|
Provided by: Affinity IT Training, LLC Oracle Database 11g Administration I |
 |
Training
Provided by Affinity IT Training, LLC
The overall objective of this course is to allow the student 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.
Audience:The primary target audience for this course is 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.
|
|
||||||||||
Oracle Database 11g Administration I
Objectives
- 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.
Outline
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
Setup
- Access to Oracle 11g
- Accounts and databases for all Students and Instructor
Seminar Pre-Requisites
- Oracle Database 11g: SQL Fundamentals - Complete Coverage
- PL/SQL Fundamentals - Complete Coverage
Training Materials
- Course Workbook
Feb08
About The Training Provider: Affinity IT Training, LLC
Affinity IT Training, LLC - .
We are a provider of hands-on, instructor-led IT training for the global business community including website development, databases, programming languages and more. Training includes: ASP, .NET, C#, C , DB2, AJAX, JavaScript, HTML/XHTML/XML, Unix, Linux, Perl, Python, Ruby On Rails, Oracle, Sybase, SQL Server, Project Management Training and customized Integrated Case Study.
