Database Administration

oracle Database Administration

This course is designed to provide you with all the necessary skills to confidently administer an Oracle Database within your organization. No matter your current competency we will teach you everything required to bring you up to speed, learning from mentors with real life hands on commercial experience. In this course we shall cover the following essential skills:

Day-1

  • Introduction to Oracle Database
  • Accessing an Oracle Database
  • Creating an Oracle Database by Using DBCA
  • Creating an Oracle Database by Using a SQL Command
  • Starting Up and Shutting Down a Database Instance
  • Managing Database Instances
  • Oracle Net Service: Overview
  • Configuring Naming Methods
  • Configuring and Administering the Listener
  • Configuring a Shared Server Architecture
  • Configuring Oracle Connection Manager for Multiplexing and Access Control
  • Creating PDBs from Seed
  • Using Other Techniques to Create PDBs
  • Managing PDBs

Face-to-face courses
Ask questions, Make friends!

Day-1

  • Introduction to Oracle Database
  • Accessing an Oracle Database
  • Creating an Oracle Database by Using DBCA
  • Creating an Oracle Database by Using a SQL Command
  • Starting Up and Shutting Down a Database Instance
  • Managing Database Instances
  • Oracle Net Service: Overview
  • Configuring Naming Methods
  • Configuring and Administering the Listener
  • Configuring a Shared Server Architecture
  • Configuring Oracle Connection Manager for Multiplexing and Access Control
  • Creating PDBs from Seed
  • Using Other Techniques to Create PDBs
  • Managing PDBs

Day-2

  • Database Storage Overview
  • Creating and Managing Tablespaces
  • Improving Space Usage
  • Managing Undo Data
  • Creating and Managing User Accounts
  • Configuring Privilege and Roles Authorization
  • Configuring User Resource Limits
  • Implementing Oracle Database Auditing
  • Introduction Loading and Transporting Data

Day-3

  • Loading Data
  • Transporting Data
  • Using External Tables to Load and Transport Data
  • Automated Maintenance Tasks: Overview
  • Automated Maintenance Tasks: Managing Tasks and Windows
  • Database Monitoring and Performance Tuning Overview
  • Monitoring Database Performance
  • Analyzing SQL and Optimizing Access Paths

Have any questions?

testimonials