SQL Fundamentals

SQL Fundamentals
1 day
Value:   R2,500 incl VAT* 

 

  • *ZAR pricing available and applicable to Southern African residents only!
  • Remote Training
Upcoming Dates:
  • 19 March 2025
  • 04 June 2025

 

Contact us for more information:
academy-sa@expleogroup.com

 

Expleo SA Academy’s one-day practical workshop provides a good understanding of basic SQL techniques. The SQL taught will enable the design of database queries on any database management system. This will support a deeper understanding of information systems used for business purposes.

The course is delivered by SQL practitioners, who can share their knowledge and experience of using the taught techniques.

The collaborative training approach provides access to a data model and a training database with which you can practice constructing SQL commands.

Expleo SA Academy also uses a cloud-based platform solution to provide a stable and rich environment to facilitate instructor demos and practical exercises for attendees.

Who is this for:

Anyone wishing to gain knowledge of Structured Query Language, as well as those wishing to brush up on their SQL skills. This includes End Users of business systems, Business Analysts, Test Analysts, Test Managers, Software Engineers, and anyone who might want to query data from a database management system. The course is equally applicable as an introduction to SQL and a refresher for those with previous knowledge.

Course Objectives

On completion of this course, attendees will be able to:

  • Recognise different types of commonly used databases
  • Recognise common approaches to modelling data requirements
  • Understand the basic structure of a relational database
  • Design a basic select statement
  • Retrieve specific data with clauses and operators
  • Use basic calculations and Functions
  • Collate retrieved data with clauses
  • Use Joins to retrieve data from different tables in one select statement

Prerequisites:

  • There are no specific prerequisites for this training. The content is equally applicable to those who have no experience with SQL as to those who have had experience with SQL and require practical guidance to refresh their competency in this topic.

Introduction

  • What is SQL?
  • Types of databases
  • Types of data models
  • Keys
  • Common Data Types
  • Example of a relational data model

Normalisation And Database Design

  • Issues with Database design
  • Normalization in database design
  • Creating a Database Schema

The SELECT Statement

  • The SELECT statement
  • Querying data from columns and tables
  • Ordering retrieved data
  • Retrieving unique data using DISTINCT statements
  • Retrieving specific rows using the WHERE clause
  • The use of Operators with WHERE clauses
  • Performing calculations on retrieved data
  • Using aliases
  • Commonly used functions
  • Collating retrieved data with the GROUP BY clause
  • Filtering retrieved data with the HAVING clause
  • Nested SELECT statements
  • Practice and guidance on database queries using SELECT statements, clauses, operators, calculations, functions, and aliases

Joins

  • Querying data from multiple tables using Basic Joins
  • Cross Joins
  • Equi-Joins
  • Resolving ambiguous field names
  • Table name aliases
  • Inner Joins
  • Left Outer Joins
  • Right Outer Joins
  • Full Outer Joins
  • Using NULL values
  • Nested Joins
  • Nested Selects
  • Practice and guidance on database queries using Joins

Real World Examples

  • Microsoft Query
  • Microsoft Excel
  • Microsoft SQL Server
  • Keys
Tags