Oracle 12c
/ 11g DBA Course Contents
- Introduction to Databases & RDBMS
- Introduction to Oracle & difference
between Oracle versions. New Features in
12c
- Oracle Physical Structures
- Memory structures and Processes of
Oracle
- Dedicated Server and Multithreaded
Server
- Installation of Oracle10g, 11g,
12c under
Linux, Solaris and Win.
- Networking Clients
- Creation of a database from scratch and
using DBCA
- Managing Tablespaces and Data files
- Managing Log files and Control file
- Introduction to Data Blocks, Extents and
Segments
- Locally Managed Tablespaces and Auto
Segment Space mgmt.
- Managing Undo Space and Flashback
Features
- Security Management, User Accounts and
Privileges
- Managing Profiles and Resource Manager
- SQL*Loader, loading data from other data
sources
- Exporting and Importing data between
Oracle Databases
- Migrating databases
- Auditing Database usage using Audit
features, FGA, triggers.
- Introduction to Oracle Database Control
- Using Enterprise Manager through Web
Browser
-
Creating Pluggable
databases in 12c
-
Managing Pluggable
databases in 12c
Tuning
- Top mistakes people do with Oracle
Databases
- Tuning SQL Statements and Tuning
Applications
- Introduction to OLTP and Data warehouse
- Tuning Indexes
- Rule based & Cost based Optimizer Mode
- Viewing and Understanding Execution
Plans
- AUTOTRACE, SQL Analyze Utilities
- Tuning Memory Structures SGA, Buffer
Cache, Log buffers
- Tuning I/O Storage
- Tuning conflicts and contention tuning
- Tuning PGA, Sorts and miscellaneous
objects
- Automatic Storage Management (ASM) in
10g, 11g
- Using SQL Advisor
- Using Automatic Database Diagnostic
Monitor
- Using Undo Advisor
Backup and
Recovery
- Developing Backup and Recovery
Strategies.
- Understanding Offline (Cold) and Online
(Hot) Backups
- Taking Offline backups and understanding
No archive log mode
- Taking database in Archive log mode and
taking Online backups
- Performing Time based, Cancel based and
Change based recovery
- Introduction to RMAN
- Taking backups and performing recovery
using RMAN.
- New features in RMAN in 10g and 11g
versions
- Maintaining Backup sets in RMAN
- Block Media Recovery in RMAN.
- Data Guard and Standby Database in 10g,
11g
- Basic Replication and Advance
Replication
- Using
DATA PUMP utility
-
Oracle Golden Gate
|