• ISQL Global Logo

  • About Us

  • Certification

  • Courses

  • Corporate

  • Placements

  • Contact Us

  • Location

    Oracle Database 12c-New-Features-for-Administrators-2.0 Training & Placements in Chennai SQL STAR

    Oracle Database 12c R1: New Features for Administrators Ed 2

    (The Course materials and Course Completion Certificates are directly delivered from Oracle University to those seeking for Foreign Opportunity)

    (Government of India Approved Education Center)

    In the Oracle Database 12c: New Features for Administrators Ed 2 course, you’ll learn about the new and enhanced features and options of Oracle Database 12c. Expert instructors will teach you how these features and options increase security, manageability and performance. In this course, you will be introduced to Oracle Database Cloud Service.
    In the Oracle Database 12c: New Features for Administrators Ed 2 course, you’ll learn about the new and enhanced features and options of Oracle Database 12c. Expert instructors will teach you how these features and options increase security, manageability and performance. In this course, you will be introduced to Oracle Database Cloud Service.
    Learn To:
    • Manage the Oracle multitenant container databases and pluggabledatabases.
    • Configure Heat Map and use Automatic Data Optimization.
    • Benefit from Online Datafile Move.
    • Understand the new Temporal capabilities as well as In-Database Archiving with Row-archival.
    • Enforce security with the Unified Auditing, the new administrativeprivileges, Privilege Analysis, and Data Redaction.
    • Increase SQL performance with the Database In-Memory option, and FullDatabase In-Memory Caching and the Automatic Big Table Caching features.
    • Benefit from optimizer enhancements such as Adaptive Execution Plans and SQL Plan Directives, Real-Time ADDM and Compare Period ADDM.
    • Use enhanced features of Resource Manager in multitenant containerdatabases and pluggable databases.
    • Understandhow and when to use enhancements in Data Pump, partitioning, and SQL.
    • Gain an understanding of the Oracle Database Cloud Service.
    Benefits to You Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
    Hands-on Practices and Demonstrations Hands-on practices and available demonstrations help you learn how to use these new or enhanced features of Oracle Database 12c. You'll explore using Oracle Enterprise Manager Cloud Control and other tools like Oracle Enterprise Manager Database Express SQL Developer to manage, monitor and administer your data center. You will also learn about performance new features of the first patchset of Oracle Database 12c: Full Database In-Memory Caching, the In-Memory Column Store which is one of the most important features of the 12.1 first patchset, and Automatic Big Table Caching.
    Suggested Prerequisite
    • Goodknowledge of Oracle Database 11g
    Required Prerequisite
    • Using Oracle Enterprise Manager Cloud Control 12c Ed 2
    Audience
    • Administrator
    • Administrator
    • Database Administrators
    • Database Administrators
    • System Administrator
    • System Administrator
    Course Objectives
    • Explore new Oracle Data Pump features and SQL*Loader Express Mode
    • Create, manage and monitor multitenant container databases and pluggabledatabases and their resources consumption with Resource Manager
    • Manage datafile online operations, heat map and automatic dataoptimization, archive data using Row-archival or Temporal Validityand Temporal History
    • Manage security by using the new unified auditing, the new privileges,such as SYSBACKUP, the privilege analysis, and by creating andmanaging Data Redaction policies
    • Use the Recovery Manager enhancements
    • Manage the database performance with monitoring DB operations, Real-TimeADDM and Compare Period ADDM
    • Understand the new in-memory capabilities of the Database In-Memory, FullDatabase In-Memory Caching, and Automatic Big Table Caching
    • Tune the SQL performance using Adaptive Execution Plans, SQL PlanDirectives and statistics enhancements
    • Use online operations during partition movement and compression, andother DDL operations
    • Use partial global partitioned indexes
    • Explainnew SQL enhancements such as extended data type column and SQL rowlimiting clause
    • Gain an understanding of the Oracle Database Cloud Service

    Course Topics
    Enterprise Manager and Other Tools

    • OUI,DBCA
    • Enterprise Manager (EM) Cloud Control home page
    • Enterprise Manager Express home page versus Enterprise Manager DatabaseControl
    • SQL Developer with new functionalities
    Basics of Multitenant Container Database (CDB)
    • Differences between the root container and pluggable database containers
    • Structureof the root
    • Structureof Pluggable Database (PDB)
    • CDB_xxxand DBA_xxx views
    • Benefitsof the multitenant architecture
    • Impactsin Security, Data Guard, Oracle GoldenGate, Oracle Streams,XStream, and Scheduler
    Configuring and Creating CDB and PDBs
    • Exploring the Structure (CDB_xxx views and EM)
    • Tools:DBCA and SQL*Plus
    • Configurationand creation of CDB
    • Create a PDB from a non-CDB
    • Clonea PDB into the same CDB or into another CDB using DB links
    • Create a new PDB from PDB$SEED
    • Plugin an unplugged PDB
    • Toolsused: SQL Developer, DBCA and SQL*Plus and EM Database Express
    Managing CDB and PDBs
    • Connectto CDB as administrator
    • Startup a CDB
    • ChangePDB state
    • Shutdown a CDB
    • Open/ Close a PDB (SQL*Plus, srvctl, EM)
    • Open/ Close all PDBs
    • Preserveor discard the PDBs open mode when the CDB restarts
    • Connectto a PDB using a service name
    Managing Table spaces, Common and Local Users, Privileges and Roles
    • Createpermanent tablespaces in the root and PDBs
    • Manage common and local roles granted commonly or locally
    • Manage common and local schemas and Users in the root and PDBs
    • Manage system and object privileges to common and local grantees grantedcommonly or locally
    Managing Backup / Recovery / Flashback
    • Backup a whole CDB
    • Backup a PDB
    • Flashback at CDB level
    • Recover PDB from PDB datafiles loss
    • Recover CDB from redo log files, control files, undo datafiles loss
    • Explainthe two methods of migration
    Online Datafile Move and Automatic Data Optimization
    • Configureheat map
    • Dataclassification in 12c : tablespace, group, object, row levels
    • Policydeclaration: simple declarative SQL extension
    • Customizedschedule with DBMS_ILM package
    • Compression levels and types
    • Customized automated action execution with User-defined function
    • Automatic movement and compression
    • Execution in scheduled maintenance windows and by MMON
    In-Database Archiving
    • SetROW ARCHIVAL VISIBILITY for session level visibility control
    • UserOW ARCHIVAL clause to enable row lifecycle state for applications
    • Use predicate on ORA_ARCHIVE_STATE column
    • New clause of CREATE / ALTER TABLE to set a Temporal Validity: PERIODFOR
    • Challenges of old data in tables and 11g solutions
    • In-database archiving new solutions
    • Temporal Validity versus Temporal History (Transaction Time of FDA)
    • New SQL temporal data type
    Auditing Enhancements
    • Enabling the Unified Audit Trail
    • Creating audit policies
    • Creating a separate tablespace for the unified audit trail
    • Configuring the Unified Audit Trail to set a tolerance level for loss of auditrecords
    • Overview of the Unified Audit Trail
    • Granting the AUDIT_ADMIN role to a User for audit trail configuration andmanagement
    • Review of 11g R2 audit trail implementation
    Privileges Enhancements
    • Creating and starting/stopping privilege captures
    • Implementing Separation of Duty for Database Administration Tasks
    • Querying DBA_PRIV_CAPTURES
    • Overview of Database Privilege Analysis
    • Using Database Privilege Analysis
    • Granting the CAPTURE_ADMIN role to enable management of privilege captures
    • Explaining the purpose of the default ORA$DEPENDENCY profile
    • Viewing privilege profile data
    Oracle Data Redaction
    • Understanding Masking of Statements Containing Subqueries
    • Viewing Information About Masking Policies by Querying REDACTION_POLICIESand REDACTION_COLUMNS
    • Managing Masking Policies
    • Administering the EXEMPT REDACTION POLICY system privilege to enable a User toview unmasked values
    • Best practices for defining policy expressions
    • Overview of Oracle Data Redaction
    • Types of Masking Policies
    General RMAN New Features and FDA Enhancements
    • Creating Multisection Backups
    • Transporting Data: Processing steps
    • Backing up and Restoring Very Large Files
    • Using the SYSBACKUP Privilege
    • Prerequisitesand Limitations
    • Using SQL, DESCRIBE Command, Duplication Operation with the NOOPENoption
    • Transporting Data Across Platforms
    • Making Database Connections With RMAN
    Monitoring DB Operations
    • Define a DB operation
    • Usecases
    • CurrentTools
    • DBOperation Active Report
    • DBOperation Tuning
    • Overview
    • Monitoring the Progress of Operations
    • Monitoring:Bracketing an Operation
    Real-Time ADDM and Compare Period Advisor
    • Goals
    • Emergency Monitoring
    • Realtime ADDM
    • Requirements for a report
    • Reporteditems
    • Define Workload dimensions
    • Root Causes
    • Usecases
    ADR and Network Enhancements
    • New File types
    • Improveperformance by Compression
    • New command for ADRCI
    • New File locations
    • Setup Compression
    • ADR file types
    In-Memory Column Store
    • Deployment and behaviors
    • Rowformat and columnar format
    • Compression ratio
    • IMCU synchronization
    • Newdictionary tables and added columns
    • NewSGA component:
    • In-MemoryDatabase option goals and benefits
    • New statistics: IM %
    In-Memory Caching
    • Explaining the two buffer replacement algorithms of Automatic Big Table Caching
    • Using Full Database In-Memory Caching
    • Configuring Automatic Big Table Caching with PARALLEL_DEGREE_POLICY andDB_BIG_TABLE_CACHE_PERCENT_TARGET initialization parameters
    • Setting up Full Database In-Memory Caching
    • Using Automatic Big Table Caching
    SQL Tuning
    • Statistics Gathering Performance Improvements
    • SQLPlan Directives
    • Enhancementsto Extended Statistics
    • AdaptiveSQL Plan Management
    • Histogram Enhancements
    • AdaptiveExecution Plans
    Resource Manager and Other Performance Enhancements
    • Current Architecture: Unix multiprocess / one thread, NT/Windows oneprocess / multithread
    • Manage runaway queries
    • Manage resources between PDBs
    • Control the in-memory database repopulation resource consumption
    • Manage resources within a PDB
    • NewArchitecture: Multiprocess / MultiThread
    • Manage resources with CDB and PDBs plans
    • Automated maintenance tasks
    Index and Table Enhancements
    • Using the following DDL statements in an online manner
    • Supportfor invisible columns
    • Describe the Advanced Row Compression
    • Describe online redefinition supports
    • Multiple indexes on the same set of columns as long as some characteristicis different
    • Explain LOCK timeout during FINISH_REDEF_TABLE
    • Createtable with INVISIBLE columns
    Oracle Database Cloud Service: Overview
    • Database as a Service Architecture & Features and Tooling
    • Automated Database Provisioning
    • Managing the Compute Node Associated With a Database Deployment
    • Patching Database as a Service
    • Using the Oracle Database Cloud Service Console to Manage Patches
    • Backing Up and Recovering Databases on Database as a Service
    • Performing Recovery by Using the Service Console
    • Software Editions: Included Database Options and Management Packs

    AWS Training Data Science Training in ISQL Global Big Data Training in ISQL Global

    All rights reserved. ©1999 - 2022, SQLSTAR Global.

    Terms of Service | Privacy Policy