Home | Career Tracks | Boot Camps | Course Search | Student Log In | Request Info | 1-800-482-3172 | Contact Us

About Us
Corporate IT Training
Vocational IT Training
CareerSource Solutions
Government/VA Solutions
Financing Options
Other Training Information
Student Resources
Career Services
Promotions
Press Releases
Course Catalog
Course Search
Forms
Real Estate Classes
Store
Connect With Us

Oracle Database 11g: Administrator Boot Camp

 

 

Click Here to View Schedules & Pricing and to Enroll Online

 

 

Duration: 14 Days

  

 

Description:

 

This 14-day boot camp will provides IT professionals with the advanced knowledge and skills necessary to administer the world's leading database systems and applications.

This course will lead you through the steps to become an Oracle Database 11g Administrator Certified Professional, including the associate certification path to get you started. Through training, experience, and official testing, we ensure that you walk away with a strong foundation and validated expertise in the advanced Oracle database management system.

You will learn the essentials of administering a database; including the skills and knowledge to install, configure, and maintain the database. Upon completion of this course, you will have the foundation necessary to develop advanced knowledge in a variety of focus areas.

Having Oracle certification demonstrates that you have a strong understanding of Oracle products. It will leave you with increased access to the industry's most challenging opportunities.

 

 

What's Included:

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers  & Onsite Certification Testing
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

 

 

 

Curriculum:

 

This curriculum prepares students for on-site delivery of the following Oracle certification exams:
1Z0-051: Oracle Database 11g SQL Fundamentals
1Z0-052: Oracle Database 11g Administration I
1Z0-053: Oracle Database 11g Administration II

Oracle Database 11g SQL Fundamentals
Retrieving Data Using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables
Using Subqueries to Solve Queries
Using the Set Operators
Manipulating Data
Using DDL Statements to Create and Manage Tables
Creating Other Schema Objects

Oracle Database 11g Administration I
Basic Oracle Concepts
Installing Oracle Database 11g
Creating an Oracle Database
Interfacing with the Oracle Database
Managing the Oracle Instance
Configuring the Oracle Networking Environment
Administering Users
Managing Schema Objects
Managing Data and Concurrency
Programming Oracle with PL/SQL
Securing the Database
Configuring Oracle Networking
Managing Shared Servers
Managing Database Performance
Monitoring Oracle
Managing Undo
Implementing Oracle Database Security
Configuring the Database for Backup and Recovery
Backing Up Oracle Databases
Recovering Oracle Databases
Recovering from User Errors
Tools for Oracle Database 11g Tuning
Moving Data
Intelligent Infrastructure Elements

Oracle Database 11g Administration II
Database Structure and ASM
Getting Started with Oracle Recovery Manager (RMAN)
Using RMAN to Back Up Oracle Databases
Creating RMAN Backups
Miscellaneous RMAN Features
Monitoring and Tuning RMAN
Using Flashback Database
Memory Management Techniques
Using Disk Space and Resource Management
Configuring Database Diagnostics
Monitoring and Managing Memory
Using the Scheduler for Task Automation
Database Globalization

 


Academy Code of Honor:  

The Academy guarantees that students shall pass all vendor examinations during the training program or may re-attend within one year of the program completion date. Students will only be responsible for accommodations and vendor exam fees.  

Student Login | Request Info | Course Search | Contact Us