| 1. Introduction and 5 Minutes of SQL | |||
| 1. Course Introduction.mp4 | 5.82 MB | ||
| 1. Course Introduction.srt | 2.18 KB | ||
| 2. Instructor Introduction(s).mp4 | 8.43 MB | ||
| 2. Instructor Introduction(s).srt | 2.61 KB | ||
| 3. Syllabus Walkthrough and Prerequisites.mp4 | 12.14 MB | ||
| 3. Syllabus Walkthrough and Prerequisites.srt | 7.3 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!.srt | 10.59 KB | ||
| 5.1 SQL Try-It Editor.html | 123 B | ||
| 5.2 Lecture Slides.html | 108 B | ||
| 6. CODE Your First 5 Minutes of SQL.html | 1.57 KB | ||
| 7. How The Course Works.mp4 | 22.4 MB | ||
| 7. How The Course Works.srt | 6.48 KB | ||
| 10. Revisiting Data Types | |||
| 1. Section 10 Introduction.mp4 | 11.2 MB | ||
| 1. Section 10 Introduction.srt | 3.15 KB | ||
| 10. DATE, TIME, and DATETIME.mp4 | 5.48 MB | ||
| 10. DATE, TIME, and DATETIME.srt | 6.13 KB | ||
| 11. Creating Our DATE data.mp4 | 8.39 MB | ||
| 11. Creating Our DATE data.srt | 6.61 KB | ||
| 12. CODE Creating Our DATE data.html | 401 B | ||
| 13. CURDATE, CURTIME, and NOW.mp4 | 8.22 MB | ||
| 13. CURDATE, CURTIME, and NOW.srt | 7.66 KB | ||
| 14. Note about formatting dates.html | 277 B | ||
| 15. Formatting Dates.mp4 | 31.75 MB | ||
| 15. Formatting Dates.srt | 17.98 KB | ||
| 16. CODE Formatting Dates.html | 947 B | ||
| 17. Date Math.mp4 | 18.52 MB | ||
| 17. Date Math.srt | 11.79 KB | ||
| 18. CODE Date Math.html | 596 B | ||
| 19. Working with TIMESTAMPS.mp4 | 19.04 MB | ||
| 19. Working with TIMESTAMPS.srt | 15.12 KB | ||
| 2. CHAR and VARCHAR.mp4 | 20.62 MB | ||
| 2. CHAR and VARCHAR.srt | 1.83 MB | ||
| 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.srt | 6.46 KB | ||
| 21.1 Slides.html | 128 B | ||
| 22. Data Types Exercises Solution.mp4 | 26.42 MB | ||
| 22. Data Types Exercises Solution.srt | 3.92 MB | ||
| 23. CODE Data Types Exercises Solution.html | 1.21 KB | ||
| 3. Note about CHAR and VARCHAR.html | 360 B | ||
| 4. CODE CHAR and VARCHAR.html | 408 B | ||
| 5. DECIMAL.mp4 | 11.27 MB | ||
| 5. DECIMAL.srt | 8.08 KB | ||
| 6. CODE DECIMAL.html | 308 B | ||
| 7. FLOAT and DOUBLE.mp4 | 11.6 MB | ||
| 7. FLOAT and DOUBLE.srt | 9.95 KB | ||
| 8. CODE FLOAT and DOUBLE.html | 296 B | ||
| 9. Note about setting the timezone in Cloud9.html | 423 B | ||
| 11. The Power of Logical Operators | |||
| 1. Section 11 Introduction.mp4 | 15.7 MB | ||
| 1. Section 11 Introduction.srt | 4.25 KB | ||
| 10. Logical AND.mp4 | 15.47 MB | ||
| 10. Logical AND.srt | 13.4 KB | ||
| 11. CODE Logical AND.html | 641 B | ||
| 12. Logical OR.mp4 | 10.69 MB | ||
| 12. Logical OR.srt | 9.13 KB | ||
| 13. CODE Logical OR.html | 492 B | ||
| 14. Between.mp4 | 18.24 MB | ||
| 14. Between.srt | 14.38 KB | ||
| 15. CODE Between.html | 640 B | ||
| 16. In And Not In.mp4 | 21.91 MB | ||
| 16. In And Not In.srt | 15.24 KB | ||
| 17. CODE In And Not In.html | 1.16 KB | ||
| 18. Case Statements.mp4 | 21.04 MB | ||
| 18. Case Statements.srt | 15.91 KB | ||
| 19. CODE Case Statements.html | 1.01 KB | ||
| 2. Not Equal.mp4 | 7.68 MB | ||
| 2. Not Equal.srt | 5.7 KB | ||
| 2.1 Slides For This Section.html | 111 B | ||
| 20. Logical Operators Exercises.mp4 | 10.83 MB | ||
| 20. Logical Operators Exercises.srt | 9.83 KB | ||
| 20.1 Slides.html | 128 B | ||
| 21. Logical Operators Exercises Solution.mp4 | 33.28 MB | ||
| 21. Logical Operators Exercises Solution.srt | 22.42 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.srt | 3.59 KB | ||
| 5. CODE Not Like.html | 282 B | ||
| 6. Greater Than.mp4 | 16.39 MB | ||
| 6. Greater Than.srt | 14.04 KB | ||
| 7. CODE Greater Than.html | 809 B | ||
| 8. Less Than.mp4 | 6.05 MB | ||
| 8. Less Than.srt | 5.22 KB | ||
| 9. CODE Less Than.html | 370 B | ||
| 12. Section 12 One To Many | |||
| 1. Section 12 Introduction.mp4 | 13.29 MB | ||
| 1. Section 12 Introduction.srt | 2.95 KB | ||
| 10. CODE Inner Joins.html | 979 B | ||
| 11. Left Join.mp4 | 28.38 MB | ||
| 11. Left Join.srt | 22.37 KB | ||
| 12. CODE Left Joins.html | 1.06 KB | ||
| 13. Right Joins Pt 1.mp4 | 20.31 MB | ||
| 13. Right Joins Pt 1.srt | 14.37 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.srt | 12.81 KB | ||
| 16. CODE Right Joins Part 2.html | 1.31 KB | ||
| 17. Right and Left Joins A Common Question.mp4 | 7.93 MB | ||
| 17. Right and Left Joins A Common Question.srt | 4.13 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.srt | 10.19 KB | ||
| 19.1 Slides.html | 113 B | ||
| 2. Real World Data Is Messy.mp4 | 14.13 MB | ||
| 2. Real World Data Is Messy.srt | 16.31 KB | ||
| 2.1 Slides For This Section.html | 111 B | ||
| 20. Our First Joins Exercise SOLUTION.mp4 | 18.65 MB | ||
| 20. Our First Joins Exercise SOLUTION.srt | 11.9 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.srt | 12.54 KB | ||
| 23. CODE Our First Joins Exercise SOLUTION PT. 2.html | 1.6 KB | ||
| 3. Types of Data Relationships.mp4 | 6.2 MB | ||
| 3. Types of Data Relationships.srt | 6.7 KB | ||
| 4. One To Many The Basics.mp4 | 19.04 MB | ||
| 4. One To Many The Basics.srt | 18.45 KB | ||
| 5. Working With Foreign Keys.mp4 | 22.67 MB | ||
| 5. Working With Foreign Keys.srt | 16.81 KB | ||
| 6. CODE Working With Foreign Keys.html | 1.3 KB | ||
| 7. Cross Join.mp4 | 14.49 MB | ||
| 7. Cross Join.srt | 10.49 KB | ||
| 8. CODE Cross Joins.html | 578 B | ||
| 9. Inner Join.mp4 | 27.58 MB | ||
| 9. Inner Join.srt | 16.17 KB | ||
| 13. Section 13 Many To Many | |||
| 1. Section 13 Introduction.mp4 | 12.99 MB | ||
| 1. Section 13 Introduction.srt | 2.96 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.srt | 7.87 KB | ||
| 12. CODE TV Joins Challenge 4 SOLUTION.html | 222 B | ||
| 13. TV Joins Challenge 5.mp4 | 9.63 MB | ||
| 13. TV Joins Challenge 5.srt | 6.65 KB | ||
| 14. CODE TV Joins Challenge 5 SOLUTION.html | 267 B | ||
| 15. TV Joins Challenge 6.mp4 | 23.34 MB | ||
| 15. TV Joins Challenge 6.srt | 15.54 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.srt | 9.13 KB | ||
| 18. CODE TV Joins Challenge 7 SOLUTION.html | 320 B | ||
| 2. Many To Many Basics.mp4 | 14.22 MB | ||
| 2. Many To Many Basics.srt | 15.26 KB | ||
| 2.1 Slides.html | 113 B | ||
| 3. Creating Our Tables.mp4 | 21.84 MB | ||
| 3. Creating Our Tables.srt | 14.41 KB | ||
| 4. CODE Creating Our Tables.html | 2.37 KB | ||
| 5. TV Joins Challenge 1.mp4 | 11.78 MB | ||
| 5. TV Joins Challenge 1.srt | 6.24 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.srt | 8.89 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.srt | 6.58 KB | ||
| 14. Instagram Database Clone | |||
| 1. Section 14 Introduction.mp4 | 9.47 MB | ||
| 1. Section 14 Introduction.srt | 2.06 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.srt | 9.98 KB | ||
| 12. CODE IG Clone Followers Schema.html | 317 B | ||
| 13. Note about Cloning Instagram's DB Hashtags Part 1.html | 402 B | ||
| 14. Cloning Instagram's DB Hashtags Part 1.mp4 | 21.84 MB | ||
| 14. Cloning Instagram's DB Hashtags Part 1.srt | 14.96 KB | ||
| 15. Cloning Instagram's DB Hashtags Part 2.mp4 | 11.76 MB | ||
| 15. Cloning Instagram's DB Hashtags Part 2.srt | 6.98 KB | ||
| 16. CODE IG Clone Hashtags Schema.html | 389 B | ||
| 17. 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.srt | 13.41 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.srt | 8.78 KB | ||
| 4. CODE IG Clone Users Schema.html | 188 B | ||
| 5. Cloning Instagram's DB Photos Schema.mp4 | 11.71 MB | ||
| 5. Cloning Instagram's DB Photos Schema.srt | 8.28 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.srt | 8.59 KB | ||
| 8. CODE IG Clone Comments Schema.html | 345 B | ||
| 9. Cloning Instagram's DB Likes Schema.mp4 | 20.57 MB | ||
| 9. Cloning Instagram's DB Likes Schema.srt | 10.34 KB | ||
| 15. Working With Lots Of Instagram Data | |||
| 1. Section 15 Introduction.mp4 | 11.25 MB | ||
| 1. Section 15 Introduction.srt | 2.68 KB | ||
| 10. Instagram Clone Challenge 4.mp4 | 15.83 MB | ||
| 10. Instagram Clone Challenge 4.srt | 9.27 KB | ||
| 11. Instagram Challenge 4 Solution CODE.html | 371 B | ||
| 12. Instagram Clone Challenge 5.mp4 | 5.41 MB | ||
| 12. Instagram Clone Challenge 5.srt | 4.52 KB | ||
| 13. Instagram Challenge 5 Solution CODE.html | 232 B | ||
| 14. Instagram Clone Challenge 6.mp4 | 11.74 MB | ||
| 14. Instagram Clone Challenge 6.srt | 6.57 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.97 MB | ||
| 17. Instagram Clone Challenge 7.srt | 7.04 KB | ||
| 18. Instagram Challenge 7 Solution CODE.html | 360 B | ||
| 2. Loading The JUMBO dataset.mp4 | 59.23 MB | ||
| 2. Loading The JUMBO dataset.srt | 12.48 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.62 MB | ||
| 4. Instagram Clone Challenge 1.srt | 6.89 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.srt | 10.07 KB | ||
| 7. Instagram Challenge 2 Solution CODE.html | 216 B | ||
| 8. Instagram Clone Challenge 3.mp4 | 17.25 MB | ||
| 8. Instagram Clone Challenge 3.srt | 10.84 KB | ||
| 9. Instagram Challenge 3 Solution CODE.html | 219 B | ||
| 16. Section 16 - Introducing Node | |||
| 1. Note about Introducing Node.html | 353 B | ||
| 10. Introduction to NPM and Faker.mp4 | 15.88 MB | ||
| 10. Introduction to NPM and Faker.srt | 12.55 KB | ||
| 10.1 FakerJS Github Repo.html | 95 B | ||
| 11. CODE Introduction to NPM and Faker.html | 1.21 KB | ||
| 12. Introducing the MySQL Package.mp4 | 6.92 MB | ||
| 12. Introducing the MySQL Package.srt | 7.7 KB | ||
| 12.1 MySQL Node Package Github Repo.html | 93 B | ||
| 13. Note about connecting Node to MySQL.html | 2.26 KB | ||
| 14. Connecting Node to MySQL.mp4 | 23.06 MB | ||
| 14. Connecting Node to MySQL.srt | 18.11 KB | ||
| 15. CODE Connecting Node to MySQL.html | 2.48 KB | ||
| 16. Creating Our Users Table.mp4 | 14 MB | ||
| 16. Creating Our Users Table.srt | 10.64 KB | ||
| 17. CODE Creating Our Users Table.html | 186 B | ||
| 18. Selecting Using Node.mp4 | 11.34 MB | ||
| 18. Selecting Using Node.srt | 8.91 KB | ||
| 19. CODE Selecting Using Node.html | 940 B | ||
| 2. Section 16 Introduction.mp4 | 13.12 MB | ||
| 2. Section 16 Introduction.srt | 2.65 KB | ||
| 20. Inserting Using Node.mp4 | 21.92 MB | ||
| 20. Inserting Using Node.srt | 16.42 KB | ||
| 21. CODE Inserting Using Node.html | 724 B | ||
| 22. Some MySQLNode Magic.mp4 | 17.86 MB | ||
| 22. Some MySQLNode Magic.srt | 10.77 KB | ||
| 23. Bulk Inserting 500 Users - Finally!.mp4 | 22.42 MB | ||
| 23. Bulk Inserting 500 Users - Finally!.srt | 12.83 KB | ||
| 24. CODE Bulk Inserting 500 Users.html | 585 B | ||
| 25. 500 Users Exercises.mp4 | 3.45 MB | ||
| 25. 500 Users Exercises.srt | 3.92 KB | ||
| 25.1 Slides.html | 110 B | ||
| 26. 500 Users Exercises Solutions.mp4 | 21.87 MB | ||
| 26. 500 Users Exercises Solutions.srt | 15.04 KB | ||
| 27. CODE 500 Users Exercises Solutions.html | 1.29 KB | ||
| 3. MySQL and Other Languages.mp4 | 11.16 MB | ||
| 3. MySQL and Other Languages.srt | 14.7 KB | ||
| 3.1 Slides For This Section.html | 108 B | ||
| 4. BUT WHAT ABOUT PHP.mp4 | 15.16 MB | ||
| 4. BUT WHAT ABOUT PHP.srt | 11.67 KB | ||
| 5. Introduction to JOIN US app.mp4 | 11.93 MB | ||
| 5. Introduction to JOIN US app.srt | 12.7 KB | ||
| 6. Note about Setting Up Cloud9 for Node.html | 835 B | ||
| 7. 5 Minute NodeJS Crash Course.mp4 | 9.35 MB | ||
| 7. 5 Minute NodeJS Crash Course.srt | 9.15 KB | ||
| 8. CODE 5 Minute Node Crash Course.html | 274 B | ||
| 9. Note about Faker install.html | 759 B | ||
| 17. Section 17 - Building Our Web App | |||
| 1. Section 17 Introduction.mp4 | 11.73 MB | ||
| 1. Section 17 Introduction.srt | 3.1 KB | ||
| 10. Connecting Express and MySQL.mp4 | 20.78 MB | ||
| 10. Connecting Express and MySQL.srt | 15.4 KB | ||
| 11. CODE Connecting Express and MySQL.html | 372 B | ||
| 12. Adding EJS Templates.mp4 | 30.45 MB | ||
| 12. Adding EJS Templates.srt | 24.38 KB | ||
| 13. CODE Adding EJS Templates.html | 441 B | ||
| 14. Connecting The Form.mp4 | 36.22 MB | ||
| 14. Connecting The Form.srt | 26.9 KB | ||
| 15. CODE Connecting the Form.html | 352 B | ||
| 16. Styling Part 1.mp4 | 17.98 MB | ||
| 16. Styling Part 1.srt | 12.16 KB | ||
| 17. CODE HTML AND CSS FILES.html | 117 B | ||
| 17.1 JOIN_US_HTML_AND_CSS.zip.zip | 2.7 KB | ||
| 18. Styling Part 2.mp4 | 18.37 MB | ||
| 18. Styling Part 2.srt | 11.88 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.srt | 9.51 KB | ||
| 3.1 Slides.html | 110 B | ||
| 3.2 Express Documentation.html | 83 B | ||
| 4. NPM Init and package.json files.mp4 | 11.6 MB | ||
| 4. NPM Init and package.json files.srt | 9.96 KB | ||
| 5. Note about Our First Simple Web App.html | 493 B | ||
| 6. Our First Simple Web App.mp4 | 28.18 MB | ||
| 6. Our First Simple Web App.srt | 24.76 KB | ||
| 7. CODE Our First Simple Web App.html | 411 B | ||
| 8. Adding Multiple Routes.mp4 | 18.66 MB | ||
| 8. Adding Multiple Routes.srt | 14.65 KB | ||
| 9. CODE Adding Multiple Routes.html | 467 B | ||
| 18. Section 18 - Database Triggers | |||
| 1. Introduction to Database Triggers.mp4 | 27.61 MB | ||
| 1. Introduction to Database Triggers.srt | 9.88 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.srt | 10.78 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.srt | 17.19 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.srt | 11.71 KB | ||
| 4.1 Lecture Slides.html | 125 B | ||
| 5. Creating Logger Triggers.mp4 | 18.62 MB | ||
| 5. Creating Logger Triggers.srt | 13.8 KB | ||
| 5.1 Lecture Slides.html | 125 B | ||
| 6. Managing Triggers And A Warning.mp4 | 12.56 MB | ||
| 6. Managing Triggers And A Warning.srt | 9.29 KB | ||
| 6.1 Lecture Slides.html | 125 B | ||
| 2. Getting Started Overview and Installation | |||
| 1. Section Introduction.mp4 | 7.98 MB | ||
| 1. Section Introduction.srt | 1.94 KB | ||
| 2. What Is a Database.mp4 | 10.27 MB | ||
| 2. What Is a Database.srt | 10.47 KB | ||
| 2.1 Slides For This Section.html | 104 B | ||
| 3. SQL Vs. MySQL.mp4 | 7.71 MB | ||
| 3. SQL Vs. MySQL.srt | 8.08 KB | ||
| 4. Installation Overview - WATCH BEFORE INSTALLING.mp4 | 6.63 MB | ||
| 4. Installation Overview - WATCH BEFORE INSTALLING.srt | 8.19 KB | ||
| 4.1 Installation Slides.html | 107 B | ||
| 5. Cloud9 Registration IMPORTANT - PLEASE READ!!!.html | 1.79 KB | ||
| 6. Mac Installation.mp4 | 22.18 MB | ||
| 6. Mac Installation.srt | 17.73 KB | ||
| 7. CODE Mac Installation.html | 1.31 KB | ||
| 8. Windows Installation.mp4 | 5.73 MB | ||
| 8. Windows Installation.srt | 6.4 KB | ||
| 3. Creating Databases and Tables | |||
| 1. Section 3 Introduction.mp4 | 9.38 MB | ||
| 1. Section 3 Introduction.srt | 1.96 KB | ||
| 10. Note about INT max size.html | 401 B | ||
| 11. Basic Datatypes Challenge.mp4 | 3.52 MB | ||
| 11. Basic Datatypes Challenge.srt | 3.73 KB | ||
| 12. Basic Datatypes Challenge - Solution.html | 183 B | ||
| 13. Creating Your Own Tables.mp4 | 3.94 MB | ||
| 13. Creating Your Own Tables.srt | 4.08 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.srt | 3.8 KB | ||
| 16. CODE How Do We Know It Worked.html | 99 B | ||
| 17. Dropping Tables.mp4 | 2.09 MB | ||
| 17. Dropping Tables.srt | 2.57 KB | ||
| 18. CODE Dropping Tables.html | 181 B | ||
| 19. Creating Your Own Tables Challenge.mp4 | 6.07 MB | ||
| 19. Creating Your Own Tables Challenge.srt | 6.36 KB | ||
| 19.1 Slides.html | 127 B | ||
| 2. Creating Databases.mp4 | 7.24 MB | ||
| 2. Creating Databases.srt | 7.44 KB | ||
| 2.1 Slides For This Section!.html | 110 B | ||
| 20. CODE Creating Your Own Tables Challenge.html | 161 B | ||
| 3. CODE Creating Databases.html | 386 B | ||
| 4. Dropping Databases.mp4 | 2.47 MB | ||
| 4. Dropping Databases.srt | 2.65 KB | ||
| 5. CODE Dropping Databases.html | 292 B | ||
| 6. Using Databases.mp4 | 4.4 MB | ||
| 6. Using Databases.srt | 3.91 KB | ||
| 7. CODE Using Databases.html | 120 B | ||
| 8. Introduction to Tables.mp4 | 7.12 MB | ||
| 8. Introduction to Tables.srt | 7.7 KB | ||
| 9. The Basic Datatypes.mp4 | 10.78 MB | ||
| 9. The Basic Datatypes.srt | 11.33 KB | ||
| 4. Inserting Data (and a couple other things) | |||
| 1. Section 4 Introduction.mp4 | 10.8 MB | ||
| 1. Section 4 Introduction.srt | 2.63 KB | ||
| 10. INSERT Challenges Solution.mp4 | 7.17 MB | ||
| 10. INSERT Challenges Solution.srt | 4.98 KB | ||
| 11. CODE INSERT Challenges Solution.html | 839 B | ||
| 12. NOTE MySQL Warnings.html | 532 B | ||
| 13. MySQL Warnings.mp4 | 8.62 MB | ||
| 13. MySQL Warnings.srt | 4.95 KB | ||
| 14. CODE MySQL Warnings.html | 637 B | ||
| 15. NULL and NOT_NULL.mp4 | 10.16 MB | ||
| 15. NULL and NOT_NULL.srt | 8.27 KB | ||
| 16. CODE NULL and NOT NULL.html | 1.1 KB | ||
| 17. Setting Default Values.mp4 | 10.38 MB | ||
| 17. Setting Default Values.srt | 8.37 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.srt | 16 KB | ||
| 2. Inserting Data.mp4 | 6.69 MB | ||
| 2. Inserting Data.srt | 7.01 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.61 MB | ||
| 21. Table Constraints Exercise.srt | 3.12 KB | ||
| 21.1 Exercise Slides.html | 112 B | ||
| 22. Table Constraints Exercise Solution.mp4 | 7.99 MB | ||
| 22. Table Constraints Exercise Solution.srt | 4.52 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.95 MB | ||
| 4. Super Quick Intro To SELECT.srt | 3.23 KB | ||
| 5. CODE Super Quick Intro To SELECT.html | 41 B | ||
| 6. Multiple INSERT.mp4 | 4.07 MB | ||
| 6. Multiple INSERT.srt | 4.07 KB | ||
| 7. CODE Multiple Insert.html | 189 B | ||
| 8. INSERT Challenges.mp4 | 2.18 MB | ||
| 8. INSERT Challenges.srt | 2.25 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.srt | 2.57 KB | ||
| 10. SELECT Challenges.mp4 | 3.09 MB | ||
| 10. SELECT Challenges.srt | 2.85 KB | ||
| 11. SELECT Challenges Solution.mp4 | 4.07 MB | ||
| 11. SELECT Challenges Solution.srt | 3.61 KB | ||
| 12. CODE SELECT Challenges Solution.html | 385 B | ||
| 13. Introduction to Aliases.mp4 | 3.95 MB | ||
| 13. Introduction to Aliases.srt | 3.92 KB | ||
| 14. CODE Introduction to Aliases.html | 198 B | ||
| 15. The UPDATE Command.mp4 | 5.43 MB | ||
| 15. The UPDATE Command.srt | 5.18 KB | ||
| 16. CODE The UPDATE Command.html | 284 B | ||
| 17. UPDATE Challenges.mp4 | 855.66 KB | ||
| 17. UPDATE Challenges.srt | 870 B | ||
| 18. UPDATE Challenges Solution.mp4 | 5.65 MB | ||
| 18. UPDATE Challenges Solution.srt | 4.75 KB | ||
| 19. CODE UPDATE Challenges Solution.html | 561 B | ||
| 2. Introduction to CRUD.mp4 | 2.25 MB | ||
| 2. Introduction to CRUD.srt | 2.59 KB | ||
| 2.1 This Section's Slides.html | 111 B | ||
| 20. Introduction to DELETE.mp4 | 6.17 MB | ||
| 20. Introduction to DELETE.srt | 6.74 KB | ||
| 21. CODE Introduction to DELETE.html | 240 B | ||
| 22. DELETE Challenges.mp4 | 1.64 MB | ||
| 22. DELETE Challenges.srt | 1.85 KB | ||
| 22.1 Slides.html | 128 B | ||
| 23. DELETE Challenges Solution.mp4 | 4.25 MB | ||
| 23. DELETE Challenges Solution.srt | 3.36 KB | ||
| 24. CODE DELETE Challenges Solution.html | 317 B | ||
| 3. CODE Introduction to CRUD.html | 73 B | ||
| 4. Preparing Our Data.mp4 | 3.71 MB | ||
| 4. Preparing Our Data.srt | 3.54 KB | ||
| 5. CODE Preparing Our Data.html | 811 B | ||
| 6. Official Introduction to SELECT.mp4 | 6.13 MB | ||
| 6. Official Introduction to SELECT.srt | 5.33 KB | ||
| 7. CODE Official Introduction to SELECT.html | 573 B | ||
| 8. Introduction to WHERE.mp4 | 6.82 MB | ||
| 8. Introduction to WHERE.srt | 7.02 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.srt | 3.18 KB | ||
| 10. CODE CRUD Exercise Delete Solution.html | 402 B | ||
| 2. CRUD Exercise Overview.mp4 | 10.61 MB | ||
| 2. CRUD Exercise Overview.srt | 11.34 KB | ||
| 2.1 Slides.html | 128 B | ||
| 3. CRUD Exercise Create Solution.mp4 | 8.93 MB | ||
| 3. CRUD Exercise Create Solution.srt | 7.13 KB | ||
| 4. CODE CRUD Exercise Create Solution.html | 802 B | ||
| 5. CRUD Exercise Read Solution.mp4 | 2.89 MB | ||
| 5. CRUD Exercise Read Solution.srt | 2.1 KB | ||
| 6. CODE CRUD Exercise Read Solution.html | 198 B | ||
| 7. CRUD Exercise Update Solution.mp4 | 6.39 MB | ||
| 7. CRUD Exercise Update Solution.srt | 5.09 KB | ||
| 8. CODE CRUD Exercise Update Solution.html | 630 B | ||
| 9. CRUD Exercise Delete Solution.mp4 | 4.88 MB | ||
| 9. CRUD Exercise Delete Solution.srt | 4.24 KB | ||
| 7. The World Of String Functions | |||
| 1. Section 7 Introduction.mp4 | 11.2 MB | ||
| 1. Section 7 Introduction.srt | 3.29 KB | ||
| 10. CODE Introducing SUBSTRING.html | 808 B | ||
| 11. Introducing REPLACE.mp4 | 11.46 MB | ||
| 11. Introducing REPLACE.srt | 8.35 KB | ||
| 12. CODE Introducing REPLACE.html | 887 B | ||
| 13. Using REVERSE.mp4 | 5.39 MB | ||
| 13. Using REVERSE.srt | 4.6 KB | ||
| 14. CODE Using REVERSE.html | 247 B | ||
| 15. Working with CHAR LENGTH.mp4 | 8.32 MB | ||
| 15. Working with CHAR LENGTH.srt | 6.52 KB | ||
| 16. CODE Working with CHAR LENGTH.html | 325 B | ||
| 17. Changing Case with UPPER and LOWER.mp4 | 6.14 MB | ||
| 17. Changing Case with UPPER and LOWER.srt | 4.61 KB | ||
| 18. CODE Changing Case with UPPER and LOWER.html | 261 B | ||
| 19. Note about string functions.html | 1.01 KB | ||
| 2. Note about Running SQL Files.html | 461 B | ||
| 20. String Function Challenges.mp4 | 7.21 MB | ||
| 20. String Function Challenges.srt | 6.59 KB | ||
| 20.1 Slides.html | 128 B | ||
| 21. String Function Challenges Solution.mp4 | 24.78 MB | ||
| 21. String Function Challenges Solution.srt | 15.54 KB | ||
| 22. CODE String Function Challenges Solution.html | 1.33 KB | ||
| 3. Running SQL Files.mp4 | 15.17 MB | ||
| 3. Running SQL Files.srt | 13.83 KB | ||
| 3.1 Slides For This Section.html | 111 B | ||
| 4. CODE Running SQL Files.html | 403 B | ||
| 5. Loading Our Book Data.mp4 | 13.04 MB | ||
| 5. Loading Our Book Data.srt | 7.89 KB | ||
| 5.1 book_data.sql file available from this c9 workspace.html | 105 B | ||
| 5.2 book_data.sql.sql | 1.31 KB | ||
| 6. CODE Loading Our Book Data.html | 1.67 KB | ||
| 7. Working with CONCAT.mp4 | 23.01 MB | ||
| 7. Working with CONCAT.srt | 15.6 KB | ||
| 8. CODE Working With CONCAT.html | 944 B | ||
| 9. Introducing SUBSTRING.mp4 | 15.73 MB | ||
| 9. Introducing SUBSTRING.srt | 13.53 KB | ||
| 8. Refining Our Selections | |||
| 1. Section 8 Introduction.mp4 | 4.63 MB | ||
| 1. Section 8 Introduction.srt | 1.05 KB | ||
| 10. Better Searches with LIKE.mp4 | 10.47 MB | ||
| 10. Better Searches with LIKE.srt | 10.44 KB | ||
| 11. CODE Better Searches with LIKE.html | 331 B | ||
| 12. LIKE Part 2 More Wildcards.mp4 | 9.49 MB | ||
| 12. LIKE Part 2 More Wildcards.srt | 8.96 KB | ||
| 13. CODE LIKE Part 2 More Wildcards.html | 388 B | ||
| 14. Refining Selections Exercises.mp4 | 7.5 MB | ||
| 14. Refining Selections Exercises.srt | 7.07 KB | ||
| 14.1 Slides.html | 128 B | ||
| 15. Refining Selections Exercises Solution.mp4 | 24.86 MB | ||
| 15. Refining Selections Exercises Solution.srt | 16.47 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.srt | 4.65 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.srt | 11.05 KB | ||
| 5. CODE Using DISTINCT.html | 284 B | ||
| 6. Sorting Data with ORDER BY.mp4 | 19.53 MB | ||
| 6. Sorting Data with ORDER BY.srt | 2.24 KB | ||
| 7. CODE Sorting Data with ORDER BY.html | 997 B | ||
| 8. Using LIMIT.mp4 | 16.36 MB | ||
| 8. Using LIMIT.srt | 13.01 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.srt | 6.42 KB | ||
| 10. Using Min and Max with Group By.mp4 | 10.35 MB | ||
| 10. Using Min and Max with Group By.srt | 10.37 MB | ||
| 11. CODE Using Min and Max with Group By.html | 432 B | ||
| 12. The Sum Function.mp4 | 6.39 MB | ||
| 12. The Sum Function.srt | 5.73 KB | ||
| 13. CODE The Sum Function.html | 350 B | ||
| 14. The Avg Function.mp4 | 8.6 MB | ||
| 14. The Avg Function.srt | 8.39 KB | ||
| 15. CODE The Avg Function.html | 350 B | ||
| 16. Aggregate Functions Challenges.mp4 | 5.82 MB | ||
| 16. Aggregate Functions Challenges.srt | 5.83 KB | ||
| 16.1 Slides.html | 129 B | ||
| 17. Aggregate Functions Challenges Solution.mp4 | 14.84 MB | ||
| 17. Aggregate Functions Challenges Solution.srt | 10.26 KB | ||
| 18. CODE Aggregate Functions Challenges Solution.html | 841 B | ||
| 2. The Count Function.mp4 | 12.92 MB | ||
| 2. The Count Function.srt | 11.78 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.86 MB | ||
| 4. The Joys of Group By.srt | 17.05 KB | ||
| 5. CODE The Joys of Group By.html | 726 B | ||
| 6. Min and Max Basics.mp4 | 6.44 MB | ||
| 6. Min and Max Basics.srt | 5.18 KB | ||
| 7. CODE MIN and MAX Basics.html | 258 B | ||
| 8. SUBQUERIES - A Problem with Min and Max.mp4 | 10.75 MB | ||
| 8. SUBQUERIES - A Problem with Min and Max.srt | 9.16 KB | ||
| 9. CODE A Problem with Min and Max.html | 480 B | ||
| Read Me.txt | 1.01 KB | ||
| [FreeAllCourse.Com].URL | 228 B | ||
| ▲ 546 total files | |||
The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert
Become an In-demand SQL Master by creating complex databases and building reports through real-world projects
What you'll learn?
#Create your own database or interact with existing databases
#Write complex SQL queries across multiple tables
#Build a web app using NodeJS and MySQL
#Model real-world data and generate reports using SQL
#Answer company performance or sales questions using data
Description
Created by Colt Steele, Ian Schoonover
Last updated 2/2020
English
Get Paid Udemy Course For Free: FreeAllCourse.Com
| 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