Skip to main content

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

Course Staff Image #1

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
  1. Course Number

    SP203
  2. Classes Start

  3. Classes End

  4. Estimated Effort

    2-3 hours/week (10 hours)
  5. Price

    PHP1000