Oracle 11g Certified Professional Exam Prep I
4.3 (125 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.
736 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle 11g Certified Professional Exam Prep I to your Wishlist.

Add to Wishlist

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.
Bestselling
4.3 (125 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.
736 students enrolled
Created by Dave Haas
Last updated 10/2015
English
Current price: $10 Original price: $75 Discount: 87% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 11 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Complete the Oracle 11g Certified Associate Exam
View Curriculum
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
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 is the target audience?
  • This course is meant for people interested in gaining a deeper understanding of Oracle Database in order to achieve certification
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 125 Lectures Collapse All 125 Lectures 11:06:57
+
Architectural Overview
12 Lectures 01:38:45



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
+
Software Installation
5 Lectures 16:38
Installation Overview
01:24

Pre-requisites
03:55

Installation demo
06:43

Post-installation demo
02:18

Post-installation security review
02:18
+
Database Creation
15 Lectures 01:18:06
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
+
Instance Management
11 Lectures 01:15:07
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
+
Storage Structures
12 Lectures 01:11:17
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
+
Networking
15 Lectures 01:07:27
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
+
User Security
11 Lectures 58:16
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
+
Schema Objects
15 Lectures 01:15:16
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

Constraints demo part three
07:40

Constraints demo part four
03:44

Constraints demo part five
06:07

Space allocation
07:53
+
Managing Undo
7 Lectures 39:42
Undo Overview
01:08

Concurrency concepts
05:08

Concurrency demo
07:10

Transactions
04:44

Transactions demo
09:05

Storing Undo
04:27

Undo storage demo
08:00
+
Moving Data
12 Lectures 48:23
Overview
01:45

Data Pump
02:08

Export data pump
07:02

Setting up the datapump demo's
01:38

Export datapump demo part one
08:21

Export datapump demo part two
04:26

Import data pump
02:09

Import datapump demo
04:42

SQL Loader
04:01

SQL Loader demo
04:48

External tables
02:09

External tables demo
05:14
1 More Section
About the Instructor
Dave Haas
4.3 Average rating
213 Reviews
811 Students
3 Courses
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.