| 1. Introduction and 5 Minutes of SQL | |||
| 1. Course Introduction.mp4 | 5.81 MB | ||
| 1. Course Introduction.vtt | 1.91 KB | ||
| 2. Instructor Introduction(s).mp4 | 8.43 MB | ||
| 2. Instructor Introduction(s).vtt | 2.27 KB | ||
| 3. Syllabus Walkthrough and Prerequisites.mp4 | 12.14 MB | ||
| 3. Syllabus Walkthrough and Prerequisites.vtt | 6.39 KB | ||
| 4. Note about SQL Editor.html | 465 B | ||
| 5. Your First 5 Minutes of SQL - Let's Get Coding!.mp4 | 18.32 MB | ||
| 5. Your First 5 Minutes of SQL - Let's Get Coding!.vtt | 9.23 KB | ||
| 5.1 Lecture Slides.html | 108 B | ||
| 5.2 SQL Try-It Editor.html | 123 B | ||
| 6. CODE Your First 5 Minutes of SQL.html | 1.35 KB | ||
| 7. How The Course Works.mp4 | 22.4 MB | ||
| 7. How The Course Works.vtt | 5.69 KB | ||
| 10. Revisiting Data Types | |||
| 1. Section 10 Introduction.mp4 | 11.21 MB | ||
| 1. Section 10 Introduction.vtt | 2.73 KB | ||
| 10. DATE, TIME, and DATETIME.mp4 | 5.48 MB | ||
| 10. DATE, TIME, and DATETIME.vtt | 5.4 KB | ||
| 11. Creating Our DATE data.mp4 | 8.4 MB | ||
| 11. Creating Our DATE data.vtt | 5.67 KB | ||
| 12. CODE Creating Our DATE data.html | 401 B | ||
| 13. CURDATE, CURTIME, and NOW.mp4 | 8.22 MB | ||
| 13. CURDATE, CURTIME, and NOW.vtt | 6.67 KB | ||
| 14. Note about formatting dates.html | 277 B | ||
| 15. Formatting Dates.mp4 | 31.75 MB | ||
| 15. Formatting Dates.vtt | 15.42 KB | ||
| 16. CODE Formatting Dates.html | 947 B | ||
| 17. Date Math.mp4 | 18.53 MB | ||
| 17. Date Math.vtt | 10.16 KB | ||
| 18. CODE Date Math.html | 596 B | ||
| 19. Working with TIMESTAMPS.mp4 | 19.05 MB | ||
| 19. Working with TIMESTAMPS.vtt | 12.97 KB | ||
| 2. CHAR and VARCHAR.mp4 | 20.62 MB | ||
| 2. CHAR and VARCHAR.vtt | 16.92 KB | ||
| 2.1 Slides For This Section.html | 111 B | ||
| 20. CODE Working with TIMESTAMPS.html | 936 B | ||
| 21. Data Types Exercises.mp4 | 7 MB | ||
| 21. Data Types Exercises.vtt | 5.6 KB | ||
| 21.1 Slides.html | 128 B | ||
| 22. Data Types Exercises Solution.mp4 | 26.42 MB | ||
| 22. Data Types Exercises Solution.vtt | 15.08 KB | ||
| 23. CODE Data Types Exercises Solution.html | 1.21 KB | ||
| 3. Note about CHAR and VARCHAR.html | 313 B | ||
| 4. CODE CHAR and VARCHAR.html | 408 B | ||
| 5. DECIMAL.mp4 | 11.28 MB | ||
| 5. DECIMAL.vtt | 7.02 KB | ||
| 6. CODE DECIMAL.html | 308 B | ||
| 7. FLOAT and DOUBLE.mp4 | 11.61 MB | ||
| 7. FLOAT and DOUBLE.vtt | 11.61 MB | ||
| 8. CODE FLOAT and DOUBLE.html | 296 B | ||
| 9. Note about setting the timezone in Cloud9.html | 376 B | ||
| 11. The Power of Logical Operators | |||
| 1. Section 11 Introduction.mp4 | 15.7 MB | ||
| 1. Section 11 Introduction.vtt | 3.69 KB | ||
| 10. Logical AND.mp4 | 15.48 MB | ||
| 10. Logical AND.vtt | 11.41 KB | ||
| 11. CODE Logical AND.html | 641 B | ||
| 12. Logical OR.mp4 | 10.69 MB | ||
| 12. Logical OR.vtt | 7.91 KB | ||
| 13. CODE Logical OR.html | 492 B | ||
| 14. Between.mp4 | 18.25 MB | ||
| 14. Between.vtt | 12.44 KB | ||
| 15. CODE Between.html | 640 B | ||
| 16. In And Not In.mp4 | 21.92 MB | ||
| 16. In And Not In.vtt | 13.1 KB | ||
| 17. CODE In And Not In.html | 1.16 KB | ||
| 18. Case Statements.mp4 | 21.05 MB | ||
| 18. Case Statements.vtt | 13.75 KB | ||
| 19. CODE Case Statements.html | 1.01 KB | ||
| 2. Not Equal.mp4 | 7.68 MB | ||
| 2. Not Equal.vtt | 4.99 KB | ||
| 2.1 Slides For This Section.html | 111 B | ||
| 20. Logical Operators Exercises.mp4 | 10.84 MB | ||
| 20. Logical Operators Exercises.vtt | 8.48 KB | ||
| 20.1 Slides.html | 128 B | ||
| 21. Logical Operators Exercises Solution.mp4 | 33.28 MB | ||
| 21. Logical Operators Exercises Solution.vtt | 19.07 KB | ||
| 22. CODE Logical Operators Exercises Solution.html | 1.41 KB | ||
| 3. CODE Not Equal.html | 326 B | ||
| 4. Not Like.mp4 | 3.78 MB | ||
| 4. Not Like.vtt | 3.08 KB | ||
| 5. CODE Not Like.html | 282 B | ||
| 6. Greater Than.mp4 | 16.39 MB | ||
| 6. Greater Than.vtt | 12.05 KB | ||
| 7. CODE Greater Than.html | 809 B | ||
| 8. Less Than.mp4 | 6.05 MB | ||
| 8. Less Than.vtt | 4.49 KB | ||
| 9. CODE Less Than.html | 370 B | ||
| 12. Section 12 One To Many | |||
| 1. Section 12 Introduction.mp4 | 13.3 MB | ||
| 1. Section 12 Introduction.vtt | 2.57 KB | ||
| 10. CODE Inner Joins.html | 979 B | ||
| 11. Left Join.mp4 | 28.39 MB | ||
| 11. Left Join.vtt | 19.03 KB | ||
| 12. CODE Left Joins.html | 1.06 KB | ||
| 13. Right Joins Pt 1.mp4 | 20.32 MB | ||
| 13. Right Joins Pt 1.vtt | 12.41 KB | ||
| 14. CODE Right Joins Part 1.html | 1.33 KB | ||
| 15. Right Joins Pt 2.mp4 | 20.58 MB | ||
| 15. Right Joins Pt 2.vtt | 11.02 KB | ||
| 16. CODE Right Joins Part 2.html | 1.31 KB | ||
| 17. Right and Left Joins A Common Question.mp4 | 7.92 MB | ||
| 17. Right and Left Joins A Common Question.vtt | 3.59 KB | ||
| 18. CODE Right and Left Joins FAQ.html | 520 B | ||
| 19. Our First Joins Exercise.mp4 | 11.62 MB | ||
| 19. Our First Joins Exercise.vtt | 8.81 KB | ||
| 19.1 Slides.html | 113 B | ||
| 2. Real World Data Is Messy.mp4 | 14.13 MB | ||
| 2. Real World Data Is Messy.vtt | 14.22 KB | ||
| 2.1 Slides For This Section.html | 111 B | ||
| 20. Our First Joins Exercise SOLUTION.mp4 | 18.66 MB | ||
| 20. Our First Joins Exercise SOLUTION.vtt | 10.11 KB | ||
| 21. CODE Our First Joins Exercise.html | 798 B | ||
| 22. Our First Joins Exercise SOLUTION PT. 2.mp4 | 17.2 MB | ||
| 22. Our First Joins Exercise SOLUTION PT. 2.vtt | 10.61 KB | ||
| 23. CODE Our First Joins Exercise SOLUTION PT. 2.html | 1.6 KB | ||
| 3. Types of Data Relationships.mp4 | 6.19 MB | ||
| 3. Types of Data Relationships.vtt | 5.89 KB | ||
| 4. One To Many The Basics.mp4 | 19.04 MB | ||
| 4. One To Many The Basics.vtt | 16.02 KB | ||
| 5. Working With Foreign Keys.mp4 | 22.67 MB | ||
| 5. Working With Foreign Keys.vtt | 14.52 KB | ||
| 6. CODE Working With Foreign Keys.html | 1.3 KB | ||
| 7. Cross Join.mp4 | 14.49 MB | ||
| 7. Cross Join.vtt | 9.03 KB | ||
| 8. CODE Cross Joins.html | 578 B | ||
| 9. Inner Join.mp4 | 27.57 MB | ||
| 9. Inner Join.vtt | 13.96 KB | ||
| 13. Section 13 Many To Many | |||
| 1. Section 13 Introduction.mp4 | 13 MB | ||
| 1. Section 13 Introduction.vtt | 2.57 KB | ||
| 10. CODE TV Joins Challenge 3 SOLUTION.html | 397 B | ||
| 11. TV Joins Challenge 4.mp4 | 12.33 MB | ||
| 11. TV Joins Challenge 4.vtt | 6.82 KB | ||
| 12. CODE TV Joins Challenge 4 SOLUTION.html | 222 B | ||
| 13. TV Joins Challenge 5.mp4 | 9.64 MB | ||
| 13. TV Joins Challenge 5.vtt | 5.73 KB | ||
| 14. CODE TV Joins Challenge 5 SOLUTION.html | 267 B | ||
| 15. TV Joins Challenge 6.mp4 | 23.35 MB | ||
| 15. TV Joins Challenge 6.vtt | 13.28 KB | ||
| 16. CODE TV Joins Challenge 6 SOLUTION.html | 1.26 KB | ||
| 17. TV Joins Challenge 7.mp4 | 15.49 MB | ||
| 17. TV Joins Challenge 7.vtt | 7.93 KB | ||
| 18. CODE TV Joins Challenge 7 SOLUTION.html | 320 B | ||
| 2. Many To Many Basics.mp4 | 14.23 MB | ||
| 2. Many To Many Basics.vtt | 13.3 KB | ||
| 2.1 Slides.html | 113 B | ||
| 3. Creating Our Tables.mp4 | 21.84 MB | ||
| 3. Creating Our Tables.vtt | 12.46 KB | ||
| 4. CODE Creating Our Tables.html | 2.37 KB | ||
| 5. TV Joins Challenge 1.mp4 | 11.79 MB | ||
| 5. TV Joins Challenge 1.vtt | 5.43 KB | ||
| 6. CODE TV Joins Challenge 1 Solution.html | 207 B | ||
| 7. TV Joins Challenge 2.mp4 | 13.24 MB | ||
| 7. TV Joins Challenge 2.vtt | 7.67 KB | ||
| 8. CODE TV Joins Challenge 2 SOLUTION.html | 240 B | ||
| 9. TV Joins Challenge 3.mp4 | 11.44 MB | ||
| 9. TV Joins Challenge 3.vtt | 5.7 KB | ||
| 14. Instagram Database Clone | |||
| 1. Section 14 Introduction.mp4 | 9.47 MB | ||
| 1. Section 14 Introduction.vtt | 1.78 KB | ||
| 10. CODE IG Clone Likes Schema.html | 295 B | ||
| 11. Cloning Instagram's DB Followers Schema.mp4 | 12.65 MB | ||
| 11. Cloning Instagram's DB Followers Schema.vtt | 8.51 KB | ||
| 12. CODE IG Clone Followers Schema.html | 317 B | ||
| 13. Cloning Instagram's DB Hashtags Part 1.mp4 | 21.83 MB | ||
| 13. Cloning Instagram's DB Hashtags Part 1.vtt | 13.18 KB | ||
| 14. Cloning Instagram's DB Hashtags Part 2.mp4 | 11.76 MB | ||
| 14. Cloning Instagram's DB Hashtags Part 2.vtt | 5.93 KB | ||
| 15. CODE IG Clone Hashtags Schema.html | 389 B | ||
| 16. CODE Complete IG Clone Schema.html | 1.57 KB | ||
| 2. Introduction To Instagram Clone Schema.mp4 | 21.73 MB | ||
| 2. Introduction To Instagram Clone Schema.vtt | 11.74 KB | ||
| 2.1 Slides For This Section.html | 108 B | ||
| 3. Cloning Instagram's DB Users Schema.mp4 | 9.49 MB | ||
| 3. Cloning Instagram's DB Users Schema.vtt | 7.6 KB | ||
| 4. CODE IG Clone Users Schema.html | 188 B | ||
| 5. Cloning Instagram's DB Photos Schema.mp4 | 11.72 MB | ||
| 5. Cloning Instagram's DB Photos Schema.vtt | 7.2 KB | ||
| 6. CODE IG Clone Photos Schema.html | 260 B | ||
| 7. Cloning Instagram's DB Comments Schema.mp4 | 12.94 MB | ||
| 7. Cloning Instagram's DB Comments Schema.vtt | 7.39 KB | ||
| 8. CODE IG Clone Comments Schema.html | 345 B | ||
| 9. Cloning Instagram's DB Likes Schema.mp4 | 20.56 MB | ||
| 9. Cloning Instagram's DB Likes Schema.vtt | 8.88 KB | ||
| 15. Working With Lots Of Instagram Data | |||
| 1. Section 15 Introduction.mp4 | 11.25 MB | ||
| 1. Section 15 Introduction.vtt | 2.31 KB | ||
| 10. Instagram Clone Challenge 4.mp4 | 15.83 MB | ||
| 10. Instagram Clone Challenge 4.vtt | 8.01 KB | ||
| 11. Instagram Challenge 4 Solution CODE.html | 371 B | ||
| 12. Instagram Clone Challenge 5.mp4 | 5.41 MB | ||
| 12. Instagram Clone Challenge 5.vtt | 3.91 KB | ||
| 13. Instagram Challenge 5 Solution CODE.html | 232 B | ||
| 14. Instagram Clone Challenge 6.mp4 | 11.74 MB | ||
| 14. Instagram Clone Challenge 6.vtt | 5.76 KB | ||
| 15. Instagram Challenge 6 Solution CODE.html | 341 B | ||
| 16. Note about Instagram Clone Challenge 7.html | 388 B | ||
| 17. Instagram Clone Challenge 7.mp4 | 10.98 MB | ||
| 17. Instagram Clone Challenge 7.vtt | 6.09 KB | ||
| 18. Instagram Challenge 7 Solution CODE.html | 360 B | ||
| 2. Loading The JUMBO dataset.mp4 | 59.24 MB | ||
| 2. Loading The JUMBO dataset.vtt | 10.95 KB | ||
| 3. The Instagram Clone DATASET.html | 381 B | ||
| 3.1 ig_clone_data.sql.sql | 429.36 KB | ||
| 4. Instagram Clone Challenge 1.mp4 | 8.61 MB | ||
| 4. Instagram Clone Challenge 1.vtt | 6.02 KB | ||
| 4.1 Slides.html | 110 B | ||
| 5. Instagram Challenge 1 Solution CODE.html | 126 B | ||
| 6. Instagram Clone Challenge 2.mp4 | 11.71 MB | ||
| 6. Instagram Clone Challenge 2.vtt | 8.79 KB | ||
| 7. Instagram Challenge 2 Solution CODE.html | 216 B | ||
| 8. Instagram Clone Challenge 3.mp4 | 17.26 MB | ||
| 8. Instagram Clone Challenge 3.vtt | 9.45 KB | ||
| 9. Instagram Challenge 3 Solution CODE.html | 219 B | ||
| 16. Section 16 - Introducing Node | |||
| 1. Section 16 Introduction.mp4 | 13.13 MB | ||
| 1. Section 16 Introduction.vtt | 2.31 KB | ||
| 10. CODE Introduction to NPM and Faker.html | 1.21 KB | ||
| 11. Introducing the MySQL Package.mp4 | 6.92 MB | ||
| 11. Introducing the MySQL Package.vtt | 6.61 KB | ||
| 11.1 MySQL Node Package Github Repo.html | 93 B | ||
| 12. Note about connecting Node to MySQL.html | 1016 B | ||
| 13. Connecting Node to MySQL.mp4 | 23.05 MB | ||
| 13. Connecting Node to MySQL.vtt | 15.54 KB | ||
| 14. CODE Connecting Node to MySQL.html | 2.45 KB | ||
| 15. Creating Our Users Table.mp4 | 14 MB | ||
| 15. Creating Our Users Table.vtt | 9.21 KB | ||
| 16. CODE Creating Our Users Table.html | 186 B | ||
| 17. Selecting Using Node.mp4 | 11.35 MB | ||
| 17. Selecting Using Node.vtt | 7.67 KB | ||
| 18. CODE Selecting Using Node.html | 940 B | ||
| 19. Inserting Using Node.mp4 | 21.92 MB | ||
| 19. Inserting Using Node.vtt | 14.01 KB | ||
| 2. MySQL and Other Languages.mp4 | 11.17 MB | ||
| 2. MySQL and Other Languages.vtt | 12.72 KB | ||
| 2.1 Slides For This Section.html | 108 B | ||
| 20. CODE Inserting Using Node.html | 724 B | ||
| 21. Some MySQLNode Magic.mp4 | 17.86 MB | ||
| 21. Some MySQLNode Magic.vtt | 9.26 KB | ||
| 22. Bulk Inserting 500 Users - Finally!.mp4 | 22.42 MB | ||
| 22. Bulk Inserting 500 Users - Finally!.vtt | 10.98 KB | ||
| 23. CODE Bulk Inserting 500 Users.html | 585 B | ||
| 24. 500 Users Exercises.mp4 | 3.44 MB | ||
| 24. 500 Users Exercises.vtt | 3.39 KB | ||
| 24.1 Slides.html | 110 B | ||
| 25. 500 Users Exercises Solutions.mp4 | 21.87 MB | ||
| 25. 500 Users Exercises Solutions.vtt | 12.8 KB | ||
| 26. CODE 500 Users Exercises Solutions.html | 1.29 KB | ||
| 3. BUT WHAT ABOUT PHP.mp4 | 15.16 MB | ||
| 3. BUT WHAT ABOUT PHP.vtt | 10.07 KB | ||
| 4. Introduction to JOIN US app.mp4 | 11.94 MB | ||
| 4. Introduction to JOIN US app.vtt | 10.99 KB | ||
| 5. Setting Up Cloud9 for Node.mp4 | 10.53 MB | ||
| 5. Setting Up Cloud9 for Node.vtt | 8.76 KB | ||
| 6. 5 Minute NodeJS Crash Course.mp4 | 9.35 MB | ||
| 6. 5 Minute NodeJS Crash Course.vtt | 7.9 KB | ||
| 7. CODE 5 Minute Node Crash Course.html | 274 B | ||
| 8. Note about Faker install.html | 759 B | ||
| 9. Introduction to NPM and Faker.mp4 | 15.89 MB | ||
| 9. Introduction to NPM and Faker.vtt | 10.85 KB | ||
| 9.1 FakerJS Github Repo.html | 95 B | ||
| 17. Section 17 - Building Our Web App | |||
| 1. Section 17 Introduction.mp4 | 11.73 MB | ||
| 1. Section 17 Introduction.vtt | 2.71 KB | ||
| 10. CODE Connecting Express and MySQL.html | 372 B | ||
| 11. Adding EJS Templates.mp4 | 30.46 MB | ||
| 11. Adding EJS Templates.vtt | 20.78 KB | ||
| 12. CODE Adding EJS Templates.html | 441 B | ||
| 13. Connecting The Form.mp4 | 36.23 MB | ||
| 13. Connecting The Form.vtt | 23.07 KB | ||
| 14. CODE Connecting the Form.html | 352 B | ||
| 15. Styling Part 1.mp4 | 17.98 MB | ||
| 15. Styling Part 1.vtt | 10.47 KB | ||
| 16. CODE HTML AND CSS FILES.html | 117 B | ||
| 16.1 JOIN_US_HTML_AND_CSS.zip.zip | 2.7 KB | ||
| 17. Styling Part 2.mp4 | 18.37 MB | ||
| 17. Styling Part 2.vtt | 10.3 KB | ||
| 2. Join Us Completed CODE.html | 337 B | ||
| 2.1 JoinUsCompleteCode.zip.zip | 3.75 MB | ||
| 3. Introducing Express.mp4 | 9.54 MB | ||
| 3. Introducing Express.vtt | 8.26 KB | ||
| 3.1 Slides.html | 110 B | ||
| 3.2 Express Documentation.html | 83 B | ||
| 4. NPM Init and package.json files.mp4 | 11.59 MB | ||
| 4. NPM Init and package.json files.vtt | 8.72 KB | ||
| 5. Our First Simple Web App.mp4 | 28.18 MB | ||
| 5. Our First Simple Web App.vtt | 21.38 KB | ||
| 6. CODE Our First Simple Web App.html | 411 B | ||
| 7. Adding Multiple Routes.mp4 | 18.67 MB | ||
| 7. Adding Multiple Routes.vtt | 12.56 KB | ||
| 8. CODE Adding Multiple Routes.html | 467 B | ||
| 9. Connecting Express and MySQL.mp4 | 20.78 MB | ||
| 9. Connecting Express and MySQL.vtt | 13.34 KB | ||
| 18. Section 18 - Database Triggers | |||
| 1. Introduction to Database Triggers.mp4 | 27.61 MB | ||
| 1. Introduction to Database Triggers.vtt | 8.65 KB | ||
| 1.1 Lecture Slides.html | 121 B | ||
| 2. Writing Our First Trigger Part 1.mp4 | 11.35 MB | ||
| 2. Writing Our First Trigger Part 1.vtt | 9.21 KB | ||
| 2.1 Lecture Slides.html | 124 B | ||
| 3. Writing Our First Trigger Part 2.mp4 | 22.77 MB | ||
| 3. Writing Our First Trigger Part 2.vtt | 14.83 KB | ||
| 3.1 Lecture Slides.html | 124 B | ||
| 4. Preventing Instagram Self-Follows With Triggers.mp4 | 14.11 MB | ||
| 4. Preventing Instagram Self-Follows With Triggers.vtt | 10.13 KB | ||
| 4.1 Lecture Slides.html | 125 B | ||
| 5. Creating Logger Triggers.mp4 | 18.62 MB | ||
| 5. Creating Logger Triggers.vtt | 11.94 KB | ||
| 5.1 Lecture Slides.html | 125 B | ||
| 6. Managing Triggers And A Warning.mp4 | 12.55 MB | ||
| 6. Managing Triggers And A Warning.vtt | 8.04 KB | ||
| 6.1 Lecture Slides.html | 125 B | ||
| 2. Getting Started Overview and Installation | |||
| 1. Section Introduction.mp4 | 7.98 MB | ||
| 1. Section Introduction.vtt | 1.68 KB | ||
| 10. CODE Installing MySQL on Cloud9.html | 113 B | ||
| 11. Your First MySQL Activity.mp4 | 6.48 MB | ||
| 11. Your First MySQL Activity.vtt | 4.79 KB | ||
| 11.1 Slides.html | 124 B | ||
| 12. CODE Your First MySQL Activity.html | 82 B | ||
| 13. Mac Installation.mp4 | 22.17 MB | ||
| 13. Mac Installation.vtt | 15.25 KB | ||
| 14. CODE Mac Installation.html | 1.31 KB | ||
| 15. Windows Installation.mp4 | 5.73 MB | ||
| 15. Windows Installation.vtt | 5.55 KB | ||
| 2. What Is a Database.mp4 | 10.28 MB | ||
| 2. What Is a Database.vtt | 9.24 KB | ||
| 2.1 Slides For This Section.html | 104 B | ||
| 3. SQL Vs. MySQL.mp4 | 7.72 MB | ||
| 3. SQL Vs. MySQL.vtt | 7.05 KB | ||
| 4. Installation Overview - WATCH BEFORE INSTALLING.mp4 | 6.64 MB | ||
| 4. Installation Overview - WATCH BEFORE INSTALLING.vtt | 7.15 KB | ||
| 4.1 Installation Slides.html | 107 B | ||
| 5. Cloud9 Registration IMPORTANT - PLEASE READ!!!.html | 1.02 KB | ||
| 6. Setting Up Cloud9.mp4 | 8 MB | ||
| 6. Setting Up Cloud9.vtt | 6.27 KB | ||
| 6.1 Cloud9 Signup Link.html | 95 B | ||
| 7. Exploring The Cloud9 Interface.mp4 | 9.45 MB | ||
| 7. Exploring The Cloud9 Interface.vtt | 7.22 KB | ||
| 8. Cloud9 Interface Challenge.mp4 | 4.78 MB | ||
| 8. Cloud9 Interface Challenge.vtt | 3.29 KB | ||
| 9. Installing MySQL on Cloud9.mp4 | 13.34 MB | ||
| 9. Installing MySQL on Cloud9.vtt | 10.42 KB | ||
| 9.1 Setting Up MySQL on Cloud9 Documentation.html | 108 B | ||
| 3. Creating Databases and Tables | |||
| 1. Section 3 Introduction.mp4 | 9.39 MB | ||
| 1. Section 3 Introduction.vtt | 1.71 KB | ||
| 10. Note about INT max size.html | 401 B | ||
| 11. Basic Datatypes Challenge.mp4 | 3.53 MB | ||
| 11. Basic Datatypes Challenge.vtt | 3.24 KB | ||
| 12. Basic Datatypes Challenge - Solution.html | 183 B | ||
| 13. Creating Your Own Tables.mp4 | 3.95 MB | ||
| 13. Creating Your Own Tables.vtt | 3.55 KB | ||
| 14. CODE Creating Your Own Tables.html | 247 B | ||
| 15. How Do We Know It Worked.mp4 | 3.52 MB | ||
| 15. How Do We Know It Worked.vtt | 3.28 KB | ||
| 16. CODE How Do We Know It Worked.html | 99 B | ||
| 17. Dropping Tables.mp4 | 2.09 MB | ||
| 17. Dropping Tables.vtt | 2.17 KB | ||
| 18. CODE Dropping Tables.html | 181 B | ||
| 19. Creating Your Own Tables Challenge.mp4 | 6.07 MB | ||
| 19. Creating Your Own Tables Challenge.vtt | 5.49 KB | ||
| 19.1 Slides.html | 127 B | ||
| 2. Creating Databases.mp4 | 7.24 MB | ||
| 2. Creating Databases.vtt | 6.47 KB | ||
| 2.1 Slides For This Section!.html | 110 B | ||
| 20. CODE Creating Your Own Tables Challenge.html | 164 B | ||
| 3. CODE Creating Databases.html | 386 B | ||
| 4. Dropping Databases.mp4 | 2.47 MB | ||
| 4. Dropping Databases.vtt | 2.26 KB | ||
| 5. CODE Dropping Databases.html | 292 B | ||
| 6. Using Databases.mp4 | 4.4 MB | ||
| 6. Using Databases.vtt | 3.38 KB | ||
| 7. CODE Using Databases.html | 120 B | ||
| 8. Introduction to Tables.mp4 | 7.11 MB | ||
| 8. Introduction to Tables.vtt | 6.66 KB | ||
| 9. The Basic Datatypes.mp4 | 10.78 MB | ||
| 9. The Basic Datatypes.vtt | 9.79 KB | ||
| 4. Inserting Data (and a couple other things) | |||
| 1. Section 4 Introduction.mp4 | 10.81 MB | ||
| 1. Section 4 Introduction.vtt | 2.27 KB | ||
| 10. INSERT Challenges Solution.mp4 | 7.16 MB | ||
| 10. INSERT Challenges Solution.vtt | 4.19 KB | ||
| 11. CODE INSERT Challenges Solution.html | 839 B | ||
| 12. NOTE MySQL Warnings.html | 427 B | ||
| 13. MySQL Warnings.mp4 | 8.63 MB | ||
| 13. MySQL Warnings.vtt | 4.28 KB | ||
| 14. CODE MySQL Warnings.html | 637 B | ||
| 15. NULL and NOT_NULL.mp4 | 10.16 MB | ||
| 15. NULL and NOT_NULL.vtt | 7.1 KB | ||
| 16. CODE NULL and NOT NULL.html | 1.1 KB | ||
| 17. Setting Default Values.mp4 | 10.39 MB | ||
| 17. Setting Default Values.vtt | 7.13 KB | ||
| 18. CODE Setting Default Values.html | 1.19 KB | ||
| 19. A Primer On Primary Keys.mp4 | 18.18 MB | ||
| 19. A Primer On Primary Keys.vtt | 13.72 KB | ||
| 2. Inserting Data.mp4 | 6.69 MB | ||
| 2. Inserting Data.vtt | 6.07 KB | ||
| 2.1 Slides For This Section.html | 112 B | ||
| 20. CODE A Primer on Primary Keys.html | 1.43 KB | ||
| 21. Table Constraints Exercise.mp4 | 2.62 MB | ||
| 21. Table Constraints Exercise.vtt | 2.69 KB | ||
| 21.1 Exercise Slides.html | 112 B | ||
| 22. Table Constraints Exercise Solution.mp4 | 7.99 MB | ||
| 22. Table Constraints Exercise Solution.vtt | 3.87 KB | ||
| 23. CODE Table Constraints Exercise Solution.html | 938 B | ||
| 3. CODE Inserting Data.html | 263 B | ||
| 4. Super Quick Intro To SELECT.mp4 | 2.94 MB | ||
| 4. Super Quick Intro To SELECT.vtt | 2.8 KB | ||
| 5. CODE Super Quick Intro To SELECT.html | 41 B | ||
| 6. Multiple INSERT.mp4 | 4.07 MB | ||
| 6. Multiple INSERT.vtt | 3.5 KB | ||
| 7. CODE Multiple Insert.html | 189 B | ||
| 8. INSERT Challenges.mp4 | 2.18 MB | ||
| 8. INSERT Challenges.vtt | 1.97 KB | ||
| 9. Note about using quotes inside of inserted values.html | 502 B | ||
| 5. CRUD commmands | |||
| 1. Section 5 Introduction.mp4 | 13.3 MB | ||
| 1. Section 5 Introduction.vtt | 2.22 KB | ||
| 10. SELECT Challenges.mp4 | 3.08 MB | ||
| 10. SELECT Challenges.vtt | 2.51 KB | ||
| 11. SELECT Challenges Solution.mp4 | 4.08 MB | ||
| 11. SELECT Challenges Solution.vtt | 3.11 KB | ||
| 12. CODE SELECT Challenges Solution.html | 385 B | ||
| 13. Introduction to Aliases.mp4 | 3.96 MB | ||
| 13. Introduction to Aliases.vtt | 3.42 KB | ||
| 14. CODE Introduction to Aliases.html | 198 B | ||
| 15. The UPDATE Command.mp4 | 5.43 MB | ||
| 15. The UPDATE Command.vtt | 4.54 KB | ||
| 16. CODE The UPDATE Command.html | 284 B | ||
| 17. UPDATE Challenges.mp4 | 855.66 KB | ||
| 17. UPDATE Challenges.vtt | 745 B | ||
| 18. UPDATE Challenges Solution.mp4 | 5.65 MB | ||
| 18. UPDATE Challenges Solution.vtt | 4.12 KB | ||
| 19. CODE UPDATE Challenges Solution.html | 561 B | ||
| 2. Introduction to CRUD.mp4 | 2.25 MB | ||
| 2. Introduction to CRUD.vtt | 2.26 KB | ||
| 2.1 This Section's Slides.html | 111 B | ||
| 20. Introduction to DELETE.mp4 | 6.16 MB | ||
| 20. Introduction to DELETE.vtt | 5.82 KB | ||
| 21. CODE Introduction to DELETE.html | 240 B | ||
| 22. DELETE Challenges.mp4 | 1.64 MB | ||
| 22. DELETE Challenges.vtt | 1.58 KB | ||
| 22.1 Slides.html | 128 B | ||
| 23. DELETE Challenges Solution.mp4 | 4.25 MB | ||
| 23. DELETE Challenges Solution.vtt | 2.89 KB | ||
| 24. CODE DELETE Challenges Solution.html | 317 B | ||
| 3. CODE Introduction to CRUD.html | 73 B | ||
| 4. Preparing Our Data.mp4 | 3.7 MB | ||
| 4. Preparing Our Data.vtt | 3.05 KB | ||
| 5. CODE Preparing Our Data.html | 811 B | ||
| 6. Official Introduction to SELECT.mp4 | 6.12 MB | ||
| 6. Official Introduction to SELECT.vtt | 4.62 KB | ||
| 7. CODE Official Introduction to SELECT.html | 573 B | ||
| 8. Introduction to WHERE.mp4 | 6.83 MB | ||
| 8. Introduction to WHERE.vtt | 6.12 KB | ||
| 9. CODE Introduction to WHERE.html | 309 B | ||
| 6. CRUD Challenge Section | |||
| 1. Section 6 Introduction.mp4 | 14.46 MB | ||
| 1. Section 6 Introduction.vtt | 2.78 KB | ||
| 10. CODE CRUD Exercise Delete Solution.html | 402 B | ||
| 2. CRUD Exercise Overview.mp4 | 10.62 MB | ||
| 2. CRUD Exercise Overview.vtt | 9.7 KB | ||
| 2.1 Slides.html | 128 B | ||
| 3. CRUD Exercise Create Solution.mp4 | 8.93 MB | ||
| 3. CRUD Exercise Create Solution.vtt | 6.22 KB | ||
| 4. CODE CRUD Exercise Create Solution.html | 802 B | ||
| 5. CRUD Exercise Read Solution.mp4 | 2.89 MB | ||
| 5. CRUD Exercise Read Solution.vtt | 1.85 KB | ||
| 6. CODE CRUD Exercise Read Solution.html | 198 B | ||
| 7. CRUD Exercise Update Solution.mp4 | 6.4 MB | ||
| 7. CRUD Exercise Update Solution.vtt | 4.34 KB | ||
| 8. CODE CRUD Exercise Update Solution.html | 630 B | ||
| 9. CRUD Exercise Delete Solution.mp4 | 4.88 MB | ||
| 9. CRUD Exercise Delete Solution.vtt | 3.64 KB | ||
| 7. The World Of String Functions | |||
| 1. Section 7 Introduction.mp4 | 11.21 MB | ||
| 1. Section 7 Introduction.vtt | 2.86 KB | ||
| 10. Introducing REPLACE.mp4 | 11.46 MB | ||
| 10. Introducing REPLACE.vtt | 7.3 KB | ||
| 11. CODE Introducing REPLACE.html | 887 B | ||
| 12. Using REVERSE.mp4 | 5.39 MB | ||
| 12. Using REVERSE.vtt | 3.96 KB | ||
| 13. CODE Using REVERSE.html | 247 B | ||
| 14. Working with CHAR LENGTH.mp4 | 8.32 MB | ||
| 14. Working with CHAR LENGTH.vtt | 5.6 KB | ||
| 15. CODE Working with CHAR LENGTH.html | 325 B | ||
| 16. Changing Case with UPPER and LOWER.mp4 | 6.14 MB | ||
| 16. Changing Case with UPPER and LOWER.vtt | 3.94 KB | ||
| 17. CODE Changing Case with UPPER and LOWER.html | 261 B | ||
| 18. Note about string functions.html | 1.01 KB | ||
| 19. String Function Challenges.mp4 | 7.2 MB | ||
| 19. String Function Challenges.vtt | 5.66 KB | ||
| 19.1 Slides.html | 128 B | ||
| 2. Running SQL Files.mp4 | 15.18 MB | ||
| 2. Running SQL Files.vtt | 11.94 KB | ||
| 2.1 Slides For This Section.html | 111 B | ||
| 20. String Function Challenges Solution.mp4 | 24.79 MB | ||
| 20. String Function Challenges Solution.vtt | 13.22 KB | ||
| 21. CODE String Function Challenges Solution.html | 1.33 KB | ||
| 3. CODE Running SQL Files.html | 403 B | ||
| 4. Loading Our Book Data.mp4 | 13.05 MB | ||
| 4. Loading Our Book Data.vtt | 6.84 KB | ||
| 4.1 book_data.sql file available from this c9 workspace.html | 105 B | ||
| 4.2 book_data.sql.sql | 1.31 KB | ||
| 5. CODE Loading Our Book Data.html | 1.54 KB | ||
| 6. Working with CONCAT.mp4 | 23.02 MB | ||
| 6. Working with CONCAT.vtt | 13.43 KB | ||
| 7. CODE Working With CONCAT.html | 944 B | ||
| 8. Introducing SUBSTRING.mp4 | 15.74 MB | ||
| 8. Introducing SUBSTRING.vtt | 11.56 KB | ||
| 9. CODE Introducing SUBSTRING.html | 808 B | ||
| 8. Refining Our Selections | |||
| 1. Section 8 Introduction.mp4 | 4.63 MB | ||
| 1. Section 8 Introduction.vtt | 937 B | ||
| 10. Better Searches with LIKE.mp4 | 10.48 MB | ||
| 10. Better Searches with LIKE.vtt | 9.06 KB | ||
| 11. CODE Better Searches with LIKE.html | 331 B | ||
| 12. LIKE Part 2 More Wildcards.mp4 | 9.48 MB | ||
| 12. LIKE Part 2 More Wildcards.vtt | 7.73 KB | ||
| 13. CODE LIKE Part 2 More Wildcards.html | 388 B | ||
| 14. Refining Selections Exercises.mp4 | 7.49 MB | ||
| 14. Refining Selections Exercises.vtt | 6.12 KB | ||
| 14.1 Slides.html | 128 B | ||
| 15. Refining Selections Exercises Solution.mp4 | 24.87 MB | ||
| 15. Refining Selections Exercises Solution.vtt | 13.99 KB | ||
| 16. CODE Refining Selections Exercises Solution.html | 732 B | ||
| 2. Seed Data Adding A Couple New Books.mp4 | 3.82 MB | ||
| 2. Seed Data Adding A Couple New Books.vtt | 4.01 KB | ||
| 2.1 Slides For This Section.html | 113 B | ||
| 3. CODE Seed Data Adding A Couple New Books.html | 361 B | ||
| 4. Using DISTINCT.mp4 | 12.71 MB | ||
| 4. Using DISTINCT.vtt | 9.59 KB | ||
| 5. CODE Using DISTINCT.html | 284 B | ||
| 6. Sorting Data with ORDER BY.mp4 | 19.53 MB | ||
| 6. Sorting Data with ORDER BY.vtt | 1.94 KB | ||
| 7. CODE Sorting Data with ORDER BY.html | 997 B | ||
| 8. Using LIMIT.mp4 | 16.37 MB | ||
| 8. Using LIMIT.vtt | 11.15 KB | ||
| 9. CODE Using LIMIT.html | 897 B | ||
| 9. The Magic of Aggregate Functions | |||
| 1. Section 9 Introduction.mp4 | 17.55 MB | ||
| 1. Section 9 Introduction.vtt | 5.59 KB | ||
| 10. Using Min and Max with Group By.mp4 | 10.35 MB | ||
| 10. Using Min and Max with Group By.vtt | 7.38 KB | ||
| 11. CODE Using Min and Max with Group By.html | 432 B | ||
| 12. The Sum Function.mp4 | 6.39 MB | ||
| 12. The Sum Function.vtt | 4.96 KB | ||
| 13. CODE The Sum Function.html | 350 B | ||
| 14. The Avg Function.mp4 | 8.6 MB | ||
| 14. The Avg Function.vtt | 7.21 KB | ||
| 15. CODE The Avg Function.html | 350 B | ||
| 16. Aggregate Functions Challenges.mp4 | 5.83 MB | ||
| 16. Aggregate Functions Challenges.vtt | 5.05 KB | ||
| 16.1 Slides.html | 129 B | ||
| 17. Aggregate Functions Challenges Solution.mp4 | 14.85 MB | ||
| 17. Aggregate Functions Challenges Solution.vtt | 8.8 KB | ||
| 18. CODE Aggregate Functions Challenges Solution.html | 841 B | ||
| 2. The Count Function.mp4 | 12.92 MB | ||
| 2. The Count Function.vtt | 10.2 KB | ||
| 2.1 Slides For This Section.html | 113 B | ||
| 3. CODE The Count Function.html | 373 B | ||
| 4. The Joys of Group By.mp4 | 18.87 MB | ||
| 4. The Joys of Group By.vtt | 18.87 MB | ||
| 5. CODE The Joys of Group By.html | 724 B | ||
| 6. Min and Max Basics.mp4 | 6.43 MB | ||
| 6. Min and Max Basics.vtt | 4.51 KB | ||
| 7. CODE MIN and MAX Basics.html | 258 B | ||
| 8. SUBQUERIES - A Problem with Min and Max.mp4 | 10.76 MB | ||
| 8. SUBQUERIES - A Problem with Min and Max.vtt | 7.99 KB | ||
| 9. CODE A Problem with Min and Max.html | 480 B | ||
| [Tutorialsplanet.NET].url | 128 B | ||
| ▲ 557 total files | |||
Udemy - The Ultimate MySQL Bootcamp: Go From SQL Beginner To Expert [TP]
Become an In-demand SQL Master by creating complex databases and building reports through real-world projects
For more Udemy Courses: https://tutorialsplanet.net
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 784.3 MB | freecoursewb | 1 week | 18 | 6 | |
| 2.2 GB | freecoursewb | 1 week | 0 | 0 | |
| 3.7 GB | freecoursewb | 1 week | 0 | 0 | |
| 3.3 GB | freecoursewb | 1 week | 24 | 16 | |
| 410.6 MB | freecoursewb | 1 week | 21 | 8 |
All Comments