Complete SQL and Databases Bootcamp: Zero to Mastery [2022]

Complete SQL and Databases Bootcamp: Zero to Mastery [2022]

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 279 lectures (24h 22m) | 9.00 GB

Complete SQL + Databases Bootcamp: Zero to Mastery [2022]

Master SQL, Database Management & Design and learn to work with databases like PostgreSQL, MySQL + more. With Exercises!

This SQL Bootcamp will take you from complete beginner to a master of SQL, database management, and database design. You’ll learn by using fun exercises and working with all database types to give you real-world experience. No prior experience needed.

Updated with all modern SQL and Database (PostgreSQL, MySQL) features for 2022, you’ll learn SQL from not one, but two industry experts. Learning SQL and database best practices from this bootcamp will help you level-up your skillset to earn a higher salary and even get you hired.

WHAT YOU’LL LEARN

  • Become an expert in SQL and Database concepts
  • Add SQL, PostgreSQL, MySQL, Redis, Database Management, and Database Design to your resume
  • Learn how Machine Learning, Data Science and Data Engineers use Big Data and databases
  • Use the right SQL features to work with data efficiently and solve database problems
  • Learn to make business and market decisions based on user 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, and caching to make your database queries efficient
  • Learn how to handle user passwords and keep data safe
  • Learn to use Redis for fast memory storage
  • Understand SQL vs NoSQL and MongoDB vs MySQL vs PostgreSQL
  • Learn to perform efficient and performant SQL queries using best practices
  • Apply for SQL Developer, Database Administrator, Business Analyst, Backend Developer and Business Intelligence roles
  • Database best practices to design and manage your company data
  • Learn how to scale databases by using things like Sharding, Replication, etc.
  • Use real-world data to generate insights and reports using SQL
  • Help Sales, Marketing, and Product Managers make better decisions based on data analysis
  • Learn how databases are used in Web & Mobile Applications, Machine Learning and other fields
  • Work with SQL across multiple tables and multiple databases
  • Master SQL joins
Table of Contents

Introduction
1 Course Outline
2 Join Our Online Classroom
3 Exercise Meet Your Classmates and Instructor
4 The Big Data Breach At Keiko Corp
5 Monthly Coding Challenges Free Resources and Guides

History And Story Of Data
6 What Is a Database
7 I Didnt Learn Anything Try Again
8 Database Management System DBMS
9 Exercise Building Amazon
10 Exercise Building Amazon 2
11 Types Of Databases
12 Exercise What Is A Database
13 Section Review

Databases SQL Fundamentals
14 SQL Playground
15 What Is SQL
16 What Is A Query
17 Exercise Setting Up Your First Database
18 Imperative vs Declarative
19 History of SQL
20 Optional History of SQL Deep Dive
21 Exercises The Select Statement
22 SQL Standards
23 What Is A Database Revisited
24 Database Oriented Approach
25 Exercise SQL Starter Quiz
26 Database Models
27 Hierarchical And Networking Model
28 Relational Model
29 DBMS Revisited
30 Relational Model Revisited
31 Tables
32 Columns
33 Rows
34 Primary And Foreign Keys
35 OLTP vs OLAP
36 Exercise OLTP vs OLAP
37 Exercise Relational Model Quiz
38 Endorsements On LinkedIN

Environment Setup
39 Why PostgreSQL
40 Environment Tooling
41 Having Trouble Registering A Serial Key For ValentinaDB
42 SQL Tooling Alternatives
43 Command Line 101
44 Getting Help With The Setup
45 WINDOWS Setup
46 Optional Setting Up Windows For Command Line
47 MAC Setup
48 MAC Commandline tools
49 LINUX Setup
50 Importing The Databases
51 Exercise Imposter Syndrome

SQL Deep Dive
52 Multi Table SELECT
53 Inner Join
54 Self Join
55 Outer Join
56 Less Common Joins
57 InnerJoin Exercises
58 USING Keyword
59 Query Along
60 Starting With Query
61 Exercise Simple Queries
62 Changing Column Names in a SELECT Query
63 Concat Function
64 What Is A Function In SQL
65 Aggregate Functions
66 Exercise Aggregate Functions
67 Commenting Your Queries
68 Common SELECT Mistakes
69 Filtering Data
70 AND and OR
71 Exercise Filtering Data
72 The NOT Keyword
73 Exercise The Where Clause
74 Comparison Operators
75 Exercise Comparison Operators
76 Logical Operators
77 Operator Precedence
78 Operator Precedence 2
79 Operator Precedence Extra
80 Exercise Operator Precedence
81 Checking For NULL Values
82 IS Keyword
83 NULL Coalescing
84 Exercise Null Value Coalescing
85 Valued Logic
86 Exercise 3 Valued Logic
87 BETWEEN AND
88 Exercise BETWEEN AND
89 IN Keyword
90 Exercise IN Keyword
91 LIKE
92 Exercise Like Keyword
93 Dates And Timezones
94 Setting Up Timezones
95 How Do We Format Date And Time
96 Timestamps
97 Date Functions
98 Date Difference And Casting
99 Age Calculation
100 Extracting Information
101 Intervals
102 Exercise Date and Timestamp
103 DISTINCT
104 Exercise Distinct Keyword
105 Sorting Data
106 Exercise Sorting Data

