The Ultimate Mysql Bootcamp Go From Sql Beginner To Expert

Become an In-demand SQL Master by creating complex databases and building reports through real-world projects

Last updated 2022-01-10 | 4.6

- Create your own database or interact with existing databases
- Write complex SQL queries across multiple tables
- Build a web app using NodeJS and MySQL

What you'll learn

Create your own database or interact with existing databases

Write complex SQL queries across multiple tables

Build a web app using NodeJS and MySQL

Model real-world data and generate reports using SQL

Answer company performance or sales questions using data

* Requirements

* No Database
* SQL
* or MySQL experience needed! Complete beginners to MySQL are welcome.
* All you need is a working computer for this course; PC
* Mac
* and Linux users are all welcome.
* No previous programming language experience required
* but it won't hurt :)

Description

If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today.

Whether you work in sales or marketing, you run your own company, or you want to build your own apps, mastering MySQL is crucial to answering complex business problems and questions using insights from data. The Ultimate MySQL Bootcamp introduces you to a solid foundation in databases in a way that’s both informative and engaging. Yes, that’s right, it’s possible to make an engaging course on databases.

In this course, you will:

Learn the ins and outs of SQL syntax
Generate reports using sales and user data
Analyze data using Aggregate Functions
Run complex queries using MySQL logical operators and string functions
Write all the common SQL joins
Work with large datasets containing thousands of entries
Build a web app using MySQL and NodeJS
Design and implement complex database schemas
Learn to navigate the treacherous world of storing dates and times
Clone the database structure of a photo sharing social network
Write Javascript code to generate fake data sets
And more!

This course is also chock full of exercises, challenges, projects, and opportunities for you to practice what you’re learning. Apply what you’re learning to real-world challenges such as finding a website’s power users, calculating your top students, identifying bots on a site, or determining which hashtags generate the most traction on a site. Along the way, you’ll also get to meet my pet cat, Blue! (She’s really cute.)

Why Learn MySQL

Consistently ranked the most in-demand skill in recent employer surveys, SQL is a fantastic way to increase your income and boost your professional development. So many companies today use MySQL, including Twitter, Uber, Airbnb, Dropbox, Github, Kickstarter, Udemy, Slack, and many others. Unsure about the difference between SQL and MySQL? MySQL is the most popular open source SQL database out there, so it’s a great choice to begin your learning journey. We’ll talk a lot more about the difference between SQL and MySQL in the course, but 95% of what you learn about MySQL in this course will apply to other databases such as Postgres, Oracle, and Microsoft SQL Server.

Why This Course Is Different

This isn’t going to be a course where you watch me code for 20 hours; it’s a course with ample opportunity for you to get your hands dirty writing code (even within the first 7 minutes of the course).

My teaching experience is rooted in the classroom. I’ve spent years teaching programming, web development, and databases to my in-person bootcamp students. This course combines the best of my offline courses with the convenience of learning online, in a setting that’s best for you.

Upon completing this course, you’ll be able to interact with and query any SQL database out there. You’ll also be able to generate reports with ease, answer company performance questions using data, and integrate MySQL into complete applications.

So let’s do this! Enroll today and start learning SQL!

Who this course is for:

Anyone interested in learning SQL to help with their current job or to find a new role. SQL is one of today's most in-demand skills
Anyone looking to answer complex business problems and generate reports using data
Business owners, people in sales, or people in marketing roles who are interested in understanding company data better.
Developers who are looking to build applications (e.g. social network, ecommerce site) using MySQL

Course content

18 sections • 325 lectures

Introduction and 5 Minutes of SQL 7 lectures

Course Introduction Preview 01:08

Instructor Introduction(s) Preview 01:25

Syllabus Walkthrough and Prerequisites Preview 04:18

Note about SQL Editor Preview 00:14

Your First 5 Minutes of SQL - Let's Get Coding! Preview 06:13

CODE: Your First 5 Minutes of SQL Preview 00:29

How The Course Works Preview 03:44

Getting Started: Overview and Installation 10 lectures

Section Introduction Preview 01:02

What Is a Database? Preview 07:16

SQL Vs. MySQL Preview 05:50

