Job Description
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 analyze data Write subqueries and joins (inner, outer, cross, left/right, equi, theta) to retrieve relational data Understand ACID properties, transactions, commit/rollba...