We will teach you in practice to interact with the database from scratch through the use of the MySQL DBMS
The course does not require the purchase of additional licenses – all software used in the course is free. The course covers the fundamentals of the SQL language for relational databases. The world is full of information, and the ability to store and interact with it in a structured way is an extremely important skill.
What you’ll learn
- Work with MySQL Workbench and Command Line.
- Use MySQL DBMS statements.
- Avoid Common Database Design Mistakes.
- Use SQL to analyze data.
- Prepare for the interview.
Course Content
- Introduction. SQL language overview –> 3 lectures • 7min.
- MySQL Installation Guide –> 1 lecture • 5min.
- Data Types and Keywords –> 2 lectures • 6min.
- Owerview Command Line and Workbench –> 2 lectures • 16min.
- Primary and Foreign Key. Relationships between tables. –> 2 lectures • 14min.
- Attributes and Comments –> 2 lectures • 5min.
- Queries with SELECT statement –> 10 lectures • 1hr 7min.
- Join Tables: How-To with Example –> 1 lecture • 11min.
- MySQL Variables –> 1 lecture • 3min.
Requirements
- Computer proficiency at the user level.
- Enthusiasm and desire to develop rapidly.
The course does not require the purchase of additional licenses – all software used in the course is free. The course covers the fundamentals of the SQL language for relational databases. The world is full of information, and the ability to store and interact with it in a structured way is an extremely important skill.
The training program is designed in the most convenient way for the assimilation of the material presented. Consistently with each lesson, the complexity and volume of the covered material will increase. But this will not become an obstacle for you on the way to achieving your goals, right?
The target audience is aspiring software developers, testers, data analysts and administrators.
The course is aimed at the practical use of the full range of tools provided. You can consolidate the information provided by completing homework and test questions. The basis for confident progress will be laid by a theory tested by several sources.
The motivation for creating the course was the desire to combine the most important aspects necessary for understanding in one place, which will significantly save you a lot of time, and therefore money.
Together we will analyze the most common interview questions and prepare for answers to the most tricky of them.
The bonus will be the connection of the database we created to the project in Inteliji Idea by using Java Database Connectivity. You will be proud to note the knowledge of MySQL and JDBC DBMS in your resume.
Start improving your skills right now. Welcome to the MySQL for Dummies course!