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

Complete SQL & MySQL Course 2026: From Beginner to Advanced

Name: Complete SQL & MySQL Course 2026: From Beginner to Advanced
Rating: 4.6 (2419 reviews)

Master SQL & MySQL with Hands-On Queries, Joins, Subqueries & Real-World Examples

Created byAshutosh Pawar

Last updated 2/2026

English

What you'll learn

Understand what are database and why they are used.
How to write SQL queries to insert, update and delete data into database.
How to write SQL queries to manipulate data.
How to write complex SQL queries to obtain useful information from the database.
Learn how to create database tables using SQL commands.
Learn SQL operators to write complex SQL queries.
Learn how to perform different types of join operations.
Learn about different SQL functions and constrains.

Course content

24 sections • 332 lectures • 14h 26m total length

Course Introduction7:29
Unlock the power of databases with this comprehensive MySQL course. Whether you're a complete beginner or have some experience with databases, this course will equip you with practical knowledge of MySQL — one of the most widely used database management systems in the world.
In this course, you'll start from the very basics, learning about databases and SQL (Structured Query Language). As you progress, you'll master creating and managing database tables, writing complex queries, and applying advanced MySQL functions.
Here's a detailed overview of what you'll learn:
Introduction to SQL
Understand what databases are and the role of SQL in managing them.
Get a high-level overview of how data is stored and managed in databases.
Installing Required Tools
Install MySQL and MySQL Workbench to start working with databases.
Set up your development environment to write and execute SQL queries.
Creating Database Tables, Data Types & SELECT Clause
Learn how to create databases and tables using MySQL.
Understand different data types and their use in storing various types of data.
Use the SELECT clause to retrieve data from tables.
Constraints in MySQL
Learn how to enforce rules and restrictions on data using constraints.
Understand constraints like PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, and more.
Comparison Operators in MySQL
Use comparison operators like =, !=, <, >, BETWEEN, LIKE, IS NULL, IS NOT NULL, etc., to filter data.
Logical Operators
Learn to combine multiple conditions using logical operators like AND, OR, and NOT.
String Functions in MySQL
Perform string manipulations using MySQL's built-in string functions.
Learn functions like CONCAT, LENGTH, SUBSTRING, TRIM, REPLACE, LOCATE, and more.
Arithmetic Operations
Learn how to perform arithmetic calculations directly within your SQL queries.
Use operators like +, -, *, /, and %.
Modifying Database Tables
Modify existing database tables by adding, removing, or altering columns.
Learn to change data types, rename tables, and manage constraints.
CRUD Operations (Create, Read, Update, Delete)
Master the four core operations of database management:
CREATE: Add new records.
READ: Retrieve data.
UPDATE: Modify existing records.
DELETE: Remove records.
Aggregate Functions
Learn to apply functions like COUNT, SUM, AVG, MIN, MAX, and GROUP BY to process and summarize data.
Date & Time Data Types
Work with date and time data using MySQL’s built-in functions.
Learn to manipulate and format date and time data.
Foreign Keys in MySQL
Understand the concept of foreign keys and how they establish relationships between tables.
Learn how to create and manage foreign keys.
Database Relationships
Understand different types of relationships in databases: One-to-One, One-to-Many, and Many-to-Many.
Learn how to structure relational databases.
Joins in MySQL
Combine data from multiple tables using joins.
Learn different types of joins, including INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Views in MySQL
Learn how to create and manage views to simplify complex queries.
Understand the benefits of using views in database management.
Database Theory for Interviews
Gain theoretical knowledge of databases to prepare for technical interviews.
Learn about relational vs non-relational databases, DDL, DML, normalization, and more.
Window Functions in MySQL
Explore powerful window functions introduced in MySQL 8.
Learn how to perform calculations across a set of table rows related to the current row.
Stored Routines (Stored Procedures & Functions)
Learn how to create reusable stored procedures and functions in MySQL.
Understand how stored routines can simplify complex operations.
Triggers in MySQL
Automate database operations using triggers.
Learn to create triggers for insert, update, and delete events.
By the end of this course, you will have a deep understanding of MySQL, enabling you to build and manage databases efficiently. Whether you want to become a database administrator, backend developer, or data analyst, this course will provide you with the practical skills to excel.

