终极MySQL训练营: 从SQL初学者到专家 | The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert 国外课程，含字母

【资源目录】:

├──1. Introduction and 5 Minutes of SQL

| ├──1. Course Introduction.en.srt 2.18kb

| ├──1. Course Introduction.mp4 5.81M

| ├──1. Course Introduction.srt 3.38kb

| ├──2. Instructor Introduction(s).en.srt 2.61kb

| ├──2. Instructor Introduction(s).mp4 8.43M

| ├──2. Instructor Introduction(s).srt 4.00kb

| ├──3. Syllabus Walkthrough and Prerequisites.en.srt 7.30kb

| ├──3. Syllabus Walkthrough and Prerequisites.mp4 12.15M

| ├──3. Syllabus Walkthrough and Prerequisites.srt 11.47kb

| ├──4. Note about SQL Editor.html 0.45kb

| ├──5. Your First 5 Minutes of SQL – Let’s Get Coding!.en.srt 10.59kb

| ├──5. Your First 5 Minutes of SQL – Let’s Get Coding!.mp4 18.32M

| ├──5. Your First 5 Minutes of SQL – Let’s Get Coding!.srt 16.89kb

| ├──5.1 SQL Try-It Editor.html 0.12kb

| ├──5.2 Lecture Slides.html 0.11kb

| ├──6. CODE Your First 5 Minutes of SQL.html 1.57kb

| ├──7. How The Course Works.en.srt 6.48kb

| ├──7. How The Course Works.mp4 22.40M

| └──7. How The Course Works.srt 10.02kb

├──10. Revisiting Data Types

| ├──1. Section 10 Introduction.en.srt 3.15kb

| ├──1. Section 10 Introduction.mp4 11.20M

| ├──1. Section 10 Introduction.srt 4.95kb

| ├──10. DATE, TIME, and DATETIME.en.srt 6.13kb

| ├──10. DATE, TIME, and DATETIME.mp4 5.47M

| ├──10. DATE, TIME, and DATETIME.srt 9.89kb

| ├──11. Creating Our DATE data.en.srt 6.61kb

| ├──11. Creating Our DATE data.mp4 8.39M

| ├──11. Creating Our DATE data.srt 10.27kb

| ├──12. CODE Creating Our DATE data.html 0.39kb

| ├──13. CURDATE, CURTIME, and NOW.en.srt 7.66kb

| ├──13. CURDATE, CURTIME, and NOW.mp4 8.22M

| ├──13. CURDATE, CURTIME, and NOW.srt 12.32kb

| ├──14. Note about formatting dates.html 0.27kb

| ├──15. Formatting Dates.en.srt 17.98kb

| ├──15. Formatting Dates.mp4 31.75M

| ├──15. Formatting Dates.srt 28.73kb

| ├──16. CODE Formatting Dates.html 0.92kb

| ├──17. Date Math.en.srt 11.79kb

| ├──17. Date Math.mp4 18.52M

| ├──17. Date Math.srt 18.65kb

| ├──18. CODE Date Math.html 0.58kb

| ├──19. Working with TIMESTAMPS.en.srt 15.12kb

| ├──19. Working with TIMESTAMPS.mp4 19.04M

| ├──19. Working with TIMESTAMPS.srt 23.79kb

| ├──2. CHAR and VARCHAR.en.srt 19.52kb

| ├──2. CHAR and VARCHAR.mp4 20.62M

| ├──2. CHAR and VARCHAR.srt 31.01kb

| ├──2.1 Slides For This Section.html 0.11kb

| ├──20. CODE Working with TIMESTAMPS.html 0.91kb

| ├──21. Data Types Exercises.en.srt 6.46kb

| ├──21. Data Types Exercises.mp4 7.01M

| ├──21. Data Types Exercises.srt 10.27kb

| ├──21.1 Slides.html 0.12kb

| ├──22. Data Types Exercises Solution.en.srt 17.64kb

| ├──22. Data Types Exercises Solution.mp4 26.43M

| ├──22. Data Types Exercises Solution.srt 27.74kb

| ├──23. CODE Data Types Exercises Solution.html 1.17kb

| ├──3. Note about CHAR and VARCHAR.html 0.35kb

| ├──4. CODE CHAR and VARCHAR.html 0.40kb

| ├──5. DECIMAL.en.srt 8.08kb

| ├──5. DECIMAL.mp4 11.28M

| ├──5. DECIMAL.srt 12.58kb

| ├──6. CODE DECIMAL.html 0.30kb

| ├──7. FLOAT and DOUBLE.en.srt 9.95kb

| ├──7. FLOAT and DOUBLE.mp4 11.60M

| ├──7. FLOAT and DOUBLE.srt 15.87kb

| ├──8. CODE FLOAT and DOUBLE.html 0.29kb

| └──9. Note about setting the timezone in Cloud9.html 0.41kb

├──11. The Power of Logical Operators

| ├──1. Section 11 Introduction.en.srt 4.25kb

| ├──1. Section 11 Introduction.mp4 15.71M

| ├──1. Section 11 Introduction.srt 6.82kb

| ├──10. Logical AND.en.srt 13.40kb

| ├──10. Logical AND.mp4 15.48M

| ├──10. Logical AND.srt 20.78kb

| ├──11. CODE Logical AND.html 1.38kb

| ├──12. Logical OR.en.srt 9.13kb

| ├──12. Logical OR.mp4 10.69M

| ├──12. Logical OR.srt 14.52kb

| ├──13. CODE Logical OR.html 1.22kb

| ├──14. Between.en.srt 14.38kb

| ├──14. Between.mp4 18.24M

| ├──14. Between.srt 22.78kb

| ├──15. CODE Between.html 0.62kb

| ├──16. In And Not In.en.srt 15.24kb

| ├──16. In And Not In.mp4 21.91M

| ├──16. In And Not In.srt 23.97kb

| ├──17. CODE In And Not In.html 1.16kb

| ├──18. Case Statements.en.srt 15.91kb

| ├──18. Case Statements.mp4 21.04M

| ├──18. Case Statements.srt 25.05kb

| ├──19. CODE Case Statements.html 1.01kb

| ├──2. Not Equal.en.srt 5.70kb

| ├──2. Not Equal.mp4 7.68M

