AI Icon Data Science

Data and Database Foundation

380810078929

Course Overview Print

This 1-day course provides a practical introduction to the foundational concepts of data and databases that support modern Data Engineering work. Participants will explore how data is structured, stored, related, queried, and governed, while gaining exposure to key topics such as relational databases, basic SQL, data quality, and responsible data handling. The course is designed to build confidence in learners who are new to data systems and to prepare them for further study in areas such as data pipelines, cloud data platforms, and analytics engineering.

Key Topics

  • Understand fundamental data and database concepts.
  • Explain relational database structures and relationships.
  • Recognize common data quality issues
  • Write basic SQL queries

Course Outline

Module 1: DatabaseFoundations

  • Importance of strong data foundations
  • How data supports analytics and business decision-making

Module 2: Understanding Data

  • Data types and formats
  • Structured, semi-structured and unstructure data
  • Data granularity, sensitivity and classification

Module 3: Relational Database Basics

  • Relational Database Basics
  • SQL Server Databse Objects
  • Constraints turn business rule
  • Normialisation overview

Module 4: SQL Fundamentals

  • Retrieving data using SELECT
  • Filtering data with WHERE
  • Sorting data with ORDER BY
  • Grouping data using GROUP BY
  • Aggregate functions (COUNT, SUM, AVG, etc.)
  • Simple table joins (JOIN)

Module 5: Data Quality and metadata

  • Structuring data for reliability and efficiency
  • Profile before trusting a dataset
  • Understanding metadata and data dictionaries

Module 6: Data Governance and Responsible Use

  • Data privacy considerations
  • Data security and access control
  • Responsible data handling
  • PDPA-aware practice
*Important Note : Fees are subject to Singapore's prevailing Goods and Services Tax (GST).
Data and Database Foundation
Available Course Dates
Fees Enquire Now

Have Question?

We’re here to help — reach out anytime.

By submitting this form, you consent to be contacted via email and/or your mobile number regarding your enquiry. You consent to the collection, use, disclosure and processing of your personal data in accordance with our Personal Data Policy.