Introduction To Databases6:01
In this lecture, you will get a clear understanding of what a database is and how it works in the context of modern web applications. When you use any social media platform, e-commerce website, or any online service, all the user information, product data, and other records are stored in something called a database.
A database is essentially an organized collection of data that is stored electronically. For example, when you create a profile on a social media platform and enter your personal information, that data is saved in a database. Similarly, when you browse products on an e-commerce site, product information is also stored in a database.
In any application, there are two main components:
Front-end (UI) – This is the part of the application that users interact with.
Back-end (Server) – This is where all the data is processed and stored, and it includes a database to manage and store data.
But how exactly is the data stored in a database?
Data is stored in tables, which organize information in rows and columns.
For example, on a social media site, user information such as name, email, and profile picture is stored in a users table.
Similarly, if it's an e-commerce site, product information would be stored in a products table.
A single database can contain multiple tables serving different purposes.
The next important question is: How do we create these databases and tables?
Do we need a special tool or software to create and manage databases?
This is exactly where MySQL comes into the picture.
In the upcoming lectures, you will learn how to install MySQL, use MySQL Workbench, and create databases and tables to store and manage data. This knowledge will allow you to build and manage powerful database systems for real-world applications.
By the end of this section, you will have a solid understanding of what a database is, how data is structured, and how MySQL can be used to build and manage databases efficiently.
Introduction To DBMS2:10
Database Management Systems in MySQL: Creating and Managing Databases
In the previous lecture, we learned what a database is and how data is stored in a database in the form of tables. Now, the next step is to learn how to create and manage those databases. This is where a Database Management System (DBMS) comes into play.
A Database Management System (DBMS) is a special kind of software that allows you to:
Create databases.
Create tables inside those databases.
Add data to the database tables.
Query and retrieve data from those tables.
Some of the most commonly used Database Management Systems (DBMS) are:
MySQL
PostgreSQL
Oracle Database
Microsoft SQL Server
For the purpose of this course, we will focus on MySQL DBMS, which is one of the most popular and widely used database management systems in the world. MySQL is powerful, open-source, and highly efficient for managing large-scale databases.
By using MySQL, you will be able to create databases, store data, query data, and manage your entire database infrastructure efficiently. This is an essential skill for building dynamic web applications, e-commerce platforms, content management systems, and much more.
In the next lecture, we will begin by installing MySQL DBMS and MySQL Workbench, a tool that allows you to easily interact with MySQL databases using a graphical interface.
By the end of this section, you will have a clear understanding of how MySQL works and how to use it to create and manage databases efficiently.
Introduction To SQL2:19
ntroduction to SQL in MySQL: Communicating with Databases
After installing a Database Management System (DBMS) like MySQL, the next step is to learn how to create databases, add data, and retrieve data from the database. But how exactly do we interact with a database?
The answer is SQL (Structured Query Language).
SQL is a programming language specifically designed to communicate with databases. It allows you to:
Create databases and tables.
Insert data into the database.
Retrieve data from the database.
Modify and delete data from the database.
SQL is widely used across various database management systems like MySQL, PostgreSQL, SQLite, Microsoft SQL Server, and Oracle. It acts as a bridge between you and the database, allowing you to perform all sorts of operations on your data.
In this lecture, we will get a brief introduction to SQL and understand why it is essential for working with databases in MySQL. In the upcoming lectures, we will use SQL commands to create databases, add data, retrieve data, and perform various data manipulations.
By the end of this section, you will have a solid understanding of how SQL works and how you can use it to manage your data in MySQL effectively.
Introduction To Database

Installing MySQL On Windows7:37
Install MySQL on Windows by downloading the official installer, choosing MySQL server 8 with workbench and shell, then configure root password and path.
Installing MySQL On Mac8:20
Install and run MySQL on a Mac by downloading the official MySQL package, configuring your path, and launching the server via the terminal with root access.
Installing MySQL Workbench On Mac2:41

