MySQL终极训练营从SQL初学者到专家（英文教程）带字幕 The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert

01. Introduction and 5 Minutes of SQL

1. Course Introduction.en.srt 2.18kb

1. Course Introduction.mp4 5.81M

1. Course Introduction.srt 3.38kb

2. Instructor Introduction(s).en.srt 2.61kb

2. Instructor Introduction(s).mp4 8.43M

2. Instructor Introduction(s).srt 4.00kb

3. Syllabus Walkthrough and Prerequisites.en.srt 7.30kb

3. Syllabus Walkthrough and Prerequisites.mp4 12.15M

3. Syllabus Walkthrough and Prerequisites.srt 11.47kb

4. Note about SQL Editor.html 0.45kb

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

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

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

5.1 SQL Try-It Editor.html 0.12kb

5.2 Lecture Slides.html 0.11kb

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

7. How The Course Works.en.srt 6.48kb

7. How The Course Works.mp4 22.40M

7. How The Course Works.srt 10.02kb

02. Getting Started Overview and Installation

1. Section Introduction.en.srt 1.94kb

1. Section Introduction.mp4 7.98M

1. Section Introduction.srt 2.99kb

2. What Is a Database.en.srt 10.47kb

2. What Is a Database.mp4 10.27M

2. What Is a Database.srt 16.59kb

2.1 Slides For This Section.html 0.10kb

3. SQL Vs. MySQL.en.srt 8.08kb

3. SQL Vs. MySQL.mp4 7.71M

3. SQL Vs. MySQL.srt 12.65kb

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

4. Installation Overview – WATCH BEFORE INSTALLING.mp4 6.63M

4. Installation Overview – WATCH BEFORE INSTALLING.srt 12.75kb

4.1 Installation Slides.html 0.10kb

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

6. Mac Installation.en.srt 17.73kb

6. Mac Installation.mp4 22.18M

6. Mac Installation.srt 28.05kb

7. CODE Mac Installation.html 1.31kb

8. Windows Installation.en.srt 6.40kb

8. Windows Installation.mp4 5.74M

8. Windows Installation.srt 9.95kb

03. Creating Databases and Tables

1. Section 3 Introduction.en.srt 1.96kb

1. Section 3 Introduction.mp4 9.38M

1. Section 3 Introduction.srt 3.08kb

10. Note about INT max size.html 0.39kb

11. Basic Datatypes Challenge.en.srt 3.73kb

11. Basic Datatypes Challenge.mp4 3.52M

11. Basic Datatypes Challenge.srt 5.96kb

12. Basic Datatypes Challenge – Solution.html 0.18kb

13. Creating Your Own Tables.en.srt 4.08kb

13. Creating Your Own Tables.mp4 3.95M

13. Creating Your Own Tables.srt 6.40kb

14. CODE Creating Your Own Tables.html 0.24kb

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

15. How Do We Know It Worked.mp4 3.52M

15. How Do We Know It Worked.srt 5.92kb

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

17. Dropping Tables.en.srt 2.57kb

17. Dropping Tables.mp4 2.10M

17. Dropping Tables.srt 3.96kb

18. CODE Dropping Tables.html 0.18kb

19. Creating Your Own Tables Challenge.en.srt 6.36kb

19. Creating Your Own Tables Challenge.mp4 6.08M

19. Creating Your Own Tables Challenge.srt 10.03kb

19.1 Slides.html 0.12kb

2. Creating Databases.en.srt 7.44kb

2. Creating Databases.mp4 7.24M

2. Creating Databases.srt 12.02kb

2.1 Slides For This Section!.html 0.11kb

20. CODE Creating Your Own Tables Challenge.html 0.16kb

3. CODE Creating Databases.html 0.38kb

4. Dropping Databases.en.srt 2.65kb

4. Dropping Databases.mp4 2.46M

4. Dropping Databases.srt 4.08kb

5. CODE Dropping Databases.html 0.29kb

6. Using Databases.en.srt 3.91kb

6. Using Databases.mp4 4.40M

6. Using Databases.srt 6.24kb

7. CODE Using Databases.html 0.12kb

8. Introduction to Tables.en.srt 7.70kb

8. Introduction to Tables.mp4 7.12M

8. Introduction to Tables.srt 12.06kb

9. The Basic Datatypes.en.srt 11.33kb

9. The Basic Datatypes.mp4 10.77M

9. The Basic Datatypes.srt 17.92kb

04. Inserting Data (and a couple other things)

1. Section 4 Introduction.en.srt 2.63kb

1. Section 4 Introduction.mp4 10.81M

1. Section 4 Introduction.srt 4.06kb

10. INSERT Challenges Solution.en.srt 4.98kb

10. INSERT Challenges Solution.mp4 7.17M

10. INSERT Challenges Solution.srt 7.70kb

11. CODE INSERT Challenges Solution.html 0.82kb

12. NOTE MySQL Warnings.html 0.52kb

13. MySQL Warnings.en.srt 4.95kb

13. MySQL Warnings.mp4 8.63M

13. MySQL Warnings.srt 7.85kb

14. CODE MySQL Warnings.html 0.62kb

15. NULL and NOT_NULL.en.srt 8.27kb

15. NULL and NOT_NULL.mp4 10.17M

15. NULL and NOT_NULL.srt 13.31kb

