Introduction to ANSI (Generic) Structured Query Language (SQL)
Short course
In Southwark
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
Start date
About this course
Intermediate MS Access experience, or intermediate experience of a similar database application.
Reviews
Course programme
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?
- The Course Sample Database
- The SELECT Statement
- SELECT syntax
- SELECT keywords
- The WHERE Clause
- SELECT ... OR/ANDS
- Logical Connectors
- Aggregate Functions
- Additional Functions
- Additional Clauses
- Database Maintenance
- UPDATE / INSERT / DELETE
- Database Creation
- Creating a Table
- Altering a Table
- Additional SELECT Types
- Equi-Joins
- Outer Joins
- Self Joins
- Sub-Queries
- Data Integrity - an appreciation
- Referential Integrity / Actions
Introduction to ANSI (Generic) Structured Query Language (SQL)