Skip to content
All courses
SQLLive instructor-led program

SQL for Data Analytics

Query business databases and turn raw records into insight.

Course overview

Master SELECT, joins, aggregations, window functions, and analytics workflows using realistic business tables.

Learning outcomes

What you will learn.

  • Write production-style SQL queries
  • Join multiple tables
  • Create reporting datasets
  • Use window functions for analysis

Tools and skills

SELECT / WHERE / GROUP BY / JOIN / CASE WHEN / CTE / Subquery / Window Functions / SQL Analysis / Data Validation

SQL
Business querying.
Database
Relational data.
Query Editor
Write and test queries.
Data Model
Table relationships.

Course syllabus

A clear path through the subject.

Explore the topics, practice activities, and outputs in each module.

3 modules / 5 weeks / Instructor-led

Explore the curriculum

Learning environment setup

Core concepts and terminology

Guided practice lab

Projects

Put your learning to work.

These course assignments use practice datasets and business scenarios. Build your own work with instructor guidance.

Mini Project

Sales Query Challenge

Write SQL queries that answer daily sales questions.

Deliverable: SQL script + answer tables

Skills and workflow

SELECT / WHERE / ORDER BY. Understand the brief, apply the course skills, validate the result, and document your findings.

Guided Project

Customer Segmentation Analysis

Group customers by value, frequency, and behavior.

Deliverable: Customer segments + insight

Skills and workflow

GROUP BY / CASE WHEN / HAVING. Understand the brief, apply the course skills, validate the result, and document your findings.

Business Project

Product Revenue Analysis

Calculate revenue by product, category, and period.

Deliverable: Revenue query pack + result tables

Skills and workflow

Aggregation / Dates / Ranking. Understand the brief, apply the course skills, validate the result, and document your findings.

Portfolio Project

Multi-Table Business Analysis

Join customers, orders, products, and salespeople to explain performance.

Deliverable: Multi-table analysis + documentation

Skills and workflow

JOIN / CTE / Subquery. Understand the brief, apply the course skills, validate the result, and document your findings.

Portfolio Project

SQL Reporting Project

Create reusable queries for a recurring management report.

Deliverable: Reporting queries + insights

Skills and workflow

CTE / Views / Validation. Understand the brief, apply the course skills, validate the result, and document your findings.

Final project

Business Database Analysis

Investigate a relational business database and deliver documented decision-ready queries.

What you will deliver

  • SQL scripts
  • Business queries
  • Result tables
  • Insights
  • Documentation
  • Recommendations

Database / Query / Join / Aggregate / Analyze / Report

Requirements

  • A laptop for class exercises and project work.
  • Basic confidence using files, web tools, and spreadsheets.
  • Time to attend live sessions and practice between classes.
  • No previous programming experience is required for foundation courses.

Who should join

  • Students
  • Analysts
  • Developers
  • Business professionals

Class schedule

The program runs for 5 weeks, with Khmer and English instruction. Contact our team for the next start date, weekly timetable, and available places.

Ask about the next class

Your instructor

Data Insight Cambodia Team

Learn through guided explanations, class exercises, and feedback on your work. Your advisor can confirm the instructor and teaching schedule for your class.

Course certificate

Data Insight Cambodia

Recognize the work you complete.

Complete the required coursework and final project review to receive your Data Insight Cambodia certificate. Your projects help demonstrate the skills behind it.

Enrollment process

  1. 01Contact
  2. 02Consultation
  3. 03Registration
  4. 04Payment
  5. 05Join live class
  6. 06Receive Student Portal access

Common questions

Are classes taught live?

Yes. Classes are instructor-led. After enrollment, Student Portal access provides class recordings, materials, assignments, and feedback to support your study between sessions.

Do I need previous experience?

This course starts with the foundations. An advisor can help you confirm the preparation you need.

Will I receive a certificate?

A course certificate is provided after you complete the required assignments and final project review.

Does the course guarantee employment?

No. We provide career guidance and project feedback. Employment and internships depend on available opportunities and employer requirements.

Contact an advisor

Talk through your next step.

Ask about this course, class times, or how to register.

Chat on Telegram