Explain relational database concepts and the role of SQL in database management.

Design normalized relational databases using keys, dependencies, and ER diagrams.

Create tables and apply appropriate data types, null values, and constraints.

Write and execute single-table and multiple-table SQL queries, including joins and set operations.

Perform data manipulation tasks such as insert, update, delete, and transaction control.

Implement database administration tasks including views, indexes, integrity constraints, and security.

Apply advanced SQL programming concepts including stored procedures, triggers, and functions across MySQL, Oracle PL/SQL, and SQL Server T-SQL environments.

Introduction to Case Databases – KimTay Pet Supplies and StayWell Accommodation

Database Design Fundamentals – Keys, Dependencies, Normalization, Diagrams

Creating Tables – SQL Commands, Data Types, Nulls, and Database Structures

Single-Table Queries – SELECT, Sorting, Functions, Grouping, Nesting

Multiple-Table Queries – Joins, Set Operations, IN/EXISTS, Special Operators

Updating Data – INSERT, UPDATE, DELETE, Transactions, Autocommit, Rollback

Database Administration – Views, Indexes, Security, Integrity Constraints, Catalogs

Functions, Procedures, and Triggers – Stored Procedures, Error Handling, PL/SQL, T-SQL, Automation