Oracle DBA Course Content

Our course is structured with beginners in mind.

The Oracle Database 12c: Administration course from NationGlobe Tech is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.

We start with basic computer lessons and then move to Oracle SQL fundamentals and to more advanced SQL lessons.
This will also include training on how to set up your virtual environment on your laptop for practice and hands-on.
We have basic Linux Command course to gain skills needed to work with Linux and Unix OS
After the SQL, we will then take on the Oracle Administration course with Linux and Oracle Installations

You will benefit from this course as you learn detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. Hands-on on backup and recovery techniques is presented in this course.

To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.


COURSE TOPICS
 
•    Introduction to oracle database administration
•    Virtualization setup practice environment
•    Installations of Oracle on Linux
•    Basic Linux Administration Syntax
•    Oracle SQL lesson

More Topics covered
  • Oracle Database Architecture
  • Managing Database Instances
  • Creating Pluggable Databases (PDBs)
  • Configuring the Oracle Network Environment
  • Dedicated Versus Shared Server Configurations
  • Administering User Security
  • Creating and Managing Tablespaces
  • Managing Storage Space
  • Managing UNDO Data
  • Managing Data Concurrency
  • Implementing Oracle Database Auditing
  • Moving Data
  • Backup and Recovery Concepts
  • Monitoring and Tuning Database Performance
  • SQL Tuning
  • Oracle Database Resource Manager
  • Upgrading Oracle Database
  • Enterprise Manager Cloud Control
  • Introduction to Oracle Database Cloud Service (DBCS)
Detailed Syllables is available for registered students. REGISTER NOW

Other course we are offering.
Share by: