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.
SQL is the cornerstone of all relational database operations. In this hands-on Writing Advanced SQL Queries course, you will learn how 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.
Attend this Writing Advanced SQL Queries training in one of three formats - live, instructor-led, on-demand or a blended on-demand/instructor-led version.
BLENDED LEARNING
Unlimited annual access to:
LIVE, INSTRUCTOR-LED
PREMIUM TRAINING
Unlimited annual access to:
TRAINING AT YOUR SITE
Customize Your Team Training Experience
CONTACT USOur flexible, easy-to-redeem training vouchers are available to any employee within your organisation. For details, please call 0800 282 353 or chat live.
This product offers access to a library of Microsoft on-demand courses including SQL, Windows, Exchange, and more. At any time during your annual access to this offering, you may attend one of our 1-day review sessions focused specifically on Powerful SQL Queries for SQL Server (4559).
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.
No. While many of the same points are covered, taking the instructor-led Writing Advanced SQL Queries course provides the deepest dive into that area. This offering is indented for those who wish to gain a broad knowledge of the topics described in the course outline above - including SQL.
An outline of the content you will receive can be seen above. You will also get access to any new on-demand content that becomes available during your annual enrolment period.
You will get access 19 pre-configured lab bundles spanning the Microsoft curriculum.
17 practise exams spanning the Microsoft curriculum are included
Once payment is received, you will receive an email from Learning Tree with all the links and information you need to get started.
Once you are enrolled in the program, specific details and dates will be sent to you.
You'll be able to register for a Training Review Session at any time after you've placed your order.
29 - 31 Mar
9:00 AM - 4:30 PM BST
Online (AnyWare)
29 Jun - 1 Jul
9:00 AM - 4:30 PM BST
Online (AnyWare)
21 - 23 Sep
9:00 AM - 4:30 PM BST
Online (AnyWare)
21 - 23 Dec
9:00 AM - 4:30 PM GMT
Online (AnyWare)
3 - 5 Feb
2:00 PM - 9:30 PM GMT
Online (AnyWare)
16 - 18 Jun
2:00 PM - 9:30 PM BST
Herndon, VA / Online (AnyWare)
4 - 6 Aug
2:00 PM - 9:30 PM BST
New York / Online (AnyWare)
8 - 10 Dec
2:00 PM - 9:30 PM GMT
Herndon, VA / Online (AnyWare)
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 — will run. Guaranteed.This product offers access to a library of Microsoft on-demand courses including SQL, Windows, Exchange, and more. At any time during your annual access to this offering, you may attend one of our 1-day review sessions focused specifically on Powerful SQL Queries for SQL Server (4559).
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
The SQL Language is an ANSI/ISO standard language used by all relational database products.
For the hands-on exercises, you will choose between working with the PostgreSQL database product or Microsoft SQL Server.
Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want, including online training.
29 - 31 Mar 9:00 AM - 4:30 PM BST Online (AnyWare)
29 Jun - 1 Jul 9:00 AM - 4:30 PM BST Online (AnyWare)
21 - 23 Sep 9:00 AM - 4:30 PM BST Online (AnyWare)
21 - 23 Dec 9:00 AM - 4:30 PM GMT Online (AnyWare)
3 - 5 Feb 2:00 PM - 9:30 PM GMT Online (AnyWare)
16 - 18 Jun 2:00 PM - 9:30 PM BST Herndon, VA / Online (AnyWare)
4 - 6 Aug 2:00 PM - 9:30 PM BST New York / Online (AnyWare)
8 - 10 Dec 2:00 PM - 9:30 PM GMT Herndon, VA / Online (AnyWare)
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 — will run. Guaranteed.This product offers access to a library of Microsoft on-demand courses including SQL, Windows, Exchange, and more. At any time during your annual access to this offering, you may attend one of our 1-day review sessions focused specifically on Powerful SQL Queries for SQL Server (4559). Enrolling in this bundle also grants you access to any of our multi-day Writing Advanced SQL Queries (929) course events.
Once payment is received, you will receive details for your Unlimited Access Training Bundle via email. At that time, you may call or email our customer service team for assistance in enrolling in the event date of your choice.
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.
No. While many of the same points are covered, taking the instructor-led Writing Advanced SQL Queries course provides the deepest dive into that area. This offering is indented for those who wish to gain a broad knowledge of the topics described in the course outline above - including SQL.
An outline of the content you will receive can be seen above. You will also get access to any new on-demand content that becomes available during your annual enrolment period.
You will get access 19 pre-configured lab bundles spanning the Microsoft curriculum.
17 practise exams spanning the Microsoft curriculum are included
Once payment is received, you will receive an email from Learning Tree with all the links and information you need to get started.
Once you are enrolled in the program, specific details and dates will be sent to you.
Once payment is received, you will receive details for your Unlimited Access Training Bundle via email. At that time, you may call or email our customer service team for assistance in enrolling in the event date of your choice.
You'll be able to register for a Training Review Session at any time after you've placed your order.
Relational Database Design Training: Tools and TechniquesWriting Powerful SQL Queries for SQL Server
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.