Job Description
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 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...