Learn SQL – Complete SQL Course from Beginner to Pro
Say goodbye to scattered tutorials and endless fluff. This course gives you a clear, structured path with bite-sized videos that blend theory and hands-on practice.
0
Students
150
Lectures
Code With Mosh
Instructor
About This Course
Made with 🩷
About the Course
SQL is one of the most valuable skills for software engineers, analysts, and data scientists—and this course is the fastest way to learn it. Whether you’re brand new or brushing up, this complete SQL course will help you learn SQL step-by-step, using practical exercises and real-world database challenges.
We’ll start with the fundamentals and build up to advanced topics like joins, subqueries, and performance optimization. You’ll write efficient SQL queries, manipulate data across multiple tables, and design well-structured relational databases.
This is a hands-on SQL course, packed with projects that help you filter, sort, aggregate, and join data with confidence. You’ll also learn the principles of database design, so your skills extend beyond writing queries—you’ll know how to create powerful, scalable databases.
Whether you’re a beginner or looking to advance your career, this course will give you the foundation and experience to succeed.
Highly Practical
What You'll Learn
- Understand the fundamentals of relational databases and SQL
- Master the SQL syntax and commonly used SQL commands
- Query and retrieve data from single and multiple database tables
- Use filtering, sorting, and aggregating techniques to manipulate data
- Create and modify database tables, views, and indexes
- Implement data integrity constraints and ensure data consistency
- Perform advanced SQL operations, such as subqueries and joins
- Write efficient and optimized SQL queries for improved performance
- Design databases effectively, including database schema and normalization principles
- Secure your databases
Curriculum Overview
This course includes 15 modules, 150 lessons, and 0 hours of materials.
Getting Started
5 Parts
Introduction
Free
Volume
3.0 MB
What is SQL
Volume
21.4 MB
Installing MySQL on Mac
Volume
171.0 MB
Installing MySQL on Windows
Volume
200.9 MB
Creating the Databases
Volume
237.9 MB
Indexing for High Performance
12 Parts
Introduction
Volume
8.9 MB
Indexes
Volume
76.0 MB
Creating Indexes
Volume
85.0 MB
Viewing Indexes
Volume
59.8 MB
Prefix Indexes
Volume
48.1 MB
Full-text Indexes
Volume
158.8 MB
Composite Indexes
Volume
104.9 MB
Order of Columns in Composite Indexes
Volume
163.9 MB
When Indexes are Ignored
Volume
97.5 MB
Using Indexes for Sorting
Volume
117.3 MB
Covering Indexese
Volume
37.2 MB
Index Maintenance
Volume
10.4 MB
Designing Databases
31 Parts
Introduction_2
Free
Volume
85.0 MB
Data Modelling
Volume
90.2 MB
Conceptual Models
Volume
93.0 MB
Logical Models
Volume
179.5 MB
Physical Models
Volume
148.6 MB
Primary Keys
Volume
91.0 MB
Foreign Keys
Volume
161.0 MB
Foreign Key Constraints
Volume
116.5 MB
Normalization
Volume
8.8 MB
1NF- First Normal Form
Volume
62.4 MB
Link Tables
Volume
117.1 MB
2NF- Second Normal Form
Volume
160.1 MB
3NF- Third Normal Form
Volume
32.1 MB
My Pragmatic Advice
Volume
114.1 MB
Don't Model the Universe
Volume
261.2 MB
Forward Engineering a Model
Volume
80.1 MB
Synchronizing a Model with a Database
Volume
133.9 MB
Reverse Engineering a Database
Volume
75.2 MB
Project- Flight Booking System
Volume
20.4 MB
Solution- Conceptual Model
Volume
181.8 MB
Solution- Logical Model
Volume
229.7 MB
Project - Video Rental Application.mp4
Volume
64.6 MB
Solution- Conceptual Model
Volume
218.6 MB
Solution- Logical Model
Volume
252.5 MB
Creating and Dropping Databases
Volume
23.8 MB
Creating Tables
Volume
94.4 MB
Altering Tables
Volume
56.8 MB
Creating Relationships
Volume
166.3 MB
Altering Primary and Foreign Key Constraints
Volume
60.5 MB
Character Sets and Collations
Volume
152.7 MB
Storage Engine
Volume
60.5 MB
Data Types
9 Parts
Introduction
Free
Volume
3.6 MB
String Types
Volume
18.7 MB
Integer Types
Volume
23.1 MB
Fixed-point and Floating-point Types
Volume
10.9 MB
Boolean Types
Volume
5.2 MB
Enum and Set Types
Volume
92.9 MB
Date and Time Types
Volume
4.5 MB
Blob Types
Volume
9.5 MB
JSON Type
Volume
187.0 MB
Transactions and Concurrency
9 Parts
Transactions
Volume
30.6 MB
Creating Transactions
Volume
107.1 MB
Concurrency and Lockign
Volume
127.3 MB
Concurrency Problems
Volume
89.3 MB
Transaction Isolation Levels
Volume
71.3 MB
READ UNCOMMITTED Isolation Level
Volume
68.4 MB
READ COMMITTED Isolation Level
Volume
78.4 MB
REPEATABLE READ Isolation Level
Volume
101.0 MB
SERIALIZABLE Isolation Level
Volume
73.4 MB
Triggers and Events
6 Parts
Triggers
Volume
145.6 MB
Viewing Triggers
Volume
21.7 MB
Dropping Triggers
Volume
11.1 MB
Using Triggers for Auditing
Volume
121.8 MB
Events
Volume
93.6 MB
Viewing, Dropping and Altering Events
Volume
19.0 MB
Stored Procedures
9 Parts
What are Stored Procedures
Volume
69.0 MB
Creating a Stored Procedure
Volume
100.9 MB
Creating Procedures Using MySQLWorkbench
Volume
30.5 MB
Dropping Stored Procedures
Volume
40.9 MB
Parameters
Volume
124.3 MB
Parameters with Default Value
Volume
157.9 MB
Parameter Validation
Volume
165.2 MB
Output Parameters
Volume
93.2 MB
Variables
Volume
99.3 MB
Views
5 Parts
Creating Views
Volume
117.1 MB
Altering or Dropping Views
Volume
75.9 MB
Updatable Views
Volume
141.7 MB
THE WITH OPTION CHECK Clause
Volume
60.0 MB
Other Benefits of Views
Volume
46.5 MB
Essential MySQL Functions
8 Parts
Numeric Functions
Volume
34.3 MB
String Functions
Volume
69.1 MB
Date Functions in MySQL
Volume
51.2 MB
Formatting Dates and Times
Volume
47.4 MB
Calculating Dates and Times
Volume
31.9 MB
The IFNULL and COALESCE Functions
Volume
59.2 MB
The IF Function
Volume
82.9 MB
The CASE Operator
Volume
105.2 MB
Writing Complex Query
10 Parts
Introduction
Free
Volume
24.0 MB
Subqueries
Volume
49.9 MB
The IN Operator
Volume
77.7 MB
Subqueries vs Joins
Volume
113.1 MB
The ALL Keyword
Volume
98.4 MB
The ANY Keyword
Volume
52.5 MB
Correlated Subqueries
Volume
152.3 MB
The EXISTS Operator
Volume
90.0 MB
Subqueries in the SELECT Clause
Volume
113.2 MB
Subqueries in the FROM Clause
Volume
82.0 MB
Summarizing Data
4 Parts
Aggregate Functions
Volume
207.6 MB
The GROUP BY Clause - Title
Volume
148.5 MB
The HAVING Clause - Title
Volume
184.5 MB
The ROLLUP Operator - Title
Volume
90.3 MB
Inserting, Updating, and Deleting Data
10 Parts
Column Attributes
Volume
78.5 MB
Inserting a Row
Volume
122.2 MB
Inserting Multiple Rows
Volume
60.1 MB
nserting Hierarchical Rows
Volume
115.1 MB
Creating a Copy of a Table
Volume
237.3 MB
Updating a Single Row
Volume
88.6 MB
Updating Multiple Rows
Volume
65.2 MB
Using Subqueries in Updates
Volume
121.0 MB
Deleting Rows
Volume
16.2 MB
Restoring the Databases
Volume
23.2 MB
Retrieving Data From Multiple Tables
13 Parts
Inner Joins
Volume
213.4 MB
Joining Across Databases
Volume
47.2 MB
Self Joins
Volume
135.7 MB
Joining Multiple Tables
Volume
138.8 MB
Compound Join Conditions
Volume
38.2 MB
Implicit Join Syntax
Volume
55.0 MB
Outer Joins
Volume
104.3 MB
Outer Join Between Multiple Tables
Volume
127.4 MB
Self Outer Joins
Volume
48.1 MB
The USING Clause
Volume
96.6 MB
Natural Joins
Volume
11.9 MB
Cross Joins
Volume
55.8 MB
Unions
Volume
155.4 MB
Retrieving Data From a Single Table
11 Parts
The SELECT Statement
Volume
139.4 MB
The SELECT Clause
Volume
177.0 MB
The WHERE Clause
Volume
119.9 MB
The AND, OR and NOT Operators
Volume
198.7 MB
The IN Operator - Title
Volume
83.9 MB
The BETWEEN Operator - Title
Volume
58.8 MB
The LIKE Operator - Title
Volume
151.4 MB
The REGEXP Operator
Volume
251.1 MB
The IS NULL Operator
Volume
69.9 MB
The ORDER BY Clause
Volume
194.9 MB
The LIMIT Clause
Volume
114.0 MB
Securing Databases
8 Parts
Introduction
Free
Volume
32.8 MB
Creating a User
Volume
46.6 MB
Viewing Users
Volume
11.6 MB
Dropping Users
Volume
7.3 MB
Changing Passwords
Volume
18.3 MB
Granting Privileges
Volume
110.4 MB
Viewing Privileges
Volume
31.9 MB
Revoking Privileges
Volume
11.9 MB
0
0 Reviews
Content Quality (0)
Instructor Skills (0)
Value for Money (0)
Support Quality (0)
Course Specifications
Sections
15
Lessons
150
Capacity
Unlimited
Duration
11:00 Hours
Students
0
Access Duration
99999 Days
Created Date
12 Nov 2025
Updated Date
12 Nov 2025
You are viewing
Learn SQL – Complete SQL Course from Beginner to Pro
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 Become Instructor About Terms and PoliciesContact US
© 2025 Rocket Soft. All Rights Reserved. Empowering Learning Worldwide.
Reply to Comment