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

📁 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]
    009 RANK()【公众号：密知圈】.mp4  [76.7 MB]
    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]
    010 DENSE_RANK, & ROW_NUMBER().mp4  [68.1 MB]
    005 PARTITION BY_en.srt  [10.8 KB]
    007 ORDER BY with Windows.mp4  [60.9 MB]
    010 DENSE_RANK, & ROW_NUMBER().srt  [7.3 KB]
    003 Using OVER().srt  [11.1 KB]
    016 LEAD and LAG.mp4  [77.0 MB]
    002 Introducing Window Functions.mp4  [67.1 MB]
    013 CODE.html  [256.0 B]
    007 ORDER BY with Windows.srt  [8.8 KB]
    003 Using OVER().mp4  [43.9 MB]
    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]
    012 NTILE().mp4  [34.0 MB]
    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]
    014 FIRST_VALUE.mp4  [38.5 MB]
    002 SLIDES.url  [79.0 B]
    005 PARTITION BY.mp4  [59.1 MB]
📁 05 - CRUD Basics
    05 - CRUD Basics文档.zip  [1.8 MB]
    022 DELETE Exercise【公众号：密知圈】.mp4  [2.4 MB]
    018 UPDATE Exercise SOLUTION【公众号：密知圈】.mp4  [6.7 MB]
    004 CODE【公众号：密知圈】.html  [675.0 B]
    021 CODE【公众号：密知圈】.html  [189.0 B]
    003 Getting Our New Dataset【公众号：密知圈】.mp4  [4.1 MB]
    020 Introducing DELETE【公众号：密知圈】.mp4  [12.8 MB]
    external-links【公众号：密知圈】.txt  [63.0 B]
    008 CODE【公众号：密知圈】.html  [189.0 B]
    010 Rapid Fire Exercises SOLUTION【公众号：密知圈】.mp4  [11.8 MB]
    001 Section Introduction【公众号：密知圈】.mp4  [33.7 MB]
    019 SOLUTION CODE【公众号：密知圈】.html  [639.0 B]
    002 Introducing CRUD.mp4  [3.2 MB]
    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]
    005 Officially Introducing SELECT.mp4  [19.8 MB]
    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]
    014 Using UPDATE.mp4  [15.0 MB]
    024 SOLUTION CODE.html  [294.0 B]
    012 Aliases.mp4  [4.3 MB]
    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]
    017 UPDATE Exercise.mp4  [2.0 MB]
    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]
    007 The WHERE clause.mp4  [7.4 MB]
    005 Officially Introducing SELECT_en.srt  [5.8 KB]
    009 Rapid Fire Exercises.mp4  [4.1 MB]
    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]
    016 A Quick Rule Of Thumb.mp4  [3.0 MB]
    023 DELETE Exercise SOLUTION.mp4  [4.6 MB]
    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]
    003 CRUD Challenge Solution Creating【公众号：密知圈】.mp4  [73.2 MB]
    009 CRUD Challenge Solution Deleting.srt  [4.5 KB]
    009 CRUD Challenge Solution Deleting.mp4  [12.0 MB]
    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]
    005 CRUD Challenge Solution Reading.mp4  [6.8 MB]
    008 SOLUTION CODE.html  [313.0 B]
    007 CRUD Challenge Solution Updating_en.srt  [5.3 KB]
    007 CRUD Challenge Solution Updating.mp4  [12.8 MB]
    007 CRUD Challenge Solution Updating.srt  [4.7 KB]
    001 Section Introduction.mp4  [39.7 MB]
    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]
    002 Introducing the CRUD Challenge.mp4  [10.6 MB]
    006 SOLUTION CODE.html  [204.0 B]
📁 02 - Getting Started & Installation
    02 - Getting Started & Installation资料.png  [493.5 KB]
    008 Installation Mac Instructions【公众号：密知圈】.mp4  [72.6 MB]
    006 Installation Windows Instructions【公众号：密知圈】.mp4  [60.7 MB]
    001 Section Introduction【公众号：密知圈】.mp4  [23.1 MB]
    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]
    002 What Is A Database.mp4  [20.0 MB]
    006 Windows-MySQL-Installation.url  [89.0 B]
    003 SQL vs. MySQL.mp4  [13.8 MB]
    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]
    004 Installation START HERE!.mp4  [28.5 MB]
