Key points about this course
Duration: 5 Days*
Support: 24/7Dates & Prices Enquire
Send us your message.X
We have your course. Please kindly fill below your contact details to receive full course information and pricing.
Available delivery methods for this course
Oracle Database 19c is a multi-model database providing complete support to relational as well as non-relational data, for e.g. XML, JSON, text, and graph data. Along with this, Oracle Database enables SQL access to non-relational data using SQL extensions or native APIs.
This course is designed to provide the knowledge of how to administer, monitor, tune, and troubleshoot an Oracle database. Delegates will get familiarised with the architecture and processes of the Oracle database server. They will learn how to ensure the company’s data integrity and availability within the Oracle environment. This course explains how to monitor the database performance, resource allocation with the resource manager and schedule jobs with the Oracle Job Scheduler.
This course describes how to configure the Oracle Network Environment as well as create and manage database storage structures. In this course, delegates will learn how to manage users, profiles, privileges and roles. They will also gain an understanding of how to manage temporary segments. This course teaches delegates how to monitor and resolve lock conflicts. Delegates will learn how to load and unload data. They will also acquire knowledge of how to use the job scheduler and configure a database for backup and recovery.
Module 1: Introduction to Oracle Database
Module 2: Oracle Database Architecture
Module 3: Administer a Database Instance
Module 4: Configure the Oracle Network Environment
Module 5: Storage Structures
Module 6: Manage Users
Module 7: Manage Privileges
Module 8: Manage Profiles and Resources
Module 9: Database Auditing
Module 10: Data Concurrency and Lock Conflicts
Module 11: Undo Management
Module 12: Backup and Recovery Configuration
Module 13: Proactive Database Maintenance
Module 14: Performance Management
Module 15: SQL Tuning
Module 16: Moving Data
Module 17: Managing Resources with Resource Manager
Module 18: Automate Tasks with the Scheduler
Module 19: Manage Space
Module 20: Oracle Support
There are no prerequisites for this course.
This course is for IT Professionals who want to learn about databases and Oracle Technologies.
Duration: 5 Days*
Support: 24/7View dates & prices
Select your preferred delivery method
Choose a Region
Choose a Location
Choose a Month
You won't find better value in the marketplace. If you do find a lower price, we will beat it.
Various delivery methods
Flexible delivery methods are available depending on your learning style.
Resources are included for a comprehensive learning experience.
"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"
Joshua Davies, Thames Water
"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."
Diane Gray, Shell