FileMood

Download [FreeCourseSite.com] Udemy - The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert

FreeCourseSite com Udemy The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert

Name

[FreeCourseSite.com] Udemy - The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert

 DOWNLOAD Copy Link

Total Size

9.7 GB

Total Files

1147

Last Seen

2024-10-12 18:29

Hash

43933A684BC4A12DC841C097F1BB223D1F0E1834

/0. Websites you may like/

[CourseClub.Me].url

0.1 KB

[FreeCourseSite.com].url

0.1 KB

[GigaCourse.Com].url

0.0 KB

/01 - Introduction & 5 Minutes of SQL/

001 This Course Was Just Updated!.mp4

17.9 MB

001 This Course Was Just Updated!_en.srt

5.2 KB

002 Join The Community!.html

0.9 KB

003 Course Intro.mp4

5.7 MB

003 Course Intro_en.srt

2.3 KB

004 About Me.mp4

9.1 MB

004 About Me_en.srt

2.8 KB

005 Getting The Course Code.mp4

5.0 MB

005 Getting The Course Code_en.srt

2.8 KB

006 First 5 Minutes of SQL.mp4

42.5 MB

006 First 5 Minutes of SQL_en.srt

14.2 KB

006 SLIDES.url

0.1 KB

006 SQL-Try-It-Editor.url

0.1 KB

external-links.txt

0.2 KB

/02 - Getting Started & Installation/

001 Section Introduction.mp4

12.4 MB

001 Section Introduction_en.srt

2.0 KB

002 SLIDES.url

0.1 KB

002 What Is A Database.mp4

14.5 MB

002 What Is A Database_en.srt

11.0 KB

003 SQL vs. MySQL.mp4

10.4 MB

003 SQL vs. MySQL_en.srt

8.2 KB

004 Installation START HERE!.mp4

32.8 MB

004 Installation START HERE!_en.srt

8.9 KB

005 Installation Windows Instructions.mp4

35.9 MB

005 Installation Windows Instructions_en.srt

15.6 KB

005 Windows-MySQL-Installation.url

0.1 KB

006 IMPORTANT Mac Installation Notes.html

4.1 KB

007 Installation Mac Instructions.mp4

42.5 MB

007 Installation Mac Instructions_en.srt

19.3 KB

007 Mac-MySQL-Download.url

0.1 KB

007 MySQL-Workbench-Download.url

0.1 KB

007 OPTIONAL-dbGate-Download.url

0.0 KB

external-links.txt

0.4 KB

/03 - Creating Databases & Tables/

001 Section Introduction.mp4

13.7 MB

001 Section Introduction_en.srt

2.1 KB

002 SLIDES.url

0.1 KB

002 Showing Databases.mp4

6.8 MB

002 Showing Databases_en.srt

6.8 KB

003 CODE Showing Databases.html

0.1 KB

004 Creating Databases.mp4

9.5 MB

004 Creating Databases_en.srt

8.1 KB

005 CODE Creating Databases.html

0.2 KB

006 Dropping and Using Databases.mp4

10.7 MB

006 Dropping and Using Databases_en.srt

8.6 KB

007 CODE Dropping and Using Databases.html

0.2 KB

008 Introducing Tables.mp4

22.4 MB

008 Introducing Tables_en.srt

8.5 KB

009 Data Types The Basics.mp4

22.4 MB

009 Data Types The Basics_en.srt

11.8 KB

010 Basic Datatypes Challenge.mp4

5.1 MB

010 Basic Datatypes Challenge_en.srt

3.9 KB

011 CODE Basic Datatypes Challenge.html

0.2 KB

012 Creating Tables.mp4

8.5 MB

012 Creating Tables_en.srt

8.1 KB

013 CODE Creating Tables.html

0.2 KB

014 How Do We Know It Worked.mp4

12.5 MB

014 How Do We Know It Worked_en.srt

7.3 KB

015 CODE How Do We Know It Worked.html

0.1 KB

016 Dropping Tables.mp4

4.8 MB

016 Dropping Tables_en.srt

3.8 KB

017 CODE Dropping Tables.html

0.2 KB

018 Tables Basics Activity.mp4

5.9 MB

018 Tables Basics Activity_en.srt

4.8 KB

019 SOLUTION Tables Basics Activity.html

0.3 KB

020 MySQL Comments.mp4

5.9 MB

020 MySQL Comments_en.srt

5.4 KB

external-links.txt

0.1 KB

/04 - Inserting Data/

001 Section Introduction.mp4

10.7 MB

001 Section Introduction_en.srt

3.0 KB

002 INSERT The Basics.mp4

6.5 MB

002 INSERT The Basics_en.srt

5.8 KB

002 SLIDES.url

0.1 KB

003 CODE INSERT The Basics.html

0.4 KB

004 A Quick Preview of SELECT.mp4

4.3 MB

004 A Quick Preview of SELECT_en.srt

2.9 KB

005 CODE A Quick Preview of SELECT.html

0.1 KB

006 Multi-inserts.mp4

10.8 MB

006 Multi-inserts_en.srt

7.6 KB

007 CODE Multi-inserts.html

0.3 KB

008 INSERT Exercise.mp4

32.4 MB

008 INSERT Exercise_en.srt

8.5 KB

009 SOLUTION INSERT Exercise.html

0.8 KB

010 Working With NOT NULL.mp4

19.2 MB

010 Working With NOT NULL_en.srt

8.6 KB

011 CODE Working With NOT NULL.html

0.1 KB

012 Sidenote Quotes In MySQL.mp4

7.8 MB

012 Sidenote Quotes In MySQL_en.srt

6.7 KB

013 Adding DEFAULT Values.mp4

16.8 MB

013 Adding DEFAULT Values_en.srt

10.3 KB

014 CODE Adding DEFAULT Values.html

0.7 KB

015 Introducing Primary Keys.mp4

12.6 MB

015 Introducing Primary Keys_en.srt

7.6 KB

016 CODE Introducing Primary Keys.html

0.4 KB

017 Working With AUTO_INCREMENT.mp4

31.0 MB

017 Working With AUTO_INCREMENT_en.srt

10.7 KB

018 CODE Working With AUTO_INCREMENT.html

0.2 KB

019 Create Table Insert Exercise.mp4

47.4 MB

019 Create Table Insert Exercise_en.srt

10.8 KB

020 SOLUTION Insert Exercise.html

0.9 KB

external-links.txt

0.1 KB

/05 - CRUD Basics/

001 Section Introduction.mp4

17.3 MB

001 Section Introduction_en.srt

2.6 KB

002 Introducing CRUD.mp4

2.3 MB

002 Introducing CRUD_en.srt

3.2 KB

002 SLIDES.url

0.1 KB

003 Getting Our New Dataset.mp4

2.9 MB

003 Getting Our New Dataset_en.srt

3.0 KB

004 CODE.html

0.7 KB

005 Officially Introducing SELECT.mp4

11.1 MB

005 Officially Introducing SELECT_en.srt

5.2 KB

006 CODE.html

0.3 KB

007 The WHERE clause.mp4

5.5 MB

007 The WHERE clause_en.srt

5.4 KB

008 CODE.html

0.2 KB

009 Rapid Fire Exercises.mp4

8.9 MB

009 Rapid Fire Exercises_en.srt

2.3 KB

010 Rapid Fire Exercises SOLUTION.mp4

7.4 MB

010 Rapid Fire Exercises SOLUTION_en.srt

4.2 KB

011 SOLUTION CODE.html

0.3 KB

012 Aliases.mp4

3.2 MB

012 Aliases_en.srt

3.4 KB

013 CODE.html

0.2 KB

014 Using UPDATE.mp4

10.5 MB

014 Using UPDATE_en.srt

7.4 KB

015 CODE.html

0.2 KB

016 A Quick Rule Of Thumb.mp4

2.2 MB

016 A Quick Rule Of Thumb_en.srt

2.8 KB

017 UPDATE Exercise.mp4

1.4 MB

017 UPDATE Exercise_en.srt

1.9 KB

018 UPDATE Exercise SOLUTION.mp4

4.9 MB

018 UPDATE Exercise SOLUTION_en.srt

4.4 KB

019 SOLUTION CODE.html

0.6 KB

020 Introducing DELETE.mp4

8.0 MB

020 Introducing DELETE_en.srt

3.9 KB

021 CODE.html

