The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

About Course

This completely free MySQL course will help you go from beginner to expert. It covers SQL syntax, aggregate functions, logical operators, string functions, joins, working with large datasets, and designing complex database schemas. You’ll also learn about MySQL 8.x Window Functions, creating views, and working with dates and times.

The course features over 325 brand new videos using MySQL 8.x. You’ll get hands-on practice with exercises, challenges, and projects. Learn how to find a website’s power users, calculate top students, identify bots, and determine which hashtags generate the most traction.

MySQL is a highly in-demand skill used by companies like Twitter, Uber, Airbnb, Dropbox, Github, Kickstarter, Udemy, Slack, and many others. This course is a comprehensive introduction to MySQL, a popular open source SQL database.

This course is offered for free through Theetay, which provides access to top-rated online courses from platforms like Udemy, Udacity, Coursera, MasterClass, NearPeer, and more.

Learn key skills like:

SQL syntax
Aggregate functions
Logical operators and string functions
SQL joins
Large datasets
Database schema design
MySQL 8.x Window Functions
Database views
Working with dates and times

Enroll now and start learning SQL for free!

Course Content

01 – Introduction & 5 Minutes of SQL

A Message from the Professor
001 This Course Was Just Updated!.mp4

00:00
002 Join The Community!.html

00:00
003 Course Intro.mp4

00:00
004 About Me.mp4

00:00
005 Getting The Course Code.mp4

00:00
006 First 5 Minutes of SQL.mp4

00:00
external-links.txt

00:00
Section Quiz

02 – Getting Started & Installation

001 Section Introduction.mp4

00:00
002 What Is A Database.mp4

00:00
003 SQL vs. MySQL.mp4

00:00
004 Installation START HERE!.mp4

00:00
005 IMPORTANT NOTE Windows Installation Instructions.html

00:00
006 Installation Windows Instructions.mp4

00:00
007 VERY IMPORTANT Mac Installation Notes.html

00:00
008 Installation Mac Instructions.mp4

00:00
external-links.txt

00:00
Section Quiz

03 – Creating Databases & Tables

001 Section Introduction.mp4

00:00
002 Showing Databases.mp4

00:00
003 CODE Showing Databases.html

00:00
004 Creating Databases.mp4

00:00
005 CODE Creating Databases.html

00:00
006 Dropping and Using Databases.mp4

00:00
007 CODE Dropping and Using Databases.html

00:00
008 Introducing Tables.mp4

00:00
009 Data Types The Basics.mp4

00:00
010 Basic Datatypes Challenge.mp4

00:00
011 CODE Basic Datatypes Challenge.html

00:00
012 Creating Tables.mp4

00:00
013 CODE Creating Tables.html

00:00
014 How Do We Know It Worked.mp4

00:00
015 CODE How Do We Know It Worked.html

00:00
016 Dropping Tables.mp4

00:00
017 CODE Dropping Tables.html

00:00
018 Tables Basics Activity.mp4

00:00
019 SOLUTION Tables Basics Activity.html

00:00
020 MySQL Comments.mp4

00:00
external-links.txt

00:00
Section Quiz

04 – Inserting Data

001 Section Introduction.mp4

00:00
002 INSERT The Basics.mp4

00:00
003 CODE INSERT The Basics.html

00:00
004 A Quick Preview of SELECT.mp4

00:00
005 CODE A Quick Preview of SELECT.html

00:00
006 Multi-inserts.mp4

00:00
007 CODE Multi-inserts.html

00:00
008 INSERT Exercise.mp4

00:00
009 SOLUTION INSERT Exercise.html

00:00
010 Working With NOT NULL.mp4

00:00
011 CODE Working With NOT NULL.html

00:00
012 Sidenote Quotes In MySQL.mp4

00:00
013 Adding DEFAULT Values.mp4

00:00
014 CODE Adding DEFAULT Values.html

00:00
015 Introducing Primary Keys.mp4

00:00
016 CODE Introducing Primary Keys.html

00:00
017 Working With AUTO_INCREMENT.mp4

00:00
018 CODE Working With AUTO_INCREMENT.html

00:00
019 Create Table Insert Exercise.mp4

00:00
020 SOLUTION Insert Exercise.html

00:00
external-links.txt

00:00
Section Quiz

05 – CRUD Basics

001 Section Introduction.mp4

00:00
002 Introducing CRUD.mp4

00:00
003 Getting Our New Dataset.mp4

00:00
004 CODE.html

00:00
005 Officially Introducing SELECT.mp4

00:00
006 CODE.html

00:00
007 The WHERE clause.mp4

00:00
008 CODE.html

00:00
009 Rapid Fire Exercises.mp4

00:00
010 Rapid Fire Exercises SOLUTION.mp4

00:00
011 SOLUTION CODE.html

00:00
012 Aliases.mp4

00:00
013 CODE.html

00:00
014 Using UPDATE.mp4

00:00
015 CODE.html

00:00
016 A Quick Rule Of Thumb.mp4

00:00
017 UPDATE Exercise.mp4

00:00
018 UPDATE Exercise SOLUTION.mp4

00:00
019 SOLUTION CODE.html

00:00
020 Introducing DELETE.mp4

00:00
021 CODE.html

00:00
022 DELETE Exercise.mp4

00:00
023 DELETE Exercise SOLUTION.mp4

00:00
024 SOLUTION CODE.html

00:00
external-links.txt

00:00
Section Quiz

06 – CRUD Challenge

001 Section Introduction.mp4

00:00
002 Introducing the CRUD Challenge.mp4

00:00
003 CRUD Challenge Solution Creating.mp4

00:00
004 SOLUTION CODE.html

00:00
005 CRUD Challenge Solution Reading.mp4

00:00
006 SOLUTION CODE.html

00:00
007 CRUD Challenge Solution Updating.mp4

00:00
008 SOLUTION CODE.html

00:00
009 CRUD Challenge Solution Deleting.mp4

00:00
010 SOLUTION CODE.html

00:00
external-links.txt

00:00
Section Quiz

07 – String Functions

001 Section Introduction.mp4

00:00
002 The World Of String Functions.mp4

00:00
003 Loading Our Books Data.mp4

00:00
004 CODE.html

00:00
005 CONCAT.mp4

00:00
006 CODE.html

00:00
007 SUBSTRING.mp4

00:00
008 CODE.html

00:00
009 Combining String Functions.mp4

00:00
010 CODE.html

00:00
011 Sidenote SQL Formatting.mp4

00:00
012 REPLACE.mp4

00:00
013 CODE.html

00:00
014 REVERSE.mp4

00:00
015 CODE.html

00:00
016 CHAR_LENGTH.mp4

00:00
017 CODE.html

00:00
018 UPPER & LOWER.mp4

00:00
019 CODE.html

00:00
020 Other String Functions.mp4

00:00
021 CODE.html

00:00
022 String Functions Exercise.mp4

00:00
023 String Functions Exerise SOLUTION.mp4

00:00
024 SOLUTION CODE.html

00:00
external-links.txt

00:00
Section Quiz

08 – Refining Selections

001 Section Introduction.mp4

00:00
002 Adding Some New Books.mp4

00:00
003 CODE.html

00:00
004 DISTINCT.mp4

00:00
005 CODE.html

00:00
006 ORDER BY.mp4

00:00
007 CODE.html

00:00
008 More On ORDER BY.mp4

00:00
009 CODE.html

00:00
010 LIMIT.mp4

00:00
011 CODE.html

00:00
012 LIKE.mp4

00:00
013 CODE.html

00:00
014 Escaping Wildcards.mp4

00:00
015 CODE.html

00:00
016 Refining Selections Exercise.mp4

00:00
017 Refining Selections Exercise SOLUTION.mp4

00:00
018 SOLUTION CODE.html

00:00
external-links.txt

00:00
Section Quiz

09 – Aggregate Functions

001 Section Introduction.mp4

00:00
002 Count Basics.mp4

00:00
003 CODE.html

00:00
004 GROUP BY.mp4

00:00
005 CODE.html

00:00
006 MIN and MAX Basics.mp4

00:00
007 CODE.html

00:00
008 Subqueries.mp4

00:00
009 CODE.html

00:00
010 Grouping By Multiple Columns.mp4

00:00
011 CODE.html

00:00
012 MIN and MAX With GROUP BY.mp4

00:00
013 CODE.html

00:00
014 SUM.mp4

00:00
015 CODE.html

00:00
016 AVG.mp4

00:00
017 CODE.html

00:00
018 Aggregate Functions Docs.mp4

00:00
019 Agg Functions Exercise.mp4

00:00
020 Agg Functions Exercise SOLUTION.mp4

00:00
021 SOLUTION CODE.html

00:00
external-links.txt

00:00
Section Quiz

10 – Revisiting Data Types

001 Section Introduction.mp4

00:00
002 Surveying Other Data Types.mp4

00:00
003 CHAR vs. VARCHAR.mp4

00:00
004 INT, TINYINT, BIGINT, etc.mp4

00:00
005 DECIMAL.mp4

00:00
006 FLOAT & DOUBLE.mp4

00:00
007 DATE and TIME.mp4

00:00
008 Working With Dates.mp4

00:00
009 CODE.html

00:00
010 CURDATE, CURTIME, & NOW.mp4

00:00
011 CODE.html

00:00
012 Date Functions.mp4

00:00
013 CODE.html

00:00
014 Time Functions.mp4

00:00
015 CODE.html

00:00
016 Formatting Dates.mp4

00:00
017 CODE.html

00:00
018 Date Math.mp4

00:00
019 TIMESTAMPS.mp4

00:00
020 DEFAULT & ON UPDATE TIMESTAMPS.mp4

00:00
021 CODE.html

00:00
022 Data Types Exercise.mp4

00:00
023 Data Types Exercise SOLUTION.mp4

00:00
024 SOLUTION CODE.html

00:00
external-links.txt

00:00
Section Quiz

11 – Comparison & Logical Operators

001 Section Introduction.mp4

00:00
002 Not Equal.mp4

00:00
003 CODE.html

00:00
004 NOT LIKE.mp4

00:00
005 CODE.html

00:00
006 Greater Than.mp4

00:00
007 CODE.html

00:00
008 Less Than Or Equal To.mp4

00:00
009 CODE.html

00:00
010 Logical AND.mp4

00:00
011 CODE.html

00:00
012 Logical OR.mp4

00:00
013 CODE.html

00:00
014 Between.mp4

00:00
015 CODE.html

00:00
016 Comparing Dates.mp4

00:00
017 CODE.html

00:00
018 The IN Operator.mp4

00:00
019 CODE.html

00:00
020 CASE.mp4

00:00
021 CODE.html

00:00
022 IS NULL.mp4

00:00
023 Exercise.mp4

00:00
024 Exercise SOLUTION.mp4

00:00
025 SOLUTION CODE.html

00:00
external-links.txt

00:00
Section Quiz

12 – Constraints & ALTER TABLE

001 UNIQUE Constraint.mp4

00:00
002 CODE.html

00:00
003 CHECK Constraints.mp4

00:00
004 CODE.html

00:00
005 Named Constraints.mp4

00:00
006 CODE.html

00:00
007 Multiple Column Constraints.mp4

00:00
008 CODE.html

00:00
009 ALTER TABLE Adding Columns.mp4

00:00
010 CODE.html

00:00
011 ALTER TABLE Dropping Columns.mp4

00:00
012 CODE.html

00:00
013 ALTER TABLE Renaming.mp4

00:00
014 CODE.html

00:00
015 ALTER TABLE Modifying Columns.mp4

00:00
016 CODE.html

00:00
017 ALTER TABLE Constraints.mp4

00:00
018 CODE.html

00:00
external-links.txt

00:00
Section Quiz

13 – One to Many & Joins

001 Section Introduction.mp4

00:00
002 Data is Messy.mp4

00:00
003 Relationships Basics.mp4

00:00
004 One to Many Relationship.mp4

00:00
005 Working with FOREIGN KEY.mp4

00:00
006 CODE.html

00:00
007 Cross Joins.mp4

00:00
008 CODE.html

00:00
009 Inner Joins.mp4

00:00
010 CODE.html

00:00
011 Inner Joins With Group By.mp4

00:00
012 CODE.html

00:00
013 Left Join.mp4

00:00
014 CODE.html

00:00
015 Left Join With Group By.mp4

00:00
016 CODE.html

00:00
017 Right Join.mp4

00:00
018 CODE.html

00:00
019 On Delete Cascade.mp4

00:00
020 CODE.html

00:00
021 Joins Exercise.mp4

00:00
022 EXERCISE STARTER DATA.html

00:00
023 Joins Exercise SOLUTION.mp4

00:00
024 SOLUTION CODE.html

00:00
external-links.txt

00:00
Section Quiz

14 – Many to Many

001 Section Introduction.mp4

00:00
002 Many to Many Basics.mp4

00:00
003 Creating Our Many To Many Tables.mp4

00:00
004 CODE.html

00:00
005 TV Series Challenge #1.mp4

00:00
006 CODE.html

00:00
007 TV Series Challenge #2.mp4

00:00
008 CODE.html

00:00
009 TV Series Challenge #3.mp4

00:00
010 CODE.html

00:00
011 TV Series Challenge #4.mp4

00:00
012 CODE.html

00:00
013 TV Series Challenge #5.mp4

00:00
014 CODE.html

00:00
015 TV Series Challenge #6.mp4

00:00
016 CODE.html

00:00
017 TV Series Challenge #7.mp4

00:00
018 CODE.html

00:00
external-links.txt

00:00
Section Quiz

15 – Views, Modes, & More!

001 Introducing Views.mp4

00:00
002 CODE.html

00:00
003 Updateable Views.mp4

00:00
004 ReplacingAltering Views.mp4

00:00
005 CODE.html

00:00
006 HAVING clause.mp4

00:00
007 CODE.html

00:00
008 WITH ROLLUP.mp4

00:00
009 CODE.html

00:00
010 SQL Modes Basics.mp4

00:00
011 CODE.html

00:00
012 STRICT_TRANS_TABLES.mp4

00:00
013 More Modes.mp4

00:00
Section Quiz

16 – Window Functions

001 Important Note (please read).html

00:00
002 Introducing Window Functions.mp4

00:00
003 Using OVER().mp4

00:00
004 CODE.html

00:00
005 PARTITION BY.mp4

00:00
006 CODE.html

00:00
007 ORDER BY with Windows.mp4

00:00
008 CODE.html

00:00
009 RANK().mp4

00:00
010 DENSE_RANK, & ROW_NUMBER().mp4

00:00
011 CODE.html

00:00
012 NTILE().mp4

00:00
013 CODE.html

00:00
014 FIRST_VALUE.mp4

00:00
015 CODE.html

00:00
016 LEAD and LAG.mp4

00:00
017 CODE.html

00:00
external-links.txt

00:00
Section Quiz

17 – Instagram Database Clone

001 Section Introduction.mp4

00:00
002 IMPORTANT NOTE ABOUT THIS SECTION!.mp4

00:00
003 Introducing Instagram Clone.mp4

00:00
004 Users Schema.mp4

00:00
005 CODE.html

00:00
006 Photos Schema.mp4

00:00
007 CODE.html

00:00
008 Comments Schema.mp4

00:00
009 CODE.html

00:00
010 Likes Schema.mp4

00:00
011 CODE.html

00:00
012 Followers Schema.mp4

00:00
013 CODE.html

00:00
014 Note!.html

00:00
015 3 Approaches for Hashtags.mp4

00:00
016 Implementing Hashtags Table.mp4

00:00
016 Implementing Hashtags Table.mp4

00:00
017 CODE.html

00:00
018 Complete Instagram Schema.html

00:00
external-links.txt

00:00
Section Quiz

18 – Working With Lots of IG Data

001 Section Introduction.mp4

00:00
002 Getting Lots of Instagram Data.mp4

00:00
003 CODE.html

00:00
004 Instagram Challenge #1.mp4

00:00
005 CODE.html

00:00
006 Instagram Challenge #2.mp4

00:00
007 CODE.html

00:00
008 Instagram Challenge #3.mp4

00:00
009 CODE.html

00:00
010 Instagram Challenge #4.mp4

00:00
011 CODE.html

00:00
012 Instagram Challenge #5.mp4

00:00
013 CODE.html

00:00
014 Instagram Challenge #6.mp4

00:00
015 CODE.html

00:00
016 Instagram Challenge #7.mp4

00:00
017 CODE.html

00:00
Section Quiz

19 – What Next

20 – LEGACY Introduction and 5 Minutes of SQL

21 – LEGACY Getting Started Overview and Installation

001 Section Introduction.mp4

00:00
002 What Is a Database.mp4

00:00
003 SQL Vs. MySQL.mp4

00:00
004 Important note about the next lecture.html

00:00
005 Installation Overview – WATCH BEFORE INSTALLING.mp4

00:00
006 Now using GoormIDE instead of Cloud9.mp4

00:00
007 GoormIDE Registration IMPORTANT – PLEASE READ!!!.html

00:00
008 MySQL Tips to Make Your Life Easier.html

00:00
009 Mac Installation.mp4

00:00
010 CODE Mac Installation.html

00:00
011 Windows Installation.mp4

00:00
external-links.txt

00:00
Section Quiz

22 – LEGACY Creating Databases and Tables

001 Section 3 Introduction.mp4

00:00
002 Creating Databases.mp4

00:00
003 CODE Creating Databases.html

00:00
004 Dropping Databases.mp4

00:00
005 CODE Dropping Databases.html

00:00
006 Using Databases.mp4

00:00
007 CODE Using Databases.html

00:00
008 Introduction to Tables.mp4

00:00
009 The Basic Datatypes.mp4

00:00
010 Note about INT max size.html

00:00
011 Basic Datatypes Challenge.mp4

00:00
012 Basic Datatypes Challenge – Solution.html

00:00
013 Creating Your Own Tables.mp4

00:00
014 CODE Creating Your Own Tables.html

00:00
015 How Do We Know It Worked.mp4

00:00
016 CODE How Do We Know It Worked.html

00:00
017 Dropping Tables.mp4

00:00
018 CODE Dropping Tables.html

00:00
019 Creating Your Own Tables Challenge.mp4

00:00
020 CODE Creating Your Own Tables Challenge.html

00:00
external-links.txt

00:00
Section Quiz

23 – LEGACY Inserting Data (and a couple other things)

001 Section 4 Introduction.mp4

00:00
002 Inserting Data.mp4

00:00
003 CODE Inserting Data.html

00:00
004 Super Quick Intro To SELECT.mp4

00:00
005 CODE Super Quick Intro To SELECT.html

00:00
006 Multiple INSERT.mp4

00:00
007 CODE Multiple Insert.html

00:00
008 INSERT Challenges.mp4

00:00
009 Note about using quotes inside of inserted values.html

00:00
010 INSERT Challenges Solution.mp4

00:00
011 CODE INSERT Challenges Solution.html

00:00
012 NOTE MySQL Warnings.html

00:00
013 MySQL Warnings.mp4

00:00
014 CODE MySQL Warnings.html

00:00
015 NULL and NOT_NULL.mp4

00:00
016 CODE NULL and NOT NULL.html

00:00
017 Setting Default Values.mp4

00:00
018 CODE Setting Default Values.html

00:00
019 A Primer On Primary Keys.mp4

00:00
020 CODE A Primer on Primary Keys.html

00:00
021 Table Constraints Exercise.mp4

00:00
022 Table Constraints Exercise Solution.mp4

00:00
023 CODE Table Constraints Exercise Solution.html

00:00
external-links.txt

00:00
Section Quiz

24 – LEGACY CRUD commmands

001 Section 5 Introduction.mp4

00:00
002 Introduction to CRUD.mp4

00:00
003 CODE Introduction to CRUD.html

00:00
004 Preparing Our Data.mp4

00:00
005 CODE Preparing Our Data.html

00:00
006 Official Introduction to SELECT.mp4

00:00
007 CODE Official Introduction to SELECT.html

00:00
008 Introduction to WHERE.mp4

00:00
009 CODE Introduction to WHERE.html

00:00
010 SELECT Challenges.mp4

00:00
011 SELECT Challenges Solution.mp4

00:00
012 CODE SELECT Challenges Solution.html

00:00
013 Introduction to Aliases.mp4

00:00
014 CODE Introduction to Aliases.html

00:00
015 The UPDATE Command.mp4

00:00
016 CODE The UPDATE Command.html

00:00
017 UPDATE Challenges.mp4

00:00
018 UPDATE Challenges Solution.mp4

00:00
019 CODE UPDATE Challenges Solution.html

00:00
020 Introduction to DELETE.mp4

00:00
021 CODE Introduction to DELETE.html

00:00
022 DELETE Challenges.mp4

00:00
023 DELETE Challenges Solution.mp4

00:00
024 CODE DELETE Challenges Solution.html

00:00
external-links.txt

00:00
Section Quiz

25 – LEGACY CRUD Challenge Section

001 Section 6 Introduction.mp4

00:00
002 CRUD Exercise Overview.mp4

00:00
003 CRUD Exercise Create Solution.mp4

00:00
004 CODE CRUD Exercise Create Solution.html

00:00
005 CRUD Exercise Read Solution.mp4

00:00
006 CODE CRUD Exercise Read Solution.html

00:00
007 CRUD Exercise Update Solution.mp4

00:00
008 CODE CRUD Exercise Update Solution.html

00:00
009 CRUD Exercise Delete Solution.mp4

00:00
010 CODE CRUD Exercise Delete Solution.html

00:00
external-links.txt

00:00
Section Quiz

26 – LEGACY The World Of String Functions

001 Section 7 Introduction.mp4

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

00:00
003 Running SQL Files.mp4

00:00
004 CODE Running SQL Files.html

00:00
005 Loading Our Book Data.mp4

00:00
006 CODE Loading Our Book Data.html

00:00
007 Working with CONCAT.mp4

00:00
008 CODE Working With CONCAT.html

00:00
009 Introducing SUBSTRING.mp4

00:00
010 CODE Introducing SUBSTRING.html

00:00
011 Introducing REPLACE.mp4

00:00
012 CODE Introducing REPLACE.html

00:00
013 Using REVERSE.mp4

00:00
014 CODE Using REVERSE.html

00:00
015 Working with CHAR LENGTH.mp4

00:00
016 CODE Working with CHAR LENGTH.html

00:00
017 Changing Case with UPPER and LOWER.mp4

00:00
018 CODE Changing Case with UPPER and LOWER.html

00:00
019 Note about string functions.html

00:00
020 String Function Challenges.mp4

00:00
021 String Function Challenges Solution.mp4

00:00
022 CODE String Function Challenges Solution.html

00:00
external-links.txt

00:00
Section Quiz

27 – LEGACY Refining Our Selections

001 Section 8 Introduction.mp4

00:00
002 Seed Data Adding A Couple New Books.mp4

00:00
003 CODE Seed Data Adding A Couple New Books.html

00:00
004 Using DISTINCT.mp4

00:00
005 CODE Using DISTINCT.html

00:00
006 Sorting Data with ORDER BY.mp4

00:00
007 CODE Sorting Data with ORDER BY.html

00:00
008 Using LIMIT.mp4

00:00
009 CODE Using LIMIT.html

00:00
010 Better Searches with LIKE.mp4

00:00
011 CODE Better Searches with LIKE.html

00:00
012 LIKE Part 2 More Wildcards.mp4

00:00
013 CODE LIKE Part 2 More Wildcards.html

00:00
014 Refining Selections Exercises.mp4

00:00
015 Refining Selections Exercises Solution.mp4

