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