Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

"Oracle DBA Online Training" is no longer available

No Reviews Yet

Course type: Online Instructor led Course

Platform: GotoMeeting, SKype

Course ID: 26940

Course type: Online Instructor led Course

Platform: GotoMeeting, SKype

No Reviews Yet

About the Course

One to One Training,
Class room sessions will be recorded and give to you for future reference.
Training provided by real time faculties with real time scenarios.

Topics Covered

Learn Oracle DBA course - What You will learn

[Demo & Practical?s will be shown in VMware/Oracle Virtualbox]

Day 1:
Introduction to Unix/Linux& Oracle DBA:

? Basic Unix Commands
? Editors: Vi
? Introduction to kernel parameters, introduction to top/vmstat/netstat/iostat/) etc
? File Transfer Methods: FTP, SFTP, SCP etc. in UNIX/Linux
? What is DBA
? Roles of Oracle DBA (Production DBA & Development).
? Types of Oracle DB users a) DBA b) Security Officers c) N/w Admin d) DB User
? Environment Management (N/w, CPU, disk & RAM).
? Oracle VM stack/ VMWARE

Day 2:
Introduction to Oracle Architecture (Part ? 1):

? Memory structures
? Physical and Logical Database structures
? Background Processes
? External Files: Parameter file, Password file, Network files
? Introduction to Oracle Instance

Day 3:
Introduction to environment variable for oracle:

? Importance of various environment variables (ORACLE_SID, ORALCE_HOME, LD_LIBRARY_PATH, NLS_LANG,ORAENV/CORAENV etc.)
? Setting up environment (oratab, oraenv, Intro to different environment settings fordifferent clients etc.)

Database availability:

? Bounce database
? Start up/Shutdown Stages
? Check database status
? Check database connectivity

Using External Tools:

? SQL Developer
? Toad For Oracle
? Putty
? Winscp

Day 4:
Database Installation & Creation.

? Installing Oracle Binaries
? Creating Database
? Installation/Creation Pre Considerations and checks





Day 5/6:
Basic SQL statements

? Basic SQL statements
? Differentiate between DDL/DML/DCL
? SELECT/INSERT/UPDATE/DELETE/TRUNCATE, Group by, order by etc
? Logical Object creation (Tables/ indexes/ views/ Roles/ synonym/users/privileges/views)
Introduction to Dynamic SQL
? PLSQL
? Triggers
? Procedures/Packages
? Functions

Day 7:
Description of various parameters and modification. (Instance level parameter changes)
? Dynamic parameter changes
? Static parameter changes

Introduction to DBA_VIEWS, USER_VIEWS, ALL_VIEWS and v$ views

? Session related info ( v$session, v$sesison_wait, v$parameteretc)
? Locking related info ( dba_locks ,dba_locked_objects etc.)
? Query physical database structures (dba_data_files, dba_free_space, v$datafile, v$tablespace, etc.)
? Query logical database objects ( dba_segments, dba_tables, dba_view, dba_synonym, dba_mviewsetc)

Day 8/9:
Tablespace Management:
? Managing SYSAUX, TEMP, UNDO & other Tablespaces
? Operations: Creation, Quota, Autoextends, Size, Resize, Move of tablespaces
? Theory: Types and Conversion of tablespaces
? Tablespaces issues: Fragmentation, reorganization and Corruption etc

Day 10/11/12/13:
Backup & Recovery:
? Theory: Types of Backups and recoveries
? HOT/COLD Backup strategies
? User Managed Backups and OS Backups
? RMAN Backups
? RMAN: Backup and Recovery issues/errors, Configuration etc
? Theory and Practical?s

Logical Backups:
? Using old Import Export Utility
? Using Data Pump
? Comparisons and parameters
? Theory and practical?

Day 14:
Monitoring using Alert.log
? Importance of alert.log & its monitoring
? Common errors found in alert log
? Maintenance of alert.log

Day 15:
Walk-through day to day common DBA error and Step-By- Step procedure
? Day to day incidents:
? Raising SR with Oracle Support
? Handling of errors/bugs ORA-600, ORA-7445, TTL Errors etc

Day 16
Architecture (Part ? 2)
? Revision of Oracle Architecture with new processes and structures

Day 17/18: (Adv. Topics)
Automatic Storage Management
? Basics of RAID Levels
? Striping and Mirroring
? Creating ASM Instance, RAW Disks, Diskgroups
? ASM Instance management and architecture
? Conversion of Cooked File System to ASM File System
? Theory: Advantages and issues

