Урок 1.00:03:09
This Course Was Just Updated!
Урок 2.00:01:09
Course Intro
Урок 3.00:01:26
About Me
Урок 4.00:01:41
Getting The Course Code
Урок 5.00:08:24
First 5 Minutes of SQL
Урок 6.00:01:03
Section Introduction
Урок 7.00:07:17
What Is A Database?
Урок 8.00:05:51
SQL vs. MySQL
Урок 9.00:05:18
Installation: START HERE!
Урок 10.00:09:14
Installation: Windows Instructions
Урок 11.00:11:35
Installation: Mac Instructions
Урок 12.00:01:10
Section Introduction
Урок 13.00:04:16
Showing Databases
Урок 14.00:04:56
Creating Databases
Урок 15.00:05:33
Dropping and Using Databases
Урок 16.00:05:19
Introducing Tables
Урок 17.00:07:39
Data Types: The Basics
Урок 18.00:02:36
Basic Datatypes Challenge
Урок 19.00:04:58
Creating Tables
Урок 20.00:04:34
How Do We Know It Worked?
Урок 21.00:02:11
Dropping Tables
Урок 22.00:02:37
Tables Basics Activity
Урок 23.00:03:13
MySQL Comments
Урок 24.00:01:41
Section Introduction
Урок 25.00:03:45
INSERT: The Basics
Урок 26.00:01:45
A Quick Preview of SELECT
Урок 27.00:04:49
Multi-inserts
Урок 28.00:05:28
INSERT Exercise
Урок 29.00:05:41
Working With NOT NULL
Урок 30.00:04:14
Sidenote: Quotes In MySQL
Урок 31.00:06:32
Adding DEFAULT Values
Урок 32.00:04:58
Introducing Primary Keys
Урок 33.00:07:14
Working With AUTO_INCREMENT
Урок 34.00:07:20
Create Table/ Insert Exercise
Урок 35.00:01:31
Section Introduction
Урок 36.00:01:52
Introducing CRUD
Урок 37.00:01:51
Getting Our New "Dataset"
Урок 38.00:03:14
Officially Introducing SELECT
Урок 39.00:03:33
The WHERE clause
Урок 40.00:01:26
Rapid Fire Exercises
Урок 41.00:02:56
Rapid Fire Exercises SOLUTION
Урок 42.00:02:14
Aliases
Урок 43.00:05:25
Using UPDATE
Урок 44.00:01:45
A Quick Rule Of Thumb
Урок 45.00:01:05
UPDATE Exercise
Урок 46.00:03:03
UPDATE Exercise SOLUTION
Урок 47.00:02:38
Introducing DELETE
Урок 48.00:00:59
DELETE Exercise
Урок 49.00:02:16
DELETE Exercise SOLUTION
Урок 50.00:01:53
Section Introduction
Урок 51.00:05:12
Introducing the CRUD Challenge
Урок 52.00:08:09
CRUD Challenge Solution: Creating
Урок 53.00:01:43
CRUD Challenge Solution: Reading
Урок 54.00:03:25
CRUD Challenge Solution: Updating
Урок 55.00:02:51
CRUD Challenge Solution: Deleting
Урок 56.00:02:05
Section Introduction
Урок 57.00:01:53
The World Of String Functions
Урок 58.00:05:26
Loading Our Books Data
Урок 59.00:08:51
CONCAT
Урок 60.00:07:32
SUBSTRING
Урок 61.00:06:50
Combining String Functions
Урок 62.00:04:27
Sidenote: SQL Formatting
Урок 63.00:05:44
REPLACE
Урок 64.00:03:31
REVERSE
Урок 65.00:02:51
CHAR_LENGTH
Урок 66.00:03:49
UPPER & LOWER
Урок 67.00:06:22
Other String Functions
Урок 68.00:03:44
String Functions Exercise
Урок 69.00:11:33
String Functions Exerise SOLUTION
Урок 70.00:00:36
Section Introduction
Урок 71.00:01:27
Adding Some New Books
Урок 72.00:06:13
DISTINCT
Урок 73.00:06:38
ORDER BY
Урок 74.00:06:20
More On ORDER BY
Урок 75.00:05:40
LIMIT
Урок 76.00:07:15
LIKE
Урок 77.00:02:04
Escaping Wildcards
Урок 78.00:03:06
Refining Selections Exercise
Урок 79.00:14:41
Refining Selections Exercise SOLUTION
Урок 80.00:03:57
Section Introduction
Урок 81.00:07:34
Count Basics
Урок 82.00:10:12
GROUP BY
Урок 83.00:03:46
MIN and MAX Basics
Урок 84.00:06:27
Subqueries
Урок 85.00:04:48
Grouping By Multiple Columns
Урок 86.00:05:51
MIN and MAX With GROUP BY
Урок 87.00:03:46
SUM
Урок 88.00:02:24
AVG
Урок 89.00:01:18
Aggregate Functions Docs
Урок 90.00:02:52
Agg Functions Exercise
Урок 91.00:12:36
Agg Functions Exercise SOLUTION
Урок 92.00:01:57
Section Introduction
Урок 93.00:02:53
Surveying Other Data Types
Урок 94.00:12:07
CHAR vs. VARCHAR
Урок 95.00:05:03
INT, TINYINT, BIGINT, etc.
Урок 96.00:06:56
DECIMAL
Урок 97.00:05:32
FLOAT & DOUBLE
Урок 98.00:04:38
DATE and TIME
Урок 99.00:07:40
Working With Dates
Урок 100.00:04:16
CURDATE, CURTIME, & NOW
Урок 101.00:06:04
Date Functions
Урок 102.00:02:04
Time Functions
Урок 103.00:09:14
Formatting Dates
Урок 104.00:10:43
Date Math
Урок 105.00:03:29
TIMESTAMPS
Урок 106.00:06:59
DEFAULT & ON UPDATE TIMESTAMPS
Урок 107.00:03:37
Data Types Exercise
Урок 108.00:13:17
Data Types Exercise SOLUTION
Урок 109.00:02:45
Section Introduction
Урок 110.00:02:57
Not Equal
Урок 111.00:03:22
NOT LIKE
Урок 112.00:03:57
Greater Than
Урок 113.00:02:58
Less Than Or Equal To
Урок 114.00:08:54
Logical AND
Урок 115.00:05:39
Logical OR
Урок 116.00:04:48
Between
Урок 117.00:08:16
Comparing Dates
Урок 118.00:08:30
The IN Operator
Урок 119.00:08:48
CASE
Урок 120.00:02:04
IS NULL
Урок 121.00:03:26
Exercise
Урок 122.00:15:23
Exercise SOLUTION
Урок 123.00:03:45
UNIQUE Constraint
Урок 124.00:05:00
CHECK Constraints
Урок 125.00:04:14
Named Constraints
Урок 126.00:05:21
Multiple Column Constraints
Урок 127.00:05:39
ALTER TABLE: Adding Columns
Урок 128.00:01:55
ALTER TABLE: Dropping Columns
Урок 129.00:03:44
ALTER TABLE: Renaming
Урок 130.00:03:56
ALTER TABLE: Modifying Columns
Урок 131.00:04:13
ALTER TABLE: Constraints
Урок 132.00:01:58
Section Introduction
Урок 133.00:10:29
Data is Messy
Урок 134.00:04:38
Relationships Basics
Урок 135.00:12:34
One to Many Relationship
Урок 136.00:11:08
Working with FOREIGN KEY
Урок 137.00:08:00
Cross Joins
Урок 138.00:08:53
Inner Joins
Урок 139.00:04:54
Inner Joins With Group By
Урок 140.00:07:06
Left Join
Урок 141.00:03:36
Left Join With Group By
Урок 142.00:04:29
Right Join
Урок 143.00:05:37
On Delete Cascade
Урок 144.00:03:02
Joins Exercise
Урок 145.00:10:43
Joins Exercise SOLUTION
Урок 146.00:01:55
Section Introduction
Урок 147.00:10:49
Many to Many Basics
Урок 148.00:06:44
Creating Our Many To Many Tables
Урок 149.00:03:36
TV Series Challenge #1
Урок 150.00:03:25
TV Series Challenge #2
Урок 151.00:03:39
TV Series Challenge #3
Урок 152.00:03:35
TV Series Challenge #4
Урок 153.00:02:26
TV Series Challenge #5
Урок 154.00:09:11
TV Series Challenge #6
Урок 155.00:05:28
TV Series Challenge #7
Урок 156.00:06:32
Introducing Views
Урок 157.00:05:43
Updateable Views
Урок 158.00:03:27
Replacing/Altering Views
Урок 159.00:04:29
HAVING clause
Урок 160.00:08:19
WITH ROLLUP
Урок 161.00:05:52
SQL Modes Basics
Урок 162.00:04:26
STRICT_TRANS_TABLES
Урок 163.00:09:50
More Modes
Урок 164.00:06:29
Introducing Window Functions
Урок 165.00:08:16
Using OVER()
Урок 166.00:06:54
PARTITION BY
Урок 167.00:06:42
ORDER BY with Windows
Урок 168.00:05:54
RANK()
Урок 169.00:05:15
DENSE_RANK, & ROW_NUMBER()
Урок 170.00:03:37
NTILE()
Урок 171.00:04:06
FIRST_VALUE
Урок 172.00:05:52
LEAD and LAG
Урок 173.00:01:20
Section Introduction
Урок 174.00:01:53
IMPORTANT NOTE ABOUT THIS SECTION!
Урок 175.00:08:32
Introducing Instagram Clone
Урок 176.00:06:09
Users Schema
Урок 177.00:06:38
Photos Schema
Урок 178.00:06:40
Comments Schema
Урок 179.00:07:42
Likes Schema
Урок 180.00:07:21
Followers Schema
Урок 181.00:10:35
3 Approaches for Hashtags
Урок 182.00:05:27
Implementing Hashtags Table
Урок 183.00:01:43
Section Introduction
Урок 184.00:08:31
Getting Lots of Instagram Data
Урок 185.00:04:54
Instagram Challenge #1
Урок 186.00:06:42
Instagram Challenge #2
Урок 187.00:07:23
Instagram Challenge #3
Урок 188.00:07:06
Instagram Challenge #4
Урок 189.00:03:14
Instagram Challenge #5
Урок 190.00:05:30
Instagram Challenge #6
Урок 191.00:05:16
Instagram Challenge #7
Урок 192.00:01:09
Course Introduction
Урок 193.00:01:26
Instructor Introduction(s)
Урок 194.00:04:19
Syllabus Walkthrough and Prerequisites
Урок 195.00:06:14
Your First 5 Minutes of SQL - Let's Get Coding!
Урок 196.00:03:45
How The Course Works
Урок 197.00:01:03
Section Introduction
Урок 198.00:07:17
What Is a Database?
Урок 199.00:05:51
SQL Vs. MySQL
Урок 200.00:05:11
Installation Overview - WATCH BEFORE INSTALLING
Урок 201.00:03:17
Now using GoormIDE instead of Cloud9
Урок 202.00:11:42
Mac Installation
Урок 203.00:03:33
Windows Installation
Урок 204.00:01:10
Section 3 Introduction
Урок 205.00:05:21
Creating Databases
Урок 206.00:01:47
Dropping Databases
Урок 207.00:03:01
Using Databases
Урок 208.00:05:10
Introduction to Tables
Урок 209.00:07:53
The Basic Datatypes
Урок 210.00:02:36
Basic Datatypes Challenge
Урок 211.00:00:00
Creating Your Own Tables
Урок 212.00:02:34
How Do We Know It Worked?
Урок 213.00:01:37
Dropping Tables
Урок 214.00:04:30
Creating Your Own Tables Challenge
Урок 215.00:01:41
Section 4 Introduction
Урок 216.00:05:04
Inserting Data
Урок 217.00:02:09
Super Quick Intro To SELECT
Урок 218.00:03:01
Multiple INSERT
Урок 219.00:01:36
INSERT Challenges
Урок 220.00:04:44
INSERT Challenges Solution
Урок 221.00:05:36
MySQL Warnings
Урок 222.00:06:55
NULL and NOT_NULL
Урок 223.00:07:18
Setting Default Values
Урок 224.00:12:22
A Primer On Primary Keys
Урок 225.00:01:52
Table Constraints Exercise
Урок 226.00:03:35
Table Constraints Exercise Solution
Урок 227.00:01:31
Section 5 Introduction
Урок 228.00:01:45
Introduction to CRUD
Урок 229.00:02:30
Preparing Our Data
Урок 230.00:04:19
Official Introduction to SELECT
Урок 231.00:05:06
Introduction to WHERE
Урок 232.00:02:01
SELECT Challenges
Урок 233.00:02:46
SELECT Challenges Solution
Урок 234.00:02:56
Introduction to Aliases
Урок 235.00:03:59
The UPDATE Command
Урок 236.00:00:38
UPDATE Challenges
Урок 237.00:03:59
UPDATE Challenges Solution
Урок 238.00:04:42
Introduction to DELETE
Урок 239.00:01:12
DELETE Challenges
Урок 240.00:02:46
DELETE Challenges Solution
Урок 241.00:01:53
Section 6 Introduction
Урок 242.00:07:27
CRUD Exercise Overview
Урок 243.00:05:56
CRUD Exercise Create Solution
Урок 244.00:01:49
CRUD Exercise Read Solution
Урок 245.00:04:11
CRUD Exercise Update Solution
Урок 246.00:03:22
CRUD Exercise Delete Solution
Урок 247.00:02:05
Section 7 Introduction
Урок 248.00:10:16
Running SQL Files
Урок 249.00:05:26
Loading Our Book Data
Урок 250.00:11:08
Working with CONCAT
Урок 251.00:10:05
Introducing SUBSTRING
Урок 252.00:06:40
Introducing REPLACE
Урок 253.00:03:40
Using REVERSE
Урок 254.00:04:55
Working with CHAR LENGTH
Урок 255.00:03:21
Changing Case with UPPER and LOWER
Урок 256.00:04:43
String Function Challenges
Урок 257.00:13:09
String Function Challenges Solution
Урок 258.00:00:36
Section 8 Introduction
Урок 259.00:02:48
Seed Data: Adding A Couple New Books
Урок 260.00:08:25
Using DISTINCT
Урок 261.00:11:20
Sorting Data with ORDER BY
Урок 262.00:09:04
Using LIMIT
Урок 263.00:07:43
Better Searches with LIKE
Урок 264.00:06:10
LIKE Part 2: More Wildcards
Урок 265.00:04:53
Refining Selections Exercises
Урок 266.00:12:30
Refining Selections Exercises Solution
Урок 267.00:03:57
Section 9 Introduction
Урок 268.00:08:39
The Count Function
Урок 269.00:12:23
The Joys of Group By
Урок 270.00:04:20
Note about SQL Mode only_full_group_by
Урок 271.00:04:13
Min and Max Basics
Урок 272.00:07:16
SUBQUERIES - A Problem with Min and Max
Урок 273.00:06:40
Using Min and Max with Group By
Урок 274.00:04:28
The Sum Function
Урок 275.00:06:01
The Avg Function
Урок 276.00:04:28
Aggregate Functions Challenges
Урок 277.00:09:11
Aggregate Functions Challenges Solution
Урок 278.00:01:57
Section 10 Introduction
Урок 279.00:14:30
CHAR and VARCHAR
Урок 280.00:06:09
DECIMAL
Урок 281.00:07:45
FLOAT and DOUBLE
Урок 282.00:04:32
DATE, TIME, and DATETIME
Урок 283.00:05:50
Creating Our DATE data
Урок 284.00:05:16
CURDATE, CURTIME, and NOW
Урок 285.00:14:30
Formatting Dates
Урок 286.00:09:41
Date Math
Урок 287.00:10:55
Working with TIMESTAMPS
Урок 288.00:04:51
Data Types Exercises
Урок 289.00:13:59
Data Types Exercises Solution
Урок 290.00:02:45
Section 11 Introduction
Урок 291.00:04:27
Not Equal
Урок 292.00:02:35
Not Like
Урок 293.00:10:05
Greater Than
Урок 294.00:03:49
Less Than
Урок 295.00:09:48
Logical AND
Урок 296.00:06:42
Logical OR
Урок 297.00:10:58
Between
Урок 298.00:11:48
In And Not In
Урок 299.00:11:22
Case Statements
Урок 300.00:06:46
Logical Operators Exercises
Урок 301.00:17:48
Logical Operators Exercises Solution
Урок 302.00:01:58
Section 12 Introduction
Урок 303.00:10:29
Real World Data Is Messy
Урок 304.00:04:38
Types of Data Relationships
Урок 305.00:12:34
One To Many: The Basics
Урок 306.00:12:05
Working With Foreign Keys
Урок 307.00:07:37
Cross Join
Урок 308.00:12:46
Inner Join
Урок 309.00:15:18
Left Join
Урок 310.00:10:37
Right Joins Pt 1
Урок 311.00:09:52
Right Joins Pt 2
Урок 312.00:03:10
Right and Left Joins: A Common Question
Урок 313.00:06:59
Our First Joins Exercise
Урок 314.00:09:11
Our First Joins Exercise SOLUTION
Урок 315.00:09:22
Our First Joins Exercise SOLUTION PT. 2
Урок 316.00:01:55
Section 13 Introduction
Урок 317.00:10:49
Many To Many Basics
Урок 318.00:10:58
Creating Our Tables
Урок 319.00:04:50
TV Joins Challenge 1
Урок 320.00:06:23
TV Joins Challenge 2
Урок 321.00:05:00
TV Joins Challenge 3
Урок 322.00:06:00
TV Joins Challenge 4
Урок 323.00:04:57
TV Joins Challenge 5
Урок 324.00:11:58
TV Joins Challenge 6
Урок 325.00:07:10
TV Joins Challenge 7
Урок 326.00:01:20
Section 14 Introduction
Урок 327.00:08:32
Introduction To Instagram Clone Schema
Урок 328.00:06:09
Cloning Instagram's DB: Users Schema
Урок 329.00:06:38
Cloning Instagram's DB: Photos Schema
Урок 330.00:06:40
Cloning Instagram's DB: Comments Schema
Урок 331.00:07:42
Cloning Instagram's DB: Likes Schema
Урок 332.00:07:21
Cloning Instagram's DB: Followers Schema
Урок 333.00:10:35
Cloning Instagram's DB: Hashtags Part 1
Урок 334.00:05:27
Cloning Instagram's DB: Hashtags Part 2
Урок 335.00:01:43
Section 15 Introduction
Урок 336.00:08:31
Loading The JUMBO dataset
Урок 337.00:04:54
Instagram Clone Challenge 1
Урок 338.00:06:42
Instagram Clone Challenge 2
Урок 339.00:07:23
Instagram Clone Challenge 3
Урок 340.00:07:06
Instagram Clone Challenge 4
Урок 341.00:03:14
Instagram Clone Challenge 5
Урок 342.00:05:30
Instagram Clone Challenge 6
Урок 343.00:05:16
Instagram Clone Challenge 7
Урок 344.00:01:37
Section 16 Introduction
Урок 345.00:09:00
MySQL and Other Languages
Урок 346.00:07:35
BUT WHAT ABOUT PHP
Урок 347.00:08:01
Introduction to JOIN US app
Урок 348.00:06:13
5 Minute NodeJS Crash Course
Урок 349.00:09:12
Introduction to NPM and Faker
Урок 350.00:04:54
Introducing the MySQL Package
Урок 351.00:12:47
Connecting Node to MySQL
Урок 352.00:06:55
Creating Our Users Table
Урок 353.00:06:16
Selecting Using Node
Урок 354.00:11:32
Inserting Using Node
Урок 355.00:07:42
Some MySQL/Node Magic
Урок 356.00:08:41
Bulk Inserting 500 Users - Finally!
Урок 357.00:02:31
500 Users Exercises
Урок 358.00:11:56
500 Users Exercises Solutions
Урок 359.00:01:53
Section 17 Introduction
Урок 360.00:05:41
Introducing Express
Урок 361.00:06:39
NPM Init and package.json files
Урок 362.00:16:34
Our First Simple Web App
Урок 363.00:09:57
Adding Multiple Routes
Урок 364.00:11:09
Connecting Express and MySQL
Урок 365.00:16:03
Adding EJS Templates
Урок 366.00:18:33
Connecting The Form
Урок 367.00:08:25
Styling Part 1
Урок 368.00:08:17
Styling Part 2
Урок 369.00:06:11
Introduction to Database Triggers
Урок 370.00:07:28
Writing Our First Trigger Part 1
Урок 371.00:11:37
Writing Our First Trigger Part 2
Урок 372.00:08:17
Preventing Instagram Self-Follows With Triggers
Урок 373.00:10:18
Creating Logger Triggers
Урок 374.00:06:13
Managing Triggers And A Warning