Oracle Training
Welcome to ITAspire training! We prepare candidates for Oracle certifications OCA and OCP by giving them ample time for doing practicals on each topic of the syllabus.
Here you will find information on all the courses we offer, both internally and externally, as well as schedules, resources and policies, and the latest announcements so you always know what’s on offer. You can request to register for any course through our online form, and of course, don’t hesitate to contact someone on our training team should you have any questions.
Courses
We at ITAspire value your career development. Make use of this excellent opportunity to experience the extensive labs under the guidance of a professional and certify as an OCP in DBA, Forms, PLSQL, or JEE streams.
SQL
Oracle 11g SQL Fundamentals
Topics:
- Intro to Oracle Enterprise Linux 5 and Oracle Enterprise Edition
- Intro to SQL Developer and Oracle Express Edition
- Retrieving Data Using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single-Row Functions to Customize Output
- Using Conversion Functions and Conditional Expressions
- Reporting Aggregated Data Using the Group Functions
- Displaying Data from Multiple Tables
- Using Subqueries to Solve Queries
- Using the Set Operators
- Manipulating Data
- Using DDL Statements to Create and Manage Tables
Resource provided: Oracle 11g Complete Reference by Kevin Loney
PL SQL
Oracle 11g PLSQL
Topics:
- Overview of PL/SQL Programs
- Creating Procedures
- Creating Functions
- Managing Subprograms
- Creating Packages
- Package Concepts
- Oracle Supplied Packages
- Manipulating Large Objects
- Creating Database Triggers
- Trigger Concepts
- Managing Dependencies
DBA I
Oracle11g Database Administration Part I
Topics:
- Exploring the Oracle Database Architecture
- Preparing the Database Environment
- Creating an Oracle Database
- Managing the Oracle Instance
- Configuring the Oracle Network Environment
- Managing Database Storage Structures
- Administering User Security
- Managing Data and Concurrency
- Managing Undo Data
- Implementing Oracle Database Security
- Database maintenance
- Performance Management
- intelligent Infrastructure Enhancements
- Backup and Recovery
- Performing Database Backups
- Performing Database Recovery
- Moving Data
Resource provided: Oracle 11g Complete Reference by Kevin Loney
DBA II
Oracle11g Database Administration Part II
Topics:
- Database Architecture and ASM
- Configuring for Recoverability
- Using the RMAN Recovery Catalog
- Configuring Backup Specifications
- Using RMAN to Create Backups
- Performing User-Managed Backup and Recovery
- Using RMAN to Perform Recovery
- Using RMAN to Duplicate a Database
- Performing Tablespace Point-in-Time Recovery
- Monitoring and Tuning RMAN
- Using Flashback Technology
- Additional Flashback Operations
- Diagnosing the Database
- Managing Memory
- Managing Database Performance
- Space Management
- Managing Resources
- Automating Tasks with the Scheduler
- Administering the Scheduler
Resource provided: Oracle 11g Complete Reference by Kevin Loney
RAC
Oracle 10g Real Application Cluster
Topics:
- Real Application Clusters Database Installation
- RAC Database Administration
- Managing Backup and Recovery for RAC
- RAC DB Monitoring and Tuning
- Services
- High Availability Connections
- Design for High Availability
FORMS
Oracle 10g Forms
Topics:
- Introduction to Oracle Forms Developer and Oracle Forms Services
- Running a Forms Developer Application
- Creating LOVs and Editors
- Creating Additional Input Items
- Creating Noninput Items
- Creating Windows and Content Canvases
- Working with Other Canvas Types
- Introduction to Triggers
- Working in the Forms Developer Environment
- Creating a Basic Form Module
- Working with Data Blocks and Frames
- Working with Text Items
- Producing Triggers
- Debugging Triggers
- Adding Functionality to Items
- Run Time Messages and Alerts
- Query Triggers
- Validation
- Navigation
- Transaction Processing
- Writing Flexible Code
- Sharing Objects and Code
- Introducing Multiple Form Applications
- Creating a Menu Module
- Managing Menu Modules
- Programming Function Keys
- Building Multiple Form Applications
- Defining Data Sources
- Working with Record Groups
- Using Database Objects in Forms Applications.
Oracle Apex
Oracle Apex
Topics:
- Introduction to Oracle Apex
- Product Overview
- SQL Workshop
- Utilities
- Application Builder
- Creating Pages
- Regions and Items
- Page Processing
- Shared Components
- Themes and Templates
- Other Page and Region Types
- Utilities and Reporting
- Advanced Development Techniques
- Administration and Deploying An Application
