IT Training Courses
IT Training Courses
 

Do you need IT and Project Management Training ?

COMNet Group can help!  Please call our support numbers now:

 

Illinois:  (847) 458-8281

 

North Carolina: 

 

Charlotte Area: (704) 909-2792

 

RTP Area: (919) 827-4364


or send us an email at info@comnetgroup.com.

LOCATIONS:

ILLINOIS:

 

Schaumburg/Hoffman Estates Area:

 

COMNet Group Inc.

2815 Forbs Avenue, Suite 107

Hoffman Estates, IL 60192

 

Oak Brook and Naperville Area:

 

COMNet Group Inc.

4320 Winfield Road, Suite 200

Cornerstone @Cantera

Warrenville, IL 60555

 

Gurnee/Waukegan/Grayslake/Lake Forest Area:

 

COMNet Group Inc.

100 Saunders Road, Suite 150

Lake Forest, IL 60045

 

NORTH CAROLINA:

 

University Executive Park Area

CHARLOTTE:

 

COMNet Group Inc.

301 McCullough Drive, Suite 400

Charlotte, NC 28262

 

Phone: (704) 909-2792

 

DURHAM:

 

2530 Meridian Pkwy, Suite 200

Durham, NC 27713

 

Phone: (919) 827-4364

 

RALEIGH:

 

4208 Six Forks Road, Suite 1000

Raleigh, NC 27609

 

Phone: (919) 827-4364

 

ORACLE Database Administration 11g


Overview

This Oracle 11g training course will allow the student to gain the skills necessary for day-to-day administration of an Oracle database. 

Who Should Attend
The primary audiences for this course are: Database administrators Web server administrators System administrators Implementation specialists Data center support engineers senior application designers and developers

 

Outline


Lesson 1: Installation and Upgrade Volume

Configuring the Server for Installation 
Enterprise Edition Installation 
Verify the Installation 
Upgrade, Deinstallation and Patching


Lesson 2: 

Manually Starting & 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 Databases Storage Structures: Table Spaces 
Manage Database Storage Structures: Advanced Table Spaces 
Manage Database Storage Structures: Data Files & Temp Files 
Managing Undo Data


Lesson 3: 

Network Environment: Oracle Net Services 
Network Environment: 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 & Locks 
Backup and Recovery Concepts and Configuration


Lesson 4: Volume A: Advanced Database Administration

Managing Memory 
Managing Storage & The Segment Advisor 
Globalization 
Diagnosing Database Problems 
Recovery Concepts 
Oracle Flashback Technology 
Flashback Database & Flashback Data Archive


Lesson 5: Volume B: Resource Manager & Scheduler

Managing Resources 
Automating Tasks with the Scheduler (Basic) 
Automating Tasks with the Scheduler (Advanced) 
Managing Database Performance


Lesson 6: Volume C: RMAN Backup & Recovery

Instance Recovery 
Configuring RMAN 
Backup with RMAN 
RMAN Management with EM 
User-Managed Recovery Operations 
Recovery with RMAN 
Using the RMAN Recovery Catalog 
Database Duplication & Cloning 
Advanced RMAN Capabilities 
Transporting Table Spaces 
Recovering From Corruption with Data Recovery Advisor


Course Number:

OracleDBA-CGI001

Print Print | Sitemap
© COMNet GROUP INC. 2005-2017 All Rights Reserved.