Course Outline
Module 1: Introduction
- Definition of SQL
- Core capabilities of SQL
- SQL standards
-
Practical applications of SQL
Module 2: SQL Query Commands
- Creating tables [Data types, Table structure, Key formats]
- Inserting data [Single and multiple records]
- Using Insert Into statements [Single and multiple records]
- SELECT statements
- SELECT statements with conditions
- SELECT statements utilizing subqueries
Module 3: Querying with Unions
- Rules and applications of UNION
- Rules and applications of UNION ALL
Module 4: Calculation and Computation
- Utilizing specialized queries such as:
- SUM
- AVE
- MIN
- MAX
- Other computational methods for data extraction
Module 5: Entity Relationship Diagrams (ERD)
- Relationships between tables
- Breaking down single tables into multiple normalized tables
- Creating tables with defined relationships
- Optimizing data selection performance using ERDs
Module 6: Two-Table Joins
- Full Outer Joins
- Inner Joins
- Left Joins
- Right Joins
Module 7: Combining Joins
- Joining three or more tables using mixed join types (Left, Right, Full, Inner)
- Best practices for joining multiple tables
Module 8: SQL Transactions
- Understanding SQL Transactions
- Applications of SQL Transactions
- Transactions in data selection processes
- Rollback and Commit operations in SQL Transactions
- The ACID properties of SQL Transactions
NOTE:
- Hands-on exercises will be included in every module to assess understanding of the topics.
- PowerPoint slides will be provided upon completion of the training.
- SQL queries from the lessons will be shared after the training concludes.
- Both answered and unanswered versions of the exercises will be provided after the training.
Requirements
Foundational SQL querying skills or equivalent knowledge are 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.
