Oracle 11g Certified Professional Exam Prep III

Part 3 of a 3 part series. A clear, concise and expert guide to achieving certification for Oracle Database.
4.4 (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.
335 students enrolled
$19
$75
75% off
Take This Course
  • Lectures 102
  • Length 12.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 performance monitoring/problem recovery and advanced tuning

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: The Flash Recovery Area
Overview
Preview
04:20
Enabling the FRA
Preview
01:41
FRA setup demo
Preview
05:20
Section 2: Advanced RMAN
Overview
02:10
Persistent Settings
07:59
Persistent Settings Demo
07:43
Scripting
03:02
Scripting Demo
11:11
Reporting
06:31
Reporting Demo
12:31
Monitoring and Tuning
09:09
Monitoring and Tuning Demo
11:16
Tablespace Point in Time Recovery
11:02
TPITR Demo
14:37
Duplicating a Database
06:37
Duplicating a Database Demo Part I
04:10
Duplicating a Database Demo Part II
03:53
Duplicating a Database Demo Part III
06:49
Duplicating a Database Demo Part IV
10:27
Restoring to a New Host
04:30
Restoring to a New Host Demo Part I
09:00
Restoring to a New Host Demo Part II
04:29
Restoring to a New Host Demo Part III
06:20
Restoring to a New Host Demo Part IV
07:52
Section 3: Flashback
Overview
05:28
Flashback Query
11:59
Flashback Query Demo Part I
11:11
Flashback Query Demo Part II
07:09
Flashback Table
08:02
Flashback Table Demo Part I
05:15
Flashback Table Demo Part II
05:44
Flashback Table Demo Part III
04:05
Flashback Archive
09:24
Flashback Archive Demo Part I
10:27
Flashback Archive Demo Part II
08:14
Flashback Database
09:03
Flashback Database Demo
14:13
Section 4: Automatic Storage Management
Overview
05:07
Storage Virtualization
06:20
ASM Architecture
06:00
ASM Install Demo Part I
10:18
ASM Install Demo Part II
04:12
Database Install Demo
03:15
DBCA Demo
06:16
ASM Instance
11:47
ASM Instance Demo Part I
06:03
ASM Instance Demo Part II
11:22
ASM Instance Demo Part III
10:03
ASM Storage
13:15
ASM Storage Demo
10:45
Using ASM
05:15
Using ASM Demo Part I
10:56
Using ASM Demo Part II
07:34
Section 5: The Resource Manager
Overview
05:34
Resource Manager Architecture
05:31
Consumer Groups
06:15
Consumer Groups Demo
05:28
Resource Directives
09:15
Resource Plan
07:11
Session Mapping
05:32
Session Mapping Demo
04:29
Simple Plan Demo Part I
05:03
Simple Plan Demo Part II
07:47
Complete Plan
01:12
Complete Plan Demo Part I
06:42
Complete Plan Demo Part II
10:23
Complete Plan Demo Part III
04:54
Section 6: The Scheduler
Overview
04:14
Scheduler Architecture
05:27
Scheduler Architecture Demo
06:17
Scheduler Components
06:34
Programs
03:09
Programs Demo Part I
06:38
Programs Demo Part II
14:13
Schedules
09:16
Jobs
02:15
Simple Job Demo
09:44
Advanced Scheduler Components
05:31
Job Chains
02:34
Job Chains Demo
20:25
Section 7: Monitoring Oracle
Overview
08:25
Monitoring Infrastructure
09:28
Statistics Demo
06:28
The Automated Workload Repository (AWR)
11:38
AWR Snapshots Demo
09:39
The Advisory Framework
08:59
The Automatic Database Diagnostics Monitor
04:29
ADDM Demo
06:21
SQL Advisors
07:25
Tuning Advisors Demo Part I
04:02
Tuning Advisors Demo Part II
02:30
Tuning Advisors Demo Part III
02:22
Tuning Advisors Demo Part IV
11:07

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