Creating A Database7:13
Creating A Table8:49
Data Types In MySQL2:56
Numeric Data Types7:03
Character Data Types5:01
Explore string data types in SQL, including char and varchar, with text variants (tiny text, medium text, long text) and binary types; understand why length uncertainty favors varchar.
Date & Time Data Types3:00
Explore SQL date and time data types, including date, date time, timestamp with time zones, and time, and learn how timestamp tracks time zones and updates when records change.
Inserting Data Into Database7:51
Select Clause2:14
Learn how the select clause in MySQL retrieves specific columns or all columns from a table, with examples using name, location, and the people table.
Select Distinct Clause3:54
Learn to use the select distinct clause to retrieve unique values from a column, such as locations, by querying the people table and eliminating duplicates.
Where Clause4:59
Learn to use the where clause in SQL to filter data by conditions on columns like name, location, and age, returning only matching rows.
Coding Challenge: Creating A Database0:06
Solution To Coding Challenge: Creating A Database0:05
Coding Challenge: Create A Database Table0:09
Solution To Coding Challenge: Create A Database Table0:05
Coding Challenge: Inserting Data Into Database Table0:10
Solution To: Coding Challenge: Inserting Data Into Database Table0:11
Coding Challenge: Read Data From Database Table0:04
Solution To Coding Challenge: Read Data From Database Table0:06
MySQL Basics

Introduction To Constraints In MySQL3:05
Not Null Constraint9:08
Unique Constraint6:04
Learn how the unique constraint enforces distinct values in a MySQL column, using a customers table example with emails to prevent duplicates.
Introduction To Primary Key Constraint7:27
Primary Key Constraint Example5:07
Default Constraint5:09
Auto Increment Constraint5:30
Create Table With Not Null Constraint0:16
Solution To Coding Challenge: Create Table With Not Null Constraint0:06
Coding Challenge: Create Table With Unique Constraint0:20
Solution To Coding Challenge: Create Table With Unique Constraint0:07
Coding Challenge: Create A Table With Primary Key Constraint0:13
Solution To Coding Challenge: Create A Table With Primary Key Constraint0:08
Coding Challenge: Create A Table With Default Constraint0:11
Solution To Coding Challenge: Create A Table With Default Constraint0:07
Coding Challenge: Create A Table With Auto Increment Constraint0:07
Solution To Coding Challenge: Create A Table With Auto Increment Constraint0:07
Constraints

Introduction To Comparison Operators2:23
Explore how MySQL comparison operators filter data by evaluating boolean results, including equal to, not equal to, less than, greater than, between, like, is null, and is not null.
Using MySQL Workbench On Windows4:09
Using MySQL Workbench On Mac3:15
Learn to use MySQL Workbench on Mac to write SQL queries, connect to a database, select social db, click the lightning icon to execute queries, and show tables.
Equal To Operator4:53
Not Equal To Operator3:42
Learn how to use the not equal to operator in MySQL to filter rows, location not equal to 'us' or age not equal to 25, using < > or !=.
Less Than Operator3:20
Explore how the less than operator in MySQL filters rows, such as selecting people with age less than 30, and apply it to strings and dates.
Greater Than Operator2:04
Master the MySQL greater than operator by filtering ages over 30, comparing names by first letter, and previewing date value comparisons in the next lesson.
Comparison Operators With Date6:26
Create a simple sales table with id, amount, and date, insert values, and use MySQL date comparison operators to filter results by date.
Less Than Or Equal To Operator3:03
Master the less than or equal to operator in MySQL by including values that are less than or equal to a threshold, illustrated with ages and date-based sales queries.
Greater Than Or Equal To Operator3:12
Between Operator8:39
Explore how the between operator in MySQL filters values within a range, such as age and salary. See inclusive endpoints demonstrated on the people and sales tables with date ranges.
Like Operator12:16
Discover how the MySQL like operator enables pattern matching with wildcards % and _ to search names and emails for starts with and ends with patterns.
In Operator5:41
Learn how the in operator filters multiple values in a where clause, using examples with name and age, and see how it simplifies queries compared to the or operator.
Is Null & Is Not Null Operator5:29
Learn how is null and is not null identify missing values in MySQL, why null cannot be compared with equals, and how to filter rows with these operators.
Coding Challenge: Equal To0:02
Solution To Coding Challenge: Equal To0:01
Coding Challenge: Not Equal To0:03
Solution To Coding Challenge: Not Equal To0:01
Coding Challenge: Less Than0:05
Solution To Coding Challenge: Less Than0:03
Coding Challenge: Greater Than0:04
Solution To Coding Challenge: Greater Than0:03
Coding Challenge: LIKE0:03
Solution To Coding Challenge: LIKE0:01
Coding Challenge: IN0:05
Solution To Coding Challenge: IN0:02
Coding Challenge: IS NULL0:03
Solution To Coding Challenge: IS NULL0:01
Coding Challenge: IS NOT NULL0:03
Solution To Coding Challenge: IS NOT NULL0:02
Comparison Operators

