Oracle 11g Certified Professional Exam Prep I

  1. Home
  2. Oracle-certification
  3. Oracle 11g Certified Professional Exam Prep I

Tags: Oracle Certification

Part 1 of a 3 part series. A clear, concise and expert guide to achieving certification for Oracle Database.

Last updated 2022-01-10 | 4.7

- Complete the Oracle 11g Certified Associate Exam

What you'll learn

Complete the Oracle 11g Certified Associate Exam

* 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 this course is for:

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

Course content

11 sections • 125 lectures

Architectural Overview 12 lectures

Overview Preview 04:48

Access vs Oracle Preview 04:01

Single Instance Installations Preview 02:00

Single Instance Demo Preview 07:28

Memory Structures Preview 09:25

The Shared Pool Preview 07:40

The Buffer Pool Preview 09:29

Process Structures Preview 11:33

Process Structures Demo Preview 03:58

Storage Structures Preview 14:11

Storage Structures Demo Preview 10:55

SQL Statement Processing Walkthrough Preview 13:17

Software Installation 5 lectures

Installation Overview Preview 01:24

Pre-requisites Preview 03:55

Installation demo Preview 06:43

Post-installation demo Preview 02:18

Post-installation security review Preview 02:18

Database Creation 15 lectures

Overview Preview 01:07

Create a Listener Preview 02:01

Database Configuration Assistant Demo Preview 13:45

Post DBCA Demo Preview 02:30

Administrative Tools Preview 08:06

Creating a database manually Preview 03:05

Create directories and parameter file Preview 05:46

Create the Windows service and start the instance Preview 05:09

Create the database Preview 10:01

Create the dictionary views Preview 03:44

Create the standard PL/SQL packages Preview 01:49

Create the SQL+ Product User Profile Preview 03:03

Compare manual creation with the Database Configuration Assistant Preview 09:19

Create the Enterprise Manager interface, Database Control Preview 05:01

Post EM DBControl configuration Preview 03:40

Instance Management 11 lectures

Overview Preview 02:00

SQL+ Preview 01:59

SQL+ demo Preview 07:44

Database Control (Enterprise Manager) Preview 04:00

Database Control demo Preview 10:58

Using parameters Preview 08:58

Server parameter file demo Preview 11:23

Instance startup phases Preview 03:47

Instance startup demo Preview 06:17

Using the database dictionary Preview 06:58

Database dictionary demo Preview 11:03

Storage Structures 12 lectures

Overview Preview 00:51

Storing data in datafiles Preview 04:33

Tablespaces Preview 08:41

Tablespaces demo part one Preview 11:27

Tablespaces demo part two Preview 10:30

Tablespaces demo part three Preview 04:14

Online log files Preview 01:47

Log demo part one Preview 10:23

Log demo part two Preview 04:16

Advancing forward (checkpointing) Preview 06:12

Control files Preview 02:19

Control files demo Preview 06:04

Networking 15 lectures

Networking Overview Preview 02:17

TNS (Transparent Network Substrate) Preview 02:23

The Listener Preview 02:39

Configuring the Listener Preview 01:51

Listener demo Preview 08:44

Client libraries installation demo part one Preview 02:43

Client libraries installation demo part two Preview 00:48

Name resolution Preview 03:03

Name resolution demo part one Preview 06:39

Name resolution demo part two Preview 03:24

Multiple client installations demo Preview 06:08

Shared Server Preview 05:41

Shared Server demo Preview 09:03

Common problems Preview 03:12

Common problems demo Preview 08:52

User Security 11 lectures

Overview Preview 01:18

The Schema concept Preview 02:46

Users Preview 05:08

Creating a user demo part one Preview 07:13

Creating a user demo part two Preview 05:41

Privileges Preview 08:42

Privileges Demo Preview 08:09

Roles Preview 02:10

Roles Demo Preview 06:38

Profiles Preview 04:35

Profiles demo Preview 05:56

Schema Objects 15 lectures

Overview Preview 01:23

Tables Preview 05:14

Tables demo Preview 06:09

Views Preview 01:46

Views demo Preview 05:14

Indexes Preview 08:44

Setting up the indexes demo Preview 01:58

Indexes demo Preview 06:19

Constraints Preview 03:35

Constraints demo part one Preview 05:10

Constraints demo part two Preview 04:20

Constraints demo part three Preview 07:40

Constraints demo part four Preview 03:44

Constraints demo part five Preview 06:07

Space allocation Preview 07:53

Managing Undo 7 lectures

Undo Overview Preview 01:08

Concurrency concepts Preview 05:08

Concurrency demo Preview 07:10

Transactions Preview 04:44

Transactions demo Preview 09:05

Storing Undo Preview 04:27

Undo storage demo Preview 08:00

Moving Data 12 lectures

Overview Preview 01:45

Data Pump Preview 02:08

Export data pump Preview 07:02

Setting up the datapump demo's Preview 01:38

Export datapump demo part one Preview 08:21

Export datapump demo part two Preview 04:26

Import data pump Preview 02:09

Import datapump demo Preview 04:42

SQL Loader Preview 04:01

SQL Loader demo Preview 04:48

External tables Preview 02:09

External tables demo Preview 05:14

Implementing Oracle Database Server Security 10 lectures

Security Overview Preview 02:08

Security of the PUBLIC role Preview 02:22

Insecure instance parameters Preview 02:37

Instance parameter demo part one Preview 04:21

Instance parameter demo part two Preview 09:38

Instance parameter demo part three Preview 01:49

Auditing Preview 02:21

Auditing demo part one Preview 04:41

Auditing demo part two Preview 05:16

Auditing SYS operations Preview 02:47