Course Outline
Module 1: Introduction
- Definition of SQL
- Capabilities of SQL
- SQL Standards
-
SQL Applications
Module 2: SQL Query Commands
- Table Creation [Data Types, Table Structure, Key Formats]
- Inserting Data [Single record to multiple records]
- Insert Into [Single record to multiple records]
- Select Statement
- Select Statements with Conditions
- 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
- Utilizing special queries such as:
- SUM
- AVG
- MIN
- MAX
- Other computational procedures for data extraction
Module 5 – Entity Relationship Diagrams
- Table Relationships
- Strategies for decomposing a single table into multiple tables
- Creating tables with defined relationships
- Enhancing data selection performance using ERDs
Module 6 - Table Joins with 2 Tables
- Full Join Tables
- Inner Join Tables
- Left Join Tables
- Right Join Tables
Module 7 – Combining Joins
- Joining three or more tables using mixed joins (left, right, full, inner)
- Best practices for joining multiple tables
Module 8 - SQL Transactions
- Understanding SQL Transactions
- Applications of SQL Transactions
- SQL Transactions when selecting data
- SQL Transactions: Rollback and Commit
- ACID Properties of SQL Transactions
NOTE:
- Hands-on exercises will be included for each module to assess participants' understanding of the topics.
- PowerPoint slides will be provided after the training concludes.
- SQL queries from the lesson will be provided after the training concludes.
- Both unanswered and answered versions of the exercises will be provided after the training concludes.
Requirements
Fundamentals 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.
