Oracle 11g New and Advanced SQL Features For Developers
Duration: 3 Days
This course presents some of the advanced features and capabilities of the Oracle 11g database. The content is geared towards senior, experienced SQL developers and database administrators who wish to make the most of the latest, most powerful elements of Oracle 11g.
Oracle?s powerful and multi-faceted Flashback technology which provides developer self-service recovery from erroneous commits is described along with alternatives for backing out bogus data changes. The potent elements of the latest SQL enhancements are covered along with extensive coverage of the SQL92 join syntax. Oracle?s recent extensions to it?s hierarchical SQL processing syntax are presented. Options and uses for new and complex data types and support for persistent object storage is offered. The many types of indexing made available in recent Oracle releases are compared. Alternative table organization methods are reviewed.
Throughout the course there is comprehensive coverage of Oracle?s data dictionary to review and monitor the usage of features.
Topics Covered In This Course
Oracle 11g concepts
The PetSaver database
Advanced data types
Working with objects
Working with LOBs
SQL92 join syntax
Advanced multi-table SELECT statements
Advanced hierarchical queries
Enhancements to SQL
Alternative index types
Who Should Take This Course
This course is appropriate for experienced Oracle SQL developers and database administrators.
Skill with GUI interfaces, and 12 months of experience writing SQL
Note: Attendees without a strong SQL background will probably not have a successful class experience.
Lecture with frequent hands on labs.
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at firstname.lastname@example.org