Course Instructor

The course Instructor, Muralidhar Punyala, is an IT professional with 23 years of global IT experience. Murali worked with various global organizations in countries like USA, UK, Singapore, Hong Kong and India. Currently, Murali is the Director at Uclid IT School and previously worked as Practice Manager at Oracle India.

Course Curriculum

1. Introduction to DBA

• What is Database? Why Database?
• Major Databases and Database Vendors
• Roles and Responsibilities of DBA

2. Oracle Database Architecture

• Database & Instance
• Memory Structures – SGA, PGA
• How does Cloud Computing Work?
• Background Processes
• Server Processes
• Database Files
• Physical & Logical Structures

3. Installing Oracle 12c Database Server

• Requirements for Installation
• Oracle Universal Installer (OUI)
• Installing Oracle Software

4. Creating Oracle Database

• Role-based & Speciality Certifications
• Planning the Database
• Creating Database
• Exploring the seed database

5. Starting & Stopping Database

• Startup & Shutdown modes
• Starting & Stopping the database
• Read-only & Restricted modes

6. Parameters & Parameter Files

• Initialization Parameters
• Static and Dynamic parameters
• Parameter Files
• Text & Server Parameter Files
• System & Session Level Parameters
• Changing Parameter values

7. Data Dictionary

• Understanding Data Dictionary
• Static & Dynamic Performance Views

8. Managing Diagnostic data

• Diagnostic files
• Automatic Diagnostic Repository (ADR)
• Viewing Diagnostic data

9. Managing Tablespaces & Data Files

• Tablespace and Data Files Concepts
• Blocks, Extents, Segments
• Understanding Space Management
• Creating & Managing Tablespaces
• Big file Tablespaces
• Tablespace Quotas
• Temporary Tablespaces
• Undo Tablespaces
• Oracle Managed Files (OMF)

10. Managing Control Files

• Understanding Control Files
• Multiplexing Control Files
• Backing up Control Files

11. Redo Log Files & Archiving

• Online & Archived Redo Log Files
• Managing Online Redo Log Files
• Fast Recovery Area (FRA)
• Configuring Database Archive mode

  12. User Administration

• Creating Users Accounts
• Account management
• Schema, Session, Killing Sessions
• Using Profiles

13. Privileges & Roles

• Understanding Privileges
• Managing Privileges
• Understanding Roles
• Managing Roles

14. Oracle Net Services

• Understanding Oracle Net Services
• Net Listener, Naming Methods
• Net configuration tools- NETCA, NETMGR
• Configuring Listener & Naming methods
• Establishing Database connectivity from Database Clients
• Configuring Shared Servers and Dispatchers

 15. Recovery Manager (RMAN)

• Backup & Recovery Concepts
• Recovery Catalog
• Full & Incremental Backups
• Image Copy & Backup Set backups
• Backup & Recovery using RMAN
• Hot & Cold backups using RMAN
• Complete & In-Complete Recovery
• SQL & DESCRIBE commands in RMAN

16. Flashback Technologies

• Oracle Flashback Technologies
• Flashback Database
• Flashback Table
• Flashback Drop Table

17. Oracle Data Pump

• Concepts of Logical Backups
• Data Pump Exports & Imports
• Data Pump Parameters
• Export Modes

18. Database Patching

• Patching Concepts
• Interim Patches, CPU, PSU patches
• Patch Sets
• Downloading & Analysing Patches
• Applying Patches

19. Oracle Multitenant Architecture

• Multitenant Architecture
• Pluggable Databases (PDB) & Container Database (CDB)
• Creating & Managing CDBs & PDBs
• Users, Roles, Privileges in CDB
• Parameters in CDB
• Backup, Recovery of CDBs & PDBs

Requirements

• A Windows, Linux or Mac PC/Laptop with Internet Connection
• Knowledge about Unix/Linux
• Oracle SQL

Key Features

• 60 hours of high-quality training
• Hands-on practices for every lesson
• Access to session recordings

FAQ

1. What about Lab practice?

Students can practice the lab sessions on their personal laptop/desktop system.

2. What if I miss a session?

We provide the recording of each session for future reference.

3. What if I discontinue the training in between?

You can attend any future training that suits your schedule.