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