16. CODE NULL and NOT NULL.html 1.10kb

17. Setting Default Values.en.srt 8.37kb

17. Setting Default Values.mp4 10.38M

17. Setting Default Values.srt 13.28kb

18. CODE Setting Default Values.html 1.19kb

19. A Primer On Primary Keys.en.srt 16.00kb

19. A Primer On Primary Keys.mp4 18.19M

19. A Primer On Primary Keys.srt 25.25kb

2. Inserting Data.en.srt 7.01kb

2. Inserting Data.mp4 6.69M

2. Inserting Data.srt 11.23kb

2.1 Slides For This Section.html 0.11kb

20. CODE A Primer on Primary Keys.html 1.43kb

21. Table Constraints Exercise.en.srt 3.12kb

21. Table Constraints Exercise.mp4 2.61M

21. Table Constraints Exercise.srt 4.85kb

21.1 Exercise Slides.html 0.11kb

22. Table Constraints Exercise Solution.en.srt 4.52kb

22. Table Constraints Exercise Solution.mp4 7.99M

22. Table Constraints Exercise Solution.srt 6.99kb

23. CODE Table Constraints Exercise Solution.html 0.92kb

3. CODE Inserting Data.html 0.26kb

4. Super Quick Intro To SELECT.en.srt 3.23kb

4. Super Quick Intro To SELECT.mp4 2.95M

4. Super Quick Intro To SELECT.srt 5.08kb

5. CODE Super Quick Intro To SELECT.html 0.04kb

6. Multiple INSERT.en.srt 4.07kb

6. Multiple INSERT.mp4 4.06M

6. Multiple INSERT.srt 6.39kb

7. CODE Multiple Insert.html 0.18kb

8. INSERT Challenges.en.srt 2.25kb

8. INSERT Challenges.mp4 2.18M

8. INSERT Challenges.srt 3.53kb

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

05. CRUD commmands

1. Section 5 Introduction.en.srt 2.57kb

1. Section 5 Introduction.mp4 13.30M

1. Section 5 Introduction.srt 4.02kb

10. SELECT Challenges.en.srt 2.85kb

10. SELECT Challenges.mp4 3.08M

10. SELECT Challenges.srt 4.57kb

11. SELECT Challenges Solution.en.srt 3.61kb

11. SELECT Challenges Solution.mp4 4.08M

11. SELECT Challenges Solution.srt 5.80kb

12. CODE SELECT Challenges Solution.html 0.38kb

13. Introduction to Aliases.en.srt 3.92kb

13. Introduction to Aliases.mp4 3.95M

13. Introduction to Aliases.srt 6.31kb

14. CODE Introduction to Aliases.html 0.19kb

15. The UPDATE Command.en.srt 5.18kb

15. The UPDATE Command.mp4 5.44M

15. The UPDATE Command.srt 8.33kb

16. CODE The UPDATE Command.html 0.28kb

17. UPDATE Challenges.en.srt 0.85kb

17. UPDATE Challenges.mp4 855.66kb

17. UPDATE Challenges.srt 1.32kb

18. UPDATE Challenges Solution.en.srt 4.75kb

18. UPDATE Challenges Solution.mp4 5.65M

18. UPDATE Challenges Solution.srt 7.73kb

19. CODE UPDATE Challenges Solution.html 0.55kb

2. Introduction to CRUD.en.srt 2.59kb

2. Introduction to CRUD.mp4 2.26M

2. Introduction to CRUD.srt 4.08kb

2.1 This Section’s Slides.html 0.11kb

20. Introduction to DELETE.en.srt 6.74kb

20. Introduction to DELETE.mp4 6.17M

20. Introduction to DELETE.srt 10.56kb

21. CODE Introduction to DELETE.html 0.23kb

22. DELETE Challenges.en.srt 1.85kb

22. DELETE Challenges.mp4 1.64M

22. DELETE Challenges.srt 2.81kb

22.1 Slides.html 0.12kb

23. DELETE Challenges Solution.en.srt 3.36kb

23. DELETE Challenges Solution.mp4 4.26M

23. DELETE Challenges Solution.srt 5.43kb

24. CODE DELETE Challenges Solution.html 0.31kb

3. CODE Introduction to CRUD.html 0.07kb

4. Preparing Our Data.en.srt 3.54kb

4. Preparing Our Data.mp4 3.70M

4. Preparing Our Data.srt 5.61kb

5. CODE Preparing Our Data.html 0.79kb

6. Official Introduction to SELECT.en.srt 5.33kb

6. Official Introduction to SELECT.mp4 6.13M

6. Official Introduction to SELECT.srt 8.84kb

7. CODE Official Introduction to SELECT.html 0.56kb

8. Introduction to WHERE.en.srt 7.02kb

8. Introduction to WHERE.mp4 6.82M

8. Introduction to WHERE.srt 11.23kb

9. CODE Introduction to WHERE.html 0.30kb

06. CRUD Challenge Section

1. Section 6 Introduction.en.srt 3.18kb

1. Section 6 Introduction.mp4 14.46M

1. Section 6 Introduction.srt 4.88kb

10. CODE CRUD Exercise Delete Solution.html 0.39kb

2. CRUD Exercise Overview.en.srt 11.34kb

2. CRUD Exercise Overview.mp4 10.62M

2. CRUD Exercise Overview.srt 17.92kb

2.1 Slides.html 0.12kb

3. CRUD Exercise Create Solution.en.srt 7.13kb

3. CRUD Exercise Create Solution.mp4 8.93M

3. CRUD Exercise Create Solution.srt 11.61kb

4. CODE CRUD Exercise Create Solution.html 0.78kb

5. CRUD Exercise Read Solution.en.srt 2.10kb

5. CRUD Exercise Read Solution.mp4 2.89M

5. CRUD Exercise Read Solution.srt 3.38kb

6. CODE CRUD Exercise Read Solution.html 0.19kb

7. CRUD Exercise Update Solution.en.srt 5.09kb

7. CRUD Exercise Update Solution.mp4 6.39M

7. CRUD Exercise Update Solution.srt 8.09kb

8. CODE CRUD Exercise Update Solution.html 0.62kb

9. CRUD Exercise Delete Solution.en.srt 4.24kb

9. CRUD Exercise Delete Solution.mp4 4.88M

9. CRUD Exercise Delete Solution.srt 6.75kb

07. The World Of String Functions

1. Section 7 Introduction.en.srt 3.29kb

1. Section 7 Introduction.mp4 11.20M

1. Section 7 Introduction.srt 5.11kb

10. CODE Introducing SUBSTRING.html 0.79kb

11. Introducing REPLACE.en.srt 8.35kb

11. Introducing REPLACE.mp4 11.46M

11. Introducing REPLACE.srt 13.52kb

12. CODE Introducing REPLACE.html 0.87kb

13. Using REVERSE.en.srt 4.60kb

13. Using REVERSE.mp4 5.38M

13. Using REVERSE.srt 7.22kb

14. CODE Using REVERSE.html 0.24kb

15. Working with CHAR LENGTH.en.srt 6.52kb

15. Working with CHAR LENGTH.mp4 8.32M

15. Working with CHAR LENGTH.srt 10.08kb

16. CODE Working with CHAR LENGTH.html 0.32kb

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

17. Changing Case with UPPER and LOWER.mp4 6.14M

17. Changing Case with UPPER and LOWER.srt 7.26kb

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

19. Note about string functions.html 1.44kb

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

20. String Function Challenges.en.srt 6.59kb

20. String Function Challenges.mp4 7.20M

20. String Function Challenges.srt 10.27kb

20.1 Slides.html 0.12kb

21. String Function Challenges Solution.en.srt 15.54kb

21. String Function Challenges Solution.mp4 24.79M

21. String Function Challenges Solution.srt 24.39kb

22. CODE String Function Challenges Solution.html 1.33kb

3. Running SQL Files.en.srt 13.83kb

3. Running SQL Files.mp4 15.17M

3. Running SQL Files.srt 22.36kb

3.1 Slides For This Section.html 0.11kb

4. CODE Running SQL Files.html 0.39kb

5. Loading Our Book Data.en.srt 7.89kb

5. Loading Our Book Data.mp4 13.04M

5. Loading Our Book Data.srt 12.51kb

5.1 book_data.sql 1.31kb

6. CODE Loading Our Book Data.html 1.67kb

7. Working with CONCAT.en.srt 15.60kb

7. Working with CONCAT.mp4 23.01M

7. Working with CONCAT.srt 24.85kb

8. CODE Working With CONCAT.html 0.92kb

9. Introducing SUBSTRING.en.srt 13.53kb

9. Introducing SUBSTRING.mp4 15.73M

9. Introducing SUBSTRING.srt 21.39kb

08. Refining Our Selections

1. Section 8 Introduction.en.srt 1.05kb

1. Section 8 Introduction.mp4 4.63M

1. Section 8 Introduction.srt 1.58kb

10. Better Searches with LIKE.en.srt 10.44kb

10. Better Searches with LIKE.mp4 10.47M

10. Better Searches with LIKE.srt 16.65kb

11. CODE Better Searches with LIKE.html 0.32kb

12. LIKE Part 2 More Wildcards.en.srt 8.96kb

12. LIKE Part 2 More Wildcards.mp4 9.48M

12. LIKE Part 2 More Wildcards.srt 13.83kb

13. CODE LIKE Part 2 More Wildcards.html 0.38kb

14. Refining Selections Exercises.en.srt 7.07kb

14. Refining Selections Exercises.mp4 7.49M

14. Refining Selections Exercises.srt 11.01kb

14.1 Slides.html 0.12kb

15. Refining Selections Exercises Solution.en.srt 16.47kb

15. Refining Selections Exercises Solution.mp4 24.87M

15. Refining Selections Exercises Solution.srt 25.33kb

16. CODE Refining Selections Exercises Solution.html 0.71kb

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

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

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

2.1 Slides For This Section.html 0.11kb

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

4. Using DISTINCT.en.srt 11.05kb

4. Using DISTINCT.mp4 12.71M

4. Using DISTINCT.srt 17.82kb

5. CODE Using DISTINCT.html 0.28kb

6. Sorting Data with ORDER BY.en.srt 2.24kb

6. Sorting Data with ORDER BY.mp4 19.54M

6. Sorting Data with ORDER BY.srt 3.50kb

7. CODE Sorting Data with ORDER BY.html 0.97kb

8. Using LIMIT.en.srt 13.01kb

8. Using LIMIT.mp4 16.37M

8. Using LIMIT.srt 20.61kb

9. CODE Using LIMIT.html 0.88kb

09. The Magic of Aggregate Functions

1. Section 9 Introduction.en.srt 6.42kb

1. Section 9 Introduction.mp4 17.55M

1. Section 9 Introduction.srt 9.89kb

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

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

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

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

12. The Sum Function.en.srt 5.73kb

12. The Sum Function.mp4 6.38M

12. The Sum Function.srt 9.10kb

13. CODE The Sum Function.html 0.34kb

14. The Avg Function.en.srt 8.39kb

14. The Avg Function.mp4 8.60M

14. The Avg Function.srt 13.19kb

15. CODE The Avg Function.html 0.34kb

16. Aggregate Functions Challenges.en.srt 5.83kb

16. Aggregate Functions Challenges.mp4 5.82M

16. Aggregate Functions Challenges.srt 9.04kb

16.1 Slides.html 0.13kb

17. Aggregate Functions Challenges Solution.en.srt 10.26kb

17. Aggregate Functions Challenges Solution.mp4 14.85M

17. Aggregate Functions Challenges Solution.srt 16.22kb

18. CODE Aggregate Functions Challenges Solution.html 0.82kb

2. The Count Function.en.srt 11.78kb

2. The Count Function.mp4 12.93M

2. The Count Function.srt 18.53kb

2.1 Slides For This Section.html 0.11kb

3. CODE The Count Function.html 0.36kb

4. The Joys of Group By.en.srt 17.05kb

4. The Joys of Group By.mp4 18.86M

4. The Joys of Group By.srt 27.21kb

5. CODE The Joys of Group By.html 0.71kb

6. Min and Max Basics.en.srt 5.18kb

6. Min and Max Basics.mp4 6.44M

6. Min and Max Basics.srt 8.33kb

7. CODE MIN and MAX Basics.html 0.25kb

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

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

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

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

10. Revisiting Data Types

1. Section 10 Introduction.en.srt 3.15kb

1. Section 10 Introduction.mp4 11.20M

1. Section 10 Introduction.srt 4.95kb

10. DATE, TIME, and DATETIME.en.srt 6.13kb

10. DATE, TIME, and DATETIME.mp4 5.47M

10. DATE, TIME, and DATETIME.srt 9.89kb

11. Creating Our DATE data.en.srt 6.61kb

11. Creating Our DATE data.mp4 8.39M

11. Creating Our DATE data.srt 10.27kb

12. CODE Creating Our DATE data.html 0.39kb

13. CURDATE, CURTIME, and NOW.en.srt 7.66kb

13. CURDATE, CURTIME, and NOW.mp4 8.22M

13. CURDATE, CURTIME, and NOW.srt 12.32kb

14. Note about formatting dates.html 0.27kb

15. Formatting Dates.en.srt 17.98kb

15. Formatting Dates.mp4 31.75M

15. Formatting Dates.srt 28.73kb

16. CODE Formatting Dates.html 0.92kb

17. Date Math.en.srt 11.79kb

17. Date Math.mp4 18.52M

17. Date Math.srt 18.65kb

18. CODE Date Math.html 0.58kb

19. Working with TIMESTAMPS.en.srt 15.12kb

19. Working with TIMESTAMPS.mp4 19.04M

19. Working with TIMESTAMPS.srt 23.79kb

2. CHAR and VARCHAR.en.srt 19.52kb

2. CHAR and VARCHAR.mp4 20.62M

2. CHAR and VARCHAR.srt 31.01kb

2.1 Slides For This Section.html 0.11kb

20. CODE Working with TIMESTAMPS.html 0.91kb

21. Data Types Exercises.en.srt 6.46kb

21. Data Types Exercises.mp4 7.01M

21. Data Types Exercises.srt 10.27kb

21.1 Slides.html 0.12kb

22. Data Types Exercises Solution.en.srt 17.64kb

22. Data Types Exercises Solution.mp4 26.43M

22. Data Types Exercises Solution.srt 27.74kb

23. CODE Data Types Exercises Solution.html 1.17kb

3. Note about CHAR and VARCHAR.html 0.35kb

4. CODE CHAR and VARCHAR.html 0.40kb

5. DECIMAL.en.srt 8.08kb

5. DECIMAL.mp4 11.28M

5. DECIMAL.srt 12.58kb

6. CODE DECIMAL.html 0.30kb

7. FLOAT and DOUBLE.en.srt 9.95kb

7. FLOAT and DOUBLE.mp4 11.60M

7. FLOAT and DOUBLE.srt 15.87kb

8. CODE FLOAT and DOUBLE.html 0.29kb

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

11. The Power of Logical Operators

1. Section 11 Introduction.en.srt 4.25kb

1. Section 11 Introduction.mp4 15.71M

1. Section 11 Introduction.srt 6.82kb

10. Logical AND.en.srt 13.40kb

10. Logical AND.mp4 15.48M

10. Logical AND.srt 20.78kb

11. CODE Logical AND.html 1.38kb

12. Logical OR.en.srt 9.13kb

12. Logical OR.mp4 10.69M

12. Logical OR.srt 14.52kb

13. CODE Logical OR.html 1.22kb

14. Between.en.srt 14.38kb

14. Between.mp4 18.24M

14. Between.srt 22.78kb

15. CODE Between.html 0.62kb

16. In And Not In.en.srt 15.24kb

16. In And Not In.mp4 21.91M

16. In And Not In.srt 23.97kb

17. CODE In And Not In.html 1.16kb

18. Case Statements.en.srt 15.91kb

18. Case Statements.mp4 21.04M

18. Case Statements.srt 25.05kb

19. CODE Case Statements.html 1.01kb

2. Not Equal.en.srt 5.70kb

2. Not Equal.mp4 7.68M

2. Not Equal.srt 9.11kb

2.1 Slides For This Section.html 0.11kb

20. Logical Operators Exercises.en.srt 9.83kb

20. Logical Operators Exercises.mp4 10.84M

20. Logical Operators Exercises.srt 15.56kb

20.1 Slides.html 0.12kb

21. Logical Operators Exercises Solution.en.srt 22.42kb

21. Logical Operators Exercises Solution.mp4 33.28M

21. Logical Operators Exercises Solution.srt 35.13kb

22. CODE Logical Operators Exercises Solution.html 1.41kb

3. CODE Not Equal.html 0.32kb

4. Not Like.en.srt 3.59kb

4. Not Like.mp4 3.77M

4. Not Like.srt 5.72kb

5. CODE Not Like.html 0.28kb

6. Greater Than.en.srt 14.04kb

6. Greater Than.mp4 16.40M

6. Greater Than.srt 21.55kb

7. CODE Greater Than.html 0.79kb

8. Less Than.en.srt 5.22kb

8. Less Than.mp4 6.06M

8. Less Than.srt 8.13kb

9. CODE Less Than.html 0.36kb

12. Section 12 One To Many

1. Section 12 Introduction.en.srt 2.95kb

1. Section 12 Introduction.mp4 13.30M

1. Section 12 Introduction.srt 4.70kb

10. CODE Inner Joins.html 1.13kb

11. Left Join.en.srt 22.37kb

11. Left Join.mp4 28.38M

11. Left Join.srt 35.41kb

12. CODE Left Joins.html 1.22kb

13. Right Joins Pt 1.en.srt 14.37kb

13. Right Joins Pt 1.mp4 20.32M

13. Right Joins Pt 1.srt 22.59kb

14. CODE Right Joins Part 1.html 1.56kb

15. Right Joins Pt 2.en.srt 12.81kb

15. Right Joins Pt 2.mp4 20.59M

15. Right Joins Pt 2.srt 20.18kb

16. CODE Right Joins Part 2.html 1.52kb

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

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

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

18. CODE Right and Left Joins FAQ.html 0.71kb

19. Our First Joins Exercise.en.srt 10.19kb

19. Our First Joins Exercise.mp4 11.62M

19. Our First Joins Exercise.srt 16.05kb

19.1 Slides.html 0.11kb

2. Real World Data Is Messy.en.srt 16.31kb

2. Real World Data Is Messy.mp4 14.14M

2. Real World Data Is Messy.srt 25.76kb

2.1 Slides For This Section.html 0.11kb

20. Our First Joins Exercise SOLUTION.en.srt 11.90kb

20. Our First Joins Exercise SOLUTION.mp4 18.65M

20. Our First Joins Exercise SOLUTION.srt 18.53kb

21. CODE Our First Joins Exercise.html 0.78kb

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

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

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

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

3. Types of Data Relationships.en.srt 6.70kb

3. Types of Data Relationships.mp4 6.20M

3. Types of Data Relationships.srt 10.36kb

4. One To Many The Basics.en.srt 18.45kb

4. One To Many The Basics.mp4 19.03M

4. One To Many The Basics.srt 28.98kb

5. Working With Foreign Keys.en.srt 16.81kb

5. Working With Foreign Keys.mp4 22.68M

5. Working With Foreign Keys.srt 26.42kb

6. CODE Working With Foreign Keys.html 1.30kb

7. Cross Join.en.srt 10.49kb

7. Cross Join.mp4 14.49M

7. Cross Join.srt 16.47kb

8. CODE Cross Joins.html 0.56kb

9. Inner Join.en.srt 16.17kb

9. Inner Join.mp4 27.58M

9. Inner Join.srt 25.59kb

13. Section 13 Many To Many

1. Section 13 Introduction.en.srt 2.96kb

1. Section 13 Introduction.mp4 12.99M

1. Section 13 Introduction.srt 4.58kb

10. CODE TV Joins Challenge 3 SOLUTION.html 0.39kb

11. TV Joins Challenge 4.en.srt 7.87kb

11. TV Joins Challenge 4.mp4 12.33M

11. TV Joins Challenge 4.srt 12.61kb

12. CODE TV Joins Challenge 4 SOLUTION.html 0.22kb

13. TV Joins Challenge 5.en.srt 6.65kb

13. TV Joins Challenge 5.mp4 9.63M

13. TV Joins Challenge 5.srt 10.41kb

14. CODE TV Joins Challenge 5 SOLUTION.html 0.26kb

15. TV Joins Challenge 6.en.srt 15.54kb

15. TV Joins Challenge 6.mp4 23.35M

15. TV Joins Challenge 6.srt 24.61kb

16. CODE TV Joins Challenge 6 SOLUTION.html 1.26kb

17. TV Joins Challenge 7.en.srt 9.13kb

17. TV Joins Challenge 7.mp4 15.50M

17. TV Joins Challenge 7.srt 14.68kb

18. CODE TV Joins Challenge 7 SOLUTION.html 0.31kb

2. Many To Many Basics.en.srt 15.26kb

2. Many To Many Basics.mp4 14.22M

2. Many To Many Basics.srt 24.41kb

2.1 Slides.html 0.11kb

3. Creating Our Tables.en.srt 14.41kb

3. Creating Our Tables.mp4 21.84M

3. Creating Our Tables.srt 22.49kb

4. CODE Creating Our Tables.html 2.37kb

5. TV Joins Challenge 1.en.srt 6.24kb

5. TV Joins Challenge 1.mp4 11.79M

5. TV Joins Challenge 1.srt 9.83kb

6. CODE TV Joins Challenge 1 Solution.html 0.20kb

7. TV Joins Challenge 2.en.srt 8.89kb

7. TV Joins Challenge 2.mp4 13.25M

7. TV Joins Challenge 2.srt 13.97kb

8. CODE TV Joins Challenge 2 SOLUTION.html 0.23kb

9. TV Joins Challenge 3.en.srt 6.58kb

9. TV Joins Challenge 3.mp4 11.45M

9. TV Joins Challenge 3.srt 10.43kb

14. Instagram Database Clone

1. Section 14 Introduction.en.srt 2.06kb

1. Section 14 Introduction.mp4 9.48M

1. Section 14 Introduction.srt 3.25kb

10. CODE IG Clone Likes Schema.html 0.29kb

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

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

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

12. CODE IG Clone Followers Schema.html 0.31kb

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

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

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

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

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

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

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

16. CODE IG Clone Hashtags Schema.html 0.38kb

17. CODE Complete IG Clone Schema.html 1.57kb

2. Introduction To Instagram Clone Schema.en.srt 13.41kb

2. Introduction To Instagram Clone Schema.mp4 21.73M

2. Introduction To Instagram Clone Schema.srt 21.05kb

2.1 Slides For This Section.html 0.11kb

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

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

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

4. CODE IG Clone Users Schema.html 0.18kb

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

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

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

6. CODE IG Clone Photos Schema.html 0.25kb

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

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

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

8. CODE IG Clone Comments Schema.html 0.34kb

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

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

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

15. Working With Lots Of Instagram Data

1. Section 15 Introduction.en.srt 2.68kb

1. Section 15 Introduction.mp4 11.26M

1. Section 15 Introduction.srt 4.24kb

10. Instagram Challenge 3 Solution CODE.html 0.21kb

11. Instagram Clone Challenge 4.en.srt 9.27kb

11. Instagram Clone Challenge 4.mp4 15.84M

11. Instagram Clone Challenge 4.srt 14.69kb

12. Instagram Challenge 4 Solution CODE.html 0.36kb

13. Instagram Clone Challenge 5.en.srt 4.52kb

13. Instagram Clone Challenge 5.mp4 5.40M

13. Instagram Clone Challenge 5.srt 7.07kb

14. Instagram Challenge 5 Solution CODE.html 0.23kb

15. Instagram Clone Challenge 6.en.srt 6.57kb

15. Instagram Clone Challenge 6.mp4 11.74M

15. Instagram Clone Challenge 6.srt 10.57kb

16. Instagram Challenge 6 Solution CODE.html 0.33kb

17. Note about Instagram Clone Challenge 7.html 0.38kb

18. Instagram Clone Challenge 7.en.srt 7.04kb

18. Instagram Clone Challenge 7.mp4 10.97M

18. Instagram Clone Challenge 7.srt 11.27kb

19. Instagram Challenge 7 Solution CODE.html 0.35kb

2. Note about Loading The JUMBO dataset.html 0.73kb

3. Loading The JUMBO dataset.en.srt 12.48kb

3. Loading The JUMBO dataset.mp4 59.24M

3. Loading The JUMBO dataset.srt 19.99kb

4. The Instagram Clone DATASET.html 0.37kb

4.1 ig_clone_data.sql 429.36kb

5. Instagram Clone Challenge 1.en.srt 6.89kb

5. Instagram Clone Challenge 1.mp4 8.62M

5. Instagram Clone Challenge 1.srt 11.01kb

5.1 Slides.html 0.11kb

6. Instagram Challenge 1 Solution CODE.html 0.12kb

7. Instagram Clone Challenge 2.en.srt 10.07kb

7. Instagram Clone Challenge 2.mp4 11.71M

7. Instagram Clone Challenge 2.srt 15.96kb

8. Instagram Challenge 2 Solution CODE.html 0.21kb

9. Instagram Clone Challenge 3.en.srt 10.84kb

9. Instagram Clone Challenge 3.mp4 17.26M

9. Instagram Clone Challenge 3.srt 17.70kb

16. Section 16 – Introducing Node

1. Note about Introducing Node.html 0.34kb

10. Introduction to NPM and Faker.en.srt 12.55kb

10. Introduction to NPM and Faker.mp4 15.89M

10. Introduction to NPM and Faker.srt 20.09kb

10.1 FakerJS Github Repo.html 0.09kb

11. CODE Introduction to NPM and Faker.html 1.21kb

12. Introducing the MySQL Package.en.srt 7.70kb

12. Introducing the MySQL Package.mp4 6.91M

12. Introducing the MySQL Package.srt 12.09kb

12.1 MySQL Node Package Github Repo.html 0.09kb

13. Note about connecting Node to MySQL.html 3.70kb

14. Connecting Node to MySQL.en.srt 18.11kb

14. Connecting Node to MySQL.mp4 23.06M

14. Connecting Node to MySQL.srt 28.86kb

15. CODE Connecting Node to MySQL.html 2.48kb

16. Creating Our Users Table.en.srt 10.64kb

16. Creating Our Users Table.mp4 13.99M

16. Creating Our Users Table.srt 16.98kb

17. CODE Creating Our Users Table.html 0.18kb

18. Selecting Using Node.en.srt 8.91kb

18. Selecting Using Node.mp4 11.35M

18. Selecting Using Node.srt 14.22kb

19. CODE Selecting Using Node.html 0.92kb

2. Section 16 Introduction.en.srt 2.65kb

2. Section 16 Introduction.mp4 13.13M

2. Section 16 Introduction.srt 4.23kb

20. Inserting Using Node.en.srt 16.42kb

20. Inserting Using Node.mp4 21.92M

20. Inserting Using Node.srt 26.25kb

21. CODE Inserting Using Node.html 0.71kb

22. Some MySQLNode Magic.en.srt 10.77kb

22. Some MySQLNode Magic.mp4 17.87M

22. Some MySQLNode Magic.srt 17.09kb

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

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

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

24. CODE Bulk Inserting 500 Users.html 0.56kb

25. 500 Users Exercises.en.srt 3.92kb

25. 500 Users Exercises.mp4 3.45M

25. 500 Users Exercises.srt 6.06kb

25.1 Slides.html 0.11kb

26. 500 Users Exercises Solutions.en.srt 15.04kb

26. 500 Users Exercises Solutions.mp4 21.87M

26. 500 Users Exercises Solutions.srt 23.68kb

27. CODE 500 Users Exercises Solutions.html 1.29kb

3. MySQL and Other Languages.en.srt 14.70kb

3. MySQL and Other Languages.mp4 11.16M

3. MySQL and Other Languages.srt 23.20kb

3.1 Slides For This Section.html 0.11kb

4. BUT WHAT ABOUT PHP.en.srt 11.67kb

4. BUT WHAT ABOUT PHP.mp4 15.16M

4. BUT WHAT ABOUT PHP.srt 18.06kb

5. Introduction to JOIN US app.en.srt 12.70kb

5. Introduction to JOIN US app.mp4 11.94M

5. Introduction to JOIN US app.srt 20.54kb

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

7. 5 Minute NodeJS Crash Course.en.srt 9.15kb

7. 5 Minute NodeJS Crash Course.mp4 9.35M

7. 5 Minute NodeJS Crash Course.srt 14.62kb

8. CODE 5 Minute Node Crash Course.html 0.27kb

9. Note about Faker install.html 2.16kb

17. Section 17 – Building Our Web App

1. Section 17 Introduction.en.srt 3.10kb

1. Section 17 Introduction.mp4 11.74M

1. Section 17 Introduction.srt 4.98kb

10. Connecting Express and MySQL.en.srt 15.40kb

10. Connecting Express and MySQL.mp4 20.78M

10. Connecting Express and MySQL.srt 24.60kb

11. CODE Connecting Express and MySQL.html 0.36kb

12. Adding EJS Templates.en.srt 24.38kb

12. Adding EJS Templates.mp4 30.46M

12. Adding EJS Templates.srt 38.61kb

13. CODE Adding EJS Templates.html 0.62kb

14. Connecting The Form.en.srt 26.90kb

14. Connecting The Form.mp4 36.23M

14. Connecting The Form.srt 42.98kb

15. CODE Connecting the Form.html 0.34kb

16. Styling Part 1.en.srt 12.16kb

16. Styling Part 1.mp4 17.98M

16. Styling Part 1.srt 19.21kb

17. CODE HTML AND CSS FILES.html 0.11kb

17.1 JOIN_US_HTML_AND_CSS.zip 2.70kb

18. Styling Part 2.en.srt 11.88kb

18. Styling Part 2.mp4 18.37M

18. Styling Part 2.srt 19.00kb

2. Join Us Completed CODE.html 0.33kb

2.1 JoinUsCompleteCode.zip 3.75M

3. Introducing Express.en.srt 9.51kb

3. Introducing Express.mp4 9.54M

3. Introducing Express.srt 15.09kb

3.1 Slides.html 0.11kb

3.2 Express Documentation.html 0.08kb

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

4. NPM Init and package.json files.mp4 11.60M

4. NPM Init and package.json files.srt 15.94kb

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

6. Our First Simple Web App.en.srt 24.76kb

6. Our First Simple Web App.mp4 28.19M

6. Our First Simple Web App.srt 39.85kb

7. CODE Our First Simple Web App.html 0.40kb

8. Adding Multiple Routes.en.srt 14.65kb

8. Adding Multiple Routes.mp4 18.67M

8. Adding Multiple Routes.srt 23.60kb

9. CODE Adding Multiple Routes.html 0.46kb

18. Section 18 – Database Triggers

1. Introduction to Database Triggers.en.srt 9.88kb

1. Introduction to Database Triggers.mp4 27.62M

