Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Oracle 11g Certified Professional Exam Prep II
Rating: 4.5 out of 5(307 ratings)
1,730 students

Oracle 11g Certified Professional Exam Prep II

Part 2 of a 3 part series. A clear, concise and expert guide to achieving certification for Oracle Database.
Created byDave Haas
Last updated 11/2015
English

What you'll learn

  • Complete the Oracle 11g Certified Professional Exam
  • Understand and be able to perform backups and recoveries

Course content

7 sections69 lectures6h 25m total length
  • Introduction4:51
  • Failure types6:54
  • Failure types demo part one5:14

    Explore failure types in Oracle databases with hands-on demos of simple statement failure, unique constraint violations, and deadlocks, including locks, transactions, and basic admin responses.

  • Failure types demo part two4:40
  • Failure types demo part three4:19

    Demonstrates media failure concepts by taking a disk offline and showing how the data file and dictionary responses affect reads, guiding backup recovery to reassemble the database.

  • Failure types demo part four5:43

    Watch an Oracle instance fail and recover, as crash recovery applies redo, undoes inflight transactions, and uses the alert log to verify the recovery process.

  • The log stream10:01
  • Instance recovery9:34

    Understand how instance recovery automatically replays log data after a clean shutdown, guided by checkpoint change numbers, log switches, and the roll forward and rollback phases.

  • Archive logging6:00

    Explore archive logging, which copies log files before overwrites to preserve the log stream between backups and enables restoring files by replaying relevant log entries.

  • Archive logging setup14:49

Requirements

  • This class runs on VMWare and makes use of Windows Server as the OS for installing and working with the database. We use publicly available software so you can follow along on your own systems
  • This class assumes that you have a basic understanding of Oracle Database but wish to strengthen your skills. In this class we cover more advanced database operations like backup/recovery and performance tuning

Description

This course series provides the student with all the skills needed to pass Oracle Certified Professional 11g DBA Exam. Join over 50,000 I.T. professionals who are certified against the world's most popular relational database platform. Use the knowledge and skills you gain from this course to advance your career in the I.T. field.

The process of becoming certified broadens your understanding of the database and gives you the skills and understanding required to manage critical systems for some of the largest companies in the world. Certification helps you become a better specialist and hones your skills to the highest levels.

Who this course is for:

  • This course is meant for people interested in gaining a deeper understanding of Oracle Database in order to achieve certification