Developing efficient, secure, optimal performance database applications is essential to the success of organizational information systems. Oracle Database 10g provides a wealth of features for developing robust, high-performance databases, allowing developers to extend and enhance application capabilities, and build and deploy distributed applications with considerable flexibility.
In this comprehensive hands-on course, you gain the knowledge and skills to leverage the Oracle Database 10g server. You learn to retrieve and manipulate data efficiently using powerful SQL features; create and manage database tables, views and sequences; maintain data integrity and enforce security with privileges and roles; and enhance performance through indexes and PL/SQL optimization.
In this hands-on course, you gain the practical knowledge to develop PL/SQL programs to access Oracle databases. You learn to manage data retrieval for front-end applications, design modular applications using packages, invoke native dynamic SQL to develop high-level abstract code, and bulk bind collections to increase the speed of data movement operations.
In this hands-on course, you gain the skills to create powerful and secure Oracle database applications, and tune them for optimal performance. Through a continuous case study, you learn to maintain and secure the database with advanced application techniques, load data into Oracle databases using SQL*Loader and improve query performance using the Oracle-provided toolset.
