Oracle Database: Managing Multitenant Architecture

Duration: 4 Half Days (~16 hours)

Teacher

John Watson

Course Features

Lectures 0
Quizzes 0
Duration 4 Half Days (~16 hours)
Skill level All levels
Language English
Students 31
Certificate Yes
Assessments Yes

Multitenant architecture

Investigate the multitenant architecture
Describe the container types: root, seed, pluggable
Understand how Oracle Net establishes sessions
Query the views that describe the environment
Describe some features relevant to large deployments

Set up a Multitenant environment

Create a container database
Create pluggable containers
Convert a non-CDB to a pluggable container
Relocate, unplug, and drop containers
Hot clones of PDBs and non-CDBs
Upgrade a CDB

Multitenant administration

Startup and shutdown a CDB
Open and close pluggable containers
Tablespace management
Create local and common objects
Understand use of roles and privileges
Set instance parameters

Backup and recovery

Backup the CDB and PDBs
Complete and incomplete restore and recovery
Database flashback
Data Guard in a Multitenant environment

Performance

Resource management
Memory and IO limits
Use of the Resource Manager
Monitoring
The AWR and Statspack

Security issues

Audit
Encryption
Data Vault
Some fine-control capabilities

John Watson

https://skillbuilders.com/our_team/john-watson/

5/5

What did you particularly like about the course?
I thought the instructor was well-versed, informative, and presented in an easy-to-follow manner. You can tell he has a lot of experience with both Oracle and teaching.

Please describe your suggestions for improvement of the course.
Some minor issues existed with the exercises.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?
No

laila.marker@ua.edu

February 4, 2021

5/5

What did you particularly like about the course?
I really loved the amount of time and care that went into preparing the class exercises.

Please describe your suggestions for improvement of the course.
I really can't think of anything that could add benefit to the class.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?
None really.

Hunter Standridge

February 4, 2021

5/5

What did you particularly like about the course?
John's training style, of course. Apart from that, the course was well-structured, plenty of offline reading to do, and the workshops were especially useful in reinforcing learning acquired over the length of the course.

Please describe your suggestions for improvement of the course.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?
No, everything worked extremely well. Will be back for more!

Jes Challand

December 17, 2020

5/5

What did you particularly like about the course?
John was an excellent trainer, he ensured that we were all caught up and understood the material. He moved at a pace that fit everyone and explained everything thoroughly.

Please describe your suggestions for improvement of the course.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?

Xavier Western

December 17, 2020

5/5

What did you particularly like about the course?
John was very knowledgeable and answered questions without hesitation.
He was able to relieve some of my apprehensions about the multitenant architecture.

Please describe your suggestions for improvement of the course.
You might add something on the subject of naming conventions for CDBs and PDMs.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?
I believe the online software and delivery were both very good.

Robert Harris

December 17, 2020

4.8/5

What did you particularly like about the course?
DataGuard part

Please describe your suggestions for improvement of the course.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?

Yiqun Zhou

December 17, 2020

4.8/5

What did you particularly like about the course?
Training content and details were shared ahead of time so enthusiastic students could prepare. The trainer was very well prepared, and provided us a comprehensive picture then dig into details. A mixture of theory and hands on labs were combined together.

Please describe your suggestions for improvement of the course.
Sometimes I was lost in details. Maybe it would be good to refer back to the overall picture every time, when a very low level topic discussed. However, it is a minor thing, the overall picture is great.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?
Voice was sometimes lost (however, other input sources always worked at the same time). Only solution was to exit from training then re-connecting.

Sandor Toth

June 25, 2020

4.8/5

What did you particularly like about the course?
Very detailed knownledge on each topic. He was able to answer our specific questions or willing to investigate it.

Please describe your suggestions for improvement of the course.
Maybe less theoritical and more real world examples / excersises.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?
Online software worked perfectly.

krisztian.csorgo@ni.com Csorgo

June 25, 2020

5/5

What did you particularly like about the course?
The exercises are fine and help to understand better the concepts.
The teacher is very good, he answered all our questions and tried to demonstrate all the doubts with examples.

Please describe your suggestions for improvement of the course.
I think that the course has all the necessary to be successful.
Maybe a little more examples in the performance section, but in general the course is very good.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?
For me, online software is fine.

mcambronero

June 25, 2020

4.8/5

What did you particularly like about the course?
John made it interesting and engaging, I particularly liked the practicals.

Please describe your suggestions for improvement of the course.

If this was an online course, do you have suggestions for improving the online software or delivery techniques?
All good from that end.

Robin Neoh

June 25, 2020

Details Price Qty

08/15/22 - 08/18/22show details +hide details - $2,100.00 (USD) Quantity

Details

Price

Name	Description	Amount
08/15/22 - 08/18/22		$2,100.00 (USD)
Total		$2,100.00 (USD)

Sale Dates

- The dates when this option is available for purchase.
Goes On Sale: May 5, 2022 8:00 am
Sales End: August 15, 2022 8:00 am

Access

- This option allows access to the following dates and times.

Date	Time
08/15/22 - 08/18/22 August 15, 2022 to August 18, 2022	9:00 am to 1:00 pm

please do not enter anything in this input

Oracle DBA Training

Oracle Database: Managing Multitenant Architecture

Course Features

Details

Price

Sale Dates

Access

Login with your site account

Register a new account

Email preferences

Select your interests

Modal title