Revised CurriculumWeek / Skill
Activity / JD Statement
Learning Objectives
Week 1 – SQL Server / Postgre SQL Essentials
Design relational databases and write SQL queries (both T-SQL and Postgre SQL dialects) for CRUD and reporting.
Understand the fundamentals of SQL and My SQL, 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 ACI...