Oracle Database 11g: Administration Workshop I Boot Camp Training Course & Certification Exam in NY, NV, DC & Online

Home > Vendors > Oracle > Oracle Database 11g, 10g > Oracle Database 11g: Administration Workshop I Boot Camp

Oracle Database 11g: Administration Workshop I Boot Camp Course Description

This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn 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. The lesson topics are reinforced with structured hands-on practices.

Intended Audience for the Oracle Database 11g: Administration Workshop I Boot Camp Course

Database Administrators
Support Engineer
Developer
Technical Administrator
Database Designers

Training Packages & Career Tracks that include the Oracle Database 11g: Administration Workshop I Boot Camp Course

Oracle Database 11g: Administration Workshop I Boot Camp Course Objectives

Describe Oracle Database Architecture
Install and configure Oracle Database 11g
Configure Oracle Net services
Manage the database storage structures
Create and administer user accounts
Perform basic backup and recovery of a database
Manage users and schemas
Manage data and concurrency
Monitor and administer undo data
Backup and recover a database
Monitor performance
Use the database diagnostic monitor

The Oracle Database 11g: Administration Workshop I Boot Camp Course prepare students for the following Exams

1Z0-052 : Oracle Database 11g: Administration I

Oracle Database 11g: Administration Workshop I Boot Camp Course Outline

Exploring the Oracle Database Architecture
1. Oracle Database Architecture Overview
2. Interacting with an Oracle Database
3. Process Architecture
4. Database Storage Architecture
5. Logical and Physical Database Structures
6. Tablespaces and Data Files
7. SYSTEM and SYSAUX Tablespaces
8. Segments, Extents, and Blocks
Preparing the Database Environment
1. Tasks of an Oracle Database Administrator
2. Tools Used to Administer an Oracle Database
3. Installation: System Requirements
4. Optimal Flexible Architecture (OFA)
5. Setting Environment Variables
6. Oracle Universal Installer (OUI)
7. Database Configuration Options
8. Advanced Installation Options
Creating an Oracle Database
1. Planning the Database
2. Configuring the Listener
3. Using the DBCA to Create a Database
4. Password Management
5. Creating a Database Design Template
6. Using the DBCA to Delete a Database
7. Using DBCA For Additional Tasks
Managing the Oracle Instance
1. Management Framework
2. Oracle Enterprise Manager
3. Initialization Parameter
4. Database Startup and Shutdown
5. Shutdown Modes
6. Viewing the Alert History
7. Using Trace Files
8. Data Dictionary: Overview
Configuring the Oracle Network Environment
1. Oracle Net Services & Listener
2. Establishing Net Connections
3. Tools for Configuring and Managing the Oracle Network
4. Net Services Administration Pages
5. Naming Methods
6. Directory Naming
7. SGA and PGA
8. When Not to Use a Shared Server
Managing Database Storage Structures
1. Storage Structures
2. How Table Data Is Stored
3. Anatomy of a Database Block
4. Space Management in Tablespaces
5. Tablespaces in the Preconfigured Database
6. Actions with Tablespaces
7. Oracle Managed Files (OMF)
8. ASM: Concepts
Administering User Security
1. Database User Accounts
2. Predefined Accounts: SYS and SYSTEM
3. Administrator Authentication
4. Benefits of Roles
5. Predefined Roles
6. Implementing Password Security Features
7. Assigning Quota to Users
Managing Schema Objects
1. What Is a Schema?
2. Accessing Schema Objects
3. Specifying Data Types in Tables
4. Creating and Modifying Tables
5. Understanding Data Integrity
6. Indexes & Views
7. Sequences
8. Temporary Tables
Managing Data and Concurrency
1. Manipulating Data Through SQL
2. PL/SQL
3. Administering PL/SQL Objects
4. Functions, Procedures, Packages & Triggers
5. Data Concurrency
6. Enqueue Mechanism
7. Resolving Lock Conflicts Using SQL
8. Deadlocks
Managing Undo Data
1. Data Manipulation
2. Transactions and Undo Data
3. Undo Data Versus Redo Data
4. Configuring Undo Retention
5. Guaranteeing Undo Retention
6. Using the Undo Advisor
7. Viewing System Activity
Implementing Oracle Database Security
1. Industry Security Requirements
2. Principle of Least Privilege
3. Monitoring for Compliance
4. Value-Based Auditing
5. Fine-Grained Auditing
6. DBA Auditing
7. Security Updates
8. Applying Security Patches
Database Maintenance
1. Introducing Terminology
2. Optimizer Statistics
3. Automatic Workload Repository (AWR)
4. Automatic Database Diagnostic Monitor (ADDM)
5. Advisory Framework
6. Automated Maintenance Tasks
7. Server-Generated Alerts
8. Reacting to Alerts
Performance Management
1. Performance Monitoring
2. Managing Memory Components
3. Enabling Automatic Memory Management (AMM)
4. Automatic Shared Memory Advisor
5. Using Memory Advisors
6. Dynamic Performance Statistics
7. Troubleshooting and Tuning Views
8. Invalid and Unusable Objects
Backup and Recovery Concepts
1. Part of Your Job
2. Statement Failure
3. User Error
4. Understanding Instance Recovery
5. Phases of Instance Recovery
6. Using the MTTR Advisor
7. Media Failure
8. Archive Log Files
Performing Database Backups
1. Backup Solutions: Overview
2. Oracle Secure Backup
3. User-Managed Backup
4. Terminology
5. Recovery Manager (RMAN)
6. Configuring Backup Settings
7. Backing Up the Control File to a Trace File
8. Monitoring the Flash Recovery Area
Performing Database Recovery
1. Opening a Database
2. Data Recovery Advisor
3. Loss of a Control File
4. Loss of a Redo Log File
5. Data Recovery Advisor
6. Data Failures
7. Listing Data Failures
8. Data Recovery Advisor Views
Moving Data
1. Moving Data: General Architecture
2. Directory Object: Overview
3. SQL*Loader: Overview
4. Data Pump: Overview
5. Performance Initialization Parameters
6. Using Enterprise Manager to Monitor Data Pump Jobs
7. Data Dictionary
Enhancing Database Capabilities
1. Using EM Support Workbench
2. Create a Service Request
3. Package and upload diagnostic data to Oracle Support
4. Track the SR and Implement Repairs
5. Incident Packaging Configuration
6. Working with Oracle Support
7. MetaLink Integration
8. Managing Patches

