Oracle12c Release 1 DBA I

Course:  OR12DBA
Duration:  5 Days
Level:  I
Course Summary

This course provides a complete, hands-on introduction to Oracle Database Administration including the use of Enterprise Manager Database Express (EMDE), SQL Developer and SQL*Plus.

« Hide The Details
Topics Covered In This Course

INTRODUCTION

  • COMPONENTS OF AN ORACLE DATABASE
  • DUTIES OF A DATABASE ADMINISTRATOR
  • DBA MANAGEMENT TOOLS
  • REVIEW OF THE SAMPLE SCHEMA
    • The Taxes Table
    • The ZipCodes Table
    • The Jobs Table
    • The Departments Table
    • The Employees Table
    • Objects In The EL Model
    • Analysis
    • Join Conditions
  • SQL*PLUS
    • Starting SQL*Plus
    • SQL Commands
    • PL/SQL Commands
    • SQL*Plus Commands
    • Login.sql (login.sql In Linux / UNIX)
  • SQL DEVELOPER
  • A BRIEF OVERVIEW OF SQL
  • WHAT GENERATION?
  • WHAT SUBLANGUAGES ARE SUPPORTED?
  • KEY SINGLE ROW FUNCTIONS
  • KEY GROUP FUNCTIONS
  • KEY ANALYTICAL FUNCTIONS
  • OTHER AVAILABLE ANALYTICAL TOOLS
  • HELP ME!
  • OBJECT NAMING
  • WHAT ARE THE KEY DATATYPES?
  • WHAT CONSTRAINTS ARE AVAILABLE FOR TABLE DEFINITIONS?
  • HOW DO YOU SELECT FROM MULTIPLE TABLES?
  • WHAT IS A SELF JOIN?
  • WHAT ELSE CAN YOU DO WITH A SELF REFERENCE?
  • NEW SQL FEATURES OF NOTE IN ORACLE12C
    • Top N And Bottom N Queries
    • Using Extended Datatypes
    • DEFAULT Values
    • IDENTITY Columns
    • Invisible Columns
    • Temporal Validity
    • Pattern Matching
    • Creating Multiple Indexes On Columns
    • Miscellaneous New SQL Features
  • A BRIEF OVERVIEW OF PL/SQL
  • NEW PL/SQL FEATURES OF NOTE IN ORACLE12C
    • White Lists
    • The WITH Clause For Functions
    • PRAGMA UDF
    • New Inquiry Directives
    • New DBMS_SQL Functionality
    • Enhanced Language Interface Features
    • Miscellaneous New PL/SQL Features For Oracle12c

CREATING ORACLE DATABASES

  • OVERVIEW OF DATABASE CREATION
  • THE ORACLE UNIVERSAL INSTALLER
  • PREREQUISE TASKS
    • Getting On The Server
    • Memory Requirements
    • Hardware Requirements
    • Software Requirements
    • Kernel Requirements
    • Resource Limits
    • Package Requirements
    • Required Users And Groups
    • Required Directories
    • What About Windows?
  • RUNNING THE INSTALLER
  • POST INSTALLATION
    • Environment
  • USING THE DATABASE CONFIGURATION ASSISTANT
  • DATABASE TEMPLATES

BASIC DATABASE ADMINISTRATION

  • A BRIEF ROADMAP
    • Basic Database Administration
    • Oracle Networking
    • Instance Management
    • Storage Management
    • Oracle Security
    • Schema Objects
    • Backup And Recovery
    • Oracle Advisors
    • Problem Resolution
    • Software Management
    • Automated Storage
  • DATABASE MANAGEMENT USING EMDE
  • ENVIRONMENTAL VARIABLES
  • ACCESSING ENTERPRISE MANAGER DATABASE EXPRESS
    • Enterprise Manager Database Express Access For Non-DBA Users
  • DATABASE ADMINISTRATION WITH OTHER TOOLS

ORACLE NETWORKING

  • ORACLE NETWORKING OVERVIEW
  • THE ORACLE NET LISTENER
  • MAKING A CONNECTION
    • Using Easy Connect
    • Using Local Naming
  • USING NET MANAGER
  • CONTROLLING THE LISTENER
    • Starting And Stopping The Listener
    • Securing The Listener
  • TROUBLESHOOTING NETWORKING

