Course Outline
Module 1: Introduction
- Definition of SQL
- Core Capabilities of SQL
- SQL Standards and Compliance
-
Practical Applications of SQL
Module 2: SQL Query Commands
- Creating Tables [Specifying Data Types, Table Structures, and Key Constraints]
- Data Insertion [Handling Single and Multiple Records]
- Using INSERT INTO [Managing Single and Multiple Records]
- The SELECT Statement
- Implementing Conditions in SELECT Statements
- Incorporating Subqueries within SELECT Statements
Module 3: Querying via Unions
- Rules and Practical Application of UNION
- Rules and Practical Application of UNION ALL
Module 4: Calculation and Aggregation
- Employing specialized aggregate queries, including:
- SUM
- AVG
- MIN
- MAX
- Additional computational methods for data extraction
Module 5: Entity Relationship Diagrams (ERD)
- Understanding Table Relationships
- Techniques for Decomposing a Single Table into Multiple Normalized Tables
- Establishing Relationships When Creating Tables
- Enhancing Data Selection Performance through ERD Utilization
Module 6: Two-Table Joins
- Full Join Operations
- Inner Join Operations
- Left Join Operations
- Right Join Operations
Module 7: Complex Join Combinations
- Joining Three or More Tables Using Mixed Join Types (Left, Right, Full, Inner)
- Best Practices and Guidelines for Multi-Table Joining
Module 8: SQL Transactions
- Conceptual Overview of SQL Transactions
- Practical Use Cases for SQL Transactions
- Transactions in the Context of Data Selection
- Managing Rollbacks and Commits in SQL Transactions
- The ACID Properties of SQL Transactions
Additional Information:
- Hands-on exercises will be provided for each module to validate participant comprehension of the subject matter.
- PowerPoint slide decks will be distributed upon completion of the training.
- All SQL queries demonstrated during the lessons will be shared after the training concludes.
- Both unsolved and solved versions of the exercises will be provided post-training.
Requirements
Proficiency in SQL: Fundamentals of Querying or comparable prior knowledge is required.
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.
