Oracle DBA Database Administration

Learn to become an Oracle Database Administrator (DBA) in 6 weeks and get a well paid job as a Junior DBA.

Add To Cart

Tags:

Users Enrolled 8

Profile

Profile

Students should have basic SQL Knowledge Students should know the basic UNIX/LINUX commands An open mind to understand Architecture, before jumping into demo's

Step by Step methodology followed is...

Learn the fundamentals of database to set the stage for Oracle Architecture
Understand the Process and Memory Architecture (This is important as understanding this will help you solve lot of critical performance issues).
Install Oracle Database 11g & 12c (Manual method and using DBCA)
Tablespace management to manage space to store the data.
UNDO Tablespace management to manage undo space.
REDO Log file management to manage redo space.
Manage users and security
Networking (Configuring Listeners and TNS entries)
Understand various Data dictionary tables/views
Diagnose issues using Diagnose data and generate packages for Oracle Support.
Backup and Recovery (User Managed)
Backup and Recovery (RMAN)
Materialized Views
Table Partitioning
Project Work