Oracle 11g DBA

Duration : 40 Hours

Oracle Database 11g makes database infrastructure far more efficient, resilient, and manageable. For example, very compelling new features in the realm of partitioning ease the design and management of partitioned tables immensely. In this series (as in the previous series focusing on Oracle Database 10g), you will learn how these new features work via simple, actionable how-to’s and sample code.

1.Introduction.
  • Different types of oracle products and features.
  • New features in oracle 11g
  • Differences among oracle9i, oracle 10g and oracle 11g features along with its importance.
2.Installing oracle database 11g software.
  • System requirements.
  • Redhat Linux 5.0 Installation (with and without Vmware workstation)
  • Installation of multiple oracle servers and multiple oracle databases on Vmware workstation (features and advantages for RAC implementation with Vmware configuration)
  • Install software with the Oracle Universal Installer on Linux Platform
3. Creation of an oracle database.
  • Oracle Database 11g 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 and architecture of Oracle 11g DBA
  • 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. User Management.
  • 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
  • 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. Oracle Enterprise Manager and Performance tuning
  • New features and its analysis of statistics on performance Tuning
17. Proactive Maintenance
  • Contents
  • Optimizer statistics
  • Automatic Workload Repository
18. Flashback.
  • Introduction
  • Configuration
  • Flashback Query/Table/Drop/Database
  • Flashback Version Query
  • Creating Restore Points
19. Automatic Storage Management. ·         New features and implementation 20. Oracle Grid Control.
  • Introduction
  • Architecture
  • Managing the multiple database nodes using OEM grid control
21. Data Replication and Integration ·         Oracle database 11g streams features overview ·         Oracle database 11g streams (Data Replication and Integration) Courses Offered in Our Training Institute:
  •  Android
  • Cognos 8 BI & Tm1
  • Data Stage
  • DB2 DBA
  • Dot Net
  • DAC
  • Hyperion Essbase , Planning
  • IBM AIX Administration
  • 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
  • I Phone
  • 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       11g
  • Oracle Fusion SOA , B2B,
  • Oracle SQL , PL SQL
  • PHP
  • Perl Scripting
  • SAP       SD & BO & ABAP
  • Sales Force CRM
  • SharePoint Server 2010
  • Shell Scripting
  • 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)

Reviews

No reviews

Post Review

Name
Email
Review Title
Rating
Review Content
View All Categories

Quick Enquiry

Technology Portfolio