Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1/1Z0-060

Download Course Contents

Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1 Course Overview

The Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1  training course will give you a detailed overview of following modules, the Using SQL New Features and Tools, the Understanding DB Architectures, and the Diagnosing Database Problems. During the training, you will be skilled with the knowledge about on-premises Multitenant databases and various other new features in different areas of database administration.

Who should do Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1 training?

  • End Users
  • Database Administrators
  • System Administrator

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

The 1-on-1 Advantage
Methodology
Flexible Dates
  • • Choose Start Date
  • • Reschedule After Booking
  • • Weekend / Evening Option
4-Hour Sessions

You will learn:

Module 1: Introduction
  • Global objectives of the course
  • Lessons grouped by modules
  • Using SQL new features and tools
  • Understanding DB architectures
  • Diagnosing database problems
  • Schedule of the week
  • Use new 128 bytes identifier length for database objects
  • Increase length limits of data types
  • Use SQL row-limiting clause
  • Describe the support for invisible and hidden columns
  • Use the new VALIDATE_CONVERSION function
  • Recall SQL*Plus commands in the same session from history
  • Describe the new SQLcl utility
  • Challenges
  • New Multitenant Architecture: Benefits
  • Non-CDB Architecture vs Oracle Multitenant Container Database
  • Configurations
  • A pristine installation
  • SYSTEM objects in the USER container
  • Provisioning a pluggable database
  • CDB root and pluggable database containers
  • Create a CDB using new clauses
  • What's new in CDB after CDB creation
  • Data dictionary views
  • What to do in CDB after CDB creation
  • ADR
  • Provisioning new PDBs: overview
  • Tools
  • Regular PDBs vs application PDBs
  • PDBs and applications
  • Application containers
  • Types of containers
  • Create and manage an application container
  • Install applications
  • Patch and upgrade applications
  • Application common objects
  • Configure and use locla UNDO mode
  • Cloning regular and application containers PDBs
  • Plugging unplugged regular and application PDBs into CDB
  • Cross-Platform transportable PDB
  • Plugging or cloning a non-CDB into a CDB
  • Perform hot cloning and relocation
  • Converting regular PDBs to application root or PDBs
  • Plugging unplugged PDBs with encrypted data
  • Managing CDB and PDBs
  • Switching Connection
  • Creating and renaming Services
  • Starting Up a CDB Instance
  • Mounting a CDB
  • Opening CDBs and PDBs
  • Changing the different modes and settings of PDBs
  • Evaluating the impact of parameter value changes
  • Creating Permanent Tablespaces in a CDB
  • Objects in Tablespaces
  • Tablespaces Created During PDB Creation
  • Defining Default Permanent Tablespaces
  • Temporary Tablespaces
  • UNDO Tablespaces
  • Creating common users, roles and profiles in CDB and PDBs
  • Granting privileges commonly in CDB and PDBs
  • Common objects in Application PDBs and operations on Data-Linked objects
  • Enabling Common Users to Access Data in PDBs
  • Managing PDB lockdown profiles
  • Auditing users in CDB and PDBs
  • Protecting data with Database Vault policies in CDB and PDBs
  • Encrypting data in PDBs
  • New syntax and clauses in RMAN
  • CDB and PDB backups
  • Using RMAN backup to plug an unplugged PDB
  • Instance failure and instance recovery
  • PDB tempfile, essential and non-SYSTEM tablespaces recovery
  • PDB point-in-time recovery
  • Duplicating PDBs
  • CDB and PDB flashback
  • Tuning a CDB
  • Sizing the CDB
  • Managing SGA and PGA for PDBs
  • Monitoring PDB memory usage
  • AWR and ADDM behaviour at CDB and PDB levels
  • PDB-Level snapshot views
  • AWR report
  • Controlling the Degree of Parallelism of Queries
  • Allocating resources in the CDB and PDBs
  • Managing resources between PDBs
  • CDB Resource plan basics: Limits + cpu_count init parm per PDB
  • Controlling PDB IO rate limit
  • Managing resources within a PDB
  • Creating and setting PDB performance profiles
  • Using Oracle Data Pump with PDBs
  • Exporting non-CDB data and importing non-CDB data into PDB
  • Exporting and importing between PDBs
  • Exporting from PDB and importing into a non-CDB
  • Full Transportable export/import
  • Transporting a database over the network
  • Using SQL*Loader with PDBs
  • Using catcon.pl utility to install/remove options from CDB/PDB
  • Using Xstreams with a CDB and PDB
  • Creating a standby of a CDB
  • Scheduling operations in a PDB
  • Jobs coordinator and resources
  • Mining statements of a PDB using LogMiner
  • What Is Database Sharding?
  • Benefits of Sharding
  • Advantages of Oracle Sharding over NoSQL
  • Application Considerations for Sharding
  • Components of Database Sharding
  • Complete Deployment of a System-Managed SDB
  • Creating Sharded Tables
  • Sharded Table Family
  • Automatic Diagnostic Repository
  • New ADRCI Command
  • ADR Retention
  • Network Performance
  • Trace File Analyzer (TFA) Collector process and repository
  • TFA Collector utility
  • Tracing Data Pump
  • MVs refreshed statistics history