Introduction To Logical Operators3:21
Explore how MySQL logical operators combine multiple conditions to form complex queries, using and, or, not, and xor, and learn their true/false evaluation in select, update, and delete statements.
AND Operator5:10
Learn how the and operator in MySQL enables combining multiple conditions in a where clause. Retrieve rows where age and location meet all criteria, with examples.
OR Operator4:26
NOT Operator2:47
Combining Logical Operators6:14
Combine the SQL operators and, or, and not in a single SQL query using parentheses to control precedence, with age greater than 30 and location in US or UK.
Combining Null Operators2:44
NOT Like Operator4:00
AND Operator0:07
AND Operator0:04
Coding Challenge: OR Operator0:04
Solution To Coding Challenge: OR Operator0:02
Coding Challenge: NOT Operator0:02
Solution To Coding Challenge: NOT Operator0:01
Coding Challenge: AND, OR & NOT Operator0:03
Solution To Coding Challenge: AND, OR & NOT Operator0:02
Coding Challenge: NOT LIKE Operator0:04
Solution To Coding Challenge: NOT LIKE Operator0:04
Logical Operators

CONCAT Function7:51
CONCAT With Separator3:32
Learn how the concat_zz function adds a separator between strings in MySQL, simplifying delimited values. See examples with dash, colon, and other separators to build dates.
LENGTH Function3:11
Learn how MySQL's length function returns string length in bytes, not characters, with examples showing hello as 5 bytes and emojis ranging from 4 to 17 bytes.
CHAR LENGTH Function3:27
Learn how the character length function in MySQL returns the actual number of characters, not bytes, and use it with between to validate usernames between 5 and 15 characters.
SUBSTRING Function12:57
Learn to use MySQL's substring function to extract parts of strings, with start and length parameters, and apply it to first names and email usernames.
LEFT Function2:49
Learn how the MySQL left function extracts a set number of characters from the start of a string, as shown with examples like hello and initials from names.
RIGHT Function2:43
Learn how to use the right function in MySQL to extract characters from the end of a string, with examples on hello world, last names, and email domains.
LOWER & UPPER Functions6:20
TRIM Function2:55
Discover how the MySQL trim function removes leading and trailing spaces to clean strings, demonstrated with examples and when applying it to database columns.
REPLACE Function7:27
INSTR Function2:44
LOCATE Function5:03
LTRIM & RTRIM Functions3:48
Discover how MySQL string functions trim spaces using ltrim and rtrim. Learn to remove leading and trailing spaces from strings with practical examples.
ASCII & CHAR Functions5:05
REGEXP Function4:02
Explore how to use regular expressions in MySQL to detect patterns in strings, such as finding names that start with a specific letter using the regexp function.
REVERSE Function3:03
Learn to use the MySQL reverse function to reverse strings, sentences, and data like emails and phone numbers; apply it to decode data and practice with examples.
CONCAT0:03
Solution To Coding Challenge: CONCAT0:02
Coding Challenge: CONCAT With Seperator0:11
Solution To Coding Challenge: CONCAT With Seperator0:06
Coding Challenge: Using Length Function0:02
Solution To Coding Challenge: Using Length Function0:01
Coding Challenge: Substring0:03
Solution To Coding Challenge: Substring0:01
Coding Challenge: UPPER & LOWER0:03
Solution To Coding Challenge: UPPER & LOWER0:02
Coding Challenge: TRIM0:02
Solution To Coding Challenge: TRIM0:01
Coding Challenge: Replace0:03
Solution To Coding Challenge: Replace0:01
Coding Challenge: Reverse0:06
Solution To Coding Challenge: Reverse0:01
String Functions

