Home / Curriculum / SS 2

SS 2
Web Engineering, Database Design & ORM

Web engineering, JavaScript, and relational database design with ORM.

Age 16–17 years 3 Terms 8 Weeks per Term Software HTML5/CSS3/JS, Python 3.x, SQLite, SQLAlchemy / Django ORM
Term-by-Term Curriculum

Every Week,
Something Built.

Designed for offline delivery on shared lab computers — no theory-only sessions, every week ends with something the student made, built, typed, or designed. Select a term to see its full breakdown.

1

Modern CSS Framework Principles

CSS Grid, CSS variables, media queries.

2

Introduction to JavaScript

Variables let/const, browser console, types.

3

JS Control Flow & Functions

Conditionals, loops, standard and arrow functions.

4

DOM Manipulation

Selecting HTML nodes, changing content/styles dynamically.

5

Event Listeners & Interactive Nodes

Binding click, submit, input events.

6

Form Validation via JavaScript

Validating forms with regular expressions.

7

Asynchronous JavaScript Mechanics

JSON parsing, localStorage persistence.

8

Term 1 Project

Construct an interactive 'Task Management Dashboard'.

End of Term 1 Project

Advanced Frontend & Javascript Basics

Construct an interactive 'Task Management Dashboard'.

9

Relational Database Engine

SQLite CLI tools and file structures.

10

Data Definition Language

CREATE TABLE, field types, constraints, keys.

11

Data Manipulation Language

INSERT INTO, UPDATE, DELETE FROM statements.

12

Data Querying Language

SELECT, WHERE, ORDER BY, LIMIT clauses.

13

Aggregations & Grouping

COUNT, SUM, AVG, GROUP BY, HAVING.

14

Relational Database Joins

Querying multiple tables with INNER/LEFT JOIN.

15

Schema Normalization Theory

Applying 1NF, 2NF, and 3NF rules.

16

Term 2 Project

Design a normalized 3-table 'E-Commerce Database Schema'.

End of Term 2 Project

SQL & Relational Database Architecture

Design a normalized 3-table 'E-Commerce Database Schema'.

17

Python DB-API Interface

Connecting Python to SQLite via sqlite3 library.

18

Parameterized Queries

Defending against SQL Injection using ? bindings.

19

Database Transaction Management

Handling transactions with commit/rollback.

20

Object-Relational Mapping

Mapping Python classes to relational tables.

21

SQLAlchemy Core & Declarative Base

Defining ORM models and relationships.

22

ORM Session Operations

Executing CRUD actions using ORM sessions.

23

Database Migrations & Relationships

One-to-Many and Many-to-Many models.

24

Term 3 Project

Build a Python 'School Portal Engine' using SQLAlchemy ORM.

End of Term 3 Project

Python Database Integration & ORM Mechanics

Build a Python 'School Portal Engine' using SQLAlchemy ORM.