Introduction to ANSI (Generic) Structured Query Language (SQL)
 Course Outline

DURATION 1 day
PREREQUISITES Intermediate MS Access experience, or intermediate experience of a similar database application.
DESCRIPTION This course will provide the opportunity to write and test a range of SQL queries within MS Access.   One of the sections adopts a more theoretical approach in attempting to raise awareness of the additional issues to be considered in a multi-user environment.
COURSE DATES Click here to request an alternate date
Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday.
Weekday Wed, 8-Feb-12 09:30 - 16:30 £200.00 +VAT
Evening Wed, 8-Feb-12 and Thu, 9-Feb-12 18:30 - 21:30 £200.00 +VAT
Weekday Thu, 8-Mar-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 10-Mar-12 10:00 - 16:30 £200.00 +VAT
Weekday Mon, 9-Apr-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 9-Apr-12 and Tue, 10-Apr-12 18:30 - 21:30 £200.00 +VAT
Weekday Tue, 8-May-12 09:30 - 16:30 £200.00 +VAT
Evening Wed, 9-May-12 and Thu, 10-May-12 18:30 - 21:30 £200.00 +VAT
Weekday Fri, 8-Jun-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 9-Jun-12 10:00 - 16:30 £200.00 +VAT
Weekday Mon, 9-Jul-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 9-Jul-12 and Tue, 10-Jul-12 18:30 - 21:30 £200.00 +VAT
Weekday Wed, 8-Aug-12 09:30 - 16:30 £200.00 +VAT
Evening Wed, 8-Aug-12 and Thu, 9-Aug-12 18:30 - 21:30 £200.00 +VAT
Weekend Sat, 8-Sep-12 10:00 - 16:30 £200.00 +VAT
Weekday Tue, 18-Sep-12 09:30 - 16:30 £200.00 +VAT
Weekday Mon, 8-Oct-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 8-Oct-12 and Tue, 9-Oct-12 18:30 - 21:30 £200.00 +VAT
Weekday Thu, 8-Nov-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 12-Nov-12 and Tue, 13-Nov-12 18:30 - 21:30 £200.00 +VAT
Weekend Sat, 8-Dec-12 10:00 - 16:30 £200.00 +VAT
Weekday Mon, 10-Dec-12 09:30 - 16:30 £200.00 +VAT
Any One-to-One Tuition
Any Date - Fully Customisable		 09:30 - 16:30 £400.00 +VAT

Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses.

 

 

 

What is SQL

  • An Introduction to ANSI Structured Query Language (SQL)

  • SQL and Relational Databases

  • Definitions

  • Data Organisation

  • What does SQL do?

Case Study

  • The Course Sample Database

Data Retrieval

  • The SELECT Statement

  • SELECT syntax

  • SELECT keywords

  • The WHERE Clause

  • SELECT ... OR/ANDS

  • Logical Connectors

  • Aggregate Functions

  • Additional Functions

  • Additional Clauses

Data Records Maintenance

  • Database Maintenance

  • UPDATE / INSERT / DELETE

Database Structural Maintenance

  • Database Creation

  • Creating a Table

  • Altering a Table

Handling data retrieval from multiple tables

  • Additional SELECT Types

  • Equi-Joins

  • Outer Joins

  • Self Joins

  • Sub-Queries

Implementing data integrity Strategies

  • Data Integrity - an appreciation

  • Referential Integrity / Actions

Course Summary