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/MySQL BootCamp : 100 Challenges to Build Your Skills

Learn SQL from scratch with hands-on coding practice and clear explanations

Created byRémi Monsel

Last updated 9/2025

English

What you'll learn

SQL/MySQL
Create and manage SQL tables with different data types and constraints
Insert, update, and delete records safely in a relational database
Retrieve data using SELECT queries with filters, sorting, and conditions
Apply SQL functions to manipulate text, numbers, and dates
Summarize data with aggregate functions like COUNT, SUM, AVG, MIN, MAX
Group results using GROUP BY and filter aggregated data with HAVING
Combine data from multiple tables using INNER JOIN, LEFT JOIN, and other joins
Write subqueries to build more complex queries inside SELECT, WHERE, and FROM
Use Common Table Expressions (CTEs) and window functions for advanced analysis
Modify database structures with ALTER TABLE and manage keys and constraints
Understand relational database design, normalization, and relationships
Solve real-world SQL problems and build confidence through hands-on practice

Coding Exercises

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

Course content

12 sections • 94 lectures • 2h 11m total length

Who I am1:27
What you will learn22:02
MySQL Installation (if you want to have it, not necessary for this course)8:55

Creating Tables1:24
Creating Your First Table
Understanding Column Data Types2:09
Using Common Data Types
Inserting a Single Row into a Table1:07
Inserting a Single Row
Inserting Multiple Rows into a Table0:56
Inserting Multiple Rows
Selecting Data from a Table0:45
Selecting Data from a Table
Updating Existing Data0:53
Updating Existing Data
Deleting Rows from a Table1:06
Deleting Rows from a Table
Dropping and Re-creating a Table1:10
Dropping and Re-creating a Table
Inserting and Selecting in a table
Common Table Design Mistakes2:04
Common Table Design Mistakes

Filtering Results with WHERE1:01
Filtering with WHERE
Combining Conditions with AND and OR0:54
Using AND and OR Conditions
Using BETWEEN for Range Filters0:53
Filtering with BETWEEN
Using IN and NOT IN0:51
Using IN and NOT IN
Using LIKE for Pattern Matching0:45
Filtering with LIKE
Handling NULLs in WHERE0:46
Handling NULLs in WHERE
Sorting Results with ORDER BY0:54
Sorting Results with ORDER BY
Sorting on Multiple Columns1:23
Sorting on Multiple Columns
Limiting Results with LIMIT and OFFSET0:59
Using LIMIT and OFFSET
Combining Filters and Sorting1:18
Combining Filters and Sorts

String Functions: UPPER, LOWER, LENGTH0:57
Using String Functions (UPPER, LOWER, LENGTH)
String Concatenation1:01
Trimming and Substring Functions0:58
Numeric Functions: ABS, ROUND, CEIL1:08
Analyzing Temperature Readings with Numeric Functions
Date Functions1:05
Date Functions – CURRENT_DATE, EXTRACT
Arithmetic in SELECT Statements0:52
Arithmetic in SELECT — Product Pricing Calculations
Conditional Logic with CASE
Handling NULLs with COALESCE0:50
Handling NULLs with COALESCE
Nesting Functions in SQL0:48
Nesting Functions
Type Conversion with CAST1:28
Converting Between Data Types

COUNT(*) – Counting Rows0:51
Counting Rows
MIN and MAX Functions0:47
Finding Maximum and Minimum
SUM() – Adding Up Values0:43
Summing Column Values
AVG() – Calculating the Average0:45
Calculating Averages
GROUP BY – Aggregating Data by Category0:50
Grouping with GROUP BY
GROUP BY Multiple Columns0:59
GROUP BY Multiple Columns
HAVING – Filtering Groups After Aggregation0:47
Filtering Groups with HAVING
WHERE + GROUP BY – Filtering Before Grouping0:57
Combining WHERE and GROUP BY
COUNT(DISTINCT ...) – Counting Unique Values0:46
Using COUNT(DISTINCT …)
Aggregation with Expressions0:52
Aggregation with Expressions

What is a JOIN?0:32
Introduction to JOINs
INNER JOIN – Matching Rows from Two Tables0:54
INNER JOIN with Two Tables
LEFT JOIN – Keeping All Rows from the Left Table0:55
LEFT JOIN
RIGHT JOIN – Keeping All Rows from the Right Table0:58
RIGHT JOIN
FULL OUTER JOIN – All Rows from Both Tables0:52
FULL OUTER JOIN
JOIN on Multiple Conditions0:44
Joining on Multiple Conditions
Table Aliases in JOINs0:45
Table Aliases in JOINs
Filtering JOINed Results with WHERE0:56
Filtering JOINed Result
Joining Three Tables0:45
Joining Three Tables
SELF JOIN0:38
Self JOIN

Subquery in the SELECT Clause1:33
Subquery in SELECT Clause
Subquery in WHERE Clause1:10
Subquery in WHERE Clause
Subquery in the FROM Clause1:08
Subquery in FROM Clause
Subquery with IN1:06
Subquery with IN
Subquery with EXISTS1:20
Subquery with EXISTS
Correlated Subqueries1:13
Correlated Subqueries
Subquery in HAVING Clause1:06
Subquery with Aggregates
Subquery with Aggregate in SELECT1:08
Filtering Based on Subquery Results
Combining JOINs and Subqueries0:48
Combining JOINs and Subqueries
Multiple Nested Levels1:11
Multiple Nested Levels

Alter Table - Add Column1:09
Adding columns to a table
Alter Table – Drop Column0:47
Dropping Columns from a Table
Alter Table - Rename Column0:56
Renaming Columns
Alter Table - Change Column Data Type1:00
Changing Data Types
NOT NULL Constraint1:04
Adding NOT NULL Constraints
UNIQUE Constraint1:13
Adding UNIQUE Constraints
PRIMARY KEY1:05
Creating PRIMARY KEYS
FOREIGN KEYS1:02
Adding FOREIGN KEYS
Dropping and Re-adding Constraints1:09
Dropping and Re-adding Constraints
Renaming and Dropping Tables

Common Table Expressions (CTEs) – WITH Clause1:07
Intro to CTEs (WITH Clause)
Recursive CTEs0:59
Recursive CTE
ROW_NUMBER() and RANK()0:56
ROW_NUMBER() and RANK()
DENSE_RANK vs RANK0:54
DENSE_RANK vs RANK
PARTITION BY in Window Functions0:59
PARTITION BY in Window Functions
LEAD() and LAG()0:58
LEAD and LAG
NTILE() for Quartiles or Percentiles1:06
NTILE for Quartiles
FIRST_VALUE() and LAST_VALUE()1:13
FIRST_VALUE and LAST_VALUE
CTEs with Aggregates0:58
CTEs with Aggregates
Mixing JOINs and CTEs1:03
Mixing JOINs and CTE

Requirements

No prior experience is required — just your motivation to learn, practice, and master the most in-demand database skill in the world of technology and data

Description

SQL/MySQL BootCamp : 100 Challenges to Build Your Skills is a comprehensive, hands-on course designed to take you from a complete beginner to a confident SQL practitioner. Whether you’re a student, aspiring data analyst, or a professional looking to sharpen your database skills, this course offers a structured and practical path to mastering SQL through carefully crafted coding challenges.

The course is divided into 11 progressive sections, covering everything from the basics of creating tables, inserting data, and writing simple SELECT queries, to more advanced concepts like filtering, sorting, aggregation, JOINs, subqueries, window functions, and database design. You’ll also explore practical scenarios that simulate real-world business problems, giving you experience with the kind of SQL you’ll use in the workplace.

Each section includes a clear introduction to the concept, followed by a series of coding challenges that reinforce your understanding in a meaningful way. You’ll move step by step — writing queries, solving problems, and seeing immediate results — ensuring that you build confidence as you go.

By the end of this course, you will have completed 100 hands-on exercises, gained a strong grasp of SQL fundamentals, and developed the skills needed for data analysis, software development, and technical interviews. Most importantly, you’ll gain the confidence to tackle real-world SQL challenges with ease.

No prior experience is required — just your motivation to learn, practice, and master the most in-demand database skill in the world of technology and data.

Who this course is for:

This course is for beginners, students, analysts, developers, or professionals who want to build practical SQL skills through hands-on coding challenges

SQL/MySQL BootCamp : 100 Challenges to Build Your Skills

What you'll learn

Explore related topics

Coding Exercises

Course content

Introduction3 lectures • 32min

Getting Started with SQL Basics9 lectures • 12min

Filtering and Sorting Data10 lectures • 10min

SQL Functions and Expressions9 lectures • 9min

Aggregation and Grouping10 lectures • 8min

JOINing Tables10 lectures • 8min

Subqueries and Nested SELECTs10 lectures • 12min

Modifying Table Structure (DDL)9 lectures • 9min

Advanced Queries and CTEs10 lectures • 10min

Database Design & Relationships4 lectures • 4min

Requirements

Description

Who this course is for: