Introduction to SQL

Course

In London, Leeds, Manchester and another venue.

£ 395 VAT inc.

Description

  • Class hours

    7h

  • Duration

    1 Day

On completion of the course, the delegate will have a basic understanding of the structure of a relational database and the functions of a DBMS.  They will have a working knowledge of the ANSI Standard Structured Query Language (SQL) allowing them to access database tables. Suitable for: This course is intended for people who need to access and work with relational databases.

Facilities

Location

Start date

Birmingham (West Midlands)
See map
C/O Netcom Training Solutions, 6th Floor, Quay Side Tower, Broad Street, Birmingham B1 2hf, B5 4UA

Start date

On request
Leeds (West Midlands)
See map
Halsbury House, Chancellor Court, 21 The Calls, LS2 7EH

Start date

On request
London
See map
6 Long Lane, Barbican, EC1A 9HF

Start date

On request
Manchester (Greater Manchester)
See map
C/O Yses, St James Court, 30 Brown Street, M2 1DH

Start date

On request

About this course

Some previous programming or database experience would be useful.

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

Subjects

  • Creating SQL statements to query a database table

Course programme

Introduction to SQL Course Overview
The Introduction to SQL course is designed to give delegates practical experience in using ANSI standard SQL. As it is a generic course, some of the differences between different vendors' implementations will be noted.
Skills Gained
The delegates will practise:
  • Creating SQL statements to query a database table
  • Writing SQL statements to retrieve data from multiple tables
  • Using standard aggregate functions
  • Implementing Subqueries
Who will the Course Benefit?
Anyone who needs to understand and use SQL to manipulate a database.
There are no formal pre-requisites for this Introduction to SQL course, although an understanding of databases and exposure to information technology in general would be useful.
Course Objectives
To provide the knowledge and skills needed to retrieve and update data held in a relational database.

Introduction to SQL

£ 395 VAT inc.