| ├──2. Not Equal.srt 9.11kb

| ├──2.1 Slides For This Section.html 0.11kb

| ├──20. Logical Operators Exercises.en.srt 9.83kb

| ├──20. Logical Operators Exercises.mp4 10.84M

| ├──20. Logical Operators Exercises.srt 15.56kb

| ├──20.1 Slides.html 0.12kb

| ├──21. Logical Operators Exercises Solution.en.srt 22.42kb

| ├──21. Logical Operators Exercises Solution.mp4 33.28M

| ├──21. Logical Operators Exercises Solution.srt 35.13kb

| ├──22. CODE Logical Operators Exercises Solution.html 1.41kb

| ├──3. CODE Not Equal.html 0.32kb

| ├──4. Not Like.en.srt 3.59kb

| ├──4. Not Like.mp4 3.77M

| ├──4. Not Like.srt 5.72kb

| ├──5. CODE Not Like.html 0.28kb

| ├──6. Greater Than.en.srt 14.04kb

| ├──6. Greater Than.mp4 16.40M

| ├──6. Greater Than.srt 21.55kb

| ├──7. CODE Greater Than.html 0.79kb

| ├──8. Less Than.en.srt 5.22kb

| ├──8. Less Than.mp4 6.06M

| ├──8. Less Than.srt 8.13kb

| └──9. CODE Less Than.html 0.36kb

├──12. Section 12 One To Many

| ├──1. Section 12 Introduction.en.srt 2.95kb

| ├──1. Section 12 Introduction.mp4 13.30M

| ├──1. Section 12 Introduction.srt 4.70kb

| ├──10. CODE Inner Joins.html 1.13kb

| ├──11. Left Join.en.srt 22.37kb

| ├──11. Left Join.mp4 28.38M

| ├──11. Left Join.srt 35.41kb

| ├──12. CODE Left Joins.html 1.22kb

| ├──13. Right Joins Pt 1.en.srt 14.37kb

| ├──13. Right Joins Pt 1.mp4 20.32M

| ├──13. Right Joins Pt 1.srt 22.59kb

| ├──14. CODE Right Joins Part 1.html 1.56kb

| ├──15. Right Joins Pt 2.en.srt 12.81kb

| ├──15. Right Joins Pt 2.mp4 20.59M

| ├──15. Right Joins Pt 2.srt 20.18kb

| ├──16. CODE Right Joins Part 2.html 1.52kb

| ├──17. Right and Left Joins A Common Question.en.srt 4.13kb

| ├──17. Right and Left Joins A Common Question.mp4 7.93M

| ├──17. Right and Left Joins A Common Question.srt 6.50kb

| ├──18. CODE Right and Left Joins FAQ.html 0.71kb

| ├──19. Our First Joins Exercise.en.srt 10.19kb

| ├──19. Our First Joins Exercise.mp4 11.62M

| ├──19. Our First Joins Exercise.srt 16.05kb

| ├──19.1 Slides.html 0.11kb

| ├──2. Real World Data Is Messy.en.srt 16.31kb

| ├──2. Real World Data Is Messy.mp4 14.14M

| ├──2. Real World Data Is Messy.srt 25.76kb

| ├──2.1 Slides For This Section.html 0.11kb

| ├──20. Our First Joins Exercise SOLUTION.en.srt 11.90kb

| ├──20. Our First Joins Exercise SOLUTION.mp4 18.65M

| ├──20. Our First Joins Exercise SOLUTION.srt 18.53kb

| ├──21. CODE Our First Joins Exercise.html 0.78kb

| ├──22. Our First Joins Exercise SOLUTION PT. 2.en.srt 12.54kb

| ├──22. Our First Joins Exercise SOLUTION PT. 2.mp4 17.20M

| ├──22. Our First Joins Exercise SOLUTION PT. 2.srt 19.50kb

| ├──23. CODE Our First Joins Exercise SOLUTION PT. 2.html 1.60kb

| ├──3. Types of Data Relationships.en.srt 6.70kb

| ├──3. Types of Data Relationships.mp4 6.20M

| ├──3. Types of Data Relationships.srt 10.36kb

| ├──4. One To Many The Basics.en.srt 18.45kb

| ├──4. One To Many The Basics.mp4 19.03M

| ├──4. One To Many The Basics.srt 28.98kb

| ├──5. Working With Foreign Keys.en.srt 16.81kb

| ├──5. Working With Foreign Keys.mp4 22.68M

| ├──5. Working With Foreign Keys.srt 26.42kb

| ├──6. CODE Working With Foreign Keys.html 1.30kb

| ├──7. Cross Join.en.srt 10.49kb

| ├──7. Cross Join.mp4 14.49M

| ├──7. Cross Join.srt 16.47kb

| ├──8. CODE Cross Joins.html 0.56kb

| ├──9. Inner Join.en.srt 16.17kb

| ├──9. Inner Join.mp4 27.58M

| └──9. Inner Join.srt 25.59kb

├──13. Section 13 Many To Many

| ├──1. Section 13 Introduction.en.srt 2.96kb

| ├──1. Section 13 Introduction.mp4 12.99M

| ├──1. Section 13 Introduction.srt 4.58kb

| ├──10. CODE TV Joins Challenge 3 SOLUTION.html 0.39kb

| ├──11. TV Joins Challenge 4.en.srt 7.87kb

| ├──11. TV Joins Challenge 4.mp4 12.33M

| ├──11. TV Joins Challenge 4.srt 12.61kb

| ├──12. CODE TV Joins Challenge 4 SOLUTION.html 0.22kb

| ├──13. TV Joins Challenge 5.en.srt 6.65kb

| ├──13. TV Joins Challenge 5.mp4 9.63M

| ├──13. TV Joins Challenge 5.srt 10.41kb

| ├──14. CODE TV Joins Challenge 5 SOLUTION.html 0.26kb

| ├──15. TV Joins Challenge 6.en.srt 15.54kb

| ├──15. TV Joins Challenge 6.mp4 23.35M

| ├──15. TV Joins Challenge 6.srt 24.61kb

| ├──16. CODE TV Joins Challenge 6 SOLUTION.html 1.26kb

| ├──17. TV Joins Challenge 7.en.srt 9.13kb

| ├──17. TV Joins Challenge 7.mp4 15.50M

| ├──17. TV Joins Challenge 7.srt 14.68kb

| ├──18. CODE TV Joins Challenge 7 SOLUTION.html 0.31kb

| ├──2. Many To Many Basics.en.srt 15.26kb

| ├──2. Many To Many Basics.mp4 14.22M

| ├──2. Many To Many Basics.srt 24.41kb

| ├──2.1 Slides.html 0.11kb

| ├──3. Creating Our Tables.en.srt 14.41kb

| ├──3. Creating Our Tables.mp4 21.84M

| ├──3. Creating Our Tables.srt 22.49kb

| ├──4. CODE Creating Our Tables.html 2.37kb

| ├──5. TV Joins Challenge 1.en.srt 6.24kb

| ├──5. TV Joins Challenge 1.mp4 11.79M

| ├──5. TV Joins Challenge 1.srt 9.83kb

| ├──6. CODE TV Joins Challenge 1 Solution.html 0.20kb

| ├──7. TV Joins Challenge 2.en.srt 8.89kb

| ├──7. TV Joins Challenge 2.mp4 13.25M

| ├──7. TV Joins Challenge 2.srt 13.97kb

| ├──8. CODE TV Joins Challenge 2 SOLUTION.html 0.23kb

| ├──9. TV Joins Challenge 3.en.srt 6.58kb

| ├──9. TV Joins Challenge 3.mp4 11.45M

| └──9. TV Joins Challenge 3.srt 10.43kb

├──14. Instagram Database Clone

| ├──1. Section 14 Introduction.en.srt 2.06kb

| ├──1. Section 14 Introduction.mp4 9.48M

| ├──1. Section 14 Introduction.srt 3.25kb

| ├──10. CODE IG Clone Likes Schema.html 0.29kb

| ├──11. Cloning Instagram’s DB Followers Schema.en.srt 9.98kb

| ├──11. Cloning Instagram’s DB Followers Schema.mp4 12.65M

| ├──11. Cloning Instagram’s DB Followers Schema.srt 15.50kb

| ├──12. CODE IG Clone Followers Schema.html 0.31kb

| ├──13. Note about Cloning Instagram’s DB Hashtags Part 1.html 0.39kb

| ├──14. Cloning Instagram’s DB Hashtags Part 1.en.srt 14.96kb

| ├──14. Cloning Instagram’s DB Hashtags Part 1.mp4 21.83M

| ├──14. Cloning Instagram’s DB Hashtags Part 1.srt 24.13kb

| ├──15. Cloning Instagram’s DB Hashtags Part 2.en.srt 6.98kb

| ├──15. Cloning Instagram’s DB Hashtags Part 2.mp4 11.77M

| ├──15. Cloning Instagram’s DB Hashtags Part 2.srt 10.89kb

| ├──16. CODE IG Clone Hashtags Schema.html 0.38kb

| ├──17. CODE Complete IG Clone Schema.html 1.57kb

| ├──2. Introduction To Instagram Clone Schema.en.srt 13.41kb

| ├──2. Introduction To Instagram Clone Schema.mp4 21.73M

| ├──2. Introduction To Instagram Clone Schema.srt 21.05kb

| ├──2.1 Slides For This Section.html 0.11kb

| ├──3. Cloning Instagram’s DB Users Schema.en.srt 8.78kb

| ├──3. Cloning Instagram’s DB Users Schema.mp4 9.49M

| ├──3. Cloning Instagram’s DB Users Schema.srt 13.79kb

| ├──4. CODE IG Clone Users Schema.html 0.18kb

| ├──5. Cloning Instagram’s DB Photos Schema.en.srt 8.28kb

| ├──5. Cloning Instagram’s DB Photos Schema.mp4 11.71M

| ├──5. Cloning Instagram’s DB Photos Schema.srt 13.24kb

| ├──6. CODE IG Clone Photos Schema.html 0.25kb

| ├──7. Cloning Instagram’s DB Comments Schema.en.srt 8.59kb

| ├──7. Cloning Instagram’s DB Comments Schema.mp4 12.94M

| ├──7. Cloning Instagram’s DB Comments Schema.srt 13.50kb

| ├──8. CODE IG Clone Comments Schema.html 0.34kb

| ├──9. Cloning Instagram’s DB Likes Schema.en.srt 10.34kb

| ├──9. Cloning Instagram’s DB Likes Schema.mp4 20.56M

| └──9. Cloning Instagram’s DB Likes Schema.srt 16.35kb

├──15. Working With Lots Of Instagram Data

| ├──1. Section 15 Introduction.en.srt 2.68kb

| ├──1. Section 15 Introduction.mp4 11.26M

| ├──1. Section 15 Introduction.srt 4.24kb

| ├──10. Instagram Challenge 3 Solution CODE.html 0.21kb

| ├──11. Instagram Clone Challenge 4.en.srt 9.27kb

| ├──11. Instagram Clone Challenge 4.mp4 15.84M

| ├──11. Instagram Clone Challenge 4.srt 14.69kb

| ├──12. Instagram Challenge 4 Solution CODE.html 0.36kb

| ├──13. Instagram Clone Challenge 5.en.srt 4.52kb

| ├──13. Instagram Clone Challenge 5.mp4 5.40M

| ├──13. Instagram Clone Challenge 5.srt 7.07kb

| ├──14. Instagram Challenge 5 Solution CODE.html 0.23kb

| ├──15. Instagram Clone Challenge 6.en.srt 6.57kb

| ├──15. Instagram Clone Challenge 6.mp4 11.74M

| ├──15. Instagram Clone Challenge 6.srt 10.57kb

| ├──16. Instagram Challenge 6 Solution CODE.html 0.33kb

| ├──17. Note about Instagram Clone Challenge 7.html 0.38kb

| ├──18. Instagram Clone Challenge 7.en.srt 7.04kb

| ├──18. Instagram Clone Challenge 7.mp4 10.97M

| ├──18. Instagram Clone Challenge 7.srt 11.27kb

| ├──19. Instagram Challenge 7 Solution CODE.html 0.35kb

| ├──2. Note about Loading The JUMBO dataset.html 0.73kb

| ├──3. Loading The JUMBO dataset.en.srt 12.48kb