Installation Overview - WATCH BEFORE INSTALLING Preview 05:10

Now using GoormIDE instead of Cloud9 Preview 03:16

GoormIDE Registration IMPORTANT - PLEASE READ!!! Preview 00:54

MySQL Tips to Make Your Life Easier Preview 00:20

Mac Installation Preview 11:41

CODE: Mac Installation Preview 00:32

Windows Installation Preview 03:32

Creating Databases and Tables 20 lectures

Section 3 Introduction Preview 01:09

Creating Databases Preview 05:20

CODE: Creating Databases Preview 00:07

Dropping Databases Preview 01:46

CODE: Dropping Databases Preview 00:06

Using Databases Preview 03:00

CODE: Using Databases Preview 00:02

Introduction to Tables Preview 05:09

The Basic Datatypes Preview 07:52

Note about INT max size Preview 00:08

Basic Datatypes Challenge Preview 02:35

Basic Datatypes Challenge - Solution Preview 00:00

Creating Your Own Tables Preview 03:06

CODE: Creating Your Own Tables Preview 00:03

How Do We Know It Worked? Preview 02:33

CODE: How Do We Know It Worked? Preview 00:02

Dropping Tables Preview 01:36

CODE: Dropping Tables Preview 00:03

Creating Your Own Tables Challenge Preview 04:29

CODE: Creating Your Own Tables Challenge Preview 00:03

Inserting Data (and a couple other things) 23 lectures

Section 4 Introduction Preview 01:40

Inserting Data Preview 05:03

CODE: Inserting Data Preview 00:04

Super Quick Intro To SELECT Preview 02:07

CODE: Super Quick Intro To SELECT Preview 00:00

Multiple INSERT Preview 03:00

CODE: Multiple Insert Preview 00:03

INSERT Challenges Preview 01:35

Note about using quotes inside of inserted values Preview 00:15

INSERT Challenges Solution Preview 04:43

CODE: INSERT Challenges Solution Preview 00:13

NOTE: MySQL Warnings Preview 00:12

MySQL Warnings Preview 05:35

CODE: MySQL Warnings Preview 00:15

NULL and NOT_NULL Preview 06:54

CODE: NULL and NOT NULL Preview 00:21

Setting Default Values Preview 07:17

CODE: Setting Default Values Preview 00:26

A Primer On Primary Keys Preview 12:21

CODE: A Primer on Primary Keys Preview 00:30

Table Constraints Exercise Preview 01:51

Table Constraints Exercise Solution Preview 03:34

CODE: Table Constraints Exercise Solution Preview 00:21

CRUD commmands 24 lectures

Section 5 Introduction Preview 01:30

Introduction to CRUD Preview 01:44

CODE: Introduction to CRUD Preview 00:01

Preparing Our Data Preview 02:29

CODE: Preparing Our Data Preview 00:18

Official Introduction to SELECT Preview 04:18

CODE: Official Introduction to SELECT Preview 00:11

Introduction to WHERE Preview 05:04

CODE: Introduction to WHERE Preview 00:07

SELECT Challenges Preview 02:00

SELECT Challenges Solution Preview 02:45

CODE: SELECT Challenges Solution Preview 00:08

Introduction to Aliases Preview 02:55

CODE: Introduction to Aliases Preview 00:05

The UPDATE Command Preview 03:58

CODE: The UPDATE Command Preview 00:05

UPDATE Challenges Preview 00:37

UPDATE Challenges Solution Preview 03:58

CODE: UPDATE Challenges Solution Preview 00:16

Introduction to DELETE Preview 04:41

CODE: Introduction to DELETE Preview 00:06

DELETE Challenges Preview 01:10

DELETE Challenges Solution Preview 02:45

CODE: DELETE Challenges Solution Preview 00:09

CRUD Challenge Section 10 lectures

Section 6 Introduction Preview 01:52

CRUD Exercise Overview Preview 07:26

CRUD Exercise Create Solution Preview 05:55

CODE: CRUD Exercise Create Solution Preview 00:22

CRUD Exercise Read Solution Preview 01:48

CODE: CRUD Exercise Read Solution Preview 00:04

CRUD Exercise Update Solution Preview 04:10