0.2 KB

022 DELETE Exercise.mp4

1.5 MB

022 DELETE Exercise_en.srt

1.6 KB

023 DELETE Exercise SOLUTION.mp4

3.4 MB

023 DELETE Exercise SOLUTION_en.srt

3.5 KB

024 SOLUTION CODE.html

0.3 KB

external-links.txt

0.1 KB

/06 - CRUD Challenge/

001 Section Introduction.mp4

22.4 MB

001 Section Introduction_en.srt

3.2 KB

002 Introducing the CRUD Challenge.mp4

7.5 MB

002 Introducing the CRUD Challenge_en.srt

9.0 KB

002 SLIDES.url

0.1 KB

003 CRUD Challenge Solution Creating.mp4

40.5 MB

003 CRUD Challenge Solution Creating_en.srt

13.0 KB

004 SOLUTION CODE.html

0.7 KB

005 CRUD Challenge Solution Reading.mp4

4.5 MB

005 CRUD Challenge Solution Reading_en.srt

2.9 KB

006 SOLUTION CODE.html

0.2 KB

007 CRUD Challenge Solution Updating.mp4

11.7 MB

007 CRUD Challenge Solution Updating_en.srt

4.9 KB

008 SOLUTION CODE.html

0.3 KB

009 CRUD Challenge Solution Deleting.mp4

5.3 MB

009 CRUD Challenge Solution Deleting_en.srt

4.6 KB

010 SOLUTION CODE.html

0.3 KB

external-links.txt

0.1 KB

/07 - String Functions/

001 Section Introduction.mp4

10.2 MB

001 Section Introduction_en.srt

3.4 KB

002 MySQL-Docs-String-Functions.url

0.1 KB

002 SLIDES.url

0.1 KB

002 The World Of String Functions.mp4

8.3 MB

002 The World Of String Functions_en.srt

3.0 KB

003 Loading Our Books Data.mp4

38.1 MB

003 Loading Our Books Data_en.srt

9.1 KB

003 book-data.sql

1.3 KB

004 CODE.html

1.4 KB

005 CONCAT.mp4

18.8 MB

005 CONCAT_en.srt

13.4 KB

006 CODE.html

0.2 KB

007 SUBSTRING.mp4

27.5 MB

007 SUBSTRING_en.srt

11.9 KB

008 CODE.html

0.3 KB

009 Combining String Functions.mp4

16.4 MB

009 Combining String Functions_en.srt

10.3 KB

010 CODE.html

0.1 KB

011 SQL-Formatter.url

0.1 KB

011 Sidenote SQL Formatting.mp4

17.4 MB

011 Sidenote SQL Formatting_en.srt

7.4 KB

012 REPLACE.mp4

22.0 MB

012 REPLACE_en.srt

9.5 KB

013 CODE.html

0.4 KB

014 REVERSE.mp4

8.3 MB

014 REVERSE_en.srt

5.3 KB

015 CODE.html

0.3 KB

016 CHAR_LENGTH.mp4

8.1 MB

016 CHAR_LENGTH_en.srt

4.0 KB

017 CODE.html

0.3 KB

018 UPPER & LOWER.mp4

15.7 MB

018 UPPER & LOWER_en.srt

5.9 KB

019 CODE.html

0.3 KB

020 Other String Functions.mp4

20.0 MB

020 Other String Functions_en.srt

9.6 KB

021 CODE.html

0.2 KB

022 String Functions Exercise.mp4

9.1 MB

022 String Functions Exercise_en.srt

6.1 KB

023 String Functions Exerise SOLUTION.mp4

61.7 MB

023 String Functions Exerise SOLUTION_en.srt

17.2 KB

024 SOLUTION CODE.html

0.7 KB

external-links.txt

0.2 KB

/08 - Refining Selections/

001 Section Introduction.mp4

7.1 MB

001 Section Introduction_en.srt

1.1 KB

002 Adding Some New Books.mp4

2.2 MB

002 Adding Some New Books_en.srt

2.3 KB

002 SLIDES.url

0.1 KB

003 CODE.html

0.3 KB

004 DISTINCT.mp4

11.0 MB

004 DISTINCT_en.srt

9.2 KB

005 CODE.html

0.3 KB

006 ORDER BY.mp4

40.2 MB

006 ORDER BY_en.srt

9.4 KB

007 CODE.html

0.2 KB

008 More On ORDER BY.mp4

24.8 MB

008 More On ORDER BY_en.srt

8.7 KB

009 CODE.html

0.2 KB

010 LIMIT.mp4

25.3 MB

010 LIMIT_en.srt

8.6 KB

011 CODE.html

0.9 KB

012 LIKE.mp4

28.6 MB

012 LIKE_en.srt

10.7 KB

013 CODE.html

0.3 KB

014 Escaping Wildcards.mp4

5.1 MB

014 Escaping Wildcards_en.srt

3.3 KB

015 CODE.html

0.2 KB

016 Refining Selections Exercise.mp4

9.2 MB

016 Refining Selections Exercise_en.srt

5.0 KB

017 Refining Selections Exercise SOLUTION.mp4

79.0 MB

017 Refining Selections Exercise SOLUTION_en.srt

22.4 KB

018 SOLUTION CODE.html

0.8 KB

external-links.txt

0.1 KB

/09 - Aggregate Functions/

001 Section Introduction.mp4

19.6 MB

001 Section Introduction_en.srt

6.6 KB

002 Count Basics.mp4

22.1 MB

002 Count Basics_en.srt

10.7 KB

002 SLIDES.url

0.1 KB

003 CODE.html

0.2 KB

004 GROUP BY.mp4

44.8 MB

004 GROUP BY_en.srt

15.4 KB

005 CODE.html

0.2 KB

006 MIN and MAX Basics.mp4

5.3 MB

006 MIN and MAX Basics_en.srt

5.8 KB

007 CODE.html

0.1 KB

008 Subqueries.mp4

22.9 MB

008 Subqueries_en.srt

9.3 KB

009 CODE.html

0.3 KB

010 Grouping By Multiple Columns.mp4

12.8 MB

010 Grouping By Multiple Columns_en.srt

6.9 KB

011 CODE.html

0.2 KB

012 MIN and MAX With GROUP BY.mp4

20.9 MB

012 MIN and MAX With GROUP BY_en.srt

8.9 KB

013 CODE.html

0.6 KB

014 SUM.mp4

13.9 MB

014 SUM_en.srt

4.9 KB

015 CODE.html

0.2 KB

016 AVG.mp4

4.2 MB

016 AVG_en.srt

3.3 KB

017 CODE.html

0.2 KB

018 Aggregate Functions Docs.mp4

10.8 MB

018 Aggregate Functions Docs_en.srt

2.0 KB

019 Agg Functions Exercise.mp4

4.3 MB

019 Agg Functions Exercise_en.srt

4.5 KB

020 Agg Functions Exercise SOLUTION.mp4

36.8 MB

020 Agg Functions Exercise SOLUTION_en.srt

17.8 KB

021 SOLUTION CODE.html

0.6 KB

external-links.txt

0.1 KB

/10 - Revisiting Data Types/

001 Section Introduction.mp4

12.3 MB

001 Section Introduction_en.srt

3.3 KB

002 Data-Types-Reference.url

0.1 KB

002 SLIDES.url

0.1 KB

002 Surveying Other Data Types.mp4

16.2 MB

002 Surveying Other Data Types_en.srt

4.7 KB

003 CHAR vs. VARCHAR.mp4

29.8 MB

003 CHAR vs. VARCHAR_en.srt

19.1 KB

004 INT, TINYINT, BIGINT, etc.mp4

21.6 MB

004 INT, TINYINT, BIGINT, etc_en.srt

7.5 KB

005 DECIMAL.mp4

10.4 MB

005 DECIMAL_en.srt

10.4 KB

006 FLOAT & DOUBLE.mp4

12.9 MB

006 FLOAT & DOUBLE_en.srt

8.5 KB

007 DATE and TIME.mp4

13.4 MB

007 DATE and TIME_en.srt

6.8 KB

008 Working With Dates.mp4

52.2 MB

008 Working With Dates_en.srt

11.0 KB

009 CODE.html

0.5 KB

010 CURDATE, CURTIME, & NOW.mp4

25.1 MB

010 CURDATE, CURTIME, & NOW_en.srt

6.1 KB

011 CODE.html

0.2 KB

012 Date Functions.mp4

41.7 MB

012 Date Functions_en.srt

8.8 KB

013 CODE.html

0.2 KB

014 Time Functions.mp4

9.7 MB

014 Time Functions_en.srt

3.0 KB

015 CODE.html

0.2 KB

016 Formatting Dates.mp4

58.5 MB

016 Formatting Dates_en.srt

13.2 KB

017 CODE.html

0.2 KB

018 Date Math.mp4

60.5 MB

018 Date Math_en.srt

15.3 KB

019 TIMESTAMPS.mp4

19.6 MB

019 TIMESTAMPS_en.srt

5.0 KB

020 DEFAULT & ON UPDATE TIMESTAMPS.mp4

41.7 MB

020 DEFAULT & ON UPDATE TIMESTAMPS_en.srt

9.8 KB

021 CODE.html

0.3 KB

022 Data Types Exercise.mp4

5.5 MB

022 Data Types Exercise_en.srt

5.8 KB

023 Data Types Exercise SOLUTION.mp4

43.8 MB

023 Data Types Exercise SOLUTION_en.srt

20.0 KB

024 SOLUTION CODE.html

1.3 KB

external-links.txt

0.2 KB

/.../0. Websites you may like/

[CourseClub.Me].url

0.1 KB

[FreeCourseSite.com].url

0.1 KB

[GigaCourse.Com].url

0.0 KB

/11 - Comparison & Logical Operators/

001 Section Introduction.mp4

17.4 MB

001 Section Introduction_en.srt

4.9 KB

002 Not Equal.mp4

5.4 MB

002 Not Equal_en.srt

3.9 KB

002 SLIDES.url

0.1 KB

003 CODE.html

0.1 KB

004 NOT LIKE.mp4

8.6 MB

004 NOT LIKE_en.srt

4.5 KB

005 CODE.html

0.1 KB

006 Greater Than.mp4

10.2 MB

006 Greater Than_en.srt

5.8 KB

007 CODE.html

0.1 KB

008 Less Than Or Equal To.mp4

8.3 MB

008 Less Than Or Equal To_en.srt

3.9 KB

009 CODE.html

0.2 KB

010 Logical AND.mp4

28.7 MB

010 Logical AND_en.srt

13.6 KB

011 CODE.html

0.3 KB

012 Logical OR.mp4

32.5 MB

012 Logical OR_en.srt

7.9 KB

013 CODE.html

0.4 KB

014 Between.mp4

14.4 MB

014 Between_en.srt

6.5 KB

015 CODE.html

0.2 KB

016 Comparing Dates.mp4

49.3 MB

016 Comparing Dates_en.srt

11.8 KB

017 CODE.html

0.2 KB

018 The IN Operator.mp4

56.0 MB

018 The IN Operator_en.srt

13.2 KB

019 CODE.html

0.5 KB

020 CASE.mp4

48.6 MB

020 CASE_en.srt

12.3 KB

021 CODE.html

0.8 KB

022 IS NULL.mp4

7.8 MB

022 IS NULL_en.srt

2.9 KB

023 Exercise.mp4

7.5 MB

023 Exercise_en.srt

5.1 KB

024 Exercise SOLUTION.mp4

86.0 MB

024 Exercise SOLUTION_en.srt

22.6 KB

025 SOLUTION CODE.html

1.1 KB

external-links.txt

0.1 KB

/12 - Constraints & ALTER TABLE/

001 SLIDES.url

0.1 KB

001 UNIQUE Constraint.mp4

6.8 MB

001 UNIQUE Constraint_en.srt

5.6 KB

002 CODE.html

0.3 KB

003 CHECK Constraints.mp4

13.0 MB

003 CHECK Constraints_en.srt

7.4 KB

004 CODE.html

0.2 KB

005 Named Constraints.mp4

13.7 MB

005 Named Constraints_en.srt

6.3 KB

006 CODE.html

0.3 KB

007 Multiple Column Constraints.mp4

24.4 MB

007 Multiple Column Constraints_en.srt

7.5 KB

008 CODE.html

0.3 KB

009 ALTER TABLE Adding Columns.mp4

29.3 MB

009 ALTER TABLE Adding Columns_en.srt

8.5 KB

010 CODE.html

0.2 KB

011 ALTER TABLE Dropping Columns.mp4

12.5 MB

011 ALTER TABLE Dropping Columns_en.srt

2.8 KB

012 CODE.html

0.1 KB

013 ALTER TABLE Renaming.mp4

16.2 MB

013 ALTER TABLE Renaming_en.srt

5.2 KB

014 CODE.html

0.3 KB

015 ALTER TABLE Modifying Columns.mp4

8.6 MB

015 ALTER TABLE Modifying Columns_en.srt

5.7 KB

016 CODE.html

0.2 KB

017 ALTER TABLE Constraints.mp4

23.4 MB

017 ALTER TABLE Constraints_en.srt

6.4 KB

018 CODE.html

0.2 KB

external-links.txt

0.1 KB

/13 - One to Many & Joins/

001 Section Introduction.mp4

23.4 MB

001 Section Introduction_en.srt

3.2 KB

002 Data is Messy.mp4

26.1 MB

002 Data is Messy_en.srt

17.0 KB

002 SLIDES.url

0.1 KB

003 Relationships Basics.mp4

8.8 MB

003 Relationships Basics_en.srt

7.2 KB

004 One to Many Relationship.mp4

35.4 MB

004 One to Many Relationship_en.srt

19.1 KB

005 Working with FOREIGN KEY.mp4

50.0 MB

005 Working with FOREIGN KEY_en.srt

16.3 KB

006 CODE.html

0.9 KB

007 Cross Joins.mp4

59.9 MB

007 Cross Joins_en.srt

11.5 KB

008 CODE.html

0.3 KB

009 Inner Joins.mp4

53.4 MB

009 Inner Joins_en.srt

13.1 KB

010 CODE.html

0.4 KB

011 Inner Joins With Group By.mp4

21.7 MB

011 Inner Joins With Group By_en.srt

7.2 KB

012 CODE.html

0.2 KB

013 Left Join.mp4

39.3 MB

013 Left Join_en.srt

10.7 KB

014 CODE.html

0.3 KB

015 Left Join With Group By.mp4

13.1 MB

015 Left Join With Group By_en.srt

5.1 KB

016 CODE.html

0.2 KB

017 Right Join.mp4

10.8 MB

017 Right Join_en.srt

6.0 KB

018 CODE.html

0.2 KB

019 On Delete Cascade.mp4

26.3 MB

019 On Delete Cascade_en.srt

7.7 KB

020 CODE.html

0.4 KB

021 Joins Exercise.mp4

6.7 MB

021 Joins Exercise_en.srt

4.5 KB

022 EXERCISE STARTER DATA.html

0.5 KB

023 Joins Exercise SOLUTION.mp4

39.1 MB

023 Joins Exercise SOLUTION_en.srt

15.9 KB

024 SOLUTION CODE.html

1.3 KB

external-links.txt

0.1 KB

/14 - Many to Many/

001 Section Introduction.mp4

12.2 MB

001 Section Introduction_en.srt

3.2 KB

002 Many to Many Basics.mp4

25.4 MB

002 Many to Many Basics_en.srt

16.1 KB

002 SLIDES.url

0.1 KB

003 Creating Our Many To Many Tables.mp4

35.8 MB

003 Creating Our Many To Many Tables_en.srt

9.0 KB

004 CODE.html

2.1 KB

005 TV Series Challenge #1.mp4

18.6 MB

005 TV Series Challenge #1_en.srt

5.5 KB

006 CODE.html

0.1 KB

007 TV Series Challenge #2.mp4

10.1 MB

007 TV Series Challenge #2_en.srt

5.2 KB

008 CODE.html

0.2 KB

009 TV Series Challenge #3.mp4

19.4 MB

009 TV Series Challenge #3_en.srt

5.1 KB

010 CODE.html

0.2 KB

011 TV Series Challenge #4.mp4

19.9 MB

011 TV Series Challenge #4_en.srt

4.7 KB

012 CODE.html

0.3 KB

013 TV Series Challenge #5.mp4

8.9 MB

013 TV Series Challenge #5_en.srt

3.3 KB

014 CODE.html

0.2 KB

015 TV Series Challenge #6.mp4

62.6 MB

015 TV Series Challenge #6_en.srt

12.9 KB

016 CODE.html

0.9 KB

017 TV Series Challenge #7.mp4

33.5 MB

017 TV Series Challenge #7_en.srt

7.3 KB

018 CODE.html

0.8 KB

external-links.txt

0.1 KB

/15 - Views, Modes, & More!/

001 Introducing Views.mp4

37.8 MB

001 Introducing Views_en.srt

9.2 KB

002 CODE.html

0.7 KB

003 Updateable Views.mp4

33.1 MB

003 Updateable Views_en.srt

7.9 KB

004 ReplacingAltering Views.mp4

24.5 MB

004 ReplacingAltering Views_en.srt

5.1 KB

005 CODE.html

0.3 KB

006 HAVING clause.mp4

30.7 MB

006 HAVING clause_en.srt

6.6 KB

007 CODE.html

0.2 KB

008 WITH ROLLUP.mp4

42.9 MB

008 WITH ROLLUP_en.srt

10.6 KB

009 CODE.html

0.4 KB

010 SQL Modes Basics.mp4

38.7 MB

010 SQL Modes Basics_en.srt

9.4 KB

011 CODE.html

0.2 KB

012 STRICT_TRANS_TABLES.mp4

17.6 MB

012 STRICT_TRANS_TABLES_en.srt

6.8 KB

013 More Modes.mp4

20.1 MB

013 More Modes_en.srt

13.7 KB

/16 - Window Functions/

001 Important Note (please read).html

0.5 KB

002 Introducing Window Functions.mp4

37.8 MB

002 Introducing Window Functions_en.srt

10.3 KB

002 SLIDES.url

0.1 KB

003 Using OVER().mp4

27.3 MB

003 Using OVER()_en.srt

12.5 KB

004 CODE.html

1.0 KB

005 PARTITION BY.mp4

35.6 MB

005 PARTITION BY_en.srt

9.5 KB

006 CODE.html

0.5 KB

007 ORDER BY with Windows.mp4

36.5 MB

007 ORDER BY with Windows_en.srt

9.7 KB

008 CODE.html

0.4 KB

009 RANK().mp4

20.7 MB

009 RANK()_en.srt

8.9 KB

010 DENSE_RANK, & ROW_NUMBER().mp4

40.4 MB

010 DENSE_RANK, & ROW_NUMBER()_en.srt

7.7 KB

011 CODE.html

0.5 KB

012 NTILE().mp4

20.6 MB

012 NTILE()_en.srt

5.3 KB

013 CODE.html

0.3 KB

014 FIRST_VALUE.mp4

16.5 MB

014 FIRST_VALUE_en.srt

5.8 KB

015 CODE.html

0.3 KB

016 LEAD and LAG.mp4

32.5 MB

016 LEAD and LAG_en.srt

8.5 KB

017 CODE.html

0.3 KB

external-links.txt

0.1 KB

/17 - Instagram Database Clone/

001 Section Introduction.mp4

16.0 MB

001 Section Introduction_en.srt

2.2 KB

002 IMPORTANT NOTE ABOUT THIS SECTION!.mp4

15.0 MB

002 IMPORTANT NOTE ABOUT THIS SECTION!_en.srt

3.1 KB

003 Introducing Instagram Clone.mp4

64.1 MB

003 Introducing Instagram Clone_en.srt

13.7 KB

003 SLIDES.url

0.1 KB

004 Users Schema.mp4

15.1 MB

004 Users Schema_en.srt

8.8 KB

005 CODE.html

0.2 KB

006 Photos Schema.mp4

22.2 MB

006 Photos Schema_en.srt

8.9 KB

007 CODE.html

0.3 KB

008 Comments Schema.mp4

23.8 MB

008 Comments Schema_en.srt

8.8 KB

009 CODE.html

0.4 KB

010 Likes Schema.mp4

67.3 MB

010 Likes Schema_en.srt

10.3 KB

011 CODE.html

0.3 KB

012 Followers Schema.mp4

23.3 MB

012 Followers Schema_en.srt

10.7 KB

013 CODE.html

0.3 KB

014 Note!.html

0.4 KB

015 3 Approaches for Hashtags.mp4

34.2 MB

015 3 Approaches for Hashtags_en.srt

15.9 KB

016 Implementing Hashtags Table.mp4

24.2 MB

016 Implementing Hashtags Table_en.srt

7.5 KB

017 CODE.html

0.4 KB

018 Complete Instagram Schema.html

1.7 KB

external-links.txt

0.1 KB

/18 - Working With Lots of IG Data/

001 Section Introduction.mp4

10.8 MB

001 Section Introduction_en.srt

2.8 KB

002 Getting Lots of Instagram Data.mp4

112.3 MB

002 Getting Lots of Instagram Data_en.srt

12.8 KB

003 CODE.html

0.2 KB

003 ig-clone-data.sql

439.7 KB

004 Instagram Challenge #1.mp4

11.3 MB

004 Instagram Challenge #1_en.srt

7.1 KB

005 CODE.html

0.1 KB

006 Instagram Challenge #2.mp4

40.1 MB

006 Instagram Challenge #2_en.srt

10.7 KB

007 CODE.html

0.2 KB

008 Instagram Challenge #3.mp4

26.8 MB

008 Instagram Challenge #3_en.srt

11.2 KB

009 CODE.html

0.1 KB

010 Instagram Challenge #4.mp4

26.3 MB

010 Instagram Challenge #4_en.srt

9.3 KB

011 CODE.html

0.3 KB

012 Instagram Challenge #5.mp4

8.8 MB

012 Instagram Challenge #5_en.srt

4.7 KB

013 CODE.html

0.2 KB

014 Instagram Challenge #6.mp4

16.1 MB

014 Instagram Challenge #6_en.srt

7.4 KB

015 CODE.html

0.2 KB

016 Instagram Challenge #7.mp4

18.8 MB

016 Instagram Challenge #7_en.srt

7.3 KB

017 CODE.html

0.3 KB

/19 - What Next/

001 Additional SQL Resources.html

2.7 KB

/20 - LEGACY Introduction and 5 Minutes of SQL/

001 Course Introduction.mp4

24.1 MB

001 Course Introduction_en.srt

2.3 KB

002 Instructor Introduction(s).mp4

30.7 MB

002 Instructor Introduction(s)_en.srt

2.8 KB

003 Syllabus Walkthrough and Prerequisites.mp4

43.2 MB

003 Syllabus Walkthrough and Prerequisites_en.srt

7.3 KB

004 Note about SQL Editor.html

0.5 KB

005 Lecture-Slides.url

0.1 KB

005 SQL-Try-It-Editor.url

0.1 KB

005 Your First 5 Minutes of SQL - Let's Get Coding!.mp4

49.2 MB

005 Your First 5 Minutes of SQL - Let's Get Coding!_en.srt

10.6 KB

006 CODE Your First 5 Minutes of SQL.html

1.6 KB

007 How The Course Works.mp4

81.8 MB

007 How The Course Works_en.srt

6.7 KB

external-links.txt

0.2 KB

/21 - LEGACY Getting Started Overview and Installation/

001 Section Introduction.mp4

12.6 MB

001 Section Introduction_en.srt

2.0 KB

002 Slides-For-This-Section.url

0.1 KB

002 What Is a Database.mp4

14.5 MB

002 What Is a Database_en.srt

11.0 KB

003 SQL Vs. MySQL.mp4

10.4 MB

003 SQL Vs. MySQL_en.srt

8.3 KB

004 Important note about the next lecture.html

0.3 KB

005 Installation Overview - WATCH BEFORE INSTALLING.mp4

8.9 MB

005 Installation Overview - WATCH BEFORE INSTALLING_en.srt

8.4 KB

005 Installation-Slides.url

0.1 KB

006 Goorm.io-Signup-Instructions.url

0.1 KB

006 Now using GoormIDE instead of Cloud9.mp4

19.2 MB

006 Now using GoormIDE instead of Cloud9_en.srt

5.6 KB

007 GoormIDE Registration IMPORTANT - PLEASE READ!!!.html

2.1 KB

008 Cheat-Sheet-for-MySQL-with-Goorm.url

0.1 KB

008 How-to-Run-MySQL-Code-from-a-File.url

0.1 KB

008 MySQL Tips to Make Your Life Easier.html

0.7 KB

009 Mac Installation.mp4

71.8 MB

009 Mac Installation_en.srt

18.6 KB

010 CODE Mac Installation.html

1.4 KB

011 Windows Installation.mp4

11.5 MB

011 Windows Installation_en.srt

6.5 KB

external-links.txt

0.4 KB

/22 - LEGACY Creating Databases and Tables/

001 Section 3 Introduction.mp4

13.9 MB

001 Section 3 Introduction_en.srt

2.1 KB

002 Creating Databases.mp4

11.0 MB

002 Creating Databases_en.srt

7.7 KB

002 Slides-For-This-Section-.url

0.1 KB

003 CODE Creating Databases.html

0.4 KB

004 Dropping Databases.mp4

7.7 MB

004 Dropping Databases_en.srt

2.8 KB

005 CODE Dropping Databases.html

0.3 KB

006 Using Databases.mp4

5.8 MB

006 Using Databases_en.srt

4.1 KB

007 CODE Using Databases.html

0.1 KB

008 Introduction to Tables.mp4

9.8 MB

008 Introduction to Tables_en.srt

8.1 KB

009 The Basic Datatypes.mp4

14.6 MB

009 The Basic Datatypes_en.srt

11.9 KB

010 Note about INT max size.html

0.4 KB

011 Basic Datatypes Challenge.mp4

5.1 MB

011 Basic Datatypes Challenge_en.srt

4.0 KB

012 Basic Datatypes Challenge - Solution.html

0.2 KB

013 Creating Your Own Tables.mp4

5.3 MB

013 Creating Your Own Tables_en.srt

4.6 KB

014 CODE Creating Your Own Tables.html

0.2 KB

015 How Do We Know It Worked.mp4

8.4 MB

015 How Do We Know It Worked_en.srt

3.9 KB

016 CODE How Do We Know It Worked.html

0.1 KB

017 Dropping Tables.mp4

2.9 MB

017 Dropping Tables_en.srt

2.5 KB

018 CODE Dropping Tables.html

0.2 KB

019 Creating Your Own Tables Challenge.mp4

9.0 MB

019 Creating Your Own Tables Challenge_en.srt

6.8 KB

019 Slides.url

0.1 KB

020 CODE Creating Your Own Tables Challenge.html

0.2 KB

external-links.txt

0.2 KB

/23 - LEGACY Inserting Data (and a couple other things)/

001 Section 4 Introduction.mp4

10.7 MB

001 Section 4 Introduction_en.srt

3.0 KB

002 Inserting Data.mp4

9.5 MB

002 Inserting Data_en.srt

7.4 KB

002 Slides-For-This-Section.url

0.1 KB

003 CODE Inserting Data.html

0.3 KB

004 Super Quick Intro To SELECT.mp4

4.0 MB

004 Super Quick Intro To SELECT_en.srt

3.3 KB

005 CODE Super Quick Intro To SELECT.html

0.0 KB

006 Multiple INSERT.mp4

6.1 MB

006 Multiple INSERT_en.srt

4.4 KB

007 CODE Multiple Insert.html

0.2 KB

008 INSERT Challenges.mp4

2.8 MB

008 INSERT Challenges_en.srt

2.3 KB

009 Note about using quotes inside of inserted values.html

0.5 KB

010 INSERT Challenges Solution.mp4

19.4 MB

010 INSERT Challenges Solution_en.srt

5.6 KB

011 CODE INSERT Challenges Solution.html

1.0 KB

012 NOTE MySQL Warnings.html

0.5 KB

013 MySQL Warnings.mp4

12.5 MB

013 MySQL Warnings_en.srt

7.6 KB

014 CODE MySQL Warnings.html

0.7 KB

015 NULL and NOT_NULL.mp4

14.6 MB

015 NULL and NOT_NULL_en.srt

9.2 KB

016 CODE NULL and NOT NULL.html

1.4 KB

017 Setting Default Values.mp4

15.8 MB

017 Setting Default Values_en.srt

9.0 KB

018 CODE Setting Default Values.html

1.5 KB

019 A Primer On Primary Keys.mp4

52.2 MB

019 A Primer On Primary Keys_en.srt

17.7 KB

020 CODE A Primer on Primary Keys.html

1.7 KB

021 Exercise-Slides.url

0.1 KB

021 Table Constraints Exercise.mp4

4.1 MB

021 Table Constraints Exercise_en.srt

3.4 KB

022 Table Constraints Exercise Solution.mp4

12.9 MB

022 Table Constraints Exercise Solution_en.srt

5.0 KB

023 CODE Table Constraints Exercise Solution.html

1.0 KB

external-links.txt

0.2 KB

/.../0. Websites you may like/

[CourseClub.Me].url

0.1 KB

[FreeCourseSite.com].url

0.1 KB

[GigaCourse.Com].url

0.0 KB

/24 - LEGACY CRUD commmands/

001 Section 5 Introduction.mp4

17.6 MB

001 Section 5 Introduction_en.srt

2.6 KB

002 Introduction to CRUD.mp4

2.9 MB

002 Introduction to CRUD_en.srt

2.6 KB

002 This-Sections-Slides.url

0.1 KB

003 CODE Introduction to CRUD.html

0.1 KB

004 Preparing Our Data.mp4

4.8 MB

004 Preparing Our Data_en.srt

4.0 KB

005 CODE Preparing Our Data.html

0.9 KB

006 Official Introduction to SELECT.mp4

8.4 MB

006 Official Introduction to SELECT_en.srt

5.6 KB

007 CODE Official Introduction to SELECT.html

0.7 KB

008 Introduction to WHERE.mp4

8.8 MB

008 Introduction to WHERE_en.srt

7.2 KB

009 CODE Introduction to WHERE.html

0.3 KB

010 SELECT Challenges.mp4

3.9 MB

010 SELECT Challenges_en.srt

3.1 KB

011 SELECT Challenges Solution.mp4

7.7 MB

011 SELECT Challenges Solution_en.srt

3.6 KB

012 CODE SELECT Challenges Solution.html

0.4 KB

013 Introduction to Aliases.mp4

5.2 MB

013 Introduction to Aliases_en.srt

4.1 KB

014 CODE Introduction to Aliases.html

0.2 KB

015 The UPDATE Command.mp4

8.5 MB

015 The UPDATE Command_en.srt

5.7 KB

016 CODE The UPDATE Command.html

0.3 KB

017 UPDATE Challenges.mp4

930.8 KB

017 UPDATE Challenges_en.srt

0.8 KB

018 UPDATE Challenges Solution.mp4

8.9 MB

018 UPDATE Challenges Solution_en.srt

4.9 KB

019 CODE UPDATE Challenges Solution.html

0.6 KB

020 Introduction to DELETE.mp4

8.5 MB

020 Introduction to DELETE_en.srt

7.2 KB

021 CODE Introduction to DELETE.html

0.3 KB

022 DELETE Challenges.mp4

2.1 MB

022 DELETE Challenges_en.srt

1.8 KB

022 Slides.url

0.1 KB

023 DELETE Challenges Solution.mp4

11.8 MB

023 DELETE Challenges Solution_en.srt

3.6 KB

024 CODE DELETE Challenges Solution.html

0.3 KB

external-links.txt

0.2 KB

/25 - LEGACY CRUD Challenge Section/

001 Section 6 Introduction.mp4

22.7 MB

001 Section 6 Introduction_en.srt

3.3 KB

002 CRUD Exercise Overview.mp4

31.3 MB

002 CRUD Exercise Overview_en.srt

11.7 KB

002 Slides.url

0.1 KB

003 CRUD Exercise Create Solution.mp4

15.8 MB

003 CRUD Exercise Create Solution_en.srt

8.0 KB

004 CODE CRUD Exercise Create Solution.html

0.8 KB

005 CRUD Exercise Read Solution.mp4

5.4 MB

005 CRUD Exercise Read Solution_en.srt

2.3 KB

006 CODE CRUD Exercise Read Solution.html

0.2 KB

007 CRUD Exercise Update Solution.mp4

9.9 MB

007 CRUD Exercise Update Solution_en.srt

5.5 KB

008 CODE CRUD Exercise Update Solution.html

0.7 KB

009 CRUD Exercise Delete Solution.mp4

7.4 MB

009 CRUD Exercise Delete Solution_en.srt

4.6 KB

010 CODE CRUD Exercise Delete Solution.html

