Structured Query Language (SQL)
Computing · JC 2 · Databases and Data Management · 2.º Período

Structured Query Language (SQL)

Practical application of SQL for Data Definition Language (DDL) and Data Manipulation Language (DML). Students will write complex queries involving joins and aggregations.

MOE Syllabus OutcomesMOE H2 Computing (Syllabus 9569), Section 3: Data and Information - 3.2 Databases (SQL: Data Definition Language)MOE H2 Computing (Syllabus 9569), Section 3: Data and Information - 3.2 Databases (SQL: Data Manipulation Language)

About This Topic

Practical application of SQL for Data Definition Language (DDL) and Data Manipulation Language (DML). Students will write complex queries involving joins and aggregations.

Key Questions

  1. How do we create and modify database schemas using SQL?
  2. What is the difference between INNER JOIN and LEFT JOIN?
  3. How are aggregate functions used to summarise data?

Active Learning Ideas

See all activities→

Activities & Teaching Strategies

See all activities

More in Databases and Data Management

Relational Database Design and Normalisation

Students will design Entity-Relationship (ER) diagrams and normalise databases up to the Third Normal Form (3NF). This ensures data integrity and reduces redundancy.

8 methodologies

NoSQL and Alternative Data Stores

An introduction to non-relational databases, focusing on document-oriented stores like MongoDB. Students will compare NoSQL with traditional SQL databases.

8 methodologies

Edited by Adriana Perusin, Editor-in-Chief, Flip Education