The Oracle Database 12c: Administration Workshop will teach professionals about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and conduct database maintenance.

Radiant Techlearning offers Oracle Database 12c: Administration Workshop Training Program in Classroom and Virtual Instructor Led/Online mode.


Duration: 5 days


Learn to:

  • Create and manage an Oracle Database Instance.
  • Create and manage Storage Structures.
  • Configure the Oracle Network Environment.
  • Create and manage users.
  • Monitor the database and manage performance.
  • Learn basic information about backup and recovery techniques.
  • Using the Oracle Support Workbench and My Oracle Support to update your Oracle Database software.


Ensure quick, reliable, secure and easy to manage performance. Develop database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.


Participate in Hands-On Practices and Demonstrations

The professionals under expert instruction and hands-on demonstrations will gain real world experience. By engaging in hands-on exercises to reinforce your learning, you’ll develop in demand skills to successfully manage an Oracle Database.


Learning Objectives

  • Using back up, restore, and patch DBCS database deployments
  • Describe the DBaaS and on-premises Oracle Database architectures
  • Manage database instances
  • Manage UNDO data
  • Move data between databases
  • Implement basic backup and recovery procedures
  • Monitor and tune database performance
  • Tune SQL to improve performance
  • Manage resources with Oracle Database Resource Manager
  • Create pluggable databases (PDBs)
  • Configure the Oracle network environment
  • Administer user security and implement auditing
  • Create and manage tablespaces
  • Manage storage space
  • Generate and control Database as a Cloud Service (DBCS) database deployments
  • Record databases and control performance with Enterprise Manager Cloud Control

Course content

  • Getting Started
  • Exploring Oracle Database Architecture
  • Managing Database Instances
  • Creating PDBs
  • Configuring the Oracle Network Environment
  • Administering User Security
  • Creating and Managing Tablespaces
  • Managing Storage Space
  • Managing UNDO Data
  • Moving Data
  • Backup and Recovery Concepts
  • Monitoring and Tuning Database Performance
  • SQL Tuning
  • Oracle Database Resource Manager
  • Enterprise Manager Cloud Control
  • Introduction to Oracle Database Cloud Service
  • Creating DBCS Database Deployments
  • Managing DBCS Database Deployments
  • Backing Up and Restoring DBCS Database Deployments
  • Patching DBCS Database Deployments
  • Creating Master Encryption Keys for PDBs
  • Tablespace Encryption by Default


Q: What is database administration and why should we prefer Oracle database?


A: Database administration is the compiled procedure of maintaining, securing and managing the globally collected data information which are considered as units, Oracle database is the first ever database designed for the grid computing in a very flexible and cost  eminent way to manage data and information accepted from the worldwide.


Q: How a PDB is distinct from CDB?


A: Pluggable database (PDB) is actually a transferrable compilation of various schemas, non schema objects, schema objects which visits the Oracle Net client under the nomenclature non CDB. While CDB is the root of system container which may contain one or multiple PDB plugged inside the application root.


Q: What is meant by DBaaS in Oracle?


A: DBaaS is an extended private management solution presented by Oracle. By accessing this solution through self service portal, IT managers need not have perform administrative tasks for providing services in databases.


Q: What is meant by database instance?


A: Instance is set of memory structure which is responsible for managing and storing database files which are created under DATABASE statement for serving the users of the database.


Q: Which database service is accessed by Android?


A:  Android uses built in implemented version of SQLite database which in fact is an open source database that stores data to a text file/application on a device.


Q: What are Tablespaces in database?


A: Tablespaces are multiple logical storage units which are responsible for conforming operating system in which Oracle database and for storing files known as datafiles.


Q: Why one should prefer Radiant Techlearning ?


A: Radiant believes in practical and creative approach to training and development which distinguishes it from the other training and developmental platforms. Moreover training courses are undertaken by some of the experts who are having vast range of experience in their domain.


Q: What if I/we have doubts after attending your training program?


A: Radiant team of experts would be available on the e-mail to answer your technical queries even after the training program.


Q: Does this training program include any project?


A: Yes, Radiant will provide you most updated high value and relevant real time projects and case studies in each training program.


Q: If I face technical difficulty during the session then is there any remedy for that?


A: Technical issues are unpredictable and might occur with us as well.   Participants have to ensure that they have access to the required configuration with good internet speed.


Q: What is schedule of training program?


A: Radiant Techlearning offers training programs on weekday, weekend and combination of weekday and weekend.  We provide you complete liberty to choose the schedule that suits to your need.

Categories: ,

Unble To Find a Batch..?

Request a Batch