The Ultimate MySQL Bootcamp: SQL Beginner to Expert
Master relational database design, SQL querying, complex JOINs, aggregations, indexes, and database optimization with MySQL.
0
Students
201
Lectures
Admin
Admin
About This Course
Course Overview
Master SQL and relational databases with MySQL. This bootcamp takes you through writing complex queries, designing normalized database schemas, building one-to-many and many-to-many relationships, and creating reporting dashboards with SQL aggregations.
What You Will Learn
- Create, query, update, and manage relational databases in MySQL
- Write complex SQL queries using WHERE, ORDER BY, GROUP BY, and HAVING
- Master table JOINs: INNER JOIN, LEFT JOIN, RIGHT JOIN, and self-joins
- Database normalization, primary keys, foreign keys, and constraint rules
- Indexes, query optimization, views, and stored procedures
- Connect MySQL to web applications and handle real-world transactions
Prerequisites
- No previous database or SQL experience needed
Who This Course is For
Web developers, backend engineers, data analysts, and product managers who work with data.
Admin
30
Courses
1
Students
Curriculum Overview
This course includes 20 modules, 201 lessons, and 0 hours of materials.
Introduction & 5 Minutes Of SQL
5 Parts
This Course Was Just Updated!
Free
Volume
23.44 MB
Course Intro
Volume
10.11 MB
About Me
Volume
16.48 MB
Getting The Course Code
Volume
8.16 MB
First 5 Minutes Of SQL
Volume
72.78 MB
Getting Started & Installation
6 Parts
Section Introduction
Volume
23.16 MB
What Is A Database
Volume
20.36 MB
SQL Vs. MySQL
Volume
14.07 MB
Installation START HERE!
Volume
28.9 MB
Installation Windows Instructions
Volume
61.35 MB
Installation Mac Instructions
Volume
73.47 MB
Creating Databases & Tables
12 Parts
Section Introduction
Volume
25.75 MB
Showing Databases
Volume
13.24 MB
Creating Databases
Volume
14.86 MB
Dropping And Using Databases
Volume
16.63 MB
Introducing Tables
Volume
39.33 MB
Data Types The Basics
Volume
44.19 MB
Basic Datatypes Challenge
Volume
7.06 MB
Creating Tables
Volume
12.82 MB
How Do We Know It Worked
Volume
32.07 MB
Dropping Tables
Volume
9.35 MB
Tables Basics Activity
Volume
11.61 MB
MySQL Comments
Volume
8.97 MB
Inserting Data
11 Parts
Section Introduction
Volume
19.47 MB
INSERT The Basics
Volume
9.88 MB
A Quick Preview Of SELECT
Volume
6.77 MB
Multi Inserts
Volume
16.25 MB
INSERT Exercise
Volume
58.91 MB
Working With NOT NULL
Volume
31.24 MB
Sidenote Quotes In MySQL
Volume
11.66 MB
Adding DEFAULT Values
Volume
35.05 MB
Introducing Primary Keys
Volume
17.43 MB
Working With AUTO INCREMENT
Volume
55.35 MB
Create Table Insert Exercise
Volume
71.43 MB
CRUD Basics
15 Parts
Section Introduction
Volume
33.8 MB
Introducing CRUD
Volume
3.24 MB
Getting Our New Dataset
Volume
4.21 MB
Officially Introducing SELECT
Volume
20.16 MB
The WHERE Clause
Volume
7.54 MB
Rapid Fire Exercises
Volume
4.18 MB
Rapid Fire Exercises SOLUTION
Volume
12.05 MB
Aliases
Volume
4.42 MB
Using UPDATE
Volume
15.29 MB
A Quick Rule Of Thumb
Volume
3.06 MB
UPDATE Exercise
Volume
2.09 MB
UPDATE Exercise SOLUTION
Volume
6.68 MB
Introducing DELETE
Volume
13.07 MB
DELETE Exercise
Volume
2.48 MB
DELETE Exercise SOLUTION
Volume
4.69 MB
CRUD Challenge
6 Parts
Section Introduction
Volume
39.83 MB
Introducing The CRUD Challenge
Volume
10.87 MB
CRUD Challenge Solution Creating
Volume
73.83 MB
CRUD Challenge Solution Reading
Volume
6.97 MB
CRUD Challenge Solution Updating
Volume
13.07 MB
CRUD Challenge Solution Deleting
Volume
11.99 MB
String Functions
14 Parts
Section Introduction
Volume
23.66 MB
The World Of String Functions
Volume
14.58 MB
Loading Our Books Data
Volume
23.79 MB
CONCAT
Volume
46.73 MB
SUBSTRING
Volume
51.03 MB
Combining String Functions
Volume
31.8 MB
Sidenote SQL Formatting
Volume
42.63 MB
REPLACE
Volume
37.36 MB
REVERSE
Volume
15.35 MB
CHAR LENGTH
Volume
12.74 MB
UPPER & LOWER
Volume
34.51 MB
Other String Functions
Volume
31.91 MB
String Functions Exercise
Volume
14.49 MB
String Functions Exerise SOLUTION
Volume
132.89 MB
Refining Selections
10 Parts
Section Introduction
Volume
12.77 MB
Adding Some New Books
Volume
3.91 MB
DISTINCT
Volume
20.65 MB
ORDER BY
Volume
66.7 MB
More On ORDER BY
Volume
47.96 MB
LIMIT
Volume
49.05 MB
LIKE
Volume
46.81 MB
Escaping Wildcards
Volume
8.25 MB
Refining Selections Exercise
Volume
15.33 MB
Refining Selections Exercise SOLUTION
Volume
132 MB
Aggregate Functions
12 Parts
Section Introduction
Volume
43.43 MB
Count Basics
Volume
31.38 MB
GROUP BY
Volume
76.57 MB
MIN And MAX Basics
Volume
7.91 MB
Subqueries
Volume
38.2 MB
Grouping By Multiple Columns
Volume
20.69 MB
MIN And MAX With GROUP BY
Volume
48.37 MB
SUM
Volume
22.8 MB
AVG
Volume
6.13 MB
Aggregate Functions Docs
Volume
22.31 MB
Agg Functions Exercise
Volume
6.25 MB
Agg Functions Exercise SOLUTION
Volume
58.31 MB
Revisiting Data Types
17 Parts
Section Introduction
Volume
22.37 MB
Surveying Other Data Types
Volume
27.22 MB
CHAR Vs. VARCHAR
Volume
62.14 MB
INT, TINYINT, BIGINT, Etc
Volume
43.35 MB
DECIMAL
Volume
15 MB
FLOAT & DOUBLE
Volume
19.76 MB
DATE And TIME
Volume
21.81 MB
Working With Dates
Volume
92.42 MB
CURDATE, CURTIME, & NOW
Volume
43.04 MB
Date Functions
Volume
69.52 MB
Time Functions
Volume
15.67 MB
Formatting Dates
Volume
102.98 MB
Date Math
Volume
104.24 MB
TIMESTAMPS
Volume
31.97 MB
DEFAULT & ON UPDATE TIMESTAMPS
Volume
70.35 MB
Data Types Exercise
Volume
8.01 MB
Data Types Exercise SOLUTION
Volume
74.85 MB
Comparison & Logical Operators
14 Parts
Section Introduction
Volume
31.52 MB
Not Equal
Volume
25.26 MB
NOT LIKE
Volume
9.16 MB
Greater Than
Volume
15.62 MB
Less Than Or Equal To
Volume
7.08 MB
Logical AND
Volume
46.78 MB
Logical OR
Volume
42.64 MB
Between
Volume
33.35 MB
Comparing Dates
Volume
84.25 MB
The IN Operator
Volume
68.33 MB
CASE
Volume
80.02 MB
IS NULL
Volume
11.8 MB
Exercise
Volume
14.7 MB
Exercise SOLUTION
Volume
209.47 MB
Constraints & ALTER TABLE
9 Parts
UNIQUE Constraint
Volume
10.14 MB
CHECK Constraints
Volume
20.5 MB
Named Constraints
Volume
32.43 MB
Multiple Column Constraints
Volume
38.99 MB
ALTER TABLE Adding Columns
Volume
48.21 MB
ALTER TABLE Dropping Columns
Volume
20.95 MB
ALTER TABLE Renaming
Volume
27.11 MB
ALTER TABLE Modifying Columns
Volume
15.52 MB
ALTER TABLE Constraints
Volume
39.75 MB
One To Many & Joins
14 Parts
Section Introduction
Volume
42.03 MB
Data Is Messy
Volume
37.8 MB
Relationships Basics
Volume
11.98 MB
One To Many Relationship
Volume
58.75 MB
Working With FOREIGN KEY
Volume
85.48 MB
Cross Joins
Volume
102.04 MB
Inner Joins
Volume
103.57 MB
Inner Joins With Group By
Volume
36.52 MB
Left Join
Volume
64.47 MB
Left Join With Group By
Volume
20.47 MB
Right Join
Volume
16.11 MB
On Delete Cascade
Volume
18.14 MB
Joins Exercise
Volume
9.99 MB
Joins Exercise SOLUTION
Volume
96.37 MB
Many To Many
10 Parts
Section Introduction
Volume
41.25 MB
Many To Many Basics
Volume
36.38 MB
Creating Our Many To Many Tables
Volume
60.65 MB
TV Series Challenge #1
Volume
32.35 MB
TV Series Challenge #2
Volume
19.69 MB
TV Series Challenge #3
Volume
31.91 MB
TV Series Challenge #4
Volume
35.05 MB
TV Series Challenge #5
Volume
22.71 MB
TV Series Challenge #6
Volume
127.85 MB
TV Series Challenge #7
Volume
56.77 MB
Views, Modes, & More!
8 Parts
Introducing Views
Volume
61.7 MB
Updateable Views
Volume
65.07 MB
ReplacingAltering Views
Volume
42.56 MB
HAVING Clause
Volume
53.12 MB
WITH ROLLUP
Volume
58.41 MB
SQL Modes Basics
Volume
65.54 MB
STRICT TRANS TABLES
Volume
27.79 MB
More Modes
Volume
77.67 MB
Window Functions
9 Parts
Introducing Window Functions
Volume
67.63 MB
Using OVER()
Volume
44.43 MB
PARTITION BY
Volume
59.63 MB
ORDER BY With Windows
Volume
61.44 MB
RANK()
Volume
77.26 MB
DENSE RANK & ROW NUMBER()
Volume
68.54 MB
NTILE()
Volume
34.31 MB
FIRST VALUE
Volume
38.83 MB
LEAD And LAG
Volume
77.58 MB
Instagram Database Clone
10 Parts
Section Introduction
Volume
28.93 MB
IMPORTANT NOTE ABOUT THIS SECTION!
Volume
27.64 MB
Introducing Instagram Clone
Volume
118.64 MB
Users Schema
Volume
26.52 MB
Photos Schema
Volume
39.17 MB
Comments Schema
Volume
44.5 MB
Likes Schema
Volume
127.55 MB
Followers Schema
Volume
34.51 MB
3 Approaches For Hashtags
Volume
60.04 MB
Implementing Hashtags Table
Volume
60.25 MB
Working With Lots Of IG Data
9 Parts
Section Introduction
Volume
35.95 MB
Getting Lots Of Instagram Data
Volume
208.5 MB
Instagram Challenge #1
Volume
20.48 MB
Instagram Challenge #2
Volume
67.91 MB
Instagram Challenge #3
Volume
49.79 MB
Instagram Challenge #4
Volume
48.64 MB
Instagram Challenge #5
Volume
16.15 MB
Instagram Challenge #6
Volume
31.09 MB
Instagram Challenge #7
Volume
33.68 MB
Database Triggers
6 Parts
Introduction To Database Triggers
Volume
15.81 MB
Writing Our First Trigger Part 1
Volume
34.01 MB
Writing Our First Trigger Part 2
Volume
90.22 MB
Preventing Instagram Self Follows With Triggers
Volume
33.21 MB
Creating Logger Triggers
Volume
62.94 MB
Managing Triggers And A Warning
Volume
95.94 MB
Deprecated NodeWeb App Legacy Sections Download: Section 20 Introducing Node
4 Parts
01 Section Introduction
Volume
33.83 MB
05 MySQL And Other Languages
Volume
29.11 MB
06 BUT WHAT ABOUT PHP
Volume
59.88 MB
07 Introduction To JOIN US App
Volume
49.66 MB
0
0 Reviews
Content Quality (0)
Instructor Skills (0)
Value for Money (0)
Support Quality (0)
Course Specifications
Sections
20
Lessons
201
Capacity
Unlimited
Duration
89:01 Hours
Students
0
Created Date
9 Sep 2026
Updated Date
9 Sep 2026
You are viewing
The Ultimate MySQL Bootcamp: SQL Beginner to Expert
Subscribe to Our Newsletter
Receive expert insights, course updates, and learning resources directly in your inbox and get notified
Additional Links
Login Register Contact Certificate Validation About Us Terms & Conditions Privacy Policy Refund PolicyContact US
© 2026 ZyloLearn, operated by Trelixa Technologies Private Limited. All rights reserved.
Reply to Comment