Specialist - SQL

MS SQL Training

SQL (Structured Query Language) is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

Please select the version that you’re interested from below:

Please select the level that you’re interested in

SQL With MS Access As A Platform Introduction

Course Overview


SQL 2008 Introduction course is suitable for those who are looking to analyse their data using specific query features incorporated within SQL.


You are not required to have any.prior knowledge or experience of SQL. However, use or understanding of MS Access Queries or simliar would be beneficial.


This is a 2 day SQL 2008 Introduction course. The course starts at 09:30 and runs until 16:30. Alternate timings can be arranged upon request. The course can be held on a date that suits you.


Our SQL 2008 Introduction course can be run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.

SQL with MS Access As A Platform Introduction Course Outline

Relational database concepts

Queries in MS Access databases

SELECT – FROM statement (including DISTINCT)

WHERE statement; conditional operators including logical operators, wildcards, LIKE, BETWEEN, IN, AND, OR


Calculated columns & aliases

Aggregate functions (eg SUM, MIN, MAX, AVG)

Date calculations (eg DATE, DATEPART, DATEADD, DATEDIFF)

GROUP BY clause

HAVING clause

Joins (inner, outer, self-joins)

UNION operator


Adding data using SELECT INTO, INSERT INTO

Updating existing records; SET statement

Deleting records eg DELETE FROM

Creating tables using CREATE TABLE

Deleting tables using DROP TABLE

Modifying table design using ALTER TABLE; adding, changing, deleting columns

creating indexes using CREATE INDEX

Deleting indexes using DROP INDEX

Deleting databases

Show more
One to One

(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training

Group for up to 8 learners
The Course outlines on our website are standard, however, we would be happy to tailor them to your specific requirements. Please call us on 020 3696 2796 or send us a message to discuss further.

What Our Clients Say


This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.