Oracle OCP: Oracle Certified Professional Call: 0207 392 9696 
 
Request Brochure
 
 
Name :
Email :
Phone :
Course :
Address :
Call Now: 0207 392 9696
 

QUICK TIME TABLE
 Weekday
StartsDay(s)Time
Aug 4 2009 Tue, Thurs18:30-21:30
Aug 24 2009 Mon, Wed14:00-17:00
Sep 22 2009 Tue, Thurs18:30-21:30
 Weekend
StartsDay(s)Time
Sep 5 2009 Saturday10:00-17:00
Oct 24 2009 Saturday10:00-17:00

ORACLE 10G SPECIALS
   Oracle 10g &
   Oracle Financial 11i - £1990
   You save £990       
   Oracle 10g &
   Oracle Apps DBA - £2550
   You save £450      
   Oracle 10g &
   MCTS SQL 2005 - £1850
   You save £500       

 
 
Raves reviews responses
 
very good - Sapna

View All Reviews

Oracle 10g Database
OCP Certification

 
  • Oracle : £1590
  • Hands On Tutor Led for 8 Weeks
  • Free Books
  • Max 10 Per Class (check our facilities)
  • VAT, Mock Exam Inc.
  • or Call 0207 392 9696
 

Oracle OCP: Oracle Certified Professional

Course Explanation

Oracle rules the database technology, so what better choice than to have the best under your sway. To be a certified OCP, or Oracle certified professional, you also need to master the database administrator’s course, called DBA. Once there getting to the oracle 10g category is literally a cakewalk. With hands-on training in Oracle 10g and an advance grid technology, you can be sure to be equipped for the OCP exam.

So what does this course have to offer? Quite simply, a lot! You can choose from first learning the Oracle 10g Database Structure, to practising complex SQL statements, a database with SQL*Plus and iSQL*Plus, indexing organized tables, creating a job classes and lots more packed neatly in 16 course sessions of 3 hours each.

Certification Exam Code
1Z0-007 Introduction to Oracle SQL
1Z0-042 Oracle Database 10g: Administration I
1Z0-043 Oracle Database 10g: Administration II

Course Contents (16 sessions of 3hrs each)

Day 1
3 hrs

• SQL Statements
• SELECT statement
• Differentiate between SQL statements and iSQL*Plus commands

• Restricting and Sorting Data
• Limit the rows retrieved by a query
• Sort the rows retrieved by a query

• Single-Row Functions
• Functions available in SQL
• Use character, number, conversion functions, and date functions in SELECT statements

• Data from Multiple Tables
• Write SELECT statements to access data from more than one table using equality and nonequality joins
• View data that generally does not meet a join condition by using outer joins
• Join a table to itself using a self-join

• Aggregating Data using Group Functions
• Group functions
• GROUP BY clause
• Include or exclude grouped rows by using the HAVING clause, Subqueries
• Describe the types of problems that subqueries can solve
• Define subqueries
• List the types of subqueries
• Write single-row and multiple-row subqueries

Day 2
3 hrs

• Producing Readable Output with iSQL*Plus
• Produce queries that require a substitution variable
• Produce more readable output
• Create and execute script files

• Manipulating Data
• Describe each DML statement
• Insert rows into a table
• Update, Delete, Merge rows in a table

• Creating and Managing Tables
• Database objects, Create tables
• Datatypes that can be used when specifying column definition
• Alter table definitions
• Drop, rename and truncate tables

• Constraints
• Introduction to constraints
• Create and maintain constraints

• Views
• Introduction to view
• Create, alter the definition, and drop a view
• Retrieve data through a view
• Insert, update and delete data through a view

• Database Objects
• Create, maintain and use sequences
• Create and maintain indexes
• Create private and public synonyms

Day 3
3 hrs

• Oracle 10g Database Structure
• Introduction to Oracle 10g DBA course.
• Discuss the contents and topics,
• Identify the student knowledge levels.
• Introduction to databases,
• explain the database terminology.
• Introduction to SQL Language,
• explain simple SQL statements
• practice using iSQL*Plus.

