LOOK Systems Training

Structured Query Language

Ref: LKSQL

Objectives

This two day course introduces delegates to the SQL language. During the course each delegate will attempt a variety of exercises developing queries to elucidate different elements of SQL. By the end of the course delegates should be aware of the features of SQL and have gained the understanding required to develop complex queries.

Prerequisites

Delegates should be experienced database users.

Topics

Relational languages

Data definition language

Data manipulation language

Using SQL

Query definition

Query results

SQL Data types

Data definition statements

Create, Drop

Data manipulation statements

Insert, Delete, Update, Select

Nulls and defaults

Predicates used in the Where clause

Set or aggregate functions

Sorting and grouping data

Complex SQL

Working with multiple tables -

Correlations , Sub-queries, Unions

Type functions

Import and export

Views

Transactions

Database procedures

Using SQL from command files