The Oracle Database 11g Administrator Certification (OCA 11g) ensures that database professionals have a strong foundation and expertize in the industry’s most advanced database management system, Oracle 11g.
Our Oracle 11g OCA training package covers includes the following exam courses needed for certification:
- 1Z0-047: Oracle Database SQL Expert
- 1Z0-052: Oracle Database 11g: Administration
Oracle 11g 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 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 databases are the one of the most popular database platforms in the world. Increase your skills and marketability today by achieving Oracle certification!
Course Syllabus
Database Architecture
- Architectural Components of the Oracle Database
- Memory Structures
- Server Processes and Background Processes
- Logical and Physical Storage Structures
- Module Summary
- Review Quiz
Installing the Oracle Software
- Database Administrator Tasks and Tools
- Planning a Oracle Database Installation
- Using Optimal Flexible Architecture
- Installing the Oracle Software using OUI
- Module Summary
- Review Quiz
Creating an Oracle Database
- Planning for Database Creation
- Configuring the Listener
- Creating a Database
- Module Summary
- Review Quiz
The Oracle Instance
- Starting and Stopping the Oracle Database
- Using the Oracle Enterprise Manager
- Access a Database with SQL*Plus
- Modify Database Initialization Parameters
- Database Startup
- Database Shutdown
- Viewing the Alert Log and Dynamic Performance Views
- Module Summary
- Review Quiz
Oracle Network Environment
- Creating and Configuring Additional Listeners
- Creating Oracle Net Service Aliases
- When to Use Shared and Dedicated Servers
- Module Summary
- Review Quiz
Database Storage Structures
- Describe Table Row Data and Define Tablespaces
- Creating and Managing Tablespaces
- Automatic Storage Management
- Module Summary
- Review Quiz
User Security
- Create and Manage User Accounts
- Grant and Revoke Privileges
- Create and Manage Roles
- Create and Manage Profiles
- Module Summary
- Review Quiz
Schema Objects
- Defining Schema Objects and Data Types
- Creating and Modifying Tables
- Defining Constraints
- Viewing Columns and Contents of a Table
- Creating Indexes
- Creating Views
- Creating Sequences
- Using Temporary Tables
- Module Summary
- Review Quiz
Data and Concurrency
- Managing data Using SQL
- Identifying and Administering PL/SQL Objects
- Monitoring and Resolving Locking Conflicts
- Module Summary
- Review Quiz
Undo Data
- Implementing Undo Data
- Working with Undo Data
- Module Summary
- Review Quiz
Security
- DBA Security and Privileges
- Enabling Auditing
- Audit Options and Information
- Fine Grained Auditing
- Auditing the DBA and Maintaining the Audit Trail
- Module Summary
- Review Quiz
Maintenance
- Managing Optimizer Statistics
- Managing Automatic Workload Repository
- Using the Automatic Database Diagnostic Monitor
- Setting Alerts and Thresholds
- Module Summary
- Review Quiz
Oracle Performance
- Performance Monitoring with the Enterprise Manager
- Using Automatic Memory Management
- Viewing Performance Related Dynamic Views
- Troubleshooting invalid and Unusable Objects
- Module Summary
- Review Quiz
Backup and Recovery
- Types of Database Failure
- Checkpoints, Redo Log Files, and Archive Log Files
- Instance Recovery
- Configuring for Recoverability
- Configuring Archive Log Mode
- Module Summary
- Review Quiz
Database Backups
- Backup Solutions Overview
- Configuring Backup Settings
- Scheduling Backups
- Backing up Control Files to a Trace File
- Managing Backups and the Flash Recovery Area
- Using the RMAN Command Line
- Module Summary
- Review Quiz
Recovery
- Recovering From a Lost Control File
- Recovering Redo Log Files
- Recovering Non Critical and Critical Data Files
- Using the Data Recovery Advisor
- Module Summary
- Review Quiz
Moving Data
- Moving Data and Creating Directory Objects
- Loading Data with the SQL Loader
- Creating and Reading External Tables
- Using Oracle Data Pump Export and Import
- Data Pump Performance and Monitoring
- Module Summary
- Review Quiz
Database Maintenance
- Using the Enterprise Manager Support Workbench
- Metalink Integration and Managing Patches
- Module Summary
- Review Quiz
- Course Review
- Oracle Database/ SQL Expert: Exam 1Z0-047
- Introduction to Oracle SQL
Relational Database Systems
- Examining SQL
- SQL Developer and SQL Plus
- Examining the Database and Schema
- Module Summary
- Review Quiz
Select Statements
- Basic Select Statements
- Selecting Columns and Using Arithmetic Operators
- Operator Precedence
- Concatenation Operator
- Displaying the Table Structure
- Module Summary
- Review Quiz
Where and Order By Clauses
- Implementing the Where Clause
- Comparison Operators
- Logical Operators
- Rules of Precedence
- Substitution Variables
- Module Summary
- Review Quiz
Single Row Functions
- Types of Single Row Functions
- Working with Dates
- Module Summary
- Review Quiz
Group Functions
- Types of Group Functions
- Creating Groups of Data
- Multi Column Grouping
- Module Summary
- Review Quiz
Joins
- Natural Joins
- Nonequijoins and Outer Joins
- Cartesian Joins
- Module Summary
- Review Quiz
Sub-Queries
- Single Row Subqueries
- Multiple Row Subqueries
- Null Values
- Module Summary
- Review Quiz
Set Operators
- Union and Union All Operators
- Intersect and Minus Operators
- Select Statements and the Order By Clause
- Module Summary
- Review Quiz
Data Manipulation Language
- Insert Statements
- Update Statement
- Delete Statement
- Database Transactions
- Module Summary
- Review Quiz
Data Definition Language
- Creating Tables
- Data Types and Constraints
- Altering a Table Statement
- Module Summary
- Review Quiz
Schema Objects
- Views
- Sequences
- Indexes
- Synonyms
- Module Summary
- Review Quiz
User Privileges
- Creating a User
- System Privileges
- Role and Object Privileges
- Granting and Revoking Privileges
- Module Summary
- Review Quiz
Schema Objects
- Altering a Table
- Adding Constraints
- Dropping Constraints
- Indexes
- Dropping Tables and Flashback Table
- Create and Use External Tables
- Module Summary
- Review Quiz
Oracle Data Dictionary Views
- Using the Oracle Data Dictionary
- Types of Views and Querying the Data Dictionary
- View Information
- Module Summary
- Review Quiz
Large Data Sets
- Using Subqueries
- Default values and Copying Rows
- Multi Table Insert
- Merge Statement
- Flash Back Version Query
- Module Summary
- Review Quiz
Time Zones
- Time Zone Functions
- Time Stamp Data Types
- Interval Data Types
- Available Functions
- Module Summary
- Review Quiz
Advanced Sub-Queries
- Pairwise and Nonpairwise Comparison Queries
- Scalar Subquery
- Correlated Subquery
- Exist Operator and With Clause
- Module Summary
- Review Quiz
Regular Expressions
- Using Regular Expressions
- Using Subexpressions and Check Constraint Expressions
- Module Summary
- Review Quiz
Course Review
University Online’s e-learning system, certification has never been simpler! You can be starting your IT career or taking your current IT skills to the next level in just a few short weeks. Our proven learning system gives you all of the benefits of a live class at just a fraction of the cost. We’re so confident that our materials will produce results; we guarantee you’ll get certified on your FIRST attempt or your money back!
IT University’s courses include:
IT University uses only the industry’s finest instructors in the IT industry. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can fast-forward, repeat or rewind all your lectures. This creates a personal learning experience and gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7.
Our courseware includes instructor-led demonstrations and visual presentations that allow students to develop their skills based on real world scenarios explained by the instructor. IT University always focuses on real world scenarios and skill-set development.
IT University’s custom practice exams prepare you for your exams differently and more effectively than the traditional exam preps on the market. We test you in three different ways; first, you have a learning tool, that gives you feedback as to why an answer is correct or incorrect. Next, you’ll receive the questions presented in a randomized, timed format very similar to the live exam. Every time you take the exam, new questions appear. At the end of the test you will be shown, in percentage, what areas of the curriculum you are strong on as well as what areas you’re weak on. The third part allows you to test on a “Single Objective” from that exam. This will allow you to pick one topic and then get questions just on that subject.
IT University’s self-paced training programs are designed in a modular fashion to allow you the flexibility to work with expert level instruction anytime 24/7. All courses are arranged in defined sections with navigation controls allowing you to control the pace of your training.