• Explain and practice complex SQL statements.
• (Table joins, sub query, outer joins, set operations, etc.
• Explore the Oracle 10g database architecture,
• Explain core DBA tasks and tools,
• Plan an Oracle installation,
• Install software with the Oracle Universal Installer (OUI),
• Create a database with the Database Configuration Assistant (DBCA).

Day 4
3 hrs

• Start and stop the Oracle database and components,
• Access a database with SQL*Plus and iSQL*Plus,
• explain the use of SPFILE and PFILE,
• Modify database initialization parameters,
• Understand the stages of database startup,
• Use DDL statements to create, alter, drop tables
• practice DML statements (insert, update, delete),
• describe table constraints, views, sequences, synonyms and indexes.
• Describe table data storage (in blocks),
• Define the purpose of tablespaces and data files,
• Understand and utilize Oracle Managed Files (OMF),
• Create and manage tablespaces,
• Obtain tablespace information,
• understand different types of tablespaces and create them.
• Understand temporary tablespaces,
• undo tablespace,
• default tablesspaces in the database.

Day 5
3 hrs

• Create and manage database user accounts,
• Authenticate users in 3 different methods (password, externally, globally),
• Grant and revoke privileges,
• Create and manage roles,
• Create and manage profiles,
• Implement standard password security features,
• Control resource usage by users using profiles.

Day 6
3 hrs

• Define schema objects and data types,
• Create and modify tables,
• Define constraints,
• Use the Data Dictionary to find object information.
• Explain DML and undo data generation,
• Configure undo retention,
• Guarantee undo retention,
• Describe table locks and different types of locks.
• Understand the data dictionary tables related to the locks.
• Discuss the general concurrency issues and explain the deadlocks.

Day 7
3 hrs

• Enable standard database auditing,
• Specify audit options, Review audit information,
• Understand Oracle’s Network Architecture,
• Create additional listeners,
• Create Net Service aliases,
• Configure connect-time failover,
• Identify when to use shared versus dedicated servers.
• Set up shared server and monitor shared connections to the database.
• Manage the Automatic Workload Repository (AWR),
• Use the Automatic Database Diagnostic Monitor (ADDM).
• Describe advisory framework.

Day 8
3 hrs

• Identify the types of failure that may occur in an Oracle Database,
• Identify the importance of checkpoints,
• redo log files, and archived log files.
• Describe Flashback database,
• Recover from a dropped table,
• See versions of a row over time with Flashback Versions Query,
• View the transaction history of a row with Flashback Transaction Query
• Describe available ways for moving data,
• Create and use directory objects,
• Use SQL*Loader to load data from a non-Oracle database (or user files),
• Explain the general architecture of Data Pump,
• Use Data Pump Export and Import to move data between Oracle databases.

Day 9
3 hrs
• Describe available ways for moving data ,
• Create and use directory objects,
• Use SQL*Loader to load data from a non-Oracle database (or user files),
• Explain the general architecture of Data Pump,
• Use Data Pump Export and Import to move data between Oracle databases.
Day 10
3 hrs

• Database Architecture Review,
• Recovery Manager Features and Components,
• Using a Flash Recovery Area with RMAN, Configuring RMAN,
• Control File Autobackups,
• Retention Policies and Channel Allocation.
• Displaying the current RMAN configuration settings,
• Altering the backup retention policy for a database.
• RMAN Command Overview,
• Parallelization of Backup Sets,
• Compressed Backups, Image Copy,
• Whole Database and Incremental Backups,
• LIST and REPORT commands.

Day 11
3 hrs

• Recovery of Non-Critical Files,
• Creating New Temporary Tablespace Recreating Redo Log Files,
• Index Tablespaces, and Indexes,
• Read-Only Tablespace Recovery,
• Authentication Methods for Database Administrators,
• Loss of Password Authentication File,

Day 12
3 hrs

• Creating a new temporary tablespace,
• Altering the default temporary tablespace for a database.
• Describe Incomplete recovery,
• Server and User Managed Recovery commands,
• Recovering a Control File Autobackup,
• Creating a New Control File,
• Simplified,
• Point-in-time recovery using RMAN.

Day 13
3 hrs

• Describe Flashback Database Architecture,
• Configuring and Monitoring Flashback Database,
• Backing Up the Flash Recovery Area,
• Using V$FLASH_RECOVERY_AREA_USAGE,
• Flashback Database Considerations,
• Using the Flashback Database RMAN interface,
• Using Flashback Database EM Interface
• Managing and monitoring Flashback Database operations.
• How to deal with block corruptions.
• Block Corruption Symptoms: ORA-1578,
• DBVERIFY Utility and the ANALYZE command,
• Initialization parameter DB_BLOCK_CHECKING,
• Segment Metadata Dump and Verification,
• Flashback for Logical Corruption and using DBMS_REPAIR,
• Lock Media Recovery
• RMAN BMR Interface,
• dumping and Verifying Segment Metadata

Day 14
3 hrs

• Memory tuning, Oracle Memory Structures,
• Automatic Shared Memory Management,
• SGA Tuning Principles, Resizing SGA_TARGET,
• PGA Management Resources,
• Using the Memory Advisor,
• Identifying Tunable Components,
• Oracle Wait Events and System Statistics,
• Troubleshooting and Tuning Views,
• Direct Attach to SGA for Statistic Collection,
• Workload Repository,
• Advisory Framework
• ADDM Scenarios and Usage Tips,
• Using the SQL Tuning and SQL Access Advisor
• Monitor and manage Database Storage Structures,
• Space Management Overview,
• Oracle-Managed Files (OMF),
• Row Chaining and Migrating,
• Proactive Tablespace Monitoring,
• Monitoring table and index space usage

Day 15
3 hrs
• Discuss Table Types,
• Partitioned Tables,
• Index-Organized Tables (IOT),
• Managing index space with SQL,
• Configure optimal redo log file size,
• View “Automatic Tuning of Undo Retention”
• Discuss ASM General Architecture and Functionalities,
• Create, Manage an ASM Instance.
• Database Resource Manager Concepts and Configuration,
• Creating a New Resource Plan,
• Creating a Simple Plan,
• Administering and Monitoring Resource Manager,
• Resource Plan Directives,
• Creating Resource Consumer Groups.
Day 16
3 hrs
• Discuss Scheduler Concepts,
• Creating a Job Class and a Windows,
• Managing Jobs, Programs,
• Chains, Events,
• Schedules, priority,
• Viewing and Purging Job Logs,
• Creating a program and a schedule,
• Creating a job that uses a program and a schedule.
• Understand Globalization Support Features,
• Database Character Sets and National Character Sets,
• Specifying Language-Dependent Behavior,
• Determining the Default NLS Settings.
After Course Free Lab Access
Copyright © 2008 LSCE London (UK). All rights reserved.