Skip to content

Main Navigation Home

A · Information Processing

B · Computer System Fundamentals

C · Internet & its Applications

D · Computational Thinking & Programming

E · Social Implications

2A · Databases

2B · Web Application Development

2C · Algorithm & Programming

SBA Study Plan Exam Tips Resources

English

English

Theme

Sidebar Navigation

Paper 2 Electives

Overview

Elective 2A · Databases

Elective overview

1 · Relational Database Concepts

Chapter overview

1.1 Tables, rows, attributes

1.2 Keys (primary, foreign, candidate)

1.3 Integrity rules

1.4 Indexes & rollback

2 · SQL

Chapter overview

2.1 CREATE, ALTER, DROP

2.2 INSERT, UPDATE, DELETE

2.3 SELECT & WHERE

2.4 Operators & LIKE / IN

2.5 ORDER BY & DISTINCT

2.6 GROUP BY & HAVING

2.7 Aggregates & built-in functions

2.8 JOIN (up to 3 tables)

2.9 Sub-queries (1 level)

2.10 Set operations (UNION etc.)

2.11 Views

3 · Database Design Methodology

Chapter overview

3.1 ER diagrams

3.2 Cardinality & participation

3.3 Normalisation to 3NF

3.4 Denormalisation

3.5 ER → tables

3.6 Access rights & privacy

Elective 2B · Web Application Development

Elective overview

1 · Network Services & Implementation

Chapter overview

1.1 Client–server model

1.2 HTTP request / response

1.3 Network servers in practice

1.4 Setting up Ethernet / Wi-Fi

1.5 File sharing & permissions

2 · Web Authoring

Chapter overview

2.1 HTML deep dive

2.2 CSS for consistent style

2.3 Publishing options

3 · Web Programming & Applications

Chapter overview

3.1 Client-side vs server-side

3.2 JavaScript essentials

3.3 PHP essentials

3.4 Form handling & validation

3.5 Database from PHP (PDO)

3.6 Cookies & sessions

3.7 Building a simple web app

Elective 2C · Algorithm & Programming

Elective overview

1 · Programming

Chapter overview

1.1 Data types beyond Module D

1.2 Nested loops & 2D lists

1.3 Sub-programs & parameters

1.4 File handling

1.5 Linear & binary search

1.6 Sorting algorithms

1.7 Merging & counting

1.8 Stack

1.9 Queue

1.10 Linked list

1.11 Testing & debugging

2 · Programming in Real Life

Chapter overview

2.1 Sensors & devices

2.2 Event-driven programs

2.3 Extended modules

On this page

Chapter 2 · Web Authoring

The HTML + CSS half of building a website.

Sub-topics

#	Topic
2.1	HTML deep dive
2.2	CSS for consistent style
2.3	Publishing options

➡️ Start: 2.1 HTML Deep Dive

Edit this page on GitHub

Last updated:

Pager

Previous page1.5 File sharing & permissions

Next page2.1 HTML deep dive

Released under the MIT License.

Copyright © 2024-present HKDSE ICT Hub · Built with VitePress