Oracle DBA Training Course

Overview

Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in today's organizations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers. .

All the above tasks are performed with the help of a Database Management System (DBMS) and the leading and most widely used DBMS across the world today are the Oracle Database, Microsoft SQL Server, MySQL database etc. Out of the three DBMS technologies, Oracle Database is the most popular and widely used database in the world today.

Salaries

DBAs play an important and responsible role in every company's Information Technology (IT) department. DBAs are also very well paid and the average annual salary is more than $100,000 in the USA. Click here for more details on DBA Salaries.

 

Furthermore, it is projected that the demand for DBAs will grow at the rate of 20% per year until 2020. www.cnn.com also published an article recently that Database Administrators stand # 7 out of 100 BEST AMERICA JOBS

The leading technology job portal in the United States www.dice.com reported in 2010 that DBAs stand 5th in the "Most Difficult to Fill" IT job.

 

Oracle DBA Training

 

We are currently offering a world class oracle database administration training programme for interested students and professionals. Registration for our Oracle classes is open for anyone in the world because it is an online course.

 

Course Highlights

 

1. Taught by Srini Ramneni (strong work ethic, polite and professional)
2. 60 hour course with 14 classes approximately, each class runs for 4 hours on Saturday and Sunday.
3. Saturday, Sunday - 9 am to 1:30 pm CENTRAL TIME (with a 30 MIN Break)
4. Remote LAB access, Total approx. 250 hours for each student. 10 hours each Saturday and Sunday, 5 hours each Tuesday to Friday.
5. Click HERE to download the training brochure (course topics and more details)

6. Home work assignments to the students to challenge on course topics.
7. Students can use the training to prepare for some of the topics related to Oracle certification exams, though the main focus is job readiness.
8.Training contains Oracle database fundamentals as well as advance topics such as Oracle RMAN, Oracle ASM, RAC etc.
9. US $799 only for the entire course. Click HERE to REGISTER for Training (OR) FREE DEMO SESSION
10. Every student in the training gets our training practice tutorials and materials which are around 300 pages.

Course Topics

Introduction to database management systems and databases

What is a database?
Popular database management system (DBMS) software and why Oracle DBMS
History and Current trends of DBMS and Database Administration
Tasks of a Database Administrator

Relational Database Model and Installing Oracle database software

Entity Relational (ER) Model Overview
Installation of Oracle database software (Oracle DBMS)

Oracle Database Architecture

Creation of the first Oracle database.
Startup and Shutdown of a database
Components of an Oracle database and detailed architecture
Advance Startup and Shutdown Scenarios

Database storage

Tablespaces and allocation types
Create tablespaces
Create datafiles with fixed size and autoextend option
Control files
How to rename datafiles in a controlfile
Redolog groups and members
Archivelog mode for a database

Oracle Networking

Introduction
Oracle listener configuration
Oracle database connections from other computers
Oracle listener administration and TNS_ADMIN environment variable
Database Links

Used Managed (Manual) Backup and Recovery

Introduction
Cold Backup (offline backup)
Database in ArchiveLog mode
Hot Backup (online backup)
How to clone a database using Cold Backup
How to clone a database using Hot Backup
How to recreate source database from backups (failure scenario)

RMAN Backup and Recovery

Differences between RMAN method and manual method
Database backup using RMAN
Database backup using RMAN compression mode
RMAN catalog
Database backup using RMAN catalog
Querying the RMAN metadata
How to clone a database using RMAN duplicate
Introduction and overview to Backups to Tape
Flashback Database and Flash Recovery Area for better management of backups

Database Objects

Introduction
Tables and Columns
Indexes
Packages, Stored procedures and Functions
Database links
Views and Synonyms
Oracle Data Dictionary
Popular Data Dictionary views and accessing them

Oracle database upgrades

Introduction to Oracle versions and how to understand a version
How to upgrade from one version to another version
How to upgrade from one patchset to another patchset within a release
What are one-off patches
What is OPatch utility

Oracle Utilities

Introduction
SQL*Plus
Data Pump Export
Data Pump Import
Introduction to Oracle SQL* Loader

User Management, Roles and Privileges

Introduction
Create databases users
User roles and privileges
User profiles and tablespace quotas
OS authentication vs database authentication

Performance Tuning

Introduction
How to handle performance issues in the real world
V$ views for performance monitoring and analysis
How to size the Oracle database and memory for optimal performance
Oracle database wait events
Explain Oracle UNDO management internals and sizing.
Explain Oracle TEMP space internals and sizing.
SQL Query tracing using TKPROF
Database wide tracing for Oracle Errors (Event Tracing)
Index Monitoring and internals of index maintenance by Oracle
Gather optimizer statistics using DBMS_STATS

Real world life of an Oracle DBA

Type of Oracle errors. Valid errors and internal exceptions
Monitoring Oracle databases.
How to work with Oracle Support to create Service Requests
Jargon and terminology used by Oracle DBAs
Working with Oracle Forums for issues.
Documentation of work and Communication with peers and managers.
Customer Satisfaction and working with database users.
Obtain Oracle database documentation.
Scheduling JOBS and scripts through UNIX/LINUX crontab utility

Oracle ASM (Automatic Storage Management)

Introduction and benefits of ASM
ASM Setup and Configuration
Partitioning Disks in LINUX
ASM Parameter file, ASM Instance and working with DISKGROUPS
Querying ASM Information
Creating Database Files using ASM
How to drop a database using drop database command.

Oracle Database High Availability (RAC, DataGaurd)

Oracle Real Application Clusters (RAC)
Oracle DataGaurd (Physical Standby) Overview

Click HERE to REGISTER for Training (OR) FREE DEMO SESSION