Live Online Training (Duration : 40 Hours) Fee On Request
We Offer :
  • 1-on-1 Public - Select your own start date. Other students can be merged.
  • 1-on-1 Private - Select your own start date. You will be the only student in the class.

4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Group Training
Date On Request
Course Prerequisites
  • Knowledge of Oracle Database 11g R2


Following is suggested but not mandatory:

  • Oracle Database 12c R2: Install and Upgrade Workshop
  • Using Oracle Enterprise Manager Cloud Control 13c Ed 2
     

Upon completion of this course, you will know:

  • Creating and managing pluggable databases
  • Understand the challenges and benefits of a sharded database
  • Handling ADR automatic file space
  • Using the Trace File Analyzer collector for diagnosing database issues
  • Using the new SQL Plus history commands, SQL enhancements & SQLcl new utility as the new SQL command line interface
  • Creating and managing a multitenant container database

Request More Information

Add Name and Email Address of participant (If different from you)

FAQ's


Yes, fee excludes local taxes.
Yes, we do.
The Fee includes:
  • Official courseware
Yes, Koenig Solutions is a Oracle Learning Partner
Schedule for Group Training is decided by Koenig. Schedule for 1-on-1 is decided by you.
In 1-on-1 you can select your own schedule, other students can be merged but you select the schedule. Choose 1-on-1 if published schedule do not meet your requirement. If you also want a private session, opt for 1-on-1 Public.
Yes.
No, it is not included.
In both, you choose the schedule. In public, other participants can join, Private other participants want to join.
Yes, course requiring practical include hands-on labs.
You can buy online from the page by clicking on "Buy Now". You can view alternate payment method on payment options page.
Yes, you can pay from the course page and flexi page.
Yes, the site is secure by utilizing Secure Sockets Layer (SSL) Technology. SSL technology enables the encryption of sensitive information during online transactions. We use the highest assurance SSL/TLS certificate, which ensures that no unauthorized person can get to your sensitive payment data over the web.
We use the best standards in Internet security. Any data retained is not shared with third parties.
You can request a refund if you do not wish to enroll in the course.
To receive an acknowledgment of your online payment, you should have a valid email address. At the point when you enter your name, Visa, and other data, you have the option of entering your email address. Would it be a good idea for you to decide to enter your email address, confirmation of your payment will be emailed to you.
After you submit your payment, you will land on the payment confirmation screen. It contains your payment confirmation message. You will likewise get a confirmation email after your transaction is submitted.
We do accept all major credit cards from Visa, Mastercard, American Express, and Discover.
Credit card transactions normally take 48 hours to settle. Approval is given right away; however, it takes 48 hours for the money to be moved.
Yes, we do accept partial payments, you may use one payment method for part of the transaction and another payment method for other parts of the transaction.
Yes, if we have an office in your city.
Yes, we do offer corporate training More details
Yes, we do.
Yes, we also offer weekend classes.
Yes, Koenig follows a BYOL(Bring Your Own Laptop) policy.
It is recommended but not mandatory. Being acquainted with the basic course material will enable you and the trainer to move at a desired pace during classes. You can access courseware for most vendors.
Yes, this is our official email address which we use if a recipient is not able to receive emails from our @koenig-solutions.com email address.
Buy-Now. Pay-Later option is available using credit card in USA and India only.
You will receive the digital certificate post training completion via learning enhancement tool after registration.
Yes you can.
Yes, we do. For details go to flexi
You can pay through debit/credit card or bank wire transfer.
Dubai, Goa, Delhi, Bangalore.
Yes you can request your customer experience manager for the same.
Yes of course. 100% refund if training not upto your satisfaction.

Prices & Payments

Yes of course.
Yes, We are

Travel and Visa

Yes we do after your registration for course.

Food and Beverages

Yes.

Others

Says our CEO-
“It is an interesting story and dates back half a century. My father started a manufacturing business in India in the 1960's for import substitute electromechanical components such as microswitches. German and Japanese goods were held in high esteem so he named his company Essen Deinki (Essen is a well known industrial town in Germany and Deinki is Japanese for electric company). His products were very good quality and the fact that they sounded German and Japanese also helped. He did quite well. In 1970s he branched out into electronic products and again looked for a German name. This time he chose Koenig, and Koenig Electronics was born. In 1990s after graduating from college I was looking for a name for my company and Koenig Solutions sounded just right. Initially we had marketed under the brand of Digital Equipment Corporation but DEC went out of business and we switched to the Koenig name. Koenig is difficult to pronounce and marketeers said it is not a good choice for a B2C brand. But it has proven lucky for us.” – Says Rohit Aggarwal (Founder and CEO - Koenig Solutions)
All our trainers are fluent in English . Majority of our customers are from outside India and our trainers speak in a neutral accent which is easily understandable by students from all nationalities. Our money back guarantee also stands for accent of the trainer.
Medical services in India are at par with the world and are a fraction of costs in Europe and USA. A number of our students have scheduled cosmetic, dental and ocular procedures during their stay in India. We can provide advice about this, on request.
Yes, if you send 4 participants, we can offer an exclusive training for them which can be started from Any Date™ suitable for you.