The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

184,085 students enrolled

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

Bestseller

184,085 students enrolled

Created by Colt Steele, Ian Schoonover

Last updated 5/2020

English

English [Auto-generated], French [Auto-generated],

Preview this course

The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

$125.99 $179.99 30% off

5 hours left at this price!

30-Day Money-Back Guarantee

20 hours on-demand video
141 articles
4 downloadable resources
Full lifetime access
Access on mobile and TV

Certificate of Completion

Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business

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

+ – Introduction and 5 Minutes of SQL

7 lectures 17:31

Course Introduction

Preview 01:08

Instructor Introduction(s)

Preview 01:25

Syllabus Walkthrough and Prerequisites

Preview 04:18

Note about SQL Editor

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

8 lectures 35:57

Section Introduction

01:02

What Is a Database?

07:16

SQL Vs. MySQL

05:50

Installation Overview - WATCH BEFORE INSTALLING

05:10

Cloud9 Registration IMPORTANT - PLEASE READ!!!

00:54

Mac Installation

11:41

CODE: Mac Installation

00:32

Windows Installation

03:32

+ – Creating Databases and Tables

20 lectures 39:12

Section 3 Introduction

01:09

Creating Databases

05:20

CODE: Creating Databases

00:07

Dropping Databases

01:46

CODE: Dropping Databases

00:06

Using Databases

03:00

CODE: Using Databases

00:02

Introduction to Tables

05:09

The Basic Datatypes

07:52

Note about INT max size

00:08

Basic Datatypes Challenge

02:35

Basic Datatypes Challenge - Solution

00:00

Creating Your Own Tables

03:06

CODE: Creating Your Own Tables

00:03

How Do We Know It Worked?

02:33

CODE: How Do We Know It Worked?

00:02

Dropping Tables

01:36

CODE: Dropping Tables

00:03

Creating Your Own Tables Challenge

04:29

CODE: Creating Your Own Tables Challenge

00:03

+ – Inserting Data (and a couple other things)

23 lectures 58:23

Section 4 Introduction

01:40

Inserting Data

05:03

CODE: Inserting Data

00:04

Super Quick Intro To SELECT

02:07

CODE: Super Quick Intro To SELECT

00:00

Multiple INSERT

03:00

CODE: Multiple Insert

00:03

INSERT Challenges

01:35

Note about using quotes inside of inserted values

00:15

INSERT Challenges Solution

04:43

CODE: INSERT Challenges Solution

00:13

NOTE: MySQL Warnings

00:12

MySQL Warnings

05:35

CODE: MySQL Warnings

00:15

NULL and NOT_NULL

06:54

CODE: NULL and NOT NULL

00:21

Setting Default Values

07:17

CODE: Setting Default Values

00:26

A Primer On Primary Keys

12:21

CODE: A Primer on Primary Keys

00:30

Table Constraints Exercise

01:51

Table Constraints Exercise Solution

03:34

CODE: Table Constraints Exercise Solution

00:21

+ – CRUD commmands

24 lectures 41:23

Section 5 Introduction

01:30

Introduction to CRUD

01:44

CODE: Introduction to CRUD

00:01

Preparing Our Data

02:29

CODE: Preparing Our Data

00:18

Official Introduction to SELECT

04:18

CODE: Official Introduction to SELECT

00:11

Introduction to WHERE

05:04

CODE: Introduction to WHERE

00:07

SELECT Challenges

02:00

SELECT Challenges Solution

02:45

CODE: SELECT Challenges Solution

00:08

Introduction to Aliases

02:55

CODE: Introduction to Aliases

00:05

The UPDATE Command

03:58

CODE: The UPDATE Command

00:05

UPDATE Challenges

00:37

UPDATE Challenges Solution

03:58

CODE: UPDATE Challenges Solution

00:16

Introduction to DELETE

04:41

CODE: Introduction to DELETE

00:06

DELETE Challenges

01:10

DELETE Challenges Solution

02:45

CODE: DELETE Challenges Solution

00:09

+ – CRUD Challenge Section

10 lectures 25:28

Section 6 Introduction

01:52

CRUD Exercise Overview

07:26

CRUD Exercise Create Solution

05:55

CODE: CRUD Exercise Create Solution

00:22

