Batch Details Call@ 919603049739

ONLINE/CLASS ROOM TRAINING

MySQL DBA Training

ORACLE DBA TRAINING COURSE CONTENT

 

 

•Introduction to Oracle

◦Prerequisite
◾Computer Fundamentals, Windows Operating System

◦Take Aways
◾Create database tables.
◾Manage database objects.
◾Access and manipulate data in the database using SQL statements.
◾Control user access to data.
◾Oracle 10g : SQL Certification exam readiness

◦Course Contents
◾Introduction
◾Writing Basic SQL SELECT Statements
◾Restricting and Sorting Data
◾Single- Row Functions
◾Displaying Data from Multiple Tables
◾Aggregating Data Using Group Functions
◾Subqueries
◾Producing Readable Output with iSQL *Plus
◾Manipulating Data
◾Creating and Managing Tables
◾Including Constraints
◾Creating Views
◾Other Database Objects
◾Controlling User Access
◾SQL Workshop
◾Using SET Operators
◾Oracle 10g Datetime Functions
◾Enhancements to the GROUP BY Clause
◾Advanced Subqueries
◾Hierarchical Retrival
◾Oracle10g Extensions to DML and DDL Statements

•Oracle Database 10g : Administration Workshop I (1Z0-042) Duration: 48 Hrs. ◦Prerequisite
◾Oracle Database 10g : SQL

◦Take Aways
◾Create Oracle database
◾Manage database objects, administer user security
◾Manage schema objects
◾Perform database backup & recovery
◾Oracle Database10g :AdminstrationWorskshop I Certification exam readines

◦Course Contents
◾Oracle Database
◾Oracle Instance
◾Database Storage Structures
◾Administering User Security
◾Schema Objects
◾Data and Concurrency
◾Managing Undo Data
◾Oracle Database Security
◾Oracle Network Environment
◾Proactive Maintenance
◾Performance Management
◾Backup and Recovery Concepts
◾Database Backup
◾Database Recovery
◾Flashback
◾Moving Data

•Oracle Database 10g : Administration Workshop II (1Z0-043) Duration : 48 Hrs. ◦Prerequisite ◾Oracle Database 10g : Administration Workshop I

◦Take Aways ◾Use recovery manager
◾Deal with database corruption
◾Monitor & manage memory
◾Manage schema objects
◾Oracle Database10g :AdminstrationWorskshop II Certification exam readiness

◦Course Contents ◾Recovery Manager
◾Flashback
◾Database Corruption
◾Memory
◾Storage
◾Performance Management
◾Schema objects
◾Managing storage
◾Storage management
◾Resources
◾Scheduler


 

contact us at +919603049739.

Thanks,

Power Tech@@...

email:  pvr.vsit@gmail.com,training@mysqldbatraininghyd.com

Phone:9603049739