Oracle Database Architecture and Management (SQL | OCA | OCP) - SCILS Management Center

Oracle Database Architecture and Management (SQL | OCA | OCP)

Oracle Database Architecture and Management (SQL | OCA | OCP)
ICT

Oracle Database Architecture and Management (SQL | OCA | OCP)

Share
Share

ORACLE DATABASE ARCHITECTURE AND MANAGEMENT

Oracle Certification Program is a professional certification program offered by the Oracle Corporation. This course offers a comprehensive introduction to Oracle Database 12c. You learn how to design, build and manage robust cloud based database applications with Oracle database tools. Oracle 12c is a large, complex system. This course provides an overview of the power and flexibility of Oracle databases.
We offer the three levels of the oracle database certifications.

  • Oracle SQL Fundamentals.
  • Oracle Database Administration (Oracle Certified Associate OCA).
  • Oracle Database Administration (Oracle Certified Professional OCP).

In Oracle, SQL is divided into two basic groups: Oracle database SQL Fundamentals 1 and Fundamentals 11 which talks about data definition language (DDL) and data manipulation language (DML).   DDL is used to define objects within the database just as creating tables or indexes.  DML is used to insert, update and delete data in the database.  Finally, there is data retrieval, which is the SELECT statement.

For Whom

Administrative Officers/Managers, Accountants, Marketing/Sales Offices, Students, Job Seekers or any one that is required to work with a Database.

Course Outline Fundamentals 1

  • Develop essential SQL skills that enable developers to write queries against single and multiple tables.
  • Manipulate data in tables.
  • Create database objects.
  • Use single row functions to customize output.
  • Work with group functions to report aggregated data.
  • Use conversion functions and conditional expressions.
  • Manipulate queries to return required data.
  • Perform calculations on data.
  • Administer database objects.

Course outline Fundamentals II

  • Control privileges at the object and system level.
  • Use group operations to create reports.
  • Manage schema objects.
  • Search data using advanced subqueries.
  • Retrieve hierarchical data.
  • Manipulate data with subqueries.
  • Understand regular expression support

Fee:

40,000 Naira

This oracle certification course is designed to identify, develop and certify individuals with requisite IT skills and knowledge for Database Management. It provides people of all ages with the means to increase their IT skills, prove their expertise and advance their professional careers.

For Whom

Administrative Officers/Managers, Accountants, Marketing/Sales Offices, Students, Job Seekers or any one that is required to work with a Database.

Pre – requisite:

At least should have a sound knowledge of SQL

Course outline

  • Install Oracle Grid Infrastructure
  • Install and configure Oracle Database 11g
  • Configure Oracle Net services
  • Monitor and administer undo data
  • Manage the database storage structures
  • Create and administer user accounts
  • Perform basic backup and recovery of a database
  • Manage data concurrency
  • Monitor performance
  • Describe Oracle Database Architecture
  • Data movement

Fee

: 45,000 Naira

The Oracle Certified Professional (OCP) certification course prepares IT experts for high-level jobs as database administrators, system architects and project managers. The Oracle Certified Professional (OCP) Certification course builds on the skills developed during Oracle Certified Associate (OCA)  training course. This course takes the database administrator beyond the basic tasks covered in the first workshop. You’ll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery and using OEM.

Oracle Certified Professional(OCP) certification requires validation of hands-on training and real-world experience, employers can trust that certified candidates meet the minimum standards for challenging database jobs.

For Whom

Administrative Officers/Managers, Accountants, Marketing/Sales Offices, Students, Job Seekers or any one that is required to work with Database.

Pre–requisite

Participants have to have undergone the Oracle Certified Associate (OCA) Training Course.

Course Outline

  • Getting Started with Oracle Recovery Manager (RMAN)
  • Using RMAN to Back Up Oracle Databases
  • Diagnosing Oracle Database Issues
  • Recovering from Critical and Noncritical Losses
  • Complete and Incomplete Database Recovery
  • Using Flashback Database
  • Recovering from User Errors
  • Detecting and Recovering from Database Corruption
  • Tools for Administering Oracle Database 11g
  • Monitoring and Managing Storage
  • Monitoring and Managing Memory
  • Managing Oracle Database Resources
  • Automating Administrative Task

Fee:

55,000 Naira

Add Comment

Your email address will not be published. Required fields are marked *

Phone: +2348162625986 | +2348094001990 | +2347039028188
2nd floor Rikaz plaza, 58, opebi road, by salvation b/s, ikeja Lagos
Ikeja, Lagos State, Nigeria.