Oracle DBA Training

Oracle DBA Online Training

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

Send Enquiry

Your Name (required)

Your Email (required)

Your Phone No. (required)

Subject

Your Message