| ├──3. Loading The JUMBO dataset.mp4 59.24M

| ├──3. Loading The JUMBO dataset.srt 19.99kb

| ├──4. The Instagram Clone DATASET.html 0.37kb

| ├──4.1 ig_clone_data.sql 429.36kb

| ├──5. Instagram Clone Challenge 1.en.srt 6.89kb

| ├──5. Instagram Clone Challenge 1.mp4 8.62M

| ├──5. Instagram Clone Challenge 1.srt 11.01kb

| ├──5.1 Slides.html 0.11kb

| ├──6. Instagram Challenge 1 Solution CODE.html 0.12kb

| ├──7. Instagram Clone Challenge 2.en.srt 10.07kb

| ├──7. Instagram Clone Challenge 2.mp4 11.71M

| ├──7. Instagram Clone Challenge 2.srt 15.96kb

| ├──8. Instagram Challenge 2 Solution CODE.html 0.21kb

| ├──9. Instagram Clone Challenge 3.en.srt 10.84kb

| ├──9. Instagram Clone Challenge 3.mp4 17.26M

| └──9. Instagram Clone Challenge 3.srt 17.70kb

├──16. Section 16 – Introducing Node

| ├──1. Note about Introducing Node.html 0.34kb

| ├──10. Introduction to NPM and Faker.en.srt 12.55kb

| ├──10. Introduction to NPM and Faker.mp4 15.89M

| ├──10. Introduction to NPM and Faker.srt 20.09kb

| ├──10.1 FakerJS Github Repo.html 0.09kb

| ├──11. CODE Introduction to NPM and Faker.html 1.21kb

| ├──12. Introducing the MySQL Package.en.srt 7.70kb

| ├──12. Introducing the MySQL Package.mp4 6.91M

| ├──12. Introducing the MySQL Package.srt 12.09kb

| ├──12.1 MySQL Node Package Github Repo.html 0.09kb

| ├──13. Note about connecting Node to MySQL.html 3.70kb

| ├──14. Connecting Node to MySQL.en.srt 18.11kb

| ├──14. Connecting Node to MySQL.mp4 23.06M

| ├──14. Connecting Node to MySQL.srt 28.86kb

| ├──15. CODE Connecting Node to MySQL.html 2.48kb

| ├──16. Creating Our Users Table.en.srt 10.64kb

| ├──16. Creating Our Users Table.mp4 13.99M

| ├──16. Creating Our Users Table.srt 16.98kb

| ├──17. CODE Creating Our Users Table.html 0.18kb

| ├──18. Selecting Using Node.en.srt 8.91kb

| ├──18. Selecting Using Node.mp4 11.35M

| ├──18. Selecting Using Node.srt 14.22kb

| ├──19. CODE Selecting Using Node.html 0.92kb

| ├──2. Section 16 Introduction.en.srt 2.65kb

| ├──2. Section 16 Introduction.mp4 13.13M

| ├──2. Section 16 Introduction.srt 4.23kb

| ├──20. Inserting Using Node.en.srt 16.42kb

| ├──20. Inserting Using Node.mp4 21.92M

| ├──20. Inserting Using Node.srt 26.25kb

| ├──21. CODE Inserting Using Node.html 0.71kb

| ├──22. Some MySQLNode Magic.en.srt 10.77kb

| ├──22. Some MySQLNode Magic.mp4 17.87M

| ├──22. Some MySQLNode Magic.srt 17.09kb

| ├──23. Bulk Inserting 500 Users – Finally!.en.srt 12.83kb

| ├──23. Bulk Inserting 500 Users – Finally!.mp4 22.41M

| ├──23. Bulk Inserting 500 Users – Finally!.srt 20.26kb

| ├──24. CODE Bulk Inserting 500 Users.html 0.56kb

| ├──25. 500 Users Exercises.en.srt 3.92kb

| ├──25. 500 Users Exercises.mp4 3.45M

| ├──25. 500 Users Exercises.srt 6.06kb

| ├──25.1 Slides.html 0.11kb

| ├──26. 500 Users Exercises Solutions.en.srt 15.04kb

| ├──26. 500 Users Exercises Solutions.mp4 21.87M

| ├──26. 500 Users Exercises Solutions.srt 23.68kb

| ├──27. CODE 500 Users Exercises Solutions.html 1.29kb

| ├──3. MySQL and Other Languages.en.srt 14.70kb

| ├──3. MySQL and Other Languages.mp4 11.16M

| ├──3. MySQL and Other Languages.srt 23.20kb

| ├──3.1 Slides For This Section.html 0.11kb

| ├──4. BUT WHAT ABOUT PHP.en.srt 11.67kb

| ├──4. BUT WHAT ABOUT PHP.mp4 15.16M

| ├──4. BUT WHAT ABOUT PHP.srt 18.06kb

| ├──5. Introduction to JOIN US app.en.srt 12.70kb

| ├──5. Introduction to JOIN US app.mp4 11.94M

| ├──5. Introduction to JOIN US app.srt 20.54kb

| ├──6. Note about Setting Up Cloud9 for Node.html 0.82kb

| ├──7. 5 Minute NodeJS Crash Course.en.srt 9.15kb

| ├──7. 5 Minute NodeJS Crash Course.mp4 9.35M

| ├──7. 5 Minute NodeJS Crash Course.srt 14.62kb

| ├──8. CODE 5 Minute Node Crash Course.html 0.27kb

| └──9. Note about Faker install.html 2.16kb

├──17. Section 17 – Building Our Web App

| ├──1. Section 17 Introduction.en.srt 3.10kb

| ├──1. Section 17 Introduction.mp4 11.74M

| ├──1. Section 17 Introduction.srt 4.98kb

| ├──10. Connecting Express and MySQL.en.srt 15.40kb

| ├──10. Connecting Express and MySQL.mp4 20.78M

| ├──10. Connecting Express and MySQL.srt 24.60kb

| ├──11. CODE Connecting Express and MySQL.html 0.36kb

| ├──12. Adding EJS Templates.en.srt 24.38kb

| ├──12. Adding EJS Templates.mp4 30.46M

| ├──12. Adding EJS Templates.srt 38.61kb

| ├──13. CODE Adding EJS Templates.html 0.62kb

| ├──14. Connecting The Form.en.srt 26.90kb

| ├──14. Connecting The Form.mp4 36.23M

| ├──14. Connecting The Form.srt 42.98kb

| ├──15. CODE Connecting the Form.html 0.34kb

| ├──16. Styling Part 1.en.srt 12.16kb

| ├──16. Styling Part 1.mp4 17.98M

| ├──16. Styling Part 1.srt 19.21kb

| ├──17. CODE HTML AND CSS FILES.html 0.11kb

| ├──17.1 JOIN_US_HTML_AND_CSS.zip 2.70kb

| ├──18. Styling Part 2.en.srt 11.88kb

| ├──18. Styling Part 2.mp4 18.37M

| ├──18. Styling Part 2.srt 19.00kb

| ├──2. Join Us Completed CODE.html 0.33kb

| ├──2.1 JoinUsCompleteCode.zip 3.75M

| ├──3. Introducing Express.en.srt 9.51kb

| ├──3. Introducing Express.mp4 9.54M

| ├──3. Introducing Express.srt 15.09kb

| ├──3.1 Slides.html 0.11kb

| ├──3.2 Express Documentation.html 0.08kb

| ├──4. NPM Init and package.json files.en.srt 9.96kb

| ├──4. NPM Init and package.json files.mp4 11.60M

| ├──4. NPM Init and package.json files.srt 15.94kb

| ├──5. Note about Our First Simple Web App.html 0.48kb

| ├──6. Our First Simple Web App.en.srt 24.76kb

| ├──6. Our First Simple Web App.mp4 28.19M

| ├──6. Our First Simple Web App.srt 39.85kb

| ├──7. CODE Our First Simple Web App.html 0.40kb

| ├──8. Adding Multiple Routes.en.srt 14.65kb

| ├──8. Adding Multiple Routes.mp4 18.67M

| ├──8. Adding Multiple Routes.srt 23.60kb

| └──9. CODE Adding Multiple Routes.html 0.46kb

├──18. Section 18 – Database Triggers

| ├──1. Introduction to Database Triggers.en.srt 9.88kb

| ├──1. Introduction to Database Triggers.mp4 27.62M

| ├──1. Introduction to Database Triggers.srt 15.45kb

| ├──1.1 Lecture Slides.html 0.12kb

| ├──2. Writing Our First Trigger Part 1.en.srt 10.78kb

| ├──2. Writing Our First Trigger Part 1.mp4 11.34M

| ├──2. Writing Our First Trigger Part 1.srt 16.69kb

| ├──2.1 Lecture Slides.html 0.12kb

| ├──3. Writing Our First Trigger Part 2.en.srt 17.19kb

| ├──3. Writing Our First Trigger Part 2.mp4 22.78M

| ├──3. Writing Our First Trigger Part 2.srt 26.98kb

| ├──3.1 Lecture Slides.html 0.12kb

| ├──4. Note about next lecture.html 0.55kb

| ├──5. Preventing Instagram Self-Follows With Triggers.en.srt 11.71kb

| ├──5. Preventing Instagram Self-Follows With Triggers.mp4 14.12M

| ├──5. Preventing Instagram Self-Follows With Triggers.srt 18.15kb

| ├──5.1 Lecture Slides.html 0.12kb

| ├──6. Creating Logger Triggers.en.srt 13.80kb

| ├──6. Creating Logger Triggers.mp4 18.63M

| ├──6. Creating Logger Triggers.srt 21.72kb

| ├──6.1 Lecture Slides.html 0.12kb

| ├──7. Managing Triggers And A Warning.en.srt 9.29kb

| ├──7. Managing Triggers And A Warning.mp4 12.55M

| ├──7. Managing Triggers And A Warning.srt 14.54kb

| └──7.1 Lecture Slides.html 0.12kb

├──2. Getting Started Overview and Installation

| ├──1. Section Introduction.en.srt 1.94kb

| ├──1. Section Introduction.mp4 7.98M

| ├──1. Section Introduction.srt 2.99kb

| ├──2. What Is a Database.en.srt 10.47kb

| ├──2. What Is a Database.mp4 10.27M

| ├──2. What Is a Database.srt 16.59kb

| ├──2.1 Slides For This Section.html 0.10kb

| ├──3. SQL Vs. MySQL.en.srt 8.08kb

| ├──3. SQL Vs. MySQL.mp4 7.71M

| ├──3. SQL Vs. MySQL.srt 12.65kb

| ├──4. Installation Overview – WATCH BEFORE INSTALLING.en.srt 8.19kb

| ├──4. Installation Overview – WATCH BEFORE INSTALLING.mp4 6.63M

| ├──4. Installation Overview – WATCH BEFORE INSTALLING.srt 12.75kb

| ├──4.1 Installation Slides.html 0.10kb

| ├──5. Cloud9 Registration IMPORTANT – PLEASE READ!!!.html 2.06kb

| ├──6. Mac Installation.en.srt 17.73kb

| ├──6. Mac Installation.mp4 22.18M

| ├──6. Mac Installation.srt 28.05kb

| ├──7. CODE Mac Installation.html 1.31kb

| ├──8. Windows Installation.en.srt 6.40kb

| ├──8. Windows Installation.mp4 5.74M

| └──8. Windows Installation.srt 9.95kb

├──3. Creating Databases and Tables

| ├──1. Section 3 Introduction.en.srt 1.96kb

| ├──1. Section 3 Introduction.mp4 9.38M

| ├──1. Section 3 Introduction.srt 3.08kb

| ├──10. Note about INT max size.html 0.39kb

| ├──11. Basic Datatypes Challenge.en.srt 3.73kb

| ├──11. Basic Datatypes Challenge.mp4 3.52M

| ├──11. Basic Datatypes Challenge.srt 5.96kb

| ├──12. Basic Datatypes Challenge – Solution.html 0.18kb

| ├──13. Creating Your Own Tables.en.srt 4.08kb

| ├──13. Creating Your Own Tables.mp4 3.95M

| ├──13. Creating Your Own Tables.srt 6.40kb

| ├──14. CODE Creating Your Own Tables.html 0.24kb

| ├──15. How Do We Know It Worked.en.srt 3.80kb

| ├──15. How Do We Know It Worked.mp4 3.52M