CODE: CRUD Exercise Update Solution Preview 00:17

CRUD Exercise Delete Solution Preview 03:21

CODE: CRUD Exercise Delete Solution Preview 00:11

The World Of String Functions 22 lectures

Section 7 Introduction Preview 02:04

Important Note about Running SQL Files (please read) Preview 00:13

Running SQL Files Preview 10:15

CODE: Running SQL Files Preview 00:09

Loading Our Book Data Preview 05:25

CODE: Loading Our Book Data Preview 00:51

Working with CONCAT Preview 11:07

CODE: Working With CONCAT Preview 00:20

Introducing SUBSTRING Preview 10:04

CODE: Introducing SUBSTRING Preview 00:21

Introducing REPLACE Preview 06:39

CODE: Introducing REPLACE Preview 00:24

Using REVERSE Preview 03:39

CODE: Using REVERSE Preview 00:04

Working with CHAR LENGTH Preview 04:54

CODE: Working with CHAR LENGTH Preview 00:04

Changing Case with UPPER and LOWER Preview 03:20

CODE: Changing Case with UPPER and LOWER Preview 00:06

Note about string functions Preview 00:46

String Function Challenges Preview 04:42

String Function Challenges Solution Preview 13:08

CODE: String Function Challenges Solution Preview 00:22

Refining Our Selections 16 lectures

Section 8 Introduction Preview 00:35

Seed Data: Adding A Couple New Books Preview 02:47

CODE: Seed Data: Adding A Couple New Books Preview 00:09

Using DISTINCT Preview 08:24

CODE: Using DISTINCT Preview 00:06

Sorting Data with ORDER BY Preview 11:19

CODE: Sorting Data with ORDER BY Preview 00:32

Using LIMIT Preview 09:03

CODE: Using LIMIT Preview 00:31

Better Searches with LIKE Preview 07:42

CODE: Better Searches with LIKE Preview 00:10

LIKE Part 2: More Wildcards Preview 06:09

CODE: LIKE Part 2: More Wildcards Preview 00:11

Refining Selections Exercises Preview 04:52

Refining Selections Exercises Solution Preview 12:29

CODE: Refining Selections Exercises Solution Preview 00:20

The Magic of Aggregate Functions 19 lectures

Section 9 Introduction Preview 03:56

The Count Function Preview 08:38

CODE: The Count Function Preview 00:10

The Joys of Group By Preview 12:22

Note about SQL Mode only_full_group_by Preview 04:19

CODE: The Joys of Group By Preview 00:20

Min and Max Basics Preview 04:12

CODE: MIN and MAX Basics Preview 00:06

SUBQUERIES - A Problem with Min and Max Preview 07:14

CODE: A Problem with Min and Max Preview 00:15

Using Min and Max with Group By Preview 06:39

CODE: Using Min and Max with Group By Preview 00:08

The Sum Function Preview 04:27

CODE: The Sum Function Preview 00:07

The Avg Function Preview 06:00

CODE: The Avg Function Preview 00:08

Aggregate Functions Challenges Preview 04:27

Aggregate Functions Challenges Solution Preview 09:10

CODE: Aggregate Functions Challenges Solution Preview 00:22

Revisiting Data Types 23 lectures

Section 10 Introduction Preview 01:56

CHAR and VARCHAR Preview 14:29

Note about CHAR and VARCHAR Preview 00:05

CODE: CHAR and VARCHAR Preview 00:11

DECIMAL Preview 06:07

CODE: DECIMAL Preview 00:06

FLOAT and DOUBLE Preview 07:44

CODE: FLOAT and DOUBLE Preview 00:07

Note about setting the timezone in Cloud9 Preview 00:07

DATE, TIME, and DATETIME Preview 04:31

Creating Our DATE data Preview 05:49

CODE: Creating Our DATE data Preview 00:09

CURDATE, CURTIME, and NOW Preview 05:15

Note about formatting dates Preview 00:09

Formatting Dates Preview 14:29

CODE: Formatting Dates Preview 00:24

Date Math Preview 09:40

CODE: Date Math Preview 00:17

Working with TIMESTAMPS Preview 10:54

