Oracle Database 11g: Administration Workshop I 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 Course- Database Administrators
- Support Engineer
- Developer
- Technical Administrator
- Database Designers
Training Packages & Career Tracks that include the Oracle Database 11g: Administration Workshop I Course
Oracle Database 11g: Administration Workshop I 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
Required Prerequisites for the Oracle Database 11g: Administration Workshop I course
The Oracle Database 11g: Administration Workshop I Course prepare students for the following Exams- 1Z0-052 : Oracle Database 11g: Administration I
Recommended Next Steps after taking the Oracle Database 11g: Administration Workshop I Course
Oracle Database 11g: Administration Workshop I Course Outline
- Exploring the Oracle Database Architecture
- Oracle Database Architecture Overview
- Interacting with an Oracle Database
- Process Architecture
- Database Storage Architecture
- Logical and Physical Database Structures
- Tablespaces and Data Files
- SYSTEM and SYSAUX Tablespaces
- Segments, Extents, and Blocks
- Preparing the Database Environment
- Tasks of an Oracle Database Administrator
- Tools Used to Administer an Oracle Database
- Installation: System Requirements
- Optimal Flexible Architecture (OFA)
- Setting Environment Variables
- Oracle Universal Installer (OUI)
- Database Configuration Options
- Advanced Installation Options
- Creating an Oracle Database
- Planning the Database
- Configuring the Listener
- Using the DBCA to Create a Database
- Password Management
- Creating a Database Design Template
- Using the DBCA to Delete a Database
- Using DBCA For Additional Tasks
- Managing the Oracle Instance
- Management Framework
- Oracle Enterprise Manager
- Initialization Parameter
- Database Startup and Shutdown
- Shutdown Modes
- Viewing the Alert History
- Using Trace Files
- Data Dictionary: Overview
- Configuring the Oracle Network Environment
- Oracle Net Services & Listener
- Establishing Net Connections
- Tools for Configuring and Managing the Oracle Network
- Net Services Administration Pages
- Naming Methods
- Directory Naming
- SGA and PGA
- When Not to Use a Shared Server
- Managing Database Storage Structures
- Storage Structures
- How Table Data Is Stored
- Anatomy of a Database Block
- Space Management in Tablespaces
- Tablespaces in the Preconfigured Database
- Actions with Tablespaces
- Oracle Managed Files (OMF)
- ASM: Concepts
- Administering User Security
- Database User Accounts
- Predefined Accounts: SYS and SYSTEM
- Administrator Authentication
- Benefits of Roles
- Predefined Roles
- Implementing Password Security Features
- Assigning Quota to Users
- Managing Schema Objects
- What Is a Schema?
- Accessing Schema Objects
- Specifying Data Types in Tables
- Creating and Modifying Tables
- Understanding Data Integrity
- Indexes & Views
- Sequences
- Temporary Tables
- Managing Data and Concurrency
- Manipulating Data Through SQL
- PL/SQL
- Administering PL/SQL Objects
- Functions, Procedures, Packages & Triggers
- Data Concurrency
- Enqueue Mechanism
- Resolving Lock Conflicts Using SQL
- Deadlocks
- Managing Undo Data
- Data Manipulation
- Transactions and Undo Data
- Undo Data Versus Redo Data
- Configuring Undo Retention
- Guaranteeing Undo Retention
- Using the Undo Advisor
- Viewing System Activity
- Implementing Oracle Database Security
- Industry Security Requirements
- Principle of Least Privilege
- Monitoring for Compliance
- Value-Based Auditing
- Fine-Grained Auditing
- DBA Auditing
- Security Updates
- Applying Security Patches
- Database Maintenance
- Introducing Terminology
- Optimizer Statistics
- Automatic Workload Repository (AWR)
- Automatic Database Diagnostic Monitor (ADDM)
- Advisory Framework
- Automated Maintenance Tasks
- Server-Generated Alerts
- Reacting to Alerts
- Performance Management
- Performance Monitoring
- Managing Memory Components
- Enabling Automatic Memory Management (AMM)
- Automatic Shared Memory Advisor
- Using Memory Advisors
- Dynamic Performance Statistics
- Troubleshooting and Tuning Views
- Invalid and Unusable Objects
- Backup and Recovery Concepts
- Part of Your Job
- Statement Failure
- User Error
- Understanding Instance Recovery
- Phases of Instance Recovery
- Using the MTTR Advisor
- Media Failure
- Archive Log Files
- Performing Database Backups
- Backup Solutions: Overview
- Oracle Secure Backup
- User-Managed Backup
- Terminology
- Recovery Manager (RMAN)
- Configuring Backup Settings
- Backing Up the Control File to a Trace File
- Monitoring the Flash Recovery Area
- Performing Database Recovery
- Opening a Database
- Data Recovery Advisor
- Loss of a Control File
- Loss of a Redo Log File
- Data Recovery Advisor
- Data Failures
- Listing Data Failures
- Data Recovery Advisor Views
- Moving Data
- Moving Data: General Architecture
- Directory Object: Overview
- SQL*Loader: Overview
- Data Pump: Overview
- Performance Initialization Parameters
- Using Enterprise Manager to Monitor Data Pump Jobs
- Data Dictionary
- Enhancing Database Capabilities
- Using EM Support Workbench
- Create a Service Request
- Package and upload diagnostic data to Oracle Support
- Track the SR and Implement Repairs
- Incident Packaging Configuration
- Working with Oracle Support
- MetaLink Integration
- Managing Patches
Benefits of taking the Oracle Database 11g: Administration Workshop I 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
- 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 |
|
|
|
|
May 15 2012 |
Great training! Great instructor!
-Fasika M.
|
| Course(s) Taken |
|
|
|
|
May 15 2012 |
This was a much needed and intensive training.
-Paul V.
|
| Course(s) Taken |
|
|
|
|
May 15 2012 |
Great experience! Geoff is awesome :-)
-Nadie H.
|
| Course(s) Taken |
|
|
|
|
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 |
|
|
|
|
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 |
|
|
|
|
Jul 02 2011 |
Very clean facilities, super friendly staff, knowledgeable instructor.
-Alma C.
|
| Course(s) Taken |
|
|
|
|
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 |
|
|
|
-
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 course
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
Contact us
|
Duration: 5 days (40 hours)
Pricing: Variable, please request
Why pricing varies..Why pricing varies..
Pricing depends on different training delivery methods, one or more students and availability of volume discounts or currently available promotions.
Our prices are frequently lower since we are able to work with our clients closely on their needs and pass on the optimum amount of savings.
In addition, we provide a price match guarantee for any competitive quotes. click to Live Chat
Click on a date to register.  Live Online Training available
New York, Jun 18, 2012
New York, Aug 25, 2012
New York, Sep 10, 2012
more..
For a customized version of this class, please contact us or call 1-888-563-8266.
|
|
 |
Need course pricing?
Need more information?
Worried about financing?
|
|
|
|
