Course Outline
Module 1: Introduction
- Definition of SQL
- SQL Capabilities
- SQL Standards
-
Applications of SQL
Module 2: Core SQL Query Commands
- Creating Tables [Data Types, Table Structures, Key Constraints]
- Inserting Data [Handling single to multiple records]
- Insert Into Statements [Single to multi-record operations]
- Select Statement Fundamentals
- Select Queries with Conditional Logic
- Select Statements Utilizing Subqueries
Module 3 - Querying with Unions
- Principles and Application of Union
- Principles and Application of Union All
Module 4 – Calculations and Computations
- Utilizing specialized query functions such as:
- SUM
- AVERAGE (AVE)
- MIN
- MAX
- Other computational procedures for data extraction
Module 5 – Entity Relationship Diagrams (ERD)
- Understanding Table Relationships
- Techniques for Decomposing a Single Table into Multiple Tables
- Creating Relational Tables
- Enhancing Data Retrieval Performance through ERD Application
Module 6 - Table Joins with Two Entities
- Full Join Operations
- Inner Join Operations
- Left Join Operations
- Right Join Operations
Module 7 – Combining Joins
- Integrating Three or More Tables Using Mixed Joins (Left, Right, Full, Inner)
- Best Practices and Guidelines for Joining Multiple Tables
Module 8 - SQL Transactions
- Definition of an SQL Transaction
- Practical Applications of SQL Transactions
- Transactions during Data Selection
- Rollback and Commit Operations in SQL Transactions
- The ACID Properties of SQL Transactions
NOTE:
- Each module includes hands-on exercises designed to assess participants' comprehension of the topics.
- PowerPoint presentation materials will be distributed following the completion of the training.
- All SQL queries covered during the lessons will be provided after the training concludes.
- Both answered and unanswered versions of the exercises will be made available post-training.
Requirements
Prerequisite: Completion of SQL Fundamentals or equivalent prior 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.
