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