INSTANCE MANAGEMENT

  • MANAGING THE ORACLE INSTANCE
    • Needed Vocabulary
  • GETTING THE DATABASE UP
  • CHANGING PARAMETERS
  • BACKGROUND PROCESSES
  • OTHER PROCESSES
  • CONTROLLING MEMORY USAGE
  • THE STARTUP PROCESS
  • STARTUP NOMOUNT
  • STARTUP MOUNT
  • STARTUP | STARTUP OPEN
  • STARTUP RESTRICT | STARTUP OPEN RESTRICT
  • STARTUP FORCE
  • THE SHUTDOWN PROCESS
  • SHUTDOWN | SHUTDOWN NORMAL
  • SHUTDOWN TRANSACTIONAL
  • SHUTDOWN IMMEDIATE
  • SHUTDOWN ABORT
    • The Overall Shutdown Process
    • Using Services For Startup / Shutdown
  • MEMORY MANAGEMENT
  • ALTERNATIVE ARCHITECTURES
    • Real Application Clusters
    • Pluggable Databases

STORAGE MANAGEMENT

  • THE BASIC LOGICAL STRUCTURES
    • The Block
    • The Extent
    • The Segment
    • The Tablespace
    • The Database
  • THE PHYSICAL STRUCTURES
    • More About Control Files
    • More About Online Redo Logs
    • More About Archived Redo Logs
    • More About Rollback Segments
    • What Types Of Tablespaces Are There?
    • Tablespace Status
    • Default Tablespace Type
    • Changing Tablespace Size
    • Tablespace Properties
    • Encrypted Tablespaces
    • Why Add Tablespaces?
  • USING EMDE FOR STORAGE MANAGEMENT
  • CHANGING TABLESPACE AND OTHER ALERTS
  • MANAGING SPACE WITHIN TABLES AND INDEXES
  • SWITCHING LOG FILES
  • UNDO RETENTION
  • REVIEWING UNDO INFORMATION
  • THE UNDO ADVISOR
  • CHANGING UNDO TABLESPACE SIZE

ORACLE SECURITY

  • CREATING USER ACCOUNTS
    • Application Schemas
    • Automatically Created Accounts
  • TYPES OF PRIVILEGES
  • ABOUT ROLES
  • PREDEFINED ROLES
  • VIEWING ROLES IN ENTERPRISE MANAGER DATABASE EXPRESS
  • CREATING ROLES IN ENTERPRISE MANAGER DATABASE EXPRESS
  • DROPPING A ROLE
  • ADMIN AND GRANT OPTIONS
  • SYSDBA / SYSOPER DETAILS
  • USER ACCOUNT ADMINISTRATION
  • CONSIDERATIONS REGARDING PASSWORD CASE SENSITIVITY
  • PROFILES AND PASSWORD POLICIES
  • OTHER SECURITY FEATURES
    • Auditing
    • Fine Grained Auditing
    • The Virtual Private Database
    • Oracle Label Security
    • Oracle Database Vault
    • Oracle Data Redaction

SCHEMA OBJECTS

  • SCHEMA OBJECTS
    • Object Naming
    • Fully Qualified Naming
    • Aliases
    • Object Control
    • Table Management
    • Column Attributes
    • Available Datatypes
    • Large Object Enhancements
    • Column Constraints
    • Partitioning
    • Table Storage Attributes
    • Table Compression
    • Accessing Table Information
    • Creating A Table
    • Adding Columns
    • Dropping Columns
    • Adding Constraints
    • Disabling Constraints
  • LOADING DATA
    • Field Delimited Data
    • Comma Delimited Data
    • SQL Developer Import
    • SQL Developer Export
  • ABOUT INDEXES
    • Index Creation
  • VIEWS
    • Permission Control Within Views
  • STORED PROCEDURES
  • OTHER OBJECTS
    • Materialized Views
    • Synonyms
    • Sequences
    • Database Links

BACKUP AND RECOVERY

  • OVERVIEW / KEY CONCEPTS
  • USERS FOR BACKUP
  • THE FAST RECOVERY AREA
  • THE RMAN REPOSITORY
  • DATABASE CONFIGURATION
  • RMAN CONFIGURATION
  • BLOCK CHANGE TRACKING
  • ORACLE SECURE BACKUPS
  • ORACLE SUGGESTED BACKUP STRATEGY
  • SCHEDULING BACKUPS
  • BACKUP VALIDATION AND OTHER RMAN MAINTENANCE
  • RESTORE VALIDATION
  • THE REPORT COMMAND
  • THE LIST COMMAND
  • ORACLE ADVISED RECOVERY
  • USER-DIRECTED RECOVERY
  • FLASHBACK TABLE
  • FLASHBACK TO BEFORE DROP
  • FLASHBACK DATABASE
  • MANUAL RESTORE AND RECOVER
  • THE RECOVERY CATALOG
  • BACKUP MANAGEMENT
  • MONITORING FRA SPACE USAGE
  • ORACLE ADVISED RECOVERY

