The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert
4.7 (1,367 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
11,594 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert to your Wishlist.

Add to Wishlist

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
Bestselling
4.7 (1,367 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
11,594 students enrolled
Created by Colt Steele
Last updated 8/2017
English
English
Curiosity Sale
Current price: $10 Original price: $180 Discount: 94% off
30-Day Money-Back Guarantee
Includes:
  • 20.5 hours on-demand video
  • 126 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
313 Lectures
20:49:20
+
Getting Started: Overview and Installation
15 Lectures 01:01:47
Section Introduction
01:02

What Is a Database?
07:16

SQL Vs. MySQL
05:50

Installation Overview - WATCH BEFORE INSTALLING
05:10

Setting Up Cloud9
04:47

Cloud9: What If I Don't Have a Credit Card?
00:44

Exploring The Cloud9 Interface
05:51

Cloud9 Interface Challenge
02:42

Installing MySQL on Cloud9
08:35

CODE: Installing MySQL on Cloud9
00:03

Your First MySQL Activity
03:58

CODE: Your First MySQL Activity
00:01

Mac Installation
11:41

CODE: Mac Installation
00:34

Windows Installation
03:32
+
Creating Databases and Tables
19 Lectures 39:09
Section 3 Introduction
01:09

Creating Databases
05:20

CODE: Creating Databases
00:08

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

Basic Datatypes Challenge
02:35

Basic Datatypes Challenge - Solution
00:00

Creating Your Own Tables
03:06

CODE: Creating Your Own Tables
00:05

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:04
+
Inserting Data (and a couple other things)
21 Lectures 58:18
Section 4 Introduction
01:40

Inserting Data
05:03

CODE: Inserting Data
00:05

Super Quick Intro To SELECT
02:07

CODE: Super Quick Intro To SELECT
00:01

Multiple INSERT
03:00

CODE: Multiple Insert
00:03

INSERT Challenges
01:35

INSERT Challenges Solution
04:43

CODE: INSERT Challenges Solution
00:16

MySQL Warnings
05:35

CODE: MySQL Warnings
00:17

NULL and NOT_NULL
06:54

CODE: NULL and NOT NULL
00:25

Setting Default Values
07:17

CODE: Setting Default Values
00:31

A Primer On Primary Keys
12:21

CODE: A Primer on Primary Keys
00:34

Table Constraints Exercise
01:51

Table Constraints Exercise Solution
03:34

CODE: Table Constraints Exercise Solution
00:24
+
CRUD commmands
24 Lectures 41:38
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:20

Official Introduction to SELECT
04:18

CODE: Official Introduction to SELECT
00:13

Introduction to WHERE
05:04

CODE: Introduction to WHERE
00:09

SELECT Challenges
02:00

SELECT Challenges Solution
02:45

CODE: SELECT Challenges Solution
00:09

Introduction to Aliases
02:55

CODE: Introduction to Aliases
00:06

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:18

Introduction to DELETE
04:41

CODE: Introduction to DELETE
00:08

DELETE Challenges
01:10

DELETE Challenges Solution
02:45

CODE: DELETE Challenges Solution
00:11
+
CRUD Challenge Section
10 Lectures 25:35
Section 6 Introduction
01:52

CRUD Exercise Overview
07:26

CRUD Exercise Create Solution
05:55

CODE: CRUD Exercise Create Solution
00:24

CRUD Exercise Read Solution
01:48

CODE: CRUD Exercise Read Solution
00:05

CRUD Exercise Update Solution
04:10

CODE: CRUD Exercise Update Solution
00:20

CRUD Exercise Delete Solution
03:21

CODE: CRUD Exercise Delete Solution
00:13
+
The World Of String Functions
20 Lectures 01:18:19
Section 7 Introduction
02:04

Running SQL Files
10:15

CODE: Running SQL Files
00:11

Loading Our Book Data
05:25

CODE: Loading Our Book Data
00:48

Working with CONCAT
11:07

CODE: Working With CONCAT
00:25

Introducing SUBSTRING
10:04

CODE: Introducing SUBSTRING
00:23

Introducing REPLACE
06:39

CODE: Introducing REPLACE
00:23

Using REVERSE
03:39

CODE: Using REVERSE
00:05

Working with CHAR LENGTH
04:54

CODE: Working with CHAR LENGTH
00:06

Changing Case with UPPER and LOWER
03:20

CODE: Changing Case with UPPER and LOWER
00:07

String Function Challenges
04:42

String Function Challenges Solution
13:08

CODE: String Function Challenges Solution
00:31
+
Refining Our Selections
16 Lectures 01:05:28
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:07

Sorting Data with ORDER BY
11:19

CODE: Sorting Data with ORDER BY
00:32

Using LIMIT
09:03

CODE: Using LIMIT
00:32

Better Searches with LIKE
07:42

CODE: Better Searches with LIKE
00:11

LIKE Part 2: More Wildcards
06:09

CODE: LIKE Part 2: More Wildcards
00:12

Refining Selections Exercises
04:52

Refining Selections Exercises Solution
12:29

CODE: Refining Selections Exercises Solution
00:23
+
The Magic of Aggregate Functions
18 Lectures 01:08:52
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:21

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:17

Using Min and Max with Group By
06:39

CODE: Using Min and Max with Group By
00:09

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:25
+
Revisiting Data Types
21 Lectures 01:42:18
Section 10 Introduction
01:56

CHAR and VARCHAR
14:29

Note about CHAR and VARCHAR
00:06

CODE: CHAR and VARCHAR
00:12

DECIMAL
06:07

CODE: DECIMAL
00:07

FLOAT and DOUBLE
07:44

CODE: FLOAT and DOUBLE
00:08

DATE, TIME, and DATETIME
04:31

Creating Our DATE data
05:49

CODE: Creating Our DATE data
00:10

CURDATE, CURTIME, and NOW
05:15

Formatting Dates
14:29

CODE: Formatting Dates
00:25

Date Math
09:40

CODE: Date Math
00:19

Working with TIMESTAMPS
10:54

CODE: Working with TIMESTAMPS
00:27

Data Types Exercises
04:50

Data Types Exercises Solution
13:58

CODE: Data Types Exercises Solution
00:38
8 More Sections
About the Instructor
Colt Steele
4.7 Average rating
34,470 Reviews
146,325 Students
2 Courses
Developer and Bootcamp Instructor

Hi! I'm Colt. I'm a developer with a serious love for teaching. I've spent the last few years teaching people to program at 2 different immersive bootcamps where I've helped hundreds of people become web developers and change their lives. My graduates work at companies like Google, Salesforce, and Square.

Most recently, I led Galvanize's SF's 6 month immersive program as Lead Instructor and Curriculum Director. After graduating from my class, 94% of my students went on to receive full-time developer roles. I also worked at Udacity as a Senior Course Developer on the web development team where I got to reach thousands of students daily.

I’ve since focused my time on bringing my classroom teaching experience to an online environment. In 2016 I launched my Web Developer Bootcamp course, which has since gone on to become one of the best selling and top rated courses on Udemy. I was also voted Udemy’s Best New Instructor of 2016.

I've spent years figuring out the "formula" to teaching technical skills in a classroom environment, and I'm really excited to finally share my expertise with you. I can confidently say that my online courses are without a doubt the most comprehensive ones on the market.

Join me on this crazy adventure!