Course Description
In this course, you will learn about security and maintenance concerns in an Oracle database with an introductory focus on Oracle SQL and PL/SQL for newer IT employees.
Audience Profile
- Database administrators
- Support engineers
- Technical consultants
- Systems administrators
- Network managers
- Technical support personnel
Prerequisites
Good knowledge of Oracle Database
Learning Objectives
- Create and administer user accounts in the Oracle 11g database.
- Backup and recover the database.
- Monitor, troubleshoot, and maintain the database
Course Outline
Module 1: SQL and PL/SQL
Lessons
• Basic SQL Syntax
• SQL Functions
• Advanced SQL Queries
• PL/SQL Program Structure
• Accessing the Database
Lab: Multiple SQL Labs
Lab: Multiple PL/SQL Labs
Module 2: Create and Oracle Database
Lessons
• Describe Oracle Database Architecture
• Understand the Instance Architecture
• Use the Management Framework and the Database Creation Assistant
Lab: Architecture/Advanced Memory Mgt.
Module 3: Controlling the Database
Lessons
• Start and Stop the Agent and the Listener
• Startup and Shutdown the Database
Lab: Starting and Stopping the Database
Module 4: Administering Users
Lessons
• Create and Manage Database User Accounts, and Manage Roles
• Grant and Revoke Privileges
• Control Resource Usage by Users
Lab: Using the Database Console (EM)
Module 5: Managing Schema Objects
Lessons
• Create and Modify Tables, Indexes, and Views
• Define Constraints
• View the Attributes and the Contents of a Table
Lab: Tables, Indexes and Constraints
Module 6: Oracle Database Security
Lessons
• Apply the Principal of Least Privilege
• Manage Default User Accounts
• Implement Standard Password Security Features
• Audit database activity
Lab: Creating Other Database Objects
Module 7: Proactive Maintenance: Objectives
Lessons
• Set Warning and Critical Alert Thresholds
• Collect and Use Baseline Metrics
• Use Tuning/Diagnostic Advisors/ADDM/ADR
Lab: Users and Security
Module 8: Recovery Manager Configuration
Lessons
• Parameters Affecting RMAN
• Use of a Flashback Recovery Area
• The CONFIGURE Command
• Persistent Settings
• NOCATALOG / CATALOG Mode
• Channel Allocation
• Controlfile Autobackup
• Retention Policies
Lab: Performance Metrics and Monitoring
Module 9: Recovery Manager Operations
Lessons
• Using the BACKUP Command
• Creating Backup Sets / Image Copies
• Compressed Backups
• Incremental Backups
• Block Change Tracking
• RMAN Backup Monitoring
• REPORT and LIST Commands
Lab: Archivelog Setup
Module 10: Non-Critical Loss Recovery
Lessons
• Password and Network Files
• Read-Only Tablespaces
• Temporary Tablespaces
• Index Tablespaces
• Redo Log Members / Control Files
Lab: Recovery Manager Configuration
Module 11: Database Recovery
Lessons
• Complete Recovery
• Incomplete Recovery
Lab: Recovery Manager Backups
Module 12: Flashback Database
Lessons
• When in Use
• Configuration and Use
• Monitoring Flashback Database
• Flash Recovery Area Maintenance
• Flash Recovery Area Monitoring
Module 13: User Error Recovery
Lessons
• The New Recycle Bin
• Querying Dropped Tables
• Flashback Versions Table
• Flashback Transaction Query
Module 14: Automatic Database Management
Lessons
• Management and Advisory Framework
• Automatic Statistics Collection
• The Automated Workload Repository
• Database Advisors
• Automatic Statistics Collection
Lab: Automated Management Tools
Module 15: Virtual Private Database
Lessons
• Row Level Control
• Column Level Control
Module 16: Oracle Auditing
Lessons
• Full Security Monitoring
