SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL

19,039 students enrolled

SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL

SQL skills are in demand. Learn to master SQL using MySQL. Become a SQL Guru today!

19,039 students enrolled

Created by John Thompson

Last updated 11/2019

English

English

Preview this course

SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL

$139.99 $199.99 30% off

5 hours left at this price!

30-Day Money-Back Guarantee

11 hours on-demand video
10 articles
114 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

Become a SQL Guru! Be that 'go-to' person!
Master SQL to create reports from realistic MySQL databases
See how to aggregate and analyze data using SQL functions
Create your own database through the power of SQL
Understand How to Leverage Database Transactions
Tune SQL statements for optimum performance
Avoid common mistakes with SQL

+ – SQL Beginner to Guru MySQL Edition Introduction

4 lectures 15:56

Learn how you can get the most out of your SQL Beginner to Guru course!

Getting the Most out of Your SQL Course

Preview 04:04

Learn about the exclusive Slack community for the course where you can interact with other students learning SQL!

Slack Group for SQL Beginner to Guru MySQL Edition

00:49

In this lecture you get to write your first SQL. See how you can create a database table using SQL, then add data to the table & get information back!

SQL - Let's write our first SQL!

Preview 07:46

In this lecture you see a step by step review of the SQL assignment from the previous lecture.

SQL Fiddle Assignment Review

Preview 03:17

+ – Introduction to SQL

11 lectures 01:19:09

Introduction lecture to the section of the course to introduce students to the SQL language.

Introduction to SQL

Preview 01:03

SQL is the language we use to work with data stored in a relational database. In this lecture, we look at what a database is and establish common terminology.

What is a Database?

Preview 08:35

Relational Database Principles

Preview 13:08

Assignment: Create Tables and Insert Data

Preview 02:33

Assignment Review: Create Tables and Insert Data

Preview 03:27

History of SQL

13:31

What is a Relational Database Management System?

11:19

History of MySQL

10:41

RDBMS Deployment Architectures

09:25

Flashcards

04:52

Conclusion

00:35

+ – Installation of MySQL

9 lectures 28:27

Preview 01:45

Review of MySQL Installation Options

03:26

MySQL Windows 10 Installation Quick Start

Preview 00:38

MySQL Windows 10 Installation

Preview 06:07

MySQL OSX Installation Quick Start

Preview 01:03

MySQL OSX Installation

Preview 06:05

MySQL Linux Installation Quick Start

01:11

MySQL Linux Installation Ubuntu

03:21

MySQL Linux Installation CentOS

04:51

+ – Connecting to MySQL

9 lectures 30:56

Preview 01:17

Connecting to MySQL Overview

07:45

MySQL Command Line for OSX and Linux

05:06

MySQL Command Line for Docker

07:47

MySQL Workbench Windows Installation Quick Start

Preview 00:37

MySQL Workbench OSX Installation Quick Start

Preview 00:19

MySQL Workbench OSX Installation

07:14

MySQL Workbench Linux Installation Quick Start

00:50

MySQL Workbench Linux Installation

00:00

+ – Selecting Data from a Single Table

28 lectures 02:08:08

Preview 02:51

Importing the MySQL Employee Database

Preview 06:44

Assignment use SQL to get Row Counts

Preview 00:47

Get the Row Counts of Each Table

Quiz - SQL Row Counts

6 questions

Assignment Review - Use SQL to get Row Counts

Preview 02:22

Review of the SQL Select Statement

Preview 05:13

Selecting Specific Columns from Tables

Preview 01:56

Using Aliases to Name Columns

Preview 02:54

Using the SQL CONCAT Function to Join Columns

Preview 02:26

SQL Arithmetic Operators

Preview 02:26

Using SQL Arithmetic Operators in Selecting Data

Preview 07:14

Preview 16:24

Formatting Date Values with MySQL

Preview 06:45

Using the LEFT and RIGHT MySQL Functions

04:02

SQL Select Clause Quiz

7 questions

Introduction to the SQL WHERE Clause

08:44

SQL WHERE Clause with Equals and Not Equals

03:19

Using AND and OR with SQL WHERE Clause

03:52

Using IN and NOT IN with with SQL WHERE Clause

05:03

Dealing with NULL Values in SQL WHERE Clause

03:27

Using Greater Than and Less Than with SQL WHERE Clause

04:00

Using LIKE and NOT LIKE with SQL WHERE Clause

03:49

Using BETWEEN and NOT BETWEEN with SQL WHERE Clause

04:30

Ordering Results with SQL ORDER BY

04:30

Limit Results with SQL LIMIT Clause

06:19

Using SQL to Select DISTINCT Values

02:12

Using SQL Sub-selects with IN in SQL Where Clause

03:12

Assignment - Fix SQL Statements

02:05

Assignment Review

08:44

Conclusion

02:18

+ – Grouping and Summarizing Data with SQL

10 lectures 28:38

Preview 01:00

Using the SQL GROUP By clause

Preview 02:49

MySQL Aggregate Functions

Preview 02:03

Using the SQL HAVING Clause

04:17

Using the SQL SUM Function

02:00

Using the SQL Min and Max Functions

05:50

Using the SQL AVG Function

03:55

Assignment - Write SQL Report for Salary Information by Year Excluding Managers

01:58

