Oracle DBA 12c Training

• Managing components with Oracle Restart.
• Configuring and managing the Network Environment.
• Upgrading existing versions of Oracle Database to the latest Oracle Database 12c.
• Creating and managing Storage Structures
• Using the Oracle Support Workbench and My Oracle Support for updating Oracle Database software.
• Learning basic backup and recovery techniques.
• Installing Oracle Grid Infrastructure for Standalone Servers.
• Acquiring an understanding of the Oracle Database Cloud Service.
• Creating container databases and provisioning pluggable databases.
• Monitoring and troubleshooting the database while ensuring performance.
• Optimize the performance effectively and efficiently.

• Database Administrators
• Technical Administrator
• Data Warehouse Administrator
• Database Designers

• Working experience and knowledge of SQL and use of PL/SQL packages
• Basic knowledge of Linux operating system

1. Oracle Database 12c: Introduction to SQL:

• Introduction
  • Course Objectives, Course Agenda and Appendixes Used in this Course
  • Overview of Oracle Database 12c and Related Products
  • Overview of relational database management concepts and terminologies
  • Introduction to SQL and its development environments
  • What is the Oracle SQL Developer?
  • Starting SQL*Plus from Oracle SQL Developer
  • The Human Resource (HR) Schema
  • Tables used in the Course

• Retrieving Data using the SQL SELECT Statement
  • Capabilities of the SELECT statement
  • Arithmetic expressions and NULL values in the SELECT statement
  • Column aliases
  • Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
  • Use of the DESCRIBE command

• Restricting and Sorting Data
  • Limiting the Rows
  • Rules of precedence for the operators in an expression
  • Substitution Variables
  • Using the DEFINE and VERIFY command

• Using Single-Row Functions to Customize Output
  • Describe the differences between single row and multiple row functions
  • Manipulate strings with character function in the SELECT and WHERE clauses
  • Manipulate numbers with the ROUND, TRUNC and MOD functions
  • Perform arithmetic with date data
  • Manipulate dates with the date functions

• Using Conversion Functions and Conditional Expressions
  • Describe implicit and explicit data type conversion
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Nest multiple functions
  • Apply the NVL, NULLIF, and COALESCE functions to data
  • Use conditional IF THEN ELSE logic in a SELECT statement

• Reporting Aggregated Data Using the Group Functions
  • Group Functions
  • Creating Groups of Data
  • Restricting Group Results

• Displaying Data from Multiple Tables Using Joins
  • Introduction to JOINS
  • Types of Joins
  • Natural join
  • Self-join
  • Non equijoins
  • OUTER join

• Using Subqueries to Solve Queries
  • Introduction to Subqueries
  • Single Row Subqueries
  • Multiple Row Subqueries

• Using the SET Operators
  • Set Operators
  • UNION and UNION ALL operator
  • INTERSECT operator
  • MINUS operator
  • Matching the SELECT statements
  • Using ORDER BY clause in set operations

• Managing Tables using DML statements
  • Data Manipulation Language
  • Database Transactions

• Introduction to Data Definition Language
  • Data Definition Language

• Introduction to Data Dictionary Views
  • Introduction to Data Dictionary
  • Describe the Data Dictionary Structure
  • Using the Data Dictionary views
  • Querying the Data Dictionary Views

• Creating Sequences, Synonyms, Indexes
  • Overview of sequences
  • Overview of synonyms
  • Overview of indexes

• Creating Views
  • Overview of views

• Managing Schema Objects
  • Managing constraints
  • Creating and using temporary tables
  • Creating and using external tables

• Retrieving Data by Using Subqueries
  • Retrieving Data by Using a Subquery as Source
  • Working with Multiple-Column subqueries
  • Using Scalar subqueries in SQL
  • Correlated Subqueries
  • Working with the WITH clause

• Manipulating Data by Using Subqueries
  • Using Subqueries to Manipulate Data
  • Inserting by Using a Subquery as a Target
  • Using the WITH CHECK OPTION Keyword on DML Statements
  • Using Correlated Subqueries to Update and Delete rows

• Controlling User Access
  • System privileges
  • Creating a role
  • Object privileges
  • Revoking object privileges

• Manipulating Data
  • Overview of the Explicit Default Feature
  • Using multitable INSERTs
  • Using the MERGE statement
  • Performing flashback operations
  • Tracking Changes in Data

• Managing Data in Different Time Zones
  • Working with CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP
  • Working with INTERVAL data types

2. Oracle Database 12c: Admin, Install and Upgrade Accelerated

• Introduction
  • Course Objectives
  • Course Schedule
  • Overview of Oracle Database 12c
  • Overview of Oracle Cloud
  • Overview of the HR Schema
  • Oracle Database 12c Introduction

• Exploring the Oracle Database Architecture
  • Oracle Database Architecture: Overview
  • Oracle Database Instance Configurations
  • Connecting to the Oracle Database Instance
  • Oracle Database memory Structures (overview)
  • Process Architecture
  • Process Structures
  • Process Startup Sequence
  • Database Storage Architecture

• Oracle Software Installation Basics
  • Planning Your Installation
  • Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM
  • Operating System Groups and Users
  • Environment Variables
  • Configuring the Oracle Software Owner Environment
  • Using Oracle Universal Installer (OUI)
  • Installation Option: Silent Mode

• Installing Oracle Database Software
  • System Requirements for Oracle Database
  • Creating Operating System Groups and Users
  • Types of Installations