| ├──15. How Do We Know It Worked.srt 5.92kb

| ├──16. CODE How Do We Know It Worked.html 0.10kb

| ├──17. Dropping Tables.en.srt 2.57kb

| ├──17. Dropping Tables.mp4 2.10M

| ├──17. Dropping Tables.srt 3.96kb

| ├──18. CODE Dropping Tables.html 0.18kb

| ├──19. Creating Your Own Tables Challenge.en.srt 6.36kb

| ├──19. Creating Your Own Tables Challenge.mp4 6.08M

| ├──19. Creating Your Own Tables Challenge.srt 10.03kb

| ├──19.1 Slides.html 0.12kb

| ├──2. Creating Databases.en.srt 7.44kb

| ├──2. Creating Databases.mp4 7.24M

| ├──2. Creating Databases.srt 12.02kb

| ├──2.1 Slides For This Section!.html 0.11kb

| ├──20. CODE Creating Your Own Tables Challenge.html 0.16kb

| ├──3. CODE Creating Databases.html 0.38kb

| ├──4. Dropping Databases.en.srt 2.65kb

| ├──4. Dropping Databases.mp4 2.46M

| ├──4. Dropping Databases.srt 4.08kb

| ├──5. CODE Dropping Databases.html 0.29kb

| ├──6. Using Databases.en.srt 3.91kb

| ├──6. Using Databases.mp4 4.40M

| ├──6. Using Databases.srt 6.24kb

| ├──7. CODE Using Databases.html 0.12kb

| ├──8. Introduction to Tables.en.srt 7.70kb

| ├──8. Introduction to Tables.mp4 7.12M

| ├──8. Introduction to Tables.srt 12.06kb

| ├──9. The Basic Datatypes.en.srt 11.33kb

| ├──9. The Basic Datatypes.mp4 10.77M

| └──9. The Basic Datatypes.srt 17.92kb

├──4. Inserting Data (and a couple other things)

| ├──1. Section 4 Introduction.en.srt 2.63kb

| ├──1. Section 4 Introduction.mp4 10.81M

| ├──1. Section 4 Introduction.srt 4.06kb

| ├──10. INSERT Challenges Solution.en.srt 4.98kb

| ├──10. INSERT Challenges Solution.mp4 7.17M

| ├──10. INSERT Challenges Solution.srt 7.70kb

| ├──11. CODE INSERT Challenges Solution.html 0.82kb

| ├──12. NOTE MySQL Warnings.html 0.52kb

| ├──13. MySQL Warnings.en.srt 4.95kb

| ├──13. MySQL Warnings.mp4 8.63M

| ├──13. MySQL Warnings.srt 7.85kb

| ├──14. CODE MySQL Warnings.html 0.62kb

| ├──15. NULL and NOT_NULL.en.srt 8.27kb

| ├──15. NULL and NOT_NULL.mp4 10.17M

| ├──15. NULL and NOT_NULL.srt 13.31kb

| ├──16. CODE NULL and NOT NULL.html 1.10kb

| ├──17. Setting Default Values.en.srt 8.37kb

| ├──17. Setting Default Values.mp4 10.38M

| ├──17. Setting Default Values.srt 13.28kb

| ├──18. CODE Setting Default Values.html 1.19kb

| ├──19. A Primer On Primary Keys.en.srt 16.00kb

| ├──19. A Primer On Primary Keys.mp4 18.19M

| ├──19. A Primer On Primary Keys.srt 25.25kb

| ├──2. Inserting Data.en.srt 7.01kb

| ├──2. Inserting Data.mp4 6.69M

| ├──2. Inserting Data.srt 11.23kb

| ├──2.1 Slides For This Section.html 0.11kb

| ├──20. CODE A Primer on Primary Keys.html 1.43kb

| ├──21. Table Constraints Exercise.en.srt 3.12kb

| ├──21. Table Constraints Exercise.mp4 2.61M

| ├──21. Table Constraints Exercise.srt 4.85kb

| ├──21.1 Exercise Slides.html 0.11kb

| ├──22. Table Constraints Exercise Solution.en.srt 4.52kb

| ├──22. Table Constraints Exercise Solution.mp4 7.99M

| ├──22. Table Constraints Exercise Solution.srt 6.99kb

| ├──23. CODE Table Constraints Exercise Solution.html 0.92kb

| ├──3. CODE Inserting Data.html 0.26kb

| ├──4. Super Quick Intro To SELECT.en.srt 3.23kb

| ├──4. Super Quick Intro To SELECT.mp4 2.95M

| ├──4. Super Quick Intro To SELECT.srt 5.08kb

| ├──5. CODE Super Quick Intro To SELECT.html 0.04kb

| ├──6. Multiple INSERT.en.srt 4.07kb

| ├──6. Multiple INSERT.mp4 4.06M

| ├──6. Multiple INSERT.srt 6.39kb

| ├──7. CODE Multiple Insert.html 0.18kb

| ├──8. INSERT Challenges.en.srt 2.25kb

| ├──8. INSERT Challenges.mp4 2.18M

| ├──8. INSERT Challenges.srt 3.53kb

| └──9. Note about using quotes inside of inserted values.html 0.49kb

├──5. CRUD commmands

| ├──1. Section 5 Introduction.en.srt 2.57kb

| ├──1. Section 5 Introduction.mp4 13.30M

| ├──1. Section 5 Introduction.srt 4.02kb

| ├──10. SELECT Challenges.en.srt 2.85kb

| ├──10. SELECT Challenges.mp4 3.08M

| ├──10. SELECT Challenges.srt 4.57kb

| ├──11. SELECT Challenges Solution.en.srt 3.61kb

| ├──11. SELECT Challenges Solution.mp4 4.08M

| ├──11. SELECT Challenges Solution.srt 5.80kb

| ├──12. CODE SELECT Challenges Solution.html 0.38kb

| ├──13. Introduction to Aliases.en.srt 3.92kb

| ├──13. Introduction to Aliases.mp4 3.95M

| ├──13. Introduction to Aliases.srt 6.31kb

| ├──14. CODE Introduction to Aliases.html 0.19kb

| ├──15. The UPDATE Command.en.srt 5.18kb

| ├──15. The UPDATE Command.mp4 5.44M

| ├──15. The UPDATE Command.srt 8.33kb

| ├──16. CODE The UPDATE Command.html 0.28kb

| ├──17. UPDATE Challenges.en.srt 0.85kb

| ├──17. UPDATE Challenges.mp4 855.66kb

| ├──17. UPDATE Challenges.srt 1.32kb

| ├──18. UPDATE Challenges Solution.en.srt 4.75kb

| ├──18. UPDATE Challenges Solution.mp4 5.65M

| ├──18. UPDATE Challenges Solution.srt 7.73kb

| ├──19. CODE UPDATE Challenges Solution.html 0.55kb

| ├──2. Introduction to CRUD.en.srt 2.59kb

| ├──2. Introduction to CRUD.mp4 2.26M

| ├──2. Introduction to CRUD.srt 4.08kb

| ├──2.1 This Section’s Slides.html 0.11kb

| ├──20. Introduction to DELETE.en.srt 6.74kb

| ├──20. Introduction to DELETE.mp4 6.17M

| ├──20. Introduction to DELETE.srt 10.56kb

| ├──21. CODE Introduction to DELETE.html 0.23kb

| ├──22. DELETE Challenges.en.srt 1.85kb

| ├──22. DELETE Challenges.mp4 1.64M

| ├──22. DELETE Challenges.srt 2.81kb

| ├──22.1 Slides.html 0.12kb

| ├──23. DELETE Challenges Solution.en.srt 3.36kb

| ├──23. DELETE Challenges Solution.mp4 4.26M

| ├──23. DELETE Challenges Solution.srt 5.43kb

| ├──24. CODE DELETE Challenges Solution.html 0.31kb

| ├──3. CODE Introduction to CRUD.html 0.07kb

| ├──4. Preparing Our Data.en.srt 3.54kb

| ├──4. Preparing Our Data.mp4 3.70M

| ├──4. Preparing Our Data.srt 5.61kb

| ├──5. CODE Preparing Our Data.html 0.79kb

| ├──6. Official Introduction to SELECT.en.srt 5.33kb

| ├──6. Official Introduction to SELECT.mp4 6.13M

| ├──6. Official Introduction to SELECT.srt 8.84kb

| ├──7. CODE Official Introduction to SELECT.html 0.56kb

| ├──8. Introduction to WHERE.en.srt 7.02kb

| ├──8. Introduction to WHERE.mp4 6.82M

| ├──8. Introduction to WHERE.srt 11.23kb

| └──9. CODE Introduction to WHERE.html 0.30kb

├──6. CRUD Challenge Section

| ├──1. Section 6 Introduction.en.srt 3.18kb

| ├──1. Section 6 Introduction.mp4 14.46M

| ├──1. Section 6 Introduction.srt 4.88kb

| ├──10. CODE CRUD Exercise Delete Solution.html 0.39kb

| ├──2. CRUD Exercise Overview.en.srt 11.34kb

| ├──2. CRUD Exercise Overview.mp4 10.62M

| ├──2. CRUD Exercise Overview.srt 17.92kb

| ├──2.1 Slides.html 0.12kb

| ├──3. CRUD Exercise Create Solution.en.srt 7.13kb

| ├──3. CRUD Exercise Create Solution.mp4 8.93M

| ├──3. CRUD Exercise Create Solution.srt 11.61kb

| ├──4. CODE CRUD Exercise Create Solution.html 0.78kb

| ├──5. CRUD Exercise Read Solution.en.srt 2.10kb

| ├──5. CRUD Exercise Read Solution.mp4 2.89M

| ├──5. CRUD Exercise Read Solution.srt 3.38kb

| ├──6. CODE CRUD Exercise Read Solution.html 0.19kb

| ├──7. CRUD Exercise Update Solution.en.srt 5.09kb

| ├──7. CRUD Exercise Update Solution.mp4 6.39M

| ├──7. CRUD Exercise Update Solution.srt 8.09kb

| ├──8. CODE CRUD Exercise Update Solution.html 0.62kb

| ├──9. CRUD Exercise Delete Solution.en.srt 4.24kb

| ├──9. CRUD Exercise Delete Solution.mp4 4.88M

| └──9. CRUD Exercise Delete Solution.srt 6.75kb

├──7. The World Of String Functions

| ├──1. Section 7 Introduction.en.srt 3.29kb

| ├──1. Section 7 Introduction.mp4 11.20M

| ├──1. Section 7 Introduction.srt 5.11kb

| ├──10. CODE Introducing SUBSTRING.html 0.79kb

| ├──11. Introducing REPLACE.en.srt 8.35kb

| ├──11. Introducing REPLACE.mp4 11.46M

| ├──11. Introducing REPLACE.srt 13.52kb

| ├──12. CODE Introducing REPLACE.html 0.87kb

| ├──13. Using REVERSE.en.srt 4.60kb

| ├──13. Using REVERSE.mp4 5.38M

| ├──13. Using REVERSE.srt 7.22kb

| ├──14. CODE Using REVERSE.html 0.24kb

| ├──15. Working with CHAR LENGTH.en.srt 6.52kb

| ├──15. Working with CHAR LENGTH.mp4 8.32M

| ├──15. Working with CHAR LENGTH.srt 10.08kb

| ├──16. CODE Working with CHAR LENGTH.html 0.32kb

| ├──17. Changing Case with UPPER and LOWER.en.srt 4.61kb

| ├──17. Changing Case with UPPER and LOWER.mp4 6.14M

| ├──17. Changing Case with UPPER and LOWER.srt 7.26kb

| ├──18. CODE Changing Case with UPPER and LOWER.html 0.25kb

| ├──19. Note about string functions.html 1.44kb

| ├──2. Important Note about Running SQL Files (please read).html 0.45kb

| ├──20. String Function Challenges.en.srt 6.59kb

| ├──20. String Function Challenges.mp4 7.20M

| ├──20. String Function Challenges.srt 10.27kb

| ├──20.1 Slides.html 0.12kb

| ├──21. String Function Challenges Solution.en.srt 15.54kb

| ├──21. String Function Challenges Solution.mp4 24.79M

| ├──21. String Function Challenges Solution.srt 24.39kb

| ├──22. CODE String Function Challenges Solution.html 1.33kb

| ├──3. Running SQL Files.en.srt 13.83kb

| ├──3. Running SQL Files.mp4 15.17M

| ├──3. Running SQL Files.srt 22.36kb

| ├──3.1 Slides For This Section.html 0.11kb

| ├──4. CODE Running SQL Files.html 0.39kb

| ├──5. Loading Our Book Data.en.srt 7.89kb

| ├──5. Loading Our Book Data.mp4 13.04M

| ├──5. Loading Our Book Data.srt 12.51kb

| ├──5.1 book_data.sql 1.31kb

| ├──6. CODE Loading Our Book Data.html 1.67kb

| ├──7. Working with CONCAT.en.srt 15.60kb

| ├──7. Working with CONCAT.mp4 23.01M

| ├──7. Working with CONCAT.srt 24.85kb

| ├──8. CODE Working With CONCAT.html 0.92kb

| ├──9. Introducing SUBSTRING.en.srt 13.53kb

| ├──9. Introducing SUBSTRING.mp4 15.73M

| └──9. Introducing SUBSTRING.srt 21.39kb

├──8. Refining Our Selections

| ├──1. Section 8 Introduction.en.srt 1.05kb

| ├──1. Section 8 Introduction.mp4 4.63M

| ├──1. Section 8 Introduction.srt 1.58kb

| ├──10. Better Searches with LIKE.en.srt 10.44kb

| ├──10. Better Searches with LIKE.mp4 10.47M

| ├──10. Better Searches with LIKE.srt 16.65kb

| ├──11. CODE Better Searches with LIKE.html 0.32kb

| ├──12. LIKE Part 2 More Wildcards.en.srt 8.96kb

| ├──12. LIKE Part 2 More Wildcards.mp4 9.48M

| ├──12. LIKE Part 2 More Wildcards.srt 13.83kb

| ├──13. CODE LIKE Part 2 More Wildcards.html 0.38kb

| ├──14. Refining Selections Exercises.en.srt 7.07kb

| ├──14. Refining Selections Exercises.mp4 7.49M

| ├──14. Refining Selections Exercises.srt 11.01kb

| ├──14.1 Slides.html 0.12kb

| ├──15. Refining Selections Exercises Solution.en.srt 16.47kb

| ├──15. Refining Selections Exercises Solution.mp4 24.87M

| ├──15. Refining Selections Exercises Solution.srt 25.33kb

| ├──16. CODE Refining Selections Exercises Solution.html 0.71kb

| ├──2. Seed Data Adding A Couple New Books.en.srt 4.65kb

| ├──2. Seed Data Adding A Couple New Books.mp4 3.82M

| ├──2. Seed Data Adding A Couple New Books.srt 7.29kb

| ├──2.1 Slides For This Section.html 0.11kb

| ├──3. CODE Seed Data Adding A Couple New Books.html 0.35kb

| ├──4. Using DISTINCT.en.srt 11.05kb

| ├──4. Using DISTINCT.mp4 12.71M

| ├──4. Using DISTINCT.srt 17.82kb

| ├──5. CODE Using DISTINCT.html 0.28kb

| ├──6. Sorting Data with ORDER BY.en.srt 2.24kb

| ├──6. Sorting Data with ORDER BY.mp4 19.54M

| ├──6. Sorting Data with ORDER BY.srt 3.50kb

| ├──7. CODE Sorting Data with ORDER BY.html 0.97kb

| ├──8. Using LIMIT.en.srt 13.01kb

| ├──8. Using LIMIT.mp4 16.37M

| ├──8. Using LIMIT.srt 20.61kb

| └──9. CODE Using LIMIT.html 0.88kb

└──9. The Magic of Aggregate Functions

| ├──1. Section 9 Introduction.en.srt 6.42kb

| ├──1. Section 9 Introduction.mp4 17.55M

| ├──1. Section 9 Introduction.srt 9.89kb

| ├──10. Using Min and Max with Group By.en.srt 8.51kb

| ├──10. Using Min and Max with Group By.mp4 10.35M

| ├──10. Using Min and Max with Group By.srt 13.88kb

| ├──11. CODE Using Min and Max with Group By.html 0.42kb

| ├──12. The Sum Function.en.srt 5.73kb

| ├──12. The Sum Function.mp4 6.38M

| ├──12. The Sum Function.srt 9.10kb

| ├──13. CODE The Sum Function.html 0.34kb

| ├──14. The Avg Function.en.srt 8.39kb

| ├──14. The Avg Function.mp4 8.60M

| ├──14. The Avg Function.srt 13.19kb

| ├──15. CODE The Avg Function.html 0.34kb

| ├──16. Aggregate Functions Challenges.en.srt 5.83kb

| ├──16. Aggregate Functions Challenges.mp4 5.82M

| ├──16. Aggregate Functions Challenges.srt 9.04kb

| ├──16.1 Slides.html 0.13kb

| ├──17. Aggregate Functions Challenges Solution.en.srt 10.26kb

| ├──17. Aggregate Functions Challenges Solution.mp4 14.85M

| ├──17. Aggregate Functions Challenges Solution.srt 16.22kb

| ├──18. CODE Aggregate Functions Challenges Solution.html 0.82kb

| ├──2. The Count Function.en.srt 11.78kb

| ├──2. The Count Function.mp4 12.93M

| ├──2. The Count Function.srt 18.53kb

| ├──2.1 Slides For This Section.html 0.11kb

| ├──3. CODE The Count Function.html 0.36kb

| ├──4. The Joys of Group By.en.srt 17.05kb

| ├──4. The Joys of Group By.mp4 18.86M

| ├──4. The Joys of Group By.srt 27.21kb

| ├──5. CODE The Joys of Group By.html 0.71kb

| ├──6. Min and Max Basics.en.srt 5.18kb

| ├──6. Min and Max Basics.mp4 6.44M

| ├──6. Min and Max Basics.srt 8.33kb

| ├──7. CODE MIN and MAX Basics.html 0.25kb

| ├──8. SUBQUERIES – A Problem with Min and Max.en.srt 9.16kb

| ├──8. SUBQUERIES – A Problem with Min and Max.mp4 10.75M

| ├──8. SUBQUERIES – A Problem with Min and Max.srt 14.67kb

| └──9. CODE A Problem with Min and Max.html 0.47kb