Oracle DBA Training

Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online transaction processing, data warehousing and mixed database workloads. Register Today

 

Oracle DBA Training Schedules :

S No Timings (IST) Start Date
Schedules for Oracle DBA Training
1 8 AM - 10 AM Aug 5th
2 6:30 PM - 7:30 PM July 14th
3 7 AM - 9AM (wk) July 11th

Oracle DBA Training Highlights :

Practical Training Reak-Time Training
Daily Tasks Weekly Assignments
Mock Interviews Placement Assistance

Total Course fee for Oracle DBA Training INR 18,000/-

Total Course fee for Oracle DBA Training INR 18,000/-

Duration6 Weeks

 

Oracle DBA Training Course Contents

Modules -1- Linux/UNIX Installation & Commands

Module – 2 ORACLE SQL COMMANDS

Chapter 1- Getting Started with UNIX
  • What is UNIX?
  • UNIX Architecture [Hardware, Kernel, Shell, Command & Utilities]
  • How to Login & Logout in UNIX?
  • Changing the Password of Logged in User
  • Listing the Files & Directories
  • List out the logged in Users
  • Modes of Shutdown the Linux/Unix OS
  • Example and Practice Commands
Chapter 1- Introduction to SQL Statements
  • SQL Fundaments DML, DDL, TCL, DCL Commands
  • Data Types & Limitation of Data Types
  • Column Alias Name, Use of DISTINCT Keyword
  • Use of DUAL Table & Where Clause
  • Use of Logical Operators & Other Operators
  • Sorting Rows by using ORDER BY clause
  • HAVING Clause, The CASE Expression
  • Using Ampersand Substitution Variables
Chapter 2- UNIX File Management & the UNIX VI Editor
  • List the files & Hidden files
  • Meta characters [* and?]
  • Creating the files using various commands
  • Display the Content of the files
  • Editing the Files using vi Editor
  • Counting the Lines, Words and Characters in a file
  • Copy, Rename and Delete a file
Chapter 2- Single Row Function
  • Single Row Function Fundamental
  • Using Single Row Character Function
  • Using Single Row Numeric Function
  • Using Single Row Date Function
  • Using Single Row Conversion Function
  • Using GROUP function
  • Detailed Explanation with Example
Chapter 3- UNIX Directories Management
  • Home Directory
  • Absolute & Relative Pathnames
  • Create Directories & Creating Parent Directories
  • Copying and Renaming Directories
  • Removing Directories
  • Changing Directories
  • The directories (. dot) and (.. dot dot)
Chapter 3- Using Join & Sub Queries
  • Inner Join (Simple Inner Join)
  • Using Table Alias, Natural Join
  • Left Outer Join, Right Outer Join
  • Full Outer Join ,SELF Join
  • Single Row Sub Queries
  • Multiple-Row Sub Queries
  • Exmple with Real World Queries
Chapter 4- UNIX File & Directory Permission Setup
  • The Permission Indicators
  • File Access Modes [Read r, Write w, Execute x]
  • Directory Access Modes [Read r, Write w, Execute x]
  • Changing the Permissions Using chmod with Symbolic Permissions
  • Changing the Permissions Using chmod with Absolute Permissions
  • Changing the Ownership of File & Directory [chown command]
  • Changing the Group Ownership of File & Directory [chgrp command]
Chapter 4- Using DML & TCL Operation
  • Insert New Records
  • Update Existing Records
  • Delete Records & TRUNCATE the Table
  • Commit, Rollback, SAVEPOINT
  • Rollback to Save-point
  • Exmple with Real World Queries
Chapter 5- UNIX User & Set the Environment
  • How to create Group?
  • How to create User?
  • How to modify User?
  • The .profile or .bash_profile file
  • Setting the Path
  • Example Commands
Chapter 5- Creating Table and Constraints
  • Database Object Overview
  • Creating Tables, Modifying Table
  • Types of Constraints, Creating Constraint
  • Enabling & Disabling Constraint
  • Validating Constraints, Dropping Constraint
  • Renaming Table, Making Table READ ONLY, Dropping Table

Module: 3 ORACLE DATABASE ARCHITECTURE & INSTALLATION

Module: 4 ORACLE DATABASE ADMINISTRATIONS

Module: 5 Database Backup Concept (Logical & Physical Backup)

