SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL

Preview this course

Develop your SQL skills, with useful insights into the MySQL syntax, SQL join statements, and more!

Unlimited access to 750+ courses.
Enjoy a Free Trial. Cancel Anytime.

- OR -

30-Day Money-Back Guarantee
Full Lifetime Access.
164 on-demand videos & exercises
Level: Intermediate
English
10hrs 52mins
Access on mobile, web and TV

What to know about this course

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---Master-SQL-with-MySQL

Who's this course for?

This course is designed for anyone who wants to learn how to use SQL.

What you'll learn

  • 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.

Key Features

  • Learn to aggregate and analyze data using SQL functions.
  • Get up to speed with SQL using MySQL.

Course Curriculum

About the Author

John Thompson

John Thompson has been in the IT industry for over 20 years. Today, he specializes mainly in Java, the most successful and widely known programming language in use today. He also specializes in the Spring Framework, which the most popular open-source application framework for building enterprise-class applications on the Java platform. Just some of the organizations he worked with include Visa, Kohls, Federal Home Loan Bank, and Belk Department Stores. Through the courses he is providing, he hopes to leverage his years of experience to accelerate your learning of the Spring Framework. The Spring Framework is a big framework. The environment for enterprise Java is even bigger. If you're new to Java, you have a lot to learn.