Skip to main content

SQL Commands


Department of Information and Communications Technology
Enrollment in this course is by invitation only

Course Overview

This course aims to teach the basic SQL commands as building blocks for creating simple to complex queries.

What You Will Learn

At the end of this course, you will be able to:

  • query data from a table
  • manipulate table data
  • create and modify database objects

Course Content

Week 1: Introduction and Data Query Language (DQL)

17 Videos | 1 Activity

17 Videos

  • Welcome to the course!
  • Parts of SQL Commands?
  • DQL
  • DML
  • DDL
  • What is a SELECT statement?
  • SELECT Examples
  • What does the WHERE clause do?
  • WHERE Examples
  • What does ORDER BY clause do?
  • ORDER BY Examples
  • What does the LIMIT clause do?
  • What does the GROUP BY clause do?
  • GROUP BY Examples
  • Common Aggregation Functions Examples
  • What are Subqueries?
  • LIMIT Examples
  • Subquery Examples
  • Summary

1 Activity

  • Exit Assessment

Week 2: Data Manipulation Language (DML)

11 Videos | 1 Activity

11 Videos

  • What is a CREATE statement?
  • CREATE Examples
  • What is an ALTER statement?
  • ALTER Examples
  • What is a DROP statement?
  • DROP Examples
  • What are Views?
  • View Examples
  • What is an Index?
  • Index Examples
  • Summary

1 Activity

  • Exit Assessment

Week 3: Other SQL Commands

11 Videos | 1 Activity

11 Videos

  • What are Common Table Expressions (CTEs)?
  • CTE Examples
  • What is an EXPLAIN statement?
  • EXPLAIN Examples
  • What is a DESCRIBE statement?
  • DESCRIBE Examples
  • What is Windowing?
  • Windowing Examples
  • How do we deal with Nulls in our queries?
  • Examples
  • Summary

1 Activity

  • Exit Assessment

Week 4: Setting up your Digital Presence for Success

8 Videos | 1 Activity

8 Videos

  • Overview
  • TOFU: Top of the Funnel
  • MOFU: Middle of the Funnel
  • BOFU: Bottom of the Funnel
  • define metrics for generating leads
  • define metrics for selling online
  • Other success metrics
  • Key Takeaways

1 Activity

  • Exit Assessment
  1. Course Number

    DICT-WD007
  2. Classes Start

    TBA
  3. Estimated Effort

    2 hrs./week (8 hours)
  4. Price

    Free