This hands-on course provides the experienced Oracle developer with the advanced SQL skills necessary to design and code complex queries. Students will learn to provide OLAP function by incorporating analytic functions, and group by clause enhancements.
Oracle application developers
Oracle SQL Fundamentals or equivalent experience
Students will expand their knowledge of basic Oracle SQL and be able to design and code complex queries. Students will learn to incorporate many advanced techniques such as the data warehouse functions CUBE and ROLLUP, DECODE, ANSI-compliant inner and outer joins, CONNECT BY (hierarchical queries), SET operations, correlated subqueries and other advanced subquery techniques. Oracle features such as flashback query, external tables and MERGE will also be covered.
Recommended Follow-On Course
Copyright © 2013 Euler Solutions, Inc. Minneapolis, MN