Oracle DBA 11g RAC Data Guard DB2 DBA Online Training @ FUTUREPOINT
Training Type : Online
Course Fee : N/A
Contact Person : RAM
Batch Timings : N/A
Oracle 11g DBA Course Content
Pre requisites : Basic SQL*plus script
knowledge is needed
|
|
|
|
- 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.
- Installing
oracle database 10g 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.
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)
Visit www.futurepointtech.com for course
curriculum
Drop a mail info@futurepointtech.com we will get in touch with u
About the Institute :
Sun Informatics concentrates only on ONLIEN Training.
About Training Center :
Future Point Technologies is a Eight Years old leading Software Training center based in Hyderabad. The Future Point Technologies is an Institute dedicated to teaching Core Computer Technologies to students and professionals.
FUTUREPOINT Offers CLASS Room, ONLINE and CORPORATE Trainings.
• ATTEND THE DEMO AND CHECK THE QUALITY OF OUR EXPERIENCED TRAINERS
We offer Online Training , so you get trained from where you are from our experienced trainers, In the weekdays as well as weekends by the Real Time Professionals .
The program is designed to provide rich learning experience for students using Internet .
Courses Offerings
• Android
• AIX Administration
• Business Analyst
• CCNA, CCNP Security
• Citrix XenApp
• Cognos 10 BI & Tm1
• Crystal Reports
• Data Stage
• DB2 DBA
• Dot Net
• DAC
• Google Web Tool Kit
• IBM Lotus Notes (Development)
• IBM Lotus Notes Domino Server Administration
• IBM Message Broker
• IBM MQ Series
• IBM Tivoli Access Manager
• IBM Web Sphere Application Server Administration (WAS)
• IBM WAS Portal server Development
• IBM Websphere Transformation extender (WTX 8.2)
• Informatica
• I Phone
• Java/J2EE
• J Query
• 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 RAC
• Oracle Fusion SOA
• Oracle SQL , PL SQL
• PHP
• Perl Scripting
• SAP SD , BO , FICO , BI / BW , APO , BPC, BASIS
• Sales Force CRM
• SharePoint Server 2010
• Shell Scripting
• Siebel CRM , EAI, E-Scripting
• SQL Server DBA
• Springs and Hibernate
• Storage Area Network ( SAN)
• Tera Data
• Testing Tools - QTP, QC, Load Runner, Selenium, ISTQB
• TIBCO BW, BE, TIBCO I Process
• Tivoli Access Manager
• Unix Administration
• VN Ware
• WCF, WPF, LINQ, AJAX, SILVER LIGHT
• Webmethods
• Webservices , SOAP ( JAVA)
Drop a mail info@futurepointtech.com we will get in touch with u
Address / Colony :
S.R.Nagar
Srinivasa colony
City :
HYDERABAD
Website :
www.suninformatic.in