Oracle 11g Certified Professional Exam Prep I

Part 1 of a 3 part series. A clear, concise and expert guide to achieving certification for Oracle Database.
4.3 (72 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.
428 students enrolled Bestselling in Oracle
$19
$75
75% off
Take This Course
  • Lectures 125
  • Length 11 hours
  • Skill Level Beginner 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 assumes no prior knowledge of Oracle Database. We'll cover everything from installing the software to creating databases to managing security.
  • 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

What am I going to get from this course?

  • Complete the Oracle 11g Certified Associate Exam

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: Architectural Overview
Overview
Preview
04:48
Access vs Oracle
Preview
04:01
Single Instance Installations
Preview
02:00
Single Instance Demo
07:28
Memory Structures
09:25
The Shared Pool
07:40
The Buffer Pool
09:29
Process Structures
11:33
Process Structures Demo
03:58
Storage Structures
14:11
Storage Structures Demo
10:55
SQL Statement Processing Walkthrough
13:17
Section 2: Software Installation
Installation Overview
01:24
Pre-requisites
03:55
Installation demo
06:43
Post-installation demo
02:18
Post-installation security review
02:18
Section 3: Database Creation
Overview
01:07
Create a Listener
02:01
Database Configuration Assistant Demo
13:45
Post DBCA Demo
02:30
Administrative Tools
08:06
Creating a database manually
03:05
Create directories and parameter file
05:46
Create the Windows service and start the instance
05:09
Create the database
10:01
Create the dictionary views
03:44
Create the standard PL/SQL packages
01:49
Create the SQL+ Product User Profile
03:03
Compare manual creation with the Database Configuration Assistant
09:19
Create the Enterprise Manager interface, Database Control
05:01
Post EM DBControl configuration
03:40
Section 4: Instance Management
Overview
02:00
SQL+
01:59
SQL+ demo
07:44
Database Control (Enterprise Manager)
04:00
Database Control demo
10:58
Using parameters
08:58
Server parameter file demo
11:23
Instance startup phases
03:47
Instance startup demo
06:17
Using the database dictionary
06:58
Database dictionary demo
11:03
Section 5: Storage Structures
Overview
00:51
Storing data in datafiles
04:33
Tablespaces
08:41
Tablespaces demo part one
11:27
Tablespaces demo part two
10:30
Tablespaces demo part three
04:14
Online log files
01:47
Log demo part one
10:23
Log demo part two
04:16
Advancing forward (checkpointing)
06:12
Control files
02:19
Control files demo
06:04
Section 6: Networking
Networking Overview
02:17
TNS (Transparent Network Substrate)
02:23
The Listener
02:39
Configuring the Listener
01:51
Listener demo
08:44
Client libraries installation demo part one
02:43
Client libraries installation demo part two
00:48
Name resolution
03:03
Name resolution demo part one
06:39
Name resolution demo part two
03:24
Multiple client installations demo
06:08
Shared Server
05:41
Shared Server demo
09:03
Common problems
03:12
Common problems demo
08:52
Section 7: User Security
Overview
01:18
The Schema concept
02:46
Users
05:08
Creating a user demo part one
07:13
Creating a user demo part two
05:41
Privileges
08:42
Privileges Demo
08:09
Roles
02:10
Roles Demo
06:38
Profiles
04:35
Profiles demo
05:56
Section 8: Schema Objects
Overview
01:23
Tables
05:14
Tables demo
06:09
Views
01:46
Views demo
05:14
Indexes
08:44
Setting up the indexes demo
01:58
Indexes demo
06:19
Constraints
03:35
Constraints demo part one
05:10
Constraints demo part two
04:20

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