Learn SQL using MySQL

Learn SQL using MySQL

The course is designed for people who want to learn how to query and extract data from relational databases using MySQL. The course is offered in conjunction with PGP - Artificial Intelligence & Machine Learning as it is important to understand how to extract data before performing analysis on the data.

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

Joins

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

Module 4

Subqueries

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