终极MySQL训练营: 从SQL初学者到专家 | The Ultimate MySQL Bootcamp: Go from SQL Be

星***

终极MySQL训练营 从SQL初学者到专家 The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert

├── 01 - Introduction & 5 Minutes of SQL
│　 ├── 001 This Course Was Just Updated!.mp4
│　 ├── 001 This Course Was Just Updated!.srt
│　 ├── 001 This Course Was Just Updated!_en.srt
│　 ├── 002 Join The Community!.html
│　 ├── 003 Course Intro.mp4
│　 ├── 003 Course Intro.srt
│　 ├── 003 Course Intro_en.srt
│　 ├── 004 About Me.mp4
│　 ├── 004 About Me.srt
│　 ├── 004 About Me_en.srt
│　 ├── 005 Getting The Course Code.mp4
│　 ├── 005 Getting The Course Code.srt
│　 ├── 005 Getting The Course Code_en.srt
│　 ├── 006 First 5 Minutes of SQL.mp4
│　 ├── 006 First 5 Minutes of SQL.srt
│　 ├── 006 First 5 Minutes of SQL_en.srt
│　 ├── 006 SLIDES.url
│　 ├── 006 SQL-Try-It-Editor.url
│　 └── external-links.txt
├── 02 - Getting Started & Installation
│　 ├── 001 Section Introduction.mp4
│　 ├── 001 Section Introduction.srt
│　 ├── 001 Section Introduction_en.srt
│　 ├── 002 SLIDES.url
│　 ├── 002 What Is A Database.mp4
│　 ├── 002 What Is A Database.srt
│　 ├── 002 What Is A Database_en.srt
│　 ├── 003 SQL vs. MySQL.mp4
│　 ├── 003 SQL vs. MySQL.srt
│　 ├── 003 SQL vs. MySQL_en.srt
│　 ├── 004 Installation START HERE!.mp4
│　 ├── 004 Installation START HERE!.srt
│　 ├── 004 Installation START HERE!_en.srt
│　 ├── 005 IMPORTANT NOTE Windows Installation Instructions.html
│　 ├── 006 Installation Windows Instructions.mp4
│　 ├── 006 Installation Windows Instructions.srt
│　 ├── 006 Installation Windows Instructions_en.srt
│　 ├── 006 Windows-MySQL-Installation.url
│　 ├── 007 VERY IMPORTANT Mac Installation Notes.html
│　 ├── 008 Installation Mac Instructions.mp4
│　 ├── 008 Installation Mac Instructions.srt
│　 ├── 008 Installation Mac Instructions_en.srt
│　 ├── 008 Mac-MySQL-Download.url
│　 ├── 008 MySQL-Workbench-Download.url
│　 ├── 008 OPTIONAL-dbGate-Download.url
│　 └── external-links.txt
├── 03 - Creating Databases & Tables
│　 ├── 001 Section Introduction.mp4
│　 ├── 001 Section Introduction.srt
│　 ├── 001 Section Introduction_en.srt
│　 ├── 002 SLIDES.url
│　 ├── 002 Showing Databases.mp4
│　 ├── 002 Showing Databases.srt
│　 ├── 002 Showing Databases_en.srt
│　 ├── 003 CODE Showing Databases.html
│　 ├── 004 Creating Databases.mp4
│　 ├── 004 Creating Databases.srt
│　 ├── 004 Creating Databases_en.srt
│　 ├── 005 CODE Creating Databases.html
│　 ├── 006 Dropping and Using Databases.mp4
│　 ├── 006 Dropping and Using Databases.srt
│　 ├── 006 Dropping and Using Databases_en.srt
│　 ├── 007 CODE Dropping and Using Databases.html
│　 ├── 008 Introducing Tables.mp4
│　 ├── 008 Introducing Tables.srt
│　 ├── 008 Introducing Tables_en.srt
│　 ├── 009 Data Types The Basics.mp4
│　 ├── 009 Data Types The Basics.srt
│　 ├── 009 Data Types The Basics_en.srt
│　 ├── 010 Basic Datatypes Challenge.mp4
│　 ├── 010 Basic Datatypes Challenge.srt
│　 ├── 010 Basic Datatypes Challenge_en.srt
│　 ├── 011 CODE Basic Datatypes Challenge.html
│　 ├── 012 Creating Tables.mp4
│　 ├── 012 Creating Tables.srt
│　 ├── 012 Creating Tables_en.srt
│　 ├── 013 CODE Creating Tables.html
│　 ├── 014 How Do We Know It Worked.mp4
│　 ├── 014 How Do We Know It Worked.srt
│　 ├── 014 How Do We Know It Worked_en.srt
│　 ├── 015 CODE How Do We Know It Worked.html
│　 ├── 016 Dropping Tables.mp4
│　 ├── 016 Dropping Tables.srt
│　 ├── 016 Dropping Tables_en.srt
│　 ├── 017 CODE Dropping Tables.html
│　 ├── 018 Tables Basics Activity.mp4
│　 ├── 018 Tables Basics Activity.srt
│　 ├── 018 Tables Basics Activity_en.srt
│　 ├── 019 SOLUTION Tables Basics Activity.html
│　 ├── 020 MySQL Comments.mp4
│　 ├── 020 MySQL Comments.srt
│　 ├── 020 MySQL Comments_en.srt
│　 └── external-links.txt
├── 04 - Inserting Data
│　 ├── 001 Section Introduction.mp4
│　 ├── 001 Section Introduction.srt
│　 ├── 001 Section Introduction_en.srt
│　 ├── 002 INSERT The Basics.mp4
│　 ├── 002 INSERT The Basics.srt
│　 ├── 002 INSERT The Basics_en.srt
│　 ├── 002 SLIDES.url
│　 ├── 003 CODE INSERT The Basics.html
│　 ├── 004 A Quick Preview of SELECT.mp4
│　 ├── 004 A Quick Preview of SELECT.srt
│　 ├── 004 A Quick Preview of SELECT_en.srt
│　 ├── 005 CODE A Quick Preview of SELECT.html
│　 ├── 006 Multi-inserts.mp4
│　 ├── 006 Multi-inserts.srt
│　 ├── 006 Multi-inserts_en.srt
│　 ├── 007 CODE Multi-inserts.html
│　 ├── 008 INSERT Exercise.mp4
│　 ├── 008 INSERT Exercise.srt
│　 ├── 008 INSERT Exercise_en.srt
│　 ├── 009 SOLUTION INSERT Exercise.html
│　 ├── 010 Working With NOT NULL.mp4
│　 ├── 010 Working With NOT NULL.srt
│　 ├── 010 Working With NOT NULL_en.srt
│　 ├── 011 CODE Working With NOT NULL.html
│　 ├── 012 Sidenote Quotes In MySQL.mp4
│　 ├── 012 Sidenote Quotes In MySQL.srt
│　 ├── 012 Sidenote Quotes In MySQL_en.srt
│　 ├── 013 Adding DEFAULT Values.mp4
│　 ├── 013 Adding DEFAULT Values.srt
│　 ├── 013 Adding DEFAULT Values_en.srt
│　 ├── 014 CODE Adding DEFAULT Values.html
│　 ├── 015 Introducing Primary Keys.mp4
│　 ├── 015 Introducing Primary Keys.srt
│　 ├── 015 Introducing Primary Keys_en.srt
│　 ├── 016 CODE Introducing Primary Keys.html
│　 ├── 017 Working With AUTO_INCREMENT.mp4
│　 ├── 017 Working With AUTO_INCREMENT.srt
│　 ├── 017 Working With AUTO_INCREMENT_en.srt
│　 ├── 018 CODE Working With AUTO_INCREMENT.html
│　 ├── 019 Create Table Insert Exercise.mp4
│　 ├── 019 Create Table Insert Exercise.srt
│　 ├── 019 Create Table Insert Exercise_en.srt
│　 ├── 020 SOLUTION Insert Exercise.html
│　 └── external-links.txt
├── 05 - CRUD Basics
│　 ├── 001 Section Introduction.mp4
│　 ├── 001 Section Introduction.srt
│　 ├── 001 Section Introduction_en.srt
│　 ├── 002 Introducing CRUD.mp4
│　 ├── 002 Introducing CRUD.srt
│　 ├── 002 Introducing CRUD_en.srt
│　 ├── 002 SLIDES.url
│　 ├── 003 Getting Our New Dataset.mp4
│　 ├── 003 Getting Our New Dataset.srt
│　 ├── 003 Getting Our New Dataset_en.srt
│　 ├── 004 CODE.html
│　 ├── 005 Officially Introducing SELECT.mp4
│　 ├── 005 Officially Introducing SELECT.srt
│　 ├── 005 Officially Introducing SELECT_en.srt
│　 ├── 006 CODE.html
│　 ├── 007 The WHERE clause.mp4
│　 ├── 007 The WHERE clause.srt
│　 ├── 007 The WHERE clause_en.srt
│　 ├── 008 CODE.html
│　 ├── 009 Rapid Fire Exercises.mp4
│　 ├── 009 Rapid Fire Exercises.srt
│　 ├── 009 Rapid Fire Exercises_en.srt
│　 ├── 010 Rapid Fire Exercises SOLUTION.mp4
│　 ├── 010 Rapid Fire Exercises SOLUTION.srt
│　 ├── 010 Rapid Fire Exercises SOLUTION_en.srt
│　 ├── 011 SOLUTION CODE.html
│　 ├── 012 Aliases.mp4
│　 ├── 012 Aliases.srt
│　 ├── 012 Aliases_en.srt
│　 ├── 013 CODE.html
│　 ├── 014 Using UPDATE.mp4
│　 ├── 014 Using UPDATE.srt
│　 ├── 014 Using UPDATE_en.srt
│　 ├── 015 CODE.html
│　 ├── 016 A Quick Rule Of Thumb.mp4
│　 ├── 016 A Quick Rule Of Thumb.srt
│　 ├── 016 A Quick Rule Of Thumb_en.srt
│　 ├── 017 UPDATE Exercise.mp4
│　 ├── 017 UPDATE Exercise.srt
│　 ├── 017 UPDATE Exercise_en.srt
│　 ├── 018 UPDATE Exercise SOLUTION.mp4
│　 ├── 018 UPDATE Exercise SOLUTION.srt
│　 ├── 018 UPDATE Exercise SOLUTION_en.srt
│　 ├── 019 SOLUTION CODE.html
│　 ├── 020 Introducing DELETE.mp4
│　 ├── 020 Introducing DELETE.srt
│　 ├── 020 Introducing DELETE_en.srt
│　 ├── 021 CODE.html
│　 ├── 022 DELETE Exercise.mp4
│　 ├── 022 DELETE Exercise.srt
│　 ├── 022 DELETE Exercise_en.srt
│　 ├── 023 DELETE Exercise SOLUTION.mp4
│　 ├── 023 DELETE Exercise SOLUTION.srt
│　 ├── 023 DELETE Exercise SOLUTION_en.srt
│　 ├── 024 SOLUTION CODE.html
│　 └── external-links.txt
├── 06 - CRUD Challenge
│　 ├── 001 Section Introduction.mp4
│　 ├── 001 Section Introduction.srt
│　 ├── 001 Section Introduction_en.srt
│　 ├── 002 Introducing the CRUD Challenge.mp4
│　 ├── 002 Introducing the CRUD Challenge.srt
│　 ├── 002 Introducing the CRUD Challenge_en.srt
│　 ├── 002 SLIDES.url
│　 ├── 003 CRUD Challenge Solution Creating.mp4
│　 ├── 003 CRUD Challenge Solution Creating.srt
│　 ├── 003 CRUD Challenge Solution Creating_en.srt
│　 ├── 004 SOLUTION CODE.html
│　 ├── 005 CRUD Challenge Solution Reading.mp4
│　 ├── 005 CRUD Challenge Solution Reading.srt
│　 ├── 005 CRUD Challenge Solution Reading_en.srt
│　 ├── 006 SOLUTION CODE.html
│　 ├── 007 CRUD Challenge Solution Updating.mp4
│　 ├── 007 CRUD Challenge Solution Updating.srt
│　 ├── 007 CRUD Challenge Solution Updating_en.srt
│　 ├── 008 SOLUTION CODE.html
│　 ├── 009 CRUD Challenge Solution Deleting.mp4
│　 ├── 009 CRUD Challenge Solution Deleting.srt
│　 ├── 009 CRUD Challenge Solution Deleting_en.srt
│　 ├── 010 SOLUTION CODE.html
│　 └── external-links.txt
├── 07 - String Functions
│　 ├── 001 Section Introduction.mp4
│　 ├── 001 Section Introduction.srt
│　 ├── 001 Section Introduction_en.srt
│　 ├── 002 MySQL-Docs-String-Functions.url
│　 ├── 002 SLIDES.url
│　 ├── 002 The World Of String Functions.mp4
│　 ├── 002 The World Of String Functions.srt
│　 ├── 002 The World Of String Functions_en.srt
│　 ├── 003 Loading Our Books Data.mp4
│　 ├── 003 Loading Our Books Data.srt
│　 ├── 003 Loading Our Books Data_en.srt
│　 ├── 003 book-data.sql
│　 ├── 004 CODE.html
│　 ├── 005 CONCAT.mp4
│　 ├── 005 CONCAT.srt
│　 ├── 005 CONCAT_en.srt
│　 ├── 006 CODE.html
│　 ├── 007 SUBSTRING.mp4
│　 ├── 007 SUBSTRING.srt
│　 ├── 007 SUBSTRING_en.srt
│　 ├── 008 CODE.html
│　 ├── 009 Combining String Functions.mp4
│　 ├── 009 Combining String Functions.srt
│　 ├── 009 Combining String Functions_en.srt
│　 ├── 010 CODE.html
│　 ├── 011 SQL-Formatter.url
│　 ├── 011 Sidenote SQL Formatting.mp4
│　 ├── 011 Sidenote SQL Formatting.srt
│　 ├── 011 Sidenote SQL Formatting_en.srt
│　 ├── 012 REPLACE.mp4
│　 ├── 012 REPLACE.srt
│　 ├── 012 REPLACE_en.srt
│　 ├── 013 CODE.html
│　 ├── 014 REVERSE.mp4
│　 ├── 014 REVERSE.srt
│　 ├── 014 REVERSE_en.srt
│　 ├── 015 CODE.html
│　 ├── 016 CHAR_LENGTH.mp4
│　 ├── 016 CHAR_LENGTH.srt
│　 ├── 016 CHAR_LENGTH_en.srt
│　 ├── 017 CODE.html
│　 ├── 018 UPPER & LOWER.mp4
│　 ├── 018 UPPER & LOWER.srt
│　 ├── 018 UPPER & LOWER_en.srt
│　 ├── 019 CODE.html
│　 ├── 020 Other String Functions.mp4
│　 ├── 020 Other String Functions.srt
│　 ├── 020 Other String Functions_en.srt
│　 ├── 021 CODE.html
│　 ├── 022 String Functions Exercise.mp4
│　 ├── 022 String Functions Exercise.srt
│　 ├── 022 String Functions Exercise_en.srt
│　 ├── 023 String Functions Exerise SOLUTION.mp4
│　 ├── 023 String Functions Exerise SOLUTION.srt
│　 ├── 023 String Functions Exerise SOLUTION_en.srt
│　 ├── 024 SOLUTION CODE.html
│　 └── external-links.txt
├── 08 - Refining Selections
│　 ├── 001 Section Introduction.mp4
│　 ├── 001 Section Introduction.srt
│　 ├── 001 Section Introduction_en.srt
│　 ├── 002 Adding Some New Books.mp4
│　 ├── 002 Adding Some New Books.srt
│　 ├── 002 Adding Some New Books_en.srt
│　 ├── 002 SLIDES.url
│　 ├── 003 CODE.html
│　 ├── 004 DISTINCT.mp4
│　 ├── 004 DISTINCT.srt
│　 ├── 004 DISTINCT_en.srt
│　 ├── 005 CODE.html
│　 ├── 006 ORDER BY.mp4
│　 ├── 006 ORDER BY.srt
│　 ├── 006 ORDER BY_en.srt
│　 ├── 007 CODE.html
│　 ├── 008 More On ORDER BY.mp4
│　 ├── 008 More On ORDER BY.srt
│　 ├── 008 More On ORDER BY_en.srt
│　 ├── 009 CODE.html
│　 ├── 010 LIMIT.mp4
│　 ├── 010 LIMIT.srt
│　 ├── 010 LIMIT_en.srt
│　 ├── 011 CODE.html
│　 ├── 012 LIKE.mp4
│　 ├── 012 LIKE.srt
│　 ├── 012 LIKE_en.srt
│　 ├── 013 CODE.html
│　 ├── 014 Escaping Wildcards.mp4
│　 ├── 014 Escaping Wildcards.srt
│　 ├── 014 Escaping Wildcards_en.srt
│　 ├── 015 CODE.html
│　 ├── 016 Refining Selections Exercise.mp4
│　 ├── 016 Refining Selections Exercise.srt
│　 ├── 016 Refining Selections Exercise_en.srt
│　 ├── 017 Refining Selections Exercise SOLUTION.mp4
│　 ├── 017 Refining Selections Exercise SOLUTION.srt
│　 ├── 017 Refining Selections Exercise SOLUTION_en.srt
│　 ├── 018 SOLUTION CODE.html
│　 └── external-links.txt
├── 09 - Aggregate Functions
│　 ├── 001 Section Introduction.mp4
│　 ├── 001 Section Introduction.srt
│　 ├── 001 Section Introduction_en.srt
│　 ├── 002 Count Basics.mp4
│　 ├── 002 Count Basics.srt
│　 ├── 002 Count Basics_en.srt
│　 ├── 002 SLIDES.url
│　 ├── 003 CODE.html
│　 ├── 004 GROUP BY.mp4
│　 ├── 004 GROUP BY.srt
│　 ├── 004 GROUP BY_en.srt
│　 ├── 005 CODE.html
│　 ├── 006 MIN and MAX Basics.mp4
│　 ├── 006 MIN and MAX Basics.srt
│　 ├── 006 MIN and MAX Basics_en.srt
│　 ├── 007 CODE.html
│　 ├── 008 Subqueries.mp4
│　 ├── 008 Subqueries.srt
│　 ├── 008 Subqueries_en.srt
│　 ├── 009 CODE.html
│　 ├── 010 Grouping By Multiple Columns.mp4
│　 ├── 010 Grouping By Multiple Columns.srt
│　 ├── 010 Grouping By Multiple Columns_en.srt
│　 ├── 011 CODE.html
│　 ├── 012 MIN and MAX With GROUP BY.mp4
│　 ├── 012 MIN and MAX With GROUP BY.srt
│　 ├── 012 MIN and MAX With GROUP BY_en.srt
│　 ├── 013 CODE.html
│　 ├── 014 SUM.mp4
│　 ├── 014 SUM.srt
│　 ├── 014 SUM_en.srt
│　 ├── 015 CODE.html
│　 ├── 016 AVG.mp4
│　 ├── 016 AVG.srt
│　 ├── 016 AVG_en.srt
│　 ├── 017 CODE.html
│　 ├── 018 Aggregate Functions Docs.mp4
│　 ├── 018 Aggregate Functions Docs.srt
│　 ├── 018 Aggregate Functions Docs_en.srt
│　 ├── 019 Agg Functions Exercise.mp4
│　 ├── 019 Agg Functions Exercise.srt
│　 ├── 019 Agg Functions Exercise_en.srt
│　 ├── 020 Agg Functions Exercise SOLUTION.mp4
│　 ├── 020 Agg Functions Exercise SOLUTION.srt
│　 ├── 020 Agg Functions Exercise SOLUTION_en.srt
│　 ├── 021 SOLUTION CODE.html
│　 └── external-links.txt
├── 10 - Revisiting Data Types
│　 ├── 001 Section Introduction.mp4
│　 ├── 001 Section Introduction.srt
│　 ├── 001 Section Introduction_en.srt
│　 ├── 002 Data-Types-Reference.url
│　 ├── 002 SLIDES.url
│　 ├── 002 Surveying Other Data Types.mp4
│　 ├── 002 Surveying Other Data Types.srt
│　 ├── 002 Surveying Other Data Types_en.srt
│　 ├── 003 CHAR vs. VARCHAR.mp4
│　 ├── 003 CHAR vs. VARCHAR.srt
│　 ├── 003 CHAR vs. VARCHAR_en.srt
│　 ├── 004 INT, TINYINT, BIGINT, etc.mp4
│　 ├── 004 INT, TINYINT, BIGINT, etc.mp4.part-Frag40.aria2
│　 ├── 004 INT, TINYINT, BIGINT, etc.mp4.part-Frag45.aria2
│　 ├── 004 INT, TINYINT, BIGINT, etc.mp4.part-Frag46.aria2
│　 ├── 004 INT, TINYINT, BIGINT, etc.mp4.part-Frag47.aria2
│　 ├── 004 INT, TINYINT, BIGINT, etc.mp4.part-Frag48.aria2
│　 ├── 004 INT, TINYINT, BIGINT, etc.srt
│　 ├── 004 INT, TINYINT, BIGINT, etc_en.srt
│　 ├── 005 DECIMAL.mp4
│　 ├── 005 DECIMAL.srt
│　 ├── 005 DECIMAL_en.srt
│　 ├── 006 FLOAT & DOUBLE.mp4
│　 ├── 006 FLOAT & DOUBLE.srt
│　 ├── 006 FLOAT & DOUBLE_en.srt
│　 ├── 007 DATE and TIME.mp4
│　 ├── 007 DATE and TIME.srt
│　 ├── 007 DATE and TIME_en.srt
│　 ├── 008 Working With Dates.mp4
│　 ├── 008 Working With Dates.srt
│　 ├── 008 Working With Dates_en.srt
│　 ├── 009 CODE.html
│　 ├── 010 CURDATE, CURTIME, & NOW.mp4
│　 ├── 010 CURDATE, CURTIME, & NOW.srt
│　 ├── 010 CURDATE, CURTIME, & NOW_en.srt
│　 ├── 011 CODE.html
│　 ├── 012 Date Functions.mp4
│　 ├── 012 Date Functions.srt
│　 ├── 012 Date Functions_en.srt
│　 ├── 013 CODE.html
│　 ├── 014 Time Functions.mp4
│　 ├── 014 Time Functions.srt
│　 ├── 014 Time Functions_en.srt
│　 ├── 015 CODE.html
│　 ├── 016 Formatting Dates.mp4
│　 ├── 016 Formatting Dates.srt
│　 ├── 016 Formatting Dates_en.srt
│　 ├── 017 CODE.html
│　 ├── 018 Date Math.mp4
│　 ├── 018 Date Math.srt
│　 ├── 018 Date Math_en.srt
│　 ├── 019 TIMESTAMPS.mp4
│　 ├── 019 TIMESTAMPS.srt
│　 ├── 019 TIMESTAMPS_en.srt
│　 ├── 020 DEFAULT & ON UPDATE TIMESTAMPS.mp4
│　 ├── 020 DEFAULT & ON UPDATE TIMESTAMPS.srt
│　 ├── 020 DEFAULT & ON UPDATE TIMESTAMPS_en.srt
│　 ├── 021 CODE.html
│　 ├── 022 Data Types Exercise.mp4
│　 ├── 022 Data Types Exercise.srt
│　 ├── 022 Data Types Exercise_en.srt
│　 ├── 023 Data Types Exercise SOLUTION.mp4
│　 ├── 023 Data Types Exercise SOLUTION.srt
│　 ├── 023 Data Types Exercise SOLUTION_en.srt
│　 ├── 024 SOLUTION CODE.html
│　 └── external-links.txt
├── 11 - Comparison & Logical Operators
│　 ├── 001 Section Introduction.mp4
│　 ├── 001 Section Introduction.srt
│　 ├── 001 Section Introduction_en.srt
│　 ├── 002 Not Equal.mp4
│　 ├── 002 Not Equal.srt
│　 ├── 002 Not Equal_en.srt
│　 ├── 002 SLIDES.url
│　 ├── 003 CODE.html
│　 ├── 004 NOT LIKE.mp4
│　 ├── 004 NOT LIKE.srt
│　 ├── 004 NOT LIKE_en.srt
│　 ├── 005 CODE.html
│　 ├── 006 Greater Than.mp4
│　 ├── 006 Greater Than.srt
│　 ├── 006 Greater Than_en.srt
│　 ├── 007 CODE.html
│　 ├── 008 Less Than Or Equal To.mp4
│　 ├── 008 Less Than Or Equal To.srt
│　 ├── 008 Less Than Or Equal To_en.srt
│　 ├── 009 CODE.html
│　 ├── 010 Logical AND.mp4
│　 ├── 010 Logical AND.srt
│　 ├── 010 Logical AND_en.srt
│　 ├── 011 CODE.html
│　 ├── 012 Logical OR.mp4
│　 ├── 012 Logical OR.srt
│　 ├── 012 Logical OR_en.srt
│　 ├── 013 CODE.html
│　 ├── 014 Between.mp4
│　 ├── 014 Between.srt
│　 ├── 014 Between_en.srt
│　 ├── 015 CODE.html
│　 ├── 016 Comparing Dates.mp4
│　 ├── 016 Comparing Dates.srt
│　 ├── 016 Comparing Dates_en.srt
│　 ├── 017 CODE.html
│　 ├── 018 The IN Operator.mp4
│　 ├── 018 The IN Operator.srt
│　 ├── 018 The IN Operator_en.srt
│　 ├── 019 CODE.html
│　 ├── 020 CASE.mp4
│　 ├── 020 CASE.srt
│　 ├── 020 CASE_en.srt
│　 ├── 021 CODE.html
│　 ├── 022 IS NULL.mp4
│　 ├── 022 IS NULL.srt
│　 ├── 022 IS NULL_en.srt
│　 ├── 023 Exercise.mp4
│　 ├── 023 Exercise.srt
│　 ├── 023 Exercise_en.srt
│　 ├── 024 Exercise SOLUTION.mp4
│　 ├── 024 Exercise SOLUTION.srt
│　 ├── 024 Exercise SOLUTION_en.srt
│　 ├── 025 SOLUTION CODE.html
│　 └── external-links.txt
├── 12 - Constraints　& ALTER TABLE
│　 ├── 001 SLIDES.url
│　 ├── 001 UNIQUE Constraint.mp4
│　 ├── 001 UNIQUE Constraint.srt
│　 ├── 001 UNIQUE Constraint_en.srt
│　 ├── 002 CODE.html
│　 ├── 003 CHECK Constraints.mp4
│　 ├── 003 CHECK Constraints.srt
│　 ├── 003 CHECK Constraints_en.srt
│　 ├── 004 CODE.html
│　 ├── 005 Named Constraints.mp4
│　 ├── 005 Named Constraints.srt
│　 ├── 005 Named Constraints_en.srt
│　 ├── 006 CODE.html
│　 ├── 007 Multiple Column Constraints.mp4
│　 ├── 007 Multiple Column Constraints.srt
│　 ├── 007 Multiple Column Constraints_en.srt
│　 ├── 008 CODE.html
│　 ├── 009 ALTER TABLE　Adding Columns.mp4
│　 ├── 009 ALTER TABLE　Adding Columns.srt
│　 ├── 009 ALTER TABLE　Adding Columns_en.srt
│　 ├── 010 CODE.html
│　 ├── 011 ALTER TABLE　Dropping Columns.mp4
│　 ├── 011 ALTER TABLE　Dropping Columns.srt
│　 ├── 011 ALTER TABLE　Dropping Columns_en.srt
│　 ├── 012 CODE.html
│　 ├── 013 ALTER TABLE　Renaming.mp4
│　 ├── 013 ALTER TABLE　Renaming.srt
│　 ├── 013 ALTER TABLE　Renaming_en.srt
│　 ├── 014 CODE.html
│　 ├── 015 ALTER TABLE　Modifying Columns.mp4
│　 ├── 015 ALTER TABLE　Modifying Columns.srt
│　 ├── 015 ALTER TABLE　Modifying Columns_en.srt
│　 ├── 016 CODE.html
│　 ├── 017 ALTER TABLE　Constraints.mp4
│　 ├── 017 ALTER TABLE　Constraints.srt
│　 ├── 017 ALTER TABLE　Constraints_en.srt
│　 ├── 018 CODE.html
│　 └── external-links.txt
├── 13 - One to Many & Joins
│　 ├── 001 Section Introduction.mp4
│　 ├── 001 Section Introduction.srt
│　 ├── 001 Section Introduction_en.srt
│　 ├── 002 Data is Messy.mp4
│　 ├── 002 Data is Messy.srt
│　 ├── 002 Data is Messy_en.srt
│　 ├── 002 SLIDES.url
│　 ├── 003 Relationships Basics.mp4
│　 ├── 003 Relationships Basics.srt
│　 ├── 003 Relationships Basics_en.srt
│　 ├── 004 One to Many Relationship.mp4
│　 ├── 004 One to Many Relationship.srt
│　 ├── 004 One to Many Relationship_en.srt
│　 ├── 005 Working with FOREIGN KEY.mp4
│　 ├── 005 Working with FOREIGN KEY.srt
│　 ├── 005 Working with FOREIGN KEY_en.srt
│　 ├── 006 CODE.html
│　 ├── 007 Cross Joins.mp4
│　 ├── 007 Cross Joins.srt
│　 ├── 007 Cross Joins_en.srt
│　 ├── 008 CODE.html
│　 ├── 009 Inner Joins.mp4
│　 ├── 009 Inner Joins.srt
│　 ├── 009 Inner Joins_en.srt
│　 ├── 010 CODE.html
│　 ├── 011 Inner Joins With Group By.mp4
│　 ├── 011 Inner Joins With Group By.srt
│　 ├── 011 Inner Joins With Group By_en.srt
│　 ├── 012 CODE.html
│　 ├── 013 Left Join.mp4
│　 ├── 013 Left Join.srt
│　 ├── 013 Left Join_en.srt
│　 ├── 014 CODE.html
│　 ├── 015 Left Join With Group By.mp4
│　 ├── 015 Left Join With Group By.srt
│　 ├── 015 Left Join With Group By_en.srt
│　 ├── 016 CODE.html
│　 ├── 017 Right Join.mp4
│　 ├── 017 Right Join.srt
│　 ├── 017 Right Join_en.srt
│　 ├── 018 CODE.html
│　 ├── 019 On Delete Cascade.mp4
│　 ├── 019 On Delete Cascade.srt
│　 ├── 019 On Delete Cascade_en.srt
│　 ├── 020 CODE.html
│　 ├── 021 Joins Exercise.mp4
│　 ├── 021 Joins Exercise.srt
│　 ├── 021 Joins Exercise_en.srt
│　 ├── 022 EXERCISE STARTER DATA.html
│　 ├── 023 Joins Exercise SOLUTION.mp4
│　 ├── 023 Joins Exercise SOLUTION.srt
│　 ├── 023 Joins Exercise SOLUTION_en.srt
│　 ├── 024 SOLUTION CODE.html
│　 └── external-links.txt
├── 14 - Many to Many
│　 ├── 001 Section Introduction.mp4
│　 ├── 001 Section Introduction.srt
│　 ├── 001 Section Introduction_en.srt
│　 ├── 002 Many to Many Basics.mp4
│　 ├── 002 Many to Many Basics.srt
│　 ├── 002 Many to Many Basics_en.srt
│　 ├── 002 SLIDES.url
│　 ├── 003 Creating Our Many To Many Tables.mp4
│　 ├── 003 Creating Our Many To Many Tables.srt
│　 ├── 003 Creating Our Many To Many Tables_en.srt
│　 ├── 004 CODE.html
│　 ├── 005 TV Series Challenge #1.mp4
│　 ├── 005 TV Series Challenge #1.srt
│　 ├── 005 TV Series Challenge #1_en.srt
│　 ├── 006 CODE.html
│　 ├── 007 TV Series Challenge #2.mp4
│　 ├── 007 TV Series Challenge #2.srt
│　 ├── 007 TV Series Challenge #2_en.srt
│　 ├── 008 CODE.html
│　 ├── 009 TV Series Challenge #3.mp4
│　 ├── 009 TV Series Challenge #3.srt
│　 ├── 009 TV Series Challenge #3_en.srt
│　 ├── 010 CODE.html
│　 ├── 011 TV Series Challenge #4.mp4
│　 ├── 011 TV Series Challenge #4.srt
│　 ├── 011 TV Series Challenge #4_en.srt
│　 ├── 012 CODE.html
│　 ├── 013 TV Series Challenge #5.mp4
│　 ├── 013 TV Series Challenge #5.srt
│　 ├── 013 TV Series Challenge #5_en.srt
│　 ├── 014 CODE.html
│　 ├── 015 TV Series Challenge #6.mp4
│　 ├── 015 TV Series Challenge #6.srt
│　 ├── 015 TV Series Challenge #6_en.srt
│　 ├── 016 CODE.html
│　 ├── 017 TV Series Challenge #7.mp4
│　 ├── 017 TV Series Challenge #7.srt
│　 ├── 017 TV Series Challenge #7_en.srt
│　 ├── 018 CODE.html
│　 └── external-links.txt
├── 15 - Views, Modes, & More!
│　 ├── 001 Introducing Views.mp4
│　 ├── 001 Introducing Views.srt
│　 ├── 001 Introducing Views_en.srt
│　 ├── 002 CODE.html
│　 ├── 003 Updateable Views.mp4
│　 ├── 003 Updateable Views.srt
│　 ├── 003 Updateable Views_en.srt
│　 ├── 004 ReplacingAltering Views.mp4
│　 ├── 004 ReplacingAltering Views.srt
│　 ├── 004 ReplacingAltering Views_en.srt
│　 ├── 005 CODE.html
│　 ├── 006 HAVING clause.mp4
│　 ├── 006 HAVING clause.srt
│　 ├── 006 HAVING clause_en.srt
│　 ├── 007 CODE.html
│　 ├── 008 WITH ROLLUP.mp4
│　 ├── 008 WITH ROLLUP.srt
│　 ├── 008 WITH ROLLUP_en.srt
│　 ├── 009 CODE.html
│　 ├── 010 SQL Modes Basics.mp4
│　 ├── 010 SQL Modes Basics.srt
│　 ├── 010 SQL Modes Basics_en.srt
│　 ├── 011 CODE.html
│　 ├── 012 STRICT_TRANS_TABLES.mp4
│　 ├── 012 STRICT_TRANS_TABLES.srt
│　 ├── 012 STRICT_TRANS_TABLES_en.srt
│　 ├── 013 More Modes.mp4
│　 ├── 013 More Modes.srt
│　 └── 013 More Modes_en.srt
├── 16 - Window Functions
│　 ├── 001 Important Note (please read).html
│　 ├── 002 Introducing Window Functions.mp4
│　 ├── 002 Introducing Window Functions.srt
│　 ├── 002 Introducing Window Functions_en.srt
│　 ├── 002 SLIDES.url
│　 ├── 003 Using OVER().mp4
│　 ├── 003 Using OVER().srt
│　 ├── 003 Using OVER()_en.srt
│　 ├── 004 CODE.html
│　 ├── 005 PARTITION BY.mp4
│　 ├── 005 PARTITION BY.srt
│　 ├── 005 PARTITION BY_en.srt
│　 ├── 006 CODE.html
│　 ├── 007 ORDER BY with Windows.mp4
│　 ├── 007 ORDER BY with Windows.srt
│　 ├── 007 ORDER BY with Windows_en.srt
│　 ├── 008 CODE.html
│　 ├── 009 RANK().mp4
│　 ├── 009 RANK().srt
│　 ├── 009 RANK()_en.srt
│　 ├── 010 DENSE_RANK, & ROW_NUMBER().mp4
│　 ├── 010 DENSE_RANK, & ROW_NUMBER().srt
│　 ├── 010 DENSE_RANK, & ROW_NUMBER()_en.srt
│　 ├── 011 CODE.html
│　 ├── 012 NTILE().mp4
│　 ├── 012 NTILE().srt
│　 ├── 012 NTILE()_en.srt
│　 ├── 013 CODE.html
│　 ├── 014 FIRST_VALUE.mp4
│　 ├── 014 FIRST_VALUE.srt
│　 ├── 014 FIRST_VALUE_en.srt
│　 ├── 015 CODE.html
│　 ├── 016 LEAD and LAG.mp4
│　 ├── 016 LEAD and LAG.srt
│　 ├── 016 LEAD and LAG_en.srt
│　 ├── 017 CODE.html
│　 └── external-links.txt
├── 17 - Instagram Database Clone
│　 ├── 001 Section Introduction.mp4
│　 ├── 001 Section Introduction.srt
│　 ├── 001 Section Introduction_en.srt
│　 ├── 002 IMPORTANT NOTE ABOUT THIS SECTION!.mp4
│　 ├── 002 IMPORTANT NOTE ABOUT THIS SECTION!.srt
│　 ├── 002 IMPORTANT NOTE ABOUT THIS SECTION!_en.srt
│　 ├── 003 Introducing Instagram Clone.mp4
│　 ├── 003 Introducing Instagram Clone.srt
│　 ├── 003 Introducing Instagram Clone_en.srt
│　 ├── 003 SLIDES.url
│　 ├── 004 Users Schema.mp4
│　 ├── 004 Users Schema.srt
│　 ├── 004 Users Schema_en.srt
│　 ├── 005 CODE.html
│　 ├── 006 Photos Schema.mp4
│　 ├── 006 Photos Schema.srt
│　 ├── 006 Photos Schema_en.srt
│　 ├── 007 CODE.html
│　 ├── 008 Comments Schema.mp4
│　 ├── 008 Comments Schema.srt
│　 ├── 008 Comments Schema_en.srt
│　 ├── 009 CODE.html
│　 ├── 010 Likes Schema.mp4
│　 ├── 010 Likes Schema.srt
│　 ├── 010 Likes Schema_en.srt
│　 ├── 011 CODE.html
│　 ├── 012 Followers Schema.mp4
│　 ├── 012 Followers Schema.srt
│　 ├── 012 Followers Schema_en.srt
│　 ├── 013 CODE.html
│　 ├── 014 Note!.html
│　 ├── 015 3 Approaches for Hashtags.mp4
│　 ├── 015 3 Approaches for Hashtags.srt
│　 ├── 015 3 Approaches for Hashtags_en.srt
│　 ├── 016 Implementing Hashtags Table.mp4
│　 ├── 016 Implementing Hashtags Table.srt
│　 ├── 016 Implementing Hashtags Table_en.srt
│　 ├── 017 CODE.html
│　 ├── 018 Complete Instagram Schema.html
│　 └── external-links.txt
├── 18 - Working With Lots of IG Data
│　 ├── 001 Section Introduction.mp4
│　 ├── 001 Section Introduction.srt
│　 ├── 001 Section Introduction_en.srt
│　 ├── 002 Getting Lots of Instagram Data.mp4
│　 ├── 002 Getting Lots of Instagram Data.srt
│　 ├── 002 Getting Lots of Instagram Data_en.srt
│　 ├── 003 CODE.html
│　 ├── 003 ig-clone-data.sql
│　 ├── 004 Instagram Challenge #1.mp4
│　 ├── 004 Instagram Challenge #1.srt
│　 ├── 004 Instagram Challenge #1_en.srt
│　 ├── 005 CODE.html
│　 ├── 006 Instagram Challenge #2.mp4
│　 ├── 006 Instagram Challenge #2.srt
│　 ├── 006 Instagram Challenge #2_en.srt
│　 ├── 007 CODE.html
│　 ├── 008 Instagram Challenge #3.mp4
│　 ├── 008 Instagram Challenge #3.srt
│　 ├── 008 Instagram Challenge #3_en.srt
│　 ├── 009 CODE.html
│　 ├── 010 Instagram Challenge #4.mp4
│　 ├── 010 Instagram Challenge #4.srt
│　 ├── 010 Instagram Challenge #4_en.srt
│　 ├── 011 CODE.html
│　 ├── 012 Instagram Challenge #5.mp4
│　 ├── 012 Instagram Challenge #5.srt
│　 ├── 012 Instagram Challenge #5_en.srt
│　 ├── 013 CODE.html
│　 ├── 014 Instagram Challenge #6.mp4
│　 ├── 014 Instagram Challenge #6.srt
│　 ├── 014 Instagram Challenge #6_en.srt
│　 ├── 015 CODE.html
│　 ├── 016 Instagram Challenge #7.mp4
│　 ├── 016 Instagram Challenge #7.srt
│　 ├── 016 Instagram Challenge #7_en.srt
│　 └── 017 CODE.html
├── 19 - What Next
│　 └── 001 Additional SQL Resources.html
├── 20 - OPTIONAL LEGACY SECTION Introducing Node
│　 ├── 001 IMPORTANT NOTE Using a Local Coding Environment Instead of Cloud9.html
│　 ├── 002 IMPORTANT NOTE Downloading Source Code.html
│　 ├── 002 node-and-mysql.zip
│　 ├── 003 Section Introduction.mp4
│　 ├── 003 Section Introduction.srt
│　 ├── 003 Section Introduction_en.srt
│　 ├── 004 MySQL and Other Languages.mp4
│　 ├── 004 MySQL and Other Languages.srt
│　 ├── 004 MySQL and Other Languages_en.srt
│　 ├── 004 Slides-For-This-Section.url
│　 ├── 005 BUT WHAT ABOUT PHP.mp4
│　 ├── 005 BUT WHAT ABOUT PHP.srt
│　 ├── 005 BUT WHAT ABOUT PHP_en.srt
│　 ├── 006 Introduction to JOIN US app.mp4
│　 ├── 006 Introduction to JOIN US app.srt
│　 ├── 006 Introduction to JOIN US app_en.srt
│　 ├── 007 REMINDER NodeJS Installation.html
│　 ├── 008 5 Minute NodeJS Crash Course.mp4
│　 ├── 008 5 Minute NodeJS Crash Course.srt
│　 ├── 008 5 Minute NodeJS Crash Course_en.srt
│　 ├── 009 CODE 5 Minute Node Crash Course.html
│　 ├── 010 IMPORTANT NOTE About the Faker Package.html
│　 ├── 011 Introduction to NPM and Faker.mp4
│　 ├── 011 Introduction to NPM and Faker.srt
│　 ├── 011 Introduction to NPM and Faker_en.srt
│　 ├── 012 UPDATED CODE Introduction to NPM and Faker.html
│　 ├── 013 Introducing the MySQL Package.mp4
│　 ├── 013 Introducing the MySQL Package.srt
│　 ├── 013 Introducing the MySQL Package_en.srt
│　 ├── 013 MySQL-Node-Package-Github-Repo.url
│　 ├── 014 IMPORTANT NOTE About the MySQL Package and Connecting Node to MySQL.html
│　 ├── 015 REMINDER How to Start the MySQL Command Line Locally (instead of Cloud9).html
│　 ├── 016 Connecting Node to MySQL.mp4
│　 ├── 016 Connecting Node to MySQL.srt
│　 ├── 016 Connecting Node to MySQL_en.srt
│　 ├── 017 CODE Connecting Node to MySQL.html
│　 ├── 018 Creating Our Users Table.mp4
│　 ├── 018 Creating Our Users Table.srt
│　 ├── 018 Creating Our Users Table_en.srt
│　 ├── 019 CODE Creating Our Users Table.html
│　 ├── 020 Selecting Using Node.mp4
│　 ├── 020 Selecting Using Node.srt
│　 ├── 020 Selecting Using Node_en.srt
│　 ├── 021 CODE Selecting Using Node.html
│　 ├── 022 Inserting Using Node.mp4
│　 ├── 022 Inserting Using Node.srt
│　 ├── 022 Inserting Using Node_en.srt
│　 ├── 023 CODE Inserting Using Node.html
│　 ├── 024 Some MySQLNode Magic.mp4
│　 ├── 024 Some MySQLNode Magic.srt
│　 ├── 024 Some MySQLNode Magic_en.srt
│　 ├── 025 Bulk Inserting 500 Users - Finally!.mp4
│　 ├── 025 Bulk Inserting 500 Users - Finally!.srt
│　 ├── 025 Bulk Inserting 500 Users - Finally!_en.srt
│　 ├── 026 CODE Bulk Inserting 500 Users.html
│　 ├── 027 500 Users Exercises.mp4
│　 ├── 027 500 Users Exercises.srt
│　 ├── 027 500 Users Exercises_en.srt
│　 ├── 027 Slides.url
│　 ├── 028 500 Users Exercises Solutions.mp4
│　 ├── 028 500 Users Exercises Solutions.srt
│　 ├── 028 500 Users Exercises Solutions_en.srt
│　 ├── 029 CODE 500 Users Exercises Solutions.html
│　 └── external-links.txt
├── 21 - OPTIONAL LEGACY SECTION　Building Our Web App
│　 ├── 001 REMINDER Set Up A Local Coding Environment Instead of Cloud9.html
│　 ├── 002 Section Introduction.mp4
│　 ├── 002 Section Introduction.srt
│　 ├── 002 Section Introduction_en.srt
│　 ├── 003 Join Us Completed CODE.html
│　 ├── 003 JoinUsCompleteCode.zip
│　 ├── 004 Express-Documentation.url
│　 ├── 004 Introducing Express.mp4
│　 ├── 004 Introducing Express.srt
│　 ├── 004 Introducing Express_en.srt
│　 ├── 004 Slides.url
│　 ├── 005 NPM Init and package.json files.mp4
│　 ├── 005 NPM Init and package.json files.srt
│　 ├── 005 NPM Init and package.json files_en.srt
│　 ├── 006 IMPORTANT NOTE About Previewing Our Node Web App in the Browser.html
│　 ├── 007 Our First Simple Web App.mp4
│　 ├── 007 Our First Simple Web App.srt
│　 ├── 007 Our First Simple Web App_en.srt
│　 ├── 008 CODE Our First Simple Web App.html
│　 ├── 009 Adding Multiple Routes.mp4
│　 ├── 009 Adding Multiple Routes.srt
│　 ├── 009 Adding Multiple Routes_en.srt
│　 ├── 010 CODE Adding Multiple Routes.html
│　 ├── 011 REMINDER Use the Updated Connection Code.html
│　 ├── 012 Connecting Express and MySQL.mp4
│　 ├── 012 Connecting Express and MySQL.srt
│　 ├── 013 CODE Connecting Express and MySQL.html
│　 ├── 014 Adding EJS Templates.mp4
│　 ├── 014 Adding EJS Templates.srt
│　 ├── 014 Adding EJS Templates_en.srt
│　 ├── 015 CODE Adding EJS Templates.html
│　 ├── 015 JOIN-US-HTML-AND-CSS.zip
│　 ├── 016 Connecting The Form.mp4
│　 ├── 016 Connecting The Form.srt
│　 ├── 016 Connecting The Form_en.srt
│　 ├── 017 CODE Connecting the Form.html
│　 ├── 018 Styling Part 1.mp4
│　 ├── 018 Styling Part 1.srt
│　 ├── 018 Styling Part 1_en.srt
│　 ├── 019 CODE HTML AND CSS FILES.html
│　 ├── 019 JOIN-US-HTML-AND-CSS.zip
│　 ├── 020 Styling Part 2.mp4
│　 ├── 020 Styling Part 2.srt
│　 ├── 020 Styling Part 2_en.srt
│　 └── external-links.txt
└── 22 - OPTIONAL LEGACY SECTION Database Triggers
　　├── 001 NOTE Use MySQL Locally Instead of Cloud9.html
　　├── 002 Introduction to Database Triggers.mp4
　　├── 002 Introduction to Database Triggers.srt
　　├── 002 Introduction to Database Triggers_en.srt
　　├── 002 Lecture-Slides.url
　　├── 003 Lecture-Slides.url
　　├── 003 Writing Our First Trigger Part 1.mp4
　　├── 003 Writing Our First Trigger Part 1.srt
　　├── 003 Writing Our First Trigger Part 1_en.srt
　　├── 004 Lecture-Slides.url
　　├── 004 Writing Our First Trigger Part 2.mp4
　　├── 004 Writing Our First Trigger Part 2.srt
　　├── 004 Writing Our First Trigger Part 2_en.srt
　　├── 005 NOTE About the Next Lecture.html
　　├── 006 Lecture-Slides.url
　　├── 006 Preventing Instagram Self-Follows With Triggers.mp4
　　├── 006 Preventing Instagram Self-Follows With Triggers.srt
　　├── 006 Preventing Instagram Self-Follows With Triggers_en.srt
　　├── 007 Creating Logger Triggers.mp4
　　├── 007 Creating Logger Triggers.srt
　　├── 007 Creating Logger Triggers_en.srt
　　├── 007 Lecture-Slides.url
　　├── 008 Lecture-Slides.url
　　├── 008 Managing Triggers And A Warning.mp4
　　├── 008 Managing Triggers And A Warning.srt
　　├── 008 Managing Triggers And A Warning_en.srt
　　└── external-links.txt

下载地址:

游客，如果您要查看本帖隐藏内容请回复