SQL - Introduction to SQL with MySQL

Name: SQL - Introduction to SQL with MySQL
Rating: 4.6 (15984 reviews)

Become a SQL Guru by Learning the Building Blocks of Working with SQL using MySQL

Created byKyle Pew • 2,000,000+ Students, Office Newb

Last updated 12/2025

English

What you'll learn

Manage and Interact with Large Datasets with SQL
Provide Data in Order to Answer Top Questions for Meetings
Create and Manage a MySQL Database
Write Complex SQL Queries Using Table Joins
Retrieve Proper Data from a Database Using a SQL WHERE Clause with Criteria

Course content

12 sections • 59 lectures • 3h 7m total length

Welcome to the "Introduction to MySQL" Course5:45
Downloadable MySQL Course Resources2:08
Visit the Course QA Board2:56

SQL WHERE Clause Syntax2:29
Explore the where clause syntax to filter results via a select statement from a table, using equals, greater than, and less than with quoted literals, as shown for country Germany.
Filter Records based on Single Criteria using the WHERE Clause2:25
Filtering Text vs. Numeric Data4:14
Filter text vs numeric data using SQL where clauses: apply equals for strings with quotes, and use greater than or less than on freight values in the orders table.
CHEAT SHEET - Filter Operators used in the WHERE Clause (DOWNLOAD)0:03
Filtering with SQL AND Operator3:22
Learn to apply the SQL and operator to filter records by multiple criteria using the where clause, with examples from the customers table to retrieve USA and Oregon results.
QUICK TIP - MySQL Comments3:19
Filtering Date Values with the Between Operator7:09
Explore filtering date values in MySQL by using the between operator or a range with and on the order date, including quoting dates.
Filtering with SQL OR Operator4:23
Exercise #2 - SQL WHERE Clause0:17
Quiz #3 - SQL Where Clause Quiz

SQL GROUP BY Syntax3:25
Grouping SQL Data by a Column Value2:09
Group by the country column to group the customers table by a single value, producing one record per country and revealing how group by differs from distinct.
QUICK TIP - DISTINCT VS. GROUP BY5:21
Performing Calculations within the Grouped Data3:33
CHEAT SHEET - MySQL Aggregate Functions when Grouping1:33
Filtering Grouped Data with the SQL Having Clause4:37
Exercise #4 - SQL GROUP BY Quiz0:18
Quiz #5 - SQL GROUP BY Quiz

Create a New Database in MySQL2:35
Using the DROP Statement to Delete a Database1:41
Adding Tables to the Database using the CREATE TABLE Statement5:50
Using the DROP Statement to Delete a Table1:29
SQL NOT NULL Constraint1:31
SQL AUTO_INCREMENT Column1:11
Explore the SQL auto increment column, which lets the ID field automatically populate with a numeric value and increment for each new record as users enter data.
SQL PRIMARY KEY Constraint2:34
RECAP - Table Relationships3:46
Explore table relationships in MySQL by linking an employees table to a customers table using a primary key and a foreign key, creating a one-to-many relationship and enabling efficient queries.
SQL FOREIGN KEY Constraint6:53
Exercise #5 - Creating a MySQL Table0:21
Quiz #6 - Creating a SQL Database

Requirements

No Prior Experience with Databases, SQL or MySQL is Necessary. This Course Starts at the Beginner Level
A Computer with Internet Connection (Windows, MAC, or Linux)

Description

LEARN SQL WITH MySQL

In order to make intelligent business decisions you need the proper data. In order to get the proper data you will need to communicate with and query data within a database. This is where SQL comes into play. SQL stands for Structured Query Language. It's the language used to communicate with a database and more importantly the data needed to make intelligent decisions that will save time and money.

WHY THIS COURSE

This SQL course starts with the absolute basic building blocks necessary to communicate effectively with any database. You'll learn how to query and manage a database using MySQL. MySQL is a free open-source relational database management system (RDBMS), used by many of the world's largest organizations.

Each section of the course will focus on a key topic of working with SQL. The video lectures have been created so you can follow along as the instructor demonstrates each concept. At the end of each section you can test your understanding through a section quiz and exercise. Once you complete a section the next section will build on the topics of the previous section. This encourages your learning as you build upon the knowledge you learn as you move from one section to the next.

This course is not just a sit back and watch the instructor type on the screen kind of course. The lectures and course flow has been designed to help you engage in the topic and participate by writing your own SQL. The TRUE LEARNING happens when you apply what you're learning and try it yourself.

The course also contains downloadable resources you can use away from the course as you continue to learn SQL. The QA board found within the course offers you the opportunity to ask questions and get answers from the instructor and interact with the other students enrolled in the course.

COURSE OBJECTIVES

In this SQL course you will learn the fundamental building blocks of creating, querying and working with databases using MySQL.

Learn Proper SQL Syntax Using the MySQL Workbench
Learn Relational Database Design Concepts
Use the SQL SELECT Statement in Order to Query Data from a Database
Use Column Alias to Give additional Context and Meaning to the Data
Learn How to Filtering Database Query Results Using the SQL Where Clause
Create Advanced Queries by Using the Proper Filter Operators
Use the SQL ORDER BY Keyword to Sort the Results of a Query
Learn How to Properly Group Data and Create Calculations for Reporting
Use the SQL HAVING Clause to Filter within Data Groups
Create a MySQL Database from Scratch
Learn How to Create Tables and Manage Records within the Tables
And Much More...

WHAT ARE YOU WAITING FOR

Start your SQL journey by enrolling now. See you in the course!

Who this course is for:

Any Data User that wants to learn how to communicate with a database using SQL

SQL - Introduction to SQL with MySQL

What you'll learn

Explore related topics

Course content

MySQL Course Introduction3 lectures • 11min

Introduction to MySQL3 lectures • 10min

Getting Up and Running with MySQL5 lectures • 23min

Working with SQL SELECT Statement7 lectures • 13min

Filtering SQL Data9 lectures • 28min

MySQL Course Lab #11 lecture • 9min

Sorting SQL Data4 lectures • 7min

Grouping SQL Data7 lectures • 21min

Creating a MySQL Database10 lectures • 28min

Inserting Records into SQL Database Tables4 lectures • 14min

Requirements

Description

Who this course is for: