Complete SQL Mastery

Name: Complete SQL Mastery
Price: 9 USD
Availability: InStock

10h 47m 7s

English

Paid

March 30, 2024

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.

Watch Online

Watch Online Complete SQL Mastery

0:00

#1: Introduction

All Course Lessons (155)

#	Lesson Title	Duration
1	Introduction Demo	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

Unlock unlimited learning

Get instant access to all 154 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Comments

0 comments

Want to join the conversation?

Similar courses

Database Mastery: SQL to Prisma

Sources: jsmastery.pro, Adrian Hajdin

Master key technologies with a practical approach! You will gain applied knowledge, clear explanations, and all the necessary tools to confidently master...

16 minutes 3 seconds

SQL and PostgreSQL: The Complete Developer's Guide

Sources: udemy, Stephen Grider

SQL and PostgreSQL: The Complete developer’s Guide is a comprehensive SQL language training course and PostgreSQL database management system . Nowadays, all app

22 hours 1 minute

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

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

Master SQL Queries From Basic to Advanced

Sources: Kamran Ahmed

The course is designed for developers, data analysts, and anyone working with databases. It covers the entire range of SQL queries - from basics to advanced...