Course Outline
Module 1: Introduction
- Understanding SQL Definition
- Exploring SQL Capabilities
- Reviewing SQL Standards
-
Practical Uses of SQL
Module 2: SQL Query Commands
- Creating Tables [Data Types, Table Formats, Key Formats]
- Inserting Data [Single record to multiple records]
- Inserting Into [Single record to multiple records]
- The 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 – Calculations and Computations
- Utilizing special queries such as:
- SUM
- AVG
- MIN
- MAX
- Other computational procedures for data extraction
Module 5 – Entity Relationship Diagrams
- Understanding Table Relationships
- Techniques for normalizing a single table into multiple tables
- Creating tables with defined relationships
- Improving data selection performance using ERDs
Module 6 - Table Joins with Two Tables
- Full Join Operations
- Inner Join Operations
- Left Join Operations
- Right Join Operations
Module 7 – Combining Joins
- Joining three or more tables using mixed joins (left, right, full, inner)
- Best practices and guidelines for joining multiple tables
Module 8 - SQL Transactions
- Understanding SQL Transactions
- Applications of SQL Transactions
- SQL Transactions during data selection
- Committing and rolling back SQL Transactions
- The ACID properties of SQL Transactions
NOTE:
- Each module includes hands-on exercises designed to assess participants' understanding of the topics.
- PowerPoint slides will be provided after the training concludes.
- SQL queries from the lessons will be shared after the training ends.
- Both unanswered and answered versions of the exercises will be distributed after the training.
Requirements
Fundamental knowledge of SQL querying or equivalent proficiency.
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.
