generic SQL

Introductory and Advanced courses

1) Introductory

Course code SQL01

Duration: 2 days

Objectives
This is a generic course is for those expected write SQL queries with a relational database

Benefits
Delegates will be given a sound understanding of SQL as it is implemented by many commercial databases
Delegates will be able to interpret SQL statements and develop their own SQL processing functions. Also, they will be able to devise complex queries and manipulate data in a relational database
Delegates will also learn the mechanics of relational databases

Pre-requisites:
Prior knowledge of database fundamentals would be an advantage.
Attendees should have some experience with either the Unix or Windows environments and applications before undertaking this course

Course Outline

Introduction
Defining Structured Query Language
Introduction to relational databases
Tables, Rows and Columns
Interactive SQL environments
General SQL guidelines

Developing queries
The SELECT statement
The WHERE clause
Specifying conditions - relational and logical operators
Pattern matching with LIKE
Other operators
The ORDER BY clause
The GROUP BY and HAVING clauses
Computed values. Null values. Selecting information from more than one table.

Data manipulation
Inserting new data.
Modifying existing rows.
Deleting data that is no longer required

Database Definition
Table creation
Specifying data types for columns
Examples of data types Changing, removing tables
Creating indexes
Indexing strategies

Controlling access to the database
Privileges and Permissions
Privilege management
The GRANT and REVOKE statements

Advanced SQL features
Aggregate functions
Nested queries
Joins
Views

Please note: this course is offered both as a scheduled or a customised course. We should be happy to supply details.

2) Advanced

Course code SQL02

Duration: 1 day

Objectives

This is a generic course is for those expected to write SQL queries with a relational database

Benefits

Delegates will be given a sound understanding of SQL as it is implemented by many commercial databases. Delegates will be able to interpret SQL statements and develop their own SQL processing functions. Also, they will be able to devise complex queries and manipulate data in a relational database.

Pre-requisites

Delegates will need to be using much of the features covered by the Introductory course.
We recommend that attendees have some experience with either the Unix or Windows operating system before undertaking this course.

Course Topics

Using Enterprise Manager more fully
Inner and Outer Joins
Nested queries
Stored Procedures
Triggers
Back up and Restore
Maintenance Plan

Please note: this course is as a customised course only. We should be happy to supply details.