If you’re serious about a career in IT, getting yourself certified as an Oracle Professional could mark the turning point in your career. With just over 440,000 Oracle Certified Professionals worldwide, your certification can put you in the league of the crème de la crème of IT professionals.
The London School of Computer Education is perfectly qualified to help you become an OCP (Oracle Certified Professional). An Oracle-certified institute, the course is handled by certified instructors who have a legacy of producing market-savvy professionals. The course, delivered through a combination of in-depth presentations, hands-on coursework, lectures, demos and preparatory tests, ensure that you learn everything you need to succeed at the exam.
Not only does our Oracle 11g program promise to quicken your professional progress, it also enhances your efficiency and boosts your credibility in the industry. Improving upon Oracle’s ability to deliver the advantages of grid computing through better automation and self-management features, our training in 11g OCP exposes you to two specific tracks— Database Administration and Application Development.
Course Contents (16 sessions of 3hrs each)
Oracle Database 11g: Administration I Exam Number: 1Z0-052
• SQL Statements • SELECT statement • Differentiate between SQL statements and iSQL*Plus commands
• Oracle Database Architecture • Oracle Memory, Process and Storage Structures
• Oracle Database Environment • Oracle Database Administration • Oracle Database Planning and installation • Oracle Universal Installer (OUI), Oracle Database Installation
• Oracle Database and Instance • Create Oracle Database • Database Configuration Assistant (DBCA) • Manage Oracle Instance • Initialization parameters • Stages of database startup and shutdown • Alert log and trace files • Data dictionary and dynamic performance views
• Oracle Network Environment • Configure and Manage the Oracle Network • Oracle Shared Server architecture
• Oracle Database Storage Structures • Manage Database Structures, Tablespace and datafiles • Create and manage tablespaces • Space management in tablespaces
• Administering User Security in Oracle Database • Create and manage database user accounts • Grant and revoke privileges • Create and manage roles • Create and manage profiles • Managing Schema Objects, Create and Modify tables • Manage Constraints, Create indexes and use temporary tables
• Undo Data • Introduction to Undo data • Transactions and undo data • Managing undo
• Data and Concurrency • Manage data using DML • Identify and administer PL/SQL objects • Monitor and resolve locking conflicts
• Oracle Database Security • Manage Oracle Database security • Principle of Least Privilege • Standard Database Auditing
• Oracle Database Maintenance and Performance Management • Automatic Workload Repository (AWR), optimizer statistics, • Use advisory framework, Alerts and Thresholds • Automatic Memory Management and Memory Advisors • Troubleshoot invalid and unusable objects
• Intelligent Infrastructure Enhancements • Enterprise Manager Support Workbench • Managing Patches
• Oracle Database Backup and Recovery • Configure and manage Oracle Database Backup and Recovery • Identify the types of failure that can occur in an Oracle database • Describe ways to tune instance recovery • Identify the importance of checkpoints, redo log files, and archived log files
• Flash recovery area • Configure ARCHIVELOG mode • Step by step Database Backups • Create consistent database backups • Back up your database without shutting it down • Create incremental backups • Automate database backups • Manage backups, view backup reports and monitor the flash recovery area • Performing Database Recovery • Oracle Data Recovery Advisor • Oracle Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)
• Moving Data • use methods to move data (Directory objects, SQL*Loader, External Tables) • Architecture of Oracle Data Pump • Data Pump Export and Import to move data between Oracle databases
Oracle Database 11g: Administration II Exam Number: 1Z1-053
• Oracle Database Architecture and ASM • Automatic Storage Management (ASM) • Set up initialization parameter files for ASM and database instances • Start up and shut down ASM instances • Administer ASM disk groups
• Configuring Oracle Database for Recoverability • Configure multiple archive log file destinations to increase availability • Define, apply and use a retention policy • Configure the Flash Recovery Area, Use Flash Recovery Area
• RMAN Recovery Catalog • Identify situations that require RMAN recovery catalog • Create and configure a recovery catalog • Synchronize the recovery catalog • Create and Use RMAN stored scripts • Back up the recovery catalog • Create virtual private catalog
• Configuring Backup Specifications • Configure backup settings • Allocate channels to use in backing up, Configure backup optimization
• Using RMAN to Create Backups • Create image file backups, whole database backup • Enable fast incremental backup • Create duplex backup and back up backup sets • Create an archival backup for long-term retention • Create a multisection, compressed and encrypted backup • Report on and maintain backups
• User-Managed Oracle Database Backup and Recovery • Recover from a lost TEMP file, lost redo log group • Recover from the loss of password file • Perform user-managed complete database recovery • Perform user-managed incomplete database recovery • Perform user-managed and server managed backups • Identify the need of backup mode • Back up and recover a control file
• RMAN to Perform Recovery • Perform complete recovery from a critical or noncritical data file loss using RMAN • Perform incomplete recovery using RMAN • Recover using incrementally updated backups • Switch to image copies for fast recovery • Restore a database onto a new host • Recover using a backup control file • Perform Disaster recovery • RMAN to Duplicate a Database • Creating a duplicate database • Using a duplicate database
• Performing Tablespace Point-in-Time Recovery • Identify the situations that require TSPITR • Perform automated TSPITR
• Monitoring and Tuning RMAN • Monitoring RMAN sessions and jobs • Tuning RMAN • Configure RMAN for Asynchronous I/O
• Flashback Technology • Restore dropped tables from the recycle bin • Perform Flashback Query • Flashback Transaction • Flashback Operations • Flashback Table operations • Configure, Monitor Flashback Database • Perform Flashback Database operations • Set up and use a Flashback Data Archive
• Diagnosing the Database • Set up Automatic Diagnostic Repository • Using Support Workbench • Perform Block Media Recovery
• Managing Memory • Automatic Memory Management • Manually configure SGA parameters • Configure automatic PGA memory management
• Managing Database Performance • SQL Tuning Advisor • SQL Access Advisor to tune a workload • Understand Database Replay
• Automating Tasks with the Scheduler • Create a job, program, and schedule • Use a time-based or event-based schedule for executing Scheduler jobs • Create lightweight jobs • Use job chains to perform a series of related tasks • Administering the Scheduler • Create Windows and Job Classes • Use advanced Scheduler concepts to prioritize jobs
• Globalization • Customize language-dependent behavior for the database and individual sessions • Working with database and NLS character sets
