ORACLE 11g Database Architecture and Management - SCILS Management Center

ORACLE 11g Database Architecture and Management

ORACLE 11g Database Architecture and Management
Share
Share

ORACLE 11g Database Architecture and Management

Oracle Certification Program is a professional certification program offered by the Oracle Corporation. There are three levels for to attain OCP offered by SCILS Management Centre:

  • Oracle Structured Query Language (SQL)

In Oracle, SQL is divided into two basic groups: Oracle database 11g 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.

Pre – requisite:

No knowledge of IT is required to attend this program

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

 Take home Kit

By enrolling for this Course, with SCILS Management Centre, you’ll be able to learn in our well-equipped classrooms and from our well qualified and Certified Instructors. You’ll develop deeper knowledge of the fundamentals of Oracle Database 11g, as well as skills that you can apply directly to your daily job to improve querying and reporting within your organization.

  • Oracle Certified Associate (OCA)

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

Training Methodology

At SCILS Management Centre all out trainings are 100% Practical. Plus you will have an opportunity to work on a real life project. All our Instructors are well certified and have vest experience in trainings and solution deployment.

Take Home Kit

At the end of the programme, each participant will be issued Certificate of Course Completion. In addition to this, he will acquire the skills and knowledge to:

  • Install Oracle 11g Software, Create Database, configured database, Control, Secure, managed and monitor Oracle 11g database.
  • Be suitable for employment in Banks, IT firms and other big organizations that need Database Management.
  • Have individual confidence and security in being a part of today’s IT world.
  • Be able to sit for and pass Administration Workshop I (OCA) exams.
  • At SCILS Management Centre our grantee exam success rate is 98%
  •  

    Oracle Certified Professional (OCP)

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

Training Methodology

At SCILS Management Centre all out trainings are 100% Practical. Plus you will have an opportunity to work on a real life project. All our Instructors are well certified and have vest experience in trainings and solution deployment.

Take Home Kit

At the end of the programme, a participant will be issued Certificate of Course Completion. In addition to this, the participant will acquire the skills and knowledge to:

  • Backup & Recover an oracle database.
  • Manage memory effectively, as well as how to perform some performance evaluation and tuning tasks
  • Be able to sit for and pass Oracle Certified Professional exams.
  • At SCILS Management Centre our grantee exam success rate is 98%

Your Name*

Your Email*

Phone Number*

Availability*

Message

Add Comment

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

Phone: +2347039028188 | +2348162625986 | +2348094001990
58, opebi road, salvation bus stop, opebi
Ikeja, Lagos State, Nigeria.