CourseFlix

Complete SQL + Databases Bootcamp: Zero to Mastery

24h 6m 52s
English
Paid

This course helps you learn SQL and databases from the ground up.You start with the basics and build real skills step by step. You get clear lessons, hands‑on practice, and tools you will use in real jobs.

What You Will Learn

You learn how databases work and how to use SQL to manage data. You also learn how to build, query, and improve databases for real projects.

Core Skills

  • Write SQL queries to read and change data
  • Create tables and design database schemas
  • Use joins, indexes, and constraints
  • Work with relational and non‑relational databases
  • Make databases faster and easier to maintain

How You Will Learn

You learn by doing. Each lesson includes short tasks to help you practice new ideas. You also build small projects that match common work tasks.

Tools Used

  • PostgreSQL for core SQL work
  • SQLite for lightweight demos
  • Real datasets from common apps

Who This Course Is For

This course is for you if you are new to SQL or need a clear path to learn databases. It also helps if you want to work in backend development, data analysis, or any role that uses structured data.

What You Can Do After

When you finish, you can build and query databases with confidence. You can read and write SQL at work, solve data problems, and understand how real systems store and use information.

Additional

https://coursehunters.online/t/complete-sql-databases-bootcamp-zero-to-mastery/3981

About the Author: Zero To Mastery

Zero To Mastery thumbnail

Zero To Mastery (ZTM) is a Toronto-based online coding academy founded by Andrei Neagoie, originally a senior developer at large Canadian tech firms before turning to teaching full-time. The academy's signature is the cohort-based bootcamp track combined with a deep self-paced course library, all aimed at career-changers and self-taught developers preparing to land software-engineering roles at top companies.

The instructor roster has grown well beyond Andrei to include other senior practitioners: Daniel Bourke (machine learning), Aleksa Tešić (DevOps), Jacinto Wong, and others. Courses cover the full software-engineering career path: web development with React and Next.js, Python, machine learning and deep learning, DevOps and cloud, system design, mobile, and the algorithm / data-structure interview prep that gates engineering jobs.

The CourseFlix listing under this source carries over 120 ZTM courses spanning that full range. Material is paid; ZTM itself runs on a monthly / annual membership model. The teaching style favours long-form, project-based courses where students build complete portfolio-quality applications rather than disconnected feature tutorials.

Watch Online 222 lessons

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 222 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Course Outline
All Course Lessons (222)
#Lesson TitleDurationAccess
1
Course Outline Demo
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
Unlock unlimited learning

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

Learn more about subscription

Course content

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

Related courses

  • 100 Days Of Code: The Complete Web Development Bootcamp 2024 thumbnail

    100 Days Of Code: The Complete Web Development Bootcamp 2024

    Sources: Academind Pro (Maximilian Schwarzmüller)
    100 Days of Code: Complete Web Development Bootcamp 2022 by Colt Steele — HTML, CSS, JavaScript, Node, Express, Mongo, and full-stack projects.
    78 hours 51 minutes 55 seconds
  • SQL for Data Engineers thumbnail

    SQL for Data Engineers

    Sources: Andreas Kretz
    SQL is the foundation for working with relational databases. If you plan to work in the field of Data Engineering .
    1 hour 51 minutes
  • SQL & MySQL Subqueries: Understanding the weird parts thumbnail

    SQL & MySQL Subqueries: Understanding the weird parts

    Sources: Udemy
    Master the Art of SQL Subqueries with this Comprehensive Course - Take Your Data Management Skills to the Next Level!
    8 hours 53 minutes 49 seconds

Frequently asked questions

What is Complete SQL + Databases Bootcamp: Zero to Mastery about?
This course helps you learn SQL and databases from the ground up. You start with the basics and build real skills step by step. You get clear lessons, hands‑on practice, and tools you will use in real jobs. What You Will Learn You learn…
Who teaches Complete SQL + Databases Bootcamp: Zero to Mastery?
Complete SQL + Databases Bootcamp: Zero to Mastery is taught by Zero To Mastery. You can find more courses by this instructor on the corresponding source page.
How long is Complete SQL + Databases Bootcamp: Zero to Mastery?
Complete SQL + Databases Bootcamp: Zero to Mastery contains 222 lessons with a total runtime of 24 hours 6 minutes. All lessons are available to watch online at your own pace.
Is Complete SQL + Databases Bootcamp: Zero to Mastery free to watch?
Complete SQL + Databases Bootcamp: Zero to Mastery is part of CourseFlix's premium catalog. A CourseFlix subscription unlocks the full video player; the course description, table of contents, and preview information are available to everyone.
Where can I watch Complete SQL + Databases Bootcamp: Zero to Mastery online?
Complete SQL + Databases Bootcamp: Zero to Mastery is available to watch online on CourseFlix at https://courseflix.net/course/complete-sql-databases-bootcamp-zero-to-mastery. The page hosts every lesson with the integrated video player; no download is required.