ORACLE DBA COURSE – LEARN @ YOUR CONVENIENCE

1 Introduction to database management systems

1.1 What is a database?

1.2 Popular database management system (DBMS) software and why Oracle DBMS

1.3 History and Current trends of DBMS and Database Administration

1.4 Tasks of a Database Administrator

 

2 Relational Database Model and Installing Oracle database software

2.1 Entity Relational (ER) Model Overview

2.2 Oracle flexible architecture

2.3 Installation of Oracle database software (Oracle DBMS)

 

3 Oracle Database Architecture

3.1 Components of an Oracle database and detailed architecture

3.2 Creation of the first Oracle database.

3.3 Startup and Shutdown of a database

 

4 Database Objects

4.1 Introduction

4.2 Tables, Indexes, Views and Synonyms

4.3 Packages, Stored procedures and Functions

4.4 Oracle Data Dictionary and some popular Data Dictionary views

 

5 Database Storage

5.1Tablespaces and allocation types

5.2 Create tablespaces

5.3 Create datafiles with fixed size and autoextend option

5.4 Control files, Redolog groups and members

5.5 NoArchivelog mode and Archivelog mode for a database

 

6 Oracle Networking

6.1Introduction

6.2 Oracle listener configuration

6.3 Oracle database connections from other computers

6.4 Oracle listener administration and TNS environment variables

6.5 Database Links

 

7 Oracle Utilities

7.1 Introduction

7.2 Export and Import

7.3Data Pump Export and Data Pump Import

7.4 Introduction to Oracle SQL* Loader

 

8 User Management, Roles and Privileges

8.1 Introduction

8.2 Create databases users

8.3 User roles and privileges

8.4 Identifying system and object privileges

8.5 Granting and revoking privileges

8.6 Creating and modifying roles

8.7 Displaying user security Information from the data dictionary

 

9 Used Managed (Manual) Backup and Recovery

9.1 Introduction

9.2 Cold Backup

9.3 Hot Backup

9.4 How to recover a database using Cold Backup

9.5 How to recover a database using Hot Backup

 

10 RMAN Backup and Recovery

10.1 Differences between RMAN method and manual method

10.2 Database backup using RMAN

10.3 RMAN catalog

10.4 Database backup using RMAN catalog

10.5 Querying the RMAN metadata

10.6 Introduction and overview to Backups to Tape

 

11 Oracle Database Upgrades

11.1 Introduction to Oracle versions and how to understand a version

11.2 How to upgrade from one version to another version

11.3 How to upgrade from one patchset to another patchset within a release

11.4 What are one-off patches

11.5 What is OPatch utility

 

12 Oracle Database Management Tools

12.1 Introduction to Oracle enterprise manager (OEM) control

12.2 Managing and monitoring databases

12.3 Managing database objects

12.4 Introduction to TOAD

 

13 Performance Tuning

13.1 Introduction

13.2 How to handle performance issues in the real world

13.3 V$ views for performance monitoring and analysis

13.4 How to size the Oracle database and memory for optimal performance

13.5 Explain Oracle UNDO management internals and sizing.

13.6 Explain Oracle TEMP space internals and sizing.

13.7 SQL Query tracing using TKPROF

13.8 Database wide tracing for Oracle Errors (Event Tracing)

13.9 Gather optimizer statistics using DBMS_STATS

 

14 Oracle ASM (Automatic Storage Management)

14.1 Introduction and benefits of ASM

14.2 ASM Setup and Configuration

14.3 ASM Parameter file, ASM Instance and working with DISKGROUPS

14.4 Querying ASM Information

14.5 Creating Database Files using ASM

 

15 Oracle Database High Availability (RAC, DataGaurd, Streams)

15.1 Oracle Real Application Clusters (RAC) Overview

15.2 Oracle DataGaurd (Physical and Logical Standby) Overview

15.3 Oracle Streams Overview