Oracle Database

Oracle Database IT courses

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications.

With more than 420,000 customers and deployments in more than 175 countries, Oracle offers a comprehensive and fully integrated stack of cloud applications, platform services, and engineered systems. Learn about oracle by clicking on the register link.

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

3 months

Register Now

From CVIT Nigeria