In this course, you gain a solid foundation to maximize Oracle 11gand develop robust databases for your organization. You learn to establish a data model and a storage framework, retrieve and manipulate data efficiently using SQL Developer, create and manage database tables, sequences and synonyms, and write structured PL/SQL code to develop stored procedures, triggers and packages.

 

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.