Complete SQL Mastery

10h 47m 7s
English
Paid

Course description

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.

Read more about the course

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

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

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

SQL - MySQL for Data Analytics and Business Intelligence

SQL - MySQL for Data Analytics and Business Intelligence

Sources: udemy
Well, when you can work with SQL, it means you don’t have to rely on others sending you data and executing queries for you. You can do that on your own. This al
9 hours 22 minutes 55 seconds
Make a Google search engine clone: JavaScript PHP and MySQL

Make a Google search engine clone: JavaScript PHP and MySQL

Sources: udemy
Do you want to become an expert in JavaScript, PHP and MySQL?Do you want to build a real search engine just like Google? If so, you’re in the right place!
5 hours 47 minutes 11 seconds
Database DevOps from Start to Finish

Database DevOps from Start to Finish

Sources: iamtimcorey.com (Tim Corey)
If you have only ever built a database using SQL Server Management Studio (SSMS), you are in for a treat. SQL Server Data Tools (SSDT) is designed for building
2 hours 40 minutes 37 seconds
SQL for Data Engineers

SQL for Data Engineers

Sources: Andreas Kretz
SQL is the foundation for working with relational databases. And if you are planning to work in the field of Data Engineering, knowing SQL is not just a...
1 hour 51 minutes