CF

Complete SQL Mastery

10h 47m 7s
English
Free

Complete SQL Mastery is a 155-lesson 10 hours 47 minutes self-paced course by Mosh Hamedani (Code with Mosh). Big databases are everywhere these days.

Course facts

Lessons
155
Duration
10 hours 47 minutes
Level
All levels
Language
English
Updated
Instructor
Mosh Hamedani (Code with Mosh)
Price
Free

Big databases are everywhere these days. Facebook, Netflix, Uber, Airbnb use SQL-driven databases - to name just a few. So, to be a successful developer or data scientist you need to know SQL inside-out. SQL isn’t complicated - or at least it doesn’t need to be, so long as you learn it the right way. Problem is - too many other courses out there jump around, skipping important concepts or simply teaching things badly.

That’s why this course goes further than most. You’ll get in-depth knowledge and skills that are built-up sequentially to make sure you don’t have any gaps. It takes you from whatever level you’re at to advanced skills, without delay - using real-life examples and applicable concepts to get you ready for any SQL job or project

Who teaches Complete SQL Mastery? Mosh Hamedani (Code with Mosh)

Mosh Hamedani (Code with Mosh) thumbnail

Mosh Hamedani is the founder of Code with Mosh, one of the highest-volume independent online instructors in software education. He has been publishing courses continuously since the early Udemy era and has taught over a million students across his Udemy catalog and his standalone Code with Mosh platform. His teaching style is patient, rigorously structured, and deliberately beginner-tolerant — the courses are widely cited as some of the most accessible introductions to their respective topics.

The Code with Mosh catalog covers an unusually wide span: web development with HTML / CSS / JavaScript / React / Angular / Node.js, Python and Django, C# and .NET, mobile development with React Native and Flutter, SQL and database fundamentals, and the algorithm / data-structure interview prep tracks. Few independent instructors maintain this much breadth at consistent quality.

The CourseFlix listing under this source carries over 35 Code with Mosh courses spanning that range. Material is paid; Code with Mosh runs on per-course pricing on the original platform. Courses are aimed primarily at developers picking up a new technology from a clean start through to working production proficiency.

What lessons are included in Complete SQL Mastery?

  • Space or K: play or pause
  • J: rewind 10 seconds
  • L: forward 10 seconds
  • Left Arrow: rewind 5 seconds
  • Right Arrow: forward 5 seconds
  • Up Arrow: volume up
  • Down Arrow: volume down
  • M: mute or unmute
  • F: toggle fullscreen
  • T: toggle theater mode
  • I: toggle mini player
  • 0 to 9: seek to 0 to 90 percent of the video
  • Shift plus N: next video
  • Shift plus P: previous video
0:00 0:00
#Lesson TitleDuration
1Introduction 00:19
2What is SQL 03:25
3Installing MySQL on Mac 04:59
4Installing MySQL on Windows 05:21
5Creating the Databases 08:33
6What You'll Learn 02:32
7The SELECT Statement 05:51
8The SELECT Clause 08:49
9The WHERE Clause 05:18
10The AND, OR and NOT Operators 06:53
11The IN Operator 03:04
12The BETWEEN Operator 02:13
13The LIKE Operator 05:38
14The REGEXP Operator 09:22
15The IS NULL Operator 02:27
16The ORDER BY Clause 07:07
17The LIMIT Clause 03:27
18Inner Joins 08:27
19Joining Across Databases 02:48
20Self Joins 04:14
21Joining Multiple Tables 06:47
22Compound Join Conditions 03:42
23Implicit Join Syntax 02:21
24Outer Joins 06:28
25Outer Join Between Multiple Tables 06:19
26Self Outer Joins 02:13
27The USING Clause 05:23
28Natural Joins 01:22
29Cross Joins 03:15
30Unions 08:30
31Column Attributes 03:25
32Inserting a Row 05:47
33Inserting Multiple Rows 03:19
34Inserting Hierarchical Rows 05:54
35Creating a Copy of a Table 08:48
36Updating a Single Row 03:56
37Updating Multiple Rows 03:15
38Using Subqueries in Updates 05:38
39Deleting Rows 01:25
40Restoring the Databases 01:07
41Aggregate Functions 09:20
42The GROUP BY Clause 07:22
43The HAVING Clause 08:51
44The ROLLUP Operator 05:06
45Introduction 01:29
46Subqueries 02:30
47The IN Operator 03:40
48Subqueries vs Joins 05:08
49The ALL Keyword 04:53
50The ANY Keyword 02:37
51Correlated Subqueries 05:37
52The EXISTS Operator 05:40
53Subqueries in the SELECT Clause 04:30
54Subqueries in the FROM Clause 02:59
55Numeric Functions 02:55
56String Functions 05:48
57Date Functions in MySQL 04:09
58Formatting Dates and Times 02:15
59Calculating Dates and Times 03:09
60The IFNULL and COALESCE Functions 03:30
61The IF Function 04:55
62The CASE Operator 05:24
63Creating Views 05:37
64Altering or Dropping Views 02:53
65Updatable Views 05:13
66THE WITH OPTION CHECK Clause 02:19
67Other Benefits of Views 02:38
68What are Stored Procedures 02:19
69Creating a Stored Procedure 05:35
70Creating Procedures Using MySQLWorkbench 01:22
71Dropping Stored Procedures 02:10
72Parameters 05:27
73Parameters with Default Value 08:19
74Parameter Validation 06:41
75Output Parameters 03:56
76Variables 04:34
77Functions 06:29
78Other Conventions 01:52
79Triggers 07:32
80Viewing Triggers 01:21
81Dropping Triggers 00:53
82Using Triggers for Auditing 04:53
83Events 04:34
84Viewing, Dropping and Altering Events 02:05
85Transactions 02:45
86Creating Transactions 05:12
87Concurrency and Locking 04:08
88Concurrency Problems 07:26
89Transaction Isolation Levels 05:43
90READ UNCOMMITTED Isolation Level 03:27
91READ COMMITTED Isolation Level 03:02
92REPEATABLE READ Isolation Level 03:30
93SERIALIZABLE Isolation Level 02:19
94Deadlocks 06:12
95Introduction 00:44
96String Types 02:26
97Integer Types 02:53
98Fixed-point and Floating-point Types 01:43
99Boolean Types 00:47
100Enum and Set Types 03:37
101Date and Time Types 00:45
102Blob Types 01:18
103JSON Type 10:25
104Introduction 01:26
105Data Modelling 02:27
106Conceptual Models 04:35
107Logical Models 07:25
108Physical Models 06:29
109Primary Keys 03:24
110Foreign Keys 05:49
111Foreign Key Constraints 05:23
112Normalization 01:25
1131NF- First Normal Form 02:43
114Link Tables 04:02
1152NF- Second Normal Form 06:34
1163NF- Third Normal Form 01:44
117My Pragmatic Advice 02:56
118Don't Model the Universe 04:25
119Forward Engineering a Model 02:36
120Synchronizing a Model with a Database 04:49
121Reverse Engineering a Database 03:12
122Project- Flight Booking System 00:24
123Solution- Conceptual Model 08:01
124Solution- Logical Model 09:04
125Project - Video Rental Application 01:06
126Solution- Conceptual Model 07:00
127Solution- Logical Model 08:30
128Creating and Dropping Databases 01:42
129Creating Tables 03:14
130Altering Tables 02:57
131Creating Relationships 04:48
132Altering Primary and Foreign Key Constraints 02:11
133Character Sets and Collations 06:30
134Storage Engines 02:28
135Introduction 00:42
136Indexes 02:50
137Creating Indexes 05:01
138Viewing Indexes 03:20
139Prefix Indexes 03:41
140Full-text Indexes 07:51
141Composite Indexes 05:13
142Order of Columns in Composite Indexes 09:17
143When Indexes are Ignored 05:04
144Using Indexes for Sorting 07:03
145Covering Indexese 01:59
146Index Maintenance 01:26
147Introduction 00:34
148Creating a User 03:14
149Viewing Users 01:30
150Dropping Users 00:49
151Changing Passwords 01:07
152Granting Privileges 04:54
153Viewing Privileges 01:35
154Revoking Privileges 01:21
155Wrap Up 00:45

Recommended next

What courses are similar to Complete SQL Mastery?

More courses by Mosh Hamedani (Code with Mosh)

Frequently asked questions

What are the prerequisites for enrolling in this course?
The course does not explicitly list prerequisites, but it may be beneficial to have a basic understanding of databases and general programming concepts. Familiarity with installing software on your operating system is also helpful, as the course includes installing MySQL on both Mac and Windows.
What projects or practical exercises does the course include?
Throughout the course, students will engage in practical exercises such as creating and managing databases, performing data manipulation with SQL statements like SELECT, INSERT, UPDATE, and DELETE, and using aggregate functions. There are also exercises involving complex queries with joins, subqueries, and functions, providing a hands-on experience with real-world data scenarios.
Who is the target audience for this course?
The course is designed for aspiring developers and data scientists who need a solid foundation in SQL to work with large databases. It is also suitable for professionals in roles that require data analysis, database management, or backend development who want to deepen their understanding of SQL.
How does this course compare in depth and scope to other SQL courses?
This course offers a comprehensive exploration of SQL, covering fundamental topics such as SELECT and WHERE clauses, operators, joins, and subqueries, as well as advanced topics like correlated subqueries, aggregate functions, and date calculations. With 155 lessons, it provides a thorough grounding in SQL suitable for both beginners and those looking to deepen their knowledge.
What specific tools or platforms does the course focus on?
The course primarily uses MySQL as the database platform, guiding students through the installation process on both Mac and Windows. Lessons focus on SQL syntax and functions within the MySQL environment, making it ideal for those who plan to work with this popular database management system.
What topics or tools are not covered in the course?
The course does not cover non-SQL database systems such as NoSQL databases, nor does it address advanced topics like performance tuning, database security, or database administration. It focuses strictly on SQL queries and MySQL functionalities.
How will the skills learned in this course benefit my career or other learning paths?
Acquiring SQL skills from this course will enhance your ability to manage and analyze data, which is crucial for careers in data science, software development, and data analytics. The knowledge gained can also be a stepping stone to learning other database management systems or advancing into roles that require expertise in data manipulation and reporting.