Get in Touch
 Duration 14 hours

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:
  1. SUM
  2. AVE
  3. MIN
  4. MAX
  5. 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
  1. SQL Transactions in data selection
  2. 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.
Investment

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)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories