ASP.NET, VB.NET, and C# Training Classes     
Accelebrate delivers SharePoint , ASP.NET, SQL Server, Java, and other training courses in the USAAccelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Canada     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in the UK     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Ireland     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in the Netherlands     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses internationally  
1 877 849 1850   0808 234 2132   1 800 550 311   0 800 022 6730   +1 678 648 3113  
Microsoft and .NET TrainingSQL Server TrainingSharePoint TrainingJava TrainingAdobe TrainingDatabase and Reporting TrainingXML, JavaScript, and Other TrainingWeb/Application Server Training
HomeAboutContact Us 


Please contact us
for GSA pricing.

GSA - Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses
Contract #
GS-35F-0307T



Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

  • Huntsville, Alabama
  • Montgomery / Birmingham, Alabama
  • Anchorage, Alaska
  • Edmonton & Calgary, Alberta
  • Phoenix, Arizona
  • Tucson, Arizona
  • Fayetteville / Little Rock, Arkansas
  • Amsterdam, The Netherlands / Brussels, Belgium
  • Vancouver, British Columbia
  • Oakland / San Jose / San Francisco, California
  • Sacramento, California
  • San Diego, California
  • Orange County / Los Angeles, California
  • Boulder / Colorado Springs / Denver, Colorado
  • Washington, DC
  • Wilmington, Delaware
  • Manchester / London, England
  • Orlando, Florida
  • Fort Lauderdale / Miami, Florida
  • Jacksonville, Florida
  • Saint Petersburg / Tampa, Florida 
  • Alpharetta & Atlanta, Georgia
  • Augusta & Savannah, Georgia
  • Boise, Idaho
  • Chicago, Illinois
  • Indianapolis, Indiana
  • Cedar Rapids / Des Moines, Iowa
  • Dublin, Ireland
  • Wichita, Kansas
  • Lexington / Louisville, Kentucky
  • Baton Rouge/New Orleans, Louisiana
  • Portland, Maine
  • Hagerstown & Frederick, Maryland
  • Annapolis / Baltimore, Maryland
  • Boston / Cambridge, Massachusetts
  • Hartford, Connecticut / Springfield, Massachusetts
  • Ann Arbor / Detroit, Michigan
  • Grand Rapids, Michigan
  • Saint Paul / Minneapolis, Minnesota
  • Jackson, Mississippi
  • St. Louis, Missouri
  • Kansas City, Missouri
  • Lincoln / Omaha, Nebraska
  • Reno and Las Vegas, Nevada
  • Fredericton / Moncton / Saint John, New Brunswick
  • Albuquerque, New Mexico
  • Princeton, New Jersey & Philadelphia, Pennsylvania
  • Albany, New York
  • Buffalo, New York
  • White Plains / New York City, New York
  • Charlotte, North Carolina
  • Durham / Raleigh, North Carolina
  • Canton / Akron, Ohio
  • Cincinnati, Ohio
  • Cleveland & Columbus, Ohio
  • Dayton, Ohio
  • Tulsa / Oklahoma City, Oklahoma
  • Toronto, Ontario
  • Portland, Oregon
  • Pittsburgh, Pennsylvania
  • San Juan, Puerto Rico
  • Providence, Rhode Island
  • Saskatoon / Regina, Saskatchewan
  • Edinburgh / Glasgow, Scotland
  • Columbia & Charleston, South Carolina
  • Spartanburg & Greenville, South Carolina
  • Knoxville, Tennessee
  • Memphis / Nashville, Tennessee
  • Houston, Texas
  • El Paso, Texas
  • San Antonio / Austin, Texas
  • Dallas, Texas
  • Salt Lake City, Utah
  • Fairfax / Dulles / McLean / Herndon / Reston, Virginia
  • Richmond / Alexandria / Arlington, Virginia
  • Virginia Beach / Norfolk, Virginia
  • Tacoma / Seattle, Washington
  • Charleston, West Virginia
  • Madison / Milwaukee, Wisconsin

 

