Structured Query Language (SQL)

This course is for people who want to extend their use of SQL beyond SQL generators found in products like Microsoft Access, programmers who want to embed SQL in their code or programmers who intend to go on to writing stored procedures and other database objects.

2 Days

Printable Version

Syllabus

Relational Database & SQL Introduction

Concept of Normalization

Referential Integrity & the Set Based Nature of SQL

Simple Selects

Column Lists

Calculations & Aliases

Distinct Keyword & Standard Functions

Restrict Rows with the Where Block

Copy with Nulls

Use Multiple Tables

Inner & Outer Joins

Differences between SQL-89 & SQL-92 Syntax

Self Joins

Group & Summarise Data

Aggregate Functions

Group & the Having Clause

Subqueries

Simple Subqueries & the More Complex Correlated Subqueries

Performance Issues & Alternative Strategies to Use Subqueries

Exists & Not Exists

Programme Objects

Views To Hide Complexity from End Users

Introduction to Stored Procedures

Triggers & User Defined Functions

Data Definition Language

Create Tables & Establish Constraints To Ensure Database Integrity

Manipulate Data

Use of Delete

Insert & Update Statements

Introduction to Transactions

SQL Puzzles & Solutions

Case Statement to Provide A Cross-Tab Report

Union Operator to Solve the ‘Detail & Subtotals Problem’

Self Join To Find Erroneous Data

How to Use What You’ve Learnt

If you would like to have a course customised for your organisation, please contact us.