Day 19/20:
Patching:
? Introduction to OPatch Utility and GUI Installers
? Applying PSU
? Applying CPU
? Applying One-Off
? Upgrade Patches
? Common issues after patching
Oracle Enterprise Manager and Grid Console (Adv. Topics)
? Managing Metrics
? Alerts and Errors
? Other daily issues with OEM/Grid

Day 21/22/23/24:
Database Upgrade/Migration:
? Migration Strategies and Plans
? Pre Requisites, Post Requisite steps
? Issues after Upgrades
? Bug Fixes
? Performing Test Cases on new databases
? Migration using Data Pump, Oracle Installer

Day 24/25/26/27:
Database Cloning/Refresh
? Creating Clones using RMAN
? Creating DB Clones using user managed backup
? Database Refreshes
? Introduction to Oracle VM & Benefits in preparing clones



Day 28:

Standby database (Adv Topics)
? Non Managed Standby Database
? Managed Standby Database
? Dataguard
? Active Dataguard (12c)

Day 29:
Oracle Flashback (Adv Topics)
? UNDO Management and other parameters consideration
? Recycle Bin/Drop
? Flashback Query
? Flashback Version Query
? Flashback Table
? Flashback Transaction Query
? Flashback Database
? Flashback Archives (Total Protection)
? Flashback New Features
? Related Errors and Restrictions

Day 30/31/32 (Adv Topics)
Oracle Real Application Clusters:
? What is RAC or a DB Cluster
? Benefits of using Oracle RAC
? Differences between a standalone and a RAC
? What?s new in RAC 11g r1/r2
? Parameters related to RAC
? Others

Day 33 (Adv. Topics)
Walk through on Database Security:
? Importance of DB Security
? Using available parameters
? Encrypting Backups
? Database Masking using OEM for clones
? DB Vault
? Database Auditing:
? Role/Privileges and Profiles

Day 34/35/36/37/38 (Adv Topics)
Performance Tuning
? Why there is a need to tune your Production systems
? What is this cost
? Techniques of removing Fragmentation from your tablespaces
? Table Shrink and related operations
? Tools: Generating performance reports like AWR, ADDM, STATSPACK etc
? Identify using OS Based utilities: top, iostat, vmstat, sar,netstat, ipcs
? Use of various performance related dynamic views
? Indexes: Types and use
? Theory: Full Table Scan, Index Range Scan
? Gathering and Viewing Statistics
? OPTIMIZER : CBO & RBO in Oracle
? Generating and reading Execution Plans
? Tools: tkprof, SQL Tracing and AUTO Tracing
? Use of various database parameters
? Use of Hidden Parameters
? Understanding of Locks, Enqueues, Latches, Mutexetc
? Understanding Wait events
? Joins/Loops types and their effects

Day 39/40
Tuning Memory Areas: (Adv. Topics)
? Tuning SHARED POOL
? Tuning DATABASE BUFFER CACHE
? Tuning other SGA Areas
? Tuning Advisors
? Automatic Memory Management (AMM)
? Automatic Shared Memory Management (ASMM)

Day (41/42/43/43/45)
Basic introduction about latest Oracle DB Technologies:
? Oracle Big Data. (What?s the hype?)
? Cloud Computing/ AWS
? Oracle 12c (CDB/PDB) (Theory cum Walk through ? 1Day); (Adv. Topics (Day 42/43/44/45)? With Practical, Upgrades)
? Understanding Competitors RDBMS (MS-SQL/MySQL/PostgreSQL) & Big Data (MongoDB)

Who should attend

Freshers and Professionals who are looking for in depth knowledge of Oracle DBA.

Pre-requisites

Minimum knowledge of SQL.

What you need to bring

Nothing to Bring,
Should have System/Laptop with good internet connection.

Key Takeaways

Confidence on on Oracle DBA

Date and Time

Not decided yet.

About the Trainer

5 Avg Rating

2 Reviews

1 Students

6 Courses

Mahesh

B.tech

1) I have 4 years of Experience of Java J2EE training and Development.
2) I am Java Certified Programmer 1.6 (OCJSE)(SCJP)(Java Certified Programmer) and providing Industry, Interview Oriented Training for Freshers/Professionals.
3) I have Experience on Core Java, JSP, Servlets, J2ee, Struts, Spring,Hibernate, all java related technologies.
4) Experience on Web Development using Java with MVC Design Pattern.

Reviews

No reviews currently Be the First to Review

Discussions

Post your requirement and let us connect you with best possible matches for Oracle Database Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more