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-12-21 23:49
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
006 Creating Logger Triggers.mp4	41.0 MB
006 Creating Logger Triggers_en.srt	14.6 KB
006 Lecture-Slides.url	0.1 KB
007 Lecture-Slides.url	0.1 KB
007 Managing Triggers And A Warning.mp4	46.4 MB
007 Managing Triggers And A Warning_en.srt	9.7 KB
external-links.txt	0.5 KB
/38 - Additional Resources/
001 Links to Additional SQL Learning Resources.html	2.7 KB
Total files 1147