Benefits of taking the Oracle Database 11g: Administration Workshop I Boot Camp course at NetCom

Why choose Oracle Training at NetCom Learning?
As a recognition for training excellence, NetCom Learning was chosen by Microsoft as the 2007 Worldwide Learning Solutions Partner of the year out of 1400 training companies.
In addition, we have won numerous other training awards for quality and customer satisfaction by CompTIA, EC-Council and other vendors. We are simply passionate about learning and achieving the highest customer satisfaction in your learning experience!
NetCom provides Authorized Training
NetCom Learning is a Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Platinum Partner, EC-Council Accredited Training Center, Adobe Authorized Training Center, Autodesk Authorized Training Center and many others. We are proud to offer the highest quality, authorized training solutions from our many partners for our customers.
See our comprehensive list of partner authorizations.

Award winning, world-class Instructors

Finnbarr M.
- Masters Degree in Computer Science from Boston University along with several certifications.
- Over 25 years of experience in the IT field and expert in Unix, GNU/Linux, and Oracle ecosystems.
- More than 10 years working as a Software Engineer in multinational companies such as Hewlett-Packard.

Bio:

Finnbarr has both breadth and in-depth knowledge of Unix, GNU/Linux, and Oracle with 25+ years of experience in operating system internals development, system administration, application development and project management on a wide variety of hardware and software platforms. As a Software Engineer, he developed and managed numerous projects in multinational companies such as Hewlett-Packard.

Finnbarr is a member of the Institute of Electrical and Electronic Engineers as well as a Moderator at unix.com. He is also a top Instructor and Subject Matter Expert at NetCom Learning and is well recognized by the students for his knowledge and his great teaching technique.