1. Introduction to Database Triggers.srt 15.45kb

1.1 Lecture Slides.html 0.12kb

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

2. Writing Our First Trigger Part 1.mp4 11.34M

2. Writing Our First Trigger Part 1.srt 16.69kb

2.1 Lecture Slides.html 0.12kb

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

3. Writing Our First Trigger Part 2.mp4 22.78M

3. Writing Our First Trigger Part 2.srt 26.98kb

3.1 Lecture Slides.html 0.12kb

4. Note about next lecture.html 0.55kb

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

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

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

5.1 Lecture Slides.html 0.12kb

6. Creating Logger Triggers.en.srt 13.80kb

6. Creating Logger Triggers.mp4 18.63M

6. Creating Logger Triggers.srt 21.72kb

6.1 Lecture Slides.html 0.12kb

7. Managing Triggers And A Warning.en.srt 9.29kb

7. Managing Triggers And A Warning.mp4 12.55M

7. Managing Triggers And A Warning.srt 14.54kb

7.1 Lecture Slides.html 0.12kb

01.SQL简介和5分钟

1.课程介绍。en.srt 2.18kb

1.课程介绍.mp4 5.81M

1.课程介绍。srt 3.38kb

2.讲师介绍。en.srt 2.61kb

2.讲师介绍。mp4 8.43M

2.讲师介绍.srt 4.00kb

3.教学大纲演练和先决条件.srt 7.30kb

3.教学大纲演练和先决条件。mp4 12.15M

3.教学大纲演练和先决条件srt 11.47kb

4.关于SQL Editor.html 0.45kb的说明

5.SQL的前5分钟-让我们开始编码吧！。en.srt 10.59kb

5.SQL的前5分钟-让我们开始编码吧！。mp4 1832M

5.SQL的前5分钟-让我们开始编码吧！。srt 16.89kb

5.1 SQL Try-It Editor.html 0.12kb

5.2讲座幻灯片.html 0.11kb

6.编写SQL.html 1.57kb的前5分钟代码

7.课程运作方式.en.srt 6.48kb

7.课程如何运作.mp4 22.40M

7.课程如何运作.srt 10.02kb

02.入门概述和安装

1.简介部分en.srt 1.94kb

1.章节简介.mp47.98M

1.章节简介.srt 2.99kb

2.什么是数据库.en.srt 10.47kb

2.什么是数据库.mp4 10.27M

2.什么是数据库.srt 16.59kb

2.1本节幻灯片.html 0.10kb

3.SQL与MySQL.en.srt之比8.08kb

3.SQL与MySQL.mp4 7.71M

3.SQL与MySQL.srt之比12.65kb

4.安装概述-安装前观看.en.srt 8.19kb

4.安装概述-安装前观看.mp4 6.63M

4.安装概述-安装前注意。启动12.75kb

4.1安装幻灯片.html 0.10kb

5.Cloud9注册重要事项-请阅读！！！。html 2.06kb

6.Mac安装.en.srt 17.73kb

6.Mac安装.mp4 2218M

6.Mac安装.srt 28.05kb

7.代码Mac安装.html 1.31kb

8.Windows安装.en.srt 6.40kb

8.Windows安装.mp4 5.74M

8.Windows安装启动9.95kb

03.创建数据库和表

1.第3节简介en.srt 1.96kb

1.第3节简介.mp4 9.38M

1.第3节简介srt 3.08kb

10.关于INT max size.html 0.39kb的说明

11.基本数据类型Challenge.en.start 3.73kb

11.基本数据类型Challenge.mp4 3.52M

11.基本数据类型Challenge.srt 5.96kb

12.基础数据类型挑战-解决方案.html 0.18kb

13.创建自己的表格.en.start 4.08kb

13.创建自己的表格.mp4 3.95M

13.创建自己的表格。srt 6.40kb

14.代码创建自己的表格.html 0.24kb

15.我们怎么知道它有效。en.srt 3.80kb

15.我们怎么知道它有效。mp4 352M

15.我们怎么知道它有效

16.编码我们如何知道它有效.html 0.10kb

17.跌落式桌子.en.srt 2.57kb

17.升降台.mp4 2.10M

17.升降台。srt 3.96kb

18.代码删除表.html 0.18kb

19.创建自己的表格挑战.en.start 6.36kb

19.创建自己的表格挑战。mp4 6.08M

19.创建自己的表格挑战。srt 10.03kb

19.1幻灯片.html 0.12kb

2.创建数据库.en.start 7.44kb

2.创建数据库.mp4 7.24M

2.创建数据库.srt 12.02kb

2.1本节幻灯片！。html 0.11kb

20.CODE创建自己的表格Challenge.html 0.16kb

3.代码创建数据库.html 0.38kb

4.删除数据库.en.srt 2.65kb

4.删除数据库.mp4246万

4.删除数据库.srt 4.08kb

5.代码删除数据库.html 0.29kb

6.使用Databases.en.srt 3.91kb

6.使用数据库.mp4.40M

6.使用数据库.srt 6.24kb

7.使用数据库编码.html 0.12kb

8.Tables.en.srt简介7.70kb

8.表格简介.mp4 7.12M

8.Tables.srt 12.06kb简介

9.基本数据类型.en.start 11.33kb

9.基本数据类型.mp4 10.77M

9.基本数据类型.srt 17.92kb