Revised Curriculum

Week / Skill

Activity / JD Statement

Learning Objectives

Week 1 – SQL Server / PostgreSQL Essentials

Design relational databases and write SQL queries (both T-SQL and PostgreSQL dialects) for CRUD and reporting.

• Understand the fundamentals of SQL and MySQL, including RDBMS concepts, schemas, tables, and SQL data types
• Apply data modeling principles using ERDs and define databases effectively
• Differentiate between SQL sub-languages (DDL, DML, DQL, DCL, TCL) and use them appropriately
• Design and manage database schemas using primary, foreign, composite, and unique keys
• Enforce data integrity and consistency through constraints, normalization, and referential integrity
• Perform CRUD operations using INSERT, UPDATE, DELETE, and SELECT statements
• Use aggregate and scalar functions, clauses, and aliases to ana...