Oracle 11

Hours: 150 / Access Length: 12 Months / Delivery: Online, Self-Paced
Retail Price: $2,595.00

Course Overview:

The Oracle Database 11g Administrator Certification (OCA 11g) ensures that as 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.

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

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:

System Requirements:

Internet Connectivity Requirements:
  • Cable and DSL internet connections are recommended for the best experience.
Hardware Requirements:
  • CPU: 1 GHz or higher
  • RAM: 2 GB or higher
  • Resolution: 1280 x 720 or higher
  • Speakers / Headphones
  • Microphone (Webinar / Live Online sessions)
Operating System Requirements:
  • Microsoft Windows 7 or 10 (Home, Pro)
  • Mac OSX 10 or higher.
  • Latest Chrome OS
  • Latest Linux Distributions

NOTE: While we understand that our courses can be viewed on Android and iPhone devices, we do not recommend the use of these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online based courses.

Web Browser Requirements:
  • Latest Google Chrome is recommended for the best experience.
  • Latest Mozilla FireFox
  • Latest Microsoft Edge
  • Latest Apple Safari
Basic Software Requirements (These are recommendations of software to use):
  • Office suite software (Microsoft Office, OpenOffice, or LibreOffice)
  • PDF reader program (Adobe Reader, FoxIt)
  • Courses may require other software that is denoted in the above course outline.