终极MySQL实战营：从SQL小白到高手

编辑点评

深入浅出，实战性强，适合初学者快速提升MySQL技能。

⭐ 编辑推荐

本课程涵盖MySQL核心知识，通过实战案例，助你成为数据库高手。

✨ 课程亮点

课程目录

📁 16 - Window Functions
16 - Window Functions资料.zip [1.8 MB]
015 CODE.html [283.0 B]
001 Important Note (please read).html [538.0 B]
external-links.txt [71.0 B]
012 NTILE()_en.srt [6.0 KB]
002 Introducing Window Functions_en.srt [13.0 KB]
007 ORDER BY with Windows_en.srt [10.6 KB]
002 Introducing Window Functions.srt [8.7 KB]
005 PARTITION BY_en.srt [10.8 KB]
010 DENSE_RANK, & ROW_NUMBER().srt [7.3 KB]
003 Using OVER().srt [11.1 KB]
013 CODE.html [256.0 B]
007 ORDER BY with Windows.srt [8.8 KB]
004 CODE.html [1.0 KB]
017 CODE.html [347.0 B]
016 LEAD and LAG_en.srt [9.7 KB]
010 DENSE_RANK, & ROW_NUMBER()_en.srt [8.8 KB]
008 CODE.html [422.0 B]
005 PARTITION BY.srt [8.5 KB]
012 NTILE().srt [4.7 KB]
014 FIRST_VALUE.srt [5.0 KB]
014 FIRST_VALUE_en.srt [7.1 KB]
003 Using OVER()_en.srt [15.4 KB]
016 LEAD and LAG.srt [7.7 KB]
011 CODE.html [488.0 B]
009 RANK().srt [8.0 KB]
006 CODE.html [520.0 B]
009 RANK()_en.srt [9.9 KB]
002 SLIDES.url [79.0 B]
📁 05 - CRUD Basics
05 - CRUD Basics文档.zip [1.8 MB]
004 CODE.html [675.0 B]
021 CODE.html [189.0 B]
external-links.txt [63.0 B]
008 CODE.html [189.0 B]
019 SOLUTION CODE.html [639.0 B]
001 Section Introduction.srt [2.4 KB]
010 Rapid Fire Exercises SOLUTION.srt [4.0 KB]
007 The WHERE clause_en.srt [6.7 KB]
005 Officially Introducing SELECT.srt [5.1 KB]
018 UPDATE Exercise SOLUTION.srt [4.1 KB]
009 Rapid Fire Exercises_en.srt [2.5 KB]
012 Aliases_en.srt [4.0 KB]
022 DELETE Exercise.srt [1.4 KB]
002 Introducing CRUD.srt [2.9 KB]
018 UPDATE Exercise SOLUTION_en.srt [4.6 KB]
014 Using UPDATE_en.srt [9.1 KB]
020 Introducing DELETE_en.srt [4.2 KB]
017 UPDATE Exercise_en.srt [2.0 KB]
002 SLIDES.url [71.0 B]
024 SOLUTION CODE.html [294.0 B]
017 UPDATE Exercise.srt [1.9 KB]
016 A Quick Rule Of Thumb.srt [2.2 KB]
022 DELETE Exercise_en.srt [1.9 KB]
006 CODE.html [269.0 B]
023 DELETE Exercise SOLUTION_en.srt [3.9 KB]
002 Introducing CRUD_en.srt [3.7 KB]
001 Section Introduction_en.srt [2.9 KB]
005 Officially Introducing SELECT_en.srt [5.8 KB]
003 Getting Our New Dataset.srt [2.8 KB]
023 DELETE Exercise SOLUTION.srt [3.3 KB]
014 Using UPDATE.srt [6.9 KB]
020 Introducing DELETE.srt [3.5 KB]
015 CODE.html [229.0 B]
011 SOLUTION CODE.html [323.0 B]
013 CODE.html [174.0 B]
016 A Quick Rule Of Thumb_en.srt [3.2 KB]
010 Rapid Fire Exercises SOLUTION_en.srt [4.7 KB]
007 The WHERE clause.srt [4.7 KB]
009 Rapid Fire Exercises.srt [2.0 KB]
012 Aliases.srt [3.2 KB]
003 Getting Our New Dataset_en.srt [3.6 KB]
📁 19 - What Next
19 - What Next必看.png [493.5 KB]
001 Additional SQL Resources.html [3.0 KB]
📁 06 - CRUD Challenge
06 - CRUD Challenge资料.zip [1.8 MB]
004 SOLUTION CODE.html [719.0 B]
external-links.txt [71.0 B]
010 SOLUTION CODE.html [347.0 B]
009 CRUD Challenge Solution Deleting.srt [4.5 KB]
005 CRUD Challenge Solution Reading_en.srt [2.9 KB]
001 Section Introduction_en.srt [3.9 KB]
005 CRUD Challenge Solution Reading.srt [2.8 KB]
003 CRUD Challenge Solution Creating.srt [12.3 KB]
002 SLIDES.url [79.0 B]
001 Section Introduction.srt [2.8 KB]
008 SOLUTION CODE.html [313.0 B]
007 CRUD Challenge Solution Updating_en.srt [5.3 KB]
007 CRUD Challenge Solution Updating.srt [4.7 KB]
002 Introducing the CRUD Challenge.srt [8.0 KB]
002 Introducing the CRUD Challenge_en.srt [9.9 KB]
003 CRUD Challenge Solution Creating_en.srt [15.2 KB]
009 CRUD Challenge Solution Deleting_en.srt [5.0 KB]
006 SOLUTION CODE.html [204.0 B]
📁 02 - Getting Started & Installation
02 - Getting Started & Installation资料.png [493.5 KB]
002 SLIDES.url [73.0 B]
008 OPTIONAL-dbGate-Download.url [43.0 B]
008 MySQL-Workbench-Download.url [66.0 B]
004 Installation START HERE!.srt [7.9 KB]
002 What Is A Database_en.srt [13.4 KB]
006 Installation Windows Instructions_en.srt [16.9 KB]
001 Section Introduction_en.srt [2.2 KB]
008 Mac-MySQL-Download.url [62.0 B]
008 Installation Mac Instructions_en.srt [22.8 KB]
001 Section Introduction.srt [1.8 KB]
external-links.txt [361.0 B]
006 Installation Windows Instructions.srt [14.4 KB]
006 Windows-MySQL-Installation.url [89.0 B]
002 What Is A Database.srt [9.4 KB]
003 SQL vs. MySQL_en.srt [9.5 KB]
004 Installation START HERE!_en.srt [11.1 KB]
003 SQL vs. MySQL.srt [7.0 KB]
007 VERY IMPORTANT Mac Installation Notes.html [4.3 KB]
005 IMPORTANT NOTE Windows Installation Instructions.html [1.1 KB]
008 Installation Mac Instructions.srt [17.7 KB]
📁 14 - Many to Many
016 CODE.html [943.0 B]
010 CODE.html [169.0 B]
014 CODE.html [190.0 B]
006 CODE.html [145.0 B]
015 TV Series Challenge #6.srt [12.3 KB]
007 TV Series Challenge #2_en.srt [5.9 KB]
013 TV Series Challenge #5_en.srt [3.5 KB]
001 Section Introduction.srt [2.8 KB]
005 TV Series Challenge #1_en.srt [6.5 KB]
002 Many to Many Basics.srt [14.5 KB]
009 TV Series Challenge #3_en.srt [5.8 KB]
001 Section Introduction_en.srt [3.7 KB]
017 TV Series Challenge #7_en.srt [8.5 KB]
002 Many to Many Basics_en.srt [19.4 KB]
004 CODE.html [2.1 KB]
009 TV Series Challenge #3.srt [4.7 KB]
003 Creating Our Many To Many Tables.srt [8.2 KB]
007 TV Series Challenge #2.srt [4.8 KB]
013 TV Series Challenge #5.srt [3.0 KB]
external-links.txt [80.0 B]
015 TV Series Challenge #6_en.srt [14.5 KB]
017 TV Series Challenge #7.srt [6.6 KB]
002 SLIDES.url [88.0 B]
003 Creating Our Many To Many Tables_en.srt [10.3 KB]
012 CODE.html [348.0 B]
008 CODE.html [211.0 B]
018 CODE.html [782.0 B]
005 TV Series Challenge #1.srt [4.9 KB]
011 TV Series Challenge #4_en.srt [5.2 KB]
011 TV Series Challenge #4.srt [4.3 KB]
📁 21 - OPTIONAL LEGACY SECTION Building Our Web App
019 JOIN-US-HTML-AND-CSS.zip [2.7 KB]
011 REMINDER Use the Updated Connection Code.html [581.0 B]
003 JoinUsCompleteCode.zip [3.8 MB]
015 CODE Adding EJS Templates.html [632.0 B]
002 Section Introduction_en.srt [3.9 KB]
020 Styling Part 2.srt [11.6 KB]
014 Adding EJS Templates.srt [23.5 KB]
016 Connecting The Form.srt [27.2 KB]
014 Adding EJS Templates_en.srt [28.5 KB]
016 Connecting The Form_en.srt [31.8 KB]
external-links.txt [118.0 B]
005 NPM Init and package.json files.srt [9.6 KB]
006 IMPORTANT NOTE About Previewing Our Node Web App in the Browser.html [995.0 B]
005 NPM Init and package.json files_en.srt [12.2 KB]
018 Styling Part 1_en.srt [14.9 KB]
010 CODE Adding Multiple Routes.html [485.0 B]
007 Our First Simple Web App.srt [24.6 KB]
009 Adding Multiple Routes_en.srt [17.5 KB]
004 Introducing Express_en.srt [11.6 KB]
018 Styling Part 1.srt [12.4 KB]
009 Adding Multiple Routes.srt [14.8 KB]
004 Slides.url [73.0 B]
001 REMINDER Set Up A Local Coding Environment Instead of Cloud9.html [608.0 B]
004 Introducing Express.srt [9.2 KB]
012 Connecting Express and MySQL.srt [15.1 KB]
020 Styling Part 2_en.srt [14.1 KB]
007 Our First Simple Web App_en.srt [30.2 KB]
013 CODE Connecting Express and MySQL.html [382.0 B]
015 JOIN-US-HTML-AND-CSS.zip [2.7 KB]
017 CODE Connecting the Form.html [363.0 B]
019 CODE HTML AND CSS FILES.html [107.0 B]
002 Section Introduction.srt [3.2 KB]
008 CODE Our First Simple Web App.html [435.0 B]
003 Join Us Completed CODE.html [334.0 B]
004 Express-Documentation.url [46.0 B]
📁 08 - Refining Selections
018 SOLUTION CODE.html [766.0 B]
013 CODE.html [333.0 B]
external-links.txt [82.0 B]
010 LIMIT_en.srt [10.0 KB]
014 Escaping Wildcards_en.srt [3.9 KB]
012 LIKE_en.srt [12.1 KB]
001 Section Introduction.srt [1001.0 B]
011 CODE.html [946.0 B]
009 CODE.html [222.0 B]
010 LIMIT.srt [7.6 KB]
006 ORDER BY.srt [8.6 KB]
012 LIKE.srt [9.4 KB]
003 CODE.html [338.0 B]
017 Refining Selections Exercise SOLUTION.srt [21.1 KB]
016 Refining Selections Exercise_en.srt [5.7 KB]
007 CODE.html [183.0 B]
016 Refining Selections Exercise.srt [4.4 KB]
002 SLIDES.url [90.0 B]
002 Adding Some New Books.srt [2.0 KB]
017 Refining Selections Exercise SOLUTION_en.srt [26.2 KB]
014 Escaping Wildcards.srt [3.0 KB]
004 DISTINCT.srt [8.7 KB]
004 DISTINCT_en.srt [10.4 KB]
008 More On ORDER BY_en.srt [11.3 KB]
006 ORDER BY_en.srt [10.8 KB]
008 More On ORDER BY.srt [8.0 KB]
001 Section Introduction_en.srt [1.2 KB]
005 CODE.html [298.0 B]
002 Adding Some New Books_en.srt [2.6 KB]
015 CODE.html [232.0 B]
📁 04 - Inserting Data
external-links.txt [94.0 B]
008 INSERT Exercise.srt [8.1 KB]
016 CODE Introducing Primary Keys.html [421.0 B]
019 Create Table Insert Exercise_en.srt [12.9 KB]
018 CODE Working With AUTO_INCREMENT.html [237.0 B]
010 Working With NOT NULL_en.srt [9.6 KB]
008 INSERT Exercise_en.srt [9.2 KB]
017 Working With AUTO_INCREMENT_en.srt [12.7 KB]
006 Multi-inserts_en.srt [8.2 KB]
005 CODE A Quick Preview of SELECT.html [87.0 B]
020 SOLUTION Insert Exercise.html [871.0 B]
015 Introducing Primary Keys_en.srt [8.6 KB]
013 Adding DEFAULT Values_en.srt [11.5 KB]
012 Sidenote Quotes In MySQL_en.srt [7.6 KB]
010 Working With NOT NULL.srt [8.1 KB]
014 CODE Adding DEFAULT Values.html [650.0 B]
001 Section Introduction.srt [2.7 KB]
017 Working With AUTO_INCREMENT.srt [9.7 KB]
002 SLIDES.url [102.0 B]
006 Multi-inserts.srt [7.2 KB]
013 Adding DEFAULT Values.srt [9.6 KB]
001 Section Introduction_en.srt [3.0 KB]
015 Introducing Primary Keys.srt [6.8 KB]
002 INSERT The Basics.srt [5.3 KB]
004 A Quick Preview of SELECT.srt [2.6 KB]
009 SOLUTION INSERT Exercise.html [798.0 B]
004 A Quick Preview of SELECT_en.srt [3.2 KB]
011 CODE Working With NOT NULL.html [146.0 B]
003 CODE INSERT The Basics.html [420.0 B]
012 Sidenote Quotes In MySQL.srt [5.8 KB]
019 Create Table Insert Exercise.srt [9.9 KB]
007 CODE Multi-inserts.html [342.0 B]
002 INSERT The Basics_en.srt [6.2 KB]
📁 15 - Views, Modes, & More!
005 CODE.html [317.0 B]
001 Introducing Views.srt [8.3 KB]
003 Updateable Views.srt [7.4 KB]
008 WITH ROLLUP_en.srt [11.9 KB]
002 CODE.html [668.0 B]
012 STRICT_TRANS_TABLES.srt [6.3 KB]
008 WITH ROLLUP.srt [9.8 KB]
011 CODE.html [196.0 B]
004 ReplacingAltering Views_en.srt [5.7 KB]
007 CODE.html [178.0 B]
003 Updateable Views_en.srt [9.2 KB]
012 STRICT_TRANS_TABLES_en.srt [7.4 KB]
006 HAVING clause_en.srt [7.5 KB]
010 SQL Modes Basics_en.srt [10.7 KB]
013 More Modes_en.srt [17.3 KB]
013 More Modes.srt [12.8 KB]
009 CODE.html [362.0 B]
010 SQL Modes Basics.srt [8.4 KB]
001 Introducing Views_en.srt [11.5 KB]
004 ReplacingAltering Views.srt [4.6 KB]
006 HAVING clause.srt [6.0 KB]
📁 01 - Introduction & 5 Minutes of SQL
external-links.txt [164.0 B]
002 Join The Community!.html [915.0 B]
004 About Me.srt [2.4 KB]
004 About Me_en.srt [3.1 KB]
001 This Course Was Just Updated!_en.srt [6.1 KB]
006 SLIDES.url [83.0 B]
003 Course Intro.srt [2.0 KB]
006 First 5 Minutes of SQL.srt [12.8 KB]
006 First 5 Minutes of SQL_en.srt [16.0 KB]
005 Getting The Course Code.srt [2.5 KB]
001 This Course Was Just Updated!.srt [4.6 KB]
006 SQL-Try-It-Editor.url [86.0 B]
005 Getting The Course Code_en.srt [3.3 KB]
003 Course Intro_en.srt [2.6 KB]
📁 13 - One to Many & Joins
008 CODE.html [323.0 B]
012 CODE.html [230.0 B]
001 Section Introduction_en.srt [3.7 KB]
016 CODE.html [248.0 B]
002 Data is Messy_en.srt [19.8 KB]
023 Joins Exercise SOLUTION_en.srt [18.0 KB]
021 Joins Exercise.srt [4.1 KB]
017 Right Join_en.srt [7.0 KB]
011 Inner Joins With Group By.srt [6.4 KB]
009 Inner Joins_en.srt [15.1 KB]
013 Left Join.srt [9.6 KB]
003 Relationships Basics.srt [6.1 KB]
009 Inner Joins.srt [11.6 KB]
015 Left Join With Group By_en.srt [6.1 KB]
002 Data is Messy.srt [15.1 KB]
019 On Delete Cascade.srt [6.8 KB]
003 Relationships Basics_en.srt [8.7 KB]
017 Right Join.srt [5.4 KB]
004 One to Many Relationship_en.srt [22.3 KB]
external-links.txt [76.0 B]
015 Left Join With Group By.srt [4.6 KB]
014 CODE.html [336.0 B]
004 One to Many Relationship.srt [16.4 KB]
006 CODE.html [916.0 B]
005 Working with FOREIGN KEY.srt [14.7 KB]
023 Joins Exercise SOLUTION.srt [15.6 KB]
019 On Delete Cascade_en.srt [8.9 KB]
022 EXERCISE STARTER DATA.html [461.0 B]
011 Inner Joins With Group By_en.srt [8.6 KB]
001 Section Introduction.srt [2.7 KB]
005 Working with FOREIGN KEY_en.srt [18.0 KB]
021 Joins Exercise_en.srt [5.0 KB]
007 Cross Joins.srt [10.1 KB]
020 CODE.html [423.0 B]
010 CODE.html [371.0 B]
007 Cross Joins_en.srt [13.9 KB]
018 CODE.html [185.0 B]
002 SLIDES.url [84.0 B]
024 SOLUTION CODE.html [1.2 KB]
013 Left Join_en.srt [12.3 KB]
📁 09 - Aggregate Functions
009 CODE.html [264.0 B]
021 SOLUTION CODE.html [655.0 B]
015 CODE.html [152.0 B]
018 Aggregate Functions Docs_en.srt [2.4 KB]
013 CODE.html [642.0 B]
020 Agg Functions Exercise SOLUTION_en.srt [20.4 KB]
002 Count Basics.srt [9.8 KB]
006 MIN and MAX Basics.srt [5.3 KB]
002 Count Basics_en.srt [12.4 KB]
004 GROUP BY.srt [13.6 KB]
018 Aggregate Functions Docs.srt [1.8 KB]
007 CODE.html [109.0 B]
012 MIN and MAX With GROUP BY_en.srt [10.0 KB]
012 MIN and MAX With GROUP BY.srt [8.2 KB]
002 SLIDES.url [90.0 B]
003 CODE.html [160.0 B]
016 AVG.srt [2.9 KB]
019 Agg Functions Exercise.srt [3.8 KB]
001 Section Introduction_en.srt [7.6 KB]
019 Agg Functions Exercise_en.srt [5.1 KB]
008 Subqueries.srt [8.2 KB]
017 CODE.html [219.0 B]
001 Section Introduction.srt [5.7 KB]
010 Grouping By Multiple Columns.srt [6.2 KB]
010 Grouping By Multiple Columns_en.srt [7.6 KB]
external-links.txt [82.0 B]
014 SUM_en.srt [5.8 KB]
008 Subqueries_en.srt [10.0 KB]
006 MIN and MAX Basics_en.srt [6.2 KB]
016 AVG_en.srt [3.8 KB]
004 GROUP BY_en.srt [16.8 KB]
020 Agg Functions Exercise SOLUTION.srt [16.4 KB]
005 CODE.html [232.0 B]
011 CODE.html [238.0 B]
014 SUM.srt [4.6 KB]
📁 17 - Instagram Database Clone
018 Complete Instagram Schema.html [1.6 KB]
005 CODE.html [192.0 B]
009 CODE.html [353.0 B]
008 Comments Schema_en.srt [10.2 KB]
015 3 Approaches for Hashtags.srt [13.9 KB]
016 Implementing Hashtags Table_en.srt [7.6 KB]
012 Followers Schema_en.srt [11.8 KB]
006 Photos Schema.srt [7.9 KB]
004 Users Schema_en.srt [11.3 KB]
006 Photos Schema_en.srt [10.2 KB]
014 Note!.html [402.0 B]
011 CODE.html [302.0 B]
external-links.txt [72.0 B]
008 Comments Schema.srt [8.1 KB]
010 Likes Schema_en.srt [12.2 KB]
001 Section Introduction_en.srt [2.4 KB]
002 IMPORTANT NOTE ABOUT THIS SECTION!_en.srt [3.8 KB]
004 Users Schema.srt [7.9 KB]
003 Introducing Instagram Clone.srt [11.8 KB]
017 CODE.html [400.0 B]
002 IMPORTANT NOTE ABOUT THIS SECTION!.srt [2.7 KB]
012 Followers Schema.srt [9.9 KB]
013 CODE.html [324.0 B]
007 CODE.html [266.0 B]
003 SLIDES.url [80.0 B]
003 Introducing Instagram Clone_en.srt [16.7 KB]
016 Implementing Hashtags Table.srt [7.0 KB]
015 3 Approaches for Hashtags_en.srt [19.6 KB]
010 Likes Schema.srt [9.2 KB]
001 Section Introduction.srt [2.0 KB]
📁 03 - Creating Databases & Tables
019 SOLUTION Tables Basics Activity.html [343.0 B]
015 CODE How Do We Know It Worked.html [128.0 B]
014 How Do We Know It Worked.srt [6.9 KB]
002 SLIDES.url [98.0 B]
009 Data Types The Basics.srt [10.6 KB]
012 Creating Tables.srt [7.5 KB]
004 Creating Databases_en.srt [9.1 KB]
005 CODE Creating Databases.html [195.0 B]
002 Showing Databases.srt [5.9 KB]
008 Introducing Tables_en.srt [9.5 KB]
011 CODE Basic Datatypes Challenge.html [196.0 B]
007 CODE Dropping and Using Databases.html [154.0 B]
008 Introducing Tables.srt [7.7 KB]
002 Showing Databases_en.srt [8.3 KB]
016 Dropping Tables_en.srt [4.1 KB]
016 Dropping Tables.srt [3.6 KB]
009 Data Types The Basics_en.srt [14.5 KB]
006 Dropping and Using Databases_en.srt [9.7 KB]
006 Dropping and Using Databases.srt [8.0 KB]
001 Section Introduction.srt [1.8 KB]
020 MySQL Comments_en.srt [6.0 KB]
003 CODE Showing Databases.html [70.0 B]
018 Tables Basics Activity_en.srt [5.1 KB]
external-links.txt [90.0 B]
013 CODE Creating Tables.html [209.0 B]
010 Basic Datatypes Challenge.srt [3.5 KB]
014 How Do We Know It Worked_en.srt [8.2 KB]
017 CODE Dropping Tables.html [153.0 B]
018 Tables Basics Activity.srt [4.5 KB]
001 Section Introduction_en.srt [2.5 KB]
010 Basic Datatypes Challenge_en.srt [4.5 KB]
004 Creating Databases.srt [7.4 KB]
012 Creating Tables_en.srt [9.5 KB]
020 MySQL Comments.srt [5.1 KB]
📁 12 - Constraints & ALTER TABLE
006 CODE.html [286.0 B]
016 CODE.html [230.0 B]
010 CODE.html [169.0 B]
004 CODE.html [211.0 B]
013 ALTER TABLE Renaming_en.srt [6.1 KB]
008 CODE.html [349.0 B]
005 Named Constraints.srt [5.8 KB]
015 ALTER TABLE Modifying Columns.srt [5.2 KB]
018 CODE.html [240.0 B]
011 ALTER TABLE Dropping Columns_en.srt [3.0 KB]
001 SLIDES.url [88.0 B]
005 Named Constraints_en.srt [6.8 KB]
009 ALTER TABLE Adding Columns.srt [7.9 KB]
015 ALTER TABLE Modifying Columns_en.srt [6.1 KB]
external-links.txt [80.0 B]
014 CODE.html [309.0 B]
017 ALTER TABLE Constraints.srt [5.9 KB]
001 UNIQUE Constraint.srt [5.2 KB]
002 CODE.html [326.0 B]
007 Multiple Column Constraints_en.srt [8.5 KB]
001 UNIQUE Constraint_en.srt [6.2 KB]
017 ALTER TABLE Constraints_en.srt [6.8 KB]
003 CHECK Constraints_en.srt [8.0 KB]
007 Multiple Column Constraints.srt [6.9 KB]
011 ALTER TABLE Dropping Columns.srt [2.6 KB]
003 CHECK Constraints.srt [6.7 KB]
009 ALTER TABLE Adding Columns_en.srt [9.8 KB]
012 CODE.html [80.0 B]
013 ALTER TABLE Renaming.srt [5.0 KB]
📁 20 - OPTIONAL LEGACY SECTION Introducing Node
012 UPDATED CODE Introduction to NPM and Faker.html [1.6 KB]
029 CODE 500 Users Exercises Solutions.html [1.5 KB]
015 REMINDER How to Start the MySQL Command Line Locally (instead of Cloud9).html [1.5 KB]
021 CODE Selecting Using Node.html [940.0 B]
027 500 Users Exercises_en.srt [4.6 KB]
010 IMPORTANT NOTE About the Faker Package.html [2.9 KB]
013 MySQL-Node-Package-Github-Repo.url [56.0 B]
external-links.txt [217.0 B]
009 CODE 5 Minute Node Crash Course.html [280.0 B]
018 Creating Our Users Table.srt [9.7 KB]
008 5 Minute NodeJS Crash Course.srt [8.8 KB]
005 BUT WHAT ABOUT PHP.srt [10.4 KB]
019 CODE Creating Our Users Table.html [189.0 B]
002 IMPORTANT NOTE Downloading Source Code.html [266.0 B]
024 Some MySQLNode Magic.srt [10.4 KB]
004 Slides-For-This-Section.url [71.0 B]
027 Slides.url [73.0 B]
020 Selecting Using Node.srt [8.8 KB]
028 500 Users Exercises Solutions.srt [15.7 KB]
007 REMINDER NodeJS Installation.html [853.0 B]
026 CODE Bulk Inserting 500 Users.html [805.0 B]
025 Bulk Inserting 500 Users - Finally!_en.srt [15.0 KB]
022 Inserting Using Node_en.srt [18.8 KB]
016 Connecting Node to MySQL_en.srt [21.6 KB]
002 node-and-mysql.zip [10.1 KB]
023 CODE Inserting Using Node.html [666.0 B]
003 Section Introduction_en.srt [3.1 KB]
011 Introduction to NPM and Faker.srt [13.4 KB]
017 CODE Connecting Node to MySQL.html [2.5 KB]
013 Introducing the MySQL Package_en.srt [8.8 KB]
011 Introduction to NPM and Faker_en.srt [15.1 KB]
013 Introducing the MySQL Package.srt [7.1 KB]
006 Introduction to JOIN US app.srt [12.3 KB]
003 Section Introduction.srt [2.6 KB]
020 Selecting Using Node_en.srt [10.8 KB]
027 500 Users Exercises.srt [4.0 KB]
024 Some MySQLNode Magic_en.srt [12.6 KB]
016 Connecting Node to MySQL.srt [18.3 KB]
006 Introduction to JOIN US app_en.srt [15.4 KB]
014 IMPORTANT NOTE About the MySQL Package and Connecting Node to MySQL.html [3.2 KB]
004 MySQL and Other Languages_en.srt [17.4 KB]
018 Creating Our Users Table_en.srt [13.0 KB]
028 500 Users Exercises Solutions_en.srt [17.8 KB]
004 MySQL and Other Languages.srt [13.0 KB]
025 Bulk Inserting 500 Users - Finally!.srt [12.9 KB]
005 BUT WHAT ABOUT PHP_en.srt [14.0 KB]
008 5 Minute NodeJS Crash Course_en.srt [11.2 KB]
022 Inserting Using Node.srt [16.8 KB]
001 IMPORTANT NOTE Using a Local Coding Environment Instead of Cloud9.html [2.8 KB]
📁 11 - Comparison & Logical Operators
021 CODE.html [843.0 B]
009 CODE.html [193.0 B]
019 CODE.html [466.0 B]
012 Logical OR_en.srt [9.3 KB]
024 Exercise SOLUTION_en.srt [23.8 KB]
008 Less Than Or Equal To.srt [3.5 KB]
010 Logical AND.srt [12.1 KB]
020 CASE_en.srt [14.4 KB]
002 Not Equal.srt [3.4 KB]
023 Exercise.srt [4.5 KB]
014 Between_en.srt [7.3 KB]
025 SOLUTION CODE.html [1.0 KB]
010 Logical AND_en.srt [15.4 KB]
002 SLIDES.url [78.0 B]
024 Exercise SOLUTION.srt [20.8 KB]
001 Section Introduction.srt [4.6 KB]
001 Section Introduction_en.srt [5.1 KB]
023 Exercise_en.srt [5.9 KB]
external-links.txt [70.0 B]
011 CODE.html [296.0 B]
003 CODE.html [89.0 B]
006 Greater Than_en.srt [6.7 KB]
013 CODE.html [427.0 B]
018 The IN Operator_en.srt [14.1 KB]
008 Less Than Or Equal To_en.srt [4.5 KB]
014 Between.srt [5.7 KB]
016 Comparing Dates_en.srt [13.1 KB]
012 Logical OR.srt [7.3 KB]
005 CODE.html [88.0 B]
004 NOT LIKE.srt [4.0 KB]
018 The IN Operator.srt [12.2 KB]
017 CODE.html [211.0 B]
015 CODE.html [227.0 B]
020 CASE.srt [11.2 KB]
006 Greater Than.srt [5.0 KB]
004 NOT LIKE_en.srt [5.1 KB]
022 IS NULL_en.srt [3.2 KB]
022 IS NULL.srt [2.7 KB]
016 Comparing Dates.srt [11.0 KB]
002 Not Equal_en.srt [4.7 KB]
007 CODE.html [137.0 B]
📁 18 - Working With Lots of IG Data
017 CODE.html [276.0 B]
009 CODE.html [145.0 B]
006 Instagram Challenge #2_en.srt [12.3 KB]
010 Instagram Challenge #4_en.srt [10.8 KB]
010 Instagram Challenge #4.srt [8.5 KB]
004 Instagram Challenge #1.srt [6.4 KB]
002 Getting Lots of Instagram Data_en.srt [15.6 KB]
008 Instagram Challenge #3.srt [10.4 KB]
016 Instagram Challenge #7_en.srt [8.6 KB]
006 Instagram Challenge #2.srt [9.5 KB]
008 Instagram Challenge #3_en.srt [13.3 KB]
005 CODE.html [125.0 B]
012 Instagram Challenge #5_en.srt [5.4 KB]
014 Instagram Challenge #6.srt [7.0 KB]
015 CODE.html [225.0 B]
013 CODE.html [158.0 B]
001 Section Introduction_en.srt [3.2 KB]
011 CODE.html [294.0 B]
007 CODE.html [160.0 B]
003 ig-clone-data.sql [429.4 KB]
001 Section Introduction.srt [2.7 KB]
012 Instagram Challenge #5.srt [4.4 KB]
014 Instagram Challenge #6_en.srt [8.5 KB]
002 Getting Lots of Instagram Data.srt [11.2 KB]
016 Instagram Challenge #7.srt [6.8 KB]
004 Instagram Challenge #1_en.srt [8.8 KB]
003 CODE.html [186.0 B]
📁 10 - Revisiting Data Types
011 CODE.html [203.0 B]
024 SOLUTION CODE.html [1.2 KB]
013 CODE.html [240.0 B]
021 CODE.html [296.0 B]
002 Data-Types-Reference.url [79.0 B]
external-links.txt [159.0 B]
019 TIMESTAMPS.srt [4.7 KB]
010 CURDATE, CURTIME, & NOW_en.srt [7.2 KB]
010 CURDATE, CURTIME, & NOW.srt [5.7 KB]
023 Data Types Exercise SOLUTION.srt [18.5 KB]
001 Section Introduction.srt [3.0 KB]
014 Time Functions_en.srt [3.2 KB]
012 Date Functions_en.srt [9.7 KB]
003 CHAR vs. VARCHAR.srt [17.2 KB]
023 Data Types Exercise SOLUTION_en.srt [22.3 KB]
006 FLOAT & DOUBLE.srt [7.7 KB]
007 DATE and TIME.srt [6.2 KB]
002 Surveying Other Data Types.srt [4.0 KB]
014 Time Functions.srt [2.8 KB]
004 INT, TINYINT, BIGINT, etc.srt [6.5 KB]
019 TIMESTAMPS_en.srt [5.9 KB]
006 FLOAT & DOUBLE_en.srt [9.5 KB]
008 Working With Dates_en.srt [12.9 KB]
020 DEFAULT & ON UPDATE TIMESTAMPS.srt [8.8 KB]
009 CODE.html [530.0 B]
016 Formatting Dates_en.srt [15.7 KB]
002 Surveying Other Data Types_en.srt [5.8 KB]
008 Working With Dates.srt [10.1 KB]
005 DECIMAL_en.srt [11.6 KB]
016 Formatting Dates.srt [12.4 KB]
004 INT, TINYINT, BIGINT, etc_en.srt [8.9 KB]
005 DECIMAL.srt [9.6 KB]
018 Date Math.srt [14.2 KB]
022 Data Types Exercise.srt [5.3 KB]
020 DEFAULT & ON UPDATE TIMESTAMPS_en.srt [10.9 KB]
007 DATE and TIME_en.srt [7.9 KB]
022 Data Types Exercise_en.srt [6.7 KB]
017 CODE.html [235.0 B]
002 SLIDES.url [82.0 B]
015 CODE.html [242.0 B]
012 Date Functions.srt [8.0 KB]
001 Section Introduction_en.srt [3.7 KB]
003 CHAR vs. VARCHAR_en.srt [22.1 KB]
018 Date Math_en.srt [17.2 KB]
📁 22 - OPTIONAL LEGACY SECTION Database Triggers
006 Preventing Instagram Self-Follows With Triggers.srt [11.2 KB]
007 Creating Logger Triggers_en.srt [17.0 KB]
007 Lecture-Slides.url [88.0 B]
006 Lecture-Slides.url [88.0 B]
005 NOTE About the Next Lecture.html [402.0 B]
004 Lecture-Slides.url [87.0 B]
003 Writing Our First Trigger Part 1_en.srt [12.0 KB]
002 Lecture-Slides.url [84.0 B]
006 Preventing Instagram Self-Follows With Triggers_en.srt [13.8 KB]
002 Introduction to Database Triggers_en.srt [12.1 KB]
002 Introduction to Database Triggers.srt [8.9 KB]
003 Writing Our First Trigger Part 1.srt [10.1 KB]
external-links.txt [522.0 B]
008 Managing Triggers And A Warning_en.srt [10.9 KB]
001 NOTE Use MySQL Locally Instead of Cloud9.html [256.0 B]
008 Lecture-Slides.url [88.0 B]
008 Managing Triggers And A Warning.srt [8.5 KB]
004 Writing Our First Trigger Part 2.srt [16.1 KB]
003 Lecture-Slides.url [87.0 B]
007 Creating Logger Triggers.srt [13.3 KB]
004 Writing Our First Trigger Part 2_en.srt [20.3 KB]
📁 07 - String Functions
019 CODE.html [273.0 B]
006 CODE.html [215.0 B]
010 CODE.html [146.0 B]
002 MySQL-Docs-String-Functions.url [85.0 B]
022 String Functions Exercise.srt [5.5 KB]
018 UPPER & LOWER.srt [5.6 KB]
005 CONCAT_en.srt [15.1 KB]
020 Other String Functions.srt [8.8 KB]
003 Loading Our Books Data_en.srt [10.1 KB]
external-links.txt [236.0 B]
024 SOLUTION CODE.html [710.0 B]
004 CODE.html [1.4 KB]
014 REVERSE.srt [5.1 KB]
018 UPPER & LOWER_en.srt [6.3 KB]
001 Section Introduction_en.srt [3.8 KB]
002 The World Of String Functions.srt [2.5 KB]
009 Combining String Functions_en.srt [11.5 KB]
016 CHAR_LENGTH.srt [3.5 KB]
005 CONCAT.srt [12.0 KB]
007 SUBSTRING.srt [10.8 KB]
002 The World Of String Functions_en.srt [3.5 KB]
023 String Functions Exerise SOLUTION_en.srt [17.3 KB]
014 REVERSE_en.srt [5.3 KB]
003 book-data.sql [1.3 KB]
007 SUBSTRING_en.srt [13.4 KB]
011 Sidenote SQL Formatting_en.srt [8.5 KB]
016 CHAR_LENGTH_en.srt [4.8 KB]
002 SLIDES.url [86.0 B]
017 CODE.html [306.0 B]
011 Sidenote SQL Formatting.srt [6.9 KB]
012 REPLACE_en.srt [10.2 KB]
001 Section Introduction.srt [3.0 KB]
022 String Functions Exercise_en.srt [6.8 KB]
003 Loading Our Books Data.srt [8.4 KB]
008 CODE.html [281.0 B]
009 Combining String Functions.srt [9.5 KB]
021 CODE.html [211.0 B]
013 CODE.html [382.0 B]
020 Other String Functions_en.srt [10.9 KB]
011 SQL-Formatter.url [61.0 B]
012 REPLACE.srt [9.0 KB]
023 String Functions Exerise SOLUTION.srt [15.9 KB]
015 CODE.html [259.0 B]

适合人群

• 数据库初学者
• 需要提升数据库技能的开发者

🎯 学习收获

• 掌握MySQL基础操作
• 精通SQL语句
• 提升数据库性能优化能力

🎉 祝您学习愉快！