Adding New Columns5:46
learn how to modify mysql tables with the alter table command to add new columns, such as username varchar(30) and salary integer, while keeping existing data intact.
Dropping Columns2:17
Changing Data Type Of Columns3:37
learn how to change a column's data type in SQL using alter table and modify column, with examples converting age from integer to character and back, while preserving data.
Renaming Columns2:28
Learn how to rename a column in a MySQL database using alter table and change, switching from location to country, and verify the result with a select query.
Renaming Tables1:51
Learn how to rename a database table using the alter table command; rename the people table to students, verify by querying the new table, and rename back if needed.
Modifying Constraints4:43
Dropping Constraints6:27
Coding Challenge: Add New Columns0:05
Solution To Coding Challenge: Add New Columns0:03
Coding Challenge: Drop Columns0:02
Solution To Coding Challenge: Drop Columns0:01
Coding Challenge: Rename Columns0:02
Solution To Coding Challenge: Rename Columns0:03
Coding Challenge: Rename Tables0:01
Solution To Coding Challenge: Rename Tables0:01
Coding Challenge: Modify Constraints0:03
Solution To Coding Challenge: Modify Constraints0:02
Coding Challenge: Drop Constraints0:02
Solution To Coding Challenge: Drop Constraints0:01
Altering Tables

Requirements

No coding, or technical knowledge required.
A computer with internet connection.
No paid tools are required as the tools required for this course are free.
Passion and curiosity to learn someting new.

Description

Complete SQL & MySQL Course 2026: From Beginner to Advanced

Want to master SQL and MySQL from scratch and confidently work with real-world databases?

This complete SQL course will take you from absolute beginner to advanced level — covering everything from basic queries to window functions, CTEs, stored procedures and triggers.

By the end of this course, you will be able to:
Create and design databases from scratch
Write powerful SQL queries with joins, subqueries & aggregations
Work with real-world relational database structures
Use window functions & CTEs (MySQL 8+)
Build stored procedures and triggers
Understand database concepts required for interviews

What Makes This Course Different?

• Step-by-step structured learning path

• Clear, word-by-word explanation of every SQL query

• 15+ hours of HD video content

• Practice exercises after every major section

• Interview-focused database theory section

• Direct instructor support

This is not just theory — you will write SQL queries throughout the course and build real confidence working with databases.

What You Will Learn

This course is divided into 23 comprehensive sections covering:

• Database fundamentals & SQL basics

• Creating databases and tables

• Constraints and relationships

• CRUD operations

• String, arithmetic & aggregate functions

• Date & time operations

• Joins (Inner, Left, Right, etc.)

• Views

• CASE statements

• Window functions

• Common Table Expressions (CTEs)

• Stored Procedures & Stored Functions

• Triggers

• Interview-focused database theory

Who This Course Is For

• Beginners with no prior SQL knowledge

• Students preparing for database interviews

• Developers wanting strong SQL fundamentals

• Anyone looking to work with MySQL professionally

Why Learn SQL?

SQL is one of the most in-demand skills in software development, data analysis and backend engineering.

Strong SQL skills make you:

• A better backend developer

• A stronger full stack developer

• More valuable in interviews

• More confident working with production databases

About The Instructor

Ashutosh Pawar is an experienced programming instructor with hundreds of thousands of students worldwide and extensive experience teaching Python, Django and full-stack development.

Join now and take your first step towards becoming confident with SQL & MySQL.

Who this course is for:

Beginners who want to learn SQL.
Database developers and database administrators.
Mobile application developers.
Web developers.
Students who wish to learn a new skill to develop their career.

Complete SQL & MySQL Course 2026: From Beginner to Advanced

What you'll learn

Explore related topics

Course content

Introduction To The Course1 lecture • 7min

Introduction to SQL & MySQL Databases3 lectures • 11min

Installing MySQL & Required Tools3 lectures • 19min

MySQL Basics: Creating Database, Tables, Data Types18 lectures • 54min

Constraints17 lectures • 43min

Comparison Operators30 lectures • 1hr 9min

Logical Operators17 lectures • 29min

String Functions32 lectures • 1hr 18min

Arithmetic Operations4 lectures • 12min

Modifying Database Tables In MySQL19 lectures • 28min

Requirements

Description

Who this course is for: