Job Description
Revised Curriculum
Week / Skill
Activity / JD Statement
Learning Objectives
Week 1 – SQL Server / PostgreSQL Essentials
Design 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 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 agg...