Oracle DBA Hands-on Training With Job Placement

ORACLE DBA Course Content

Our Oracle DBA training provides detailed coverage of core database concepts, the role and capabilities of the administrator and walks you through database configuration, administration, programming, performance tuning, backup and recovery, and high availability.

Course Duration: Online

• ​5 weeks course, 6 days per week, 1 hr a day, total 6 hours per week.
• Total​ Duration 25 hours.
• ​Free - Demo Training available for interested students

Module - 1

• ​Introduction
• ​Writing Basic SQL Statements
• ​Restricting and Sorting Data
• ​Single Row Functions
• ​Displaying Data from Multiple Tables

Module - 2

• ​Aggregating Data by Using Group Functions
• ​Writing Sub queries
• ​Producing Readable Output with isql *Plus
• ​Manipulating Data

Module - 3

• ​Creating and Managing Tables
• ​Including Constraints
• ​Creating Views

Module - 4

• ​Other Database Objects

Module - 5

• ​Controlling User Access

Module - 6

• ​Using Set Operators
• ​Oracle Date time Functions
• ​Enhancements to the GROUP BY Clause
• ​Advanced Sub queries

Module - 7

• ​Oracle Architectural Components
• ​Getting Started with the Oracle Server
• ​Managing an Oracle Instance

Module - 8

• ​Creating a Database Data Dictionary Contents and Usage

Module - 9

• ​Maintaining the Control File
• ​Maintaining Redo Log Files

Module - 10

• ​Managing Table spaces and Data files
• ​Storage Structures and Relationship

Module - 11

• ​Managing Undo Data
• ​Managing Indexes
• ​Maintaining Data Integrity

Module - 12

• ​Managing Password Security and Resources
• ​Managing Users
• ​Managing Privileges
• ​Managing Roles