Tecnosoft | Training Instistute Website

Oracle Database

Home > Courses > Oracle Database

Icon
Duration

45 DAYS

Icon
Online Fee

15,000

Icon
Classroom Fee

6,000

Icon
Students Enrolled

2000+

Icon
Reviews

Upcoming Batch Schedule for Online Training

Tecnosoft provides flexible timings to all our students. Here are the Online Training Schedule in our branches. If this schedule doesn’t match please let us know. We will try to arrange appropriate timings based on your flexible timings.

  • 27-04-2020 Monday (Monday - Friday)Weekdays Regular 08:00 AM (IST)(Class 1Hr - 1:30Hrs) / Per SessionCourse Fees
  • 30-04-2020 Thursday (Monday - Friday)Weekdays Regular 08:00 AM (IST)(Class 1Hr - 1:30Hrs) / Per SessionCourse Fees
  • 25-04-2020Saturday (Saturday - Sunday)Weekend Regular11:00 AM (IST) (Class 3Hrs) / Per SessionCourse Fees
  • 25-04-2020Saturday (Saturday - Sunday)Weekend Fast-track 10:00 AM (IST)(Class 6Hrs - 7Hrs) / Per SessionCourse Fees
Tecnosoft Calender
Can’t find a batch you were looking for?

Enroll Now

Get Instant access to 5000+ Online courses

Course Curriculam

Introduction

  • What is DBA?
  • Why a Company needs a DBA?
  • Roles & Responsibilities of DBA
  • Identify the oracle product
  • Oracle Architecture
  • Physical and Logical Phase of Database

Installing oracle database 11g software

  • System requirements.
  • Redhat Linux Installation
  • Install software with the Oracle Universal Installer on Linux Platform
  • Identify System Requirements
  • Discuss Oracle Base
  • Discuss Oracle Home

Exploring The Oracle DatabaseArchitecture: General

  • More About Database Instances
  • What is Instance and SGA
  • General Database Architecture
  • Instance Background Processes
  • Discuss about New Feature Parameters
  • About PGA and Server Process

Exploring The Oracle Database Physical Architecture

  • Discuss about Control files
  • How to manage the Control files
  • Multiplexing the Control files
  • Multiplexing the online redo log files
  • Brief about online redo log files.
  • More About Datafiles concepts
  • Brief About Paramter files
  • Discuss about Password files.
  • How to create spfile and pfile
  • What is spfile?
  • Difference between spfile and pfile

Create an oracle database

  • Database Configuration Assistant(DBCA)
  • Create A New Database
  • Configure An Existing Database
  • Drop A Database
  • Manually Create A Database
  • More About The Database Files

Manually Starting and Stopping Database Services

  • Starting and Stopping Database Control
  • Different Startup Modes
  • Different Shutdown Modes
  • Starting and Stopping The Listener
  • Sysdba

Manage Database Storage Structures: Tablespaces

  • What are segments?
  • What are extents?
  • What is Blocks?
  • Estimation of Extents
  • Dictionary Managed Table space
  • Locally Managed Table space
  • About Tablespaces
  • Tablespace Management
  • Autoextend Options
  • Drop Tablespace
  • Alter Tablespace
  • Tablespace Encryption

Manage Database Storage Structures: Advanced Tablespaces

  • More About Bigfile Tablespaces
  • More About The Sysaux Tablespace

Manage Database Storage Structures

  • Managing Data Files
  • Managing Temp Files
  • Enable Oracle-Managed Files (OMF)
  • Renaming a data file
  • Temporary Groups

Managing Undo Data

  • About Undo Space Management
  • Configure Undo Management
  • Undo_Management
  • Undo_Tablespace
  • Undo_Retention
  • Guarantee Undo Retention
  • Monitor Undo Space
  • Use The Undo Advisor

Security: Administering User Security

  • Create and manage database user accounts
  • Create and manage roles
  • Grant and revoke privileges
  • Control resource usage by using Profiles
  • Create and Manage Database Accounts
  • Grant and Revoke Database Privileges
  • Resource Limits Via Profiles
  • Alter Profile
  • Drop Profile
  • Password Management Via Profiles
  • With Grant Option and Object Privileges
  • Alter User…Default Role
  • Set Role
  • Enhanced Default Security Settings

Oracle Net Services

  • Understand Oracle Net concepts
  • Use Oracle Net Manager to create and configure listeners
  • Use the listener control utility to control the Oracle Net Listener
  • Start and stop Listener concepts
  • ora
  • Concept about Database Links
  • Use the Oracle Net Manager to configure client and middle-tier connection
  • Use TNSPING to test Oracle Net connectivity

Create indexes and views Logical Backup & Restore

  • Introduction Data pump (expdp, impdp)  Utilities
  • Exporting/Importing Tables
  • Exporting/Importing Schemas
  • Exporting/Importing Table space
  • Exporting/Importing Database
  • Transportable Table space within & across the database and platforms
  • Discuss New features concept 11g

Oracle Backup & Recovery (User Managed)

  • Introduction
  • Design, Testing, Implementation Strategies
  • Offline(cold)/Online(hot) backups
  • Performing Complete Recovery
  • Performing Incomplete Recovery

Oracle Backup & Recovery (System Managed: RMAN)

  • Introduction
  • RMAN Architecture & Rman commands
  • Configuration
  • Setting up Catalog
  • Online/Offline Backup using RMAN
  • Backups Options
  • Incremental Backups,
  • Scripts,
  • Complete Recovery
  • Incomplete Recovery
  • Table Space Point in Time Recovery (TSPITR)
  • Disaster Recovery
  • Recovery of Corrupted DB-Blocks
  • RMAN 11g new features

Cloning & Refresh

  • Database Refresh Using RMAN
  • Database refresh Using Manual
  • DB refresh Using Expdp and Empdp
  • Migration Using Expdp and Impdp
  • Migration Using Rman

Flashback Database Concept

  • Introduction
  • Configuration
  • Flashback Query/Table/Drop/Database
  • Flashback Version Query
  • Creating Restore Points
  • Flashback Archive(11g)

Patching Activity

  • Database Patch Management Introduction
  • Applying Interim and Patch set Patches
  • Patch History & Documentation

Data Guard Concept

  • Introduction
  • Architecture
  • Configuring Standby database
  • Types of Standby databases
  • Performing Switch Over and Fail Over
  • Monitoring & Troubleshooting
  • 11g New features in Data Guard
  • Types of Protection modes
  • Active standby/snapshot standby(11g)

Automatic Storage Management

  • Basic Automatic Storage Management Concepts
  • Disk Groups
  • Automatic Storage Management Files
  • Automatic Storage Management Templates
  • Automatic Storage Management Disks
  • Failure Groups
  • Automatic Storage Management Instances
  • Benefits of Using Automatic Storage Management
  • Highlights of the Course
  • Oracle installation process
  • Patching Activity
  • Upgradation Process
  • Migration Process
  • Rman Refresh & cloning Process
  • Resume Preparation
  • Dataguard scenario
  • Project related scenario.
  • Real time scenario.

Our Courses

Request a call back
info@tecnosoft.in
+(91) 996 642 2225

Scroll to top