An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information.
Pre-requisite:
Basic computer knowledge.
The courses that are covered in this program include:
Course Outline For Oracle SQL
- 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
- Creating Other Schema Objects
Course Content For Oracle OCA
- 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 Concepts
- Performing Database Backups
- Performing Database Recovery
- Moving Data
Course Content For Oracle OCP
- 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
One Hundred and Forty Thousand Naira only (N140,000.00)
4 Months (Three times a week)