CODE: Working with TIMESTAMPS Preview 00:25

Data Types Exercises Preview 04:50

Data Types Exercises Solution Preview 13:58

CODE: Data Types Exercises Solution Preview 00:36

The Power of Logical Operators 22 lectures

Section 11 Introduction Preview 02:44

Not Equal Preview 04:26

CODE: Not Equal Preview 00:08

Not Like Preview 02:34

CODE: Not Like Preview 00:10

Greater Than Preview 10:04

CODE: Greater Than Preview 00:23

Less Than Preview 03:48

CODE: Less Than Preview 00:10

Logical AND Preview 09:47

CODE: Logical AND Preview 00:34

Logical OR Preview 06:41

CODE: Logical OR Preview 00:29

Between Preview 10:57

CODE: Between Preview 00:16

In And Not In Preview 11:47

CODE: In And Not In Preview 00:29

Case Statements Preview 11:20

CODE: Case Statements Preview 00:28

Logical Operators Exercises Preview 06:45

Logical Operators Exercises Solution Preview 17:46

CODE: Logical Operators Exercises Solution Preview 00:41

Section 12: One To Many 23 lectures

Section 12 Introduction Preview 01:57

Real World Data Is Messy Preview 10:28

Types of Data Relationships Preview 04:36

One To Many: The Basics Preview 12:33

Working With Foreign Keys Preview 12:04

CODE: Working With Foreign Keys Preview 00:27

Cross Join Preview 07:36

CODE: Cross Joins Preview 00:11

Inner Join Preview 12:44

CODE: Inner Joins Preview 00:19

Left Join Preview 15:17

CODE: Left Joins Preview 00:23

Right Joins Pt 1 Preview 10:36

CODE: Right Joins Part 1 Preview 00:33

Right Joins Pt 2 Preview 09:51

CODE: Right Joins Part 2 Preview 00:30

Right and Left Joins: A Common Question Preview 03:09

CODE: Right and Left Joins FAQ Preview 00:11

Our First Joins Exercise Preview 06:58

Our First Joins Exercise SOLUTION Preview 09:10

CODE: Our First Joins Exercise Preview 00:21

Our First Joins Exercise SOLUTION PT. 2 Preview 09:21

CODE: Our First Joins Exercise SOLUTION PT. 2 Preview 00:32

Section 13: Many To Many 18 lectures

Section 13 Introduction Preview 01:54

Many To Many Basics Preview 10:48

Creating Our Tables Preview 10:57

CODE: Creating Our Tables Preview 00:42

TV Joins Challenge 1 Preview 04:49

CODE: TV Joins Challenge 1 Solution Preview 00:04

TV Joins Challenge 2 Preview 06:22

CODE: TV Joins Challenge 2 SOLUTION Preview 00:05

TV Joins Challenge 3 Preview 04:59

CODE: TV Joins Challenge 3 SOLUTION Preview 00:07

TV Joins Challenge 4 Preview 05:59

CODE: TV Joins Challenge 4 SOLUTION Preview 00:05

TV Joins Challenge 5 Preview 04:56

CODE: TV Joins Challenge 5 SOLUTION Preview 00:05

TV Joins Challenge 6 Preview 11:57

CODE: TV Joins Challenge 6 SOLUTION Preview 00:23

TV Joins Challenge 7 Preview 07:08

CODE: TV Joins Challenge 7 SOLUTION Preview 00:07

Instagram Database Clone 17 lectures

Section 14 Introduction Preview 01:19

Introduction To Instagram Clone Schema Preview 08:31

Cloning Instagram's DB: Users Schema Preview 06:08

CODE: IG Clone Users Schema Preview 00:04

Cloning Instagram's DB: Photos Schema Preview 06:37

CODE: IG Clone Photos Schema Preview 00:06

Cloning Instagram's DB: Comments Schema Preview 06:39

CODE: IG Clone Comments Schema Preview 00:08

Cloning Instagram's DB: Likes Schema Preview 07:41

CODE: IG Clone Likes Schema Preview 00:06

Cloning Instagram's DB: Followers Schema Preview 07:20

CODE: IG Clone Followers Schema Preview 00:06

