Easy way to IT Job

Oracle DBA Course Syllabus

JOB READY
Syllabus
CERTIFIED
Courses

Let's take the first step to becoming an expert in Oracle DBA

Click Here to Get Started

100% Placement
Assurance

What Learning at SLA gives you

  • Technology Training
  • Aptitude Training
  • Learn to Code (Codeathon)
  • Real Time Projects
  • Learn to Crack Interviews
  • Panel Mock Interview
  • Unlimited Interviews
  • Life Long Placement Support

Syllabus for The Oracle DBA Course

Download Syllabus
Introduction

1

  • Describe course objectives
  • Explore the Oracle 10g database architecture
Installing the Oracle Database Software

2

  • Explain core DBA tasks and tools
  • Plan an Oracle installation
  • Use optimal flexible architecture
  • Install software with the Oracle Universal Installer
Creating an Oracle Database

3

  • Create a database with the Database Configuration Assistant (DBCA)
  • Create a database design template with the DBCA
  • Generate database creation scripts with the DBCA
Managing the Oracle Instance

4

  • Start and stop the Oracle database and components
  • Use Enterprise Manager (EM)
  • Access a database with SQL*Plus and iSQL*Plus
  • Modify database initialization parameters
  • Understand the stages of database startup
  • View the Alert log
  • Use the Data Dictionary
Managing Undo Data

5

  • Explain DML and undo data generation
  • Monitor and administer undo
  • Describe the difference between undo and redo data
Configure undo retention

6

  • Guarantee undo retention
  • Use the undo advisor
Implementing Oracle Database Security

7

  • Describe DBA responsibilities for security
  • Apply the principal of least privilege
  • Enable standard database auditing
  • Specify audit options
  • Review audit information
  • Maintain the audit trail
Performing Database Backups

8

  • Create consistent database backups
  • Back your database up without shutting it down
  • Create incremental backups
  • Automate database backups
  • Monitor the flash recovery area
Performing Database Recovery

9

  • Recover from loss of a control file
  • Recover from loss of a redo log file
  • Perform complete recovery following the loss of a data file
Recovering from Non-critical Losses

10

  • Recovery of Non-Critical Files
  • Creating New Temporary Tablespace
  • Recreating Redo Log Files, Index Tablespaces, and Indexes
  • Read-Only Tablespace Recovery
  • Authentication Methods for Database Administrators
  • Loss of Password Authentication File
  • Creating a new temporary tablespace
  • Altering the default temporary tablespace for a database
Flashback

11

  • Flashback Database Architecture
  • Configuring and Monitoring Flashback Database
  • Backing Up the Flash Recovery Area
  • Using V$FLASH_RECOVERY_AREA_USAGE
  • Flashback Database Considerations
  • Using the Flashback Database RMAN interface
  • Using Flashback Database EM Interface
  • Managing and monitoring Flashback Database operationse
Dealing with Database Corruption

12

  • Block Corruption Symptoms: ORA-1578
  • DBVERIFY Utility and the ANALYZE command
  • Initialization parameter DB_BLOCK_CHECKING
  • Segment Metadata Dump and Verification
  • Using Flashback for Logical Corruption and using DBMS_REPAIR
  • Block Media Recovery
  • RMAN BMR Interface
  • Dumping and Verifying Segment Metadata
Monitoring and Managing Storage

13

  • Database Storage Structures
  • Space Management Overview
  • Oracle-Managed Files (OMF)
  • Row Chaining and Migrating
  • Proactive Tablespace Monitoring
  • Managing Resumable Space Allocation
  • SYSAUX Tablespace
  • Monitoring table and index space usage
Automating Tasks with the Scheduler

14

  • Scheduler Concepts
  • Creating a Job Class and a Window
  • Managing Jobs, Programs, Chains, Events, Schedules, priority
  • Viewing and Purging Job Logs
  • Creating a program and a schedule
  • Creating a job that uses a program and a schedule
  • Altering the program and schedule for the job and observing the behavior change of the job
  • Monitoring job runs
Workshop

15

  • Workshop Methodology, requirements, and setup
  • Scenario 1: Database performance
  • Scenario 2: Finding and Tuning Inefficient SQL
  • Scenario 3: SGA Management – REDO
  • Scenario 4: Running out of Undo Space
  • Scenario 5: Missing datafile
  • Scenario 6: Managing space in a tablespace – REDO
  • Scenario 7: Missing TEMP data file
Managing Database Storage Structures

16

  • Describe table data storage (in blocks)
  • Define the purpose of tablespaces and data files
  • Understand and utilize Oracle Managed Files (OMF)
  • Create and manage tablespaces
  • Obtain tablespace information
  • Describe the main concepts and functionality of Automatic Storage Management (ASM)
Administering User Security

17

  • Create and manage database user accounts
  • Authenticate users
  • Assign default storage areas (tablespaces)
  • Grant and revoke privileges
  • Create and manage roles
  • Create and manage profiles
  • Implement standard password security features
  • Control resource usage by users
Managing Schema Objects

18

  • Define schema objects and data types
  • Create and modify tables
  • Define constraints
  • View the columns and contents of a table
  • Create indexes, views and sequences
  • Explain the use of temporary tables
  • Use the Data Dictionary
  • Manage data through SQL
  • Monitor and resolve locking conflicts
Configuring the Oracle Network Environment

19

  • Create additional listeners
  • Create Net Service aliases
  • Configure connect-time failover
  • Control the Oracle Net Listener
  • Test Oracle Net connectivity
  • Identify when to use shared versus dedicated servers
Backup and Recovery Concepts

20

  • Identify the types of failure that may occur in an Oracle Database
  • Describe ways to tune instance recovery
  • Identify the importance of checkpoints, redo log files, and archived log files
  • Configure ARCHIVELOG mode

Want more details about the Oracle DBA Syllabus?

Fill out the form, and our counsellors will get in touch with you at your preferred time. You can have all your queries answered. Once you decide that SLA is the perfect fit for your training needs, our counselors will guide you through the process every step of the way.

Course Schedules

PDF Course Syllabus

Course Fees

or any other questions...

The SLA way to Become
a Oracle DBA Expert

Enrollment

Technology Training

Coding Practices
Realtime Projects

Placement Training

Aptitude Training
Interview Skills

Panel Mock
Interview

Unlimited
Interviews

Interview
Feedback

100%
IT Career

Google Reviews

Rating
4.8
1,053 Google reviews

Ganesan Vasu

I'm from non-IT background, but always wanted to be in IT, SLA make my dream true and I don't know how many will see this…
Click here for Full Review

Hari Krishnan

I am from Mechanical background. I have no command over programming before joining SLA Such a wonderful place to learn and achieve your goals.Having wonderful…
Click here for Full Review

Aswin Pandiyan

It's my genuine review i searched many institutes to do software testing course and finally landed in SLA. My counselor Bala backed me and my…
Click here for Full Review

Venkatesh

I joined SLA for python course one year back, and i got selected as software developer with decent salary, with after one year of experience,…
Click here for Full Review

Discover What Our Students Have To Say

See More Reviews

Releated Blogs for
The Oracle DBA Course

Our counselors will share the Syllabus PDF with you via Email / Whatsapp

Just a minute!

If you have any questions that you did not find answers for, our counsellors are here to answer them. You can get all your queries answered before deciding to join SLA and move your career forward.

We are excited to get started with you

Give us your information and we will arange for a free call (at your convenience) with one of our counsellors. You can get all your queries answered before deciding to join SLA and move your career forward.