Discover new courses and celebrate learning with us today. 🎓

Explore

Development

Web Development

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

4.9

315,475 rating
11 Lessons
229 Students
Last updated 2 months ago

By John Thompson • 500,000+ Enrollments Worldwide

By Spring Ahead Code Academy

via Udemy

Go To Course

About This Course

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

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 using 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!

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

Course Curriculum

SQL Beginner to Guru MySQL Edition Introduction

5 Lectures

Getting the Most out of Your SQL Course

Slack Group for SQL Beginner to Guru MySQL Edition

GitHub Workflow

SQL - Let's write our first SQL!

SQL Fiddle Assignment Review

Introduction to SQL

11 Lectures

Introduction to SQL

What is a Database?

Relational Database Principles

Assignment: Create Tables and Insert Data

Assignment Review: Create Tables and Insert Data

History of SQL

What is a Relational Database Management System?

History of MySQL

RDBMS Deployment Architectures

Flashcards

Conclusion

Installation of MySQL

9 Lectures

Introduction

Review of MySQL Installation Options

MySQL Windows 10 Installation Quick Start

MySQL Windows 10 Installation

MySQL OSX Installation Quick Start

MySQL OSX Installation

MySQL Linux Installation Quick Start

MySQL Linux Installation Ubuntu

MySQL Linux Installation CentOS

Connecting to MySQL

9 Lectures

Introduction

Connecting to MySQL Overview

MySQL Command Line for OSX and Linux

MySQL Command Line for Docker

MySQL Workbench Windows Installation Quick Start

MySQL Workbench OSX Installation Quick Start

MySQL Workbench OSX Installation

MySQL Workbench Linux Installation Quick Start

MySQL Workbench Linux Installation

Selecting Data from a Single Table

28 Lectures

Introduction

Importing the MySQL Employee Database

Assignment use SQL to get Row Counts

Quiz - SQL Row Counts

Assignment Review - Use SQL to get Row Counts

Review of the SQL Select Statement

Selecting Specific Columns from Tables

Using Aliases to Name Columns

Using the SQL CONCAT Function to Join Columns

SQL Arithmetic Operators

Using SQL Arithmetic Operators in Selecting Data

SQL Data Types

Formatting Date Values with MySQL

Using the LEFT and RIGHT MySQL Functions

SQL Select Clause Quiz

Introduction to the SQL WHERE Clause

SQL WHERE Clause with Equals and Not Equals

Using AND and OR with SQL WHERE Clause

Using IN and NOT IN with with SQL WHERE Clause

Dealing with NULL Values in SQL WHERE Clause

Using Greater Than and Less Than with SQL WHERE Clause

Using LIKE and NOT LIKE with SQL WHERE Clause

Using BETWEEN and NOT BETWEEN with SQL WHERE Clause

Ordering Results with SQL ORDER BY

Limit Results with SQL LIMIT Clause

Using SQL to Select DISTINCT Values

Using SQL Sub-selects with IN in SQL Where Clause

Assignment - Fix SQL Statements

Assignment Review

Conclusion

Grouping and Summarizing Data with SQL

10 Lectures

Introduction

Using the SQL GROUP By clause

MySQL Aggregate Functions

Using the SQL HAVING Clause

Using the SQL SUM Function

Using the SQL Min and Max Functions

Using the SQL AVG Function

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

Salary Report Quiz

Assignment Review

Conclusion

Using SQL to Select Data from More Than One Table

16 Lectures

Introduction

Overview of SQL Table Joins

Introduction to SQL Inner Joins

Using Table Aliases with SQL Inner Joins

Limiting Columns Displayed with SQL Inner Joins

Using a WHERE Clause with SQL Inner Joins

Assignment - Create Department Employee Report

Assignment Review - Create Department Employee Report

Using SQL Natural Joins

Using SQL Equi-Joins

Using SQL Union Joins

Other MySQL Functions

Using SQL LEFT OUTER JOINS

Assignment - Write SQL LEFT OUTER JOIN

Assignment Review - Write SQL LEFT OUTER JOIN

Conclusion

Using SQL to Insert Data

11 Lectures

Introduction

Overview of the SQL Insert Statement

Example SQL Insert Statement

Specifying Columns in SQL Inserts

Assignment - Use SQL to create a record in DEPARTMENTS table

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

Using a SQL Sub-select with SQL Insert Statements

SQL Core Concept - Foreign Key Constraints

Assignment - Use SQL Inserts to create a new Employee

Assignment Review - Use SQL Inserts to create a new Employee

Conclusion

Using SQL to Update Data

11 Lectures

Introduction

Overview of the SQL Update Statement

Example SQL Update Statement

Assignment - Use SQL Update Statement to Change Employee Name

Assignment Review - Use SQL Update Statement to Change Employee Name

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

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

Using SQL to drop the employee database

Assignment - Re-import the employee database

Assignment - Review re-import employee database

Conclusion

Using SQL to Delete Data

6 Lectures

Introduction

Overview of the SQL DELETE statement

Example of the SQL DELETE Statement

Assignment - Create, Update, and Delete an Employee record

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

Conclusion

Using SQL Transactions

10 Lectures

Introduction

Introduction to SQL Transactions

Demonstration of Database Transactions

Assignment - Create Employee Using SQL Transactions

Assignment Review - Create Employee Using SQL Transactions

Demonstration of Database Locks

User Defined Variables in MySQL

Demonstration of Lost SQL Updates

Using SQL Select for Update

Conclusion

Advanced SQL Reporting

14 Lectures

Introduction to Advanced SQL Reporting

Overview of the Northwind Database

Assignment - Import the Northwind Database

Assignment Review - Import the Northwind Database

Assignment - Create Orders Report

Assignment Review - Create Orders Report

Assignment - Monthly Sales Report by State

Assignment Review - Monthly Sales Report by State

Assignment - Create Monthly Profit Report by Item

Assignment Review - Create Monthly Profit Report by Item

Assignment - Create a Weekly Sales Report by Employee

Assignment Review - Create a Weekly Sales Report by Employee

Weekly Sales Report by Employee Revisted

Conclusion

Introduction to DDL Statements - Creating SQL Views

5 Lectures

Introduction to Views

Demonstration using SQL DDL Creating a Database View

Assignment - Create Orders View

Assignment Review - Create Orders View

Materialized Views in MySQL

Using SQL to Create MySQL Database Tables

12 Lectures

Overview of SQL Create Table Syntax

Creating a Table with SQL Select

SQL Truncate Table Command

SQL Drop Table Command

SQL Create Table Example

SQL Create Table Example with Primary Key

SQL Create Table with Auto-Increment Primary Key

SQL Create Table with Foreign Keys

SQL Create Table with Indexes

SQL Create Table with Unique Indexes

Assignment - SQL Create Table

Assignment Review - SQL Create Table

Using SQL to Update Tables

8 Lectures

Introduction to the SQL Alter Table Command

Using SQL Alter Table Command to Add and Remove a Column

Using SQL Alter Table to Reorder Columns

Using SQL Alter Table Command to Add or Remove an Index

Using SQL Alter Table Command to Add or Remove a Foreign Key Constraint

Assignment - Add ASIN, UPC, and EAN to Book Table using SQL Alter Table Command

Assignment Review - Add ASIN, UPC, EAN to Book Table using SQL Alter Table Cmd

Using SQL Alter Table for MySQL Generated Columns

Appendix A

3 Lectures

Udemy Interface Explained - For new Udemy Users

GitHub Basics

GitHub Workflow

Instructors

John Thompson • 500,000+ Enrollments Worldwide

4.9

315,475 Reviews
345 Students
34 Course

Hi. I'm John.I've been in the IT industry for over 25 years. Today, I specialize mainly in Java, the most successful and widely known programming language in use today. I also specialize with the Spring Framework, which the most popular open source application framework for building enterprise class applications on the Java platform. Just some of the organizations I've worked...

Instructors

Spring Ahead Code Academy

4.9

315,475 Reviews
345 Students
34 Course

Spring Ahead Code Academy was established by John Thompson, founder of Spring Framework Guru. John has over 25 years of programming experience and has taught over 250,000 students in 180 different countries. Spring Ahead Code Academy is collation of experienced professional developers helping others learn to code.Our goal is to bring together real world professionals, to share real world experience...

More Courses By John Thompson • 500,000+ Enrollments Worldwide, Spring Ahead Code Academy

Mastering Thymeleaf with Spring Boot

4.9

(230)

Spring Framework DevOps on AWS

4.9

(230)

Ready for Production with Spring Boot Actuator

4.9

(230)

Docker for Java Developers

4.9

(230)

Spring Framework 5: Beginner to Guru

4.9

(230)

Review

4.9 course rating

4K ratings

Jagadeesh R.

5.0

7 months ago

good

Helpful
Not helpful

John M. O.

5.0

8 months ago

I am learning so much about MySQL and instructor is very knowledgeable and teaching concisely. I would like to take more of his courses, if possible.

Helpful
Not helpful

Mandadi P. K. R.

4.0

10 months ago

Good Course for SQL learning

Helpful
Not helpful

Pankaj S.

5.0

11 months ago

The session was very insightful those are a beginner in SQL

Helpful
Not helpful

Jordy S. C.

5.0

1 year ago

Amazing

Helpful
Not helpful

Kurt O.

1.0

1 year ago

Source material is crap. The most essential for the course it's database is not importable, so you can't do this course at all. Don't buy this course, and last but not least the instructor doesn't even bother to reply to your questions.

Helpful
Not helpful

Cristina M.

5.0

1 year ago

Useful and very informative.

Helpful
Not helpful

Paweł Z.

3.5

2 years ago

It lacks some materials that are stated to be in the course. Anyways quite nice course.

Helpful
Not helpful

Atchaya R.

3.5

2 years ago

Its good for me.

Helpful
Not helpful

Munna S.

3.0

2 years ago

content was not too detailed.

Helpful
Not helpful

Ratings

This course includes:

54.5 hours on-demand video
3 articles
249 downloadable resources
Access on mobile and TV
Full lifetime access
Certificate of completion

Courses You May Like

Lorem ipsum dolor sit amet elit

Show More Courses

Become a Certified Web Developer: HTML, CSS and JavaScript

4.9

(230)

By: Carolyn Welborn

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

About This Course

Course Curriculum

Instructors

John Thompson • 500,000+ Enrollments Worldwide