Book your Introduction to SQL Training Course
This one day course is being run 14 times between Wednesday 6th June 2012 and Wednesday 19th December 2012 in London, Leeds, Birmingham,
Book this course with us today from as little as £355.50 + VAT and with our price guarantee you can be confident of getting great value. Our team of experienced independent booking administrators will make the joining process painless and by providing feedback on your experiences you’ll also influence the Coursebookers independent course ratings.
Sorry no downloadable outline found.Expert Help
If you would like
advice, or to book, call
one of our experts on
Open: 9am - 5:30pm
Monday- Friday
Locations/dates for this course
| Date | Provider | Location | Rating | Price | ||
|---|---|---|---|---|---|---|
| Wednesday 06 June 2012 | StayAhead | London |  | Save £39.50 | £355.50+VAT | |
| Friday 08 June 2012 | StayAhead | Leeds | | Save £39.50 | £355.50+VAT | |
| Monday 25 June 2012 | StayAhead | London | | Save £39.50 | £355.50+VAT | |
| Monday 30 July 2012 | StayAhead | London | | Save £39.50 | £355.50+VAT | |
| Monday 06 August 2012 | StayAhead | London | | Save £39.50 | £355.50+VAT | |
| Tuesday 28 August 2012 | StayAhead | Birmingham | | Save £39.50 | £355.50+VAT | |
| Monday 24 September 2012 | StayAhead | London | | Save £39.50 | £355.50+VAT | |
| Monday 15 October 2012 | StayAhead | Birmingham | | Save £39.50 | £355.50+VAT | |
| Monday 15 October 2012 | StayAhead | London | | Save £39.50 | £355.50+VAT | |
| Monday 29 October 2012 | StayAhead | London | | Save £39.50 | £355.50+VAT | |
| Monday 12 November 2012 | StayAhead | Leeds | | Save £39.50 | £355.50+VAT | |
| Monday 12 November 2012 | StayAhead | London | | Save £39.50 | £355.50+VAT | |
| Monday 10 December 2012 | StayAhead | London | | Save £39.50 | £355.50+VAT | |
| Wednesday 19 December 2012 | StayAhead | London | | Save £39.50 | £355.50+VAT |
|
|
Book your course now with Coursebookers!
Making an enquiry to Coursebookers couldn't be easier, just fill out the form to the left or call 01920 460232 and our team will be in touch within 48 hours.
Remember:
- Not only are we great value, we can also boast no booking fees
- Human administrators make booking & coordination simple and painless
- Coursebookers is vendor neutral we can offer unbiased and independent advice
- If you have complex booking requirements we're happy to help! Call our team on 01920 460232 to discuss your needs
- We ensure all our courses meet our high standards, meaning you'll only ever see "the best of the best" on Coursebookers!
Summary:
This 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.
PreRequisites:
There are no formal pre-requisites, although an understanding of databases and exposure to information technology in general would be useful.
Audience:
- Anyone who needs to understand and use SQL to manipulate a database.
Objectives:
- To provide the knowledge and skills needed to retrieve and update data held in a relational database.
Outline:
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
Description:
This 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.
StayAhead
StayAhead training has been offering high quality IT technical training courses since 1992. They specialise in UNIX, Oracle, Linux and MySQL training and pride themselves on the long term investments they put into attending delegates.
StayAhead has gained a reputation for offering high quality courses and is ranked as one of the UK’s top 50 business organisations in 2008.
Want to leave your own testimonial? click Here
Really worth attending.