PeopleCert, on behalf of Axelos
01344 203999 Available 24/7
close
Press esc to close
close
Fill out your contact details below and our training experts will be in touch.
If you wish to make any changes to your course, please
log a ticket and choose the category ‘booking change’
close
One of our training experts will be in touch shortly to go over your training requirements.
close
Press esc to close
Back to Course Information
Back to course information
One of our training experts will be in touch shortly to go overy your training requirements.
One of our training experts will be in touch shortly to go over your training requirements.
accredited by
TKA, on behalf of TKA
Module 1: Oracle Database Architecture
Module 2: Introduction to Oracle Database Cloud
Module 3: Creating Oracle Database Cloud Service (DBCS) Deployments
Module 4: Accessing an Oracle Database
Module 5: Managing DBCS Database Deployments
Module 6: Managing Database Instances
Module 7: Oracle Net Services
Module 8: Administering User Security
Module 9: Creating PDBs
Module 10: Creating Master Encryption Keys for PDBs
Module 11: Creating and Managing Tablespaces
Module 12: Managing Storage Space
Module 13: Managing Undo Data
Module 14: Moving Data
Module 15: Backup and Recovery Concepts
Module 16: Backup and Recovery Configuration
Module 17: Creating Database Backups
Module 18: Performing Database Recovery
Module 19: Monitoring and Tuning Database Performance
Module 20: SQL Tuning
Prerequisites
There are no prerequisites for this course.
Audience
This course is for IT Professionals and Database Administrators who wants to learn about databases and Oracle Technologies.
Oracle 18c describes how to create, configure, and administer an Oracle database. This course gives knowledge on the architecture of an Oracle Database instance and database, enables delegates to manage their database resources effectively. This course describes how to create oracle database cloud service (DBCS) deployments, how to access an oracle database and manage DBCS database deployments. In this course delegates will learn how to manage database instances. They will also learn about oracle net services: oracle net listener, connecting to an oracle database instances, naming methods, oracle net services administration tools, configuring communication between database instances, and comparing dedicated and shared server configurations.
In this 3-day course, delegates will acquire knowledge of how to manage oracle cloud and database users, privileges, and roles. They will also learn about user authentication, creating and assigning profiles. This course describes creating PDBs: methods and tools to create PDBs, creating PDBs from seed, cloning PDBs, unplugging and plugging in PDBs and dropping PDBs. This course teaches delegates how to create master encryption keys for PDBs and Creating and managing table spaces. They will also learn how to manage storage space, manage undo data, and moving data.
This course explains backup and recovery concepts and configuration. Delegates will learn how to configure and monitoring the fast recovery area, multiplexing control files, multiplexing redo log files, archive redo log files, and configure ARCHIVELOG mode. They will also learn about SQL tuning: SQL tuning process, oracle optimiser, optimiser statistics, SQL tuning advisor, SQL access advisor, and SQL performance analyser.
Why choose us
Our easy to use Virtual platform allows you to sit the course from home with a live instructor. You will follow the same schedule as the classroom course, and will be able to interact with the trainer and other delegates.
Our fully interactive online training platform is compatible across all devices and can be accessed from anywhere, at any time. All our online courses come with a standard 90 days access that can be extended upon request. Our expert trainers are constantly on hand to help you with any questions which may arise.
This is our most popular style of learning. We run courses in 1200 locations, across 200 countries in one of our hand-picked training venues, providing the all important ‘human touch’ which may be missed in other learning styles.
All our trainers are highly qualified, have 10+ years of real-world experience and will provide you with an engaging learning experience.
We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible
We limit our class sizes to promote better discussion and ensuring everyone has a personalized experience
Get more bang for your buck! If you find your chosen course cheaper elsewhere, we’ll match it!
This is the same great training as our classroom learning but carried out at your own business premises. This is the perfect option for larger scale training requirements and means less time away from the office.
Our courses can be adapted to meet your individual project or business requirements regardless of scope.
Cut unnecessary costs and focus your entire budget on what really matters, the training.
This gives your team a great opportunity to come together, bond, and discuss, which you may not get in a standard classroom setting.
Keep track of your employees’ progression and performance in your own workspace.
Course was run very smoothly, Richard our trainer was extremely knowledgeable and delivered the course in a succinct fashion with a twist of humour thrown in.
The course was great and the so was the trainer - brilliantly delivered and I would certainly recommend this course to my colleagues. Thanks to Richard for a great course and delivering it a tough environment virtually.
Richard was very knowledgeable and explained well
You won't find better value in the marketplace. If you do find a lower price, we will beat it.
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
Back to course information
We may not have any package deals available including this course. If you enquire or give us a call on 01344 203999 and speak to our training experts, we should be able to help you with your requirements.
If you miss out, enquire to get yourself on the waiting list for the next day!