📁 14 - Many to Many
    011 TV Series Challenge #4【公众号：密知圈】.mp4  [34.8 MB]
    003 Creating Our Many To Many Tables【公众号：密知圈】.mp4  [60.1 MB]
    016 CODE【公众号：密知圈】.html  [943.0 B]
    010 CODE【公众号：密知圈】.html  [169.0 B]
    014 CODE【公众号：密知圈】.html  [190.0 B]
    006 CODE【公众号：密知圈】.html  [145.0 B]
    001 Section Introduction【公众号：密知圈】.mp4  [41.1 MB]
    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]
    002 Many to Many Basics.mp4  [35.8 MB]
    009 TV Series Challenge #3_en.srt  [5.8 KB]
    001 Section Introduction_en.srt  [3.7 KB]
    015 TV Series Challenge #6.mp4  [127.0 MB]
    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]
    007 TV Series Challenge #2.mp4  [19.5 MB]
    009 TV Series Challenge #3.srt  [4.7 KB]
    013 TV Series Challenge #5.mp4  [22.5 MB]
    003 Creating Our Many To Many Tables.srt  [8.2 KB]
    007 TV Series Challenge #2.srt  [4.8 KB]
    017 TV Series Challenge #7.mp4  [56.3 MB]
    009 TV Series Challenge #3.mp4  [31.6 MB]
    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]
    005 TV Series Challenge #1.mp4  [32.1 MB]
    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
    009 Adding Multiple Routes【公众号：密知圈】.mp4  [65.4 MB]
    004 Introducing Express【公众号：密知圈】.mp4  [18.9 MB]
    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]
    014 Adding EJS Templates.mp4  [212.6 MB]
    005 NPM Init and package.json files.mp4  [31.0 MB]
    020 Styling Part 2.srt  [11.6 KB]
    014 Adding EJS Templates.srt  [23.5 KB]
    016 Connecting The Form.mp4  [181.0 MB]
    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]
    002 Section Introduction.mp4  [21.7 MB]
    012 Connecting Express and MySQL.mp4  [146.7 MB]
    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]
    007 Our First Simple Web App.mp4  [156.9 MB]
    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]
    018 Styling Part 1.mp4  [151.0 MB]
    015 JOIN-US-HTML-AND-CSS.zip  [2.7 KB]
    020 Styling Part 2.mp4  [194.7 MB]
    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]
    017 Refining Selections Exercise SOLUTION【公众号：密知圈】.mp4  [130.9 MB]
    002 Adding Some New Books.mp4  [3.8 MB]
    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]
    016 Refining Selections Exercise.mp4  [15.1 MB]
    010 LIMIT.srt  [7.6 KB]
    006 ORDER BY.srt  [8.6 KB]
    006 ORDER BY.mp4  [66.0 MB]
    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]
    010 LIMIT.mp4  [48.5 MB]
    016 Refining Selections Exercise.srt  [4.4 KB]
    002 SLIDES.url  [90.0 B]
    008 More On ORDER BY.mp4  [47.4 MB]
    001 Section Introduction.mp4  [12.7 MB]
    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]
    012 LIKE.mp4  [46.1 MB]
    008 More On ORDER BY_en.srt  [11.3 KB]
    014 Escaping Wildcards.mp4  [8.1 MB]
    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]
    004 DISTINCT.mp4  [20.2 MB]
    015 CODE.html  [232.0 B]
