Loading Course Schedule...
PT7523
Training Summary
This course covers some of the most advanced ways and means of accessing data in an Oracle database. The topics provide skills for working with a multiple tables (or alternatives to tables) in a query, using aggregation and analytic techniques to work with hierarchical data and compute advanced results.The methods available from Oracle for alternative transaction structure and control are covered. Oracle's Flashback technology allows developers to review data as it existed in the past. The numerous Oracle features for utilizing Flashback to review and potentially restore data as it previously existed are all described.
Prerequisites
-Skill with GUI interfaces-Data processing background-A thorough understanding of SQL is required to succeed in this class. Persons attending without this will experience difficulty.
Duration
2-3 Days/Lecture & Lab
Audience
-Experienced Oracle SQL developers and DBAs-Experienced Oracle developers looking to fulfill advanced data retrieval requirements
Course Topics
- Oracle Query Review
- The Petsaver database
- Advanced Datatypes
- Flashback Techniques
- SQL92 JOINs
- Multi-table Operations
- Enhancements to SQL
- Advanced PL/SQL
- Advanced Data Aggregation
- Understanding Concurrency and Consistency
- Day three topics
- Analytic Functions
- Hierarchical Queries
- Regular Expressions in Queries
- Table Alternatives
- ETL Support