Udemy - The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert
Language: English
Files Type: mp4, zip, srt, html, sql| Size: 9.02 GB
Video: 36:32:17 |  1280X720 | 844 Kbps
Audio: mp4a-40-2 | 62 Kbps | AAC
Genre:eLearning

Videos Files :
001 This Course Was Just Updated!.mp4 (17.06 MB)
002 Course Intro.mp4 (5.41 MB)
003 About Me.mp4 (8.62 MB)
004 Getting The Course Code.mp4 (4.77 MB)
005 First 5 Minutes of SQL.mp4 (40.56 MB)
001 Section Introduction.mp4 (11.79 MB)
002 What Is A Database.mp4 (13.85 MB)
003 SQL vs. MySQL.mp4 (9.88 MB)
004 Installation START HERE!.mp4 (31.26 MB)
005 Installation Windows Instructions.mp4 (34.19 MB)
006 Installation Mac Instructions.mp4 (40.57 MB)
001 Section Introduction.mp4 (13.11 MB)
002 Showing Databases.mp4 (6.53 MB)
004 Creating Databases.mp4 (9.03 MB)
006 Dropping and Using Databases.mp4 (10.25 MB)
008 Introducing Tables.mp4 (21.37 MB)
009 Data Types The Basics.mp4 (21.37 MB)
010 Basic Datatypes Challenge.mp4 (4.86 MB)
012 Creating Tables.mp4 (8.07 MB)
014 How Do We Know It Worked.mp4 (11.9 MB)
016 Dropping Tables.mp4 (4.54 MB)
018 Tables Basics Activity.mp4 (5.64 MB)
020 MySQL Comments.mp4 (5.63 MB)
001 Section Introduction.mp4 (10.25 MB)
002 INSERT The Basics.mp4 (6.19 MB)
004 A Quick Preview of SELECT.mp4 (3.91 MB)
006 Multi-inserts.mp4 (10.06 MB)
008 INSERT Exercise.mp4 (29.09 MB)
010 Working With NOT NULL.mp4 (17.7 MB)
012 Sidenote Quotes In MySQL.mp4 (7.28 MB)
013 Adding DEFAULT Values.mp4 (15.42 MB)
015 Introducing Primary Keys.mp4 (10.32 MB)
017 Working With AUTO INCREMENT.mp4 (29.6 MB)
019 Create Table Insert Exercise.mp4 (45.22 MB)
001 Section Introduction.mp4 (16.49 MB)
002 Introducing CRUD.mp4 (2.2 MB)
003 Getting Our New Dataset.mp4 (2.77 MB)
005 Officially Introducing SELECT.mp4 (10.54 MB)
007 The WHERE clause.mp4 (5.25 MB)
009 Rapid Fire Exercises.mp4 (8.5 MB)
010 Rapid Fire Exercises SOLUTION.mp4 (7.06 MB)
012 Aliases.mp4 (3.01 MB)
014 Using UPDATE.mp4 (10.01 MB)
016 A Quick Rule Of Thumb.mp4 (2.14 MB)
017 UPDATE Exercise.mp4 (1.36 MB)
018 UPDATE Exercise SOLUTION.mp4 (4.67 MB)
020 Introducing DELETE.mp4 (7.6 MB)
022 DELETE Exercise.mp4 (1.46 MB)
023 DELETE Exercise SOLUTION.mp4 (3.21 MB)
001 Section Introduction.mp4 (21.41 MB)
002 Introducing the CRUD Challenge.mp4 (7.16 MB)
003 CRUD Challenge Solution Creating.mp4 (38.66 MB)
005 CRUD Challenge Solution Reading.mp4 (4.26 MB)
007 CRUD Challenge Solution Updating.mp4 (11.2 MB)
009 CRUD Challenge Solution Deleting.mp4 (5.09 MB)
001 Section Introduction.mp4 (9.74 MB)
002 The World Of String Functions.mp4 (7.87 MB)
003 Loading Our Books Data.mp4 (36.37 MB)
005 CONCAT.mp4 (17.93 MB)
007 SUBSTRING.mp4 (26.19 MB)
009 Combining String Functions.mp4 (15.65 MB)
011 Sidenote SQL Formatting.mp4 (16.55 MB)
012 REPLACE.mp4 (20.98 MB)
014 REVERSE.mp4 (7.95 MB)
016 CHAR LENGTH.mp4 (7.76 MB)
018 UPPER & LOWER.mp4 (15.01 MB)
020 Other String Functions.mp4 (19.05 MB)
022 String Functions Exercise.mp4 (8.64 MB)
023 String Functions Exerise SOLUTION.mp4 (58.79 MB)
001 Section Introduction.mp4 (6.75 MB)
002 Adding Some New Books.mp4 (2.1 MB)
004 DISTINCT.mp4 (10.49 MB)
006 ORDER BY.mp4 (38.37 MB)
008 More On ORDER BY.mp4 (23.68 MB)
010 LIMIT.mp4 (24.13 MB)
012 LIKE.mp4 (27.24 MB)
014 Escaping Wildcards.mp4 (4.84 MB)
016 Refining Selections Exercise.mp4 (8.81 MB)
017 Refining Selections Exercise SOLUTION.mp4 (75.38 MB)
001 Section Introduction.mp4 (18.71 MB)
002 Count Basics.mp4 (21.12 MB)
004 GROUP BY.mp4 (42.71 MB)
006 MIN and MAX Basics.mp4 (5.03 MB)
008 Subqueries.mp4 (21.83 MB)
010 Grouping By Multiple Columns.mp4 (12.21 MB)
012 MIN and MAX With GROUP BY.mp4 (19.9 MB)
014 SUM.mp4 (13.24 MB)
016 AVG.mp4 (3.98 MB)
018 Aggregate Functions Docs.mp4 (10.28 MB)
019 Agg Functions Exercise.mp4 (4.07 MB)
020 Agg Functions Exercise SOLUTION.mp4 (35.13 MB)
001 Section Introduction.mp4 (11.77 MB)
002 Surveying Other Data Types.mp4 (15.46 MB)
003 CHAR vs. VARCHAR.mp4 (28.46 MB)
004 INT, TINYINT, BIGINT, etc.mp4 (20.63 MB)
005 DECIMAL.mp4 (9.91 MB)
006 FLOAT & DOUBLE.mp4 (12.29 MB)
007 DATE and TIME.mp4 (12.81 MB)
008 Working With Dates.mp4 (49.82 MB)
010 CURDATE, CURTIME, & NOW.mp4 (23.98 MB)
012 Date Functions.mp4 (39.76 MB)
014 Time Functions.mp4 (9.25 MB)
016 Formatting Dates.mp4 (55.83 MB)
018 Date Math.mp4 (57.65 MB)
019 TIMESTAMPS.mp4 (18.65 MB)
020 DEFAULT & ON UPDATE TIMESTAMPS.mp4 (39.74 MB)
022 Data Types Exercise.mp4 (5.21 MB)
023 Data Types Exercise SOLUTION.mp4 (41.79 MB)
001 Section Introduction.mp4 (16.6 MB)
002 Not Equal.mp4 (5.18 MB)
004 NOT LIKE.mp4 (8.23 MB)
006 Greater Than.mp4 (9.76 MB)
008 Less Than Or Equal To.mp4 (7.93 MB)
010 Logical AND.mp4 (27.38 MB)
012 Logical OR.mp4 (31 MB)
014 Between.mp4 (13.71 MB)
016 Comparing Dates.mp4 (46.99 MB)
018 The IN Operator.mp4 (53.38 MB)
020 CASE.mp4 (46.31 MB)
022 IS NULL.mp4 (7.48 MB)
023 Exercise.mp4 (7.18 MB)
024 Exercise SOLUTION.mp4 (81.97 MB)
001 UNIQUE Constraint.mp4 (6.46 MB)
003 CHECK Constraints.mp4 (12.43 MB)
005 Named Constraints.mp4 (13.07 MB)
007 Multiple Column Constraints.mp4 (22.68 MB)
009 ALTER TABLE  Adding Columns.mp4 (27.3 MB)
011 ALTER TABLE  Dropping Columns.mp4 (11.48 MB)
013 ALTER TABLE  Renaming.mp4 (15.16 MB)
015 ALTER TABLE  Modifying Columns.mp4 (9.69 MB)
017 ALTER TABLE  Constraints.mp4 (21.83 MB)
001 Section Introduction.mp4 (11.92 MB)
002 Data is Messy.mp4 (24.9 MB)
003 Relationships Basics.mp4 (8.37 MB)
004 One to Many Relationship.mp4 (33.77 MB)
005 Working with FOREIGN KEY.mp4 (47.66 MB)
007 Cross Joins.mp4 (54.82 MB)
009 Inner Joins.mp4 (50.91 MB)
011 Inner Joins With Group By.mp4 (20.72 MB)
013 Left Join.mp4 (37.51 MB)
015 Left Join With Group By.mp4 (12.19 MB)
017 Right Join.mp4 (10.21 MB)
019 On Delete Cascade.mp4 (20.91 MB)
021 Joins Exercise.mp4 (6.18 MB)
023 Joins Exercise SOLUTION.mp4 (37.31 MB)
001 Section Introduction.mp4 (11.63 MB)
002 Many to Many Basics.mp4 (24.21 MB)
003 Creating Our Many To Many Tables.mp4 (33.09 MB)
005 TV Series Challenge #1.mp4 (17.77 MB)
007 TV Series Challenge #2.mp4 (9.64 MB)
009 TV Series Challenge #3.mp4 (17.88 MB)
011 TV Series Challenge #4.mp4 (19.01 MB)
013 TV Series Challenge #5.mp4 (8.52 MB)
015 TV Series Challenge #6.mp4 (59.67 MB)
017 TV Series Challenge #7.mp4 (31.14 MB)
001 Introducing Views.mp4 (28.97 MB)
003 Updateable Views.mp4 (31.56 MB)
004 ReplacingAltering Views.mp4 (23.34 MB)
006 HAVING clause.mp4 (29.31 MB)
008 WITH ROLLUP.mp4 (40.87 MB)
010 SQL Modes Basics.mp4 (36.91 MB)
012 STRICT TRANS TABLES.mp4 (16.81 MB)
013 More Modes.mp4 (19.18 MB)
001 Introducing Window Functions.mp4 (36.05 MB)
002 Using OVER().mp4 (26.07 MB)
004 PARTITION BY.mp4 (33.93 MB)
006 ORDER BY with Windows.mp4 (34.8 MB)
008 RANK().mp4 (19.75 MB)
009 DENSE RANK, & ROW NUMBER().mp4 (38.49 MB)
011 NTILE().mp4 (19.62 MB)
013 FIRST VALUE.mp4 (15.75 MB)
015 LEAD and LAG.mp4 (30.98 MB)
001 Section Introduction.mp4 (15.22 MB)
002 IMPORTANT NOTE ABOUT THIS SECTION!.mp4 (14.26 MB)
003 Introducing Instagram Clone.mp4 (61.16 MB)
004 Users Schema.mp4 (14.42 MB)
006 Photos Schema.mp4 (21.15 MB)
008 Comments Schema.mp4 (22.66 MB)
010 Likes Schema.mp4 (64.17 MB)
012 Followers Schema.mp4 (22.21 MB)
015 3 Approaches for Hashtags.mp4 (32.63 MB)
016 Implementing Hashtags Table.mp4 (23.12 MB)
001 Section Introduction.mp4 (10.34 MB)
002 Getting Lots of Instagram Data.mp4 (107.14 MB)
004 Instagram Challenge #1.mp4 (10.79 MB)
006 Instagram Challenge #2.mp4 (38.22 MB)
008 Instagram Challenge #3.mp4 (25.52 MB)
010 Instagram Challenge #4.mp4 (25.09 MB)
012 Instagram Challenge #5.mp4 (8.35 MB)
014 Instagram Challenge #6.mp4 (15.33 MB)
016 Instagram Challenge #7.mp4 (17.91 MB)
001 Course Introduction.mp4 (22.99 MB)
002 Instructor Introduction(s).mp4 (29.28 MB)
003 Syllabus Walkthrough and Prerequisites.mp4 (41.22 MB)
005 Your First 5 Minutes of SQL - Let's Get Coding!.mp4 (46.96 MB)
007 How The Course Works.mp4 (78.05 MB)
001 Section Introduction.mp4 (12.01 MB)
002 What Is a Database.mp4 (13.85 MB)
003 SQL Vs. MySQL.mp4 (9.88 MB)
005 Installation Overview - WATCH BEFORE INSTALLING.mp4 (8.45 MB)
006 Now using GoormIDE instead of Cloud9.mp4 (18.35 MB)
009 Mac Installation.mp4 (68.46 MB)
011 Windows Installation.mp4 (10.95 MB)
001 Section 3 Introduction.mp4 (13.23 MB)
002 Creating Databases.mp4 (10.53 MB)
004 Dropping Databases.mp4 (7.39 MB)
006 Using Databases.mp4 (5.52 MB)
008 Introduction to Tables.mp4 (9.38 MB)
009 The Basic Datatypes.mp4 (13.95 MB)
011 Basic Datatypes Challenge.mp4 (4.86 MB)
013 Creating Your Own Tables.mp4 (5.09 MB)
015 How Do We Know It Worked.mp4 (7.98 MB)
017 Dropping Tables.mp4 (2.73 MB)
019 Creating Your Own Tables Challenge.mp4 (8.55 MB)
001 Section 4 Introduction.mp4 (10.23 MB)
002 Inserting Data.mp4 (9.09 MB)
004 Super Quick Intro To SELECT.mp4 (3.8 MB)
006 Multiple INSERT.mp4 (5.82 MB)
008 INSERT Challenges.mp4 (2.69 MB)
010 INSERT Challenges Solution.mp4 (18.5 MB)
013 MySQL Warnings.mp4 (11.88 MB)
015 NULL and NOT NULL.mp4 (13.96 MB)
017 Setting Default Values.mp4 (15.02 MB)
019 A Primer On Primary Keys.mp4 (49.75 MB)
021 Table Constraints Exercise.mp4 (3.87 MB)
022 Table Constraints Exercise Solution.mp4 (12.28 MB)
001 Section 5 Introduction.mp4 (16.78 MB)
002 Introduction to CRUD.mp4 (2.73 MB)
004 Preparing Our Data.mp4 (4.61 MB)
006 Official Introduction to SELECT.mp4 (8.01 MB)
008 Introduction to WHERE.mp4 (8.4 MB)
010 SELECT Challenges.mp4 (3.73 MB)
011 SELECT Challenges Solution.mp4 (7.37 MB)
013 Introduction to Aliases.mp4 (4.95 MB)
015 The UPDATE Command.mp4 (8.09 MB)
017 UPDATE Challenges.mp4 (908.96 KB)
018 UPDATE Challenges Solution.mp4 (8.44 MB)
020 Introduction to DELETE.mp4 (8.11 MB)
022 DELETE Challenges.mp4 (2.01 MB)
023 DELETE Challenges Solution.mp4 (11.25 MB)
001 Section 6 Introduction.mp4 (21.61 MB)
002 CRUD Exercise Overview.mp4 (29.81 MB)
003 CRUD Exercise Create Solution.mp4 (15.07 MB)
005 CRUD Exercise Read Solution.mp4 (5.11 MB)
007 CRUD Exercise Update Solution.mp4 (9.39 MB)
009 CRUD Exercise Delete Solution.mp4 (7.06 MB)
001 Section 7 Introduction.mp4 (9.74 MB)
003 Running SQL Files.mp4 (25.69 MB)
005 Loading Our Book Data.mp4 (33.9 MB)
007 Working with CONCAT.mp4 (65.37 MB)
009 Introducing SUBSTRING.mp4 (42.33 MB)
011 Introducing REPLACE.mp4 (20.61 MB)
013 Using REVERSE.mp4 (8.04 MB)
015 Working with CHAR LENGTH.mp4 (24.4 MB)
017 Changing Case with UPPER and LOWER.mp4 (7.89 MB)
020 String Function Challenges.mp4 (10.28 MB)
021 String Function Challenges Solution.mp4 (80.92 MB)
001 Section 8 Introduction.mp4 (6.77 MB)
002 Seed Data Adding A Couple New Books.mp4 (5.52 MB)
004 Using DISTINCT.mp4 (41.97 MB)
006 Sorting Data with ORDER BY.mp4 (32.28 MB)
008 Using LIMIT.mp4 (54.17 MB)
010 Better Searches with LIKE.mp4 (29.61 MB)
012 LIKE Part 2 More Wildcards.mp4 (25.94 MB)
014 Refining Selections Exercises.mp4 (14.12 MB)
015 Refining Selections Exercises Solution.mp4 (73.22 MB)
001 Section 9 Introduction.mp4 (18.71 MB)
002 The Count Function.mp4 (17.26 MB)
004 The Joys of Group By.mp4 (26.51 MB)
005 Note about SQL Mode only full group by.mp4 (26.85 MB)
007 Min and Max Basics.mp4 (14.94 MB)
009 SUBQUERIES - A Problem with Min and Max.mp4 (16.08 MB)
011 Using Min and Max with Group By.mp4 (14.66 MB)
013 The Sum Function.mp4 (9.51 MB)
015 The Avg Function.mp4 (12.56 MB)
017 Aggregate Functions Challenges.mp4 (7.49 MB)
018 Aggregate Functions Challenges Solution.mp4 (48.09 MB)
001 Section 10 Introduction.mp4 (11.75 MB)
002 CHAR and VARCHAR.mp4 (36.2 MB)
005 DECIMAL.mp4 (27.38 MB)
007 FLOAT and DOUBLE.mp4 (31.72 MB)
010 DATE, TIME, and DATETIME.mp4 (6.74 MB)
011 Creating Our DATE data.mp4 (13.34 MB)
013 CURDATE, CURTIME, and NOW.mp4 (13.13 MB)
015 Formatting Dates.mp4 (85.87 MB)
017 Date Math.mp4 (67.12 MB)
019 Working with TIMESTAMPS.mp4 (62.27 MB)
021 Data Types Exercises.mp4 (9.19 MB)
022 Data Types Exercises Solution.mp4 (84.97 MB)
001 Section 11 Introduction.mp4 (16.57 MB)
002 Not Equal.mp4 (11.88 MB)
004 Not Like.mp4 (5.37 MB)
006 Greater Than.mp4 (43.04 MB)
008 Less Than.mp4 (8.59 MB)
010 Logical AND.mp4 (44.59 MB)
012 Logical OR.mp4 (15.38 MB)
014 Between.mp4 (53.97 MB)
016 In And Not In.mp4 (34.33 MB)
018 Case Statements.mp4 (33.29 MB)
020 Logical Operators Exercises.mp4 (20.12 MB)
021 Logical Operators Exercises Solution.mp4 (116.18 MB)
001 Section 12 Introduction.mp4 (40.82 MB)
002 Real World Data Is Messy.mp4 (24.9 MB)
003 Types of Data Relationships.mp4 (8.38 MB)
004 One To Many The Basics.mp4 (33.77 MB)
005 Working With Foreign Keys.mp4 (87.57 MB)
007 Cross Join.mp4 (27.5 MB)
009 Inner Join.mp4 (109.68 MB)
011 Left Join.mp4 (103.93 MB)
013 Right Joins Pt 1.mp4 (35.95 MB)
015 Right Joins Pt 2.mp4 (43.94 MB)
017 Right and Left Joins A Common Question.mp4 (11.87 MB)
019 Our First Joins Exercise.mp4 (20.94 MB)
020 Our First Joins Exercise SOLUTION.mp4 (68.39 MB)
022 Our First Joins Exercise SOLUTION PT. 2.mp4 (37.21 MB)
001 Section 13 Introduction.mp4 (11.66 MB)
002 Many To Many Basics.mp4 (24.21 MB)
003 Creating Our Tables.mp4 (59.98 MB)
005 TV Joins Challenge 1.mp4 (17.37 MB)
007 TV Joins Challenge 2.mp4 (22.37 MB)
009 TV Joins Challenge 3.mp4 (21.55 MB)
011 TV Joins Challenge 4.mp4 (23.59 MB)
013 TV Joins Challenge 5.mp4 (27.5 MB)
015 TV Joins Challenge 6.mp4 (70.47 MB)
017 TV Joins Challenge 7.mp4 (52.99 MB)
001 Section 14 Introduction.mp4 (15.37 MB)
002 Introduction To Instagram Clone Schema.mp4 (61.16 MB)
003 Cloning Instagram's DB Users Schema.mp4 (14.43 MB)
005 Cloning Instagram's DB Photos Schema.mp4 (21.15 MB)
007 Cloning Instagram's DB Comments Schema.mp4 (22.66 MB)
009 Cloning Instagram's DB Likes Schema.mp4 (64.1 MB)
011 Cloning Instagram's DB Followers Schema.mp4 (46.87 MB)
014 Cloning Instagram's DB Hashtags Part 1.mp4 (32.64 MB)
015 Cloning Instagram's DB Hashtags Part 2.mp4 (23.12 MB)
001 Section 15 Introduction.mp4 (10.38 MB)
003 Loading The JUMBO dataset.mp4 (107.31 MB)
005 Instagram Clone Challenge 1.mp4 (10.79 MB)
007 Instagram Clone Challenge 2.mp4 (33.56 MB)
009 Instagram Clone Challenge 3.mp4 (25.52 MB)
011 Instagram Clone Challenge 4.mp4 (25.1 MB)
013 Instagram Clone Challenge 5.mp4 (8.36 MB)
015 Instagram Clone Challenge 6.mp4 (15.33 MB)
018 Instagram Clone Challenge 7.mp4 (17.91 MB)
002 Section 16 Introduction.mp4 (18.6 MB)
003 MySQL and Other Languages.mp4 (14.49 MB)
004 BUT WHAT ABOUT PHP.mp4 (31.76 MB)
005 Introduction to JOIN US app.mp4 (18.13 MB)
007 5 Minute NodeJS Crash Course.mp4 (14.06 MB)
010 Introduction to NPM and Faker.mp4 (43.84 MB)
012 Introducing the MySQL Package.mp4 (8.9 MB)
014 Connecting Node to MySQL.mp4 (72.35 MB)
016 Creating Our Users Table.mp4 (23.26 MB)
018 Selecting Using Node.mp4 (21.82 MB)
020 Inserting Using Node.mp4 (41.18 MB)
022 Some MySQLNode Magic.mp4 (65.94 MB)
023 Bulk Inserting 500 Users - Finally!.mp4 (31.77 MB)
025 500 Users Exercises.mp4 (4.57 MB)
026 500 Users Exercises Solutions.mp4 (69.73 MB)
001 Section 17 Introduction.mp4 (11.45 MB)
002 JoinUsCompleteCode.zip (3.75 MB)
003 Introducing Express.mp4 (31.29 MB)
004 NPM Init and package.json files.mp4 (19.88 MB)
006 Our First Simple Web App.mp4 (47.66 MB)
008 Adding Multiple Routes.mp4 (33.72 MB)
010 Connecting Express and MySQL.mp4 (74.37 MB)
012 Adding EJS Templates.mp4 (112.8 MB)
013 JOIN-US-HTML-AND-CSS.zip (2.7 KB)
014 Connecting The Form.mp4 (73.49 MB)
016 Styling Part 1.mp4 (55.71 MB)
017 JOIN-US-HTML-AND-CSS.zip (2.7 KB)
018 Styling Part 2.mp4 (84.3 MB)
001 Introduction to Database Triggers.mp4 (11.26 MB)
002 Writing Our First Trigger Part 1.mp4 (18.28 MB)
003 Writing Our First Trigger Part 2.mp4 (53.12 MB)
005 Preventing Instagram Self-Follows With Triggers.mp4 (30.9 MB)
006 Creating Logger Triggers.mp4 (39.14 MB)
007 Managing Triggers And A Warning.mp4 (44.22 MB)