Linkedin Instagram
GET IN TOUCH

Database Administration

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
Oracle Database Administration Training Courses
Book Now

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?

CONTACT US

testimonials

  • Oracle Database Academy is one of the best courses I have participated in. Satnam 's knowledge, delivery, and experience are second to none.

    Tom Jenkins

  • The only course that I have come across which was tailored to my specific company needs, at a fraction of the price compared to previous learning courses I have used.

    Gurmejer Singh

  • Well thought out courses, amazing organisation of courses and the ODA team are extremely helpful during the hands-on process. Definitely recommend.

    Sarah Robinson