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)

©2022 Softalicious Technologies. All Rights Reserved.