MISSION

supervised and delivers only the official training programs for more than 3000 Courses and 480 Certificates, through 30 dedicated Learning Centers in Egypt, Kuwait, and UAE.....

Read more   

learning process

partner of the most world's technology leaders such as: Microsoft, Cisco, Math-Works, CompTia, WiMax, CWNP, Oracle, EC-Council, CIW, Symantec, ETS, Parametric, PearsonVUE, and more ...

Read more   

Warm welcome

WE aimed to improve and develop the human resources to be qualified for job Opportunities. By assure quality through the four basic elements of learning process (Official curriculum, Expert Teaching Staff, Hand-ON labs, Suitable Environment)...

Read more   

Quality assurance

our quality control and montoring system is added value, allow our customers watching the secure cams 24/7, performance and evaluate the training progress. ...

Read more   
Nada Youssef
Date: 2012-11-10
nice site... More...
Ahmed Ali
Date: 2012-11-10
I like the site design, it's sweet .. simple ... well organized. Hope to see next projects... More...
Maha el Said
Date: 2012-11-11
Very Helpful and very organized company...it opens its doors for people who are willing to learn and develop their designing abilities.... More...
mohamed saad
Date: 2012-11-28
it\'s very nice website go ahead..... More...

  • Category: Microsoft Office
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Entercaps Traning Center
    Date: 2012-11-11
                                    Play
  • Photoshop CS5-The Missing Manual
    Photoshop CS5-The Missing Manual
    DOWNLOAD
  • Photoshop CS6 For Dummies
    A dobe Photoshop is one of the most impo
    DOWNLOAD
  • Pro .NET Best Practices
    Pro .NET Best Practices
    DOWNLOAD
  • Hardening Cisco Routers
    Hardening Cisco Routers
    DOWNLOAD
   OCP: Oracle Database 11g Administrator Certified Professional

Admission

•Database Administrators

•Data Warehouse Administrator

•Technical Consultant

•Support Engineer


OCP: Oracle Database 11g Administrator Certified Professional
     Professional Group
  Oracle Database 11g: SQL Fundamentals I   24
  Oracle Database 11g: Administration Workshop I   42
  Oracle Database 11g: Administration Workshop II   42
Exam # Duration Language Level Type Classroom Code Fees
-- 108 English Professional Course Classroom Cs401 0 LE
Description :

This Package introduces students to the fundamentals of SQL using Oracle Database 11g database technology. In this package students learn the concepts of relational databases and the powerful SQL programming language. This package provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects also This package is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices. In this package, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios. Also, the students learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered. Topics are reinforced with hands-on practices. This package counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification.



Objectives :
  • Retrieve row and column data from tables with the SELECT statement
  • Create reports of sorted and restricted data
  • Employ SQL functions to generate and retrieve customized data
  • Display data from multiple tables using the ANSI SQL 99 JOIN syntax
  • Create reports of aggregated data
  • Use the SET operators to create subsets of data
  • Run data manipulation statements (DML) to update data in the Oracle Database 11g
  • Run data definition language (DDL) statements to create and manage schema objects
  • Identify the major structural components of the Oracle Database 11g
  • Describe Oracle Database Architecture.
  • Install and configure Oracle Database 11g.
  • Configure Oracle Net services.
  • Manage the database storage structures.
  • Create and administer user accounts.
  • Perform basic backup and recovery of a database.
  • Manage users and schemas.
  • Manage data and concurrency.
  • Monitor and administer undo data.
  • Backup and recover a database.
  • Monitor performance.
  • Use the database diagnostic monitor.
  • Back up and recover a database.
  • Configure Oracle Database for optimal recovery.
  • Administer ASM disk groups.
  • Use an RMAN backup to duplicate a database.
  • Automating Tasks with the Scheduler.


Topics :




Recommended Knowledge :

ORACLE11g: Database Administrator Certified Associate (OCA)

Recommended Course(s) :

OCA: Oracle Database 11g Administrator Certified Associate


Training Materials :

Oracle Press


Labs :

This package includes several labs to ensure you will gain the targeted skills and experience.


Credential :

This package is necessary to pass ORACLE Database 11g Administrator Certified Master (OCM).

Category :
DataBase


The Instructor: