SQLSTAR Global Logo
Location Contact Us Certification Placements Corporate Courses About Us

    Oracle Database 12c Administration Workshop 2.0 Training & Placements in Chennai "ISQL Global"

    Oracle Database 12c R2: Administration Workshop Ed 3
    (Course materials and Course Completion Certificates are directly delivered from Oracle University to those required for Foreign Opportunity)

    (Government of India Approved Education Center)

    The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.
    The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.
    Learn To:
    • Managean Oracle Database instance.
    • Configurethe Oracle Network environment.
    • Create and manage storage structures.
    • Manageand move data.
    • Create and manage Users.
    • Monitorthe database and manage performance.
    • Create and manage Database as a Cloud Service database deployments.
    Benefits To YouYou will benefit from this course as you learn detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition you learn how to create Users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course. To provide an acceptable response time to Users and manage resources effectively, you learn how to monitor your database and manage performance.
    Prerequisites
    Suggested Prerequisite
    • Aworking knowledge of SQL and PL/SQL packages is very helpful inthe course.
    • Basic knowledge of Linux operating system
    Audience
    • Database Administrators
    • Database Administrators
    • DatabaseDesigners
    • DatabaseDesigners
    • Support Engineer
    • Support Engineer
    • Technical Administrator
    • Technical Administrator
    • DataWarehouse Administrator
    • DataWarehouse Administrator
    • DataWarehouse Administrator
    Course Objectives
    • Backup, restore, and patch DBCS database deployments
    • Describe the DBaaS and on-premises Oracle Database architectures
    • Manage database instances
    • ManageUNDO data
    • Movedata between databases
    • Implementbasic backup and recovery procedures
    • Monitorand tune database performance
    • TuneSQL to improve performance
    • Manage resources with Oracle Database Resource Manager
    • Createpluggable databases (PDBs)
    • Configurethe Oracle network environment
    • AdministerUser security and implement auditing
    • Create and manage tablespaces
    • Manage storage space
    • Create and manage Database as a Cloud Service (DBCS) database deployments
    • Registerdatabases and manage performance with Enterprise Manager CloudControl

    Course Topics
    Getting Started

    • Course Objectives
    Exploring Oracle Database Architecture
    • Querying the Oracle Data Dictionary
    • Oracle Database Tools
    • Oracle-SuppliedUser Accounts
    • Oracle Database Server Architecture
    • Oracle SQL and PL/SQL
    • Connecting to Oracle Databases
    • Introducing Oracle Database
    • RelationDatabase Models
    Managing Database Instances
    • Initialization Parameter Files
    • Opening and Closing PDBs
    • Starting Up Oracle Databases
    • Shutting Down Oracle Databases
    • Querying Dynamic Performance Views
    • Working with the Automatic Diagnostic Repository (ADR)
    Creating PDBs
    • Methods and Tools to Create PDBs
    • Dropping PDBs with SQL*Plus
    • Unplugging and Pluggin In PDBs with SQL*Plus
    • Cloning PDBs with SQL*Plus
    • Creating PDBs from Seed with SQL*Plus
    Configuring the Oracle Network Environment
    • Configuring Listeners for Static Service Registration
    • DedicatedVersus Shared Server Configurations
    • HowListeners Work
    • Testing Oracle Net Connectivity with tnsping
    • Configuring Listeners for Dynamic Service Registration
    • Oracle Net Services
    • Configuring Local Naming for Connections
    • Configuring Communidation Between Databases
    Administering User Security
    • Authenticating Users
    • Assigning Quotas to Users
    • Creating Users
    • Granting Privileges
    • Creating and Granting Roles
    • Creating and Assigning Profiles
    • Applying the Principal of Least Privilege
    • Revoking Privileges and Roles
    Creating and Managing Table spaces
    • Implementing Oracle Manage d Files
    • Creating Table spaces in SQL*Plus
    • Moving and Renaming Online Data Files in SQL*Plus
    • Viewing Tablespace Information in SQL*Plus
    • HowTable Data is Stored
    • Altering and Dropping Table spaces in SQL*Plus
    Managing Storage Space
    • BlockSpace Management
    • Allocating Extents
    • FreeSpace Management Within Segments
    • RowChaining and Migration
    • Space-Saving Features
    • Types of Segments
    • Oracle Database Space Management Features
    • Understanding Deferred Segment Creation
    Managing UNDO Data
    • LocalUndo Mode Versus Shared Undo Mode
    • Comparing Undo Data and Redo Data
    • UndoData: Overview
    • Configuring Undo Retension
    • Categoriesof Undo
    • Storing Undo Information
    • Transactionsand Undo Data
    • Managing Undo
    Moving Data
    • Oracle Data Pump: Benefits
    • DataPump Export and Import Clients
    • SQL*LoaderOverview
    • DataPump Utility: Interfaces and Modes
    • Loading Methods
    • Oracle Data Pump: Overview
    • DataPump Import: Transformations
    • Moving Data: General Architecture
    Backup and Recovery Concepts
    • Categoriesof Failure
    • Understanding Types of Backups
    • Understanding Instance Recovery
    • FlashbackTechnology
    • DBAResponsibilities
    • Oracle Data Protection Solutions
    • Comparing Complete and Incomplete Recovery
    Monitoring and Tuning Database Performance
    • Database Maintenance
    • AutomaticDatabase Diagnostic Monitor
    • AutomaticWorkload Repository (AWR)
    • DatabaseServer Statistics and Metrics
    • PerformanceTuning Methodology
    • PerformancePlanning Considerations
    • Managing Performance Activities
    • PerformanceMonitoring
    SQL Tuning
    • OracleOptimizer
    • SQLAccess Advisor
    • SQLPlan Directives
    • SQLTuning Advisor
    • SQLTuning Process
    • OptimizerStatistics
    • AdaptiveExecution Plans
    • SQLPerformance Analyzer
    Oracle Database Resource Manager
    • ResourceManager Elements
    • Limiting CPU Utilization at the Database Level
    • Using the Active Session Pool Feature
    • Creating a Complex Resource Plan
    • Oracle Database Resource Manager: Overview
    • Limiting CPU Utilization at the Server Level
    • Creating a Simple Resource Plan
    • Using Resource Manager to Allocate Resources
    Enterprise Manager Cloud Control
    • Controlling the Enterprise Manager Cloud Control Framework
    • Starting the Enterprise Manager Cloud Control Framework
    • Stopping the Enterprise Manager Cloud Control Framework
    Introduction to Oracle Database Cloud Service
    • DBCS Architecture
    • Oracle Cloud: Overview
    • Additional Database Configuration Options
    • Featuresand Tooling
    • DatabaseCloud Service Offerings
    Creating DBCS Database Deployments
    • Creating a Database Deployment
    • Automated Database Provisioning
    • Creating an SSH Key Pair
    • HowSSH Key Pairs are Used
    • StorageUsed for Database Files
    Managing DBCS Database Deployments
    • Managing Network Access to DBCS
    • CloudTooling
    • Accessing Tools and Features from the DBCS Console
    • Enabling Access to a Compute Node Port
    • Scaling a Database Deployment
    • Managing the Compute Node Associated With a Database Deployment
    Backing Up and Restoring DBCS Database Deployments
    • Backing Up and Recovering Databases on DBCS
    • Creating an On-Demand Backup
    • Performing Recovery by Using the Console
    • Performing Recovery by Using the dbaascli Utility
    • BackupConfiguration
    • Customizing the Backup Configuration
    • BackupDestination Choices
    Patching DBCS Database Deployments
    • Using the dbaascli Utility to Manage Patches
    • Using the DBCS Console to Manage Patches
    • Patching DBCS
    Creating Master Encryption Keys for PDBs
    • Creating and Activating an Encryption Key
    • Determining Whether You Need to Create and Activate and Encryption Key for aPDB
    • CDBand PDB Master Encryption Keys
    Tablespace Encryption by Default
    • Using TDE
    • Defining the Keystore Location
    • Transparent Data Encryption (TDE) Overview
    • Managing the Software Keystore and Master Encryption Key
    • Managing the Keystore in CDBs and PDBs
    • Componentsof TDE
    • TablespaceEncryption by Default in DBCS
    • Controlling Tablespace Encryption by Default

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

Terms of Service | Privacy Policy