Course Content
1 – Introduction
0/3
1 – Course Outline.mp4
07:51
2 – Join Our Online Classroom.mp4
04:01
4 – The Big Data Breach At Keiko Corp.mp4
02:22
10 – Database Landscape Performance and Security
0/14
231 – Brunos Request.mp4
01:36
232 – Scalability.mp4
04:19
233 – Sharding.mp4
03:04
234 – Replication.mp4
04:56
235 – Backups.mp4
02:15
236 – Distributed vs Centralized Databases.mp4
03:41
237 – Database Security.mp4
04:02
239 – Optional All About Injections Attacks.mp4
19:42
240 – Optional Storing Passwords.mp4
10:54
242 – Relational vs NoSQL PostgreSQL vs MongoDB Databases.mp4
10:35
243 – Future Of Relational Databases.mp4
01:47
244 – Elasticsearch.mp4
03:48
245 – S3 Object Storage.mp4
01:48
246 – Top Databases To Use.mp4
04:42
11 – Where To Go From Here
0/1
247 – Thank You.mp4
01:14
12 – Extras Data Engineering And the role of Machine Learning
0/12
252 – Big Data Analytics.mp4
02:31
254 – Reviewing How We Got Here.mp4
06:03
255 – Data Engineering Introduction.mp4
03:23
256 – What Is Data.mp4
06:42
257 – What Is A Data Engineer.mp4
04:20
258 – What Is A Data Engineer 2.mp4
05:35
259 – What Is A Data Engineer 3.mp4
05:03
260 – What Is A Data Engineer 4.mp4
03:22
261 – Types Of Databases.mp4
06:50
262 – Hadoop HDFS and MapReduce.mp4
04:22
263 – Apache Spark and Apache Flink.mp4
02:07
264 – Kafka and Stream Processing.mp4
04:33
13 – Extras Redis
0/9
266 – What Is Caching.mp4
06:57
267 – Introducing Redis.mp4
06:30
269 – Installing Redis.mp4
04:31
271 – Redis Commands.mp4
05:57
272 – Redis Data Types.mp4
01:59
273 – Redis Hashes.mp4
02:00
274 – Redis Lists.mp4
03:55
275 – Redis Sets and Sorted Sets.mp4
06:11
276 – Section Summary.mp4
03:00
14 – Extra Bits Databases In A Web App with Nodejs
0/3
278 – Setting Up Your Database.mp4
08:51
279 – Connecting To The Database.mp4
07:06
280 – Registering A User Part 1.mp4
04:50
2 – History And Story Of Data
0/8
6 – What Is a Database.mp4
05:57
7 – I Didnt Learn Anything Try Again.mp4
06:35
8 – Database Management System DBMS.mp4
07:44
9 – Exercise Building Amazon.mp4
05:34
10 – Exercise Building Amazon 2.mp4
05:28
11 – 5 Types Of Databases.mp4
05:37
12 – Exercise What Is A Database.mp4
01:11
13 – Section Review.mp4
01:29
3 – Databases SQL Fundamentals
0/19
27 – Hierarchical And Networking Model.mp4
08:03
36 – Exercise OLTP vs OLAP.mp4
03:20
35 – OLTP vs OLAP.mp4
00:00
34 – Primary And Foreign Keys.mp4
05:03
33 – Rows.mp4
02:27
32 – Columns.mp4
04:07
31 – Tables.mp4
03:45
30 – Relational Model Revisited.mp4
01:06
29 – DBMS Revisited.mp4
13:56
28 – Relational Model.mp4
07:17
14 – SQL Playground.mp4
01:54
26 – Database Models.mp4
01:21
24 – Database Oriented Approach.mp4
06:51
23 – What Is A Database Revisited.mp4
05:36
22 – SQL Standards.mp4
04:25
19 – History of SQL.mp4
02:21
18 – Imperative vs Declarative.mp4
03:23
16 – What Is A Query.mp4
06:27
15 – What Is SQL.mp4
02:17
4 – Environment Setup
0/9
39 – Why PostgreSQL.mp4
01:52
40 – Environment Tooling.mp4
03:10
43 – Command Line 101.mp4
05:21
45 – WINDOWS Setup.mp4
04:53
46 – Optional Setting Up Windows For Command Line.mp4
04:27
47 – MAC Setup.mp4
06:30
49 – LINUX Setup.mp4
05:36
50 – Importing The Databases.mp4
06:03
51 – Exercise Imposter Syndrome.mp4
02:56
5 – SQL Deep Dive
0/40
93 – Extracting Information.mp4
02:51
82 – IN Keyword.mp4
03:24
84 – LIKE.mp4
13:17
86 – Dates And Timezones.mp4
12:53
87 – Setting Up Timezones.mp4
03:37
88 – How Do We Format Date And Time.mp4
06:15
89 – Timestamps.mp4
10:27
90 – Date Functions.mp4
04:52
91 – Date Difference And Casting.mp4
01:47
92 – Age Calculation.mp4
02:09
80 – BETWEEN AND.mp4
02:06
94 – Intervals.mp4
03:13
96 – DISTINCT.mp4
04:11
98 – Sorting Data.mp4
06:17
100 – Multi Table SELECT.mp4
10:47
101 – Inner Join.mp4
19:42
102 – Self Join.mp4
04:54
103 – Outer Join.mp4
11:30
104 – Less Common Joins.mp4
06:36
106 – USING Keyword.mp4
04:29
64 – Exercise Filtering Data.mp4
07:56
54 – Exercise Simple Queries.mp4
10:10
55 – Changing Column Names in a SELECT Query.mp4
03:19
56 – Concat Function.mp4
04:51
57 – What Is A Function In SQL.mp4
06:46
58 – Aggregate Functions.mp4
05:19
60 – Commenting Your Queries.mp4
09:32
61 – Common SELECT Mistakes.mp4
08:27
62 – Filtering Data.mp4
05:44
63 – AND and OR.mp4
14:15
53 – Starting With Query.mp4
05:14
65 – The NOT Keyword.mp4
07:18
67 – Comparison Operators.mp4
06:01
69 – Logical Operators.mp4
07:31
70 – Operator Precedence.mp4
09:38
71 – Operator Precedence 2.mp4
11:31
74 – Checking For NULL Values.mp4
12:01
75 – IS Keyword.mp4
13:42
76 – NULL Coalescing.mp4
07:12
78 – 3 Valued Logic.mp4
12:24
6 – Advanced SQL
0/30
124 – ROWNUMBER.mp4
03:03
144 – Subquery Operators.mp4
09:00
143 – Getting The Latest Salaries.mp4
14:19
141 – Using Subqueries.mp4
11:26
140 – Subquery Guidelines As Types.mp4
11:17
139 – Subqueries vs Joins.mp4
08:47
138 – What Are Subqueries.mp4
08:18
136 – Index Algorithms.mp4
10:28
135 – Index Types.mp4
10:28
134 – Indexes.mp4
11:09
132 – Using Views.mp4
12:24
131 – View Syntax.mp4
05:36
130 – ViewsWhat Are They Good For.mp4
03:41
128 – NULLIF.mp4
02:25
126 – Conditional Statements.mp4
06:14
107 – GROUP BY.mp4
14:43
123 – SUM.mp4
05:32
122 – LASTVALUE.mp4
04:03
121 – FIRSTVALUE.mp4
05:48
120 – Solving For Current Salary.mp4
10:49
119 – Using Framing In Window Function.mp4
14:12
118 – Order By Acting Strange.mp4
05:34
117 – PARTITION BY.mp4
05:50
116 – Looking Through The Window.mp4
08:52
115 – Window What.mp4
03:30
114 – Rollup.mp4
07:17
113 – Grouping Sets.mp4
09:29
112 – Group By Mental Model.mp4
12:10
111 – Ordering Grouped Data.mp4
01:44
109 – HAVING Keyword.mp4
07:38
7 – Database Management
0/31
162 – Storing Arrays.mp4
04:19
182 – Transactions.mp4
18:15
181 – Restoring A Database.mp4
06:15
180 – Backing Up In Postgres.mp4
07:42
179 – Backups And Why They Are Important.mp4
23:19
176 – A Tale Of 2 Feedbacks.mp4
09:03
175 – Adding Feedback To A Course.mp4
06:49
174 – Creating A Course.mp4
12:31
173 – Adding Students And Teachers.mp4
08:07
171 – Creating The Tables For ZTM.mp4
11:52
170 – Custom Data Types And Domains.mp4
06:07
169 – UUID Explained.mp4
05:47
167 – Table Constraints.mp4
11:42
166 – Column Constraints.mp4
05:49
164 – CREATE TABLE.mp4
08:55
163 – Data Models And Naming Conventions.mp4
10:54
147 – Time To Create Some Stuff.mp4
09:56
161 – Storing Numbers.mp4
07:16
160 – Storing Text.mp4
05:19
159 – Data Types & Boolean Type.mp4
07:36
158 – Best Practices For Role Management.mp4
04:22
157 – Granting Privileges and Role Management.mp4
06:23
156 – Privileges.mp4
03:51
155 – Creating Users And Configuring Login.mp4
13:44
154 – Role Attributes And Creation.mp4
04:52
153 – Roles In Postgres.mp4
03:45
152 – Database Organization.mp4
07:08
151 – Creating A Database.mp4
04:41
150 – Template Databases.mp4
06:41
149 – Default PostgreSQL Database.mp4
07:38
148 – Types Of Databases In A RDBMS.mp4
04:17
8 – Solving The Mystery
0/8
183 – Clue 1 and 2.mp4
01:45
185 – Clue 3.mp4
00:47
187 – Solution Solving The First Clues.mp4
05:25
188 – Clue 4.mp4
00:27
190 – Solution Clue 4.mp4
01:02
191 – Clue 5 and 6.mp4
01:13
193 – Solution Clue 5 and 6.mp4
05:46
194 – Solving The Mystery.mp4
02:52
9 – Database Design
0/35
221 – Normalization.mp4
07:14
213 – DRIVEME Relationships.mp4
12:29
214 – Step 4 Solving Many To Many.mp4
09:27
215 – Step 5 Subject Areas.mp4
02:44
216 – DRIVEME Subject Areas.mp4
02:55
217 – Exercise Painting Reservations.mp4
09:17
218 – Exercise Movie Theatre.mp4
05:05
219 – Bottom Up Design.mp4
05:17
220 – Anomalies.mp4
10:29
212 – Step 3 Relationships.mp4
12:05
222 – Functional Dependencies.mp4
06:35
223 – Functional Dependencies 2.mp4
06:11
224 – The Normal Forms.mp4
04:32
225 – Going from 0NF to 1NF.mp4
08:09
226 – Going from 1NF to 2NF.mp4
05:47
227 – Going from 2NF to 3NF.mp4
08:30
228 – BoyceCodd Normal Form.mp4
09:01
229 – Why 4NF And 5NF Are Not Useful.mp4
05:57
204 – DRIVEME Academy Entities.mp4
13:54
196 – SDLC Phases.mp4
06:00
197 – System Design Deep Dive.mp4
05:57
198 – TopDown vs BottomUp.mp4
06:28
199 – DRIVEME Academy.mp4
06:41
200 – Top Down Design.mp4
04:41
201 – ER Model.mp4
05:10
202 – Step 1 Determining Entities.mp4
03:34
203 – Tooling For Diagramming.mp4
03:28
195 – System Design And SDLC.mp4
09:49
205 – Step 2 Attributes.mp4
03:04
206 – Relational Model Extended.mp4
01:09
207 – Relational Schema And Instance.mp4
02:37
208 – Super Key and Candidate Key.mp4
06:22
209 – Primary Key and Foreign Key.mp4
07:33
210 – Compound Composite And Surrogate Key.mp4
04:07
211 – DRIVEME Attributes.mp4
11:56
[Last updated 11/2022] Complete SQL and Databases Bootcamp: Zero to Mastery [2023] (Udemy – Engsub)
Previous
Next
0% Complete