Do not get relaxed with Oracle 11gR2 database administration, it is very vital to upgrade your skills to Oracle 12c. Add value to your projects, clients and most importantly to your career with this Oracle 12c new features training. Be the first and quick in the market to get real time exposure and experience on the new features with this Part I course. Part I and Part II courses will concentrate on training you on both theoretical concepts and activities with our focused approach.
Get hands-on experience on new Oracle 12c Database environment now.
- Install and Implement yourself.
- Simple and easy to understand.
- Meet industry standards.
Pre-requisites (Free)
No Pre-requisites needed
System Requirements
CPU:Minimum of Dual Core processor
Memory: 3 GB
OS: Windows/MacOS
Space: 40 GB of disk spac
Training Details
17 Sessions.
Trainer: Pawan Kumar Yaddanapudi.
Includes supporting documents, software’s and Log files.
Anytime assistance.
Video tutorials
Learn at your own pace.
Saves 50% of your money.
Revise any number of times for 6 months.
Assured quality and content as classroom/online training.
Online training
One scheduled session per day.
Good internet connectivity required.
Batch of minimum 5 students.
- What’s new?
- Details
- Software Installation – 12.1.0.2
- Pre-Oracle 12c
- Benefits of Multitenant Architecture
- Possible Configurations
- Multitenant CDB
- User container and Data
- Provisioning pluggable DB
- Multitenant CDB architecture
- Containers
- Users, Privileges and Roles
- Objects & Data dictionary views
- When to opt CDB?
- Layout
- Create CDB using SQLplus
- Create CDB using DBCA
- Whats new?
- Post creation
- ADR – Automatic Diagnostic Repository
- Provisioning New PDBs – Methods
- Dropping a PDB
- Migrating pre-12c to 12c CDB
- Connections
- Startup & Shutdown
- PDB settings
- Parameter Changes
- Tablespaces in PDB’s
- Permanent Tablespaces
- Default Tablespaces
- Temporary Tablespaces
- Users, Roles & Privileges
- Goals
- New RMAN clauses
- CDB backup
- PDB backup
- Recovery
- Instance failure
- NOARCHIVELOG mode
- Media failure
- Flashback CDB
- ILM challenges & Solution
- ADO & Heat map
- Enabling Heat map
- Compression
- Storate tiering
- Policies on segment
- Evaluation & Execution
- ADO DDL’s
- Online move Datafile/Partitions
- Compatibilities
- Partitions
- Define & pre 12c
- 12c solutions
- In-database archiving
- Temporal validity & Temporal history
- Temporal validity
- Temporal history
- Pre-12c Auditing
- 12c Auditing
- Security
- Simplicity – Audit policy
- Create/View/Enable/Disable audit policy
- Challenges in privileges
- New Admin privileges
- New system privileges
- Pre-12c privilege listing
- 12c privilege listing
- Overview & Operational activities
- Types of Data redaction
- Redaction policy
- Managing/applying policies
- Examples
- Modfy redaction policy
- Data redaction & other database security solutions
- Best practices
Frequently Asked Questions (FAQs)
Wondering what ORSKL can do for you?
Related Posts
There are many variations of passages of Lorem Ipsum available but majority have suffered alteration in some.There are many variations.
Build Simple Machine Learning Web Application using Python
Pre-processing data and developing efficient model on a given data set is one of the daily tasks of machine learning engineer with commonly used languages like Python or R. Not every machine learning engineer would get a chance or requirement to integrate the model into real time applications like web or mobile for end users […]
Ways to identify if data is Normally Distributed
Normal distribution also known as Gaussian distribution is one of the core probabilistic models to data scientists. Naturally occurring high volume data is approximated to follow normal distribution. According to Central limit theorem, large volume of data with multiple independent variables also assumed to follow normal distribution irrespective of their individual distributions. In reality we […]
Will highly correlated variables impact Linear Regression?
Linear regression is one of the basic and widely used machine learning algorithms in the area of data science and analytics for predictions. Data scientists will deal with huge dimensions of data and it will be quite challenging to build simplest linear model possible. In this process of building the model there are possibilities of […]
Will Oracle 18c impact DBA roles in the market?
There has been a serious concern in the market with announcement of Oracle Autonomous database 18c release. Should this be considered as a threat to Oracle DBA’s roles in the market? Let us gather facts available on the Oracle web to understand what exactly this is going to be and focus on skill improvements accordingly. […]
How Oracle database does instance recovery after failures?
INSTANCE RECOVERY – Oracle database have inherit feature of recovering from instance failures automatically. SMON is the background process which plays a key role in making this possible. Though this is an automatic process that runs after the instance faces a failure, it is very important for every DBA to understand how is it made […]
Why should we configure limits.conf for Oracle database?
Installing Oracle Database is a very common activity to every DBA. In this process, DBA would try to configure all the pre-requisites that Oracle installation document will guide, respective to the version and OS architecture. In which the very common configuration on UNIX platforms is setting up LIMITS.CONF file from /etc/security directory. But why should […]
Why RMAN needs REDO for Database Backups?
RMAN is one of the key important utility that every Oracle DBA is dependent on for regular day to day backup and restoration activities. It is proven to be the best utility for hot backups, in-consistent backups while database is running and processing user sessions. With all that known, as an Oracle DBA it will […]
Will huge Consistent Reads floods BUFFER CACHE?
Oracle Database BUFFER CACHE is one of the core important architectural memory component which holds the copies of data blocks read from datafiles. In my journey of Oracle DBA this memory component played major role in handling Performance Tuning issues. In this Blog, I will demonstrate a case study and analyze the behavior of BUFFER […]
Can a data BLOCK accommodate rows of distinct tables?
In Oracle database, data BLOCK is defined as the smallest storage unit in the data files. But, there are many more concepts run around the BLOCK architecture. One of them is to understand if a BLOCK can accommodate rows from distinct tables. In this article, we are going to arrive at the justifiable answer with […]
Can you really flush Oracle SHARED_POOL?
One of the major player in the SGA is SHARED_POOL, without which we can say that there are no query executions. During some performance tuning trials, you would have used ALTER SYSTEM command to flush out the contents in SHARED_POOL. Do you really know what exactly this command cleans out? As we know that internally […]
