Lee, This course should prepare a person for one of the two exams (other looks basic and topics would be covered) needed for the Oracle Database 11g Administrator Certified Associate. See http://tinyurl.com/3lxkmu for more information. -t On Jan 8, 2009, at 9:39 AM, Lee Duynslager wrote: > Troy: > > Will this course be in preparation for some type of Certification? > > LD > > From: MSU Network Administrators Group [mailto:[log in to unmask]] > On Behalf Of Troy Murray > Sent: Thursday, January 08, 2009 9:35 AM > To: [log in to unmask] > Subject: Re: [MSUNAG] Oracle Training > > Sorry, this course if typically taught over 5 days. > > -t > > > On Jan 8, 2009, at 9:32 AM, Timothy Woods wrote: > > > Troy, > > How long is the workshop? > > From: MSU Network Administrators Group [mailto:[log in to unmask]] > On Behalf Of Troy Murray > Sent: Thursday, January 08, 2009 9:23 AM > To: [log in to unmask] > Subject: [MSUNAG] Oracle Training > > NAG, > > I'm looking into some Oracle training, particularly the "Oracle > Database 11g: Administration Workshop I" course. The more people > that are interested, the better opportunity we can have something > locally here on campus. The cost would depend on the number of > people in the class. Anyone interested in this training course? > The description is as follows: > > 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 > > Course Topics > +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 > > > -- > Troy Murray > Systems/Database Administrator > Michigan State University > Biomedical Research Informatics Core (BRIC) > 100 Conrad Hall > East Lansing, MI 48824 > Phone: 517-432-4248 > Fax: 517-353-9420 > E-mail: [log in to unmask] > AOL IM: troymurray72 > > > -- > Troy Murray > Systems/Database Administrator > Michigan State University > Biomedical Research Informatics Core (BRIC) > 100 Conrad Hall > East Lansing, MI 48824 > Phone: 517-432-4248 > Fax: 517-353-9420 > E-mail: [log in to unmask] > AOL IM: troymurray72 > -- Troy Murray Systems/Database Administrator Michigan State University Biomedical Research Informatics Core (BRIC) 100 Conrad Hall East Lansing, MI 48824 Phone: 517-432-4248 Fax: 517-353-9420 E-mail: [log in to unmask] AOL IM: troymurray72