Database Courses > Introduction to Oracle9i for Experienced SQL Users Training Course
Introduction to Oracle9i for Experienced SQL Users Course Outline
Course Description
This intensive course is intended for IT professionals who already have a through knowledge of SQL in another relational database environment, but who are now working in an Oracle environment, including Application Developers, System Analysts, Database Administrators and Technical Support Personnel. This course gives delegates an understanding of Oracle's relational and object relational database management systems through the powerful SQL language. The SQL commands, functions and operators supported by oracle as extensions to standard SQL are emphasised. Delegates learn to create and maintain database objects such as tables, indices, views, constraints and sequences. Delegates also learn to store and retrieve by using advanced techniques such as grouping sets, SET operators and hierarchical retrieval. Delegates also learn how to manipulate data. Finally, delegates learn to write SQL script files using iSQL*Plus tool and to generate report-like output.
Certification: For students studying towards OCP certification, this course provides the core knowledge for exam 1Z0-007 (Introduction to Oracle9i: SQL).
Course pre-requisites:
Delegates must have a thorough working knowledge of standard ANSI SQL or SQL in another relational database environment. Familiarity with relational database concepts is also required.
Topics covered on the 2 day Introduction to Oracle9i for Experienced SQL Users course
This is an instructor led training course taught in a classroom based environment.
Course Classification:
Technical Training Course
Course Fee = £775 (excl.VAT)
Scheduled course dates
| October 2008 |
November 2008 |
December 2008 |
| - | - | - |
If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.
|
