Oracle 10g DBA Course Curriculum

Course Duration - 60hrs

1.Introduction.

• Identify the oracle product

2.Installing oracle database 10g software.

• System requirements.
• Redhat Linux Installation
• Install software with the Oracle Universal Installer on Linux Platform

3.Create an oracle database.

• Oracle Database Architecture
• Oracle instance architecture
• Oracle Read Consistency and Concurrency

4.Controlling the database

• Start and stop the enterprise manager database console
• Start and stop the listener
• Startup and shutdown the database

5.Database Creation.

• Manual
• Database Configuration Assistant(DBCA)

6.Storage Structures.

• Logical structure Vs Physical structure
• Defining the tablespaces and data files
• Create tablespaces
• Manage tablespaces
• Obtain tablespace information
• Managing Undo Data

7.File Management.

• Control File Management
• Redo Log File Management
• Parameter File Management
• Obtain tablespace information

8.Administering users .

• Create and manage database user accounts
• Roles
• Privileges
• Control resource usage by using Profiles

9.Oracle Net Services.

• Understand Oracle Net concepts
• Use Oracle Net Manager to create and configure listeners
• Use the listener control utility to control the Oracle Net Listener
• Testing Oracle Net connectivity
• Shared Server: Connection pooling

10.Managing schema objects.

• Create and modify tables
• Define constraints
• View the attributes of a table
• View the contents of a table
• Create indexes and views

11.Oracle Backup & Recovery (User Managed).

• Introduction
• Design, Testing, Implementation Strategies
• Offline(cold)/Online(hot) backups
• Performing Complete Recovery
• Performing Incomplete Recovery

12.Oracle Backup & Recovery (System  Managed: RMAN).

• Introduction
• RMAN Architecture
• Configuration
• Setting up Catalog
• Online/Offline Backup using RMAN
• Backups Options
• Incremental Backups
• Image copies
• Scripts,
• Complete Recovery
• Incomplete Recovery
• Table Space Point in Time Recovery (TSPITR)
• Disaster Recovery

13.Cloning.

• RMAN
• Manual

14.Logical Backup & Transporting data between databases.

• Introduction Data pump (expdp, impdp)  Utilities
• Exporting/Importing Tables
• Exporting/Importing Schemas
• Exporting/Importing Table space
• Exporting/Importing Database
• Transportable Table space within & across the database and platforms

15.High Availability(HA).

• Database Patch Management Introduction
• Applying Interim and Patch set Patches
• Patch History & Documentation

16.Proactive Maintenance

• Contents
• Optimizer statistics
• Automatic Workload Repository

17.Flashback.

• Introduction
• Configuration
• Flashback Query/Table/Drop/Database
• Flashback Version Query
• Creating Restore Points

18.Automatic Storage Management.

19.Oracle Grid Control.

• Introduction
• Architecture
• Managing the multiple database nodes using OEM grid control

Courses Offered in Our Training Institute:

• Android
• Cognos 8 BI
• Data Stage
• DB2 DBA
• Dot Net
• Hyperion Essbase , Planning
• IBM Lotus Notes (Development)
• IBM Lotus Notes Domino Server Administration
• IBM Message Broker
• IBM MQ Series
• IBM Web Sphere Application Server Administration (WAS)
• IBM WAS Portal server Development
• Informatica
• Java/J2EE          
• MicroSoft .NET Technologies (VB.NET, C#, ASP.NET)
• Microstrategy
• MicroSoft Business Intelligence
• MicroSoft Dynamics CRM
• OBIEE 11 g
• Oracle APPS –  HRMS
• Oracle APPS –  SCM
• Oracle APPS –  Financial
• Oracle APPS – Technical
• Oracle BI Apps  
• Oracle BI Publisher
• Oracle DBA
• Oracle Fusion SOA , B2B, 
• Oracle SQL , PL SQL
• PHP
• SAP  SD  &  BO & ABAP
• SharePoint Server 2010
• Siebel CRM , EAI, E-Scripting
• SQL Server DBA
• Springs and Hibernate
• Testing Tools  - QTP, QC, Load Runner, Selenium
• TIBCO BW, BE, CIM, TIBCO I Process
• WCF, WPF, LINQ,  AJAX, SILVER LIGHT
• Webmethods
• Webservices   , SOAP ( JAVA)

Visit  www.futurepointtech.com for course curriculum

Drop a mail info@futurepointtech.com  we will get in touch with u