Oracle Database 11g Administration Workshop I ekit

Document Sample
Oracle Database 11g Administration Workshop I ekit Powered By Docstoc
					                                                                                                                                                                   Course Length

                                        Oracle Database 11g: Administration Workshop I (ekit)                                                                            5 Days

    Course Description: This course class, studentsgive students a firm foundation in basic administration of Oracle Database
                                     is designed to
                        11g. In this                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.

    Who Should Attend: This Database for Database Administrators, Support Engineers, Developers, Technical Administrators,
                            course is
                       and            Designers.
                                    Students must have working knowledge of SQL. It is also recommended that students have taken
    Prerequisites:                  Oracle Database 11g: Introduction to SQL.

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