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

Short course

In Southwark

Price on request

Description

  • Type

    Short course

  • Location

    Southwark

  • Duration

    1 Day

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.

Facilities

Location

Start date

Southwark (London)
See map
202 Blackfriars Road, SE1 8NJ

Start date

On request

About this course

Intermediate MS Access experience, or intermediate experience of a similar database application.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

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.

PREREQUISITES
Intermediate MS Access experience, or intermediate experience of a similar database application.

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

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

Price on request