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.
Those who are developing applications using relational databases, or who are using SQL to extract and analyze data from databases and need to use the full power of SQL queries.
This is an advanced course and knowledge of the basics of SQL at the level of Introduction to SQL Programming Training or equivalent is assumed.
SQL fundamentals
Retrieving data with SELECT
Executing queries
Implementing various types of joins
Writing self joins
Combining queries with set operators
Summarizing 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 due 30 days after you attend your course.
Tuition — Standard: $2745 Government: $2415
Jul 11 - 13
(3 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare)
Reserve Your Seat
Aug 15 - 17
(3 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Reserve Your Seat
Sep 12 - 14
(3 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare)
Reserve Your Seat
Nov 14 - 16
(3 Days)
9:00 AM - 4:30 PM EST
Herndon, VA / Online (AnyWare)
Reserve Your Seat
Dec 19 - 21
(3 Days)
9:00 AM - 4:30 PM EST
New York / Online (AnyWare)
Reserve Your Seat
Jan 9 - 11
(3 Days)
9:00 AM - 4:30 PM EST
Ottawa / Online (AnyWare)
Reserve Your Seat
Mar 27 - 29
(3 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Reserve Your Seat
May 8 - 10
(3 Days)
9:00 AM - 4:30 PM EDT
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 1-888-843-8733 or Click here »
$2745
$2415
Course Tuition Includes:
Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm