Learnfly Academy

Oracle DBA Training

  • Sale
  • Regular price Rs. 30,000.00

Drop a query

Speak to Counsellor: Call 1-800 3000 7460 (India Toll Free)


Quick Overview

Course Description

Oracle is the world’s largest enterprise software company, and an individual with expertise in Oracle Database management can reach to amazing career heights. It will add a great deal of value to your profile, if you can handle the database and maintain maximum efficiency.


Oracle DBA Training course will help you to understand the concepts of oracle database (DBA) and architecture. During the course you will be trained and educated about:



  • Introduction to Database
  • Physical Database Structure
  • Oracle Storage structures
  • Alert & Trace files
  • Database Startup
  • Memory & Process Architecture
  • Background Process
  • Serving User Requests
  • Database Security
  • Oracle Network Environment
  • Oracle Backup & Recovery Concepts
  • Oracle Recovery Manager (RMAN)

Enroll for a Live Class

Enroll for the course at the earliest as we have limited seats available.

Duration : 1 hour
Length : 7 Weeks
Batch Start Date : 20/11/2016
Course Fee Rs. 30000
Test Lab Hours : 30 mins
Class Room Training : Available
Instructor Learnfly Faculty
Available Training Modes Instructor-Led Class

With proper guidance and directions from the faculty, the course curriculum will help the candidates with no experience in programming or web development to become an accomplished Ruby on Rails developers. Professional developers enrolling in the course will add another feather to their skill-hat and improve their career prospects.

Week 1 - Introduction to Database

  • Introduction to Oracle database
  • How ORACLE DB does it?
  • Unix Kernel
  • Physical Database Structure
  • Control files
  • Key information of files
  • Redo log files
  • Oracle Storage structures
  • Table statement
  • How to check “create table”
  • Schemas and schema objects
  • Data blocks
  • Extents
  • Segments

Week 2 - Memory & Process Architecture

  • Memory & Process Architecture
  • Instance/Memory structures
  • Shared pool
  • Buffer Cache
  • Redo Log Buffer
  • Process Architecture
  • Background Process, Alert & Trace files
  • Alert
  • Trace files

Week 3 – Database Startup & Serving User Requests

  • Database Startup & Serving User Requests
  • Data Base Startup
  • User process, Server process
  • Database Security
  • Process of “Create User”
  • Alter & Drop User
  • Resource Limits & profiles
  • Auditing
  • Schema Objects
  • Types of schema objects
  • How table data is stored
  • Temporary Tables
  • External Tables

Week 4 - Schema Object Continued

  • Schema Object Continued
  • Materialized View
  • Sequence Generator
  • Indexes
  • B-Tree index structure
  • Cluster/Hash Cluster
  • Data concurrency & consistency
  • Locking
  • Deadlocks
  • Oracle Network Environment
  • How to connect your database
  • Network environment of ORACLE
  • Database link

Week 5 Oracle Backup & Recovery Concepts

  • Oracle Backup & Recovery Concepts
  • Standby database
  • Testing
  • Media recovery options
  • Offline backup
  • Standby Database
  • Oracle Recovery Manager (RMAN)
  • Data pump export & import
  • SQL loader
  • External table
  • Data dictionary & Dynamic Performance Tables
  • Dynamic performance Tables
  • Typical day ORACLE DBA

Week 6 – Introduction to Database Tuning

  • Database Tuning
  • Monitor space usage
  • Monitor SQL scripts
  • Data base tuning
  • SQL tuning
  • Table Statistics
  • Index statistics
  • Index Selectivity
  • Chained Rows
  • Locks
  • Introduction to Database Tuning Continued
  • Tuning Shared pool
  • Data dictionary performance
  • Data dictionary tuning
  • PL/SQL code
  • Code reuse
  • Data base Buffer
  • Buffer cache hit Ratio
  • Code reuse

 

Learnfly Academy is a forward-thinking educational ecosystem. We train extraordinary people for the emerging professions of the 21st century according to industry demand. We fill a crucial gap between learners and companies to train and hire the best talent in the market. Learning from Learnfly Academy increases your chances by 95% to get you the right job.

Live Class is a live streaming of teacher from our location. Learnfly Academy instructors deliver live classes in an online environment. Attendees join a WebEx session from their preferred location and connect to a hosted lab environment to practice what they learn. We run classes as per Indian Standard time.

Each attendee needs a computer with a high-speed Internet connection in order to connect to

  • A WebEx web conference session and
  • A hosted lab environment.
and For best results, we recommend the following browsers: PC - Internet Explorer or FireFox. Mac - 64-bit browser (Safari of FireFox). or Google Chrome We also highly recommend that you use a computer headset and microphone (VOIP) and that you attend from a quiet workspace to allow you to concentrate.

 

We have a very transparent fee structure. Please see the course fee next to the “Add to Cart” button on this page.

We only provide certified and industry expert trainers to our learners. Our teachers/instructors are highly qualified in their training verticals. Our instructors could be an individual teachers from colleges or working professionals from multi national companies like google, Facebook or Microsoft.

Of course you should. That’s what applications are for, don't worry. It's our responsibility to make sure that you are ready for any course you will attend. If it's not right for you, we'll let you know. We're not shy about things like that.

Yes. We do offer full job assistance once you do the certification from Learnfly. We have partnered ourselves with multiple small business and multi national companies to provide you the best working platform. We also conduct in-house campus events and send you invitations to experience multiple job opportunities at one place. We offer 99% job placement, if you do 2-3 job oriented courses from our catalogs.

Currently, you can attend our class’s in English or Hindi Language.

Yes Off course! You can reschedule a class with your assigned teacher or request for a pre-recorded session on your email.

We accept payments via credit cards, debit cards, net banking & NEFT. You can also pay us via paypal & paytm. Use the “Add to Cart” button provided on this page and checkout by making the online payment. You will receive an automated confirmation on your email after a success-full payment with further instructions.

Once you purchase training, we'll send you an email with registration instructions. Also, One of our counsellor will get in touch with you to assign you an online teacher and decide the class timings. We can either assign you to the existing running batch or add you in the upcoming batches.

You may cancel an order within 30 days of purchase for a full refund, but not inside of 3 days of your scheduled course.

 

Step 1 : Make an Online Payment


Step 2 : Our Counsellor will contact you within few minutes after payment.


Step 3 : Choose your time to attend your live class with our counsellor


Step 4 : Connect with a Live Teacher from your PC, Phone or a tablet & attend the class from anywhere in the world.


You may be interested in:


Customer Reviews

Based on 6 reviews Write a review