Quiz on results of SQL Report Assignment

Salary Report Quiz

3 questions

Assignment Review

04:12

Conclusion

00:34

+ – Using SQL to Select Data from More Than One Table

16 lectures 01:06:13

Preview 01:15

Overview of SQL Table Joins

Preview 05:13

Introduction to SQL Inner Joins

Preview 03:34

Using Table Aliases with SQL Inner Joins

03:38

Limiting Columns Displayed with SQL Inner Joins

03:02

Using a WHERE Clause with SQL Inner Joins

04:33

Assignment - Create Department Employee Report

01:44

Assignment Review - Create Department Employee Report

06:52

Using SQL Natural Joins

03:10

Using SQL Equi-Joins

04:48

Using SQL Union Joins

05:04

Other MySQL Functions

08:55

Using SQL LEFT OUTER JOINS

05:09

Assignment - Write SQL LEFT OUTER JOIN

01:32

Assignment Review - Write SQL LEFT OUTER JOIN

06:13

Conclusion

01:31

+ – Using SQL to Insert Data

11 lectures 32:42

Preview 00:44

Overview of the SQL Insert Statement

Preview 02:44

Example SQL Insert Statement

Preview 02:38

Specifying Columns in SQL Inserts

04:05

Assignment - Use SQL to create a record in DEPARTMENTS table

00:45

Assignment Review - Use SQL to create a record in DEPARTMENTS table

05:07

Using a SQL Sub-select with SQL Insert Statements

04:02

SQL Core Concept - Foreign Key Constraints

04:24

Assignment - Use SQL Inserts to create a new Employee

Preview 00:51

Assignment Review - Use SQL Inserts to create a new Employee

06:23

Conclusion

00:59

+ – Using SQL to Update Data

11 lectures 24:28

Preview 01:23

Overview of the SQL Update Statement

Preview 03:55

Example SQL Update Statement

Preview 03:07

Assignment - Use SQL Update Statement to Change Employee Name

00:48

Assignment Review - Use SQL Update Statement to Change Employee Name

02:22

Assignment - Using SQL Update and Insert to Create a New Salary Record

01:40

Assignment Review - Using SQL Update and Insert to Create a New Salary Record

03:35

Using SQL to drop the employee database

02:49

Assignment - Re-import the employee database

00:43

Assignment - Review re-import employee database

03:26

Conclusion

00:40

+ – Using SQL to Delete Data

6 lectures 19:16

Preview 01:00

Overview of the SQL DELETE statement

02:33

Example of the SQL DELETE Statement

09:42

Assignment - Create, Update, and Delete an Employee record

01:20

Assignment Review - Create, Update, and Delete an Employee Record

04:05

Conclusion

00:36

6 more sections

Requirements

Just a computer - Any modern PC, Mac or Linux system will work!
Fundamental computer skills are helpful (you understand what files and directories are)

Description

SQL is the programming language used to get data in and out of databases. Relational Databases are extremely popular with companies of all sizes.

Employers are searching for people with SQL skills. Go to any popular jobs site, and search for the keyword 'SQL'. You will see 10's of THOUSANDS of job postings.

Right now these positions are going unfilled - because companies cannot find enough people with SQL skills.

In this course, you will learn how to use SQL using the MySQL relational database - the most popular database in the world.

No previous SQL experience is needed. This course is perfect for beginners.

In this course, you will:

Learn how to install MySQL on your computer.
Learn how to install MySQL Workbench on your computer.
See how to import the famous MySQL employee database into your MySQL database.
Get hands on experience generating SQL reports.
Master SQL join statements.
Create table joins using database tables with MILLIONS of records!
See how easy it is to use SQL to update one record or many records in the database.
Learn to use SQL Sub-Selects.
Write advanced SQL reports against a ecommerce database.
Understand what database transactions are, and the tools you have to control them with MySQL.
Use SQL to create tables in your MySQL database.
Learn the MySQL syntax to alter existing database tables.
Tackle challenging real world like assignments for SQL reporting and database maintenance tasks.
Leverage SQL views for common reports.

Course Extras

Slack Community - Join the instructor, teacher's assistants, and other students in a Slack Community exclusive to this course!
All Source Code in GitHub - Get access to all source code used in course via GitHub (no experience with GitHub necessary)
All Lecture Slides Downloadable as PDFs - Download lecture slides for study and future reference!

Other Databases?

This course is focused on using SQL with the MySQL database.

SQL is a standard, which which is supported by many other databases. The SQL skills you learn in this course can be applied to other databases such as Postgres, Oracle, and MS SQL Server.

There is a ton of demand for people with SQL skills. In the US, there are over 100,000 job openings for people with SQL skills.

Through this course, you will master SQL.

Open the door to new opportunities and enroll today!

Who this course is for:

Anyone wishing to learn how to use SQL!

Featured review

Patrick Skelley ( 39 courses, 11 reviews )

a year ago

John T. is fantastic, tons of experience and gives you a high level idea of how parts of the industry have evolve. John gives options for lectures based on skill level, particularly in set up. I would have personally liked more interaction with the command line as opposed to workbench and some talk on how to be command line efficient in SQL in the workplace. That's the only reason I'm giving 4.5 stars. One other thing, I speed up videos at least 1.5 or 1.75x speed.