Database

In the Oracle Database: SQL Tuning for Developers course, you learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code. Learn the different ways in which data can be accessed efficiently. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.

In this application development-centric course, students learn about Oracle SQL statement tuning and how to write well-tuned SQL statements appropriate for the Oracle database.

This Oracle Application Express Workshop I Ed 2 training teaches you how to quickly and efficiently develop database-centric web applications using Oracle Application Express. Explore implementing security in your applications, managing application navigation, basic validation and debugging techniques used while developing an application in Oracle Application Express.

This Oracle Application Express Workshop II Ed 2 training will build on the knowledge learned in the 5-day Oracle Application Express Workshop I course. You'll examine topics that including learning how to use collections, add dynamic actions, create and customize plug-ins, and create and consume a RESTful Web Service.

In the Oracle Application Express: Administration Ed 2 course, students will learn the different ways in which Oracle Application Express can be installed and will perform a full development environment installation on a multitenant architecture of Oracle Database 12c. They will identify the three options of configuring a web server for Oracle Application Express and will install and configure the Oracle REST Data Services.

This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam.

This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

In this Oracle Database 11G Advanced PL/SQL training, expert Oracle University instructors will help you explore the advanced features of PL/SQL to design and tune PL/SQL. You'll learn how it interfaces with the database and other applications in the most efficient manner.

This Oracle Database 11g: New Features for Administrators DBA Release 2 training explores new change management features and other key enhancements in Oracle Database 11g Release 1 and Release 2. Participating in hands-on practice sessions help reinforce your understanding of the new capabilities.

This Oracle Database 11g Performance Tuning training starts with an unknown database that requires tuning. You'llthen learn the steps a DBA performs to identify problem areas, diagnose common problems and fix them.