Oracle 12c DBA SCHEDULE
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 |
Note: Please test scripts in Non Prod before trying in Production.
Loading...
Sanjana Valecha
I want to learn database. Please share contact number so that we can reach you