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