ORACLE ADVISORS

  • PROACTIVE MONITORING
    • The Automatic Database Diagnostic Monitor
  • MONITORING THE DATABASE WITH EMDE
  • USING THE PERFORMANCE HUB
    • The Summary Tab
    • The RAC Tab
    • The Activity Tab
    • The Workload Tab
    • The Monitored SQL Tab
    • The ADDM Tab
    • The Current ADDM Findings Tab
    • The Database Time Tab
    • The Resources Tab
    • The System Statistics Tab
    • Workload Repository Reports
    • Modifying Automatic Snapshot Settings
  • USING OTHER ADVISORS
    • SQL Tuning Advisor Details
    • The Automatic SQL Tuning Advisor
    • SQL Access Advisor
    • Running Memory Advisors
  • REAL APPLICATION TESTING
    • Database Replay
    • SQL Performance Analyzer (SPA)

PROBLEM RESOLUTION

  • OVERVIEW
  • THE RESOLUTION PROCESS

SOFTWARE MANAGEMENT

  • PATCH MANAGEMENT
  • UPGRADING THE DATABASE
  • EDITION-BASED REDEFINITION
  • REMOVING ORACLE SOFTWARE

AUTOMATED STORAGE

  • AUTOMATIC STORAGE MANAGEMENT OVERVIEW
  • THE ASM INSTANCE
  • DISKS, DISK GROUPS AND FAILURE GROUPS
  • CREATING AND DROPPING DISK GROUPS
  • ADDING AND DROPPING DISKS
  • ASM BACKUPS

HARDENING THE DATABASE

  • ELIMINATING SINGLE POINTS OF FAILURE
  • HARDENING DATA FILES
  • HARDENING THE CONTROL FILES
  • HARDENING THE REDO LOGS
    • Adding Redo Log Groups
  • HARDENING THE ARCHIVED REDO LOGS
  • HARDENING THE PERIPHERAL FILES
  • HARDENING THE BACKUPS
  • HARDENING THE FAST RECOVERY AREA

OS BACKUP & RECOVERY

  • WHY USE THE OPERATING SYSTEM?
  • CLOSED BACKUPS IN NOARCHIVELOG MODE
  • CLOSED RESTORE IN NOARCHIVELOG MODE
  • OPEN BACKUPS IN ARCHIVELOG MODE
  • RESTORING IN ARCHIVELOG MODE
  • RECOVERY IN ARCHIVELOG MODE
  • INCOMPLETE RECOVERY

ADVANCED RECOVERY MANAGER

  • CONFIGURING THE RECOVERY CATALOG
  • RUNNING SCRIPTS IN RMAN
  • CREATING SCRIPTS IN THE CATALOG

DATA PUMP

  • USING DATA PUMP
    • Command Line Syntax
    • Using Interactive Mode
    • Reattaching
    • Data Pump Import Options
    • EXPDP Examples
    • IMPDP Examples
  • ENTERPRISE MANAGER DATABASE EXPRESS AND DATA PUMP
  • THE DATA PUMP DRIVER
  • DATA DICTIONARY VIEWS

ADVANCED SECURITY

  • DBMS_RLS
    • Implementation Tasks
    • Our Example Scenario
    • The Policy Package
    • The Dynamic Predicate Package
    • Creating The Context And The Trigger
    • Using DBMS_RLS
    • Exempting Policies
  • DBMS_FGA
  • CONTROLLING COLUMN ACCESS WITH VIRTUAL COLUMNS

SHARED SERVER

  • INITIALIZATION PARAMETERS
  • ENABLING SHARED SERVERS
  • DISPATCHER CONFIGURATION
  • DATA DICTIONARY VIEWS
  • CONFIGURING THE CLIENT FOR SHARED SERVER

LOGMINER

  • LOGMINER BASICS
  • DBMS_LOGMNR
  • DBMS_LOGMNR.ADD_LOGFILE
  • DBMS_LOGMNR.START_LOGMNR
  • DBMS_LOGMNR. END_LOGMNR
  • DBMS_LOGMNR.MINE_VALUE
  • DBMS_LOGMNR.COLUMN_PRESENT
  • DBMS_LOGMNR_D
  • DBMS_LOGMNR_D.BUILD
  • DBMS_LOGMNR_D.SET_TABLESPACE
  • SUPPLEMENTAL LOGGING
  • LOGMINER USE SUMMARY
  • USING LOGMINER
  • USING ENTERPRISE MANAGER DATABASE EXPRESS WITH LOGMINER
Who Should Take This Course

This course is appropriate for anyone needing to understand and manage an Oracle 12c database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers, database administrators and IT management.

Recommended Prerequisites

Oracle12c SQL is required. Oracle12c PL/SQL is highly desirable.

Training Style

Instructor-led with hands-on workshops.

« Hide The Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
5/6/2019
Albany, NY
5/27/2019
Live on the Web
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com