Oracle Database 11g Administration I
Duration: 5 Days
Oracle 11g Database Management Workshop course provides an educational starting point for administration of the Oracle database. The course begins with an in-depth discussion of the database architecture, then installing the Oracle software and creating an Oracle database are covered.
The Oracle instance, background processes, the SGA and memory structures are explored. As well as administering the initialization parameter file and the procedures for database startup and shutdown. Various models of data concurrency and consistency and alternative isolation levels are explained along with their uses.
A large portion of the class covers common administration tasks such as managing the use of disk space through data files, tablespaces, extents, blocks and rows, the UNDO tablespace and the online redo log.
The effective use of indexes is presented and how Oracle uses indexes to improve query performance.
Since so much access to Oracle’s features is based upon it, a comprehensive overview of the PL/SQL language is conducted, including stored procedures and database triggers.
All aspects of database user creation, maintenance and management are provided. Also including database security and controlling user access to database objects and resources.
There is a review of Oracle’s approach to the “self-tuning database” and the SQL Access and SQL Tuning advisors.
The Oracle data utilities SQL*Loader, Import data pump and Export data pump are described.
Finally an overview of backup and recovery concepts is given along with simple backup and recovery procedures.
Topics Covered In This Course
Part 1 Oracle Architecture
Part 2 Data Dictionary
Part 3 Installing Oracle 11g Enterprise Edition
Part 4 Database Creation
Part 5 Database Startup and Shutdown
Part 6 Managing the Initialization Parameter file
Part 7 Managing the System Global Area (SGA)
Part 8 Concurrency and Consistency
Part 9 Managing Database Storage
Part 10 Managing UNDO
Part 11 PL/SQL Overview
Part 12 Managing Database Users
Part 13 Controlling User Access
Part 14 Managing Database Security
Part 15 Creating Tables
Part 16 Maintaining Tables
Part 17 Creating Constraints
Part 18 Maintaining Constraints
Part 19 Effective Indexing
Part 20 Creating Other Schema Objects
Part 21 Working with Statistics
Part 22 Self-managing Database
Part 23 Loading and Moving Data
Part 24 Backup and Recovery Concepts
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.
This class provides preparation for the OCP Oracle Database 11g: Administration I 1Z0-052 test. Oracle Corporation suggests that candidates also have six months of hands-on experience before testing and undertake substantial self-study.
Who Should Take This Course
Oracle developers and novice DBAs
Oracle developers and DBAs wishing to ‘back fill’ gaps in their expertise
Oracle APEX, Forms and Reports developers
Technical managers needing Oracle expertise for project administration
Skill with GUI interfaces
Data processing background
An understanding of SQL is required to succeed in this class
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 [email protected]