Introduction to Oracle9i for Experienced SQL Users Course

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).

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