0.4 KB

external-links.txt

0.1 KB

/26 - LEGACY The World Of String Functions/

001 Section 7 Introduction.mp4

10.2 MB

001 Section 7 Introduction_en.srt

3.4 KB

002 Important Note about Running SQL Files (please read).html

0.5 KB

003 Running SQL Files.mp4

26.9 MB

003 Running SQL Files_en.srt

14.7 KB

003 Slides-For-This-Section.url

0.1 KB

004 CODE Running SQL Files.html

0.4 KB

005 Loading Our Book Data.mp4

35.6 MB

005 Loading Our Book Data_en.srt

8.5 KB

005 book-data.sql

1.3 KB

006 CODE Loading Our Book Data.html

1.7 KB

007 Working with CONCAT.mp4

68.5 MB

007 Working with CONCAT_en.srt

16.3 KB

008 CODE Working With CONCAT.html

1.0 KB

009 Introducing SUBSTRING.mp4

44.4 MB

009 Introducing SUBSTRING_en.srt

14.1 KB

010 CODE Introducing SUBSTRING.html

0.8 KB

011 Introducing REPLACE.mp4

21.6 MB

011 Introducing REPLACE_en.srt

9.4 KB

012 CODE Introducing REPLACE.html

0.9 KB

013 Using REVERSE.mp4

8.4 MB

013 Using REVERSE_en.srt

5.1 KB

014 CODE Using REVERSE.html

0.3 KB

015 Working with CHAR LENGTH.mp4

25.6 MB

015 Working with CHAR LENGTH_en.srt

6.6 KB

016 CODE Working with CHAR LENGTH.html

0.3 KB

017 Changing Case with UPPER and LOWER.mp4

8.3 MB

017 Changing Case with UPPER and LOWER_en.srt

4.6 KB

018 CODE Changing Case with UPPER and LOWER.html

0.3 KB

019 Note about string functions.html

1.5 KB

020 Slides.url

0.1 KB

020 String Function Challenges.mp4

10.8 MB

020 String Function Challenges_en.srt

6.6 KB

021 String Function Challenges Solution.mp4

84.8 MB

021 String Function Challenges Solution_en.srt

17.1 KB

022 CODE String Function Challenges Solution.html

1.6 KB

external-links.txt

0.2 KB

/27 - LEGACY Refining Our Selections/

001 Section 8 Introduction.mp4

7.1 MB

001 Section 8 Introduction_en.srt

1.1 KB

002 Seed Data Adding A Couple New Books.mp4

5.8 MB

002 Seed Data Adding A Couple New Books_en.srt

4.6 KB

002 Slides-For-This-Section.url

0.1 KB

003 CODE Seed Data Adding A Couple New Books.html

0.4 KB

004 Using DISTINCT.mp4

44.0 MB

004 Using DISTINCT_en.srt

12.2 KB

005 CODE Using DISTINCT.html

0.3 KB

006 Sorting Data with ORDER BY.mp4

33.9 MB

006 Sorting Data with ORDER BY_en.srt

15.7 KB

007 CODE Sorting Data with ORDER BY.html

1.0 KB

008 Using LIMIT.mp4

56.8 MB

008 Using LIMIT_en.srt

13.7 KB

009 CODE Using LIMIT.html

0.9 KB

010 Better Searches with LIKE.mp4

31.1 MB

010 Better Searches with LIKE_en.srt

11.1 KB

011 CODE Better Searches with LIKE.html

0.3 KB

012 LIKE Part 2 More Wildcards.mp4

27.2 MB

012 LIKE Part 2 More Wildcards_en.srt

9.4 KB

013 CODE LIKE Part 2 More Wildcards.html

0.4 KB

014 Refining Selections Exercises.mp4

14.8 MB

014 Refining Selections Exercises_en.srt

7.6 KB

014 Slides.url

0.1 KB

015 Refining Selections Exercises Solution.mp4

76.8 MB

015 Refining Selections Exercises Solution_en.srt

17.5 KB

016 CODE Refining Selections Exercises Solution.html

0.8 KB

external-links.txt

0.2 KB

/28 - LEGACY The Magic of Aggregate Functions/

001 Section 9 Introduction.mp4

19.6 MB

001 Section 9 Introduction_en.srt

6.4 KB

002 Slides-For-This-Section.url

0.1 KB

002 The Count Function.mp4

18.1 MB

002 The Count Function_en.srt

12.7 KB

003 CODE The Count Function.html

0.4 KB

004 The Joys of Group By.mp4

27.8 MB

004 The Joys of Group By_en.srt

18.6 KB

005 Note about SQL Mode only_full_group_by.mp4

28.2 MB

005 Note about SQL Mode only_full_group_by_en.srt

7.3 KB

006 CODE The Joys of Group By.html

0.7 KB

007 Min and Max Basics.mp4

15.7 MB

007 Min and Max Basics_en.srt

5.9 KB

008 CODE MIN and MAX Basics.html

0.3 KB

009 SUBQUERIES - A Problem with Min and Max.mp4

16.9 MB

009 SUBQUERIES - A Problem with Min and Max_en.srt

9.7 KB

010 CODE A Problem with Min and Max.html

0.5 KB

011 Using Min and Max with Group By.mp4

15.4 MB

011 Using Min and Max with Group By_en.srt

9.2 KB

012 CODE Using Min and Max with Group By.html

0.5 KB

013 The Sum Function.mp4

10.0 MB

013 The Sum Function_en.srt

6.0 KB

014 CODE The Sum Function.html

0.4 KB

015 The Avg Function.mp4

13.2 MB

015 The Avg Function_en.srt

8.9 KB

016 CODE The Avg Function.html

0.4 KB

017 Aggregate Functions Challenges.mp4

7.8 MB

017 Aggregate Functions Challenges_en.srt

6.3 KB

017 Slides.url

0.1 KB

018 Aggregate Functions Challenges Solution.mp4

50.4 MB

018 Aggregate Functions Challenges Solution_en.srt

11.8 KB

019 CODE Aggregate Functions Challenges Solution.html

0.8 KB

external-links.txt

0.2 KB

/29 - LEGACY Revisiting Data Types/

001 Section 10 Introduction.mp4

12.3 MB

001 Section 10 Introduction_en.srt

3.3 KB

002 CHAR and VARCHAR.mp4

38.0 MB

002 CHAR and VARCHAR_en.srt

21.1 KB

002 Slides-For-This-Section.url

0.1 KB

003 Note about CHAR and VARCHAR.html

0.4 KB

004 CODE CHAR and VARCHAR.html

0.4 KB

005 DECIMAL.mp4

28.7 MB

005 DECIMAL_en.srt

8.3 KB

006 CODE DECIMAL.html

0.3 KB

007 FLOAT and DOUBLE.mp4

33.3 MB

007 FLOAT and DOUBLE_en.srt

10.6 KB

008 CODE FLOAT and DOUBLE.html

0.3 KB

009 Note about setting the timezone in Cloud9.html

0.4 KB

010 DATE, TIME, and DATETIME.mp4

7.1 MB

010 DATE, TIME, and DATETIME_en.srt

6.8 KB

011 Creating Our DATE data.mp4

14.0 MB

011 Creating Our DATE data_en.srt

7.4 KB

012 CODE Creating Our DATE data.html

0.4 KB

013 CURDATE, CURTIME, and NOW.mp4

13.8 MB

013 CURDATE, CURTIME, and NOW_en.srt

8.0 KB

014 Note about formatting dates.html

0.3 KB

015 Formatting Dates.mp4

90.0 MB

015 Formatting Dates_en.srt

19.8 KB

016 CODE Formatting Dates.html

1.0 KB

017 Date Math.mp4

70.4 MB

017 Date Math_en.srt

12.8 KB

018 CODE Date Math.html

0.6 KB

019 Working with TIMESTAMPS.mp4

65.3 MB

019 Working with TIMESTAMPS_en.srt

15.6 KB

020 CODE Working with TIMESTAMPS.html

1.0 KB

021 Data Types Exercises.mp4

9.6 MB

021 Data Types Exercises_en.srt

7.2 KB

021 Slides.url

0.1 KB

022 Data Types Exercises Solution.mp4

89.1 MB

022 Data Types Exercises Solution_en.srt

19.5 KB

023 CODE Data Types Exercises Solution.html

1.2 KB

external-links.txt

