SQL Taining Course Midlands | Birmingham | Telford | Stafford | Wolverhampton

SQL (Structured Query Language) is central to working with any form of database. In this practical hands on course participants learn how to use the full potential of SQL to write complex and robust queries. The course will significantly help anyone who needs to retrieve or manipulate information in a relational database

Topics include

Overview of Relational Databases
The SQL standard
The ANSI standards
Components of a relational database
Normalised data
Anatomy of a table
Primary and foreign keys
Joins
Components of SQL

Data Manipulation Language
SELECT operations
DISTINCT
Virtual columns
Column aliases
Functions
Restricting the rows returned
Multiple conditions
Ordering data
Inserting rows
Updating rows
Deleting rows

Joining tables
The theory of joining tables
Cross, Inner, Outer, Full, Left and Right
Composite joins
Table aliases
SQL92 and SQL89 Join syntax

Data Definition Language
Data types
Column attributes
Create table
Primary and foreign keys
Referential integrity
Alter and drop tables

Views
Defining simple views
Views with virtual columns
Restricted-column views
Joined-table views
Restricted-row views
View restrictions

Summarised Queries
Table aggregates
GROUP BY and aggregates
The HAVING clause

Subqueries
Using Subqueries
EXISTS
Correlated Subqueries
Advanced Subqueries

Further Data Manipulation Language
Unions
Self joins