Exploring 11g Best Practices & New Features for Database Developers & DBAs
Oracle Database 11g brings many new features and enhancements to SQL and PL/SQL. These will help improve your applications and database performance, enhance applications functionality, provide better security for your applications and increase your productivity as a database developer and administrator while making database development processes simpler and faster.
This course will present best practices for implementing and using Oracle database 11g R1 and R2 new SQL and PL/SQL programming language features and enhancements which have significant impact on database application development and that can be used for improving programming functionality, application performance and usability.
Participants in this course will learn about new performance and storage related features, virtual columns, new SQL functions, new DML & DDL enhancements, locking enhancements, new trigger options, bulk binding enhancements, subprogram inlining, partitioning enhancements, new security features and miscellaneous SQL and PL/SQL new features.
This course includes real life examples and live demonstrations and is followed with various SQL and PL/SQL scripts to demonstrate the implementation of Oracle database 11g important new features, guidelines and best practices for database developers and administrators.