Complete SQL Mastery

10h 47m 7s
English
Paid
March 30, 2024

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.

More

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

Watch Online Complete SQL Mastery

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

Similar courses to Complete SQL Mastery

Effective Database Design

Effective Database DesignBen Brumm

Duration 1 hour 3 minutes 56 seconds
Mastery with SQL

Mastery with SQLmasterywithsql.com

Duration 9 hours 15 minutes 2 seconds
Node, SQL, & PostgreSQL - Mastering Backend Web Development
Database Design & Implementation

Database Design & Implementationamigoscode (Nelson Djalo)

Duration 2 hours 7 minutes 49 seconds
PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours
SQL and PostgreSQL: The Complete Developer's Guide
Ultimate Expert Guide: Mastering PostgreSQL Administration