Advanced SQL
107 GROUP BY
108 Group By Exercises
109 HAVING Keyword
110 Having Exercises
111 Ordering Grouped Data
112 Group By Mental Model
113 Grouping Sets
114 Rollup
115 Window What
116 Looking Through The Window
117 PARTITION BY
118 Order By Acting Strange
119 Using Framing In Window Function
120 Solving For Current Salary
121 FIRSTVALUE
122 LASTVALUE
123 SUM
124 ROWNUMBER
125 Window Function Exercises
126 Conditional Statements
127 Conditional Statement Exercise
128 NULLIF
129 NULLIF Exercise
130 ViewsWhat Are They Good For
131 View Syntax
132 Using Views
133 Views Exercises
134 Indexes
135 Index Types
136 Index Algorithms
137 Quick Note On Index Algorithms
138 What Are Subqueries
139 Subqueries vs Joins
140 Subquery Guidelines As Types
141 Using Subqueries
142 Quick Note Titles For Employees
143 Getting The Latest Salaries
144 Subquery Operators
145 Subquery Exercises

Database Management
146 Before We Get Started
147 Time To Create Some Stuff
148 Types Of Databases In A RDBMS
149 Default PostgreSQL Database
150 Template Databases
151 Creating A Database
152 Database Organization
153 Roles In Postgres
154 Role Attributes And Creation
155 Creating Users And Configuring Login
156 Privileges
157 Granting Privileges and Role Management
158 Best Practices For Role Management
159 Data Types & Boolean Type
160 Storing Text
161 Storing Numbers
162 Storing Arrays
163 Data Models And Naming Conventions
164 CREATE TABLE
165 Extra information on CREATE TABLE
166 Column Constraints
167 Table Constraints
168 Regexes
169 UUID Explained
170 Custom Data Types And Domains
171 Creating The Tables For ZTM
172 Extra information on ALTER TABLE
173 Adding Students And Teachers
174 Creating A Course
175 Adding Feedback To A Course
176 A Tale Of 2 Feedbacks
177 SQL Exercises
178 SQL Quiz
179 Backups And Why They Are Important
180 Backing Up In Postgres
181 Restoring A Database
182 Transactions

Solving The Mystery
183 Clue 1 and 2
184 Getting ready to solve the Mystery
185 Clue 3
186 Exercise Solving The First Clues
187 Solution Solving The First Clues
188 Clue 4
189 Exercise Clue 4
190 Solution Clue 4
191 Clue 5 and 6
192 Exercise Clue 5 and 6
193 Solution Clue 5 and 6
194 Solving The Mystery

Database Design
195 System Design And SDLC
196 SDLC Phases
197 System Design Deep Dive
198 Top
199 DRIVEME Academy
200 Top Down Design
201 ER Model
202 Step 1 Determining Entities
203 Tooling For Diagramming
204 DRIVEME Academy Entities
205 Step 2 Attributes
206 Relational Model Extended
207 Relational Schema And Instance
208 Super Key and Candidate Key
209 Primary Key and Foreign Key
210 Compound Composite And Surrogate Key
211 DRIVEME Attributes
212 Step 3 Relationships
213 DRIVEME Relationships
214 Step 4 Solving Many To Many
215 Step 5 Subject Areas
216 DRIVEME Subject Areas
217 Exercise Painting Reservations
218 Exercise Movie Theatre
219 Bottom Up Design
220 Anomalies
221 Normalization
222 Functional Dependencies
223 Functional Dependencies 2
224 The Normal Forms
225 Going from 0NF to 1NF
226 Going from 1NF to 2NF
227 Going from 2NF to 3NF
228 Boyce
229 Why 4NF And 5NF Are Not Useful
230 Exercise Database Design Quiz

Database Landscape Performance and Security
231 Brunos Request
232 Scalability
233 Sharding
234 Replication
235 Backups
236 Distributed vs Centralized Databases
237 Database Security
238 Exercise SQL Injection
239 Optional All About Injections Attacks
240 Optional Storing Passwords
241 Optional How To Store Passwords
242 Relational vs NoSQL PostgreSQL vs MongoDB Databases
243 Future Of Relational Databases
244 Elasticsearch
245 S3 Object Storage
246 Top Databases To Use

Where To Go From Here
247 Thank You
248 LinkedIn Endorsements
249 Become An Alumni
250 Learning Guideline
251 Coding Challenges

Extras Data Engineering And the role of Machine Learning
252 Big Data Analytics
253 Quick Note Upcoming Videos
254 Reviewing How We Got Here
255 Data Engineering Introduction
256 What Is Data
257 What Is A Data Engineer
258 What Is A Data Engineer 2
259 What Is A Data Engineer 3
260 What Is A Data Engineer 4
261 Types Of Databases
262 Hadoop HDFS and MapReduce
263 Apache Spark and Apache Flink
264 Kafka and Stream Processing

Extras Redis
265 Quick Note Upcoming Videos
266 What Is Caching
267 Introducing Redis
268 Installing Redis
269 Redis Commands
270 Redis Data Types
271 Redis Hashes
272 Redis Lists
273 Redis Sets and Sorted Sets
274 Section Summary

Extra Bits Databases In A Web App with Nodejs
275 Quick Note Upcoming Videos
276 Setting Up Your Database
277 Connecting To The Database
278 Registering A User Part 1

BONUS SECTION
279 Bonus Lecture

Homepage