Main Office: | 800.631.0410 | |
---|---|---|
Sales Office: | 800.533.3893 |
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.
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.
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.
Code | Course Title | Duration | Level | |
---|---|---|---|---|
OR18NEW |
Oracle12c -18c New Features For Administrators (Five Days) |
5 Days |
I |
Details |
OBIAD |
Oracle BI 11g - System Administration |
4 Days |
I |
Details |
OR1212NF |
Oracle12c Release 1 & 2 New Features For Administrators |
5 Days |
I |
Details |
OR12NEW |
Oracle12c New Features For Administrators |
5 Days |
II |
Details |
OR11A2 |
Oracle Database 11g Administration II & Backup and Recovery Workshop |
4 Days |
II |
Details |
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.