Programme outline
Learning objectives
- Utilise Data Definition Language (DDL) commands such as CREATE, DROP, and ALTER TABLE to create and modify databases.
- Execute Data Manipulation Language (DML) commands including INSERT, UPDATE, and DELETE for database manipulation.
- Perform basic and advanced Data Query Language (DQL) commands, incorporating SQL operators and functions for text and date searches.
- Apply SQL (Structured Query Language) aggregate functions for data analysis and reporting purposes.
- Implement join operators, subqueries, and nested queries to retrieve data from multiple tables, and create views, triggers, and functions to enhance database functionality.
Day 1
- Creating Database with Data Definition Language: CREATE, DROP, ALTER TABLE commands
- Modifying Database with Data Manipulation Language (DML): INSERT, UPDATE, DELETE commands
- Retrieving data from single table with Data Query Language (DQL) 鈥 Basic (SELECT commands with SQL operators, Functions related text and date searches, SQL aggregate functions)
Day 2
- Retrieving data from multiple tables with Data Query Language (DQL) 鈥 Advanced (Subqueries and nested queries, types of join operators: inner, full outer, left outer, right outer joins)
- Creating views, triggers, functions.
Day 3
- Project consultation
- Project presentation
Mode of assessment
- Assignment
- Project