Course Outline
Module 1: Introduction
- Definition of SQL
- Capabilities of SQL
- SQL Standards
-
Applications of SQL
Module 2: SQL Query Commands
- Table Creation [Data Types, Table Structure, Key Structure]
- Data Insertion [Single to Multiple Records]
- Insert Into Statements [Single to Multiple Records]
- Select Statements
- Select Statements with Conditions
- Select Statements with Subqueries
Module 3 - Querying with Unions
- Rules and Applications of Union
- Rules and Applications of Union All
Module 4 – Calculation and Computation
- Utilisation of specific queries such as:
- SUM
- AVE
- MIN
- MAX
- Other computational procedures for data extraction
Module 5 – Entity Relationship Diagrams
- Table Relationships
- Decomposing a single table into multiple tables
- Creating tables with relationships
- Enhancing data selection performance using ERDs
Module 6 - Table Joins with Two Tables
- Full Outer Joins
- Inner Joins
- Left Outer Joins
- Right Outer Joins
Module 7 – Combination of Joins
- Using three or more tables with mixed join types (left, right, full, inner)
- Best practices for joining multiple tables
Module 8 - SQL Transactions
- Understanding SQL Transactions
- Purpose of SQL Transactions
- SQL Transactions in data selection
- SQL Transactions: Rollback and Commit
- ACID Properties of SQL Transactions
Note:
- Hands-on exercises will be provided for each module to assess participant comprehension of the topics.
- PowerPoint slides will be distributed at the conclusion of the training.
- SQL queries from the lessons will be provided at the end of the training.
- Both ungraded and marked versions of the exercises will be issued after the training concludes.
Requirements
Familiarity with SQL Fundamentals of Querying or equivalent experience is required.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customised Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from £3200 + VAT*
Contact us for an exact quote and to hear our latest promotions
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.