Signup as a Tutor

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

Oracle DBA Online Training

No Reviews Yet

Course type: Online Instructor led Course

Platform: GotoMeeting, SKype

Course ID: 26940

Course type: Online Instructor led Course

Platform: GotoMeeting, SKype

Students Interested 0 (Seats Left 0)

No Reviews Yet

Date and Time

Not decided yet.

Mahesh

B.tech

About Mahesh

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.
No reviews currently Be the First to Review

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

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

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

Enquire

Submit your enquiry for Oracle DBA Online Training

Please enter valid question or comment

Please select a category

No matching category found.

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With JavaETraining

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer