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

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