Section 1 : Introduction and 5 Minutes ofSQL
|
|
Lecture 1 | Course Introduction | 00:01:09 Duration |
|
|
Lecture 2 | Instructor Introduction(s) | 00:01:26 Duration |
|
|
Lecture 3 | Your First 5 Minutes of SQL - Let's Get Coding! | 00:06:13 Duration |
|
|
Lecture 4 | How The Course Works | 00:03:45 Duration |
Section 2 : Getting Started Overview and Installation
|
|
Lecture 1 | Section Introduction | 00:01:03 Duration |
|
|
Lecture 2 | What Is a Database | 00:07:16 Duration |
|
|
Lecture 3 | SQL Vs. MySQL | 00:05:51 Duration |
|
|
Lecture 4 | Installation Overview - WATCH BEFORE INSTALLING | 00:05:10 Duration |
|
|
Lecture 5 | Mac Installation | 00:11:27 Duration |
|
|
Lecture 6 | Windows Installation | 00:02:46 Duration |
Section 3 : Creating Databases and Tables
|
|
Lecture 1 | Section 3 Introduction | 00:01:10 Duration |
|
|
Lecture 2 | Creating Databases | 00:05:21 Duration |
|
|
Lecture 3 | Dropping Databases | 00:05:03 Duration |
|
|
Lecture 4 | Using Databases | 00:10:20 Duration |
|
|
Lecture 5 | Introduction to Tables | 00:05:09 Duration |
|
|
Lecture 6 | The Basic Datatypes | 00:07:52 Duration |
|
|
Lecture 7 | Basic Datatypes Challenge | 00:02:36 Duration |
|
|
Lecture 8 | Creating Your Own Tables | 00:03:07 Duration |
|
|
Lecture 9 | How Do We Know It Worked | 00:02:33 Duration |
|
|
Lecture 10 | Dropping Tables | 00:01:36 Duration |
|
|
Lecture 11 | Creating Your Own Tables Challenge | 00:04:30 Duration |
Section 4 : Inserting Data (and a couple other things)
|
|
Lecture 1 | Section 4 Introduction | 00:01:40 Duration |
|
|
Lecture 2 | Inserting Data | 00:05:03 Duration |
|
|
Lecture 3 | Super Quick Intro To SELECT | 00:02:08 Duration |
|
|
Lecture 4 | Multiple INSERT | 00:03:01 Duration |
|
|
Lecture 5 | INSERT Challenges | 00:01:36 Duration |
|
|
Lecture 6 | INSERT Challenges Solution | 00:04:44 Duration |
|
|
Lecture 7 | MySQL Warnings | 00:05:36 Duration |
|
|
Lecture 8 | NULL and NOT_NULL | 00:06:55 Duration |
|
|
Lecture 9 | Setting Default Values | 00:07:17 Duration |
|
|
Lecture 10 | A Primer On Primary Keys | 00:12:21 Duration |
|
|
Lecture 11 | Table Constraints Exercise | 00:01:51 Duration |
|
|
Lecture 12 | Table Constraints Exercise Solution |
Section 5 : CRUD commmands
|
|
Lecture 1 | Section 5 Introduction | 00:01:31 Duration |
|
|
Lecture 2 | Introduction to CRUD | 00:01:45 Duration |
|
|
Lecture 3 | Preparing Our Data | 00:02:29 Duration |
|
|
Lecture 4 | Official Introduction to SELECT | 00:04:18 Duration |
|
|
Lecture 5 | introduction to WHERE | 00:05:05 Duration |
|
|
Lecture 6 | SELECT Challenges | 00:02:01 Duration |
|
|
Lecture 7 | SELECT Challenges Solution | 00:02:46 Duration |
|
|
Lecture 8 | Introduction to Aliases | 00:02:55 Duration |
|
|
Lecture 9 | The UPDATE Command | 00:03:59 Duration |
|
|
Lecture 10 | UPDATE Challenges | 00:00:37 Duration |
|
|
Lecture 11 | UPDATE Challenges Solution | 00:03:59 Duration |
|
|
Lecture 12 | Introduction to DELETE | |
|
|
Lecture 13 | DELETE Challenges | 00:01:11 Duration |
|
|
Lecture 14 | DELETE Challenges Solution | 00:02:45 Duration |
Section 6 : CRUD Challenge Section
|
|
Lecture 1 | Section 6 Introduction | 00:01:53 Duration |
|
|
Lecture 2 | CRUD Exercise Overview | 00:07:27 Duration |
|
|
Lecture 3 | CRUD Exercise Create Solution | 00:05:55 Duration |
|
|
Lecture 4 | CRUD Exercise Read Solution | 00:01:48 Duration |
|
|
Lecture 5 | CRUD Exercise Update Solution | 00:04:11 Duration |
|
|
Lecture 6 | CRUD Exercise Delete Solution | 00:03:22 Duration |
Section 7 : The World Of String Functions
|
|
Lecture 1 | Section 7 Introduction | 00:02:04 Duration |
|
|
Lecture 2 | Running SQL Files | 00:10:16 Duration |
|
|
Lecture 3 | Loading Our Book Data | 00:05:25 Duration |
|
|
Lecture 4 | Working with CONCAT | 00:11:07 Duration |
|
|
Lecture 5 | Introducing SUBSTRING | 00:10:05 Duration |
|
|
Lecture 6 | Introducing REPLACE | 00:06:40 Duration |
|
|
Lecture 7 | Using REVERSE | 00:03:39 Duration |
|
|
Lecture 8 | Working with CHAR LENGTH | 00:04:55 Duration |
|
|
Lecture 9 | Changing Case with UPPER and LOWER | 00:03:20 Duration |
|
|
Lecture 10 | String Function Challenges | 00:04:43 Duration |
|
|
Lecture 11 | String Function Challenges Solution | 00:13:08 Duration |
Section 8 : Refining Our Selections
|
|
Lecture 1 | Section 8 Introduction | 00:00:36 Duration |
|
|
Lecture 2 | Seed Data- Adding A Couple New Books | 00:02:47 Duration |
|
|
Lecture 3 | Using DISTINCT | 00:08:25 Duration |
|
|
Lecture 4 | Sorting Data with ORDER BY | 00:11:19 Duration |
|
|
Lecture 5 | Using LIMIT | 00:09:04 Duration |
|
|
Lecture 6 | Better Searches with LIKE | 00:07:43 Duration |
|
|
Lecture 7 | LIKE Part 2- More Wildcards | 00:06:10 Duration |
|
|
Lecture 8 | Refining Selections Exercises | 00:04:52 Duration |
|
|
Lecture 9 | Refining Selections Exercises Solution | 00:12:30 Duration |
Section 9 : The Magic of Aggregate Functions
|
|
Lecture 1 | Section 9 Introduction | 00:03:57 Duration |
|
|
Lecture 2 | The Count Function | 00:08:39 Duration |
|
|
Lecture 3 | The Joys of Group By | 00:12:23 Duration |
|
|
Lecture 4 | Min and Max Basics | 00:12:23 Duration |
|
|
Lecture 5 | SUBQUERIES - A Problem with Min and Max | 00:07:15 Duration |
|
|
Lecture 6 | Using Min and Max with Group By | 00:06:40 Duration |
|
|
Lecture 7 | The Sum Function | 00:04:27 Duration |
|
|
Lecture 8 | The Avg Function | 00:06:00 Duration |
|
|
Lecture 9 | Aggregate Functions Challenges | 00:04:28 Duration |
|
|
Lecture 10 | Aggregate Functions Challenges Solution | 00:09:10 Duration |
Section 10 : Revisiting Data Types
|
|
Lecture 1 | Section 10 Introduction | 00:01:56 Duration |
|
|
Lecture 2 | CHAR and VARCHAR | 00:14:29 Duration |
|
|
Lecture 3 | DECIMAL | 00:06:08 Duration |
|
|
Lecture 4 | FLOAT and DOUBLE | |
|
|
Lecture 5 | DATE, TIME, and DATETIME | 00:04:31 Duration |
|
|
Lecture 6 | Creating Our DATE data | 00:05:49 Duration |
|
|
Lecture 7 | CURDATE, CURTIME, and NOW | 00:05:16 Duration |
|
|
Lecture 8 | Formatting Dates | 00:14:29 Duration |
|
|
Lecture 9 | Date Math | 00:09:40 Duration |
|
|
Lecture 10 | Working with TIMESTAMPS | 00:10:54 Duration |
|
|
Lecture 11 | Data Types Exercises | 00:04:50 Duration |
|
|
Lecture 12 | Data Types Exercises Solution | 00:13:58 Duration |
Section 11 : The Power of Logical Operators
|
|
Lecture 1 | Section 11 Introduction | 00:02:45 Duration |
|
|
Lecture 2 | Not Equal | 00:04:27 Duration |
|
|
Lecture 3 | Not Like | 00:02:34 Duration |
|
|
Lecture 4 | Greater Than | 00:10:04 Duration |
|
|
Lecture 5 | Less Than | 00:03:49 Duration |
|
|
Lecture 6 | Logical AND | 00:09:47 Duration |
|
|
Lecture 7 | Logical OR | 00:06:41 Duration |
|
|
Lecture 8 | Between | 00:10:58 Duration |
|
|
Lecture 9 | In And Not In | 00:11:47 Duration |
|
|
Lecture 10 | Case Statements | 00:11:21 Duration |
|
|
Lecture 11 | Logical Operators Exercises | 00:06:45 Duration |
|
|
Lecture 12 | Logical Operators Exercises Solution | 00:17:47 Duration |
Section 12 : Section 12 One To Many
|
|
Lecture 1 | Section 12 Introduction | 00:01:58 Duration |
|
|
Lecture 2 | Real World Data Is Messy | 00:10:28 Duration |
|
|
Lecture 3 | Types of Data Relationships | 00:04:37 Duration |
|
|
Lecture 4 | One To Many- The Basics | |
|
|
Lecture 5 | Working With Foreign Keys | 00:12:05 Duration |
|
|
Lecture 6 | Cross Join | 00:07:36 Duration |
|
|
Lecture 7 | Inner Join | 00:12:45 Duration |
|
|
Lecture 8 | Left Join | 00:15:18 Duration |
|
|
Lecture 9 | Right Joins Pt 1 | 00:10:37 Duration |
|
|
Lecture 10 | Right Joins Pt 2 | 00:09:52 Duration |
|
|
Lecture 11 | Right and Left Joins- A Common Question | 00:03:09 Duration |
|
|
Lecture 12 | Our First Joins Exercise | 00:06:59 Duration |
|
|
Lecture 13 | Our First Joins Exercise SOLUTION | 00:09:10 Duration |
|
|
Lecture 14 | Our First Joins Exercise SOLUTION PT. 2 | 00:09:21 Duration |
Section 13 : Section 13 Many To Many
|
|
Lecture 1 | Section 13 Introduction | 00:01:54 Duration |
|
|
Lecture 2 | Many To Many Basics | 00:10:48 Duration |
|
|
Lecture 3 | Creating Our Tables | 00:10:58 Duration |
|
|
Lecture 4 | TV Joins Challenge 1 | 00:04:49 Duration |
|
|
Lecture 5 | TV Joins Challenge 2 | 00:06:23 Duration |
|
|
Lecture 6 | TV Joins Challenge 3 | 00:05:00 Duration |
|
|
Lecture 7 | TV Joins Challenge 4 | 00:05:59 Duration |
|
|
Lecture 8 | TV Joins Challenge 5 | 00:04:56 Duration |
|
|
Lecture 9 | TV Joins Challenge 6 | 00:11:58 Duration |
|
|
Lecture 10 | TV Joins Challenge 7 | 00:07:09 Duration |
Section 14 : Instagram Database Clone
|
|
Lecture 1 | Section 14 Introduction | 00:01:20 Duration |
|
|
Lecture 2 | Introduction To Instagram Clone Schema | 00:08:32 Duration |
|
|
Lecture 3 | Cloning Instagram's DB- Users Schema | 00:06:08 Duration |
|
|
Lecture 4 | Cloning Instagram's DB- Photos Schema | 00:06:37 Duration |
|
|
Lecture 5 | Cloning Instagram's DB- Comments Schema | 00:06:39 Duration |
|
|
Lecture 6 | Cloning Instagram's DB- Likes Schema | |
|
|
Lecture 7 | Cloning Instagram's DB- Followers Schema | 00:07:20 Duration |
|
|
Lecture 8 | Cloning Instagram's DB- Hashtags Part 1 | 00:10:35 Duration |
|
|
Lecture 9 | Cloning Instagram's DB- Hashtags Part 2 | 00:05:26 Duration |
Section 15 : Working With Lots Of InstagramData
|
|
Lecture 1 | Section 15 Introduction | 00:01:42 Duration |
|
|
Lecture 2 | Loading The JUMBO dataset | 00:08:31 Duration |
|
|
Lecture 3 | Instagram Clone Challenge 1 | 00:04:53 Duration |
|
|
Lecture 4 | Instagram Clone Challenge 2 | 00:06:42 Duration |
|
|
Lecture 5 | Instagram Clone Challenge 3 | 00:07:22 Duration |
|
|
Lecture 6 | Instagram Clone Challenge 4 | 00:07:06 Duration |
|
|
Lecture 7 | Instagram Clone Challenge 5 | 00:03:13 Duration |
|
|
Lecture 8 | Instagram Clone Challenge 6 | 00:05:30 Duration |
|
|
Lecture 9 | Instagram Clone Challenge 7 | 00:05:15 Duration |
Section 16 : Section 16 Introducing Node
|
|
Lecture 1 | Section 16 Introduction | 00:01:37 Duration |
|
|
Lecture 2 | MySQL and Other Languages | 00:09:00 Duration |
|
|
Lecture 3 | BUT WHAT ABOUT PHP | 00:07:34 Duration |
|
|
Lecture 4 | Introduction to JOIN US app | 00:07:34 Duration |
|
|
Lecture 5 | 5 Minute NodeJS Crash Course | 00:06:13 Duration |
|
|
Lecture 6 | Introduction to NPM and Faker | 00:03:22 Duration |
|
|
Lecture 7 | Introducing the MySQL Package | 00:04:53 Duration |
|
|
Lecture 8 | Connecting Node to MySQL | 00:07:41 Duration |
|
|
Lecture 9 | Creating Our Users Table | 00:06:55 Duration |
|
|
Lecture 10 | Selecting Using Node | 00:06:16 Duration |
|
|
Lecture 11 | Inserting Using Node | 00:11:32 Duration |
|
|
Lecture 12 | Some MySQL-Node Magic | 00:07:41 Duration |
|
|
Lecture 13 | Bulk Inserting 500 Users - Finally | 00:08:40 Duration |
|
|
Lecture 14 | 500 Users Exercises | 00:02:30 Duration |
|
|
Lecture 15 | 500 Users Exercises Solutions | 00:06:39 Duration |
Section 17 : Section 17 Building Our WebApp
|
|
Lecture 1 | Section 17 Introduction | 00:01:53 Duration |
|
|
Lecture 2 | Introducing Express | 00:05:41 Duration |
|
|
Lecture 3 | NPM Init and package.json files | 00:06:39 Duration |
|
|
Lecture 4 | Our First Simple Web App | 00:16:34 Duration |
|
|
Lecture 5 | Adding Multiple Routes | 00:09:57 Duration |
|
|
Lecture 6 | Connecting Express and MySQL | 00:11:09 Duration |
|
|
Lecture 7 | Adding EJS Templates | 00:16:03 Duration |
|
|
Lecture 8 | Connecting The Form | 00:18:33 Duration |
|
|
Lecture 9 | Styling Part 1 | 00:08:24 Duration |
|
|
Lecture 10 | Styling Part 2 | 00:08:17 Duration |
Section 18 : Section 18 Database Triggers
|
|
Lecture 1 | Introduction to Database Triggers | 00:06:11 Duration |
|
|
Lecture 2 | Writing Our First Trigger Part 1 | 00:07:28 Duration |
|
|
Lecture 3 | Writing Our First Trigger Part 2 | 00:11:36 Duration |
|
|
Lecture 4 | Preventing Instagram Self-Follows With Triggers | 00:08:17 Duration |
|
|
Lecture 5 | Creating Logger Triggers | 00:10:18 Duration |
|
|
Lecture 6 | Managing Triggers And A Warning | 00:06:12 Duration |
