Oracle Database Administration for Beginners

1 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 5
Please Log in or register to rate

Oracle Database Administration for Beginners


This training explores the basic fundamentals of Oracle database administration. This course is designed to provide students with a firm foundation in basic Oracle Database administration.

In this course, students gain a conceptual understanding of the Oracle Database Architecture, and learn how it’s components work and interact with one another. Students learn how to manage the Oracle Database Instance, configure proper networking, manage storage, user-management & Database security, Auditing, Undo management, handling Database Locks, statistics, and basic backup/recovery techniques. In this course, each module is reinforced with structured hands-on exercises.


Target Audience: 
This course is mainly intended for Database Administrators, Database Developers, IT Professionals, and other roles responsible for administering the Oracle database.

– Basic working knowledge of relational databases
– Basic understanding of the Microsoft Windows operating system
– Familiarity with PL/SQL is recommended but not mandatory
– Familiarity with the SQL language concepts and syntax.

Course Topics

Module 1 – Database Architecture:
Connecting to the server, the logical structure, the physical structure, Oracle background processes.

Module 2 – Managing Database Instance:
Working with the Pfile and Spfile, static and dynamic parameters, startup & shutdown phases, Data Dictionary Views, Dynamic Performance Views

Module 3 – Networking:
Understanding Connect-Identifier, Connect Descriptor, Naming Methods, configuring the LISTENER, working with TNSPING.

Module 4 – Storage:
Logical & Physical layout, Tablespace Types, Extent Management, Resizing a tablespace, Oracle-Managed Files.

Module 5 – User Management:
Creating users, managing privileges, working with Roles, Quotas, and Profiles.

Module 6 – Undo Management:
Understanding A.C.I.D Standards, DML and DDL – Behind the scenes, Consistency types, Managing UNDO Data, Flashback query, Oracle Isolation Levels.

Module 7 – Data Concurrency:
Shared and Exclusive Locks, DML and DDL Locks, Enqueue Mechanism.

Module 8 – Auditing:
Mandatory Auditing, Standard DB auditing, Value based auditing, Fine Grained Auditing, SYSDBA auditing, relevant Data Dictionary Views.

Module 9 – Statistics and Alerts:
Working with Database Statistics and Optimizer Statistics, using the AWR.

Module 10 – Performance Aspects:
Foreground and background processes, Oracle memory components, troubleshooting incorrect memory settings, invalid objects.

Module 11 – Backup & Recovery Concepts:
Categories of failure, phases of Instance recovery, Redo log files, media failure, Flash Recovery Area, ARCHIVE vs NOARCHIVELOG modes, Place the DB in Archivelog mode.

Module 12 – Exporting & Importing Data:
Data Pump Architecture, Export & Import using the Datapump, Monitor progress.

Detailed Course Outline
© Copyright - Skilit - Site by Dweb