Complete SQL + Databases Bootcamp: Zero to Mastery

24:06:52 Inglés Premium 21/11/2023 222 videos

Descripción del curso

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.

Curriculum

Section 1: Module 1

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

About the Instructor

zerotomastery.io

$0.00

$8.00

Que esta incluido?

Streaming Multiplataforma
Acceso de por vida
Soporte al cliente
Actualizaciones gratuitas