We may earn an affiliate commission when you visit our partners.
Course image
Kyle Pew and Office Newb

LEARN SQL WITH MySQL

Read more

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.

  • 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.

Enroll now

What's inside

Learning objectives

  • 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

Syllabus

MySQL Course Introduction
Welcome to the "Introduction to MySQL" Course
Downloadable MySQL Course Resources
Visit the Course QA Board
Read more
Introduction to MySQL
What is SQL?
Introduction to Relational Database Design
Why MySQL
Quiz #1 - Introduction to MySQL Quiz
Getting Up and Running with MySQL
Installing MySQL on Windows
Installing MySQL on Windows Continued
Introduction to MySQL Interface
Setting Up the MySQL Course Database
Introduction to Course Database
Working with SQL SELECT Statement
Identify which Database by the USE statement
SQL SELECT Statement Syntax
Using the SELECT Statement to Retrieve Columns from a Table
QUICK TIP - Query All Columns from a Table
Using a Column Name Alias
Removing Duplicate Values by Using the DISTINCT Statement
Exercise #1 - SQL Select
Quiz #2 - SQL SELECT Statement Quiz
Filtering SQL Data
SQL WHERE Clause Syntax
Filter Records based on Single Criteria using the WHERE Clause
Filtering Text vs. Numeric Data
CHEAT SHEET - Filter Operators used in the WHERE Clause (DOWNLOAD)
Filtering with SQL AND Operator
QUICK TIP - MySQL Comments
Filtering Date Values with the Between Operator
Filtering with SQL OR Operator
Exercise #2 - SQL WHERE Clause
Quiz #3 - SQL Where Clause Quiz
Sorting SQL Data
SQL ORDER BY Keyword Syntax
Sort SQL Data Ascending/Descending using the ORDER BY Keyword
Sort SQL Data by Multiple Columns
Exercise #3 - SQL ORDER BY Keyword
Quiz #4 - SQL ORDER BY Quiz
Grouping SQL Data
SQL GROUP BY Syntax
Grouping SQL Data by a Column Value
QUICK TIP - DISTINCT VS. GROUP BY
Performing Calculations within the Grouped Data
CHEAT SHEET - MySQL Aggregate Functions when Grouping
Filtering Grouped Data with the SQL Having Clause
Exercise #4 - SQL GROUP BY Quiz
Quiz #5 - SQL GROUP BY Quiz
Creating a MySQL Database
Create a New Database in MySQL
Using the DROP Statement to Delete a Database
Adding Tables to the Database using the CREATE TABLE Statement
Using the DROP Statement to Delete a Table
SQL NOT NULL Constraint
SQL AUTO_INCREMENT Column
SQL PRIMARY KEY Constraint
RECAP - Table Relationships
SQL FOREIGN KEY Constraint
Exercise #5 - Creating a MySQL Table
Quiz #6 - Creating a SQL Database
Inserting Records into SQL Database Tables
SQL INSERT INTO Statement Syntax
Inserting Data into Specific Columns of a Table
Inserting Data into Every Column of a Table
Exercise #6 - Inserting Records
Quiz #7 - Inserting Records
Querying Multiple Tables with a Relationship
SQL Table JOIN Syntax
SQL INNER JOIN
SQL LEFT and RIGHT JOIN
SQL IS NULL Value
Exercise #7 - SQL Table JOIN
Quiz #8 - SQL Table JOINS
Congratulations
Congratulations on Completing the Introduction to SQL Course

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Develops advanced proficiency in data management and querying using SQL and MySQL Workbench, catering to the needs of professionals seeking to enhance their data analysis skills
Enhances data comprehension and utilization by teaching how to filter, sort, and group data for informed decision-making
Provides hands-on practice through exercises and quizzes, reinforcing concepts and ensuring learners' understanding
Suitable for beginners seeking to establish a solid foundation in SQL and data management
Delivered by Kyle Pew and Office Newb, recognized experts in SQL and data management, offering learners access to industry insights
Recommended for individuals seeking to advance their careers in data analysis, business intelligence, or related fields

Save this course

Save SQL - Introduction to SQL with MySQL to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in SQL - Introduction to SQL with MySQL with these activities:
Join a study group
Engage with fellow learners to discuss concepts, solve problems, and enhance your understanding.
Show steps
  • Find a study group or create your own
  • Set regular meeting times
  • Prepare and participate in discussions
Review SQL syntax
Practice writing and executing basic SQL queries to strengthen your understanding of the language.
Browse courses on SQL Syntax
Show steps
Follow tutorials on advanced SQL concepts
Supplement your learning with video tutorials or online courses to delve deeper into advanced SQL concepts.
Browse courses on Advanced SQL
Show steps
One other activity
Expand to see all activities and additional details
Show all four activities
Build a small database application
Apply your SQL skills by designing and developing a simple database application that solves a real-world problem.
Browse courses on Database Design
Show steps
  • Define the problem and gather requirements
  • Design the database schema
  • Create the database and implement the application
  • Test and refine the application

Career center

Learners who complete SQL - Introduction to SQL with MySQL will develop knowledge and skills that may be useful to these careers:

Reading list

We haven't picked any books for this reading list yet.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to SQL - Introduction to SQL with MySQL.
SQL Tutorial: Learn SQL with MySQL Database - Updated...
Most relevant
SQL - The Complete Developer's Guide (MySQL, PostgreSQL)
Most relevant
Calculate Data in SQL using MySQL Workbench
Most relevant
Clean Data in SQL using MySQL Workbench
Most relevant
SQL for Data Analysis: Beginner MySQL Business...
Most relevant
How to Use SQL with Large Datasets
Most relevant
Introduction to SQL
Most relevant
SQL for Beginners: Learn SQL using MySQL and Database...
Most relevant
Introduction to SQL
Most relevant
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser