Oracle Database 18c Administration Training Course

Course Contents - DAY 1

Course Introduction

• • Administration and Course Materials
• • Course Structure and Agenda
• • Delegate and Trainer Introductions

Session 1: INTRODUCTION TO ORACLE DATABASE

• • Overview of the Oracle database
• • Overview of the Oracle Cloud
• • Relational database concepts
• • Database administration tasks

Session 2: ORACLE DATABASE 18c ARCHITECTURE

• • Overview of the Oracle database architecture
• • The Oracle database instance
• • Oracle Database memory structures
• • Process architecture and structures
• • Server and client processes
• • The Oracle database storage architecture
• • Connect to the Oracle database instance

Session 3: ADMINISTER A DATABASE INSTANCE

• • Administrative tools available to a DBA
• • Use SQL*Plus in Oracle to manage a database instance
• • Use SQL Developer to manage a database instance
• • Administer the database using Enterprise Manager (EM)
• • Overview of the Enterprise Manager framework
• • Access Enterprise Manager Database Express
• • The Enterprise Manager Database Express Home Page
• • Enterprise Manager Cloud Control
• • Initialization parameter files

Session 4: CONFIGURE THE ORACLE NETWORK ENVIRONMENT

• • Overview of network configuration
• • Oracle Net Listener configuration and management
• • Oracle Net naming methods
• • Tools for configuring and managing the Oracle network
• • Using the Net Configuration Assistant
• • Configure client connections with Net Manager
• • View listener configuration
• • Start and stop the Oracle listener
• • Use TNSPING to test Oracle Net connectivity
• • Connect to the database
• • Configure Net Services with Enterprise Manager

Session 5: STORAGE STRUCTURES

• • Overview of data storage
• • The database block
• • Overview of tablespaces and datafiles
• • Use Enterprise Manager to view the storage structure of the database
• • Create and alter tablespace commands
• • Temporary tablespaces
• • Create and manage datafiles
• • Use OMF
• • Drop tablespaces and datafiles

Oracle Database 18c Administration Training Course

Course Contents - DAY 2

Session 6: MANAGE USERS

• • Predefined database administration accounts
• • User accounts
• • Create a user account
• • User authentication
• • Change a user's password
• • Manage a user account
• • Drop a user account
• • Monitor user information
• • Terminate user sessions
• • Create a Schema Only Account

Session 7: MANAGE PRIVILEGES

• • Database access
• • Oracle supplied roles
• • System and object level privileges
• • The grant and revoke commands
• • Create,modify and drop roles
• • Use predefined roles

Session 8: MANAGE PROFILES AND RESOURCES

• • Overview of user profiles
• • Profile resource parameters
• • Create profile command
• • Manage passwords with profiles
• • Control resource usage with profiles
• • Maintain profiles

Session 9: DATABASE AUDITING

• • Overview of database security
• • Overview of database auditing
• • Security compliance
• • Standard auditing
• • Unified audit trail
• • Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles
• • Configure the audit trail
• • Specify audit options

Oracle Database 18c Administration Training Course

Course Contents - DAY 3

Session 10: DATA CONCURRENCY AND LOCK CONFLICTS

• • Levels of locking in Oracle
• • Methods used to acquire locks
• • Data concurrency
• • Possible causes of contention
• • DML locks
• • Prevent locking problems
• • Detect lock contention
• • Resolve conflicts

Session 11: UNDO MANAGEMENT

• • Undo data overview
• • Monitor and administer undo
• • Configure undo retention
• • Switch undo tablespaces
• • Specify the retention period
• • Guarantee undo retention
• • Retention period for flashback queries
• • View undo space information
• • Use the undo advisor
• • Size the undo tablespace
• • Alter an undo tablespace to a fixed size

Session 12: BACKUP AND RECOVERY CONFIGURATION

• • Oracle backup solutions
• • Oracle suggested backup strategy
• • Overview of database backup,restore and recover
• • Flashback technology
• • Types of failure
• • Instance recovery
• • Tune instance recovery
• • The MTTR Advisor
• • Media failure
• • Configure a database for recoverability

Session 13: PROACTIVE DATABASE MAINTENANCE

• • Database Maintenance
• • View the alert log
• • The Automatic Workload Repository
• • Statistic levels
• • The Automatic Database Diagnostic Monitoring
• • Monitor an Oracle database
• • Use the Advisors
• • Set up notification rules

Session 14: PERFORMANCE MANAGEMENT

• • Tuning information sources
• • Performance monitoring
• • Tuning activities
• • Performance planning
• • Instance tuning
• • Performance tuning methodology
• • Performance tuning data
• • Monitoring performance
• • Managing memory
• • Manage Private Temporary Tables

Oracle Database 18c Administration Training Course

Course Contents - DAY 4

Session 15: SQL TUNING

• • SQL tuning
• • Cancel a SQL Statement in a Session
• • The Oracle Optimizer
• • SQL Plan directives
• • Adaptive execution plans
• • SQL Advisors
• • Automatic SQL Tuning results
• • Implement automatic tuning recommendations
• • SQL Tuning Advisor

Session 16: MOVING DATA

• • Create directory objects
• • Data Pump architecture
• • Data Pump data dictionary views
• • Data Pump interactive mode
• • Data Pump API
• • Use Data Pump to export data
• • Use Data Pump to import data
• • Overview of SQL Loader
• • Command line parameters
• • Record filtering
• • Control file keywords
• • Datafiles
• • SQL Loader data paths
• • External Tables

Session 17: MANAGING RESOURCES WITH RESOURCE MANAGER

• • Overview of the Database Resource Manager
• • Use the Resource Manager
• • Create Resource Plans
• • The default maintenance resource manager plan
• • Create Resource Plan Directives
• • Allocate resources for Resource Plans

Session 18: AUTOMATE TASKS WITH THE SCHEDULER

• • Introduction to the Scheduler
• • Access Rights
• • Scheduler components and workflow
• • Create a Job
• • Job Classes
• • Use time based,event based schedules
• • Create an event based schedule

Oracle Database 18c Administration Training Course

Course Contents - DAY 5

Session 19: MANAGE SPACE

• • Overview of space management
• • Block space management within segments
• • Segment types
• • Allocate extents
• • Allocate space
• • Row chaining and migration
• • Create tables without segments

Session 20: ORACLE SUPPORT

• • The Enterprise Manager Support Workbench
• • Register for security updates
• • Work with Oracle Support
• • My Oracle Support integration
• • Log Service Requests
• • Manage patches
• • Apply a patch