Cource Agenda
D49996GC20_sg1
Day 1
Introduction
Retrieving Data Using the SQL SELECT Statement
Restricting and Sorting Data
Using single-Row Functions to Customize Qutput
Using Conversion Functions and Conditional Expressions
Day 2
Reporing Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables Using Joins
Using Subqueries to Solve Queries
Using the Set Operators
Day 3
Manipulating Data
Using DDL statements to Create and Manage Tables
Creating Other Schema Objects
D49994GC20_sg1
Day 4
Introduction
Controlling User Access
Managing Schema Objects
Managing Objects with Data Dictionary Views
Day 5
Manipulating Large Data Sets
Managing Data in Different Time Zones
Retrieving Data by Using Subqueries
Regular Expression Support
D50102GC20_sg1-2
Day 6
Exploring the Oracle Database Architecture
Preparing the Database Environment
Createing an Oracle Database
Managing Database Instances
Day 7
Managing ASM Instances
Configuring the Oracle Network Environment
Mnaging Database Storage Structures
Administering User Security
Day 8
Managing Data Concurrency
Managing Undo Data
Implementing Oracle Database Auditing
Day9
Database Maintenance
Performance Management
Backup and Recovery Concepts
Day 10
Performing Dabase Backups
Performing Database Recovery
Moveing Data
Working with Support
D50079GC20_sg1-2-3
Day 11
Core Concepts and Tools of the Oracle Database
Configuring for Recoverability
Using the RMAN Recovery Catalog
Configuring Backup Settings
Day 12
Create Backups with RMAN
Restore and Recovery Tasks
Using RMAN to Perform Recovery
Monitonring and Tuning RMAN
Day 13
Diagnosing the Database
Using Flashback Technology I
Using Flashback technology II
Performing Flashback Database
Day 14
Managing Memory
Managing Database Performance
Managing Performance by SQL Tuning
Managing Resources
Automationg Tasks with the Scheduler
Day 15
Managing Space
Managing Space for the Database
Duplicating a Database