SQL DATABASE MANAGEMENT AND DESIGN - Bespoke Training Course

Module 1: Introduction

• Definition of SQL
• Functional capabilities of SQL
• SQL standards compliance

• Applications of SQL for government

Module 2: SQL Query Commands

• Table Creation [Data Types, Table Formats, Key Structures]
• Data Insertion [Single record to multiple records]
• INSERT INTO Syntax [Single record to multiple records]
• SELECT Statement
• Conditional SELECT Statements
• SELECT Statements with Subqueries

Module 3: Querying with Unions

• Rules and application of UNION
• Rules and application of UNION ALL

Module 4: Calculation and Computation

• Utilization of aggregate query functions, including:

1. SUM
2. AVG
3. MIN
4. MAX
5. Additional data extraction computational procedures

Module 5: Entity Relationship Diagrams

• Table Relationship Models
• Normalization of single tables into multiple tables
• Creation of relational tables
• Optimization of data selection performance using Entity Relationship Diagrams for government systems

Module 6: Table Joins with Two Entities

• Full Outer Join
• Inner Join
• Left Outer Join
• Right Outer Join

Module 7: Combined Joins

• Executing joins across three or more tables using mixed join types (left, right, full, inner)
• Guidelines for joining multiple tables

Module 8: SQL Transactions

• Definition of an SQL Transaction
• Applications of SQL Transactions

1. Transactional operations during data selection
2. Transaction rollback and commit procedures

• ACID properties of SQL Transactions

NOTES:

• Hands-on exercises will be conducted for each module to verify participant competency regarding the subject matter.
• Training materials, including PowerPoint presentations, will be distributed upon completion of the training.
• Reference SQL queries from the curriculum will be provided after the conclusion of the training.
• Both completed and uncompleted versions of the exercise materials will be provided post-training.