Complete SQL + Databases Bootcamp: Zero to Mastery

24h 6m 52s
English
Paid
November 21, 2023

With so many online resources available, it can be paralyzing not only figuring out where to start but more importantly which courses will actually teach you the skills you need to get hired. That’s why the Zero To Mastery Academy exists, to provide industry-leading courses and content to teach you the relevant skills you need to advance your career and get you hired at some of the top companies in the world.

More



Watch Online Complete SQL + Databases Bootcamp: Zero to Mastery

Join premium to watch
Go to premium
# Title Duration
1 Course Outline 07:52
2 The Big Data Breach At Keiko Corp 02:24
3 What Is a Database? 05:58
4 I Didn't Learn Anything, Try Again... 06:36
5 Database Management System (DBMS) 07:45
6 Exercise: Building Amazon 05:35
7 Exercise: Building Amazon 2 05:29
8 5 Types Of Databases 05:38
9 Exercise: What Is A Database? 01:12
10 Section Review 01:30
11 SQL Playground 01:55
12 What Is SQL 02:18
13 What Is A Query? 06:25
14 Imperative vs Declarative 03:25
15 History of SQL 02:22
16 SQL Standards 04:26
17 What Is A Database? Revisited 05:37
18 Database Oriented Approach 06:52
19 Database Models 01:22
20 Hierarchical And Networking Model 08:04
21 Relational Model 07:18
22 DBMS Revisited 13:57
23 Relational Model Revisited 01:07
24 Tables 03:46
25 Columns 04:08
26 Rows 02:28
27 Primary And Foreign Keys 05:04
28 OLTP vs OLAP 03:17
29 Exercise: OLTP vs OLAP 03:21
30 Why PostgreSQL 01:53
31 Environment Tooling 03:11
32 Command Line 101 05:22
33 WINDOWS Setup 04:53
34 Optional: Setting Up Windows For Command Line 04:28
35 MAC Setup 06:31
36 LINUX Setup 05:37
37 Importing Data On WINDOWS 08:29
38 Importing Data On MAC 06:39
39 Importing Data On LINUX 04:58
40 Starting With Query 05:15
41 Exercise: Simple Queries 10:11
42 Exercise: Renaming Columns 03:20
43 Concat Function 04:52
44 What Is A Function In SQL? 06:47
45 Aggregate Functions 05:20
46 Commenting Your Queries 09:33
47 Common SELECT Mistakes 08:40
48 Filtering Data 05:45
49 AND and OR 14:16
50 Exercise: Filtering Data 07:57
51 The NOT Keyword 07:19
52 Comparison Operators 06:47
53 Logical Operators 07:32
54 Operator Precedence 09:39
55 Operator Precedence 2 11:32
56 Checking For NULL Values 12:02
57 IS Keyword 13:43
58 NULL Coalescing 07:13
59 3 Valued Logic 12:25
60 BETWEEN + AND 02:07
61 IN Keyword 03:25
62 LIKE 13:18
63 Dates And Timezones 12:54
64 Setting Up Timezones 03:38
65 How Do We Format Date And Time? 06:16
66 Timestamps 10:28
67 Date Functions 04:53
68 Date Difference And Casting 01:48
69 Age Calculation 02:10
70 Extracting Information 02:52
71 Intervals 03:14
72 DISTINCT 04:12
73 Sorting Data 06:18
74 Multi Table SELECT 10:48
75 Inner Join 19:43
76 Self Join 04:55
77 Outer Join 11:31
78 Less Common Joins 06:37
79 USING Keyword 04:30
80 GROUP BY 14:44
81 HAVING Keyword 07:39
82 Ordering Grouped Data 01:45
83 Group By Mental Model 12:11
84 Grouping Sets 09:30
85 Rollup 07:18
86 Window What? 03:31
87 Looking Through The Window 08:53
88 PARTITION BY 05:51
89 Order By Acting Strange 05:35
90 Using Framing In Window Function 14:13
91 Solving For Current Salary 10:50
92 FIRST_VALUE 05:49
93 LAST_VALUE 04:04
94 SUM 05:33
95 ROW_NUMBER 03:04
96 Conditional Statements 06:15
97 NULLIF 02:26
98 Views...What Are They Good For? 03:42
99 View Syntax 05:37
100 Using Views 12:25
101 Indexes 11:10
102 Index Types 10:29
103 Index Algorithms 10:29
104 What Are Subqueries? 08:19
105 Subqueries vs Joins 08:48
106 Subquery Guidelines As Types 11:18
107 Using Subqueries 11:27
108 Getting The Latest Salaries 14:20
109 Subquery Operators 09:01
110 Time To Create Some Stuff! 09:57
111 Types Of Databases In A RDBMS 04:18
112 Default PostgreSQL Database 07:39
113 Template Databases 06:42
114 Creating A Database 04:42
115 Database Organization 07:09
116 Roles In Postgres 03:46
117 Role Attributes And Creation 04:53
118 Creating Users And Configuring Login 13:45
119 Privileges 03:52
120 Granting Privileges and Role Management 06:24
121 Best Practices For Role Management 04:23
122 Data Types & Boolean Type 07:37
123 Storing Text 05:20
124 Storing Numbers 07:17
125 Storing Arrays 04:21
126 Data Models And Naming Conventions 10:55
127 CREATE TABLE 08:56
128 Column Constraints 05:50
129 Table Constraints 11:43
130 UUID Explained 05:48
131 Custom Data Types And Domains 06:08
132 Creating The Tables For ZTM 11:53
133 Adding Students And Teachers 08:08
134 Creating A Course 12:32
135 Adding Feedback To A Course 06:50
136 A Tale Of 2 Feedbacks 09:04
137 Backups And Why They Are Important 23:20
138 Backing Up In Postgres 07:43
139 Restoring A Database 06:16
140 Transactions 18:16
141 Clue #1 and #2 01:46
142 Clue #3 00:48
143 Solution: Solving The First Clues 05:26
144 Clue #4 00:28
145 Solution: Clue #4 01:03
146 Clue #5 and #6 01:14
147 Solution: Clue #5 and #6 05:47
148 Solving The Mystery 02:53
149 System Design And SDLC 09:50
150 SDLC Phases 06:01
151 System Design Deep Dive 05:58
152 Top-Down vs Bottom-Up 06:29
153 DRIVEME Academy 06:42
154 Top Down Design 04:42
155 ER Model 05:11
156 Step 1: Determining Entities 03:35
157 Tooling For Diagramming 03:29
158 DRIVEME Academy Entities 13:55
159 Step 2: Attributes 03:05
160 Relational Model Extended 01:10
161 Relational Schema And Instance 02:38
162 Super Key and Candidate Key 06:23
163 Primary Key and Foreign Key 07:34
164 Compound Composite And Surrogate Key 04:08
165 DRIVEME Attributes 11:57
166 Step 3: Relationships 12:06
167 DRIVEME Relationships 12:30
168 Step 4: Solving Many To Many 09:28
169 Step 5: Subject Areas 02:45
170 DRIVEME Subject Areas 02:56
171 Exercise: Painting Reservations 09:18
172 Exercise: Movie Theatre 05:07
173 Bottom Up Design 05:18
174 Anomalies 10:30
175 Normalization 07:15
176 Functional Dependencies 06:36
177 Functional Dependencies 2 06:12
178 The Normal Forms 04:33
179 Going from 0NF to 1NF 08:10
180 Going from 1NF to 2NF 05:48
181 Going from 2NF to 3NF 08:31
182 Boyce-Codd Normal Form 09:02
183 Why 4NF And 5NF Are Not Useful 05:58
184 Bruno's Request 01:37
185 Scalability 04:20
186 Sharding 03:05
187 Replication 04:57
188 Backups 02:16
189 Distributed vs Centralized Databases 03:42
190 Database Security 04:03
191 Optional: All About Injections Attacks 19:43
192 Optional: Storing Passwords 10:55
193 Relational vs NoSQL, PostgreSQL vs MongoDB Databases 10:36
194 Future Of Relational Databases 01:48
195 Elasticsearch 03:49
196 S3 Object Storage 01:49
197 Top Databases To Use 04:43
198 Thank You 01:15
199 Big Data + Analytics 02:32
200 Reviewing How We Got Here 06:04
201 Data Engineering Introduction 03:24
202 What Is Data? 06:43
203 What Is A Data Engineer? 04:21
204 What Is A Data Engineer 2? 05:36
205 What Is A Data Engineer 3? 05:04
206 What Is A Data Engineer 4? 03:23
207 Types Of Databases 06:51
208 Hadoop, HDFS and MapReduce 04:23
209 Apache Spark and Apache Flink 02:08
210 Kafka and Stream Processing 04:34
211 What Is Caching? 06:58
212 Introducing Redis 06:32
213 Installing Redis 04:48
214 Redis Commands 05:58
215 Redis Data Types 02:00
216 Redis Hashes 02:01
217 Redis Lists 03:56
218 Redis Sets and Sorted Sets 06:12
219 Section Summary 03:01
220 Setting Up Your Database 08:52
221 Connecting To The Database 07:07
222 Registering A User Part 1 04:51

Similar courses to Complete SQL + Databases Bootcamp: Zero to Mastery

Learn MySQL and Solve 42 Practical Problems

Learn MySQL and Solve 42 Practical Problemsudemy

Duration 4 hours 24 minutes 35 seconds
Redis Caching Concepts with Node.js

Redis Caching Concepts with Node.jsCodedamn

Duration 1 hour 52 minutes 26 seconds
SQL Injections Unlocked - SQLi Web Attacks

SQL Injections Unlocked - SQLi Web Attacksudemy

Duration 4 hours 59 minutes 9 seconds
Database Design & Implementation

Database Design & Implementationamigoscode (Nelson Djalo)

Duration 2 hours 7 minutes 49 seconds