Chapter 1- Introduction Database & Oracle DBA
  • What is Database?
  • Why do we need of Database?
  • List of major Databases and Database vendors
  • Tasks of Database Administrator (DBA)
  • Database related tools and utilities.
Chapter 6- Table-space Administration & Data file Administration
  • Create, Alter & Drop the Permanent Table-space
  • Add & Resize the data files
  • Understand Segment space management
  • Understand the Extent Management
  • Create Big File Table-space
  • Table-space Quotas
  • Configuring the Multi-block Table-space support
  • Table-space related views [DBA_Tablespaces, DBA_data_files, V$Tablespace, V$Datafile]

Chapter 13- Oracle Database Logical Backup (Oracle Data Pump)

  • Oracle Database Data Movement Utilities:
  • Data Pump Export (Export) expdp &  exp
  • Data Pump Import (Import) impdp & imp
  • Oracle Data Pump Components DBMS_DATAPUMP & DBMS_METADATA Package
  • Export & Import Table, Schema, Table-space, Database
Chapter 2- Oracle Database Instance Architecture & Storage Structure
  • What is Oracle Database 11g & 12c?
  • What is Database Instance?
  • Oracle Database Instance Memory Architecture (SGA & PGA)
  • Subcomponents of Shared/System Global Area (SGA)
  • Oracle Database Process Architecture [PMON (CLMN), SMON, LREG, CKPT, DBWn, LGWR, MMON...]
  • Oracle Database Storage Structure
  • Oracle DB Logical Storage Structure [OS Block, Oracle Data block, Extents, Segment, Table-space]
  • Oracle DB Physical Storage Structure [Control file, Data files, Online Redo log files, Parameter files]
  • Oracle Database 12c Multitenant Architecture
  • Oracle Database 12c Container Database [CDB$ROOT] & Non Container Database
  • Oracle Database 12c SEED Database [PDB$SEED]
  • Oracle Database 12c Pluggable database [Application Container Database]
Chapter 7- Undo Table-space
  • Create Undo Table-space and add data file to undo Table-space
  • Change the Undo Table-space on the Database level
  • Managing the Transaction & Undo Data
  • Configuring the Undo Table-space
Chapter 14- Backup, Restore & Recovery using RMAN
  • Introduction Backup and Recovery
  • Introduction to RMAN (Recovery Manager) Architecture
  • Configuring the RMAN Environment
  • RMAN Backup Concepts like Backup Sets & Image Copy Backup
  • RMAN Control file & Parameter file backup
  • RMAN full database & Incremental Backup
  • RMAN Backup Retention Policy
  • List out the Archive log backup & Database Backups
  • RMAN related Views
  • Concept of Repository Catalog Database
  • Benefit & Use of Repository Database
  • RMAN backup CDB & PDB Databases [Backup database root; Backup pluggable database hr_appcont;]
Chapter 3- Oracle Software Installation & Database Creation
  • Understand prerequisites for a successful Oracle RDBMS software installation.
  • Installation of Oracle 12cR1 database software with the latest patch set.
  • Installation of Oracle 12cR2 database software
  • Planning for Oracle Database Creation
  • Database Creation using DBCA (Database Configuration Assistance) GUI
  • Database Creation using script manually with CREATE DATABASE statement
  • Exploring the Database components Logical & Physically
Chapter 8- Temporary Table-space
  • Create Temporary Table-space
  • Adding and Resize the temporary file
  • Temporary Table-space Group
  • Temporary Table-space views [DBA_temp_files, V$tempfile]
Chapter 15- Oracle Database Flashback & Restore Point
  • Overview of Flashback Database, Restore Points and Guaranteed Restore Points
  • About Logging for Flashback Database and Guaranteed Restore Points
  • Prerequisites for Flashback Database and Guaranteed Restore Points
  • Using Normal and Guaranteed Restore Points
  • Using Flashback Database, Table-space, Table
Chapter 4- Oracle Database Start & Stop and Parameter
  • Oracle Database Startup modes [STARTUP, STARTUP NOMOUNT, STARTUP MOUNT, OPEN, FORCE]
  • Oracle Database Open Read Only & Restricted Modes
  • Oracle Database Shutdown modes [SHUTDOWN NORMAL, TRANSACTIONL, IMMEDIATE, ABORT]
  • ----Parameters ----
  • Initialization Parameters
  • Static & Dynamic Parameters
  • System & Session Level Parameters
  • Parameter files (Initialization Parameter & Server Parameter files)
  •  Changing the Parameter Value
  • ----Data Dictionary----
  • Understanding Data Dictionary
  • Static & Dynamic Performance Views [V$...,X$......, DBA_, ALL_, USER_]
  • Using Data Dictionary Views [ DICT, V$FIXED_TABLE]
Chapter 9- Managing the Control File
  • Understanding Control Files
  • Multiplexing Control Files
  • Backing up Control Files
  • Control file related view (V$controlfile)
Chapter 16- Oracle Database RMAN Duplicate Cloning
  • Cloning Concept & Consideration
  • Cloning Technologies
  • Cloning Oracle Home
  • RMAN Duplicate Database Cloning
Chapter 5- User Management
  • What is Oracle Database Users?
  • Types of Database Users on the basis of Authentication [Database & External (OS) User]
  • Database 12c Common (C##Username) User & Local User
  • Create the Database Common User & Local User
  • Alter the Database Common User &Local User
Chapter 10- Managing Online Redo log files
  • Redo Log Files & Archiving
  • Online & Archived Redo Log Files
  • Managing Online Redo Log Files
  • Fast Recovery Area (FRA)
  • Configuring Database Archive mode
  • Views related Log [V$LOG, V$LOG_FILE, V$LOGSTDBY, V$LOG_HISTORY, V$RECOVERY_LOG, V$STANDBY_LOG]
Chapter 17- Oracle Database Disaster Setup (Standby Database/ Data Guard)
  • Introduction Oracle Data Guard
  • Types of Standby Databases & Data Guard Services
  • Difference between Physical, Logical & Snapshot Standby databases
  • Oracle Data Guard Architecture
  • Processes related to Primary & Standby Databases
  • Creating Physical Standby Database using SQL & RMAN Duplicate command
  • Open The Physical Standby database to Real Time Apply
  • Oracle Data Guard Overview
Database Security
  • Types of Privileges [System Level & Object Level Privileges] & Roles
  • Grant and Revoke the Privileges from Database Users
  • What is profile?
  • Assign the Profile to Database User
  • Create & Alter the Profile
  • Killing the Session of the Connected User
Chapter 11- Oracle Net Service Architecture
  • Overview of Oracle Net Services & It’s component
  • How Oracle Net Service works?
  • The Oracle Net Listener
  • Types of Listener & Oracle Listener configuration [Dynamic and Static Listeners]
  • Oracle netca (Network Configuration Assistant) utility to Create Listener
  • Oracle netmgr (Network Manager) utility to Create & Configure the Listener
  • Oracle Dedicated Server Architecture
  • Oracle Shared Server Architecture
  • Oracle Listener Administration and TNS_ADMIN environment variable
Chapter 18- Oracle Database Performance Tuning
  • How to handle performance issues in the real world
  • V$ dynamic views for performance monitoring and analysis
  • How to define size of Oracle database memory structures for optimal performance
  • Oracle database wait events
  • Explain Oracle temporary space internals and sizing.
  • How to trace database sessions using DBMS_MONITOR and DBMS_SESSION packages
  • How to format SQL trace files using the tkprof utility
  • Index Monitoring and internals of index maintenance by Oracle
  • Statistics data collection for Oracle database optimizer
  • What is Oracle automatic workload repository (AWR) and how to obtain AWR reports
 
Chapter 12- Oracle Database Link
  • Overview about Oracle Database Link
  • Type of Database Link [Private & Public Database link]
  • How to create Oracle Database Link
  • How to Drop the Oracle Database Link
Chapter 19- Oracle Database Patching
  • Introduction to Oracle versions and how to understand a version
  • How to upgrade from one patch-set to another patch-set within the same maintenance release
  • What are Oracle interim patches?
  • How to apply SPU patches (Security Patch Updates).
  • How to apply a Patch Set Update (PSU)
  • Learn about Oracle Interim Patch Installer (OPATCH)
 
All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and 24x7 LIVE Server.
 

Oracle DBA Training - Highlights :

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews, Certifications
  • Certification & Interview Guidance
 
 
Register Today  Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer: Mr. Sai Phanindra T