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.
This Oracle SQL Queries training course will help you increase productivity and maximize the potential of SQL to formulate intricate queries for Oracle databases. Learn to solve business problems easily, efficiently, and elegantly with only a few lines of SQL code, and gain the practical skills to choose the best query method — ensuring accuracy and avoiding common errors or pitfalls.
LIVE, INSTRUCTOR-LED
TRAINING AT YOUR SITE
Customize Your Team Training Experience
CONTACT USOur FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.
Apr 6 - 9
9:00 AM - 4:30 PM EDT
Online (AnyWare)
Jun 22 - 25
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare)
Aug 10 - 13
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare)
Oct 5 - 8
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Nov 30 - Dec 3
9:00 AM - 4:30 PM EST
Ottawa / Online (AnyWare)
Feb 1 - 4
9:00 AM - 4:30 PM EST
New York / 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.The uses of SQL queries
Enhancing query performance
Aggregate functions
Single-row functions
Calculating ranks
Extending the use of aggregates
Creating inner and outer joins
How and when to use self-joins
Applying the ANSI standard join syntax
Manipulating the set operators
Noncorrelated subqueries
Handling correlated subqueries
Subqueries in the FROM clause
Subqueries as expressions
Overcoming obstacles with views
Temporary tables as alternatives to views
This course is currently running on Oracle 12c.
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.
Questions about which training is right for you?
It allows us to direct your request to the appropriate Customer Care team.
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.