Developing SQL Queries for Oracle Databases

Nivå: Advanced
Snittbetyg: 4,8/5 4,76/5 Based on 188 Reviews

This Oracle SQL Queries training course will help you increase productivity and maximise 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.

Nyckelfunktioner:

  • After-course instructor coaching benefit
  • Learning Tree end-of-course exam included

Du kommer lära dig att:

  • Maximise 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

Välj den utbildningsform som passar dig bäst

LIVE, LÄRARLEDD

Klassrum och självstudier

  • 4-day instructor-led training course
  • After-course instructor coaching benefit
  • Learning Tree end-of-course exam included

FÖRETAGSINTERN UTBILDNING

Teamträning

  • Använd denna eller någon annan utbildning i ditt företag
  • Fullskalig programutveckling
  • Levereras när, var och hur du vill
  • Blandade utbildningsmodellerSkräddarsytt innehåll
  • Coaching av ett expertteam

Anpassa kurs och innehåll efter teamets behov

Kontakta oss

Utveckla dig och ditt team med anpassade eller öppna kurser alternativt e-learning

Learning Tree erbjuder kundanpassad utbildning hos er, öppna kurser i Stockholm, London eller Washington, möjlighet att delta via våra Anywhere centers (Malmö, Göteborg, Linköping, Stockholm eller Borlänge) eller olika former av e-learning med lärarstöd. Läs mer på www.learningtree.se/priser .

Klassrum och självstudier

Note: This course runs for 4 dagar

  • 3 - 6 mar 9:00 - 4:30 EST Rockville, MD / Online (AnyWare) Rockville, MD / Online (AnyWare) Boka Din Kursplats

  • 7 - 10 apr 9:00 - 4:30 EDT New York / Online (AnyWare) New York / Online (AnyWare) Boka Din Kursplats

  • 12 - 15 maj 9:00 - 4:30 EDT Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Boka Din Kursplats

  • 16 - 19 jun 9:00 - 4:30 EDT Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Boka Din Kursplats

  • 25 - 28 aug 9:00 - 4:30 EDT Rockville, MD / Online (AnyWare) Rockville, MD / Online (AnyWare) Boka Din Kursplats

Kurs med startgaranti

När du ser symbolen för “Guaranteed to Run” vid ett kurstillfälle vet du att kursen blir av. Garanterat.

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 optimisation
    • 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
    • Utilising 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

Teamträning

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.

Questions about which training is right for you?

call 08-506 668 00




100% Satisfaction Guaranteed

Your Training Comes with a 100% Satisfaction Guarantee!*

  • If you are not 100 % satisfied, you pay no tuition fee!
  • No advance payment required for most products.
  • Tuition fee can be paid later by invoice - OR - at the time of checkout by credit card.

*Partner-delivered courses may have different terms that apply. Ask for details.

Rockville, MD / Online (AnyWare)
New York / Online (AnyWare)
Herndon, VA / Online (AnyWare)
Ottawa / Online (AnyWare)
Rockville, MD / Online (AnyWare)
Hur föredrar du att bli kontaktad:

Please Choose a Language

Canada - English

Canada - Français