Oracle Database 11g: Administration I Courses and other IT courses from TEKsystems Education Services

Note: All fields are required

First Name:

Last Name:

Company:

Title:

Email Address:

Phone Number:

Address:

City:

State:

Zip Code:

Which Topic(s) Currently Interests Your Organization:

Tell Us More:

I have an immediate training or educational service need and I wish to be contacted today

I am a current TEKsystems Education Services client and wish to speak to someone

I have a training budget approved and I am ready to talk to someone about the details of my organization’s training need

I do not have an approved training budget, but I have a need and would like to talk to TEKsystems Education Services about their solutions

Unfortunately, I do not have a group training request

At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.

My Delivery Method Needed Is:

Instructor-Led Classroom Training

Instructor-Led Virtual Training

Self-Paced Online Training

Code Number:

We Value Your Privacy!

Course Code:	RT 511
Course Abstract:	The overall objective of this course is to allow the participant to gain the skills necessary for day-today administration of an Oracle database. This course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification. Certification Examination This course along with its prerequisites cover information necessary to complete the certification test Exam #1Z1-052 Oracle Database 11g: Administration I.
Audience:	This course is designed for individuals who are Oracle database administrators. Oracle web server and application server administrators, as well as others who must manage an embedded repository database using Oracle database technology will also find this information useful. This course is also recommended for technical consultants, support engineers, project managers and other technical management and support personnel.
Duration:	5 days
Learning Outcomes:	Upon completion of this course, the participant will be able to: > Software installation and the creation of new databases. > An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures. > Management of database files. > Specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the result cache, the database buffer cache, and other similar components. > Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles. > Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework. > Performance monitoring, problem troubleshooting, and resolving lock and conflict issues. > Using the Oracle Enterprise Manager and SQL interfaces for administration tasks. > Control over database support services, including the Database Control, Oracle Net and others. > A primer on backup and recovery structures and strategies. > Operating system-specific considerations for various platforms, especially Linux and MS Windows Server.
Course Topics:	Enterprise Edition Installation Identify System Requirements The Optimal Flexible Architecture (OFA) Oracle_Base Oracle_Home Configure the Installation Environment Enterprise Edition Installation DBCA The Administrator Interface Enterprise Manager Tour Using EM SQL Worksheet Duties of a Database Administrator Exploring the Oracle Database Architecture: General The Oracle Enterprise Architecture Exploring The Oracle Database Architecture: Instance Memory What is an Oracle Database Instance? More about the System Global Area (SGA) About the PGA Managing Memory Exploring The Oracle Database Architecture: Instance Processes Instance Background Processes SQL Execution Processes Creating An Oracle Database Create a New Database Configure an Existing Database Drop a Database Manage DBCA Templates Manually Create a Database Managing The Database Instance Configuring a Linux Environment Starting & Stopping Database Control Starting & Stopping the Database Listener Starting & Stopping the Database Instance More about the Database Files Manage Database Storage Structures: Tablespaces About Tablespaces Tablespace Management Drop Tablespace Alter Tablespace Manage Database Storage Structures: Advanced Tablespaces More about Temporary Tablespaces About Temporary Tablespace Groups More about Permanent Tablespaces More about Bigfile Tablespaces More about the Sysaux Tablespace Manage Database Storage Structures Data Files & Temp Files Managing Data Files Managing Temp Files Enable Oracle-Managed Files (OMF) Managing UNDO Data About UNDO Space Management Configure Automatic UNDO Management UNDO_MANAGEMENT UNDO_TABLESPACE UNDO_RETENTION Guarantee UNDO Retention Monitor UNDO Space Use the UNDO Advisor 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 & V$DISPATCHER_CONFIG V$QUEUE Security: Implementing Database Security Database System Privileges Database Object Privileges Administrator Auditing of Database Activity Enhanced Default Security Settings Security: Administering User Security Create & Manage Database Accounts Grant & Revoke Database Privileges Resource Limits Via Profiles Alter Profile Drop Profile Password Management Via Profiles About Role-Based Security With Admin Option Alter User...Default Role Set Role Enhanced Default Security Settings Moving Data: SQL Loader Loader Concepts Control File Options Load Methods Using the EM Interface Moving Data: Export & Import Manage Directory Objects About the Data Pump Architecture Data Pump Export Data Pump Import Data Pump Data Dictionary Views Using the EM Interface Database Maintenance & Performance Management The Management & Advisory Framework Manage the Automatic Workload Repository Automatic Database Diagnostic Monitor Use Metrics & Alert Thresholds Automatic Maintenance Tasks Managing Concurrency & Locks About Latches & Locks Manage & Monitor Latches Manage & Monitor Locks V$LOCK V$LOCKED_OBJECT V$SESSION V$SESSION_WAIT DBA_BLOCKERS & DBA_WAITERS DBA_DML_LOCKS & DBA_DDL_LOCKS DML_LOCKS Backup & Recovery Concepts & Configuration About Database Backup & Recovery Structures Managing Redo Data Managing Archival Data Automatic Crash Recovery Creating a Basic Backup Strategy
Prerequisites:	Many participants taking this course have familiarity with system administration and administration of other non-Oracle databases, and this is helpful though not mandatory. Specific course prerequisites for this course are: Oracle Database 11g: SQL Fundamentals – Complete Library Oracle Database 11g: Program With PL/SQL – Complete Library

Oracle Database 11g: Administration I Course

Hot Courses

Top Skills

Testimonials

Agile
AJAX and Web 2.0
Business Analysis
Business Practices
Cisco
Communications
Customer Service/Communications
Data Warehousing
Database Developer
End User
Enterprise Architecture
Internet Application Developer
Lotus
Mainframe
Messaging Infrastructure
Networking
Operating Systems
Programming Languages
Programming Methodologies
Project Management
Project Management
Quality Assurance
Relational Databases
Reporting Tools
SAP
Scrum Master
Security
Server Applications
SQL & PL/SQL Programming
Testing
Testing and Quality Assurance
Virtualization
Web Technologies
Wireless Technology