Loading Course Schedule...
PT3061
Summary
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.
Prerequisites
Students should have a working knowledge of computers.
Duration
5 Days/Lecture & Lab
Audience
This course is designed for Application Developers, Database Administrators, Systems Analysts and Technical Support Professionals
Topics
Tuning Sql Code::Advanced Sql Coding::Tuning Sql With Oracle Tools::Using oracle's plan table::Data definition language::Tuning with enterprise manager