Teach on Udemy

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

Learn More

Your cart is empty.

Keep shopping

The Comprehensive SQL Course (MySQL)

Name: The Comprehensive SQL Course (MySQL)
Rating: 4.6 (1180 reviews)

MySQL Bootcamp: Journey From Beginner to Avanced!

Created byMalvik Vaghadia, Pathfinder Analytics

Last updated 6/2026

English

What you'll learn

MySQL
Become proficient in SQL
Relational Database Design
Students will be able to apply SQL to real world problems
Boost your CV with one of the most in-demand skills in the data analysis and software development professions
Apply what you've learnt across different database management systems

Coding Exercises

This course includes our updated coding exercises so you can practice your skills as you learn.

Course content

22 sections • 142 lectures • 9h 28m total length

Course Overview2:49
Udemy Basics2:37
Explore Udemy platform basics, adjust playback speed, add notes, and manage video settings and resolution; learn about using Q&A, contacting Udemy support, and accessing downloadable resources in each lecture.
Connect with me...0:09
Relational Databases4:57
What is MySQL?2:07
What is SQL?2:13
Objects in MySQL1:16
MySQL Installation Overview1:32
MySQL Installation on Windows OS8:42
MySQL Installation on Mac OS9:14
MySQL Workbench UI Overview8:54
Adding the Countries Data4:28
Create a countries schema in MySQL with countries, regions, and subregions tables, linked by region_id and subregion_id. Run the Countries Data script in MySQL Workbench to populate the data.
Course Resources PDF + Lecture Downloads!2:17

Section Overview1:05
The SELECT Statement7:15
USE SCHEMA2:18
Statements vs Queries0:47
SELECT STAR (*)3:04
Aliasing Column Names5:47
Alias column names in sql query results using as or whitespace, with examples from the countries table to create readable aliases like country_name and capital_city, while data remains unchanged.
Aliasing Table Names (and Qualifying Columns)5:31
Alias table names and qualify columns with dot notation to avoid ambiguity. Learn the execution order and how aliasing affects queries, especially with multiple tables.
Adding Comments to SQL Code2:03
Selecting Distinct Rows3:26
Ordering Rows4:28
Limiting Rows2:20
Order of Execution (So Far)2:15
Syntax Differences Across Databases1:56

Section Overview0:55
Numeric Data Types3:37
String Data Types3:06
Date and Time Data Types0:55
Explore MySQL date and time data types, learn the standard formats for date (YYYY-MM-DD), time (HH:MM:SS), and year, and see how MySQL converts nonstandard inputs to these formats.
The Describe Statement1:59
Discover how to use the describe statement in MySQL to retrieve metadata about a table, including column names and data types, and understand schema qualification and differences across management systems.
Data Type Differences Across Databases2:08

Section Overview1:09
Explore data definition language and data manipulation language in MySQL, defining structures with create, alter, drop, truncate, and manipulating data with insert, update, and delete through hands-on practice.
Creating and Dropping Tables5:13
Creating and Dropping Schemas3:14
Inserting Rows11:31
Learn how to use insert into to add records to MySQL tables, including schema and table creation, column ordering, quotes, date formats, nulls, and data types.
Inserting Multiple Rows8:03
Create Table As (CTAS)3:19
Truncating Tables1:14
Truncate table deletes all records inside a table while preserving its structure, unlike drop table which removes the table entirely.
Alter Table8:54
Updating and Deleting Rows11:24
Constraints in SQL1:35
Not Null Constraint5:41
Unique Constraint3:55
Default Constraint3:40
Check Constraint3:17
Explore how a check constraint restricts a column to values greater than ten using the check expression, with a demo table and inserts that reject five but accept twelve.
Dropping the Not Null and Default Constraints2:49
Dropping the Unique and Check Constraints3:32
Master the MySQL syntax to drop unique and check constraints using alter table, drop constraint, and constraint names, with guidance from information_schema and show create table.

Section Overview0:28
Normalization11:48
Types of Relationships5:17
Primary and Foreign Keys6:11
Primary and Foreign Keys (Demo)10:55
Demonstrate creating and enforcing primary and foreign keys in MySQL with practical table examples, constraint syntax, and insert validations using create, alter, and drop operations.
Entity Relationship Diagrams (ERD)8:23
Tidying Up Our Schemas0:28
Syntax Differences Across Databases1:10
Compare syntax for constraints across MySQL, SQL Server, Postgres, and Oracle, including primary keys, foreign keys, unique, not null, check, and default. Subtle differences exist; consult official docs.

Section Overview0:24
Introduction to the Where Clause4:29
Comparison Operators and the Where Clause9:03
Null Values1:04
Arithmetic Operators, Expressions and Order of SQL Execution8:19
Logical Operators12:01
Explore logical operators in SQL, including and, or, between, in, and not, learn operator precedence and how to compose where clauses with salary ranges and job filters.
Pattern Matching with the LIKE Operator4:20
Recapping DDL and DML Statements6:48
Syntax Differences Across Databases0:44
Compare syntax differences across database management systems. Focus on case sensitivity and null and empty strings handling, noting MySQL is case-insensitive while PostgreSQL is case-sensitive by default.

Requirements

Absolutely no prior knowledge required

Description

This course has been completely re-done

Want to learn one of the most in-demand skills in the business and technology sector? Then this course is perfect for you!

SQL is one of the most in demand programming languages in the world. It’s the language used to communicate with Relational Databases.

In addition to the extremely popular relational databases such as MySQL, Microsoft SQL Server and Oracle Databases more and more platforms new and old are supporting SQL including Amazon Redshift, Databricks, Snowflake, Google BigQuery and the list goes on and on…

According to IEEE Spectrum - SQL is the top programming language when it comes to its “Jobs” ranking.

This course has been designed for:

Individuals with no prior experience in SQL and looking to make that step to develop their skills in this highly sought after programming language
Those with some experience looking to brush up on their SQL knowledge

We will be using MySQL which is one of the most widely used relational databases in the world. The version we’ll be using is open source and completely free.

Although we will be using MySQL the course has been designed to highlight key differences between some of the main Database Management Systems such as Oracle, Postgre and Microsoft SQL Server, so what you learn in this course can be applied across all platforms supporting SQL.

The lectures in this course are arranged in a logical flow and delivered as short, bite-sized videos. The course is designed to be comprehensive, but also concise in order to make the learning experience as easy as possible. Every major section of the course will be rounded off coding challenges and dedicated assignment sections to give you an opportunity to develop your practical skills.

Who this course is for:

Beginners looking to learn SQL
Individuals with prior SQL knowledge looking to refresh their SQL skills
Individuals looking to pursue a career in software engineering, business intelligence or data analysis

The Comprehensive SQL Course (MySQL)

What you'll learn

Explore related topics

Coding Exercises

Course content

Introduction and Set Up13 lectures • 51min

Data Query Language13 lectures • 42min

Challenge Section 10

Data Types6 lectures • 13min

Data Definition and Manipulation Language16 lectures • 1hr 19min

Relational Database Design8 lectures • 45min

HR and Customer Orders Schema2 lectures • 5min

Challenge Section 23 lectures • 14min

SQL Operators and the Where Clause9 lectures • 47min

Challenge Section 33 lectures • 13min

Requirements

Description

Who this course is for: