Introduction to SQL

1 day @ £395.00  
S5

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.

Requirements

Some previous programming or database experience would be useful.

Follow-On Courses

NOTE: Course technical content is subject to change without notice.

Introduction to SQL Training Course

Course Contents - DAY 1

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: RELATIONAL DATABASE CONCEPTS

  • What is a Relational Database?
  • Tables, Rows and Columns
  • Indexes, Primary Keys and Foreign Keys
  • Data Types
  • The Data Dictionary
  • Getting Started

Session 2: SQL LANGUAGE ESSENTIALS

  • The Select Statement
  • The Select and From Clauses
  • Conditions and the Where Clause
  • The Order By Clause
  • Arithmetic Operations
  • Column Aliases
  • Practical Exercises

Session 3: SUMMARISING AND GROUPING DATA

  • Aggregate Functions
  • The Group By Clause
  • The Having Clause
  • Practical Exercises

Session 4: QUERYING MULTIPLE TABLES

  • Joining Tables
  • Inner Joins
  • Column Qualification and Table Aliases
  • Outer Joins
  • Self Joins
  • Alternative Join Syntax
  • Practical Exercises

Session 5: ADDITIONAL SQL FEATURES

  • Combining Queries
  • The Union, Intersect and Minus Operators
  • Basic Subqueries
  • Practical Exercises

Follow-On Courses


       Home     Let Us Call You     Enquiry     Make Booking     Top

Make A Booking

In London
 

In Birmingham
 

In Leeds




May also be run upon request at:

Centres


MOD Career Transition

Ministry Of Defense - Career Transition Partnership

 

We have created our website to the following W3C standards, this helps makes our pages easier to use for you.

Valid HTML 4.01 Transitional

Valid CSS!

If you find a non-compliant page on our site, please let us know and we will endeavour to fix it immediately.
 

Publicly Scheduled
Training Locations
London centre:
6 Long Lane
Barbican
London
EC1A 9HF
UK

telephone:
+44 (0)20 7600NoSkype 6116
Manchester centre:
St James Court
30 Brown Street
Manchester
M2 1DH
UK
Birmingham centre:
The Enterprise Suite
9th Floor Centre City Tower
5-7 Hill Street
Birmingham
B5 4UA
UK
Bristol centre:
Apex House
Westerleigh Business Park
Turner Drive
Yate
Bristol
BS37 5YX
UK
Leeds centre:
Halsbury House
Chancellor Court
21 The Calls
Leeds
LS2 7EH
UK
Edinburgh centre:
16 St Mary's Street
Edinburgh
Scotland
B3 2HJ
UK
Please contact our London office for all enquiries.

telephone:
+44 (0)20 7600NoSkype 6116

or email:

info@
stayahead.com



 

Top  |  Go back  

Print Friendly

Printer friendly version of the Introduction to SQL outline