Oracle Administration Training: Oracle 11g Administration I

Print This Outline
E-mail This Outline
Get A Quote
Course Number: ORC-204
Duration: 5 days
view class outline

Oracle 11g Administration Training Overview

This Oracle 11g administration training course teaches attendees the skills necessary for day-to-day administration of Oracle® 11g.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals.  To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=category&page=oracle.

Oracle 11g Administration Training Prerequisites

No prior experience is presumed.

Hands-on/Lecture Ratio

This course is 60% hands-on, 40% discussion, with the longest discussion segments lasting 20 minutes.

Oracle 11g Administration Training Materials

All students receive comprehensive courseware and a related textbook.

Software Needed on Each Student PC

  • A complete installation of Oracle 11g

Please contact us for detailed setup instructions if you have purchased this class.

Oracle 11g Administration Training Objectives

All attendees will learn how to:

  • Configure the Linux and MS Windows operating systems in anticipation of a database installation
  • Install Oracle 11g R2 Enterprise Edition database
  • Verify a valid database installation
  • Use database administrator interface options
  • Uninstall the database
  • Patch online software
  • Startup and shutdown database services and related software components
  • Use super administrator authentication options
  • Explore the database architecture, including memory, process and data structures, and the management of those structures
  • Manage database files.
  • Use specialized facilities intended to maximize performance of enterprise-scale transactional applications
  • Manage security policies and procedures, including administration of user accounts, roles, privileges and profiles
  • Use advanced self-tuning and self-management capabilities
  • Monitor preformance, troubleshoot problems, and resolve lock and conflict issues
  • Use the Oracle Enterprise Manager and SQL interfaces for administration tasks
  • Gain gontrol over database support services, including the Database Control, Oracle Net and others
  • Backup and recover
  • Operate system-specific considerations for various platforms, especially Linux and MS Windows

