There are no items in your cart. Continue shopping on our Course Directory page.
Pay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.
PDF Add to WishList
SQL is the cornerstone of all relational database operations. In this hands-on course, you learn to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, and avoid common errors and pitfalls. It also teaches alternative solutions to given problems, enabling you to choose the most efficient solution in each situation.
The SQL Language is an ANSI/ISO standard language used by all relational database products. This course describes the standard language, but also identifies deviations from the standard in two widely-used database products, Oracle and Microsoft SQL Server. For the hands-on exercises, the course environment allows the students to choose between working with the PostgreSQL database product or Microsoft SQL Server.
SQL fundamentals
Retrieving data with SELECT
Executing queries
Implementing various types of joins
Writing self joins
Combining queries with set operators
Summarising data with aggregate functions
Grouping data
Extending group queries
The OVER clause
Calculating ranks
Extending the use of aggregates
Self-contained subqueries
Correlated subqueries
Common table expressions
Hassle-Free Enrolment: No advance payment required to reserve your seat.
Tuition Fee due 30 days after you attend your course.
Tuition Fee — Standard: £1695
30 Jan - 1 Feb
(
3 Days)
9:00 AM - 4:30 PM GMT
London / Online (AnyWare)
Reserve Your Seat
10 - 12 Apr
(
3 Days)
9:00 AM - 4:30 PM BST
London / Online (AnyWare)
Reserve Your Seat
19 - 21 Jun
(
3 Days)
9:00 AM - 4:30 PM BST
London / Online (AnyWare)
Reserve Your Seat
28 - 30 Aug
(
3 Days)
9:00 AM - 4:30 PM BST
London / Online (AnyWare)
Reserve Your Seat
6 - 8 Nov
(
3 Days)
9:00 AM - 4:30 PM GMT
London / Online (AnyWare)
Reserve Your Seat
AFTERNOON START: Attend these live courses online via Anyware
19 - 21 Dec
(
3 Days)
2:00 PM - 9:30 PM GMT
New York / Online (AnyWare)
Reserve Your Seat
6 - 8 Feb
(
3 Days)
2:00 PM - 9:30 PM GMT
Herndon, VA / Online (AnyWare)
Reserve Your Seat
27 Feb - 1 Mar
(
3 Days)
2:00 PM - 9:30 PM GMT
New York / Online (AnyWare)
Reserve Your Seat
27 - 29 Mar
(
3 Days)
1:00 PM - 8:30 PM GMT
Herndon, VA / Online (AnyWare)
Reserve Your Seat
24 - 26 Jul
(
3 Days)
2:00 PM - 9:30 PM BST
Herndon, VA / Online (AnyWare)
Reserve Your Seat
18 - 20 Sep
(
3 Days)
2:00 PM - 9:30 PM BST
New York / Online (AnyWare)
Reserve Your Seat
Guaranteed to Run
When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.Enroling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.
For details, call 0800 282 353 or Click here »
Course Tuition Fee Includes:
Standard class hours:
9:00 a.m. - 4:30 p.m.
Last day class hours:
9:00 a.m. - 3:30 p.m.
Free Course Exam – Last Day:
3:30 p.m. - 4:30 p.m.
Each class day:
Informal discussion with instructor about your projects or areas of special interest:
4:30 p.m. - 5:30 p.m.
AFTERNOON START class hours:
2:00 p.m. - 9:30 p.m.
Last day class hours:
2:00 p.m. - 8:30 p.m.
Free Course Exam – Last Day:
8:30 p.m. - 9:30 p.m.
Each class day:
Informal discussion with instructor about your projects or areas of special interest
9:30 p.m. - 10:30 p.m.