SQL for Business Users
Development Academy of the Philippines
Enrollment is Closed
Course Overview
SQL is the standard language for relational database management systems and is widely used in data mining and processing. As businesses use data in tracking everything, leverage in data will enable business to better understand its operations and derive sound business decisions. This course provides foundation knowledge on SQL programming, which may be used in metrics calculation, data analytics, and report production.
What You Will Learn
Upon completion of this course, the learners are expected to:
- gain basic SQL programming background including databases, tables and other data processing algorithms;
- be able to write SQL code to build database structures and process data with various conditions from multiple tables using different types of join and with row and aggregate functions;
- retrieve data using subqueries and set operators, which can be used in data mining and analytics; and
- perform aggregation and use popular SQL functions.
Note to SPARTA scholars: Upon enrollment, you will have 6 months to finish a SPARTA course. Failure to complete the course in 6 months and/or inactivity for 3 months will result in course access revocation.
Course Instructor
Xavier Puspus
Subject Matter Expert
Course Content
Week 1: SQL Basics
6 Videos | 3 Activities
Videos
- Welcome to the course!
- Prework: Setting up a Cloud Database and SQL Environment
- Understanding Databases
- The Design Thinking Framework
- Getting Started with SQL
- Basic SQL Functions
3 Activities
- Recall Activities
- Exit Assessment
Week 2: Intermediate SQL I: Aggregates
3 Videos | 2 Activities
3 Videos
- Aggregate Functions
- COUNT, SUM, MIN/MAX, and AVG
- GROUP BY and HAVING
Activities
- Recall Activity
- Exit Assessment
Week 3: Intermediate SQL II: Joins
3 Videos | 2 Activities
3 Videos
- Practice Dataset (College Football Players and Teams) and JOINS
- Inner and Outer Joins
- Practice Dataset (Crunchbase Companies and Investments)
2 Activities
- Recall Activity
- Exit Assessment
Week 4: Advanced SQL
6 Videos | 2 Activities
6 Videos
- Case
- Data Types
- Date format, INTERVAL, and NOW
- Practice dataset: San Francisco Crime Incidents
- Why Test?
- How to test?
2 Activities
- Recall Activity
- Exit Assessment
Week 5: Advanced SQL II
3 Videos | 2 Activities
3 Videos
- Subquery
- Practice Dataset: Washington DC’s Capital Bikeshare Program
- Key Takeaways
2 Activities
- Recall Activity
- Exit Assessment