|
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.
|
| [CourseClub.ME].url |
122B |
| [FCS Forum].url |
133B |
| [FreeCourseSite.com].url |
127B |
| 1.1 Lecture Slides.html |
121B |
| 1. Course Introduction.mp4 |
5.82MB |
| 1. Course Introduction.srt |
2.18KB |
| 1. Introduction to Database Triggers.mp4 |
27.62MB |
| 1. Introduction to Database Triggers.srt |
9.88KB |
| 1. Note about Introducing Node.html |
353B |
| 1. Section 10 Introduction.mp4 |
11.21MB |
| 1. Section 10 Introduction.srt |
3.15KB |
| 1. Section 11 Introduction.mp4 |
15.71MB |
| 1. Section 11 Introduction.srt |
4.25KB |
| 1. Section 12 Introduction.mp4 |
13.29MB |
| 1. Section 12 Introduction.srt |
2.95KB |
| 1. Section 13 Introduction.mp4 |
12.99MB |
| 1. Section 13 Introduction.srt |
2.96KB |
| 1. Section 14 Introduction.mp4 |
9.47MB |
| 1. Section 14 Introduction.srt |
2.06KB |
| 1. Section 15 Introduction.mp4 |
11.26MB |
| 1. Section 15 Introduction.srt |
2.68KB |
| 1. Section 17 Introduction.mp4 |
11.73MB |
| 1. Section 17 Introduction.srt |
3.10KB |
| 1. Section 3 Introduction.mp4 |
9.38MB |
| 1. Section 3 Introduction.srt |
1.96KB |
| 1. Section 4 Introduction.mp4 |
10.81MB |
| 1. Section 4 Introduction.srt |
2.63KB |
| 1. Section 5 Introduction.mp4 |
13.30MB |
| 1. Section 5 Introduction.srt |
2.57KB |
| 1. Section 6 Introduction.mp4 |
14.47MB |
| 1. Section 6 Introduction.srt |
3.18KB |
| 1. Section 7 Introduction.mp4 |
11.20MB |
| 1. Section 7 Introduction.srt |
3.29KB |
| 1. Section 8 Introduction.mp4 |
4.63MB |
| 1. Section 8 Introduction.srt |
1.05KB |
| 1. Section 9 Introduction.mp4 |
17.56MB |
| 1. Section 9 Introduction.srt |
6.42KB |
| 1. Section Introduction.mp4 |
7.98MB |
| 1. Section Introduction.srt |
1.94KB |
| 10.1 FakerJS Github Repo.html |
95B |
| 10. Better Searches with LIKE.mp4 |
10.47MB |
| 10. Better Searches with LIKE.srt |
10.44KB |
| 10. CODE CRUD Exercise Delete Solution.html |
402B |
| 10. CODE IG Clone Likes Schema.html |
295B |
| 10. CODE Inner Joins.html |
1.13KB |
| 10. CODE Introducing SUBSTRING.html |
808B |
| 10. CODE TV Joins Challenge 3 SOLUTION.html |
397B |
| 10. Connecting Express and MySQL.mp4 |
20.79MB |
| 10. Connecting Express and MySQL.srt |
15.40KB |
| 10. DATE, TIME, and DATETIME.mp4 |
5.47MB |
| 10. DATE, TIME, and DATETIME.srt |
6.13KB |
| 10. INSERT Challenges Solution.mp4 |
7.17MB |
| 10. INSERT Challenges Solution.srt |
4.98KB |
| 10. Instagram Challenge 3 Solution CODE.html |
219B |
| 10. Introduction to NPM and Faker.mp4 |
15.89MB |
| 10. Introduction to NPM and Faker.srt |
12.55KB |
| 10. Logical AND.mp4 |
15.48MB |
| 10. Logical AND.srt |
13.40KB |
| 10. Note about INT max size.html |
401B |
| 10. SELECT Challenges.mp4 |
3.08MB |
| 10. SELECT Challenges.srt |
2.85KB |
| 10. Using Min and Max with Group By.mp4 |
10.36MB |
| 10. Using Min and Max with Group By.srt |
8.51KB |
| 11. Basic Datatypes Challenge.mp4 |
3.53MB |
| 11. Basic Datatypes Challenge.srt |
3.73KB |
| 11. Cloning Instagram's DB Followers Schema.mp4 |
12.66MB |
| 11. Cloning Instagram's DB Followers Schema.srt |
9.98KB |
| 11. CODE Better Searches with LIKE.html |
331B |
| 11. CODE Connecting Express and MySQL.html |
372B |
| 11. CODE INSERT Challenges Solution.html |
839B |
| 11. CODE Introduction to NPM and Faker.html |
1.21KB |
| 11. CODE Logical AND.html |
1.38KB |
| 11. CODE Using Min and Max with Group By.html |
432B |
| 11. Creating Our DATE data.mp4 |
8.40MB |
| 11. Creating Our DATE data.srt |
6.61KB |
| 11. Instagram Clone Challenge 4.mp4 |
15.83MB |
| 11. Instagram Clone Challenge 4.srt |
9.27KB |
| 11. Introducing REPLACE.mp4 |
11.46MB |
| 11. Introducing REPLACE.srt |
8.35KB |
| 11. Left Join.mp4 |
28.39MB |
| 11. Left Join.srt |
22.37KB |
| 11. SELECT Challenges Solution.mp4 |
4.08MB |
| 11. SELECT Challenges Solution.srt |
3.61KB |
| 11. TV Joins Challenge 4.mp4 |
12.34MB |
| 11. TV Joins Challenge 4.srt |
7.87KB |
| 12.1 MySQL Node Package Github Repo.html |
93B |
| 12. Adding EJS Templates.mp4 |
30.46MB |
| 12. Adding EJS Templates.srt |
24.38KB |
| 12. Basic Datatypes Challenge - Solution.html |
183B |
| 12. CODE Creating Our DATE data.html |
401B |
| 12. CODE IG Clone Followers Schema.html |
317B |
| 12. CODE Introducing REPLACE.html |
887B |
| 12. CODE Left Joins.html |
1.22KB |
| 12. CODE SELECT Challenges Solution.html |
385B |
| 12. CODE TV Joins Challenge 4 SOLUTION.html |
222B |
| 12. Instagram Challenge 4 Solution CODE.html |
371B |
| 12. Introducing the MySQL Package.mp4 |
6.92MB |
| 12. Introducing the MySQL Package.srt |
7.70KB |
| 12. LIKE Part 2 More Wildcards.mp4 |
9.48MB |
| 12. LIKE Part 2 More Wildcards.srt |
8.96KB |
| 12. Logical OR.mp4 |
10.69MB |
| 12. Logical OR.srt |
9.13KB |
| 12. NOTE MySQL Warnings.html |
532B |
| 12. The Sum Function.mp4 |
6.39MB |
| 12. The Sum Function.srt |
5.73KB |
| 13. CODE Adding EJS Templates.html |
633B |
| 13. CODE LIKE Part 2 More Wildcards.html |
388B |
| 13. CODE Logical OR.html |
1.22KB |
| 13. CODE The Sum Function.html |
350B |
| 13. Creating Your Own Tables.mp4 |
3.95MB |
| 13. Creating Your Own Tables.srt |
4.08KB |
| 13. CURDATE, CURTIME, and NOW.mp4 |
8.21MB |
| 13. CURDATE, CURTIME, and NOW.srt |
7.66KB |
| 13. Instagram Clone Challenge 5.mp4 |
5.41MB |
| 13. Instagram Clone Challenge 5.srt |
4.52KB |
| 13. Introduction to Aliases.mp4 |
3.95MB |
| 13. Introduction to Aliases.srt |
3.92KB |
| 13. MySQL Warnings.mp4 |
8.62MB |
| 13. MySQL Warnings.srt |
4.95KB |
| 13. Note about Cloning Instagram's DB Hashtags Part 1.html |
402B |
| 13. Note about connecting Node to MySQL.html |
3.70KB |
| 13. Right Joins Pt 1.mp4 |
20.32MB |
| 13. Right Joins Pt 1.srt |
14.37KB |
| 13. TV Joins Challenge 5.mp4 |
9.64MB |
| 13. TV Joins Challenge 5.srt |
6.65KB |
| 13. Using REVERSE.mp4 |
5.39MB |
| 13. Using REVERSE.srt |
4.60KB |
| 14.1 Slides.html |
128B |
| 14. Between.mp4 |
18.25MB |
| 14. Between.srt |
14.38KB |
| 14. Cloning Instagram's DB Hashtags Part 1.mp4 |
21.84MB |
| 14. Cloning Instagram's DB Hashtags Part 1.srt |
14.96KB |
| 14. CODE Creating Your Own Tables.html |
247B |
| 14. CODE Introduction to Aliases.html |
198B |
| 14. CODE MySQL Warnings.html |
637B |
| 14. CODE Right Joins Part 1.html |
1.56KB |
| 14. CODE TV Joins Challenge 5 SOLUTION.html |
267B |
| 14. CODE Using REVERSE.html |
247B |
| 14. Connecting Node to MySQL.mp4 |
23.06MB |
| 14. Connecting Node to MySQL.srt |
18.11KB |
| 14. Connecting The Form.mp4 |
36.22MB |
| 14. Connecting The Form.srt |
26.90KB |
| 14. Instagram Challenge 5 Solution CODE.html |
232B |
| 14. Note about formatting dates.html |
277B |
| 14. Refining Selections Exercises.mp4 |
7.50MB |
| 14. Refining Selections Exercises.srt |
2.02MB |
| 14. The Avg Function.mp4 |
8.61MB |
| 14. The Avg Function.srt |
8.39KB |
| 15. Cloning Instagram's DB Hashtags Part 2.mp4 |
11.77MB |
| 15. Cloning Instagram's DB Hashtags Part 2.srt |
6.98KB |
| 15. CODE Between.html |
640B |
| 15. CODE Connecting Node to MySQL.html |
2.48KB |
| 15. CODE Connecting the Form.html |
352B |
| 15. CODE The Avg Function.html |
350B |
| 15. Formatting Dates.mp4 |
31.74MB |
| 15. Formatting Dates.srt |
17.98KB |
| 15. How Do We Know It Worked.mp4 |
3.52MB |
| 15. How Do We Know It Worked.srt |
3.80KB |
| 15. Instagram Clone Challenge 6.mp4 |
11.74MB |
| 15. Instagram Clone Challenge 6.srt |
6.57KB |
| 15. NULL and NOT_NULL.mp4 |
10.16MB |
| 15. NULL and NOT_NULL.srt |
8.27KB |
| 15. Refining Selections Exercises Solution.mp4 |
24.87MB |
| 15. Refining Selections Exercises Solution.srt |
16.47KB |
| 15. Right Joins Pt 2.mp4 |
20.59MB |
| 15. Right Joins Pt 2.srt |
12.81KB |
| 15. The UPDATE Command.mp4 |
5.43MB |
| 15. The UPDATE Command.srt |
5.18KB |
| 15. TV Joins Challenge 6.mp4 |
23.34MB |
| 15. TV Joins Challenge 6.srt |
15.54KB |
| 15. Working with CHAR LENGTH.mp4 |
8.31MB |
| 15. Working with CHAR LENGTH.srt |
6.52KB |
| 16.1 Slides.html |
129B |
| 16. Aggregate Functions Challenges.mp4 |
5.83MB |
| 16. Aggregate Functions Challenges.srt |
5.83KB |
| 16. CODE Formatting Dates.html |
947B |
| 16. CODE How Do We Know It Worked.html |
99B |
| 16. CODE IG Clone Hashtags Schema.html |
389B |
| 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.52KB |
| 16. CODE The UPDATE Command.html |
284B |
| 16. CODE TV Joins Challenge 6 SOLUTION.html |
1.26KB |
| 16. CODE Working with CHAR LENGTH.html |
325B |
| 16. Creating Our Users Table.mp4 |
13.99MB |
| 16. Creating Our Users Table.srt |
10.64KB |
| 16. In And Not In.mp4 |
21.92MB |
| 16. In And Not In.srt |
15.24KB |
| 16. Instagram Challenge 6 Solution CODE.html |
341B |
| 16. Styling Part 1.mp4 |
17.98MB |
| 16. Styling Part 1.srt |
12.16KB |
| 17.1 JOIN_US_HTML_AND_CSS.zip |
2.70KB |
| 17. Aggregate Functions Challenges Solution.mp4 |
14.85MB |
| 17. Aggregate Functions Challenges Solution.srt |
10.26KB |
| 17. Changing Case with UPPER and LOWER.mp4 |
6.13MB |
| 17. Changing Case with UPPER and LOWER.srt |
4.61KB |
| 17. CODE Complete IG Clone Schema.html |
1.57KB |
| 17. CODE Creating Our Users Table.html |
186B |
| 17. CODE HTML AND CSS FILES.html |
117B |
| 17. CODE In And Not In.html |
1.16KB |
| 17. Date Math.mp4 |
18.53MB |
| 17. Date Math.srt |
11.79KB |
| 17. Dropping Tables.mp4 |
2.09MB |
| 17. Dropping Tables.srt |
2.57KB |
| 17. Note about Instagram Clone Challenge 7.html |
388B |
| 17. Right and Left Joins A Common Question.mp4 |
7.93MB |
| 17. Right and Left Joins A Common Question.srt |
4.13KB |
| 17. Setting Default Values.mp4 |
10.39MB |
| 17. Setting Default Values.srt |
8.37KB |
| 17. TV Joins Challenge 7.mp4 |
15.49MB |
| 17. TV Joins Challenge 7.srt |
9.13KB |
| 17. UPDATE Challenges.mp4 |
855.66KB |
| 17. UPDATE Challenges.srt |
870B |
| 18. Case Statements.mp4 |
21.05MB |
| 18. Case Statements.srt |
15.91KB |
| 18. CODE Aggregate Functions Challenges Solution.html |
841B |
| 18. CODE Changing Case with UPPER and LOWER.html |
261B |
| 18. CODE Date Math.html |
596B |
| 18. CODE Dropping Tables.html |
181B |
| 18. CODE Right and Left Joins FAQ.html |
725B |
| 18. CODE Setting Default Values.html |
1.19KB |
| 18. CODE TV Joins Challenge 7 SOLUTION.html |
320B |
| 18. Instagram Clone Challenge 7.mp4 |
10.98MB |
| 18. Instagram Clone Challenge 7.srt |
7.04KB |
| 18. Selecting Using Node.mp4 |
11.35MB |
| 18. Selecting Using Node.srt |
8.91KB |
| 18. Styling Part 2.mp4 |
18.37MB |
| 18. Styling Part 2.srt |
11.88KB |
| 18. UPDATE Challenges Solution.mp4 |
5.66MB |
| 18. UPDATE Challenges Solution.srt |
4.75KB |
| 19.1 Slides.html |
113B |
| 19.1 Slides.html |
127B |
| 19. A Primer On Primary Keys.mp4 |
18.18MB |
| 19. A Primer On Primary Keys.srt |
16.00KB |
| 19. CODE Case Statements.html |
1.01KB |
| 19. CODE Selecting Using Node.html |
940B |
| 19. CODE UPDATE Challenges Solution.html |
561B |
| 19. Creating Your Own Tables Challenge.mp4 |
6.07MB |
| 19. Creating Your Own Tables Challenge.srt |
6.36KB |
| 19. Instagram Challenge 7 Solution CODE.html |
360B |
| 19. Note about string functions.html |
1.44KB |
| 19. Our First Joins Exercise.mp4 |
11.63MB |
| 19. Our First Joins Exercise.srt |
10.19KB |
| 19. Working with TIMESTAMPS.mp4 |
19.05MB |
| 19. Working with TIMESTAMPS.srt |
15.12KB |
| 2.1 JoinUsCompleteCode.zip |
3.76MB |
| 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 |
104B |
| 2.1 Slides For This Section.html |
112B |
| 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.srt |
19.52KB |
| 2. Creating Databases.mp4 |
7.25MB |
| 2. Creating Databases.srt |
7.44KB |
| 2. CRUD Exercise Overview.mp4 |
10.61MB |
| 2. CRUD Exercise Overview.srt |
11.34KB |
| 2. Important Note about Running SQL Files (please read).html |
465B |
| 2. Inserting Data.mp4 |
6.68MB |
| 2. Inserting Data.srt |
7.01KB |
| 2. Instructor Introduction(s).mp4 |
8.44MB |
| 2. Instructor Introduction(s).srt |
2.61KB |
| 2. Introduction to CRUD.mp4 |
2.25MB |
| 2. Introduction to CRUD.srt |
2.59KB |
| 2. Introduction To Instagram Clone Schema.mp4 |
21.73MB |
| 2. Introduction To Instagram Clone Schema.srt |
13.41KB |
| 2. Join Us Completed CODE.html |
337B |
| 2. Many To Many Basics.mp4 |
14.23MB |
| 2. Many To Many Basics.srt |
15.26KB |
| 2. Note about Loading The JUMBO dataset.html |
745B |
| 2. Not Equal.mp4 |
7.69MB |
| 2. Not Equal.srt |
5.70KB |
| 2. Real World Data Is Messy.mp4 |
14.13MB |
| 2. Real World Data Is Messy.srt |
16.31KB |
| 2. Section 16 Introduction.mp4 |
13.13MB |
| 2. Section 16 Introduction.srt |
2.65KB |
| 2. Seed Data Adding A Couple New Books.mp4 |
3.83MB |
| 2. Seed Data Adding A Couple New Books.srt |
4.65KB |
| 2. The Count Function.mp4 |
12.93MB |
| 2. The Count Function.srt |
11.78KB |
| 2. What Is a Database.mp4 |
10.27MB |
| 2. What Is a Database.srt |
10.47KB |
| 2. Writing Our First Trigger Part 1.mp4 |
11.35MB |
| 2. Writing Our First Trigger Part 1.srt |
10.78KB |
| 20.1 Slides.html |
128B |
| 20.1 Slides.html |
128B |
| 20. CODE A Primer on Primary Keys.html |
1.43KB |
| 20. CODE Creating Your Own Tables Challenge.html |
161B |
| 20. CODE Working with TIMESTAMPS.html |
936B |
| 20. Inserting Using Node.mp4 |
21.93MB |
| 20. Inserting Using Node.srt |
16.42KB |
| 20. Introduction to DELETE.mp4 |
6.16MB |
| 20. Introduction to DELETE.srt |
6.74KB |
| 20. Logical Operators Exercises.mp4 |
10.84MB |
| 20. Logical Operators Exercises.srt |
9.83KB |
| 20. Our First Joins Exercise SOLUTION.mp4 |
18.66MB |
| 20. Our First Joins Exercise SOLUTION.srt |
11.90KB |
| 20. String Function Challenges.mp4 |
7.21MB |
| 20. String Function Challenges.srt |
6.59KB |
| 21.1 Exercise Slides.html |
112B |
| 21.1 Slides.html |
128B |
| 21. CODE Inserting Using Node.html |
724B |
| 21. CODE Introduction to DELETE.html |
240B |
| 21. CODE Our First Joins Exercise.html |
798B |
| 21. Data Types Exercises.mp4 |
7.00MB |
| 21. Data Types Exercises.srt |
6.46KB |
| 21. Logical Operators Exercises Solution.mp4 |
33.29MB |
| 21. Logical Operators Exercises Solution.srt |
22.42KB |
| 21. String Function Challenges Solution.mp4 |
24.79MB |
| 21. String Function Challenges Solution.srt |
15.54KB |
| 21. Table Constraints Exercise.mp4 |
2.62MB |
| 21. Table Constraints Exercise.srt |
3.12KB |
| 22.1 Slides.html |
128B |
| 22. CODE Logical Operators Exercises Solution.html |
1.41KB |
| 22. CODE String Function Challenges Solution.html |
1.33KB |
| 22. Data Types Exercises Solution.mp4 |
26.42MB |
| 22. Data Types Exercises Solution.srt |
17.64KB |
| 22. DELETE Challenges.mp4 |
1.64MB |
| 22. DELETE Challenges.srt |
1.85KB |
| 22. Our First Joins Exercise SOLUTION PT. 2.mp4 |
17.20MB |
| 22. Our First Joins Exercise SOLUTION PT. 2.srt |
12.54KB |
| 22. Some MySQLNode Magic.mp4 |
17.86MB |
| 22. Some MySQLNode Magic.srt |
10.77KB |
| 22. Table Constraints Exercise Solution.mp4 |
7.98MB |
| 22. Table Constraints Exercise Solution.srt |
4.52KB |
| 23. Bulk Inserting 500 Users - Finally!.mp4 |
22.41MB |
| 23. Bulk Inserting 500 Users - Finally!.srt |
12.83KB |
| 23. CODE Data Types Exercises Solution.html |
1.17KB |
| 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.srt |
3.36KB |
| 24. CODE Bulk Inserting 500 Users.html |
574B |
| 24. CODE DELETE Challenges Solution.html |
317B |
| 25.1 Slides.html |
110B |
| 25. 500 Users Exercises.mp4 |
3.45MB |
| 25. 500 Users Exercises.srt |
3.92KB |
| 26. 500 Users Exercises Solutions.mp4 |
21.88MB |
| 26. 500 Users Exercises Solutions.srt |
15.04KB |
| 27. CODE 500 Users Exercises Solutions.html |
1.29KB |
| 3.1 Lecture Slides.html |
124B |
| 3.1 Slides.html |
110B |
| 3.1 Slides For This Section.html |
108B |
| 3.1 Slides For This Section.html |
111B |
| 3.2 Express Documentation.html |
83B |
| 3. Cloning Instagram's DB Users Schema.mp4 |
9.50MB |
| 3. Cloning Instagram's DB Users Schema.srt |
8.78KB |
| 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 Seed Data Adding A Couple New Books.html |
361B |
| 3. CODE The Count Function.html |
373B |
| 3. Creating Our Tables.mp4 |
21.85MB |
| 3. Creating Our Tables.srt |
14.41KB |
| 3. CRUD Exercise Create Solution.mp4 |
8.93MB |
| 3. CRUD Exercise Create Solution.srt |
7.13KB |
| 3. Introducing Express.mp4 |
9.54MB |
| 3. Introducing Express.srt |
9.51KB |
| 3. Loading The JUMBO dataset.mp4 |
59.23MB |
| 3. Loading The JUMBO dataset.srt |
12.48KB |
| 3. MySQL and Other Languages.mp4 |
11.17MB |
| 3. MySQL and Other Languages.srt |
14.70KB |
| 3. Note about CHAR and VARCHAR.html |
360B |
| 3. Running SQL Files.mp4 |
15.18MB |
| 3. Running SQL Files.srt |
13.83KB |
| 3. SQL Vs. MySQL.mp4 |
7.71MB |
| 3. SQL Vs. MySQL.srt |
8.08KB |
| 3. Syllabus Walkthrough and Prerequisites.mp4 |
12.15MB |
| 3. Syllabus Walkthrough and Prerequisites.srt |
7.30KB |
| 3. Types of Data Relationships.mp4 |
6.20MB |
| 3. Types of Data Relationships.srt |
6.70KB |
| 3. Writing Our First Trigger Part 2.mp4 |
22.78MB |
| 3. Writing Our First Trigger Part 2.srt |
17.19KB |
| 4.1 ig_clone_data.sql |
429.36KB |
| 4.1 Installation Slides.html |
107B |
| 4. BUT WHAT ABOUT PHP.mp4 |
15.17MB |
| 4. BUT WHAT ABOUT PHP.srt |
11.67KB |
| 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. CODE Running SQL Files.html |
403B |
| 4. Dropping Databases.mp4 |
2.47MB |
| 4. Dropping Databases.srt |
2.65KB |
| 4. Installation Overview - WATCH BEFORE INSTALLING.mp4 |
6.63MB |
| 4. Installation Overview - WATCH BEFORE INSTALLING.srt |
8.19KB |
| 4. Note about next lecture.html |
566B |
| 4. Note about SQL Editor.html |
465B |
| 4. Not Like.mp4 |
3.77MB |
| 4. Not Like.srt |
3.59KB |
| 4. NPM Init and package.json files.mp4 |
11.60MB |
| 4. NPM Init and package.json files.srt |
9.96KB |
| 4. One To Many The Basics.mp4 |
19.04MB |
| 4. One To Many The Basics.srt |
18.45KB |
| 4. Preparing Our Data.mp4 |
3.71MB |
| 4. Preparing Our Data.srt |
3.54KB |
| 4. Super Quick Intro To SELECT.mp4 |
2.95MB |
| 4. Super Quick Intro To SELECT.srt |
3.23KB |
| 4. The Instagram Clone DATASET.html |
381B |
| 4. The Joys of Group By.mp4 |
18.87MB |
| 4. The Joys of Group By.srt |
17.05KB |
| 4. Using DISTINCT.mp4 |
12.70MB |
| 4. Using DISTINCT.srt |
11.05KB |
| 5.1 book_data.sql |
1.31KB |
| 5.1 Lecture Slides.html |
125B |
| 5.1 Slides.html |
110B |
| 5.1 SQL Try-It Editor.html |
123B |
| 5.2 Lecture Slides.html |
108B |
| 5. Cloning Instagram's DB Photos Schema.mp4 |
11.72MB |
| 5. Cloning Instagram's DB Photos Schema.srt |
8.28KB |
| 5. Cloud9 Registration IMPORTANT - PLEASE READ!!!.html |
2.06KB |
| 5. CODE Dropping Databases.html |
292B |
| 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 |
726B |
| 5. CODE Using DISTINCT.html |
284B |
| 5. CRUD Exercise Read Solution.mp4 |
2.89MB |
| 5. CRUD Exercise Read Solution.srt |
2.22MB |
| 5. DECIMAL.mp4 |
11.27MB |
| 5. DECIMAL.srt |
8.08KB |
| 5. Instagram Clone Challenge 1.mp4 |
8.62MB |
| 5. Instagram Clone Challenge 1.srt |
6.89KB |
| 5. Introduction to JOIN US app.mp4 |
11.93MB |
| 5. Introduction to JOIN US app.srt |
12.70KB |
| 5. Loading Our Book Data.mp4 |
13.05MB |
| 5. Loading Our Book Data.srt |
7.89KB |
| 5. Note about Our First Simple Web App.html |
493B |
| 5. Preventing Instagram Self-Follows With Triggers.mp4 |
14.12MB |
| 5. Preventing Instagram Self-Follows With Triggers.srt |
11.71KB |
| 5. TV Joins Challenge 1.mp4 |
11.79MB |
| 5. TV Joins Challenge 1.srt |
6.24KB |
| 5. Working With Foreign Keys.mp4 |
22.68MB |
| 5. Working With Foreign Keys.srt |
16.81KB |
| 5. Your First 5 Minutes of SQL - Let's Get Coding!.mp4 |
18.33MB |
| 5. Your First 5 Minutes of SQL - Let's Get Coding!.srt |
10.59KB |
| 6.1 Lecture Slides.html |
125B |
| 6. CODE CRUD Exercise Read Solution.html |
198B |
| 6. CODE DECIMAL.html |
308B |
| 6. CODE IG Clone Photos Schema.html |
260B |
| 6. CODE Loading Our Book Data.html |
1.67KB |
| 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.57KB |
| 6. Creating Logger Triggers.mp4 |
18.63MB |
| 6. Creating Logger Triggers.srt |
13.80KB |
| 6. Greater Than.mp4 |
16.40MB |
| 6. Greater Than.srt |
14.04KB |
| 6. Instagram Challenge 1 Solution CODE.html |
126B |
| 6. Mac Installation.mp4 |
22.18MB |
| 6. Mac Installation.srt |
17.73KB |
| 6. Min and Max Basics.mp4 |
6.44MB |
| 6. Min and Max Basics.srt |
5.18KB |
| 6. Multiple INSERT.mp4 |
4.06MB |
| 6. Multiple INSERT.srt |
4.07KB |
| 6. Note about Setting Up Cloud9 for Node.html |
835B |
| 6. Official Introduction to SELECT.mp4 |
6.12MB |
| 6. Official Introduction to SELECT.srt |
5.33KB |
| 6. Our First Simple Web App.mp4 |
28.19MB |
| 6. Our First Simple Web App.srt |
24.76KB |
| 6. Sorting Data with ORDER BY.mp4 |
19.53MB |
| 6. Sorting Data with ORDER BY.srt |
2.24KB |
| 6. Using Databases.mp4 |
4.41MB |
| 6. Using Databases.srt |
3.91KB |
| 7.1 Lecture Slides.html |
125B |
| 7. 5 Minute NodeJS Crash Course.mp4 |
9.36MB |
| 7. 5 Minute NodeJS Crash Course.srt |
9.15KB |
| 7. Cloning Instagram's DB Comments Schema.mp4 |
12.94MB |
| 7. Cloning Instagram's DB Comments Schema.srt |
8.59KB |
| 7. CODE Greater Than.html |
809B |
| 7. CODE Mac Installation.html |
1.31KB |
| 7. CODE MIN and MAX Basics.html |
258B |
| 7. CODE Multiple Insert.html |
189B |
| 7. CODE Official Introduction to SELECT.html |
573B |
| 7. CODE Our First Simple Web App.html |
411B |
| 7. CODE Sorting Data with ORDER BY.html |
997B |
| 7. CODE Using Databases.html |
120B |
| 7. Cross Join.mp4 |
14.50MB |
| 7. Cross Join.srt |
10.49KB |
| 7. CRUD Exercise Update Solution.mp4 |
6.40MB |
| 7. CRUD Exercise Update Solution.srt |
5.09KB |
| 7. FLOAT and DOUBLE.mp4 |
11.60MB |
| 7. FLOAT and DOUBLE.srt |
9.95KB |
| 7. How The Course Works.mp4 |
22.40MB |
| 7. How The Course Works.srt |
6.48KB |
| 7. Instagram Clone Challenge 2.mp4 |
11.71MB |
| 7. Instagram Clone Challenge 2.srt |
10.07KB |
| 7. Managing Triggers And A Warning.mp4 |
12.56MB |
| 7. Managing Triggers And A Warning.srt |
9.29KB |
| 7. TV Joins Challenge 2.mp4 |
13.24MB |
| 7. TV Joins Challenge 2.srt |
8.89KB |
| 7. Working with CONCAT.mp4 |
23.01MB |
| 7. Working with CONCAT.srt |
15.60KB |
| 8. Adding Multiple Routes.mp4 |
18.67MB |
| 8. Adding Multiple Routes.srt |
14.65KB |
| 8. CODE 5 Minute Node Crash Course.html |
274B |
| 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. CODE Working With CONCAT.html |
944B |
| 8. INSERT Challenges.mp4 |
2.17MB |
| 8. INSERT Challenges.srt |
2.25KB |
| 8. Instagram Challenge 2 Solution CODE.html |
216B |
| 8. Introduction to Tables.mp4 |
7.11MB |
| 8. Introduction to Tables.srt |
7.70KB |
| 8. Introduction to WHERE.mp4 |
6.83MB |
| 8. Introduction to WHERE.srt |
7.02KB |
| 8. Less Than.mp4 |
6.06MB |
| 8. Less Than.srt |
5.22KB |
| 8. SUBQUERIES - A Problem with Min and Max.mp4 |
10.76MB |
| 8. SUBQUERIES - A Problem with Min and Max.srt |
9.16KB |
| 8. Using LIMIT.mp4 |
16.36MB |
| 8. Using LIMIT.srt |
13.01KB |
| 8. Windows Installation.mp4 |
5.73MB |
| 8. Windows Installation.srt |
6.40KB |
| 9. Cloning Instagram's DB Likes Schema.mp4 |
20.57MB |
| 9. Cloning Instagram's DB Likes Schema.srt |
10.34KB |
| 9. CODE Adding Multiple Routes.html |
467B |
| 9. CODE A Problem with Min and Max.html |
480B |
| 9. CODE Introduction to WHERE.html |
309B |
| 9. CODE Less Than.html |
370B |
| 9. CODE Using LIMIT.html |
897B |
| 9. CRUD Exercise Delete Solution.mp4 |
4.89MB |
| 9. CRUD Exercise Delete Solution.srt |
4.24KB |
| 9. Inner Join.mp4 |
27.58MB |
| 9. Inner Join.srt |
16.17KB |
| 9. Instagram Clone Challenge 3.mp4 |
17.26MB |
| 9. Instagram Clone Challenge 3.srt |
10.84KB |
| 9. Introducing SUBSTRING.mp4 |
15.74MB |
| 9. Introducing SUBSTRING.srt |
13.53KB |
| 9. Note about Faker install.html |
2.16KB |
| 9. Note about setting the timezone in Cloud9.html |
423B |
| 9. Note about using quotes inside of inserted values.html |
502B |
| 9. The Basic Datatypes.mp4 |
10.78MB |
| 9. The Basic Datatypes.srt |
11.33KB |
| 9. TV Joins Challenge 3.mp4 |
11.45MB |
| 9. TV Joins Challenge 3.srt |
6.58KB |