ISQLGlobal Global Logo
Contact UsCertificationPlacementsCoursesCorporateHome

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 - SQL STAR)

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.
  • Configure the 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 You

You 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 Designers
  • Support Engineer
  • Technical Administrator
  • Data Warehouse Administrator
  • Data Warehouse Administrator
Course Objectives
  • Backup, restore, and patch DBCS database deployments
  • Describe the DBaaS and on-premises Oracle Database architectures
  • Managedatabase instances
  • ManageUNDO data
  • Movedata between databases
  • Implementbasic backup and recovery procedures
  • Monitorand tune database performance
  • TuneSQL to improve performance
  • Manageresources with Oracle Database Resource Manager
  • Createpluggable databases (PDBs)
  • Configure the Oracle network environment
  • Administer User security and implement auditing
  • Create and manage table spaces
  • 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
  • OracleSQL and PL/SQL
  • Connecting to Oracle Databases
  • IntroducingOracle 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
    • Methodsand 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
    • ConfiguringListeners for Static Service Registration
    • Dedicated Versus Shared Server Configurations
    • HowListeners Work
    • TestingOracle Net Connectivity with tnsping
    • ConfiguringListeners for Dynamic Service Registration
    • OracleNet Services
    • ConfiguringLocal 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 Tablespaces

    • Implementing Oracle Managed Files
    • Creating Tablespaces 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 Tablespaces in SQL*Plus
    Managing Storage Space
    • BlockSpace Management
    • Allocating Extents
    • Free Space Management Within Segments
    • Row Chaining and Migration
    • Space-Saving Features
    • Types of Segments
    • Oracle Database Space Management Features
    • Understanding Deferred Segment Creation
    Managing UNDO Data
    • Local Undo 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*Loader Overview
    • Data Pump Utility: Interfaces and Modes
    • LoadingMethods
    • Oracle Data Pump: Overview
    • DataPump Import: Transformations
    • Moving Data: General Architecture
    Backup and Recovery Concepts
    • Categories of 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
    • Automatic Workload Repository (AWR)
    • DatabaseServer Statistics and Metrics
    • Performance Tuning Methodology
    • PerformancePlanning Considerations
    • Managing Performance Activities
    • PerformanceMonitoring
    SQL Tuning
    • Oracle Optimizer
    • SQLAccess Advisor
    • SQLPlan Directives
    • SQL Tuning Advisor
    • SQL Tuning Process
    • OptimizerStatistics
    • AdaptiveExecution Plans
    • SQLPerformance Analyzer
    Oracle Database Resource Manager
    • Resource Manager 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
    • UsingResource 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
    • DBCSArchitecture
    • OracleCloud: 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
    • EnablingAccess 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
    • PerformingRecovery by Using the Console
    • PerformingRecovery 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
    • TransparentData 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