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