Anyone who needs to use and understand iSQL*Plus and Oracle9i SQL*Plus to an advanced level, to retrieve data from and to update an Oracle database. The more advanced topics are covered in this course for the; Introduction to Oracle9i: SQL Oracle Certified Professional examination (IZ0-007)
Course topics:13 topics
- Oracle9i Datatypes and Functions
- Advanced Single Row Functions
- Advanced Group Functions
- Ansi Standard Table Joins
- Inline Views
- Top-'N' Analysis
- Inserting Rows into Multiple Tables
- Merging Data into Tables
- External Tables
- CASE Expressions
- Table Locking
- Creation of User, Profiles and Roles
Delegates should have attended the Oracle SQL*Plus course or have a similar level of experience. Before taking any exam, ensure you have the recommended experience.
Dates & Locations
Click on a course date to make a booking enquiry, or find out about available discounts.
Would you like this course to be delivered at your location? Make an Onsite Enquiry or call Sales on 408-759-5074.