Trainer

Revised CurriculumWeek / SkillActivity / JD StatementLearning ObjectivesWeek 1 – SQL Server / Postgre SQL EssentialsDesign 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 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 ...