Actual Client Testimonials

	May 15 2012
Training environment and material are good. Materials are clear and short to the point. Instructor is very knowledgeable and full of experience. I've learned so much through the lecture as well as from his real life experiences. -Aye M.
Course(s) Taken
Oracle DBA Track (11g) - Boot Camp

	May 15 2012
Great training! Great instructor! -Fasika M.
Course(s) Taken
Oracle DBA Track (11g) - Boot Camp

	May 15 2012
This was a much needed and intensive training. -Paul V.
Course(s) Taken
Oracle DBA Track (11g) - Boot Camp

	May 15 2012
Great experience! Geoff is awesome :-) -Nadie H.
Course(s) Taken
Oracle DBA Track (11g) - Boot Camp

	Aug 29 2011
My instructor is very knowledgeable. He was capable of answering all questions and explaining all material in detail. I am glad I chose NetCm for my training. All of the NetCm staff were courteous helpful, and polite. -Adrienne B.
Course(s) Taken
Oracle DBA Track (11g) - Boot Camp

	Jul 02 2011
I am very pleased about my experience with NetCom Learning. It was a great course! The best experience I could have expected. Great instructor! Great everything! I am very happy. Thank You! -Lorena M.
Course(s) Taken
Oracle DBA Track (11g) - Boot Camp

	Jul 02 2011
Very clean facilities, super friendly staff, knowledgeable instructor. -Alma C.
Course(s) Taken
Oracle DBA Track (11g) - Boot Camp

	Jul 02 2011
Geoff was a great instructor during the Oracle course. He ensured I understood the material and brought a sense of fun to the class. I really really have to study for the certification course due to my limited database management skills. This training and certification will hopefully allow me to start a new career. -Denise L.
Course(s) Taken
Oracle DBA Track (11g) - Boot Camp

Awards won by NetCom
NetCom Learning is an award winning, customer focused company. We are simply Passionate About Learning!
See our list of awards.
Specialized Boot Camp Training

This training is also available as a boot camp. NetCom is world famous for delivering specialized boot camp training to our clients.
For answers to questions regarding our boot camp training delivery format, please refer to our Boot Camp FAQ section.

Enrollment Options for the Oracle Database 11g: Administration Workshop I Boot Camp course

Click on a date to register.
Oracle Database 11g: Administration Workshop I Boot Camp in Las Vegas, Aug 8, 2012
Oracle Database 11g: Administration Workshop I Boot Camp in Arlington, Sep 26, 2012
Oracle Database 11g: Administration Workshop I Boot Camp in Las Vegas, Nov 7, 2012
more..

For a customized version of this class, please contact us or call 1-888-563-8266.

Training Delivery Methods

Take this training with one of the following training delivery methods

Classroom Training
NetCom’s classroom training ensures that you have state-of-the-art tools, techniques and practices you need to succeed on the job. Our instructors are active practitioners and true masters in their fields. With convenient classes at multiple learning centers across the US, you never have to go far to get ahead.
Live Online Training (LOT)
NetCom’s premium Live Online Training (we call it LOT) is the ultimate in convenience and cost-effectiveness. LOT combines interactive video instruction via the latest web conference technology, and post-class access to learning labs for a best-in-class learning experience.
Learn more about LOT
Boot Camp Training
NetCom’s intensive boot camps are designed to advance your skills in the shortest possible amount of time and get you certified. Boot camps go at a faster pace and often run for longer days, so you must have some level of subject matter experience before enrolling. Boot camps have mandatory assessment tests to ensure no one will slow down the class for other students. Learn more about Boot Camps
Private Onsite Training
With NetCom’s private training programs, you decide where and when courses are held. Tailor the training to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique. Save money by doing bulk customized training.
Learn more about Private Onsite Training
Private 1-on-1 Training
NetCom’s private 1-on-1 training focuses on the highest quality training possible. You get individualized, full attention from the instructor and you decide where and when courses are held. The training is custom tailored to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique.
Learn more about Private 1-on-1 Training