SQL Fundamentals

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

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 

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.

Refer to Expleo Academy’s Business Analysis, Software Quality Analysis, and Software Engineering Learning Pathways for additional training options.

Expleo Academy is  happy to discuss your specific training needs to advise on your optimal learning pathway. 

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.