课程目录

├──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