SQL is the programming language used to get data in and out of databases. Relational databases are extremely popular with companies of all sizes.
Employers are also constantly searching for people with SQL skills, which is ideal if you’re looking to pursue a career in this domain.
In this course, you will learn how to use SQL using the MySQL relational database - one of the most popular databases in the world. You’ll start by installing MySQL workbench on your computer. Next, you’ll understand how to import the famous MySQL employee database into your MySQL database. Gradually, you’ll get hands-on with generating SQL reports, before going on to exploring all about SQL join statements. In addition to this, you’ll create table joins using database tables with millions of records. You’ll discover how easy it is to use SQL to update one record or multiple records in the database. As you progress, you’ll delve into using SQL sub-selects and writing advanced SQL reports against an e-commerce database.
Later, you’ll focus on what database transactions are, and the tools you have to control them with MySQL. The course will then take you through using SQL to create tables in your MySQL database. You’ll also learn the MySQL syntax to alter existing database tables. Finally, you’ll tackle challenging real-world-style assignments for SQL reporting and database maintenance tasks, along with using SQL views for common reports.
By the end of this course, you will be well-versed with SQL and have the skills to use it effectively for your database management needs.
All code and supporting files for this course are available at https://github.com/PacktPublishing/SQL-Beginner-to-Guru-MySQL-Edition--…
Learn SQL to create reports from realistic MySQL databases
Create your own database through the power of SQL
Understand how to leverage database transactions
Tune SQL statements for optimum performance
Avoid common mistakes with SQL