0.2 KB

/.../0. Websites you may like/

[CourseClub.Me].url

0.1 KB

[FreeCourseSite.com].url

0.1 KB

[GigaCourse.Com].url

0.0 KB

/30 - LEGACY The Power of Logical Operators/

001 Section 11 Introduction.mp4

17.4 MB

001 Section 11 Introduction_en.srt

4.9 KB

002 Not Equal.mp4

12.5 MB

002 Not Equal_en.srt

6.1 KB

002 Slides-For-This-Section.url

0.1 KB

003 CODE Not Equal.html

0.3 KB

004 Not Like.mp4

5.6 MB

004 Not Like_en.srt

3.5 KB

005 CODE Not Like.html

0.3 KB

006 Greater Than.mp4

45.1 MB

006 Greater Than_en.srt

14.7 KB

007 CODE Greater Than.html

0.9 KB

008 Less Than.mp4

9.0 MB

008 Less Than_en.srt

6.0 KB

009 CODE Less Than.html

0.4 KB

010 Logical AND.mp4

46.8 MB

010 Logical AND_en.srt

14.8 KB

011 CODE Logical AND.html

1.4 KB

012 Logical OR.mp4

16.1 MB

012 Logical OR_en.srt

9.4 KB

013 CODE Logical OR.html

1.3 KB

014 Between.mp4

56.6 MB

014 Between_en.srt

14.7 KB

015 CODE Between.html

0.6 KB

016 In And Not In.mp4

36.0 MB

016 In And Not In_en.srt

16.6 KB

017 CODE In And Not In.html

1.2 KB

018 Case Statements.mp4

34.9 MB

018 Case Statements_en.srt

17.0 KB

019 CODE Case Statements.html

1.1 KB

020 Logical Operators Exercises.mp4

21.1 MB

020 Logical Operators Exercises_en.srt

10.7 KB

020 Slides.url

0.1 KB

021 Logical Operators Exercises Solution.mp4

121.8 MB

021 Logical Operators Exercises Solution_en.srt

24.7 KB

022 CODE Logical Operators Exercises Solution.html

1.5 KB

external-links.txt

0.2 KB

/31 - LEGACY Section 12 One To Many/

001 Section 12 Introduction.mp4

42.8 MB

001 Section 12 Introduction_en.srt

3.1 KB

002 Real World Data Is Messy.mp4

26.1 MB

002 Real World Data Is Messy_en.srt

16.7 KB

002 Slides-For-This-Section.url

0.1 KB

003 Types of Data Relationships.mp4

8.8 MB

003 Types of Data Relationships_en.srt

7.1 KB

004 One To Many The Basics.mp4

35.4 MB

004 One To Many The Basics_en.srt

19.3 KB

005 Working With Foreign Keys.mp4

91.8 MB

005 Working With Foreign Keys_en.srt

17.8 KB

006 CODE Working With Foreign Keys.html

1.4 KB

007 Cross Join.mp4

28.8 MB

007 Cross Join_en.srt

11.5 KB

008 CODE Cross Joins.html

0.6 KB

009 Inner Join.mp4

115.0 MB

009 Inner Join_en.srt

18.0 KB

010 CODE Inner Joins.html

1.2 KB

011 Left Join.mp4

109.0 MB

011 Left Join_en.srt

23.5 KB

012 CODE Left Joins.html

1.3 KB

013 Right Joins Pt 1.mp4

37.7 MB

013 Right Joins Pt 1_en.srt

14.6 KB

014 CODE Right Joins Part 1.html

1.6 KB

015 Right Joins Pt 2.mp4

46.1 MB

015 Right Joins Pt 2_en.srt

14.0 KB

016 CODE Right Joins Part 2.html

1.6 KB

017 Right and Left Joins A Common Question.mp4

12.5 MB

017 Right and Left Joins A Common Question_en.srt

4.4 KB

018 CODE Right and Left Joins FAQ.html

0.7 KB

019 Our First Joins Exercise.mp4

22.0 MB

019 Our First Joins Exercise_en.srt

11.1 KB

019 Slides.url

0.1 KB

020 Our First Joins Exercise SOLUTION.mp4

71.7 MB

020 Our First Joins Exercise SOLUTION_en.srt

12.9 KB

021 CODE Our First Joins Exercise.html

0.8 KB

022 Our First Joins Exercise SOLUTION PT. 2.mp4

39.0 MB

022 Our First Joins Exercise SOLUTION PT. 2_en.srt

13.4 KB

023 CODE Our First Joins Exercise SOLUTION PT. 2.html

1.8 KB

external-links.txt

0.2 KB

/32 - LEGACY Many To Many/

001 Section 13 Introduction.mp4

12.2 MB

001 Section 13 Introduction_en.srt

3.2 KB

002 Many To Many Basics.mp4

25.4 MB

002 Many To Many Basics_en.srt

16.4 KB

002 Slides.url

0.1 KB

003 Creating Our Tables.mp4

62.9 MB

003 Creating Our Tables_en.srt

15.2 KB

004 CODE Creating Our Tables.html

2.5 KB

005 TV Joins Challenge 1.mp4

18.2 MB

005 TV Joins Challenge 1_en.srt

7.3 KB

006 CODE TV Joins Challenge 1 Solution.html

0.2 KB

007 TV Joins Challenge 2.mp4

23.5 MB

007 TV Joins Challenge 2_en.srt

9.7 KB

008 CODE TV Joins Challenge 2 SOLUTION.html

0.2 KB

009 TV Joins Challenge 3.mp4

22.6 MB

009 TV Joins Challenge 3_en.srt

6.5 KB

010 CODE TV Joins Challenge 3 SOLUTION.html

0.4 KB

011 TV Joins Challenge 4.mp4

24.7 MB

011 TV Joins Challenge 4_en.srt

8.3 KB

012 CODE TV Joins Challenge 4 SOLUTION.html

0.2 KB

013 TV Joins Challenge 5.mp4

28.8 MB

013 TV Joins Challenge 5_en.srt

6.9 KB

014 CODE TV Joins Challenge 5 SOLUTION.html

0.3 KB

015 TV Joins Challenge 6.mp4

73.9 MB

015 TV Joins Challenge 6_en.srt

17.0 KB

016 CODE TV Joins Challenge 6 SOLUTION.html

1.3 KB

017 TV Joins Challenge 7.mp4

55.6 MB

017 TV Joins Challenge 7_en.srt

10.0 KB

018 CODE TV Joins Challenge 7 SOLUTION.html

0.3 KB

external-links.txt

0.1 KB

/33 - LEGACY Instagram Database Clone/

001 Section 14 Introduction.mp4

16.1 MB

001 Section 14 Introduction_en.srt

2.2 KB

002 Introduction To Instagram Clone Schema.mp4

64.1 MB

002 Introduction To Instagram Clone Schema_en.srt

13.7 KB

002 Slides-For-This-Section.url

0.1 KB

003 Cloning Instagram's DB Users Schema.mp4

15.1 MB

003 Cloning Instagram's DB Users Schema_en.srt

8.9 KB

004 CODE IG Clone Users Schema.html

0.2 KB

005 Cloning Instagram's DB Photos Schema.mp4

22.2 MB

005 Cloning Instagram's DB Photos Schema_en.srt

9.0 KB

006 CODE IG Clone Photos Schema.html

0.3 KB

007 Cloning Instagram's DB Comments Schema.mp4

23.8 MB

007 Cloning Instagram's DB Comments Schema_en.srt

8.8 KB

008 CODE IG Clone Comments Schema.html

0.4 KB

009 Cloning Instagram's DB Likes Schema.mp4

67.2 MB

009 Cloning Instagram's DB Likes Schema_en.srt

10.5 KB

010 CODE IG Clone Likes Schema.html

0.3 KB

011 Cloning Instagram's DB Followers Schema.mp4

49.1 MB

011 Cloning Instagram's DB Followers Schema_en.srt

10.9 KB

012 CODE IG Clone Followers Schema.html

0.3 KB

013 Note about Cloning Instagram's DB Hashtags Part 1.html

0.4 KB

014 Cloning Instagram's DB Hashtags Part 1.mp4

34.2 MB

014 Cloning Instagram's DB Hashtags Part 1_en.srt

15.6 KB

015 Cloning Instagram's DB Hashtags Part 2.mp4

24.2 MB

015 Cloning Instagram's DB Hashtags Part 2_en.srt

7.7 KB

016 CODE IG Clone Hashtags Schema.html

0.4 KB

017 CODE Complete IG Clone Schema.html

1.7 KB

external-links.txt

0.1 KB

/34 - LEGACY Working With Lots Of Instagram Data/

001 Section 15 Introduction.mp4

10.9 MB

001 Section 15 Introduction_en.srt

2.9 KB

002 Note about Loading The JUMBO dataset.html

0.7 KB

003 Loading The JUMBO dataset.mp4

112.5 MB

003 Loading The JUMBO dataset_en.srt

12.9 KB

004 The Instagram Clone DATASET.html

0.4 KB

004 ig-clone-data.sql

439.7 KB

005 Instagram Clone Challenge 1.mp4

11.3 MB

005 Instagram Clone Challenge 1_en.srt

7.3 KB

005 Slides.url

0.1 KB

006 Instagram Challenge 1 Solution CODE.html

0.1 KB

007 Instagram Clone Challenge 2.mp4

35.2 MB

007 Instagram Clone Challenge 2_en.srt

10.7 KB

008 Instagram Challenge 2 Solution CODE.html

0.2 KB

009 Instagram Clone Challenge 3.mp4

26.8 MB

009 Instagram Clone Challenge 3_en.srt

11.2 KB

010 Instagram Challenge 3 Solution CODE.html

0.2 KB

011 Instagram Clone Challenge 4.mp4

26.3 MB

011 Instagram Clone Challenge 4_en.srt

9.5 KB

012 Instagram Challenge 4 Solution CODE.html

0.4 KB

013 Instagram Clone Challenge 5.mp4

8.8 MB

013 Instagram Clone Challenge 5_en.srt

4.8 KB

014 Instagram Challenge 5 Solution CODE.html

0.2 KB

015 Instagram Clone Challenge 6.mp4

16.1 MB

015 Instagram Clone Challenge 6_en.srt

7.2 KB

016 Instagram Challenge 6 Solution CODE.html

0.2 KB

017 Note about Instagram Clone Challenge 7.html

0.4 KB

018 Instagram Clone Challenge 7.mp4

18.8 MB

018 Instagram Clone Challenge 7_en.srt

7.4 KB

019 Instagram Challenge 7 Solution CODE.html

0.4 KB

external-links.txt

0.1 KB

/35 - LEGACY Introducing Node/

001 Note about Introducing Node.html

0.4 KB

002 Section 16 Introduction.mp4

19.5 MB

002 Section 16 Introduction_en.srt

2.7 KB

003 MySQL and Other Languages.mp4

15.2 MB

003 MySQL and Other Languages_en.srt

14.8 KB

003 Slides-For-This-Section.url

0.1 KB

004 BUT WHAT ABOUT PHP.mp4

33.3 MB

004 BUT WHAT ABOUT PHP_en.srt

11.8 KB

005 Introduction to JOIN US app.mp4

19.0 MB

005 Introduction to JOIN US app_en.srt

13.0 KB

006 Note about Setting Up Cloud9 for Node.html

0.8 KB

007 5 Minute NodeJS Crash Course.mp4

14.7 MB

007 5 Minute NodeJS Crash Course_en.srt

9.5 KB

008 CODE 5 Minute Node Crash Course.html

0.3 KB

009 Note about Faker install.html

3.3 KB

010 FakerJS-Github-Repo.url

0.1 KB

010 Introduction to NPM and Faker.mp4

46.0 MB

010 Introduction to NPM and Faker_en.srt

14.2 KB

011 CODE Introduction to NPM and Faker.html

1.5 KB

012 Introducing the MySQL Package.mp4

9.3 MB

012 Introducing the MySQL Package_en.srt

7.6 KB

012 MySQL-Node-Package-Github-Repo.url

0.1 KB

013 Note about connecting Node to MySQL.html

3.8 KB

014 Connecting Node to MySQL.mp4

75.9 MB

014 Connecting Node to MySQL_en.srt

19.2 KB

015 CODE Connecting Node to MySQL.html

2.6 KB

016 Creating Our Users Table.mp4

24.4 MB

016 Creating Our Users Table_en.srt

10.8 KB

017 CODE Creating Our Users Table.html

0.2 KB

018 Selecting Using Node.mp4

22.9 MB

018 Selecting Using Node_en.srt

9.3 KB

019 CODE Selecting Using Node.html

0.9 KB

020 Inserting Using Node.mp4

43.2 MB

020 Inserting Using Node_en.srt

17.5 KB

021 CODE Inserting Using Node.html

0.8 KB

022 Some MySQLNode Magic.mp4

69.1 MB

022 Some MySQLNode Magic_en.srt

11.1 KB

023 Bulk Inserting 500 Users - Finally!.mp4

33.3 MB

023 Bulk Inserting 500 Users - Finally!_en.srt

13.6 KB

024 CODE Bulk Inserting 500 Users.html

0.6 KB

025 500 Users Exercises.mp4

4.8 MB

025 500 Users Exercises_en.srt

4.2 KB

025 Slides.url

0.1 KB

026 500 Users Exercises Solutions.mp4

73.1 MB

026 500 Users Exercises Solutions_en.srt

16.3 KB

027 CODE 500 Users Exercises Solutions.html

1.5 KB

external-links.txt

0.3 KB

/36 - LEGACY Building Our Web App/

001 Section 17 Introduction.mp4

12.0 MB

001 Section 17 Introduction_en.srt

3.4 KB

002 Join Us Completed CODE.html

0.3 KB

002 JoinUsCompleteCode.zip

3.9 MB

003 Express-Documentation.url

0.0 KB

003 Introducing Express.mp4

32.8 MB

003 Introducing Express_en.srt

9.9 KB

003 Slides.url

0.1 KB

004 NPM Init and package.json files.mp4

20.8 MB

004 NPM Init and package.json files_en.srt

10.3 KB

005 Note about Our First Simple Web App.html

0.5 KB

006 Our First Simple Web App.mp4

50.0 MB

006 Our First Simple Web App_en.srt

26.1 KB

007 CODE Our First Simple Web App.html

0.4 KB

008 Adding Multiple Routes.mp4

35.4 MB

008 Adding Multiple Routes_en.srt

15.7 KB

009 CODE Adding Multiple Routes.html

0.5 KB

010 Connecting Express and MySQL.mp4

78.0 MB

010 Connecting Express and MySQL_en.srt

16.1 KB

011 CODE Connecting Express and MySQL.html

0.4 KB

012 Adding EJS Templates.mp4

118.3 MB

012 Adding EJS Templates_en.srt

25.3 KB

013 CODE Adding EJS Templates.html

0.6 KB

013 JOIN-US-HTML-AND-CSS.zip

2.8 KB

014 Connecting The Form.mp4

77.1 MB

014 Connecting The Form_en.srt

28.7 KB

015 CODE Connecting the Form.html

0.4 KB

016 Styling Part 1.mp4

58.4 MB

016 Styling Part 1_en.srt

13.4 KB

017 CODE HTML AND CSS FILES.html

0.1 KB

017 JOIN-US-HTML-AND-CSS.zip

2.8 KB

018 Styling Part 2.mp4

88.4 MB

018 Styling Part 2_en.srt

12.6 KB

external-links.txt

0.1 KB

/.../0. Websites you may like/

[CourseClub.Me].url

0.1 KB

[FreeCourseSite.com].url

0.1 KB

[GigaCourse.Com].url

0.0 KB

/37 - LEGACY Database Triggers/

001 Introduction to Database Triggers.mp4

11.8 MB

001 Introduction to Database Triggers_en.srt

10.4 KB

001 Lecture-Slides.url

0.1 KB

002 Lecture-Slides.url

0.1 KB

002 Writing Our First Trigger Part 1.mp4

19.2 MB

002 Writing Our First Trigger Part 1_en.srt

11.2 KB

003 Lecture-Slides.url

0.1 KB

003 Writing Our First Trigger Part 2.mp4

55.7 MB

003 Writing Our First Trigger Part 2_en.srt

17.6 KB

004 Note about next lecture.html

0.6 KB

005 Lecture-Slides.url

0.1 KB

005 Preventing Instagram Self-Follows With Triggers.mp4

32.4 MB

005 Preventing Instagram Self-Follows With Triggers_en.srt

12.4 KB