Note about: Cloning Instagram's DB: Hashtags Part 1 Preview 00:13

Cloning Instagram's DB: Hashtags Part 1 Preview 10:34

Cloning Instagram's DB: Hashtags Part 2 Preview 05:25

CODE: IG Clone Hashtags Schema Preview 00:09

CODE: Complete IG Clone Schema Preview 00:40

Working With Lots Of Instagram Data 19 lectures

Section 15 Introduction Preview 01:41

Note about Loading The JUMBO dataset Preview 00:19

Loading The JUMBO dataset Preview 08:30

The Instagram Clone DATASET Preview 00:07

Instagram Clone Challenge 1 Preview 04:52

Instagram Challenge 1 Solution CODE Preview 00:03

Instagram Clone Challenge 2 Preview 06:41

Instagram Challenge 2 Solution CODE Preview 00:06

Instagram Clone Challenge 3 Preview 07:22

Instagram Challenge 3 Solution CODE Preview 00:05

Instagram Clone Challenge 4 Preview 07:05

Instagram Challenge 4 Solution CODE Preview 00:10

Instagram Clone Challenge 5 Preview 03:13

Instagram Challenge 5 Solution CODE Preview 00:05

Instagram Clone Challenge 6 Preview 05:29

Instagram Challenge 6 Solution CODE Preview 00:07

Note about Instagram Clone Challenge 7 Preview 00:15

Instagram Clone Challenge 7 Preview 05:14

Instagram Challenge 7 Solution CODE Preview 00:08

Section 16 - Introducing Node 27 lectures

Note about Introducing Node Preview 00:09

Section 16 Introduction Preview 01:36

MySQL and Other Languages Preview 08:59

BUT WHAT ABOUT PHP Preview 07:34

Introduction to JOIN US app Preview 08:00

Note about Setting Up Cloud9 for Node Preview 00:18

5 Minute NodeJS Crash Course Preview 06:12

CODE: 5 Minute Node Crash Course Preview 00:05

Note about Faker install Preview 01:11

Introduction to NPM and Faker Preview 09:11

CODE: Introduction to NPM and Faker Preview 00:23

Introducing the MySQL Package Preview 04:53

Note about connecting Node to MySQL Preview 01:32

Connecting Node to MySQL Preview 12:46

CODE: Connecting Node to MySQL Preview 00:59

Creating Our Users Table Preview 06:54

CODE: Creating Our Users Table Preview 00:04

Selecting Using Node Preview 06:15

CODE: Selecting Using Node Preview 00:17

Inserting Using Node Preview 11:31

CODE: Inserting Using Node Preview 00:13

Some MySQL/Node Magic Preview 07:41

Bulk Inserting 500 Users - Finally! Preview 08:40

CODE: Bulk Inserting 500 Users Preview 00:11

500 Users Exercises Preview 02:30

500 Users Exercises Solutions Preview 11:55

CODE: 500 Users Exercises Solutions Preview 00:24

Section 17 - Building Our Web App 18 lectures

Section 17 Introduction Preview 01:52

Join Us Completed CODE Preview 00:04

Introducing Express Preview 05:40

NPM Init and package.json files Preview 06:38

Note about Our First Simple Web App Preview 00:15

Our First Simple Web App Preview 16:33

CODE: Our First Simple Web App Preview 00:10

Adding Multiple Routes Preview 09:56

CODE: Adding Multiple Routes Preview 00:11

Connecting Express and MySQL Preview 11:08

CODE: Connecting Express and MySQL Preview 00:10

Adding EJS Templates Preview 16:02

CODE: Adding EJS Templates Preview 00:15

Connecting The Form Preview 18:32

CODE: Connecting the Form Preview 00:06

Styling Part 1 Preview 08:24

CODE: HTML AND CSS FILES Preview 00:04

Styling Part 2 Preview 08:16

Section 18 - Database Triggers 7 lectures

Introduction to Database Triggers Preview 06:10

Writing Our First Trigger Part 1 Preview 07:27

Writing Our First Trigger Part 2 Preview 11:36

Note about next lecture Preview 00:10

Preventing Instagram Self-Follows With Triggers Preview 08:16

Creating Logger Triggers Preview 10:17