COURSE NAME
ORACLE DATABASE 11g ADMINISTRATION: Hands-on
This hands-on course covers all of the Oracle Database Administration topics. You gain the knowledge and the skills needed to create and configure Oracle 11g databases. You learn to retrieve and manipulate data efficiently using powerful SQL features manage SGA, instance management, file & tablespace management, create and manage database tables, views and sequences; maintain data integrity, administering partitioned objects, retrieving lost data, perform recovery operations to maintain consistent and available data; exploit automated backup and recovery techniques with Recovery Manager; user administration & security and enhance performance through indexes and PL/SQL optimization

DETAIL COURSE CONTENT
RETRIEVING DATA USING THE SQL SELECT STATEMENT
List the capabilities of SQL SELECT statements
Execute a basic SELECT statement

RESTRICTING AND SORTING DATA
Limit the rows that are retrieved by a query
Sort the rows that are retrieved by a query
Use ampersand substitution to restrict and sort output at runtime

USING SINGLE-ROW FUNCTINS TO CUSTOMIZE OUTPUT
Describe various types of functions available in SQL
Use character, number, and date functions in SELECT statements

USING CONVERSION FUNCTIONS AND CONDITIONAL EXPRESSIONS
Describe various types of conversion functions that are available in SQL
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Apply conditional expressions in a SELECT statement

REPORTING AGGREGATED DATA USING TEH GROUP FUNCTIONS
Identify the available group functions
Describe the use of group functions
Group data by using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause

DISPLAYING DATA FROM MULTIPLE TABLES
Write SELECT statements to access data from more than one table using equijoins and nonequijoins
Join a table to itself by using a self-join
View data that generally does not meet a join condition by using outer joins
Generate a Cartesian product of all rows from two or more tables

USING SUBQUERIES TO SOLVE QUERIES
Define subqueries
Describe the types of problems that the subqueries can solve
List the types of subqueries
Write single-row and multiple-row subqueries

USING THE SET OPERATORS
Describe set operators
Use a set operator to combine multiple queries into a single query
Control the order of rows returned

MANIPULATING DATA
Describe each data manipulation language (DML) statement
Insert rows into a table
Update rows in a table
Delete rows from a table
Control transactions

USING DDL STATEMENTS TO CREATE AND MANAGE TABLES
Categorize the main database objects
Review the table structure
List the data types that are available for columns
Create a simple table
Explain how constraints are created at the time of table creation
Describe how schema objects work

CREATING OTHER SCHEMA OBJECTS
Create simple and complex views
Retrieve data from views
Create, maintain, and use sequences
Create and maintain indexes
Create private and public synonyms

EXPLORING THE ORACLE DATABASE ARCHITECTURE
Explain the Memory Structures
Describe the Process Structures
Overview of Storage Structures

PREPARING THE DATABASE ENVIRONMENT
Identify the tools for Administering an Oracle Database
Plan an Oracle Database installation
Install the Oracle software by using Oracle Universal Installer (OUI)

CREATING AN ORACLE DATABASE
Create a database by using the Database Configuration Assistant (DBCA)

MANAGING THE ORACLE INSTANCE
Setting database initialization parameters
Describe the stages of database startup and shutdown
Using alert log and trace files
Using data dictionary and dynamic performance views

CONFIGURING THE ORACLE NETWORK ENVIRONMENT
Configure and Manage the Oracle Network
Using the Oracle Shared Server architecture

MANAGING DATABASE STORAGE STRUCTURES
Overview of tablespace and datafiles
Create and manage tablespaces
Space management in tablespaces

ADMINISTERING USER SECURITY
Create and manage database user accounts
Grant and revoke privileges
Create and manage roles
Create and manage profiles

MANAGING DATA CONCURRENCY
Monitor and resolve locking conflicts

MANAGING UNDO DATA
Overview of Undo
Transactions and undo data
Managing undo

IMPLEMENTING ORACLE DATABASE SECURITY
Database Security and Principle of Least Privilege
Work with Standard Database Auditing

DATABASE MAINTENANCE
Use and manage optimizer statistics
Use and manage Automatic Workload Repository (AWR)
Use advisory framework
Manage Alerts and Thresholds

PERFORMANCE MANAGEMENT
Use Automatic Memory Management
Use Memory Advisors
Troubleshoot invalid and unusable objects