📁 04 - Inserting Data
    001 Section Introduction【公众号：密知圈】.mp4  [19.4 MB]
    019 Create Table Insert Exercise【公众号：密知圈】.mp4  [70.9 MB]
    external-links【公众号：密知圈】.txt  [94.0 B]
    017 Working With AUTO_INCREMENT【公众号：密知圈】.mp4  [54.7 MB]
    008 INSERT Exercise.mp4  [58.4 MB]
    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]
    010 Working With NOT NULL.mp4  [30.8 MB]
    018 CODE Working With AUTO_INCREMENT.html  [237.0 B]
    010 Working With NOT NULL_en.srt  [9.6 KB]
    006 Multi-inserts.mp4  [16.0 MB]
    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]
    012 Sidenote Quotes In MySQL.mp4  [11.5 MB]
    005 CODE A Quick Preview of SELECT.html  [87.0 B]
    002 INSERT The Basics.mp4  [9.7 MB]
    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]
    004 A Quick Preview of SELECT.mp4  [6.7 MB]
    014 CODE Adding DEFAULT Values.html  [650.0 B]
    001 Section Introduction.srt  [2.7 KB]
    015 Introducing Primary Keys.mp4  [17.1 MB]
    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.mp4  [34.5 MB]
    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!
    006 HAVING clause【公众号：密知圈】.mp4  [52.7 MB]
    013 More Modes【公众号：密知圈】.mp4  [76.8 MB]
    012 STRICT_TRANS_TABLES【公众号：密知圈】.mp4  [27.4 MB]
    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]
    004 ReplacingAltering Views.mp4  [42.2 MB]
    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.mp4  [65.0 MB]
    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]
    008 WITH ROLLUP.mp4  [57.8 MB]
    010 SQL Modes Basics.srt  [8.4 KB]
    003 Updateable Views.mp4  [64.5 MB]
    001 Introducing Views.mp4  [61.1 MB]
    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]
    004 About Me【公众号：密知圈】.mp4  [16.5 MB]
    003 Course Intro【公众号：密知圈】.mp4  [10.1 MB]
    002 Join The Community!【公众号：密知圈】.html  [915.0 B]
    001 This Course Was Just Updated!【公众号：密知圈】.mp4  [23.4 MB]
    005 Getting The Course Code.mp4  [8.1 MB]
    006 First 5 Minutes of SQL.mp4  [72.8 MB]
    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
    013 Left Join【公众号：密知圈】.mp4  [63.8 MB]
    011 Inner Joins With Group By【公众号：密知圈】.mp4  [36.1 MB]
    008 CODE【公众号：密知圈】.html  [323.0 B]
    003 Relationships Basics【公众号：密知圈】.mp4  [11.8 MB]
    021 Joins Exercise【公众号：密知圈】.mp4  [9.8 MB]
    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]
    023 Joins Exercise SOLUTION.mp4  [95.5 MB]
    019 On Delete Cascade.srt  [6.8 KB]
    007 Cross Joins.mp4  [101.3 MB]
    003 Relationships Basics_en.srt  [8.7 KB]
    009 Inner Joins.mp4  [102.7 MB]
    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]
    019 On Delete Cascade.mp4  [17.9 MB]
    014 CODE.html  [336.0 B]
    004 One to Many Relationship.srt  [16.4 KB]
    005 Working with FOREIGN KEY.mp4  [84.6 MB]
    002 Data is Messy.mp4  [37.8 MB]
    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]
    004 One to Many Relationship.mp4  [57.9 MB]
    015 Left Join With Group By.mp4  [20.2 MB]
    001 Section Introduction.mp4  [41.9 MB]
    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]
    017 Right Join.mp4  [15.9 MB]
    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【公众号：密知圈】.mp4  [22.2 MB]
    008 Subqueries【公众号：密知圈】.mp4  [37.7 MB]
    004 GROUP BY【公众号：密知圈】.mp4  [75.6 MB]
    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]
    019 Agg Functions Exercise.mp4  [6.1 MB]
    014 SUM.mp4  [22.4 MB]
    004 GROUP BY.srt  [13.6 KB]
    012 MIN and MAX With GROUP BY.mp4  [47.9 MB]
    018 Aggregate Functions Docs.srt  [1.8 KB]
    001 Section Introduction.mp4  [43.2 MB]
    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]
    002 Count Basics.mp4  [30.8 MB]
    017 CODE.html  [219.0 B]
    020 Agg Functions Exercise SOLUTION.mp4  [57.5 MB]
    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]
    006 MIN and MAX Basics.mp4  [7.7 MB]
    014 SUM.srt  [4.6 KB]
    010 Grouping By Multiple Columns.mp4  [20.4 MB]
    016 AVG.mp4  [6.0 MB]
📁 17 - Instagram Database Clone
    006 Photos Schema【公众号：密知圈】.mp4  [38.7 MB]
    001 Section Introduction【公众号：密知圈】.mp4  [28.8 MB]
    018 Complete Instagram Schema【公众号：密知圈】.html  [1.6 KB]
    005 CODE【公众号：密知圈】.html  [192.0 B]
    004 Users Schema【公众号：密知圈】.mp4  [26.2 MB]
    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]
    016 Implementing Hashtags Table.mp4  [59.8 MB]
    012 Followers Schema_en.srt  [11.8 KB]
    006 Photos Schema.srt  [7.9 KB]
    004 Users Schema_en.srt  [11.3 KB]
    012 Followers Schema.mp4  [34.1 MB]
    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]
    008 Comments Schema.mp4  [44.0 MB]
    010 Likes Schema.mp4  [126.8 MB]
    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]
    015 3 Approaches for Hashtags.mp4  [59.3 MB]
    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.mp4  [117.8 MB]
    002 IMPORTANT NOTE ABOUT THIS SECTION!.mp4  [27.5 MB]
    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]
    014 How Do We Know It Worked【公众号：密知圈】.mp4  [31.7 MB]
    010 Basic Datatypes Challenge【公众号：密知圈】.mp4  [6.9 MB]
    006 Dropping and Using Databases【公众号：密知圈】.mp4  [16.4 MB]
    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]
    008 Introducing Tables.mp4  [38.9 MB]
    009 Data Types The Basics.mp4  [43.5 MB]
    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]
    002 Showing Databases.mp4  [13.0 MB]
    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]
    016 Dropping Tables.mp4  [9.2 MB]
    003 CODE Showing Databases.html  [70.0 B]
    018 Tables Basics Activity.mp4  [11.4 MB]
    018 Tables Basics Activity_en.srt  [5.1 KB]
    004 Creating Databases.mp4  [14.6 MB]
    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]
    001 Section Introduction.mp4  [25.7 MB]
    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]
    020 MySQL Comments.mp4  [8.8 MB]
    004 Creating Databases.srt  [7.4 KB]
    012 Creating Tables.mp4  [12.6 MB]
    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]
    015 ALTER TABLE  Modifying Columns.mp4  [15.3 MB]
    005 Named Constraints.srt  [5.8 KB]
    015 ALTER TABLE  Modifying Columns.srt  [5.2 KB]
    018 CODE.html  [240.0 B]
    009 ALTER TABLE  Adding Columns.mp4  [47.8 MB]
    011 ALTER TABLE  Dropping Columns_en.srt  [3.0 KB]
    001 SLIDES.url  [88.0 B]
    005 Named Constraints_en.srt  [6.8 KB]
    007 Multiple Column Constraints.mp4  [38.6 MB]
    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]
    003 CHECK Constraints.mp4  [20.2 MB]
    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]
    005 Named Constraints.mp4  [32.1 MB]
    001 UNIQUE Constraint.mp4  [10.0 MB]
    017 ALTER TABLE  Constraints_en.srt  [6.8 KB]
    003 CHECK Constraints_en.srt  [8.0 KB]
    013 ALTER TABLE  Renaming.mp4  [26.8 MB]
    007 Multiple Column Constraints.srt  [6.9 KB]
    011 ALTER TABLE  Dropping Columns.mp4  [20.8 MB]
    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]
    017 ALTER TABLE  Constraints.mp4  [39.4 MB]
    012 CODE.html  [80.0 B]
    013 ALTER TABLE  Renaming.srt  [5.0 KB]
📁 20 - OPTIONAL LEGACY SECTION Introducing Node
    008 5 Minute NodeJS Crash Course【公众号：密知圈】.mp4  [20.6 MB]
    027 500 Users Exercises【公众号：密知圈】.mp4  [6.6 MB]
    012 UPDATED CODE Introduction to NPM and Faker【公众号：密知圈】.html  [1.6 KB]
    029 CODE 500 Users Exercises Solutions【公众号：密知圈】.html  [1.5 KB]
    028 500 Users Exercises Solutions【公众号：密知圈】.mp4  [136.1 MB]
    006 Introduction to JOIN US app【公众号：密知圈】.mp4  [37.8 MB]
    015 REMINDER How to Start the MySQL Command Line Locally (instead of Cloud9)【公众号：密知圈】.html  [1.5 KB]
    022 Inserting Using Node【公众号：密知圈】.mp4  [78.1 MB]
    013 Introducing the MySQL Package【公众号：密知圈】.mp4  [12.6 MB]
    024 Some MySQLNode Magic【公众号：密知圈】.mp4  [128.4 MB]
    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]
    004 MySQL and Other Languages.mp4  [20.4 MB]
    018 Creating Our Users Table.srt  [9.7 KB]
    003 Section Introduction.mp4  [34.3 MB]
    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]
    016 Connecting Node to MySQL.mp4  [151.8 MB]
    004 Slides-For-This-Section.url  [71.0 B]
    027 Slides.url  [73.0 B]
    005 BUT WHAT ABOUT PHP.mp4  [81.0 MB]
    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]
    011 Introduction to NPM and Faker.mp4  [84.6 MB]
    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]
    018 Creating Our Users Table.mp4  [59.0 MB]
    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]
    025 Bulk Inserting 500 Users - Finally!.mp4  [62.2 MB]
    020 Selecting Using Node.mp4  [41.3 MB]
    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]
    018 The IN Operator【公众号：密知圈】.mp4  [67.7 MB]
    012 Logical OR_en.srt  [9.3 KB]
    024 Exercise SOLUTION_en.srt  [23.8 KB]
    023 Exercise.mp4  [14.5 MB]
    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]
    022 IS NULL.mp4  [11.6 MB]
    020 CASE.mp4  [79.3 MB]
    001 Section Introduction.mp4  [31.3 MB]
    024 Exercise SOLUTION.mp4  [208.0 MB]
    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]
    012 Logical OR.mp4  [42.2 MB]
    006 Greater Than.mp4  [15.3 MB]
    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]
    004 NOT LIKE.mp4  [8.9 MB]
    014 Between.srt  [5.7 KB]
    002 Not Equal.mp4  [25.0 MB]
    010 Logical AND.mp4  [46.2 MB]
    016 Comparing Dates.mp4  [83.4 MB]
    016 Comparing Dates_en.srt  [13.1 KB]
    014 Between.mp4  [33.0 MB]
    012 Logical OR.srt  [7.3 KB]
    005 CODE.html  [88.0 B]
    008 Less Than Or Equal To.mp4  [6.9 MB]
    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]
    001 Section Introduction【公众号：密知圈】.mp4  [35.8 MB]
    016 Instagram Challenge #7【公众号：密知圈】.mp4  [33.3 MB]
    009 CODE【公众号：密知圈】.html  [145.0 B]
    006 Instagram Challenge #2【公众号：密知圈】.mp4  [67.3 MB]
    004 Instagram Challenge #1.mp4  [20.2 MB]
    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]
    002 Getting Lots of Instagram Data.mp4  [207.7 MB]
    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]
    012 Instagram Challenge #5.mp4  [16.0 MB]
    011 CODE.html  [294.0 B]
    008 Instagram Challenge #3.mp4  [49.3 MB]
    007 CODE.html  [160.0 B]
    014 Instagram Challenge #6.mp4  [30.8 MB]
    003 ig-clone-data.sql  [429.4 KB]
    010 Instagram Challenge #4.mp4  [48.2 MB]
    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
    019 TIMESTAMPS【公众号：密知圈】.mp4  [31.7 MB]
    011 CODE【公众号：密知圈】.html  [203.0 B]
    024 SOLUTION CODE【公众号：密知圈】.html  [1.2 KB]
    002 Surveying Other Data Types【公众号：密知圈】.mp4  [27.0 MB]
    008 Working With Dates【公众号：密知圈】.mp4  [91.7 MB]
    013 CODE【公众号：密知圈】.html  [240.0 B]
    014 Time Functions【公众号：密知圈】.mp4  [15.5 MB]
    021 CODE【公众号：密知圈】.html  [296.0 B]
    012 Date Functions【公众号：密知圈】.mp4  [68.9 MB]
    002 Data-Types-Reference.url  [79.0 B]
    004 INT, TINYINT, BIGINT, etc.mp4.part-Frag40.aria2  [59.0 B]
    004 INT, TINYINT, BIGINT, etc.mp4.part-Frag45.aria2  [58.0 B]
    external-links.txt  [159.0 B]
    004 INT, TINYINT, BIGINT, etc.mp4.part-Frag47.aria2  [59.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]
    001 Section Introduction.mp4  [22.2 MB]
    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]
    004 INT, TINYINT, BIGINT, etc.mp4.part-Frag46.aria2  [56.0 B]
    003 CHAR vs. VARCHAR.srt  [17.2 KB]
    023 Data Types Exercise SOLUTION_en.srt  [22.3 KB]
    018 Date Math.mp4  [103.2 MB]
    006 FLOAT & DOUBLE.srt  [7.7 KB]
    007 DATE and TIME.srt  [6.2 KB]
    002 Surveying Other Data Types.srt  [4.0 KB]
    023 Data Types Exercise SOLUTION.mp4  [73.8 MB]
    014 Time Functions.srt  [2.8 KB]
    010 CURDATE, CURTIME, & NOW.mp4  [42.7 MB]
    020 DEFAULT & ON UPDATE TIMESTAMPS.mp4  [69.7 MB]
    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]
    016 Formatting Dates.mp4  [102.3 MB]
    020 DEFAULT & ON UPDATE TIMESTAMPS.srt  [8.8 KB]
    009 CODE.html  [530.0 B]
    016 Formatting Dates_en.srt  [15.7 KB]
    004 INT, TINYINT, BIGINT, etc.mp4.part-Frag48.aria2  [59.0 B]
    002 Surveying Other Data Types_en.srt  [5.8 KB]
    003 CHAR vs. VARCHAR.mp4  [61.0 MB]
    022 Data Types Exercise.mp4  [7.8 MB]
    008 Working With Dates.srt  [10.1 KB]
    005 DECIMAL_en.srt  [11.6 KB]
    016 Formatting Dates.srt  [12.4 KB]
    006 FLOAT & DOUBLE.mp4  [19.4 MB]
    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]
    004 INT, TINYINT, BIGINT, etc.mp4  [37.9 MB]
    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]
    005 DECIMAL.mp4  [14.7 MB]
    012 Date Functions.srt  [8.0 KB]
    001 Section Introduction_en.srt  [3.7 KB]
    007 DATE and TIME.mp4  [21.4 MB]
    003 CHAR vs. VARCHAR_en.srt  [22.1 KB]
    018 Date Math_en.srt  [17.2 KB]
📁 22 - OPTIONAL LEGACY SECTION Database Triggers
    007 Creating Logger Triggers【公众号：密知圈】.mp4  [62.2 MB]
    003 Writing Our First Trigger Part 1【公众号：密知圈】.mp4  [33.6 MB]
    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]
    004 Writing Our First Trigger Part 2.mp4  [89.3 MB]
    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]
    006 Preventing Instagram Self-Follows With Triggers.mp4  [32.8 MB]
    008 Managing Triggers And A Warning.mp4  [95.3 MB]
    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]
    002 Introduction to Database Triggers.mp4  [15.5 MB]
📁 07 - String Functions
    019 CODE【公众号：密知圈】.html  [273.0 B]
    006 CODE【公众号：密知圈】.html  [215.0 B]
    009 Combining String Functions【公众号：密知圈】.mp4  [31.4 MB]
    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]
    020 Other String Functions.mp4  [31.4 MB]
    003 Loading Our Books Data_en.srt  [10.1 KB]
    external-links.txt  [236.0 B]
    001 Section Introduction.mp4  [23.5 MB]
    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]
    023 String Functions Exerise SOLUTION.mp4  [131.9 MB]
    018 UPPER & LOWER.mp4  [34.1 MB]
    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]
    007 SUBSTRING.mp4  [50.3 MB]
    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]
    011 Sidenote SQL Formatting.mp4  [42.3 MB]
    014 REVERSE_en.srt  [5.3 KB]
    014 REVERSE.mp4  [15.0 MB]
    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]
    012 REPLACE.mp4  [36.8 MB]
    002 SLIDES.url  [86.0 B]
    017 CODE.html  [306.0 B]
    005 CONCAT.mp4  [46.0 MB]
    011 Sidenote SQL Formatting.srt  [6.9 KB]
    012 REPLACE_en.srt  [10.2 KB]
    001 Section Introduction.srt  [3.0 KB]
    002 The World Of String Functions.mp4  [14.4 MB]
    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]
    003 Loading Our Books Data.mp4  [23.5 MB]
    016 CHAR_LENGTH.mp4  [12.5 MB]
    020 Other String Functions_en.srt  [10.9 KB]
    022 String Functions Exercise.mp4  [14.3 MB]
    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]