• Creating an Oracle Database by Using DBCA
  • Planning the Database Storage Structure
  • Types of Databases (based on workload)
  • Choosing the Appropriate Character Set
  • Understanding How Character Sets are Used
  • Setting the NLS_LANG Initialization Parameter
  • Using the Database Configuration Assistant (DBCA)

• Oracle Database Management Tools
  • Introducing Oracle Database Management Tools
  • Using SQL*Plus
  • Using SQL Developer
  • Logging in to Oracle Enterprise Manager Database Express
  • Using the Enterprise Manager Database Express Home Page
  • Understanding the Enterprise Manager Cloud Control Framework
  • Using Enterprise Manager Cloud Control

• Managing the Database Instance
  • Initialization Parameter Files
  • Starting an Oracle Database Instance
  • Shutting Down an Oracle Database Instance
  • Viewing Log Files
  • Using Trace Files
  • Using the Dynamic Performance Views
  • Data Dictionary

• Configuring the Oracle Network Environment
  • Oracle Net Services Overview
  • Oracle Net Listener Overview
  • Establishing Oracle Network Connections
  • Connecting to a Server
  • Tools for Configuring and Managing the Oracle Network
  • Using the Listener Control Utility
  • Using Oracle Net Configuration Assistant
  • Using Oracle Net Manager

• Administering User Security
  • Database User Accounts (overview)
  • Predefined Administrative Accounts
  • Creating a User
  • Authentication
  • Unlocking a User Account and Resetting the Password
  • Privileges
  • Roles
  • Profiles

• Managing Database Storage Structures
  • Understanding Storage of Data
  • Database Block contents
  • Exploring the Storage Structure
  • Creating a New Tablespace
  • Overview of Tablespaces Created by Default
  • Managing Tablespaces
  • Viewing Tablespace Information
  • Using Oracle Managed Files

• Managing Space
  • Space Management Overview
  • Block Space Management
  • Row Chaining and Migration
  • Free Space Management Within Segments
  • Types of Segments
  • Allocating Extents
  • Allocating Space
  • Creating Tables Without Segments

• Managing Undo Data
  • Undo Data Overview
  • Transactions and Undo Data
  • Storing Undo Information
  • Comparing Undo Data and Redo Data
  • Managing Undo
  • Configuring Undo Retention
  • Guaranteeing Undo Retention
  • Changing an Undo tablespace to a Fixed Size

• Managing Data Concurrency
  • Overview of Locks
  • Locking Mechanism
  • Data Concurrency
  • DML Locks
  • Enqueue Mechanism
  • Lock Conflicts

• Implementing Oracle Database Auditing
  • Separation of Responsibilities
  • Database Security
  • Monitoring for Compliance
  • Standard Database Auditing
  • Unified Audit Data Trail
  • Separation for Duties for Audit Administration (AUDIT_ADMIN and AUDIT_VIEWER roles)
  • Configuring the Audit Trail
  • Specifying Audit Options

• Backup and Recovery Concepts
  • Categories of Failures
  • Flashback Technology
  • Understanding Instance Recovery
  • Phases of Instance Recovery
  • Tuning Instance Recovery
  • Using the MTTR Advisor
  • Comparing Complete and Incomplete Recovery
  • Oracle Data Protection Solutions

• Backup and Recovery Configuration
  • Configuring for Recoverability
  • Configuring the Fast Recovery Area
  • Multiplexing the Control File
  • Online Redo Log File
  • Multiplexing the Online Redo Log File
  • Archived Redo Log Files
  • Archiver Process
  • Archived Redo Log File Naming and Destinations

• Performing Database Backups
  • Backup Solutions Overview
  • Oracle Secure Backup (overview)
  • User Managed Backup (overview)
  • Backup Terminology and Types of Backups
  • Using Recovery Manager (RMAN)
  • Configuring Backup Settings
  • Oracle-Suggested Backup
  • Backing Up the Control File to a Trace File

• Performing Database Recovery
  • Data Recovery Advisor
  • Loss of a Control File
  • Loss of a Redo Log File
  • Loss of a Datafile in NOARCHIVELOG Mode
  • Loss of a Noncritical Datafile in ARCHIVELOG Mode
  • Loss of a System-Critical Datafile in ARCHIVELOG Mode

• Moving Data
  • Moving Data: General Architecture
  • Oracle Data Pump
  • SQL*Loader
  • External Tables

• Performing Database Maintenance
  • Database Maintenance (overview)
  • Viewing the Alert History
  • Terminology
  • Automatic Workload Repository (AWR)
  • Statistic Levels
  • Automatic Database Diagnostic Monitor (ADDM)
  • Advisory Framework
  • Enterprise Manager and Advisors

• Managing Performance
  • Performance Monitoring
  • Tuning Activities
  • Performance Planning
  • Instance Tuning
  • Performance Tuning Methodology
  • Performance Tuning Data
  • Monitoring Performance
  • Managing Memory

• Oracle Database Cloud Service: Overview
  • Database as a Service Architecture, Features and Tooling
  • Software Editions: Included Database Options and Management Packs
  • Automated Database Provisioning
  • Managing the Compute Node Associated With a Database Deployment
  • Managing Network Access to Database as a Service
  • Enabling Access to a Compute Node Port
  • Scaling a Database Deployment & Patching Database as a Service
  • Using the Oracle Database Cloud Service Console to Manage Patches