Oracle 11

150 Hours / 12 Months / Self-Paced

Course Overview:

The Oracle Database 11g Administrator Certification (OCA 11g) ensures that database professionals you have a strong foundation and expertise in the industry’s most advanced database management system, Oracle 11g.

This training course will teach students how to install and maintain an Oracle database, how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.  Students will also learn skills required for working with SQL, including how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques.  After completing

The Oracle OCA 11g course, students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another.

Oracle DBA's managed the industry's most advanced information systems and command some of the highest salaries.  By earning your Oracle Certification, you will be one step closer to gaining access to better career opportunities.

Course Outline:

Oracle Database 11g: SQL Fundamentals I​ Curriculum:
Lesson 1: Introducing SQL
  • Overview
  • SQL Fundamentals
  • Writing Simple Queries
  • Accepting Values at Runtime
  • Summary
  • Exam Essentials
  • Review Questions
Lesson 2: Using Single-Row Functions
  • Overview
  • Single-Row Function Fundamentals
  • Using Single-Row Character Functions
  • Using Single-Row Numeric Functions
  • Using Single-Row Date Functions
  • Using Single-Row Conversion Functions
  • Using Other Single-Row Functions
  • Summary
  • Exam Essentials
  • Review Questions
Lesson 3: Using Group Functions
  • Overview
  • Group-Function Fundamentals
  • Utilizing Aggregate Functions
  • Summary
  • Exam Essentials
  • Review Questions
Lesson 4: Using Joins and Subqueries
  • Overview
  • Writing Multiple-Table Queries
  • Using Set Operators
  • Subqueries
  • Summary
  • Exam Essentials
  • Review Questions
Lesson 5: Manipulating Data
  • Overview
  • Using DML Statements
  • Understanding Transaction Control
  • Summary
  • Exam Essentials
  • Review Questions
Lesson 6: Creating Tables and Constraints
  • Overview
  • Database Objects Overview
  • Built-in Datatypes
  • Creating Tables
  • Modifying Tables
  • Managing Constraints
  • Summary
  • Exam Essentials
  • Review Questions
Lesson 7: Creating Schema Objects
  • Overview
  • Creating and Modifying Views
  • Creating and Managing Sequences
  • Creating and Managing Synonyms
  • Creating and Managing Indexes
  • Summary
  • Exam Essentials
  • Review Questions
Oracle Database 11g: Administration I Curriculum:
Lesson 1: Introducing Oracle Database 11g Components and Architecture
  • Overview
  • Oracle Database Fundamentals
  • Relational Databases
  • Oracle Database 11g Objects
  • Interacting with Oracle 11g
  • Oracle 11g Architecture
  • User Processes
  • The Oracle Instance
  • Oracle Storage Structures
  • Installing Oracle 11g
  • Review the Documentation
  • Review the System Requirements
  • Plan Your Install
  • Using the Oracle Universal Installer
  • Summary
  • Exam Essentials
  • Review Questions
Lesson 2: Creating an Oracle 11g Database
  • Overview
  • Using DBCA to Create Oracle 11g Databases
  • Working with Oracle 11g Metadata
  • Managing Initialization-Parameter Files
  • Starting Up and Shutting Down an Oracle Instance
  • Monitoring the Database Alert Log
  • Summary
  • Exam Essentials
  • Review Questions
Lesson 3: Allocating Database Storage and Creating Schema Objects
  • Overview
  • Tablespaces and Data Files Overview
  • Managing Tablespaces
  • Managing Data Files
  • Working with Schema Objects
  • Summary
  • Exam Essentials
  • Review Questions
Lesson 4: Understanding Network Architecture
  • Overview
  • Introducing Network Configurations
  • An Overview of Oracle Net Features
  • Configuring Oracle Net on the Server
  • Configuring Oracle Net for the Client
  • An Overview of Oracle Shared Server
  • Oracle Shared Server Infrastructure
  • Summary
  • Exam Essentials
  • Review Questions
Lesson 5: Implementing Security and Auditing
  • Overview
  • Creating and Managing User Accounts
  • Granting and Revoking Privileges
  • Controlling Resource Usage by Users
  • Auditing Database Activity
  • Summary
  • Exam Essentials
  • Review Questions
Lesson 6: Managing Data and Undo
  • Overview
  • Manipulating Data through SQL
  • Identifying PL/SQL Objects
  • Monitoring Locks and Resolving Lock Conflicts
  • Leveraging Undo Management
  • Summary
  • Exam Essentials
  • Review Questions
Lesson 7: Maintaining the Database and Managing Performance
  • Overview
  • Proactive Database Maintenance
  • Managing Performance
  • Summary
  • Exam Essentials
  • Review Questions
Lesson 8: Implementing Database Backups
  • Overview
  • Understanding and Configuring Recovery Components
  • Performing Backups
  • Summary
  • Exam Essentials
  • Review Questions
Lesson 9: Recovering the Database
  • Overview
  • Understanding Types of Database Failure
  • Performing Recovery Operations
  • Summary
  • Exam Essentials
  • Review Questions
Lesson 10: Moving Data and Using EM Tools
  • Overview
  • Understanding Data Pump
  • Loading Data with SQL*Loader
  • Populating External Tables
  • Using EM Support Workbench
  • Using EM to Manage Patches
  • Summary
  • Exam Essentials
  • Review Questions

Certification(s):

This course prepares students to take the 1Z0-051: Oracle Database SQL Fundamentals I and 1Z0-052: Oracle Database 11g: Administration I certification exams.


System Requirements:

Internet Connectivity Requirements:
  • Cable and DSL internet connections are recommended.

Hardware Requirements:
  • Minimum Pentium 400 Mhz CPU or G3 Macintosh. 1 GHz or greater CPU recommended.
  • 256MB RAM minimum. 1 GB RAM recommended.
  • 800x600 video resolution minimum. 1025x768 recommended.
  • Speakers/Headphones to listen to Dialogue steaming audio sessions.
  • A microphone to speak in Dialogue streaming audio sessions.
Operating System Requirements:
  • Windows Vista, 7, 8, 8.1, 9, 10
  • Mac OSX 10 or higher.
  • OpenSUSE Linux 9.2 or higher.
Web Browser Requirements:
  • Google Chrome is recommended.
  • Firefox 13.x or greater.
  • Internet Explorer 6.x or greater.
  • Safari 3.2.2 or greater.
Software Requirements:
  • Adobe Flash Player 6 or greater.
  • Oracle Java 7 or greater.
  • Adobe Reader 7 or greater.
Web Browser Settings:
  • Accept Cookies
  • Disable Pop-up Blocker.


**Outlines are subject to change, as courses and materials are updated.**