Job Description
Revised Curriculum
Week / 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 ACID propertie...