Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

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

Name: SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL
Rating: 4.6 (1146 reviews)

SQL skills are in demand. Learn to master SQL using MySQL. Become a SQL Guru today!

Created byJohn Thompson • 500,000+ Enrollments Worldwide, Spring Ahead Code Academy

Last updated 8/2026

English

What you'll learn

Become a SQL Guru! Be that 'go-to' person!
Master SQL to create reports from realistic MySQL databases
See how to aggregate and analyze data using SQL functions
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

Course content

16 sections • 168 lectures • 11h 25m total length

Getting the Most out of Your SQL Course4:04
Learn how you can get the most out of your SQL Beginner to Guru course!
Slack Group for SQL Beginner to Guru MySQL Edition0:51
Learn about the exclusive Slack community for the course where you can interact with other students learning SQL!
GitHub Workflow12:20
SQL - Let's write our first SQL!7:46
In this lecture you get to write your first SQL. See how you can create a database table using SQL, then add data to the table & get information back!
SQL Fiddle Assignment Review3:17
In this lecture you see a step by step review of the SQL assignment from the previous lecture.

Introduction to SQL1:03
Introduction lecture to the section of the course to introduce students to the SQL language.
What is a Database?8:35
SQL is the language we use to work with data stored in a relational database. In this lecture, we look at what a database is and establish common terminology.
Relational Database Principles13:08
Explore relational database principles by examining tables, relations, and keys, including primary keys, surrogate keys, and foreign key constraints; understand one-to-one, one-to-many, and many-to-many relationships with ERDs.
Assignment: Create Tables and Insert Data2:33
Assignment Review: Create Tables and Insert Data3:27
History of SQL13:31
What is a Relational Database Management System?11:19
History of MySQL10:41
RDBMS Deployment Architectures9:25
Flashcards4:52
Conclusion0:35

Introduction2:51
Importing the MySQL Employee Database6:44
Assignment use SQL to get Row Counts0:47
Quiz - SQL Row Counts
Assignment Review - Use SQL to get Row Counts2:22
Review of the SQL Select Statement5:13
Selecting Specific Columns from Tables1:56
Using Aliases to Name Columns2:54
Using the SQL CONCAT Function to Join Columns2:26
SQL Arithmetic Operators2:26
Using SQL Arithmetic Operators in Selecting Data7:14
SQL Data Types16:24
Explore MySQL data types across numeric, date and time, string, spatial, and JSON categories, with ANSI SQL standard and practical notes on storage, precision, and when to use each type.
Formatting Date Values with MySQL6:45
Using the LEFT and RIGHT MySQL Functions4:02
SQL Select Clause Quiz
Introduction to the SQL WHERE Clause8:44
SQL WHERE Clause with Equals and Not Equals3:19
Using AND and OR with SQL WHERE Clause3:52
Using IN and NOT IN with with SQL WHERE Clause5:03
Dealing with NULL Values in SQL WHERE Clause3:27
Using Greater Than and Less Than with SQL WHERE Clause4:00
Using LIKE and NOT LIKE with SQL WHERE Clause3:49
Master using like and not like in SQL where clauses, with wildcards % and _, to filter employee names by patterns such as starting with e or ending with n.
Using BETWEEN and NOT BETWEEN with SQL WHERE Clause4:30
Ordering Results with SQL ORDER BY4:30
Limit Results with SQL LIMIT Clause6:19
Using SQL to Select DISTINCT Values2:12
Using SQL Sub-selects with IN in SQL Where Clause3:12
Assignment - Fix SQL Statements2:05
Take the assignment to fix intentionally broken SQL statements in the downloadable course file and master common MySQL syntax errors through hands-on practice.
Assignment Review8:44
Conclusion2:18
Conclude by emphasizing how the where clause powers selecting data from a single table and lays the foundation for updates, deletes, joins, and future grouping with summary functions.

Introduction1:00
Using the SQL GROUP By clause2:49
MySQL Aggregate Functions2:03
Explore MySQL aggregate functions, including count, avg, sum, max, and min, which compute a single value from a set of values while ignoring nulls; learn through examples and reports.
Using the SQL HAVING Clause4:17
Using the SQL SUM Function2:00
Using the SQL Min and Max Functions5:50
Using the SQL AVG Function3:55
Assignment - Write SQL Report for Salary Information by Year Excluding Managers1:58
Salary Report Quiz
Assignment Review4:12
Conclusion0:34
Explore grouping functions in SQL and pull data from the employee database through a quiz. Preview how to select data from multiple tables in upcoming lessons.

Introduction1:15
Overview of SQL Table Joins5:13
Introduction to SQL Inner Joins3:34
Using Table Aliases with SQL Inner Joins3:38
Limiting Columns Displayed with SQL Inner Joins3:02
Using a WHERE Clause with SQL Inner Joins4:33
Assignment - Create Department Employee Report1:44
Assignment Review - Create Department Employee Report6:52
Using SQL Natural Joins3:10
Using SQL Equi-Joins4:48
Using SQL Union Joins5:04
Other MySQL Functions8:55
Using SQL LEFT OUTER JOINS5:09
Assignment - Write SQL LEFT OUTER JOIN1:32
Assignment Review - Write SQL LEFT OUTER JOIN6:13
Conclusion1:31

Introduction0:44
Overview of the SQL Insert Statement2:44
Example SQL Insert Statement2:38
Specifying Columns in SQL Inserts4:05
Specify the columns you want to insert into to handle optional fields and ensure the values count matches the selected columns, speeding up inserts on large tables.
Assignment - Use SQL to create a record in DEPARTMENTS table0:45
Assignment Review - Use SQL to create a record in DEPARTMENTS table5:07
Using a SQL Sub-select with SQL Insert Statements4:02
SQL Core Concept - Foreign Key Constraints4:24
Assignment - Use SQL Inserts to create a new Employee0:51
Perform sql inserts to create a new employee across the employee and salary tables, assign a title, department, and salary record, with step-by-step guidance in the next video.
Assignment Review - Use SQL Inserts to create a new Employee6:23
Conclusion0:59

Introduction1:23
Overview of the SQL Update Statement3:55
Example SQL Update Statement3:07
Assignment - Use SQL Update Statement to Change Employee Name0:48
Assignment Review - Use SQL Update Statement to Change Employee Name2:22
Assignment - Using SQL Update and Insert to Create a New Salary Record1:40
Assignment Review - Using SQL Update and Insert to Create a New Salary Record3:35
Using SQL to drop the employee database2:49
Assignment - Re-import the employee database0:43
Assignment - Review re-import employee database3:26
Review how to re-import the employees database via mysql workbench, run the employees.sql script from GitHub, and refresh schemas to recover a fresh database for practicing inserts, updates, and deletes.
Conclusion0:40

Introduction1:00
Overview of the SQL DELETE statement2:33
Master the MySQL delete statement, using delete from table with an appropriate where clause, and optionally order by and limit, while avoiding full-table deletes and testing carefully.
Example of the SQL DELETE Statement9:42
Assignment - Create, Update, and Delete an Employee record1:20
Assignment Review - Create, Update, and Delete an Employee Record4:05
Master a CRUD workflow on the employees table by executing create, read, update, and delete operations in MySQL, including generating the next employee number with a max-based insert.
Conclusion0:36

Requirements

Just a computer - Any modern PC, Mac or Linux system will work!
Fundamental computer skills are helpful (you understand what files and directories are)

Description

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 searching for people with SQL skills. Go to any popular jobs site, and search for the keyword 'SQL'. You will see 10's of THOUSANDS of job postings.

Right now these positions are going unfilled - because companies cannot find enough people with SQL skills.

In this course, you will learn how to use SQL using the MySQL relational database - the most popular database in the world.

No previous SQL experience is needed. This course is perfect for beginners.

In this course, you will:

Learn how to install MySQL on your computer.
Learn how to install MySQL Workbench on your computer.
See how to import the famous MySQL employee database into your MySQL database.
Get hands on experience generating SQL reports.
Master SQL join statements.
Create table joins using database tables with MILLIONS of records!
See how easy it is to use SQL to update one record or many records in the database.
Learn to use SQL Sub-Selects.
Write advanced SQL reports against a ecommerce database.
Understand what database transactions are, and the tools you have to control them with MySQL.
Use SQL to create tables in your MySQL database.
Learn the MySQL syntax to alter existing database tables.
Tackle challenging real world like assignments for SQL reporting and database maintenance tasks.
Leverage using SQL views for common reports.

Course Extras

Slack Community - Join the instructor, teacher's assistants, and other students in a Slack Community exclusive to this course!
All Source Code in GitHub - Get access to all source code used in course via GitHub (no experience with GitHub necessary)
All Lecture Slides Downloadable as PDFs - Download lecture slides for study and future reference!

Other Databases?

This course is focused on using SQL with the MySQL database.

SQL is a standard, which which is supported by many other databases. The SQL skills you learn in this course can be applied to other databases such as Postgres, Oracle, and MS SQL Server.

There is a ton of demand for people with SQL skills. In the US, there are over 100,000 job openings for people with SQL skills.

Through this course, you will master SQL.

Open the door to new opportunities and enroll today!

Who this course is for:

Anyone wishing to learn how to use SQL!

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

What you'll learn

Explore related topics

Course content

SQL Beginner to Guru MySQL Edition Introduction5 lectures • 28min

Introduction to SQL11 lectures • 1hr 19min

Installation of MySQL9 lectures • 28min

Connecting to MySQL9 lectures • 31min

Selecting Data from a Single Table28 lectures • 2hr 8min

Grouping and Summarizing Data with SQL10 lectures • 29min

Using SQL to Select Data from More Than One Table16 lectures • 1hr 6min

Using SQL to Insert Data11 lectures • 33min

Using SQL to Update Data11 lectures • 24min

Using SQL to Delete Data6 lectures • 19min

Requirements

Description

Who this course is for: