Course Outline
Module 1: Introduction
- Definition of SQL
- Capabilities of SQL
- Standards in SQL
-
Uses of SQL for government operations and data management
- Create Table [Data Types, Table Format, Key Format]
- Insert Data [Single Record to Multiple Records]
- Insert Into [Single Record to Multiple Records]
- Select Statement
- Select Statements with Conditions
- Select Statements with Subqueries
Module 2: SQL Query Commands
Module 3: Querying with Unions
- Rules and Applications of Union for government data integration
- Rules and Applications of Union All for comprehensive data retrieval
Module 4: Calculation and Computation in SQL
- Utilizing special queries such as:
- SUM
- AVERAGE (AVE)
- MINIMUM (MIN)
- MAXIMUM (MAX)
- Other computational procedures for data extraction in government databases
Module 5: Entity Relationship Diagrams
- Table Relationships for efficient data organization
- Properly breaking down a single table into multiple tables for government datasets
- Creating tables with relationships to enhance data integrity
- Improving the performance of data selection using Entity Relationship Diagrams (ERDs)
Module 6: Table Joins with Two Tables
- Full Join Tables for comprehensive data retrieval
- Inner Join Tables for intersecting data sets
- Left Join Tables for inclusive data queries
- Right Join Tables for complementary data retrieval
Module 7: Combination of Joins with Multiple Tables
- Using three or more tables with mixed joins (left, right, full, inner) for complex government data analysis
- Guidelines to follow when joining multiple tables in government databases
Module 8: SQL Transactions for Government Operations
- Definition of an SQL Transaction
- Uses of SQL Transactions in government applications
- SQL Transactions when selecting data to ensure data consistency
- SQL Transactions, Rollback, and Commit operations for reliable data management
- SQL Transaction ACID Properties (Atomicity, Consistency, Isolation, Durability)
NOTE:
- Hands-on exercises will be provided for each module to test the understanding of participants on the topics.
- PowerPoint slides will be distributed at the conclusion of the training.
- SQL queries from the lessons will be provided after the training session.
- An unanswered and answered version of the exercises will be given after the completion of the training to aid in further learning and review.
Requirements
Testimonials (4)
The smoothness of the training flow.
Alby Geronimo - Aarki, Inc.
Course - SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
The instructor explains everything in a way that is very easy to understand. He's super good at teaching.
Elaiza Marie Parumog - Aarki, Inc.
Course - SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
The instructor explains everything in a way that is very easy to understand. He's super good at teaching.
Elaiza Marie Parumog - Aarki, Inc.
Course - SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
They way the instructor teaches is very informative and effective especially on the 2nd day when topics are a bit advanced.
