Oracle 9i SQL Performance and Tuning

This course offers students a lecture/lab intensive environment on Oracle's Data Server Technology. The class covers the concepts of both performance tuning of SQL, Objects and Advanced PL/SQL in an Oracle database and the use of SQL. The student will learn how to write simple to complex queries along with being able to modify database objects through SQL. Advanced technique such as ROLLUP, CUBE, set operators and creation of user-defined datatypes are discussed.
Students should have a working knowledge of computers.
5 Days/Lecture & Lab
This course is designed for Application Developers, Database Administrators, Systems Analysts and Technical Support Professionals
Tuning Sql Code::Advanced Sql Coding::Tuning Sql With Oracle Tools::Using oracle's plan table::Data definition language::Tuning with enterprise manager

Related Scheduled Courses