We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS.

Topics Covered

DBA-I 1. Oracle 10g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? ? Direct Path Loads and Unloads ? Situations in Which Direct Path Load ? Situations in Which Direct Path ? External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? ? Coordination of a Job ? Tracking Progress within a Job ? Filtering Data and Metadata During a ? Transforming Metadata during a Job ? Maximizing Job Performance ? Loading and Unloading of Data ? Monitoring Job Status ? Monitoring the Progress of Executing • File Allocation ? Specifying Files and Adding ? Default Locations for Dump, Log, • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility Is Not Used Unload Is Not Used Job Jobs Additional Dump Files and SQL Files 2. RMAN Concepts • Configuring the Environment for RMAN Backups ? Showing and Clearing Persistent ? Configuring the Default Device for ? Configuring the Default Type for ? Configuring Channels ? Configuring Control File and Server ? Configuring RMAN to Make Backups ? Configuring the Backup Retention ? Configuring Backup Optimization ? Configuring Oracle Flashback • About RMAN Channels ? Channel Control Options for Manual ? Channel Failover • About RMAN Backups ? About Image Copies • RMAN Backup Types ? Incremental Backups ? RMAN Backup Errors ? Tests and Integrity Checks for ? Detecting Physical and Logical Block ? Backup Validation with RMAN • Restoring Files with RMAN ? Mechanics of Restore Operations ? File Selection in Restore Operations ? Datafile Media Recovery with RMAN ? Mechanics of Recovery: Incremental ? Incomplete Recovery ? Tablespace Point-in-Time Recovery ? Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) RMAN Configurations Backups: Disk or SBT Backups: Backup Sets or Copies Parameter File Autobackups to a Media Manager Policy Database and Restore Points and Automatic Channels Backups Corruption Backups and Redo Logs

Who should attend

• Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA.

Pre-requisites

• Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts.

What you need to bring

We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course."""

Key Takeaways

• RDMBS knowledge • Way to proceed for the next step which is RAC