Oracle 10g Advanced SQL

Software Training Academy
Toronto, Ontario, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course will give experienced Oracle technologists the advanced SQL skills necessary to design and code complex queries against Oracle databases.



You will learn to use many advanced SQL coding techniques such as coding analytic functions for data warehouse and decision support queries, using partition outer join to "densify" data, the Oracle10g MODEL clause ("spreadsheet-like capability directly from the database"), Oracle10g regular expressions for pattern matching, using the extended aggregate functions CUBE and ROLLUP, CONNECT BY (hierarchical queries), coding SET operations such as INTERSECT, and more.



An overview Oracle10g SQL-related new features is also provided.



As with all of our courses, this course is highly customizable to your specific training requirements.





LEARNING OBJECTIVES



· Design, code and test the most efficient Oracle query for a given business problem

· Code efficient inner and outer joins, including the use of the Oracle ANSI-compatible join syntax

· Use Oracle10g partition outer join to "densify" data (i.e. fill in the gaps)

· Code complex subqueries including correlated subqueries, inline views, subqueries in the column-list, Oracle subquery factoring (the "WITH" clause) and NOT EXISTS queries

· Code partition independent and partition-aware queries.

· Use the set operators UNION , INTERSECT and MINUS to combine the results of two or more queries into a single result set.

· Query and generally handle Oracle date and datetime (i.e. temporal) data.

· Use the Oracle10g MODEL clause to produce spreadsheet-like results (e.g. sales forecasting) from a query result set

· Use Oracle10g regular expressions for text pattern matching (i.e. search and optionally replace data using the POSIX-compatible regular expressions)

· Use Oracle analytic functions to code efficient solutions to complex decision support problems such as ranking (e.g. top earners by department), percentages within a group (e.g. each employees percent of total payroll), cumulative totals (e.g. cumulative salary by department), lag and lead functions (compare to next / previous row - without a self-join), windowing functions and more.

· Use the Oracle CUBE and ROLLUP extensions to create super-aggregate rows of output (i.e. add additional dimensions of data to the result).

· Use the Oracle GROUPING function with CUBE and ROLLUP.

· Use the Oracle GROUPING SETS extension to the GROUP BY clause to control which dimensions are included in the result set.

· Store hierarchical data and display data results in hierarchy order (e.g. employees sorted by management chain) with the Oracle CONNECT BY clause

· Use the Oracle DECODE function and Oracle CASE expression to add IF / THEN / ELSE (conditional) logic to an SQL query.

· Use basic Oracle XML functions to search and extract XML data from the Oracle database



Course Duration: 4 days

...''

Phone:1-888-896-7852

School Address:

Toronto Star Building
1 Yonge Street, Suite 1801
Downtown Toronto
Ontario, Canada - M5E 1W7

Jobs & Resumes: Toronto
Houses & Roommates: Toronto
Travel Agencies: Toronto

Search other schools for Oracle 10g Advanced SQL training resources.

Introduction to Ruby on Rails (RoR)
XML
Jakarta Struts
Java Development for Secure Systems
Java Persistence with Hibernate
Java Foundation Classes (Swing) Java 5.0
Java Servlets
JSP
JDBC
Oracle 10g Introduction to SQL
Oracle 10g PL/SQL Programming
Oracle Applications Using ADO.NET and C#
J2EE
Visual Basic for Applications (VBA)
Securing Java Web Applications
SQL Server 2005 Additional Topics
SQL Server 2005 Analysis Services (SSAS)
SQL Server 2005

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.