Introduction to Oracle9i for Experienced SQL Users Course
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
Course Classification:
Technical Training Course
This is an instructor led training course taught in a classroom based environment.
Course Fee = £775 (excl.VAT)
Scheduled course dates
| September 2010 | October 2010 | November 2010 | December 2010 | January 2011 |
| - | - | - | - | - |
View full schedule of Oracle 9i Languages courses
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Database Training and bespoke Database courses