MySQL / PostgreSQL

Module 1: Database introduction and RDBMS

• Database introduction and RDBMS fundamentals
• SQL query writing, database/table creation, insert, drop, and delete operations

Module 2: Foreign key, unique key

• Foreign key, unique key, CRUD operations, and query design
• Data types, functions, where clause, like wildcard, IN, BETWEEN, LIMIT, ORDER BY

Module 3: Aggregations, joins including inner/outer/self

• Aggregations, joins including inner/outer/self join, and practical query building
• PostgreSQL pgAdmin setup and practice-based SQL exercises fileciteturn0file0