Course Outline
Module 1: Introduction
- Definition of SQL
- Capabilities of SQL
- Standards for SQL
-
Uses of SQL
Module 2: SQL Query Commands
- Create Table [Data Type, 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 Sub-Query
Module 3: Querying with Unions
- Rules and Application of Union
- Rules and Application of Union All
Module 4: Calculate and Compute
- Using Special Queries Such As:
- SUM
- AVERAGE (AVE)
- MINIMUM (MIN)
- MAXIMUM (MAX)
- Other Computation Procedures to Extract Data
Module 5: Entity Relationship Diagrams
- Table Relationships
- Properly Breakdown a Single Table into Multiple Tables
- Create Tables with Relationships
- Improve Performance of Selecting Data by Using ERD
Module 6: Table Joins
- Full Join Tables
- Inner Join Tables
- Left Join Tables
- Right Join Tables
Module 7: Combination of Joins
- Using 3 or More Tables with Mixed Joins (Left, Right, Full, Inner)
- Guidelines for Joining Multiple Tables
Module 8: SQL Transactions
- Definition of an SQL Transaction
- Uses of SQL Transactions
- SQL Transactions When Selecting Data
- SQL Transactions, Rollback, and Commit
- SQL Transaction ACID Property
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, specifically designed for government use.
- SQL queries from the lessons will be provided after the training.
- An unanswered and answered version of the exercises will be given after the training to reinforce learning.
Requirements
For government professionals, this course requires a foundational understanding of SQL querying or equivalent knowledge.
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.
