Oracle DBA Online Training.
Enquire.Join and get training by Well Experienced & Certified tutors for your professional Courses.
Watch Sample Session!ORACLE DBA COURSE – LEARN @ YOUR CONVENIENCE
1 Introduction to database management systems
1.1 What is a database?
1.2 Popular database management system (DBMS) software and why Oracle DBMS
1.3 History and Current trends of DBMS and Database Administration
1.4 Tasks of a Database Administrator
2 Relational Database Model and Installing Oracle database software
2.1 Entity Relational (ER) Model Overview
2.2 Oracle flexible architecture
2.3 Installation of Oracle database software (Oracle DBMS)
3 Oracle Database Architecture
3.1 Components of an Oracle database and detailed architecture
3.2 Creation of the first Oracle database.
3.3 Startup and Shutdown of a database
4 Database Objects
4.1 Introduction
4.2 Tables, Indexes, Views and Synonyms
4.3 Packages, Stored procedures and Functions
4.4 Oracle Data Dictionary and some popular Data Dictionary views
5 Database Storage
5.1Tablespaces and allocation types
5.2 Create tablespaces
5.3 Create datafiles with fixed size and autoextend option
5.4 Control files, Redolog groups and members
5.5 NoArchivelog mode and Archivelog mode for a database
6 Oracle Networking
6.1Introduction
6.2 Oracle listener configuration
6.3 Oracle database connections from other computers
6.4 Oracle listener administration and TNS environment variables
6.5 Database Links
7 Oracle Utilities
7.1 Introduction
7.2 Export and Import
7.3Data Pump Export and Data Pump Import
7.4 Introduction to Oracle SQL* Loader
8 User Management, Roles and Privileges
8.1 Introduction
8.2 Create databases users
8.3 User roles and privileges
8.4 Identifying system and object privileges
8.5 Granting and revoking privileges
8.6 Creating and modifying roles
8.7 Displaying user security Information from the data dictionary
9 Used Managed (Manual) Backup and Recovery
9.1 Introduction
9.2 Cold Backup
9.3 Hot Backup
9.4 How to recover a database using Cold Backup
9.5 How to recover a database using Hot Backup
10 RMAN Backup and Recovery
10.1 Differences between RMAN method and manual method
10.2 Database backup using RMAN
10.3 RMAN catalog
10.4 Database backup using RMAN catalog
10.5 Querying the RMAN metadata
10.6 Introduction and overview to Backups to Tape
11 Oracle Database Upgrades
11.1 Introduction to Oracle versions and how to understand a version
11.2 How to upgrade from one version to another version
11.3 How to upgrade from one patchset to another patchset within a release
11.4 What are one-off patches
11.5 What is OPatch utility
12 Oracle Database Management Tools
12.1 Introduction to Oracle enterprise manager (OEM) control
12.2 Managing and monitoring databases
12.3 Managing database objects
12.4 Introduction to TOAD
13 Performance Tuning
13.1 Introduction
13.2 How to handle performance issues in the real world
13.3 V$ views for performance monitoring and analysis
13.4 How to size the Oracle database and memory for optimal performance
13.5 Explain Oracle UNDO management internals and sizing.
13.6 Explain Oracle TEMP space internals and sizing.
13.7 SQL Query tracing using TKPROF
13.8 Database wide tracing for Oracle Errors (Event Tracing)
13.9 Gather optimizer statistics using DBMS_STATS
14 Oracle ASM (Automatic Storage Management)
14.1 Introduction and benefits of ASM
14.2 ASM Setup and Configuration
14.3 ASM Parameter file, ASM Instance and working with DISKGROUPS
14.4 Querying ASM Information
14.5 Creating Database Files using ASM
15 Oracle Database High Availability (RAC, DataGaurd, Streams)
15.1 Oracle Real Application Clusters (RAC) Overview
15.2 Oracle DataGaurd (Physical and Logical Standby) Overview
15.3 Oracle Streams Overview