INTELLIGENT INFRASTRUTURE ENHANCEMENTS
Use the Enterprise Manager Support Workbench
Managing Patches

BACKUP AND RECOVERY CONCEPTS
Identify the types of failure that can occur in an Oracle database
Describe ways to tune instance recovery
Identify the importance of checkpoints, redo log files, and archived log files
Overview of flash recovery area
Configure ARCHIVELOG mode

PERFORMING DATABASE BACKUPS
Create consistent database backups
Back up your database without shutting it down
Create incremental backups
Automate database backups
Manage backups, view backup reports and monitor the flash recovery area

PERFORMING DATABASE RECOVERY
Overview of Data Recovery Advisor
Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)

MOVING DATA
Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
Explain the general architecture of Oracle Data Pump
Use Data Pump Export and Import to move data between Oracle databases

DATABASE ARCHITECTURE AND ASM
Describe Automatic Storage Management (ASM)
Set up initialization parameter files for ASM and database instances
Start up and shut down ASM instances
Administer ASM disk groups

CONFIGURING FOR RECOVERABILITY
Configure multiple archive log file destinations to increase availability
Define, apply and use a retention policy
Configure the Flash Recovery Area
Use Flash Recovery Area

USING THE RMAN RECOVERY CATALOG
Identify situations that require RMAN recovery catalog
Create and configure a recovery catalog
Synchronize the recovery catalog
Create and Use RMAN stored scripts
Back up the recovery catalog
Create and use a virtual private catalog

CONFIGURING BACKUP SPECIFICATIONS
Configure backup settings
Allocate channels to use in backing up
Configure backup optimization

USING RMAN TO CREATE BACKUPS
Create image file backups
Create a whole database backup
Enable fast incremental backup
Create duplex backup and back up backup sets
Create an archival backup for long-term retention
Create a multisection, compressed and encrypted backup
Report on and maintain backups

PERFORMING USER-MANAGED BACKUP AND RECOVERY
Recover from a lost TEMP file
Recover from a lost redo log group
Recover from the loss of password file
Perform user-managed complete database recovery
Perform user-managed incomplete database recovery
Perform user-managed and server managed backups
Identify the need of backup mode
Back up and recover a control file

USING RMAN TO PERFORM RECOVERY
Perform complete recovery from a critical or noncritical data file loss using RMAN
Perform incomplete recovery using RMAN
Recover using incrementally updated backups
Switch to image copies for fast recovery
Restore a database onto a new host
Recover using a backup control file
Perform Disaster recovery

USING RMAN TO DUPLICATE A DATABASE
Creating a duplicate database
Using a duplicate database

PERFORMING TABLESPACE POINT –IN-TIME RECOVERY
Identify the situations that require TSPITR
Perform automated TSPITR

MONITORING AND TUNING RMAN
Monitoring RMAN sessions and jobs
Tuning RMAN
Configure RMAN for Asynchronous I/O

USING FLASHBACK TECHNOLOGY
Restore dropped tables from the recycle bin
Perform Flashback Query
Use Flashback Transaction

ADDITIONAL FLASHBACK OPERATIONS
Perform Flashback Table operations
Configure, Monitor Flashback Database and Perform Flashback Database operations
Set up and use a Flashback Data Archive

DIAGNOSING THE DATABASE
Set up Automatic Diagnostic Repository
Using Support Workbench
Perform Block Media Recovery

MANAGING MEMORY
Implement Automatic Memory Management
Manually configure SGA parameters
Configure automatic PGA memory management

MANAGING DATABASE PERFORMANCE
Use the SQL Tuning Advisor
Use the SQL Access Advisor to tune a workload
Understand Database Replay

SPACE MANAGEMENT
Manage resumable space allocation
Describe the concepts of transportable tablespaces and databases
Reclaim wasted space from tables and indexes by using the segment shrink functionality

MANAGING RESOURCES
Understand the database resource manager
Create and use Database Resource Manager Components

AUTOMATING TASKS WITH THE SCHEDULER
Create a job, program, and schedule
Use a time-based or event-based schedule for executing Scheduler jobs
Create lightweight jobs
Use job chains to perform a series of related tasks

ADMINISTERING THE SCHEDULER
Create Windows and Job Classes
Use advanced Scheduler concepts to prioritize jobs