Computer Science · Theme A: Concepts of computer science

A3.3 — Database programming

Computer Science · SL / HL · syllabus-mapped notes

1. CS_A3.3.1

   SQL data language types (DDL and DML)

   How DDL defines structures and DML manipulates data.

2. CS_A3.3.2

   Queries across two tables

   Joins, filtering, pattern matching and ordering with named SQL commands.

3. CS_A3.3.3

   Updating data with SQL

   INSERT, UPDATE, DELETE and the cost of updating indexed columns.

4. CS_A3.3.4

   Aggregate calculations

   AVERAGE, COUNT, MAX, MIN, SUM on grouped data.

5. CS_A3.3.5

   Database views

   Virtual and materialized views and what they are used for.

6. CS_A3.3.6

   Transactions and data integrity

   ACID properties and TCL commands.