SQL Fundamentals

By completing this course, you will acquire the skills to effectively query databases, manipulate data, and apply advanced SQL techniques across real-world datasets.

You will learn to:

Analyze data with the database using SQL
Work with live databases in the cloud and manipulate multiple tables.
Perform CRUD operations using SQL statements like CREATE, INSERT, SELECT, UPDATE, and DELETE.
Filter, sort, group, and aggregate data to extract meaningful insights.
Use advanced SQL techniques such as joins, views, transactions, and stored procedures.
Apply relational database concepts to MySQL, PostgreSQL, SQL Server, IBM Db2, and Oracle systems.

Course Overview

This course offers practical, hands-on experience with SQL to build a solid foundation for careers in data analytics, data science, data warehousing, and data engineering. This course is designed to help you learn and apply foundational and intermediate knowledge of the SQL language and become familiar with many relational database (RDBMS) concepts along the way.

You will start by performing basic Create, Read, Update and Delete (CRUD) operations using CREATE, SELECT, INSERT, UPDATE, and DELETE statements. You will also learn to filter, order, sort, and aggregate data and work with functions, perform sub-selects and nested queries, and JOIN data in multiple tables. You will learn to work with VIEWS, transactions, and create stored procedures.

Throughout the course, you will create a relational database instance in the cloud and practice writing SQL queries on live datasets.

At the end of the course, you will complete a final project to demonstrate your SQL proficiency. This project will involve working with multiple datasets to answer questions and deliver insights, much like tasks performed in real data-related roles.

Course Syllabus

Module 0: Welcome

Video: Course Introduction
Reading: General Information
Reading: Learning Objectives and Syllabus
Reading: Grading Scheme

Module 1: Getting Started with SQL

Reading: Module 1 Introduction and Learning Objectives
Video: Introduction to Databases
Video: SELECT Statement
Reading: SELECT Statement Example
Lab: Simple SELECT Statements
Video: COUNT, DISTINCT, LIMIT
Lab: COUNT, DISTINCT, LIMIT
Video: INSERT Statement
Video: UPDATE and DELETE Statement
Practice Quiz: Module 1: Getting Started with SQL
Reading: Summary & Highlights: Module 1: Getting Started with SQL
Graded Quiz: Module 1: Getting Started with SQL

Module 2: Introduction to Relational Databases and Tables

Video: Relational Database Concepts
Video: Types of SQL Statements (DDL vs. DML)
Video: CREATE TABLE Statement
Video: ALTER, DROP, and Truncate Tables
Reading: Examples to ALTER and TRUNCATE Tables using MySQL
Reading: Examples to CREATE and DROP Tables
Lab: CREATE, ALTER, TRUNCATE, DROP
Lab: Create and Load Tables using SQL Scripts
Practice Quiz: Module 2: Introduction to Relational Databases and Tables
Reading: Optional Db2 Labs
Video: How to Create a Database Instance on Cloud
Lab: Obtain IBM Cloud Feature Code and Activate Trial Account
Lab: (Optional) Db2 Lab: Create Db2 Service Instance and Get Started with Db2 Console
Lab: (Optional) Db2 lab: CREATE, ALTER, TRUNCATE, DROP
Lab: (Optional): Db2 lab: Create and Load Tables using SQL Scripts
Reading: Summary & Highlights: Module 2: Introduction to Relational Databases and Tables
Graded Quiz: Module 2: Introduction to Relational Databases and Tables

Module 3: Intermediate SQL

Reading: Module 3 Introduction and Learning Objectives
Video: Using String Patterns and Ranges
Video: Sorting Result Set
Video: Grouping Result Sets
Lab: String Patterns, Sorting and Grouping
Lab: (Optional) Db2 Lab: String Patterns, Sorting & Grouping
Video: Built-in Database Functions
Video: Date and Time Built-in Functions
Lab: Built-in functions
Lab: (Optional) Db2 Lab: Built-in Functions
Video: Sub-Queries and Nested Selects
Lab: Sub-queries and Nested SELECTS
Lab: (Optional) Db2 Lab: Sub-queries and Nested SELECTs
Video: Working with Multiple Tables
Lab: Working with Multiple Tables
Lab: (Optional) Db2 Lab: Working with Multiple Tables
Reading: Summary & Highlights: Module 3: Intermediate SQL
Graded Quiz: Module 3: Intermediate SQL

Module 4: Working with Real-World Datasets, Final Project & Exam

Reading: Module 4 Introduction and Learning Objectives
Video: Working with Real-World Datasets
Video: Getting Table and Column Details
Lab: Getting Table and Column Details using MySQLP
Lab: (Optional): Loading Data
Lab: Working with a Real-World Dataset
Lab: (Optional) Db2 Lab: Working with a Real-World Dataset Using SQL and IBM Cloud Db2
Reading: Final Project Overview
Lab: Final Project
Lab: (Optional) Db2 Lab: Exploratory Data Analysis with SQL
Lab: Project Evaluation (Quiz)
Quiz: Final Exam
Reading: Re-take Exam
Reading: Congratulations and Next Steps
Reading: Course Team

Module 5: Advanced SQL (Honors)

Reading: Module 5 Introduction and Learning Objectives
Reading: About This Honors Module
Video: Views
Lab: Using Views
Lab: (Optional) Db2 Lab: Using Views
Video: Stored Procedures
Lab: Stored Procedures
Lab: (Optional) Db2 Lab: Stored Procedures
Video: ACID Transactions
Lab: Committing and Rolling back a Transaction
Lab: (Optional) Db2 Lab: Committing and Rolling Back a Transaction
Video: Join Overview
Video: Inner Join
Video: Outer Joins
Lab: Joins
Lab: (Optional) Db2 Lab: Joins
Reading: Summary & Highlights: Module 5: Advanced SQL (Honors)
Practice Quiz: Module 5: Advanced SQL (Honors)
Graded Quiz: Module 5: Advanced SQL (Honors)
Practice Lab: Joins
Lab: Final Project: Advanced SQL for Data Engineers
Lab: (Optional) Db2 Final Project: Advanced SQL for Data Engineers
Lab: Advanced SQL for Data Engineers
Reading: Copyrights and Trademarks
Reading: Feedback
Reading: How to Claim your Certificate
Reading: Claim your Badge Here

Prerequisites

No prior knowledge of databases, SQL, or programming is required; however, some basic data literacy is beneficial.

SQL Fundamentals

Language

Topic

Skills You Will Learn

Offered By

Estimated Effort

Platform

Last Update