Course Locations
Anaheim, CA
Atlanta, GA
Austin, TX
Baltimore, MD
Boston, MA
Burbank, CA
Calgary, AB
Charleston, SC
Charlotte, NC
Chicago, IL
Columbia, MD
Columbus, OH
Dallas-Ft Worth, TX
Denver, CO
Detroit, MI
Edison, NJ
El Paso, TX
Framingham, MA
Houston, TX
Kansas City, MO
Lansing, MI
Los Angeles, CA
Minneapolis, MN
Ottawa, ON
Pittsburgh, PA
Toronto, ON
Virtual Classroom
Popular Courses
Project Management, IT Service Management, .NET, SAS, Rexx, ASP, JavaScript, HTML, XML, ColdFusion, Visual Basic, COBOL, Assembler, Java, J2EE, Java Wireless, WebSphere, WebLogic, UNIX, LINUX, AIX, Solaris, z/OS, OS/390, CICS, IMS, VSAM, Easytrieve, AS/400, Oracle, BusinessObjects, SQL, DB2, Crystal Reports
Browse Courses
 |
 |
 |
 |
 |
Course Schedule: | |
Oracle11g Advanced SQL Queries
Summary:
This course is intended to provide experienced Oracle developers with the advanced SQL skills needed to effectively design and code complex queries and applications required to solve enterprise business problems. Coding examples and workshops serve to reinforce the material presented in class.
Duration:
2 Days/Lecture & Lab
Audience:
This course is designed for programmers, analysts, database administrators, and users who require advanced SQL techniques to access data in an Oracle database.
Topics:
- Multi-table Operations
- Grouping Data
- Analytic Functions
- Hierarchic Queries
- Transaction Control
- Table Alternatives
- Multiset Operators
- Expression Filter Type
- Flashback Query
- ETL Support
Prerequisites:
Students should have taken the Oracle11g SQL & SQL*Plus. Students are expected to be experienced in the development of single table operations.
Last Update: May 24, 2013