00:00
016 CODE Refining Selections Exercises Solution.html

00:00
external-links.txt

00:00
Section Quiz

28 – LEGACY The Magic of Aggregate Functions

001 Section 9 Introduction.mp4

00:00
002 The Count Function.mp4

00:00
003 CODE The Count Function.html

00:00
004 The Joys of Group By.mp4

00:00
005 Note about SQL Mode only_full_group_by.mp4

00:00
006 CODE The Joys of Group By.html

00:00
007 Min and Max Basics.mp4

00:00
008 CODE MIN and MAX Basics.html

00:00
009 SUBQUERIES – A Problem with Min and Max.mp4

00:00
010 CODE A Problem with Min and Max.html

00:00
011 Using Min and Max with Group By.mp4

00:00
012 CODE Using Min and Max with Group By.html

00:00
013 The Sum Function.mp4

00:00
014 CODE The Sum Function.html

00:00
015 The Avg Function.mp4

00:00
016 CODE The Avg Function.html

00:00
017 Aggregate Functions Challenges.mp4

00:00
018 Aggregate Functions Challenges Solution.mp4

00:00
019 CODE Aggregate Functions Challenges Solution.html

00:00
external-links.txt

00:00
Section Quiz

29 – LEGACY Revisiting Data Types

001 Section 10 Introduction.mp4

00:00
002 CHAR and VARCHAR.mp4

00:00
003 Note about CHAR and VARCHAR.html

00:00
004 CODE CHAR and VARCHAR.html

00:00
005 DECIMAL.mp4

00:00
006 CODE DECIMAL.html

00:00
007 FLOAT and DOUBLE.mp4

00:00
008 CODE FLOAT and DOUBLE.html

00:00
009 Note about setting the timezone in Cloud9.html

00:00
010 DATE, TIME, and DATETIME.mp4

00:00
011 Creating Our DATE data.mp4

00:00
012 CODE Creating Our DATE data.html

00:00
013 CURDATE, CURTIME, and NOW.mp4

00:00
014 Note about formatting dates.html

00:00
015 Formatting Dates.mp4

00:00
016 CODE Formatting Dates.html

00:00
017 Date Math.mp4

00:00
018 CODE Date Math.html

00:00
019 Working with TIMESTAMPS.mp4

00:00
020 CODE Working with TIMESTAMPS.html

00:00
021 Data Types Exercises.mp4

00:00
022 Data Types Exercises Solution.mp4

00:00
023 CODE Data Types Exercises Solution.html

00:00
external-links.txt

00:00
Section Quiz

30 – LEGACY The Power of Logical Operators

001 Section 11 Introduction.mp4

00:00
002 Not Equal.mp4

00:00
003 CODE Not Equal.html

00:00
004 Not Like.mp4

00:00
005 CODE Not Like.html

00:00
006 Greater Than.mp4

00:00
007 CODE Greater Than.html

00:00
008 Less Than.mp4

00:00
009 CODE Less Than.html

00:00
010 Logical AND.mp4

00:00
011 CODE Logical AND.html

00:00
012 Logical OR.mp4

00:00
013 CODE Logical OR.html

00:00
014 Between.mp4

00:00
015 CODE Between.html

00:00
016 In And Not In.mp4

00:00
017 CODE In And Not In.html

00:00
018 Case Statements.mp4

00:00
019 CODE Case Statements.html

00:00
020 Logical Operators Exercises.mp4

00:00
021 Logical Operators Exercises Solution.mp4

00:00
022 CODE Logical Operators Exercises Solution.html

00:00
external-links.txt

00:00
Section Quiz

31 – LEGACY Section 12 One To Many

001 Section 12 Introduction.mp4

00:00
002 Real World Data Is Messy.mp4

00:00
003 Types of Data Relationships.mp4

00:00
004 One To Many The Basics.mp4

00:00
005 Working With Foreign Keys.mp4

00:00
006 CODE Working With Foreign Keys.html

00:00
007 Cross Join.mp4

00:00
008 CODE Cross Joins.html

00:00
009 Inner Join.mp4

00:00
010 CODE Inner Joins.html

00:00
011 Left Join.mp4

00:00
012 CODE Left Joins.html

00:00
013 Right Joins Pt 1.mp4

00:00
014 CODE Right Joins Part 1.html

00:00
015 Right Joins Pt 2.mp4

00:00
016 CODE Right Joins Part 2.html

00:00
017 Right and Left Joins A Common Question.mp4

00:00
018 CODE Right and Left Joins FAQ.html

00:00
019 Our First Joins Exercise.mp4

00:00
020 Our First Joins Exercise SOLUTION.mp4

00:00
021 CODE Our First Joins Exercise.html

00:00
022 Our First Joins Exercise SOLUTION PT. 2.mp4

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

00:00
external-links.txt

00:00
Section Quiz

32 – LEGACY Many To Many

001 Section 13 Introduction.mp4

00:00
002 Many To Many Basics.mp4

00:00
003 Creating Our Tables.mp4

00:00
004 CODE Creating Our Tables.html

00:00
005 TV Joins Challenge 1.mp4

00:00
006 CODE TV Joins Challenge 1 Solution.html

00:00
007 TV Joins Challenge 2.mp4

00:00
008 CODE TV Joins Challenge 2 SOLUTION.html

00:00
009 TV Joins Challenge 3.mp4

00:00
010 CODE TV Joins Challenge 3 SOLUTION.html

00:00
011 TV Joins Challenge 4.mp4

00:00
012 CODE TV Joins Challenge 4 SOLUTION.html

00:00
013 TV Joins Challenge 5.mp4

00:00
014 CODE TV Joins Challenge 5 SOLUTION.html

00:00
015 TV Joins Challenge 6.mp4

00:00
016 CODE TV Joins Challenge 6 SOLUTION.html

00:00
017 TV Joins Challenge 7.mp4

00:00
018 CODE TV Joins Challenge 7 SOLUTION.html

00:00
external-links.txt

00:00
Section Quiz

33 – LEGACY Instagram Database Clone

001 Section 14 Introduction.mp4

00:00
002 Introduction To Instagram Clone Schema.mp4

00:00
003 Cloning Instagram’s DB Users Schema.mp4

00:00
004 CODE IG Clone Users Schema.html

00:00
005 Cloning Instagram’s DB Photos Schema.mp4

00:00
006 CODE IG Clone Photos Schema.html

00:00
007 Cloning Instagram’s DB Comments Schema.mp4

00:00
008 CODE IG Clone Comments Schema.html

00:00
009 Cloning Instagram’s DB Likes Schema.mp4

00:00
010 CODE IG Clone Likes Schema.html

00:00
011 Cloning Instagram’s DB Followers Schema.mp4

00:00
012 CODE IG Clone Followers Schema.html

00:00
013 Note about Cloning Instagram’s DB Hashtags Part 1.html

00:00
014 Cloning Instagram’s DB Hashtags Part 1.mp4

00:00
015 Cloning Instagram’s DB Hashtags Part 2.mp4

00:00
016 CODE IG Clone Hashtags Schema.html

00:00
017 CODE Complete IG Clone Schema.html

00:00
external-links.txt

00:00
Section Quiz

34 – LEGACY Working With Lots Of Instagram Data

001 Section 15 Introduction.mp4

00:00
002 Note about Loading The JUMBO dataset.html

00:00
003 Loading The JUMBO dataset.mp4

00:00
004 The Instagram Clone DATASET.html

00:00
005 Instagram Clone Challenge 1.mp4

00:00
006 Instagram Challenge 1 Solution CODE.html

00:00
007 Instagram Clone Challenge 2.mp4

00:00
008 Instagram Challenge 2 Solution CODE.html

00:00
009 Instagram Clone Challenge 3.mp4

00:00
010 Instagram Challenge 3 Solution CODE.html

00:00
011 Instagram Clone Challenge 4.mp4

00:00
012 Instagram Challenge 4 Solution CODE.html

00:00
013 Instagram Clone Challenge 5.mp4

00:00
014 Instagram Challenge 5 Solution CODE.html

00:00
015 Instagram Clone Challenge 6.mp4

00:00
016 Instagram Challenge 6 Solution CODE.html

00:00
017 Note about Instagram Clone Challenge 7.html

00:00
018 Instagram Clone Challenge 7.mp4

00:00
019 Instagram Challenge 7 Solution CODE.html

00:00
external-links.txt

00:00
Section Quiz

35 – LEGACY Introducing Node

001 Note about Introducing Node.html

00:00
002 Section 16 Introduction.mp4

00:00
003 MySQL and Other Languages.mp4

00:00
004 BUT WHAT ABOUT PHP.mp4

00:00
005 Introduction to JOIN US app.mp4

00:00
006 Note about Setting Up Cloud9 for Node.html

00:00
007 5 Minute NodeJS Crash Course.mp4

00:00
008 CODE 5 Minute Node Crash Course.html

00:00
009 Note about Faker install.html

00:00
010 Introduction to NPM and Faker.mp4

00:00
011 CODE Introduction to NPM and Faker.html

00:00
012 Introducing the MySQL Package.mp4

00:00
013 Note about connecting Node to MySQL.html

00:00
014 Connecting Node to MySQL.mp4

00:00
015 CODE Connecting Node to MySQL.html

00:00
016 Creating Our Users Table.mp4

00:00
017 CODE Creating Our Users Table.html

00:00
018 Selecting Using Node.mp4

00:00
019 CODE Selecting Using Node.html

00:00
020 Inserting Using Node.mp4