Oracle 11g Administration Training Outline

  • Introduction
  • Configuring The Server For Installation
    • Identify System Requirements
    • Optimal Flexible Architecture (Ofa)
    • Oracle_Base
    • Oracle_Home
    • Configure Linux Installation
    • Configure Ms Windows Installation
    • Prerequisite Checks and Fixup Utility
  • Enterprise Edition Installation
    • More About The Installation
    • Start The Installation
    • Desktop Class Installation 11g R2
    • Server Class Installation 11g R2
    • Post-Installation Configuration
  • Verify The Installation
    • Accessing The Em Database Control
    • Using The Em Interface
    • Using Sql*Plus
    • Using Em Sql Worksheet
    • Using Ssh
  • Upgrade, Deinstallation and Patching
    • Database Upgrade
    • Netca
    • Dbua
    • Online Patching
    • Oracle Deinstaller
  • Manually Starting and Stopping Database Services
    • Starting and Stopping Database Control
    • Starting and Stopping The Listener
    • Starting and Stopping The Database
    • Sysdba
  • Exploring The Oracle Database Architecture: General
    • The Oracle Enterprise Architecture
    • General Database Architecture
    • V$Version
  • Exploring The Oracle Database Architecture: Instance Memory
    • More About Database Instances
    • Using V$Sga_Dynamic_Components
    • About The Pga
    • Managing Memory
  • Exploring The Oracle Database Architecture: Instance Processes
    • Instance Background Processes
    • Sql Execution Processes
    • Using V$Session
  • Creating An Oracle Database
    • Create A New Database
    • Configure An Existing Database
    • Drop A Database
    • Manage Dbca Templates
    • Manually Create A Database
    • More About The Database Files
  • Enabling Transparent Data Encryption
    • Transparent Data Encryption
    • Managing Tde
    • Implementing Column Encryption
  • Manage Database Storage Structures: Tablespaces
    • About Tablespaces
    • Tablespace Management
    • Autoextend Options
    • Drop Tablespace
    • Alter Tablespace
  • Manage Database Storage Structures: Advanced Tablespaces
    • More About Temporary Tablespaces
    • Using V$Sort_Segment
    • About Temporary Tablespace Groups
    • More About Permanent Tablespaces
    • About Database_Properties
    • More About Bigfile Tablespaces
    • More About The Sysaux Tablespace
  • Manage Database Storage Structures: Data Files and Temp Files
    • Managing Data Files
    • Managing Temp Files
    • Enable Oracle-Managed Files (Omf)
  • Managing Undo Data
    • About Undo Space Management
    • Configure Undo Management
    • Undo_Management
    • Undo_Tablespace
    • Undo_Retention
    • Guarantee Undo Retention
    • Monitor Undo Space
    • Use The Undo Advisor
  • Network Environment: Oracle Net Services
    • Oracle Net Services Architecture
    • Oracle Net Configuration Assistant
    • Oracle Net Manager
    • Configuration Using Em
    • Troubleshooting Network Problems
    • Countering Database Attacks
  • Network Environment: Oracle Shared Servers
    • Shared Servers Architecture
    • Configure Shared Servers
    • Monitor Shared Servers
    • V$Shared_Server
    • V$Shared_Server_Monitor
    • V$Session
    • V$Circuit
    • V$Dispatcher and V$Dispatcher_Config
    • V$Queue
  • Security: Implementing Database Security
    • Database System Privileges
    • Database Object Privileges
    • Auditing Of Database Activity
    • Audit_Trail Parameter
    • Enhanced Default Security Settings
  • Security: Administering User Security
    • Create and Manage Database Accounts
    • Grant and Revoke Database Privileges
    • Resource Limits Via Profiles
    • Alter Profile
    • Drop Profile
    • Password Management Via Profiles
    • About Role-Based Security
    • With Admin Option
    • With Admin Option and System Privileges
    • With Grant Option and Object Privileges
    • Alter User...Default Role
    • Set Role
    • Enhanced Default Security Settings
    • Sec_Case_Sensitive_Logon Setting
  • Moving Data: Sql Loader
    • Loader Concepts
    • Control File Options
    • Load Methods
    • Using The Em Interface
  • Moving Data: Export and Import
    • Manage Directory Objects
    • About The Data Pump Architecture
    • Data Pump Import
    • Data Pump Data Dictionary Views
    • Using The Em Interface
  • Database Maintenance and Performance Monitoring
    • Management and Advisory Framework
    • Manage Awr
    • Addm
    • Use Metrics and Alert Thresholds
    • Automatic Maintenance Tasks
  • Managing Concurrency and Locks
    • About Latches and Locks
    • Manage and Monitor Latches
    • V$Lock
    • V$Locked_Object
    • V$Session
    • V$Session_Wait
    • Dba_Blockers and Dba_Waiters
    • Dba_Dml_Locks and Dba_Ddl_Locks
    • Dml_Locks
  • Backup and Recovery Concepts and Configuration
    • About Backup and Recovery Structures
    • Managing Redo Data
    • Managing Archival Data
    • Automatic Crash Recovery
  • Conclusion

© 2008 Sideris Courseware Corporation

 

Print This OutlineE-mail This OutlineGet A Quote


Java® and all Java-based marks are registered trademarks of the Oracle Corporation in the U.S. and other countries.

Oracle® is a registered trademark of the Oracle Corporation in the U.S. and other countries.

MySQL™ and all MySQL-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the U.S. and other countries.

 
Request Information for Group Training at Your Site   Request Information for Group Training at Your Site
 
Accelebrate®
Focuses on You!


Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.

For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.

             
               

VB.NET, C#, ASP, & ASP.NET Training Java Training SQL Server Training
SharePoint Training  Adobe Training PHP Training XML Training Perl Training Sitemap

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | Sacramento, CA | San Diego, CA | San Francisco, CA | San Jose, CA | Denver, CO | Washington, DC | Jacksonville, FL | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | Las Vegas, NV | Albany, NY | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Dayton, OH | Oklahoma City, OK | Toronto, ON | Portland, OR | Philadelphia, PA | Pittsburgh, PA | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | San Antonio, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK