Trainer

Revised Curriculum Week / Skill Activity / JD StatementLearning ObjectivesWeek 1 – SQL Server / PostgreSQL EssentialsDesign 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 typesApply data modeling principles using ERDs and define databases effectivelyDifferentiate between SQL sub-languages (DDL, DML, DQL, DCL, TCL) and use them appropriatelyDesign and manage database schemas using primary, foreign, composite, and unique keysEnforce data integrity and consistency through constraints, normalization, and referential integrityPerform CRUD operations using INSERT, UPDATE, DELETE, and SELECT statementsUse aggregate and scalar functions, clauses, and aliases to analyze dataWrite subqueries and joins (inner, outer, cross, left/right, equi, theta) to retrieve relational dataUnderstand ACID properties, transactions, commit/rollback, and i...