00:00
021 CODE Inserting Using Node.html

00:00
022 Some MySQLNode Magic.mp4

00:00
023 Bulk Inserting 500 Users – Finally!.mp4

00:00
024 CODE Bulk Inserting 500 Users.html

00:00
025 500 Users Exercises.mp4

00:00
026 500 Users Exercises Solutions.mp4

00:00
027 CODE 500 Users Exercises Solutions.html

00:00
external-links.txt

00:00
Section Quiz

36 – LEGACY Building Our Web App

001 Section 17 Introduction.mp4

00:00
002 Join Us Completed CODE.html

00:00
003 Introducing Express.mp4

00:00
004 NPM Init and package.json files.mp4

00:00
005 Note about Our First Simple Web App.html

00:00
006 Our First Simple Web App.mp4

00:00
007 CODE Our First Simple Web App.html

00:00
008 Adding Multiple Routes.mp4

00:00
009 CODE Adding Multiple Routes.html

00:00
010 Connecting Express and MySQL.mp4

00:00
011 CODE Connecting Express and MySQL.html

00:00
012 Adding EJS Templates.mp4

00:00
013 CODE Adding EJS Templates.html

00:00
014 Connecting The Form.mp4

00:00
015 CODE Connecting the Form.html

00:00
016 Styling Part 1.mp4

00:00
017 CODE HTML AND CSS FILES.html

00:00
018 Styling Part 2.mp4

00:00
external-links.txt

00:00
Section Quiz

37 – LEGACY Database Triggers

001 Introduction to Database Triggers.mp4

00:00
002 Writing Our First Trigger Part 1.mp4

00:00
003 Writing Our First Trigger Part 2.mp4

00:00
004 Note about next lecture.html

00:00
005 Preventing Instagram Self-Follows With Triggers.mp4

00:00
006 Creating Logger Triggers.mp4

00:00
007 Managing Triggers And A Warning.mp4

00:00
external-links.txt

00:00
Section Quiz

38 – Additional Resources

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

01 – Introduction & 5 Minutes of SQL

A Message from the Professor

001 This Course Was Just Updated!.mp4

002 Join The Community!.html

003 Course Intro.mp4

004 About Me.mp4

005 Getting The Course Code.mp4

006 First 5 Minutes of SQL.mp4

external-links.txt

Section Quiz

02 – Getting Started & Installation

001 Section Introduction.mp4

002 What Is A Database.mp4

003 SQL vs. MySQL.mp4

004 Installation START HERE!.mp4

005 IMPORTANT NOTE Windows Installation Instructions.html

006 Installation Windows Instructions.mp4

007 VERY IMPORTANT Mac Installation Notes.html

008 Installation Mac Instructions.mp4

external-links.txt

Section Quiz

03 – Creating Databases & Tables

001 Section Introduction.mp4

002 Showing Databases.mp4

003 CODE Showing Databases.html

004 Creating Databases.mp4

005 CODE Creating Databases.html

006 Dropping and Using Databases.mp4

007 CODE Dropping and Using Databases.html

008 Introducing Tables.mp4

009 Data Types The Basics.mp4

010 Basic Datatypes Challenge.mp4

011 CODE Basic Datatypes Challenge.html

012 Creating Tables.mp4

013 CODE Creating Tables.html

014 How Do We Know It Worked.mp4

015 CODE How Do We Know It Worked.html

016 Dropping Tables.mp4

017 CODE Dropping Tables.html

018 Tables Basics Activity.mp4

019 SOLUTION Tables Basics Activity.html

020 MySQL Comments.mp4

external-links.txt

Section Quiz

04 – Inserting Data

001 Section Introduction.mp4

002 INSERT The Basics.mp4

003 CODE INSERT The Basics.html

004 A Quick Preview of SELECT.mp4

005 CODE A Quick Preview of SELECT.html

006 Multi-inserts.mp4

007 CODE Multi-inserts.html

008 INSERT Exercise.mp4

009 SOLUTION INSERT Exercise.html

010 Working With NOT NULL.mp4

011 CODE Working With NOT NULL.html

012 Sidenote Quotes In MySQL.mp4

013 Adding DEFAULT Values.mp4

014 CODE Adding DEFAULT Values.html

015 Introducing Primary Keys.mp4

016 CODE Introducing Primary Keys.html

017 Working With AUTO_INCREMENT.mp4

018 CODE Working With AUTO_INCREMENT.html

019 Create Table Insert Exercise.mp4

020 SOLUTION Insert Exercise.html

external-links.txt

Section Quiz

05 – CRUD Basics

001 Section Introduction.mp4

002 Introducing CRUD.mp4

003 Getting Our New Dataset.mp4

004 CODE.html

005 Officially Introducing SELECT.mp4

006 CODE.html

007 The WHERE clause.mp4

008 CODE.html

009 Rapid Fire Exercises.mp4