-
-
Cart
There are no items in your cart. Continue shopping on our Course Directory page.
SUBTOTALPay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.
-
Developing SQL Queries for Oracle Databases
Level: Advanced
Rating:
4.80/5 Based on 132 Reviews
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.
Key Features of this Oracle SQL Queries Training:
- After-course instructor coaching benefit
- Learning Tree end-of-course exam included
You Will Learn How To:
- Maximize the potential of SQL to formulate complex queries
- Thoroughly test SQL queries and avoid common errors
- Select the most efficient solution to complex SQL problems
- Leverage the analytical functions of Oracle
- Employ inner joins, outer joins, cross joins, and self joins
Certifications/Credits:
Choose the Training Solution That Best Fits Your Individual Needs or Organizational Goals
LIVE, INSTRUCTOR-LED
In Class & Live, Online Training
- 4-day instructor-led training course
- After-course instructor coaching benefit
- Learning Tree end-of-course exam included
- Earn 23 NASBA credits (live, in-class training only)
TRAINING AT YOUR SITE
Team Training
- Bring this or any training to your organization
- Full - scale program development
- Delivered when, where, and how you want it
- Blended learning models
- Tailored content
- Expert team coaching
Customize Your Team Training Experience
CONTACT USSave More On Training with FlexVouchers – A Unique Training Savings Account
Our 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.
In Class & Live, Online Training
Time Zone Legend:
Note: This course runs for 4 Days *
*Events with the Partial Day Event clock icon run longer than normal but provide the convenience of half-day sessions.
-
Oct 6 - 9 9:00 AM - 4:30 PM EDT Online (AnyWare)
Reserve Your Seat -
Nov 10 - 13 9:00 AM - 4:30 PM EST Online (AnyWare)
Reserve Your Seat -
Dec 8 - 11 9:00 AM - 4:30 PM EST Online (AnyWare)
Reserve Your Seat -
Apr 6 - 9 9:00 AM - 4:30 PM EDT Herndon, VA / Online (AnyWare)
Reserve Your Seat -
Jun 22 - 25 9:00 AM - 4:30 PM EDT Ottawa / 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 — will run. Guaranteed.Partial Day Event
Learning Tree offers a flexible schedule program. If you cannot attend full day sessions, this option consists of four-hour sessions per day instead of the full-day session.Oracle SQL Queries Course Information
-
Requirements
SQL and Oracle RDBMS knowledge at the level of: Course 925, SQL Programming Language Introduction, or Course 2226, Oracle Database 12c Introduction -
Software
This course is currently running on Oracle 12c
Oracle SQL Queries Course Outline
-
Introduction and Overview
The uses of SQL queries
- Why SQL can be both easy and difficult
- Recommendations for thorough testing
Enhancing query performance
- Query optimization
- Choosing the most efficient query method
-
Leveraging SQL Functions to Build Queries
Aggregate functions
- Grouping in several levels
- Grouping and NULLs
- CUBE and ROLLUP
- Building crosstab reports
- Utilizing the PIVOT operator in Oracle 11g
Single-row functions
- String-manipulation functions
- Functions for date and time manipulation
- Simulating IF ... THEN ... ELSE with functions
- Handling regular expressions with Oracle 10g functions
-
Performing Extensive Analysis with Analytical Functions
Calculating ranks
- RANK and DENSE_RANK
- ROW_NUMBER depending on ORDER BY
Extending the use of aggregates
- Partitioning in multiple levels
- Computing running totals
- Comparing row and aggregate values
- Defining sliding window boundaries
-
Developing Complex Joins
Creating inner and outer joins
- Building multiple table joins
- Grouping and joins
How and when to use self-joins
- Implementing recursive self-joins with CONNECT BY
- CONNECT BY and join simultaneously
- Oracle 10g enhancements to CONNECT BY
Applying the ANSI standard join syntax
- INNER JOIN
- CROSS JOIN
- LEFT, RIGHT and FULL OUTER JOIN
- Adding filter conditions to OUTER JOINS
- Differences between new ANSI and old Oracle style
Manipulating the set operators
- UNION and UNION ALL
- INTERSECT
- MINUS
-
Building Subqueries
Noncorrelated subqueries
- Subqueries that return NULL
- Multiple row subqueries
- Multiple column subqueries
Handling correlated subqueries
- Fetching main query values
- The EXISTS operator
- Avoiding accidental correlation
Subqueries in the FROM clause
- Breaking up a complex problem into manageable pieces
- Factoring subqueries for reusability
- Applying recursive factored subqueries in Oracle 11g R2
Subqueries as expressions
- Subqueries as parameters to functions
- Correlated and noncorrelated subqueries in expressions
-
Employing Views and Temporary Tables
Overcoming obstacles with views
- Multiple group levels in one query
- How views impact performance
Temporary tables as alternatives to views
- Avoiding interference from other users
- Tailoring temporary tables
-
Introducing Oracle 12c
- Limiting the number of rows returned with FETCH
- Retrieving partly results with OFFSET
- Simulating joins with lateral views and APPLY
- Declaring local functions in the WITH clause
Team Training
Oracle SQL Queries Training FAQs
-
What software does this Oracle SQL Queries course run on?
This course is currently running on Oracle 12c.
-
Can I learn to create Oracle SQL queries online?
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.
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.