Oracle 12c DBA SCHEDULE

Share via:

Post Views: 0

Prerequisite for Oracle DBA Training.

The candidate should have knowledge on Basic SQL & Basic Unix.

Sno	Batch : 19th Jan 2019 Timings: 08.00-11.00 AM Faculty : Ajay
	Week – 1
1	Oracle 12c Architecture-1
2	Oracle 12c Architecture-2
3	Oracle 12c Architecture-3
4	Startup & Shutdown Modes / DB-Creation, TS-Mgmt
	Week – 2
5	SP File & OMF, Storage (Dictionary & Locally Managed)
6	Undo Mgmt, FB-Query, FB-Table and FB-Version Query
7	User / Role / Profile Mgmt / Schema Mgmt
8	Intro to Networking with Oracle 12c DB Links & Materialized Views (with MV-Logs)
	Week -3
9	Redo-Log & Control File Mgmt,TTS for a single partition
10	Logical Bkups – Reg & Incr Exports
11	Data Pump (expdp & impdp)
12	Bkup/Rec-1 – Cold-1, Bkup / Rec-2 – Cold-2
	Week -4
13	Bkup/Rec-3 – Hot Backup
14	Bkup/Rec-4 – RMAN-1 – Theory
15	Bkup/Rec-5 – RMAN-2 – Scenarios
	Week -5
16	12c Multitenant Architecture
17	Top-N Query, Recover Table using RMAN, TEMP Undo, Online stats
18	PDB Cloing Methods
19	Move active DBF, Redaction Policy, Invisible Columns, DDL Tracking
20	Oracle 12c Installations
	Week -6
21	Availability-1 Data-Guard / DB-Cloning
22	Availability – 2 Active / Snapshot Standby
23	Availability – 2 Logminer
	Week -7
24	PT-9 ASM (Auto Storage Management) PT-10 ASM Demo
25	PT-1 DB-Tuning, PT-2 Appl Tuning
26	PT-3 Memory Tuning
	Week -8
27	PT-4 NetworkTuning PT-5 AOS / AWR / ADDM / ASH / ASMM / ASSM / PTSM
28	PT-6 Flashback DB / Flashback Data Archive
29	PT-7 Partitioning / Special Indexes
30	PT-8 Resumable, Row-Chaining / Row-Migration