Download link
File List
-
15. Working With Lots Of Instagram Data/2. Loading The JUMBO dataset.mp4 59.23 MB
17. Section 17 - Building Our Web App/14. Connecting The Form.mp4 36.22 MB
11. The Power of Logical Operators/21. Logical Operators Exercises Solution.mp4 33.28 MB
10. Revisiting Data Types/15. Formatting Dates.mp4 31.74 MB
17. Section 17 - Building Our Web App/12. Adding EJS Templates.mp4 30.45 MB
12. Section 12 One To Many/11. Left Join.mp4 28.38 MB
17. Section 17 - Building Our Web App/6. Our First Simple Web App.mp4 28.18 MB
18. Section 18 - Database Triggers/1. Introduction to Database Triggers.mp4 27.61 MB
12. Section 12 One To Many/9. Inner Join.mp4 27.57 MB
10. Revisiting Data Types/22. Data Types Exercises Solution.mp4 26.42 MB
8. Refining Our Selections/15. Refining Selections Exercises Solution.mp4 24.86 MB
7. The World Of String Functions/21. String Function Challenges Solution.mp4 24.78 MB
13. Section 13 Many To Many/15. TV Joins Challenge 6.mp4 23.34 MB
16. Section 16 - Introducing Node/14. Connecting Node to MySQL.mp4 23.05 MB
7. The World Of String Functions/7. Working with CONCAT.mp4 23.01 MB
18. Section 18 - Database Triggers/3. Writing Our First Trigger Part 2.mp4 22.77 MB
12. Section 12 One To Many/5. Working With Foreign Keys.mp4 22.67 MB
16. Section 16 - Introducing Node/23. Bulk Inserting 500 Users - Finally!.mp4 22.41 MB
1. Introduction and 5 Minutes of SQL/7. How The Course Works.mp4 22.4 MB
2. Getting Started Overview and Installation/6. Mac Installation.mp4 22.17 MB
16. Section 16 - Introducing Node/20. Inserting Using Node.mp4 21.92 MB
11. The Power of Logical Operators/16. In And Not In.mp4 21.91 MB
16. Section 16 - Introducing Node/26. 500 Users Exercises Solutions.mp4 21.87 MB
13. Section 13 Many To Many/3. Creating Our Tables.mp4 21.84 MB
14. Instagram Database Clone/14. Cloning Instagram's DB Hashtags Part 1.mp4 21.83 MB
14. Instagram Database Clone/2. Introduction To Instagram Clone Schema.mp4 21.73 MB
11. The Power of Logical Operators/18. Case Statements.mp4 21.04 MB
17. Section 17 - Building Our Web App/10. Connecting Express and MySQL.mp4 20.78 MB
10. Revisiting Data Types/2. CHAR and VARCHAR.mp4 20.62 MB
12. Section 12 One To Many/15. Right Joins Pt 2.mp4 20.58 MB
14. Instagram Database Clone/9. Cloning Instagram's DB Likes Schema.mp4 20.56 MB
12. Section 12 One To Many/13. Right Joins Pt 1.mp4 20.31 MB
8. Refining Our Selections/6. Sorting Data with ORDER BY.mp4 19.53 MB
10. Revisiting Data Types/19. Working with TIMESTAMPS.mp4 19.04 MB
12. Section 12 One To Many/4. One To Many The Basics.mp4 19.03 MB
9. The Magic of Aggregate Functions/4. The Joys of Group By.mp4 18.86 MB
17. Section 17 - Building Our Web App/8. Adding Multiple Routes.mp4 18.66 MB
12. Section 12 One To Many/20. Our First Joins Exercise SOLUTION.mp4 18.65 MB
18. Section 18 - Database Triggers/5. Creating Logger Triggers.mp4 18.62 MB
10. Revisiting Data Types/17. Date Math.mp4 18.52 MB
17. Section 17 - Building Our Web App/18. Styling Part 2.mp4 18.37 MB
1. Introduction and 5 Minutes of SQL/5. Your First 5 Minutes of SQL - Let's Get Coding!.mp4 18.32 MB
11. The Power of Logical Operators/14. Between.mp4 18.24 MB
4. Inserting Data (and a couple other things)/19. A Primer On Primary Keys.mp4 18.18 MB
17. Section 17 - Building Our Web App/16. Styling Part 1.mp4 17.99 MB
16. Section 16 - Introducing Node/22. Some MySQLNode Magic.mp4 17.86 MB
9. The Magic of Aggregate Functions/1. Section 9 Introduction.mp4 17.55 MB
15. Working With Lots Of Instagram Data/8. Instagram Clone Challenge 3.mp4 17.25 MB
12. Section 12 One To Many/22. Our First Joins Exercise SOLUTION PT. 2.mp4 17.2 MB
11. The Power of Logical Operators/6. Greater Than.mp4 16.39 MB
8. Refining Our Selections/8. Using LIMIT.mp4 16.36 MB
16. Section 16 - Introducing Node/10. Introduction to NPM and Faker.mp4 15.88 MB
15. Working With Lots Of Instagram Data/10. Instagram Clone Challenge 4.mp4 15.83 MB
7. The World Of String Functions/9. Introducing SUBSTRING.mp4 15.74 MB
11. The Power of Logical Operators/1. Section 11 Introduction.mp4 15.7 MB
13. Section 13 Many To Many/17. TV Joins Challenge 7.mp4 15.49 MB
11. The Power of Logical Operators/10. Logical AND.mp4 15.48 MB
7. The World Of String Functions/3. Running SQL Files.mp4 15.17 MB
16. Section 16 - Introducing Node/4. BUT WHAT ABOUT PHP.mp4 15.16 MB
9. The Magic of Aggregate Functions/17. Aggregate Functions Challenges Solution.mp4 14.84 MB
12. Section 12 One To Many/7. Cross Join.mp4 14.5 MB
6. CRUD Challenge Section/1. Section 6 Introduction.mp4 14.46 MB
13. Section 13 Many To Many/2. Many To Many Basics.mp4 14.22 MB
12. Section 12 One To Many/2. Real World Data Is Messy.mp4 14.13 MB
18. Section 18 - Database Triggers/4. Preventing Instagram Self-Follows With Triggers.mp4 14.11 MB
16. Section 16 - Introducing Node/16. Creating Our Users Table.mp4 13.99 MB
5. CRUD commmands/1. Section 5 Introduction.mp4 13.31 MB
12. Section 12 One To Many/1. Section 12 Introduction.mp4 13.29 MB
13. Section 13 Many To Many/7. TV Joins Challenge 2.mp4 13.24 MB
16. Section 16 - Introducing Node/2. Section 16 Introduction.mp4 13.12 MB
7. The World Of String Functions/5. Loading Our Book Data.mp4 13.05 MB
13. Section 13 Many To Many/1. Section 13 Introduction.mp4 13 MB
14. Instagram Database Clone/7. Cloning Instagram's DB Comments Schema.mp4 12.95 MB
9. The Magic of Aggregate Functions/2. The Count Function.mp4 12.92 MB
8. Refining Our Selections/4. Using DISTINCT.mp4 12.7 MB
14. Instagram Database Clone/11. Cloning Instagram's DB Followers Schema.mp4 12.65 MB
18. Section 18 - Database Triggers/6. Managing Triggers And A Warning.mp4 12.55 MB
13. Section 13 Many To Many/11. TV Joins Challenge 4.srt 12.35 MB
13. Section 13 Many To Many/11. TV Joins Challenge 4.mp4 12.33 MB
1. Introduction and 5 Minutes of SQL/3. Syllabus Walkthrough and Prerequisites.mp4 12.14 MB
16. Section 16 - Introducing Node/5. Introduction to JOIN US app.mp4 11.93 MB
13. Section 13 Many To Many/5. TV Joins Challenge 1.mp4 11.78 MB
14. Instagram Database Clone/15. Cloning Instagram's DB Hashtags Part 2.mp4 11.77 MB
15. Working With Lots Of Instagram Data/14. Instagram Clone Challenge 6.mp4 11.74 MB
17. Section 17 - Building Our Web App/1. Section 17 Introduction.mp4 11.74 MB
14. Instagram Database Clone/5. Cloning Instagram's DB Photos Schema.mp4 11.72 MB
15. Working With Lots Of Instagram Data/6. Instagram Clone Challenge 2.mp4 11.71 MB
12. Section 12 One To Many/19. Our First Joins Exercise.mp4 11.62 MB
10. Revisiting Data Types/7. FLOAT and DOUBLE.mp4 11.6 MB
17. Section 17 - Building Our Web App/4. NPM Init and package.json files.mp4 11.6 MB
7. The World Of String Functions/11. Introducing REPLACE.mp4 11.46 MB
13. Section 13 Many To Many/9. TV Joins Challenge 3.mp4 11.44 MB
16. Section 16 - Introducing Node/18. Selecting Using Node.mp4 11.34 MB
18. Section 18 - Database Triggers/2. Writing Our First Trigger Part 1.mp4 11.34 MB
10. Revisiting Data Types/5. DECIMAL.mp4 11.28 MB
15. Working With Lots Of Instagram Data/1. Section 15 Introduction.mp4 11.25 MB
10. Revisiting Data Types/1. Section 10 Introduction.mp4 11.21 MB
7. The World Of String Functions/1. Section 7 Introduction.mp4 11.2 MB
16. Section 16 - Introducing Node/3. MySQL and Other Languages.mp4 11.16 MB
15. Working With Lots Of Instagram Data/17. Instagram Clone Challenge 7.mp4 10.98 MB
11. The Power of Logical Operators/20. Logical Operators Exercises.mp4 10.83 MB
4. Inserting Data (and a couple other things)/1. Section 4 Introduction.mp4 10.8 MB
3. Creating Databases and Tables/9. The Basic Datatypes.mp4 10.77 MB
9. The Magic of Aggregate Functions/8. SUBQUERIES - A Problem with Min and Max.mp4 10.75 MB
11. The Power of Logical Operators/12. Logical OR.mp4 10.69 MB
6. CRUD Challenge Section/2. CRUD Exercise Overview.mp4 10.61 MB
8. Refining Our Selections/10. Better Searches with LIKE.mp4 10.47 MB
4. Inserting Data (and a couple other things)/17. Setting Default Values.mp4 10.39 MB
9. The Magic of Aggregate Functions/10. Using Min and Max with Group By.mp4 10.35 MB
2. Getting Started Overview and Installation/2. What Is a Database.mp4 10.27 MB
4. Inserting Data (and a couple other things)/15. NULL and NOT_NULL.mp4 10.17 MB
13. Section 13 Many To Many/13. TV Joins Challenge 5.mp4 9.63 MB
17. Section 17 - Building Our Web App/3. Introducing Express.mp4 9.54 MB
14. Instagram Database Clone/3. Cloning Instagram's DB Users Schema.mp4 9.5 MB
8. Refining Our Selections/12. LIKE Part 2 More Wildcards.mp4 9.49 MB
14. Instagram Database Clone/1. Section 14 Introduction.mp4 9.48 MB
3. Creating Databases and Tables/1. Section 3 Introduction.mp4 9.38 MB
16. Section 16 - Introducing Node/7. 5 Minute NodeJS Crash Course.mp4 9.35 MB
6. CRUD Challenge Section/3. CRUD Exercise Create Solution.mp4 8.93 MB
4. Inserting Data (and a couple other things)/13. MySQL Warnings.mp4 8.63 MB
15. Working With Lots Of Instagram Data/4. Instagram Clone Challenge 1.mp4 8.62 MB
9. The Magic of Aggregate Functions/14. The Avg Function.mp4 8.6 MB
1. Introduction and 5 Minutes of SQL/2. Instructor Introduction(s).mp4 8.44 MB
10. Revisiting Data Types/11. Creating Our DATE data.mp4 8.39 MB
7. The World Of String Functions/15. Working with CHAR LENGTH.mp4 8.32 MB
10. Revisiting Data Types/13. CURDATE, CURTIME, and NOW.mp4 8.22 MB
2. Getting Started Overview and Installation/1. Section Introduction.mp4 7.98 MB
4. Inserting Data (and a couple other things)/22. Table Constraints Exercise Solution.mp4 7.98 MB
12. Section 12 One To Many/17. Right and Left Joins A Common Question.mp4 7.93 MB
2. Getting Started Overview and Installation/3. SQL Vs. MySQL.mp4 7.71 MB
11. The Power of Logical Operators/2. Not Equal.mp4 7.69 MB
8. Refining Our Selections/14. Refining Selections Exercises.mp4 7.5 MB
3. Creating Databases and Tables/2. Creating Databases.mp4 7.24 MB
7. The World Of String Functions/20. String Function Challenges.mp4 7.2 MB
4. Inserting Data (and a couple other things)/10. INSERT Challenges Solution.mp4 7.17 MB
3. Creating Databases and Tables/8. Introduction to Tables.mp4 7.12 MB
10. Revisiting Data Types/21. Data Types Exercises.mp4 7 MB
16. Section 16 - Introducing Node/12. Introducing the MySQL Package.mp4 6.92 MB
5. CRUD commmands/8. Introduction to WHERE.mp4 6.83 MB
4. Inserting Data (and a couple other things)/2. Inserting Data.mp4 6.68 MB
2. Getting Started Overview and Installation/4. Installation Overview - WATCH BEFORE INSTALLING.mp4 6.64 MB
9. The Magic of Aggregate Functions/6. Min and Max Basics.mp4 6.44 MB
6. CRUD Challenge Section/7. CRUD Exercise Update Solution.mp4 6.4 MB
9. The Magic of Aggregate Functions/12. The Sum Function.mp4 6.39 MB
12. Section 12 One To Many/3. Types of Data Relationships.mp4 6.2 MB
5. CRUD commmands/20. Introduction to DELETE.mp4 6.17 MB
7. The World Of String Functions/17. Changing Case with UPPER and LOWER.mp4 6.14 MB
5. CRUD commmands/6. Official Introduction to SELECT.mp4 6.13 MB
3. Creating Databases and Tables/19. Creating Your Own Tables Challenge.mp4 6.07 MB
11. The Power of Logical Operators/8. Less Than.mp4 6.06 MB
9. The Magic of Aggregate Functions/16. Aggregate Functions Challenges.mp4 5.83 MB
1. Introduction and 5 Minutes of SQL/1. Course Introduction.mp4 5.82 MB
2. Getting Started Overview and Installation/8. Windows Installation.mp4 5.74 MB
5. CRUD commmands/18. UPDATE Challenges Solution.mp4 5.65 MB
10. Revisiting Data Types/10. DATE, TIME, and DATETIME.mp4 5.48 MB
5. CRUD commmands/15. The UPDATE Command.mp4 5.43 MB
15. Working With Lots Of Instagram Data/12. Instagram Clone Challenge 5.mp4 5.41 MB
7. The World Of String Functions/13. Using REVERSE.mp4 5.38 MB
6. CRUD Challenge Section/9. CRUD Exercise Delete Solution.mp4 4.89 MB
8. Refining Our Selections/1. Section 8 Introduction.mp4 4.63 MB
3. Creating Databases and Tables/6. Using Databases.mp4 4.4 MB
5. CRUD commmands/23. DELETE Challenges Solution.mp4 4.26 MB
5. CRUD commmands/11. SELECT Challenges Solution.mp4 4.07 MB
4. Inserting Data (and a couple other things)/6. Multiple INSERT.mp4 4.07 MB
5. CRUD commmands/13. Introduction to Aliases.mp4 3.96 MB
3. Creating Databases and Tables/13. Creating Your Own Tables.mp4 3.94 MB
8. Refining Our Selections/2. Seed Data Adding A Couple New Books.mp4 3.83 MB
11. The Power of Logical Operators/4. Not Like.mp4 3.77 MB
17. Section 17 - Building Our Web App/2.1 JoinUsCompleteCode.zip.zip 3.75 MB
5. CRUD commmands/4. Preparing Our Data.mp4 3.71 MB
3. Creating Databases and Tables/15. How Do We Know It Worked.mp4 3.52 MB
3. Creating Databases and Tables/11. Basic Datatypes Challenge.mp4 3.52 MB
16. Section 16 - Introducing Node/25. 500 Users Exercises.mp4 3.44 MB
5. CRUD commmands/10. SELECT Challenges.mp4 3.08 MB
4. Inserting Data (and a couple other things)/4. Super Quick Intro To SELECT.mp4 2.94 MB
6. CRUD Challenge Section/5. CRUD Exercise Read Solution.mp4 2.9 MB
4. Inserting Data (and a couple other things)/21. Table Constraints Exercise.mp4 2.62 MB
3. Creating Databases and Tables/4. Dropping Databases.mp4 2.46 MB
5. CRUD commmands/2. Introduction to CRUD.mp4 2.25 MB
4. Inserting Data (and a couple other things)/8. INSERT Challenges.mp4 2.17 MB
3. Creating Databases and Tables/17. Dropping Tables.mp4 2.1 MB
5. CRUD commmands/22. DELETE Challenges.mp4 1.64 MB
5. CRUD commmands/17. UPDATE Challenges.mp4 855.66 KB
15. Working With Lots Of Instagram Data/3.1 ig_clone_data.sql.sql 429.36 KB
17. Section 17 - Building Our Web App/14. Connecting The Form.srt 26.9 KB
17. Section 17 - Building Our Web App/6. Our First Simple Web App.srt 24.76 KB
17. Section 17 - Building Our Web App/12. Adding EJS Templates.srt 24.38 KB
11. The Power of Logical Operators/21. Logical Operators Exercises Solution.srt 22.42 KB
12. Section 12 One To Many/11. Left Join.srt 22.37 KB
10. Revisiting Data Types/2. CHAR and VARCHAR.srt 19.52 KB
12. Section 12 One To Many/4. One To Many The Basics.srt 18.45 KB
16. Section 16 - Introducing Node/14. Connecting Node to MySQL.srt 18.11 KB
10. Revisiting Data Types/15. Formatting Dates.srt 17.98 KB
2. Getting Started Overview and Installation/6. Mac Installation.srt 17.73 KB
10. Revisiting Data Types/22. Data Types Exercises Solution.srt 17.64 KB
18. Section 18 - Database Triggers/3. Writing Our First Trigger Part 2.srt 17.19 KB
9. The Magic of Aggregate Functions/4. The Joys of Group By.srt 17.05 KB
12. Section 12 One To Many/5. Working With Foreign Keys.srt 16.81 KB
8. Refining Our Selections/15. Refining Selections Exercises Solution.srt 16.47 KB
16. Section 16 - Introducing Node/20. Inserting Using Node.srt 16.42 KB
12. Section 12 One To Many/2. Real World Data Is Messy.srt 16.31 KB
12. Section 12 One To Many/9. Inner Join.srt 16.17 KB
4. Inserting Data (and a couple other things)/19. A Primer On Primary Keys.srt 16 KB
11. The Power of Logical Operators/18. Case Statements.srt 15.91 KB
7. The World Of String Functions/7. Working with CONCAT.srt 15.6 KB
13. Section 13 Many To Many/15. TV Joins Challenge 6.srt 15.54 KB
7. The World Of String Functions/21. String Function Challenges Solution.srt 15.54 KB
17. Section 17 - Building Our Web App/10. Connecting Express and MySQL.srt 15.4 KB
13. Section 13 Many To Many/2. Many To Many Basics.srt 15.26 KB
11. The Power of Logical Operators/16. In And Not In.srt 15.24 KB
10. Revisiting Data Types/19. Working with TIMESTAMPS.srt 15.12 KB
16. Section 16 - Introducing Node/26. 500 Users Exercises Solutions.srt 15.04 KB
14. Instagram Database Clone/14. Cloning Instagram's DB Hashtags Part 1.srt 14.96 KB
16. Section 16 - Introducing Node/3. MySQL and Other Languages.srt 14.7 KB
17. Section 17 - Building Our Web App/8. Adding Multiple Routes.srt 14.65 KB
13. Section 13 Many To Many/3. Creating Our Tables.srt 14.41 KB
11. The Power of Logical Operators/14. Between.srt 14.38 KB
12. Section 12 One To Many/13. Right Joins Pt 1.srt 14.37 KB
11. The Power of Logical Operators/6. Greater Than.srt 14.04 KB
7. The World Of String Functions/3. Running SQL Files.srt 13.83 KB
18. Section 18 - Database Triggers/5. Creating Logger Triggers.srt 13.8 KB
7. The World Of String Functions/9. Introducing SUBSTRING.srt 13.53 KB
14. Instagram Database Clone/2. Introduction To Instagram Clone Schema.srt 13.41 KB
11. The Power of Logical Operators/10. Logical AND.srt 13.4 KB
8. Refining Our Selections/8. Using LIMIT.srt 13.01 KB
16. Section 16 - Introducing Node/23. Bulk Inserting 500 Users - Finally!.srt 12.83 KB
12. Section 12 One To Many/15. Right Joins Pt 2.srt 12.81 KB
16. Section 16 - Introducing Node/5. Introduction to JOIN US app.srt 12.7 KB
16. Section 16 - Introducing Node/10. Introduction to NPM and Faker.srt 12.55 KB
12. Section 12 One To Many/22. Our First Joins Exercise SOLUTION PT. 2.srt 12.54 KB
15. Working With Lots Of Instagram Data/2. Loading The JUMBO dataset.srt 12.48 KB
17. Section 17 - Building Our Web App/16. Styling Part 1.srt 12.16 KB
12. Section 12 One To Many/20. Our First Joins Exercise SOLUTION.srt 11.9 KB
17. Section 17 - Building Our Web App/18. Styling Part 2.srt 11.88 KB
10. Revisiting Data Types/17. Date Math.srt 11.79 KB
9. The Magic of Aggregate Functions/2. The Count Function.srt 11.78 KB
18. Section 18 - Database Triggers/4. Preventing Instagram Self-Follows With Triggers.srt 11.71 KB
16. Section 16 - Introducing Node/4. BUT WHAT ABOUT PHP.srt 11.67 KB
6. CRUD Challenge Section/2. CRUD Exercise Overview.srt 11.34 KB
3. Creating Databases and Tables/9. The Basic Datatypes.srt 11.33 KB
8. Refining Our Selections/4. Using DISTINCT.srt 11.05 KB
15. Working With Lots Of Instagram Data/8. Instagram Clone Challenge 3.srt 10.84 KB
18. Section 18 - Database Triggers/2. Writing Our First Trigger Part 1.srt 10.78 KB
16. Section 16 - Introducing Node/22. Some MySQLNode Magic.srt 10.77 KB
16. Section 16 - Introducing Node/16. Creating Our Users Table.srt 10.64 KB
1. Introduction and 5 Minutes of SQL/5. Your First 5 Minutes of SQL - Let's Get Coding!.srt 10.59 KB
12. Section 12 One To Many/7. Cross Join.srt 10.49 KB
2. Getting Started Overview and Installation/2. What Is a Database.srt 10.47 KB
8. Refining Our Selections/10. Better Searches with LIKE.srt 10.44 KB
14. Instagram Database Clone/9. Cloning Instagram's DB Likes Schema.srt 10.34 KB
9. The Magic of Aggregate Functions/17. Aggregate Functions Challenges Solution.srt 10.26 KB
12. Section 12 One To Many/19. Our First Joins Exercise.srt 10.19 KB
15. Working With Lots Of Instagram Data/6. Instagram Clone Challenge 2.srt 10.07 KB
14. Instagram Database Clone/11. Cloning Instagram's DB Followers Schema.srt 9.98 KB
17. Section 17 - Building Our Web App/4. NPM Init and package.json files.srt 9.96 KB
10. Revisiting Data Types/7. FLOAT and DOUBLE.srt 9.95 KB
18. Section 18 - Database Triggers/1. Introduction to Database Triggers.srt 9.88 KB
11. The Power of Logical Operators/20. Logical Operators Exercises.srt 9.83 KB
17. Section 17 - Building Our Web App/3. Introducing Express.srt 9.51 KB
18. Section 18 - Database Triggers/6. Managing Triggers And A Warning.srt 9.29 KB
15. Working With Lots Of Instagram Data/10. Instagram Clone Challenge 4.srt 9.27 KB
9. The Magic of Aggregate Functions/8. SUBQUERIES - A Problem with Min and Max.srt 9.16 KB
16. Section 16 - Introducing Node/7. 5 Minute NodeJS Crash Course.srt 9.15 KB
13. Section 13 Many To Many/17. TV Joins Challenge 7.srt 9.13 KB
11. The Power of Logical Operators/12. Logical OR.srt 9.13 KB
8. Refining Our Selections/12. LIKE Part 2 More Wildcards.srt 8.96 KB
16. Section 16 - Introducing Node/18. Selecting Using Node.srt 8.91 KB
13. Section 13 Many To Many/7. TV Joins Challenge 2.srt 8.89 KB
14. Instagram Database Clone/3. Cloning Instagram's DB Users Schema.srt 8.78 KB
14. Instagram Database Clone/7. Cloning Instagram's DB Comments Schema.srt 8.59 KB
9. The Magic of Aggregate Functions/10. Using Min and Max with Group By.srt 8.51 KB
9. The Magic of Aggregate Functions/14. The Avg Function.srt 8.39 KB
4. Inserting Data (and a couple other things)/17. Setting Default Values.srt 8.37 KB
7. The World Of String Functions/11. Introducing REPLACE.srt 8.35 KB
14. Instagram Database Clone/5. Cloning Instagram's DB Photos Schema.srt 8.28 KB
4. Inserting Data (and a couple other things)/15. NULL and NOT_NULL.srt 8.27 KB
2. Getting Started Overview and Installation/4. Installation Overview - WATCH BEFORE INSTALLING.srt 8.19 KB
10. Revisiting Data Types/5. DECIMAL.srt 8.08 KB
2. Getting Started Overview and Installation/3. SQL Vs. MySQL.srt 8.08 KB
7. The World Of String Functions/5. Loading Our Book Data.srt 7.89 KB
16. Section 16 - Introducing Node/12. Introducing the MySQL Package.srt 7.7 KB
3. Creating Databases and Tables/8. Introduction to Tables.srt 7.7 KB
10. Revisiting Data Types/13. CURDATE, CURTIME, and NOW.srt 7.66 KB
3. Creating Databases and Tables/2. Creating Databases.srt 7.44 KB
1. Introduction and 5 Minutes of SQL/3. Syllabus Walkthrough and Prerequisites.srt 7.3 KB
6. CRUD Challenge Section/3. CRUD Exercise Create Solution.srt 7.13 KB
8. Refining Our Selections/14. Refining Selections Exercises.srt 7.07 KB
15. Working With Lots Of Instagram Data/17. Instagram Clone Challenge 7.srt 7.04 KB
5. CRUD commmands/8. Introduction to WHERE.srt 7.02 KB
4. Inserting Data (and a couple other things)/2. Inserting Data.srt 7.01 KB
14. Instagram Database Clone/15. Cloning Instagram's DB Hashtags Part 2.srt 6.98 KB
15. Working With Lots Of Instagram Data/4. Instagram Clone Challenge 1.srt 6.89 KB
5. CRUD commmands/20. Introduction to DELETE.srt 6.74 KB
12. Section 12 One To Many/3. Types of Data Relationships.srt 6.7 KB
13. Section 13 Many To Many/13. TV Joins Challenge 5.srt 6.65 KB
10. Revisiting Data Types/11. Creating Our DATE data.srt 6.61 KB
7. The World Of String Functions/20. String Function Challenges.srt 6.59 KB
13. Section 13 Many To Many/9. TV Joins Challenge 3.srt 6.58 KB
15. Working With Lots Of Instagram Data/14. Instagram Clone Challenge 6.srt 6.57 KB
7. The World Of String Functions/15. Working with CHAR LENGTH.srt 6.52 KB
1. Introduction and 5 Minutes of SQL/7. How The Course Works.srt 6.48 KB
10. Revisiting Data Types/21. Data Types Exercises.srt 6.46 KB
9. The Magic of Aggregate Functions/1. Section 9 Introduction.srt 6.42 KB
2. Getting Started Overview and Installation/8. Windows Installation.srt 6.4 KB
3. Creating Databases and Tables/19. Creating Your Own Tables Challenge.srt 6.36 KB
13. Section 13 Many To Many/5. TV Joins Challenge 1.srt 6.24 KB
10. Revisiting Data Types/10. DATE, TIME, and DATETIME.srt 6.13 KB
9. The Magic of Aggregate Functions/16. Aggregate Functions Challenges.srt 5.83 KB
9. The Magic of Aggregate Functions/12. The Sum Function.srt 5.73 KB
11. The Power of Logical Operators/2. Not Equal.srt 5.7 KB
5. CRUD commmands/6. Official Introduction to SELECT.srt 5.33 KB
11. The Power of Logical Operators/8. Less Than.srt 5.22 KB
5. CRUD commmands/15. The UPDATE Command.srt 5.18 KB
9. The Magic of Aggregate Functions/6. Min and Max Basics.srt 5.18 KB
6. CRUD Challenge Section/7. CRUD Exercise Update Solution.srt 5.09 KB
4. Inserting Data (and a couple other things)/10. INSERT Challenges Solution.srt 4.98 KB
4. Inserting Data (and a couple other things)/13. MySQL Warnings.srt 4.95 KB
5. CRUD commmands/18. UPDATE Challenges Solution.srt 4.75 KB
8. Refining Our Selections/2. Seed Data Adding A Couple New Books.srt 4.65 KB
7. The World Of String Functions/17. Changing Case with UPPER and LOWER.srt 4.61 KB
7. The World Of String Functions/13. Using REVERSE.srt 4.6 KB
15. Working With Lots Of Instagram Data/12. Instagram Clone Challenge 5.srt 4.52 KB
4. Inserting Data (and a couple other things)/22. Table Constraints Exercise Solution.srt 4.52 KB
11. The Power of Logical Operators/1. Section 11 Introduction.srt 4.25 KB
6. CRUD Challenge Section/9. CRUD Exercise Delete Solution.srt 4.24 KB
12. Section 12 One To Many/17. Right and Left Joins A Common Question.srt 4.13 KB
3. Creating Databases and Tables/13. Creating Your Own Tables.srt 4.08 KB
4. Inserting Data (and a couple other things)/6. Multiple INSERT.srt 4.07 KB
5. CRUD commmands/13. Introduction to Aliases.srt 3.92 KB
16. Section 16 - Introducing Node/25. 500 Users Exercises.srt 3.92 KB
3. Creating Databases and Tables/6. Using Databases.srt 3.91 KB
3. Creating Databases and Tables/15. How Do We Know It Worked.srt 3.8 KB
3. Creating Databases and Tables/11. Basic Datatypes Challenge.srt 3.73 KB
5. CRUD commmands/11. SELECT Challenges Solution.srt 3.61 KB
11. The Power of Logical Operators/4. Not Like.srt 3.59 KB
5. CRUD commmands/4. Preparing Our Data.srt 3.54 KB
5. CRUD commmands/23. DELETE Challenges Solution.srt 3.36 KB
7. The World Of String Functions/1. Section 7 Introduction.srt 3.29 KB
4. Inserting Data (and a couple other things)/4. Super Quick Intro To SELECT.srt 3.23 KB
6. CRUD Challenge Section/1. Section 6 Introduction.srt 3.18 KB
10. Revisiting Data Types/1. Section 10 Introduction.srt 3.15 KB
4. Inserting Data (and a couple other things)/21. Table Constraints Exercise.srt 3.12 KB
17. Section 17 - Building Our Web App/1. Section 17 Introduction.srt 3.1 KB
13. Section 13 Many To Many/1. Section 13 Introduction.srt 2.96 KB
12. Section 12 One To Many/1. Section 12 Introduction.srt 2.95 KB
5. CRUD commmands/10. SELECT Challenges.srt 2.85 KB
17. Section 17 - Building Our Web App/17.1 JOIN_US_HTML_AND_CSS.zip.zip 2.7 KB
15. Working With Lots Of Instagram Data/1. Section 15 Introduction.srt 2.68 KB
3. Creating Databases and Tables/4. Dropping Databases.srt 2.65 KB
16. Section 16 - Introducing Node/2. Section 16 Introduction.srt 2.65 KB
4. Inserting Data (and a couple other things)/1. Section 4 Introduction.srt 2.63 KB
1. Introduction and 5 Minutes of SQL/2. Instructor Introduction(s).srt 2.61 KB
5. CRUD commmands/2. Introduction to CRUD.srt 2.59 KB
3. Creating Databases and Tables/17. Dropping Tables.srt 2.57 KB
5. CRUD commmands/1. Section 5 Introduction.srt 2.57 KB
16. Section 16 - Introducing Node/15. CODE Connecting Node to MySQL.html 2.48 KB
13. Section 13 Many To Many/4. CODE Creating Our Tables.html 2.37 KB
16. Section 16 - Introducing Node/13. Note about connecting Node to MySQL.html 2.26 KB
4. Inserting Data (and a couple other things)/8. INSERT Challenges.srt 2.25 KB
8. Refining Our Selections/6. Sorting Data with ORDER BY.srt 2.24 KB
1. Introduction and 5 Minutes of SQL/1. Course Introduction.srt 2.18 KB
6. CRUD Challenge Section/5. CRUD Exercise Read Solution.srt 2.1 KB
14. Instagram Database Clone/1. Section 14 Introduction.srt 2.06 KB
3. Creating Databases and Tables/1. Section 3 Introduction.srt 1.96 KB
2. Getting Started Overview and Installation/1. Section Introduction.srt 1.94 KB
5. CRUD commmands/22. DELETE Challenges.srt 1.85 KB
2. Getting Started Overview and Installation/5. Cloud9 Registration IMPORTANT - PLEASE READ!!!.html 1.79 KB
7. The World Of String Functions/6. CODE Loading Our Book Data.html 1.67 KB
12. Section 12 One To Many/23. CODE Our First Joins Exercise SOLUTION PT. 2.html 1.6 KB
1. Introduction and 5 Minutes of SQL/6. CODE Your First 5 Minutes of SQL.html 1.57 KB
14. Instagram Database Clone/17. CODE Complete IG Clone Schema.html 1.57 KB
4. Inserting Data (and a couple other things)/20. CODE A Primer on Primary Keys.html 1.43 KB
11. The Power of Logical Operators/22. CODE Logical Operators Exercises Solution.html 1.41 KB
7. The World Of String Functions/22. CODE String Function Challenges Solution.html 1.33 KB
12. Section 12 One To Many/14. CODE Right Joins Part 1.html 1.33 KB
12. Section 12 One To Many/16. CODE Right Joins Part 2.html 1.31 KB
7. The World Of String Functions/5.2 book_data.sql.sql 1.31 KB
2. Getting Started Overview and Installation/7. CODE Mac Installation.html 1.31 KB
12. Section 12 One To Many/6. CODE Working With Foreign Keys.html 1.3 KB
16. Section 16 - Introducing Node/27. CODE 500 Users Exercises Solutions.html 1.29 KB
13. Section 13 Many To Many/16. CODE TV Joins Challenge 6 SOLUTION.html 1.26 KB
16. Section 16 - Introducing Node/11. CODE Introduction to NPM and Faker.html 1.21 KB
4. Inserting Data (and a couple other things)/18. CODE Setting Default Values.html 1.19 KB
10. Revisiting Data Types/23. CODE Data Types Exercises Solution.html 1.17 KB
11. The Power of Logical Operators/17. CODE In And Not In.html 1.16 KB
4. Inserting Data (and a couple other things)/16. CODE NULL and NOT NULL.html 1.1 KB
12. Section 12 One To Many/12. CODE Left Joins.html 1.06 KB
8. Refining Our Selections/1. Section 8 Introduction.srt 1.05 KB
7. The World Of String Functions/19. Note about string functions.html 1.01 KB
11. The Power of Logical Operators/19. CODE Case Statements.html 1.01 KB
8. Refining Our Selections/7. CODE Sorting Data with ORDER BY.html 997 B
12. Section 12 One To Many/10. CODE Inner Joins.html 979 B
10. Revisiting Data Types/16. CODE Formatting Dates.html 947 B
7. The World Of String Functions/8. CODE Working With CONCAT.html 944 B
4. Inserting Data (and a couple other things)/23. CODE Table Constraints Exercise Solution.html 938 B
10. Revisiting Data Types/20. CODE Working with TIMESTAMPS.html 936 B
8. Refining Our Selections/9. CODE Using LIMIT.html 897 B
7. The World Of String Functions/12. CODE Introducing REPLACE.html 887 B
16. Section 16 - Introducing Node/19. CODE Selecting Using Node.html 871 B
5. CRUD commmands/17. UPDATE Challenges.srt 870 B
4. Inserting Data (and a couple other things)/11. CODE INSERT Challenges Solution.html 839 B
16. Section 16 - Introducing Node/6. Note about Setting Up Cloud9 for Node.html 835 B
9. The Magic of Aggregate Functions/18. CODE Aggregate Functions Challenges Solution.html 815 B
5. CRUD commmands/5. CODE Preparing Our Data.html 811 B
11. The Power of Logical Operators/7. CODE Greater Than.html 809 B
7. The World Of String Functions/10. CODE Introducing SUBSTRING.html 808 B
6. CRUD Challenge Section/4. CODE CRUD Exercise Create Solution.html 802 B
12. Section 12 One To Many/21. CODE Our First Joins Exercise.html 798 B
16. Section 16 - Introducing Node/9. Note about Faker install.html 759 B
8. Refining Our Selections/16. CODE Refining Selections Exercises Solution.html 732 B
9. The Magic of Aggregate Functions/5. CODE The Joys of Group By.html 726 B
16. Section 16 - Introducing Node/21. CODE Inserting Using Node.html 724 B
11. The Power of Logical Operators/11. CODE Logical AND.html 641 B
4. Inserting Data (and a couple other things)/14. CODE MySQL Warnings.html 637 B
6. CRUD Challenge Section/8. CODE CRUD Exercise Update Solution.html 630 B
11. The Power of Logical Operators/15. CODE Between.html 618 B
10. Revisiting Data Types/18. CODE Date Math.html 596 B
16. Section 16 - Introducing Node/24. CODE Bulk Inserting 500 Users.html 585 B
12. Section 12 One To Many/8. CODE Cross Joins.html 578 B
5. CRUD commmands/7. CODE Official Introduction to SELECT.html 573 B
5. CRUD commmands/19. CODE UPDATE Challenges Solution.html 561 B
4. Inserting Data (and a couple other things)/12. NOTE MySQL Warnings.html 532 B
12. Section 12 One To Many/18. CODE Right and Left Joins FAQ.html 520 B
4. Inserting Data (and a couple other things)/9. Note about using quotes inside of inserted values.html 502 B
17. Section 17 - Building Our Web App/5. Note about Our First Simple Web App.html 493 B
11. The Power of Logical Operators/13. CODE Logical OR.html 492 B
9. The Magic of Aggregate Functions/9. CODE A Problem with Min and Max.html 480 B
17. Section 17 - Building Our Web App/9. CODE Adding Multiple Routes.html 467 B
1. Introduction and 5 Minutes of SQL/4. Note about SQL Editor.html 465 B
7. The World Of String Functions/2. Note about Running SQL Files.html 461 B
17. Section 17 - Building Our Web App/13. CODE Adding EJS Templates.html 441 B
9. The Magic of Aggregate Functions/11. CODE Using Min and Max with Group By.html 432 B
10. Revisiting Data Types/9. Note about setting the timezone in Cloud9.html 423 B
17. Section 17 - Building Our Web App/7. CODE Our First Simple Web App.html 411 B
10. Revisiting Data Types/4. CODE CHAR and VARCHAR.html 408 B
7. The World Of String Functions/4. CODE Running SQL Files.html 403 B
14. Instagram Database Clone/13. Note about Cloning Instagram's DB Hashtags Part 1.html 402 B
6. CRUD Challenge Section/10. CODE CRUD Exercise Delete Solution.html 402 B
10. Revisiting Data Types/12. CODE Creating Our DATE data.html 401 B
3. Creating Databases and Tables/10. Note about INT max size.html 401 B
13. Section 13 Many To Many/10. CODE TV Joins Challenge 3 SOLUTION.html 397 B
14. Instagram Database Clone/16. CODE IG Clone Hashtags Schema.html 389 B
15. Working With Lots Of Instagram Data/16. Note about Instagram Clone Challenge 7.html 388 B
8. Refining Our Selections/13. CODE LIKE Part 2 More Wildcards.html 388 B
3. Creating Databases and Tables/3. CODE Creating Databases.html 386 B
5. CRUD commmands/12. CODE SELECT Challenges Solution.html 385 B
15. Working With Lots Of Instagram Data/3. The Instagram Clone DATASET.html 381 B
9. The Magic of Aggregate Functions/3. CODE The Count Function.html 373 B
17. Section 17 - Building Our Web App/11. CODE Connecting Express and MySQL.html 372 B
15. Working With Lots Of Instagram Data/11. Instagram Challenge 4 Solution CODE.html 371 B
11. The Power of Logical Operators/9. CODE Less Than.html 370 B
8. Refining Our Selections/3. CODE Seed Data Adding A Couple New Books.html 361 B
10. Revisiting Data Types/3. Note about CHAR and VARCHAR.html 360 B
15. Working With Lots Of Instagram Data/18. Instagram Challenge 7 Solution CODE.html 360 B
16. Section 16 - Introducing Node/1. Note about Introducing Node.html 353 B
17. Section 17 - Building Our Web App/15. CODE Connecting the Form.html 352 B
9. The Magic of Aggregate Functions/13. CODE The Sum Function.html 350 B
9. The Magic of Aggregate Functions/15. CODE The Avg Function.html 350 B
14. Instagram Database Clone/8. CODE IG Clone Comments Schema.html 345 B
15. Working With Lots Of Instagram Data/15. Instagram Challenge 6 Solution CODE.html 341 B
17. Section 17 - Building Our Web App/2. Join Us Completed CODE.html 337 B
8. Refining Our Selections/11. CODE Better Searches with LIKE.html 331 B
11. The Power of Logical Operators/3. CODE Not Equal.html 326 B
7. The World Of String Functions/16. CODE Working with CHAR LENGTH.html 325 B
13. Section 13 Many To Many/18. CODE TV Joins Challenge 7 SOLUTION.html 320 B
14. Instagram Database Clone/12. CODE IG Clone Followers Schema.html 317 B
5. CRUD commmands/24. CODE DELETE Challenges Solution.html 317 B
5. CRUD commmands/9. CODE Introduction to WHERE.html 309 B
10. Revisiting Data Types/6. CODE DECIMAL.html 308 B
10. Revisiting Data Types/8. CODE FLOAT and DOUBLE.html 296 B
14. Instagram Database Clone/10. CODE IG Clone Likes Schema.html 295 B
3. Creating Databases and Tables/5. CODE Dropping Databases.html 292 B
8. Refining Our Selections/5. CODE Using DISTINCT.html 284 B
11. The Power of Logical Operators/5. CODE Not Like.html 282 B
10. Revisiting Data Types/14. Note about formatting dates.html 277 B
16. Section 16 - Introducing Node/8. CODE 5 Minute Node Crash Course.html 274 B
13. Section 13 Many To Many/14. CODE TV Joins Challenge 5 SOLUTION.html 267 B
4. Inserting Data (and a couple other things)/3. CODE Inserting Data.html 263 B
5. CRUD commmands/16. CODE The UPDATE Command.html 262 B
7. The World Of String Functions/18. CODE Changing Case with UPPER and LOWER.html 261 B
14. Instagram Database Clone/6. CODE IG Clone Photos Schema.html 260 B
9. The Magic of Aggregate Functions/7. CODE MIN and MAX Basics.html 258 B
3. Creating Databases and Tables/14. CODE Creating Your Own Tables.html 247 B
7. The World Of String Functions/14. CODE Using REVERSE.html 247 B
13. Section 13 Many To Many/8. CODE TV Joins Challenge 2 SOLUTION.html 240 B
5. CRUD commmands/21. CODE Introduction to DELETE.html 240 B
15. Working With Lots Of Instagram Data/13. Instagram Challenge 5 Solution CODE.html 232 B
13. Section 13 Many To Many/12. CODE TV Joins Challenge 4 SOLUTION.html 222 B
15. Working With Lots Of Instagram Data/9. Instagram Challenge 3 Solution CODE.html 219 B
15. Working With Lots Of Instagram Data/7. Instagram Challenge 2 Solution CODE.html 216 B
13. Section 13 Many To Many/6. CODE TV Joins Challenge 1 Solution.html 207 B
5. CRUD commmands/14. CODE Introduction to Aliases.html 198 B
6. CRUD Challenge Section/6. CODE CRUD Exercise Read Solution.html 198 B
4. Inserting Data (and a couple other things)/7. CODE Multiple Insert.html 189 B
14. Instagram Database Clone/4. CODE IG Clone Users Schema.html 188 B
16. Section 16 - Introducing Node/17. CODE Creating Our Users Table.html 186 B
3. Creating Databases and Tables/12. Basic Datatypes Challenge - Solution.html 183 B
3. Creating Databases and Tables/18. CODE Dropping Tables.html 181 B
3. Creating Databases and Tables/20. CODE Creating Your Own Tables Challenge.html 161 B
9. The Magic of Aggregate Functions/16.1 Slides.html 129 B
10. Revisiting Data Types/21.1 Slides.html 128 B
11. The Power of Logical Operators/20.1 Slides.html 128 B
5. CRUD commmands/22.1 Slides.html 128 B
6. CRUD Challenge Section/2.1 Slides.html 128 B
7. The World Of String Functions/20.1 Slides.html 128 B
8. Refining Our Selections/14.1 Slides.html 128 B
3. Creating Databases and Tables/19.1 Slides.html 127 B
15. Working With Lots Of Instagram Data/5. Instagram Challenge 1 Solution CODE.html 126 B
18. Section 18 - Database Triggers/4.1 Lecture Slides.html 125 B
18. Section 18 - Database Triggers/5.1 Lecture Slides.html 125 B
18. Section 18 - Database Triggers/6.1 Lecture Slides.html 125 B
18. Section 18 - Database Triggers/2.1 Lecture Slides.html 124 B
18. Section 18 - Database Triggers/3.1 Lecture Slides.html 124 B
1. Introduction and 5 Minutes of SQL/5.2 SQL Try-It Editor.html 123 B
18. Section 18 - Database Triggers/1.1 Lecture Slides.html 121 B
3. Creating Databases and Tables/7. CODE Using Databases.html 120 B
17. Section 17 - Building Our Web App/17. CODE HTML AND CSS FILES.html 117 B
12. Section 12 One To Many/19.1 Slides.html 113 B
13. Section 13 Many To Many/2.1 Slides.html 113 B
8. Refining Our Selections/2.1 Slides For This Section.html 113 B
9. The Magic of Aggregate Functions/2.1 Slides For This Section.html 113 B
4. Inserting Data (and a couple other things)/2.1 Slides For This Section.html 112 B
4. Inserting Data (and a couple other things)/21.1 Exercise Slides.html 112 B
10. Revisiting Data Types/2.1 Slides For This Section.html 111 B
11. The Power of Logical Operators/2.1 Slides For This Section.html 111 B
12. Section 12 One To Many/2.1 Slides For This Section.html 111 B
5. CRUD commmands/2.1 This Section's Slides.html 111 B
7. The World Of String Functions/3.1 Slides For This Section.html 111 B
15. Working With Lots Of Instagram Data/4.1 Slides.html 110 B
16. Section 16 - Introducing Node/25.1 Slides.html 110 B
17. Section 17 - Building Our Web App/3.1 Slides.html 110 B
3. Creating Databases and Tables/2.1 Slides For This Section!.html 110 B
1. Introduction and 5 Minutes of SQL/5.1 Lecture Slides.html 108 B
14. Instagram Database Clone/2.1 Slides For This Section.html 108 B
16. Section 16 - Introducing Node/3.1 Slides For This Section.html 108 B
2. Getting Started Overview and Installation/4.1 Installation Slides.html 107 B
7. The World Of String Functions/5.1 book_data.sql file available from this c9 workspace.html 105 B
2. Getting Started Overview and Installation/2.1 Slides For This Section.html 104 B
3. Creating Databases and Tables/16. CODE How Do We Know It Worked.html 99 B
16. Section 16 - Introducing Node/10.1 FakerJS Github Repo.html 95 B
16. Section 16 - Introducing Node/12.1 MySQL Node Package Github Repo.html 93 B
17. Section 17 - Building Our Web App/3.2 Express Documentation.html 83 B
5. CRUD commmands/3. CODE Introduction to CRUD.html 73 B
[FreeCourseWorld.Com].url 54 B
4. Inserting Data (and a couple other things)/5. CODE Super Quick Intro To SELECT.html 41 B
Download Info
-
Tips
“[FreeCourseWorld.Com] Udemy - The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
-
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.