HomeOracle Database

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

1. Retrieving Data Using the SQL SELECT Statement
2. Restricting and Sorting Data
3. Using Single-Row Functions to Customize Output
4. Using Conversion Functions and Conditional Expressions
5. Reporting Aggregated Data Using the Group Functions
6. Displaying Data from Multiple Tables
7. Using Subqueries to Solve Queries
8. Using the Set Operators
9. Manipulating Data
10. Using DDL Statements to Create and Manage Tables
11. Creating Other Schema Objects

Course Content For Oracle OCA

1. Exploring the Oracle Database Architecture
2. Preparing the Database Environment
3. Creating an Oracle Database
4. Managing the Oracle Instance
5. Configuring the Oracle Network Environment
6. Managing Database Storage Structures
7. Administering User Security
8. Managing Data and Concurrency
9. Managing Undo Data
10. Implementing Oracle Database Security
11. Database Maintenance
12. Performance Management
13. Intelligent Infrastructure Enhancements
14. Backup and Recovery Concepts
15. Performing Database Backups
16. Performing Database Recovery
17. Moving Data

Course Content For Oracle OCP

1. Database Architecture and ASM
2. Configuring for Recoverability
3. Using the RMAN Recovery Catalog
4. Configuring Backup Specifications
5. Using RMAN to Create Backups
6. Performing User-Managed Backup and Recovery
7. Using RMAN to Perform Recovery
8. Using RMAN to Duplicate a Database
9. Performing Tablespace Point-in-Time Recovery
10. Monitoring and Tuning RMAN
11. Using Flashback Technology
12. Additional Flashback Operations
13. Diagnosing the Database
14. Managing Memory
15. Managing Database Performance
16. Space Management
17. Managing Resources
18. Automating Tasks with the Scheduler
19. Administering the Scheduler

One Hundred and Forty Thousand Naira only (N140,000.00)

4 Months (Three times a week)