Week 1 – SQL Server / Postgre SQL Essentials
Design 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
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
Implement advanced SQL features such as indexes, views, triggers, and stored procedures
Apply security and governance concepts, including user defined functions and access...