Feedback

Feedback to trainingforit.co.uk


Site comment Site ratings
Email (optional)

Content

Design

Ease of use

Overall

Introduction to SQL

Summary
Length:
1 day
Price:
395 GBP excl. VAT
Training Provider:
StayAhead Training plusStayAhead Training
Location:
Training Method:
Startdate:  
London: 17/02/2012, 05/03/2012, 10/04/2012
Birmingham: 19/03/2012, 28/08/2012, 15/10/2012
Leeds: 28/05/2012, 12/11/2012

About Introduction to SQL

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
  • Oracle SQL




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

Continuing studies

Follow on course: Oracle SQL

Expenses

£395.00

About StayAhead Training

technical it training

SQL, Oracle, UNIX and Linux experts

StayAhead Training are recognised as one of the top 50 IT Training organisations in the UK and the first choice provider of UNIX, Linux, MySQL and Oracle training courses for many of the UK's most prominent organisations.

StayAhead Training was established in 1992 and now have training centres in London, Birmingham, Manchester, Leeds, Edinburgh and Bristol. Because of this, StayAhead are able to offer a large range of scheduled, tailored and onsite training. Independent of where you are based, StayAhead can help you and your firm's IT requirements be reality.

StayAhead IT Training works with some of the largest names in the IT training industry to provide courses on behalf of Parity Training, Global Knowledge, New Horizons and many more.

unix, linux, oracle, sql, javaSpecialist IT training

StayAhead Training have a formidable reputation for quality and expertise within the UNIX, Oracle, Linux and MySQL arena and enjoy an enviable position in the UK by being amongst the top IT Technical training organisations.

The UNIX curriculum not only covers standard UNIX but includes a range of Solaris, AIX, HP-UX, Linux, SUSE, LPI & Red Hat Linux training. The Oracle curriculum also has depth with courses available for DBAs, Developers and Designers. If certification is important to you then again we do not disappoint taking delegates to the level required to take the examinations in Solaris, Red Hat, SUSE, LPI, MySQL, Oracle Forms Developer and Oracle DBA. With the Oracle e-business suite growing in popularity a range of Oracle Financials courses are also available.

StayAhead's training flexibility comes from developing their own courses that include high quality course material, written not only to support the learning process, but can also act as a helpful reference guide on the delegates return to work.

In-house IT training

In addition to the public schedule of courses provided, StayAhead offer all courses in-house at a client's site, or at a StayAhead location. All courses can be tailored to meet our clients' specific needs. For courses at the client's site StayAhead can provide all the necessary hardware and software.

StayAhead's focus on IT training

StayAhead understands the best approach for such technical IT training is always to be enthusiastic, business-like, informal yet professional. Whether delegates attend a StayAhead Training scheduled course or an on-site course, each event is approached in a professional manner.

StayAhead's style of delivery is designed to foster the development of learning. Instructor led tutorials are followed by practical exercises. The style is experiential allowing delegates to take ownership and solve problems for themselves. Research shows that the pace of learning is greatly accelerated when delegates are shown HOW to solve their problems rather than just why they should.

specialist it training


plus Show all courses with StayAhead Training

Request information - obligation free

Get more information from StayAhead Training by filling out the following form. This is a free service for you and the course provider to help you find the most suitable training.
To request information from StayAhead Training, please fill out the following details:
* =  Required field
Email Address*
First Name*
Last Name*
Company
Position
Town/City*
Telephone*
Start date
Number of participants
Message*
Rules

Contact information for StayAhead Training

StayAhead Training

6 Long Lane, Barbican
EC1A 9HF London

Phone no: 020 7600 6116
www.stayahead.com

More Information
Request Information
To request information from Introduction to SQL, please fill out the following details:

What happens now?
Write a course review
Have you studied » Introduction to SQL at » StayAhead Training? Share your experience & help others to pick the right course. Set grades (1-5) where 1= very poor & 5 = excellent.
V. Poor | Poor | OK | Good | Excellent
Trainer / Provider
Venue / Facilities
Course Materials
Networking with other delegates

Do you recommend the provider:


Need help finding the right course?

  
By submitting your e-mail, you become a member of Trainingforit.co.uk