[Last updated 11/2022] Complete SQL and Databases Bootcamp: Zero to Mastery [2023] (Udemy – Engsub)
About Course
Views
:
What you’ll learn:
Become an expert in SQL and Database Concepts
Understand SQL vs NoSQL, MongoDB vs MySQL vs PostgreSQL
Learn to perform efficient and performant SQL queries using best practices
Add SQL, PostgreSQL, MySQL, Redis, Database Management/Design to your resume
Apply for SQL developer, Database Administrator, Business Analyst, Backend Developer and Business Intelligence roles
Database best practices to design and manage your company data
Create your own databases while using SQL to interact with the data
Tons of exercises to practice what you learn and test your knowledge
Advanced SQL topics like indexes, aggregates, caching to make your database queries efficient
Work with SQL across multiple tables and multiple databases
v.v…
Time video:
24 hours (281 Lessons + Documents)
Teacher:
Andrei Neagoie, Mo Binni, Zero To Mastery
Total weight:
14.54 GB
Original link:
https://www.udemy.com/course/complete-sql-databases-bootcamp-zero-to-mastery/
Link :
Below The Post
Tải file video và file Sub (.srt) và dùng phần mềm VLC, KMPlayer,… để xem nhé!
Course Content
1 – Introduction
-
07:51
-
04:01
-
4 – The Big Data Breach At Keiko Corp.mp4
02:22
10 – Database Landscape Performance and Security
-
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
-
247 – Thank You.mp4
01:14
12 – Extras Data Engineering And the role of Machine Learning
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
Student Ratings & Reviews
No Review Yet