Colleges and Universities Offering Diploma in Oracle Database Management in Nigeria

Institutions Offering Diploma in Oracle Database Management

•  FlamyTech Computer School, Lagos  
  Course content
  Part I: Oracle Database 11g Administration
  (i) Architectural Overview of Oracle Database 11g (Oracle and SQL Concepts)
  
  (ii) Installing and Creating a Database
  
  (iii) Instance Management
  
  (iv) Oracle Networking
  
  (v) Oracle Storage (Storage Model and Tablespaces)
  
  (vi) Oracle Security (Database User Accounts, Privileges, Roles)
  
  Part II: SQL
  (i) DDL and Schema Objects
  
  (ii) DML and Concurrency
  
  (iii) Retrieving, Restricting, and Sorting Data Using SQL
  
  (iv) Single-row and Conversion Functions
  
  (v) Group Functions
  
  (vi) SQL Joins
  
  (vii) Subqueries and Set Operators
  
  Part III: Advanced Database Administration
  (i) Configuring the Database for Backup and Recovery
  
  (ii) Back Up with RMAN
  
  (iii) Restore and Recover with RMAN
  
  (iv) Advanced RMAN Facilities
  
  (v) User-Managed Backup, Restoration, and Recovery
  
  (vi) Flashback
  
  (vii) Automatic Storage Management
  
  (viii) The Resource Manager
  
  (ix) The Scheduler
  
  (x) Moving and Reorganizing Data
  
  (xi) The AWR and the Alert System
  
  (xii) Performance Tuning
  
  (xiii) Globalization
  
  (xiv) The Intelligent Infrastructure
  
  
  Entry requirements
  (i) Basic computer knowledge is required
  
  (ii) Basic understanding of technology concepts is fine
  
  (iii) A pure determination to learn about database and relational database management system (RDBMS) concepts
  
  Course duration: Six Months (4 Times per Week)
  

---

More Diploma Courses in Nigeria

---

View all courses in Nigeria

---