CRUD Exercise Read Solution

01:48

CODE: CRUD Exercise Read Solution

00:04

CRUD Exercise Update Solution

04:10

CODE: CRUD Exercise Update Solution

00:17

CRUD Exercise Delete Solution

03:21

CODE: CRUD Exercise Delete Solution

00:11

+ – The World Of String Functions

22 lectures 01:19:00

Section 7 Introduction

02:04

Important Note about Running SQL Files (please read)

00:13

Running SQL Files

10:15

CODE: Running SQL Files

00:09

Loading Our Book Data

05:25

CODE: Loading Our Book Data

00:51

Working with CONCAT

11:07

CODE: Working With CONCAT

00:20

Introducing SUBSTRING

10:04

CODE: Introducing SUBSTRING

00:21

Introducing REPLACE

06:39

CODE: Introducing REPLACE

00:24

Using REVERSE

03:39

CODE: Using REVERSE

00:04

Working with CHAR LENGTH

04:54

CODE: Working with CHAR LENGTH

00:04

Changing Case with UPPER and LOWER

03:20

CODE: Changing Case with UPPER and LOWER

00:06

Note about string functions

00:46

String Function Challenges

04:42

String Function Challenges Solution

13:08

CODE: String Function Challenges Solution

00:22

+ – Refining Our Selections

16 lectures 01:05:21

Section 8 Introduction

00:35

Seed Data: Adding A Couple New Books

02:47

CODE: Seed Data: Adding A Couple New Books

00:09

Using DISTINCT

08:24

CODE: Using DISTINCT

00:06

Sorting Data with ORDER BY

11:19

CODE: Sorting Data with ORDER BY

00:32

Using LIMIT

09:03

CODE: Using LIMIT

00:31

Better Searches with LIKE

07:42

CODE: Better Searches with LIKE

00:10

LIKE Part 2: More Wildcards

06:09

CODE: LIKE Part 2: More Wildcards

00:11

Refining Selections Exercises

04:52

Refining Selections Exercises Solution

12:29

CODE: Refining Selections Exercises Solution

00:20

+ – The Magic of Aggregate Functions

18 lectures 01:08:42

Section 9 Introduction

03:56

The Count Function

08:38

CODE: The Count Function

00:10

The Joys of Group By

12:22

CODE: The Joys of Group By

00:20

Min and Max Basics

04:12

CODE: MIN and MAX Basics

00:06

SUBQUERIES - A Problem with Min and Max

07:14

CODE: A Problem with Min and Max

00:15

Using Min and Max with Group By

06:39

CODE: Using Min and Max with Group By

00:08

The Sum Function

04:27

CODE: The Sum Function

00:07

The Avg Function

06:00

CODE: The Avg Function

00:08

Aggregate Functions Challenges

04:27

Aggregate Functions Challenges Solution

09:10

CODE: Aggregate Functions Challenges Solution

00:22

+ – Revisiting Data Types

23 lectures 01:42:22

Section 10 Introduction

01:56

CHAR and VARCHAR

14:29

Note about CHAR and VARCHAR

00:05

CODE: CHAR and VARCHAR

00:11

DECIMAL

06:07

CODE: DECIMAL

00:06

FLOAT and DOUBLE

07:44

CODE: FLOAT and DOUBLE

00:07

Note about setting the timezone in Cloud9

00:07

DATE, TIME, and DATETIME

04:31

Creating Our DATE data

05:49

CODE: Creating Our DATE data

00:09

CURDATE, CURTIME, and NOW

05:15

Note about formatting dates

00:09

Formatting Dates

14:29

CODE: Formatting Dates

00:24

Date Math

09:40

CODE: Date Math

00:17

Working with TIMESTAMPS

10:54

CODE: Working with TIMESTAMPS

00:25

Data Types Exercises

04:50

Data Types Exercises Solution

13:58

CODE: Data Types Exercises Solution

00:36

8 more sections

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

Featured review

Nassim Badaoui ( 35 courses, 1 review )

9 months ago

The course was great. Colt gives a lot of detailed information and breaks it down into small chunks with many excercises. Although this can make the course seem slow at times one can always skip something that is already known or speed up the playback rate. I was very satisfied with what I got and will pursue other courses created by Colt.