Diplomas
Certificates
Courses

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   
Call our Sales
   Clients Testimonials
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
   OCA: Oracle Database 11g Administrator Certified Associate

Admission

Technical Consultant Functional Implementer Database Administrators. Support Engineer. Developer. Technical Administrator. Database Designers.


OCA: Oracle Database 11g Administrator Certified Associate
     Professional Group
  Oracle Database 11g: Administration Workshop I   42
  Oracle Database 11g: SQL Fundamentals I   24
Exam # Duration Language Level Type Classroom Code Fees
-- 66 English Professional Course Classroom Cs396 4900 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.



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.


Topics :




Recommended Knowledge :

Familiarity with data processing concepts and techniques

Recommended Course(s) :
Windows Vista Core
 Database Concepts

 


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 ORACLE11g: Database Administrator Certified Professional (OCP).

Category :
DataBase


The Instructor:
Copyright © 2008-2012 - EnterCaps for Design and Development - All rights reserved.