Learn SQL using MySQL

Learn SQL using MySQL

Learn how to query and extract data from relational databases using MySQL. This course will teach you everything you need to know to mine, manage, and manipulate large volumes of data effectively.

About the course

In this course, you will learn:

  • What is a database and how information is stored in a database
  • How to create, update and access data in a database
  • How to query data using join & Merge operations
  • How to write subqueries

Course Syllabus

Module 1

What is a Database?

  • Introduction to database
  • Database operations
  • DBMS (Database Management System)
  • Introduction to MySQL
  • Show more

Module 2

Defining a Database & Data Manipulation

  • DDL (Data Definition Language) commands
  • DML (Data Manipulation Language) commands
  • Single row functions in MySQL
  • Group functions in MySQL
  • Show more

Module 3


  • Inner join, outer join
  • How to retrieve data using joins with the use of multiple joins
  • Applying set operations on tables

Module 4


  • What are subqueries and how to use them?
  • Group functions in subqueries
  • Sub-queries with conditional logic
  • Joining subqueries
  • Show more

Course certificate

Get a course certificate from Great learning which you can share in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.