Course Description

Oracle Flashback Technology is a group of Oracle Database features that that let you view past states of database objects or to return database objects to a previous state without using point-in-time media recovery.

Oracle Oracle Flashback features use the Automatic Undo Management (AUM) system to obtain metadata and historical data for transactions. They rely on undo data, which are records of the effects of individual transactions. For example, if a user executes an UPDATE statement to change a salary from 1000 to 1100, then Oracle Database stores the value 1000 in the undo data.

What are the requirements?

– A PC with internet is required for this course

– Desire and commitment to learn Oracle Flashback Technologies

What am I going to get from this course?

– Learn about Flashback database

– Learn about Flashback Table

– Learn about Flashback Data Archive

What is the target audience?

– Students, Professionals

-Anyone who wants to learn about Lean Manufacturing Flashback

How to access:-

Curriculum

Section 1: Introduction

1                  Overview and Undo Management

2                  Accidental Delete Scenario

3                  Flashback Delete and Update

Section 2: Requirements for Flashback

4                  Archive Log Mode Being Enabled

5                  Version Query Delete Commit

6                  Transaction Query

7                  Transaction Query continued

Section 3: Flashback Table

8                  Table Theory

9                  Table To Timestamp Lab Example

10               Table To Restore Point Lab Example

11               Behavior of Index during Flashback Table Operation

Section 4: Flashback Table To Before Drop

12               Flashback Table to Before Drop Theory

13               Flashback Table to Before Drop Theory continued

14               Flashback Table to Before Drop – Simple Example

15               Flashback Table to Before Drop – Truncate Table

16               Flashback Table to Before Drop – Same Table Dropped Multiple Times

Section 5: Flashback Database

17               Flashback Database Concepts, Restrictions and Effects on Datafile

18               Database Concepts, Restrictions and Effects on Datafile continued

19               State of the Database and Flashback Log Mode Being Enabled

20               Database To SCN – Simple Example

21               Normal vs Guaranteed Restore Points

Section 6: Flashback Data Archive

22               Concepts, Creation, Alteration, Dropping of Flashback Data Archives

23               Concepts, Creation, Alteration, Dropping of Flashback Data Archives continued

24               Assigning of Tables in various flashback data archive objects

25               Flashback Transaction

Here is a sample for the course completion certificate which you will recieve after complete the course. This certificate is widely accepted across industries and will boost your chances to grab the job opportunities.

Mail us at: [email protected] with below details to receive your certificate:

• Name
• Course Name
• Date of Completion
• Address