Oracle Database 11g Administration I
Duration: 5 Days
Administration of the Oracle database management system (DBMS) software environment and of the server systems on which the DBMS runs is one of the primary tasks required of Database Administrators and Oracle technical support staff such as Unix/Linux/Windows administrators. Oracle Database 11g: Administration I class enables the DBA and other technical support to acquire and develop skills to effectively and holistically administer an Oracle11g RDBMS from top to bottom. A great option of this class is that it can be customized to be delivered on either a Windows or Unix/Linux OS platform to suit the client???s needs. The overall objective of this course is to allow the student to gain the skills necessary for day-to-day administration of an Oracle database. This course sets the foundation for advanced administrator training and certification.
Topics Covered In This Course
Configuring the Server for Installation
Installation of Oracle11g
Verifying the Installation
Upgrade, De-installation &Patching
Manually Starting and Stopping Database Services
Exploring the Oracle Database Architecture: General
Exploring the Oracle Database Architecture: Instance Memory
Exploring the Oracle Database Architecture: Instance Processes
Creating an Oracle Database
Enabling Transparent Data Encryption
Manage Database Storage Structures
Manage Database Storage Structures: Advanced
Manage Database Storage Structures: DATA FILES &TEMP FILES
Managing UNDO Data
Oracle Network Environnent: Oracle NET Services
Oracle Network Environnent: Oracle Shared Servers
Security : Implementing Database Security
Security : Administering USER Security
Moving Data : SQL*Loader
Moving Data : EXPORT &IMPORT
Database Maintenance &Performance Monitoring
Managing Concurrency and Locks
Backup &Recovery Concepts and Configuration
What You Can Expect
Oracle Database 11g: Administration I class enables the student participants to acquire and develop key skills to effectively administer an Oracle11g RDBMS. The participants will learn to configure and start up the Oracle instance and memory components and create the Oracle database Enterprise Manager repository. The student participants will create physical and logical database objects, utilize many of the advanced features of the Oracle Enterprise Manager and the integrated Oracle Data Dictionary to monitor and maintain the Oracle11g database. In addition, they will be introduced to Oracle Backup and Recovery using the RMAN utility and also learn how to secure access to the Oracle database objects with privileges, roles and profiles. Many exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience.
Who Should Take This Course
Web Server Administrators
Data Center Support Engineers
Senior application designers and developers
Oracle Database: SQL Fundamentals
Oracle Database: SQL-PL/SQL Fundamentals
Relational Database Design and Concepts
Instructor Led with typically 50% lecture and 50% lab.
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at firstname.lastname@example.org