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.
4.7 (28 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
338 students enrolled
$19
$75
75% off
Take This Course
  • Lectures 69
  • Length 6.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2015 English

Course 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.

What are the 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

What am I going to get from this course?

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

What is the target audience?

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Backup/Recovery Concepts
Introduction
Preview
04:51
Failure types
Preview
06:54
Failure types demo part one
05:14
Failure types demo part two
04:40
Failure types demo part three
04:19
Failure types demo part four
05:43
The log stream
10:01
Instance recovery
09:34
Archive logging
06:00
Archive logging setup
14:49
Section 2: User Managed Backup
Overview
01:19
What to back up
06:26
Cold backups
07:07
Cold backup demo
06:16
Hot backups
12:11
Hot backup demo
15:04
Section 3: User Managed Recovery
Overview
07:25
Complete Recovery
03:28
Complete recovery demo part one
06:27
Complete recovery demo part two
03:30
Complete recovery demo part three
03:16
Attempted recovery in no-archivelog mode
04:19
Incomplete Recovery
07:07
Incomplete recovery demo part one
08:40
Incomplete recovery demo part two
04:25
Log Miner demo
09:57
Loss of Control File(s) demo
06:13
Recovering using backup controlfile demo part one
05:07
Recovering using backup controlfile demo part two
07:53
Recovery flowcharts
09:45
Section 4: Recovery Manager Concepts
Overview
09:43
Recovery Manager Architecture
05:41
The backup set
05:40
Image copies
02:29
Sample backup with RMAN
04:21
Section 5: RMAN Backup
Overview
02:33
Cold backups
01:19
Cold backup in no-archivelog mode demo
05:26
Cold backup in archivelog mode demo
04:00
Hot backups
01:18
Hot backup attempt in no-archivelog mode
03:30
Hot backup demo
03:41
Controlfile backup demo
05:13
Image copy demo
03:25
Archived log backups
03:00
Archived log backup demo
05:08
Incremental backups
07:51
Incremental level 0 backup demo
04:46
Incremental level 1 backup demo
03:50
Block Change Tracking demo
02:10
Controlfile autobackup
01:38
Controlfile autobackup demo
05:25
Backup compression
03:08
Backup compression demo
04:04
Section 6: RMAN Recovery
Overview
03:48
Complete recovery
03:01
Complete recovery demo part one
04:04
Complete recovery demo part two
02:42
Incomplete recovery
03:41
Incomplete recovery demo setup
04:18
Incomplete recovery demo
08:15
Controlfile recovery
03:51
Controlfile recovery from autobackup
10:29
More thoughts
05:29
More thoughts demo part one
04:31
More thoughts demo part two
09:32
Section 7: The Recovery Catalog
Overview
04:21
Creating the Recovery Catalog
04:20
Recovery Catalog Demo
05:35

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Dave Haas, Senior Oracle DBA/Instructor

I graduated University with a Bachelor of Science in Engineering but my passion is software. I've been working with Oracle database for almost 20 years and have achieved many certifications. Having been a production database administrator, instructor and software developer for many years I can help you achieve your Oracle certification goals.

Ready to start learning?
Take This Course