Camp Fire Academy
Learning path
UI/UX Design Foundations UI/UX Design Intermediate Advanced UX Strategy
Specialisations
Fintech & Banking UI/UX AI-Powered UI/UX UX for Leaders Design Thinking
Most requested
AI for Workplace Productivity Excel for Business Power BI & Business Intelligence Cybersecurity Awareness PDPA Compliance Data Protection Officer Browse the full catalogue →
For teams
Corporate & In-House Training LMS & Self-Paced Learning Events Verify a Certificate
Company
About Contact WhatsApp

SQL for Data Analysis

This programme teaches SQL for business and data analysis. Participants learn to query databases, extract insights, and produce data outputs that support better decisions without needing a software engineering background.

Modules

Introduction to Databases and SQL
What relational databases are, how tables and relationships work, and where SQL is used in business analytics.

Basic Queries
Use SELECT, FROM, WHERE, ORDER BY, and LIMIT to retrieve and filter data from a single table with precision.

Filtering and Conditions
Use AND, OR, NOT, IN, BETWEEN, and LIKE to write conditions that extract exactly the records you need.

Aggregation and Grouping
Use COUNT, SUM, AVG, MIN, and MAX with GROUP BY and HAVING to summarise data for reporting and analysis.

Joining Tables
Use INNER JOIN, LEFT JOIN, and RIGHT JOIN to combine data from multiple tables and answer cross-functional questions.

Subqueries and CTEs
Use nested queries and Common Table Expressions to build complex, readable analysis in logical steps.

Working with Dates and Text
Format dates, calculate durations, and manipulate text fields for cleaner reporting outputs.

Practical Business Scenarios
Apply SQL to real questions about customer behaviour, sales trends, inventory levels, and operational metrics.

Final Activity

Business Analysis Query Set. Participants write a set of queries answering five real business questions from a provided dataset, covering filtering, joining, and aggregation.

Key Outcomes:
Query databases to retrieve and filter business data accurately
Summarise and group data for management reporting
Join multiple tables to answer cross-functional questions
Write subqueries and CTEs for structured, readable analysis
Work with dates, text, and calculated fields
Apply SQL to real business scenarios without a coding background

Fee: RM 2,200 per day
Minimum enrolment: 1 participant
Duration: 2 Days
Level: Beginner to Intermediate (no prior SQL experience needed)
HRD Corp Claimable
Certificate included

Frequently Asked Questions

RM 2,200 per day.

No. The programme starts from the very beginning and assumes no prior SQL or database knowledge.

Exercises use PostgreSQL and are compatible with MySQL and SQL Server syntax.

Yes.

Analysts, managers, and any professional who needs to extract and analyse data from databases regularly.

Yes. Participants should bring a laptop. Software setup instructions will be provided before the session.

Yes, a Certificate of Completion is issued.

Yes, online delivery is available.

Yes. Any programme can be booked as a team day. Everyone works the same brief together, so your people come away having built something and knowing each other better.

If you are claiming under HRD Corp, the session has to fall at least 14 days after your HRD Corp approval. If you are not claiming, the date is flexible and we work around your calendar.

At your own office or venue, online, or at our training space in Cyberjaya. It can also be delivered entirely through our LMS as self-paced e-learning.

Put them on the self-paced e-learning instead. Your team works through the modules on our LMS in their own time, sits the assessment, and earns the same certificate, so nobody has to clear a full day together.