Live Technoworld offering Oracle DBA Training in Gurgaon in more practical way. Our team of Oracle DBA trainers offers Oracle DBA in Classroom training. We framed our syllabus to match with the real world requirements for both beginner level to advanced level. Our training will be handled in either weekday or weekends programme depends on participants requirement.
At Live Technoworld well-equipped Oracle DBA training center in Gurgaon aspirants learn the skills for oracle database,Oracle 11g dba management, database creation, table space management, oracle performance tuning, oracle dba Training on real time projects along with Oracle DBA placement training. Oracle DBA Training in Gurgaon has been designed as per latest industry trends and keeping in mind the advanced Oracle DBA course content and syllabus based on the professional requirement of the student, helping them to get placement assistance in Multinational companies and achieve their career goals.
1. Are you right for this program?
The Database Administrator (DBA) program has been designed to give you the necessary skills to excel as:
2. What qualification will this program give you?
OCA - Database Administrator (DBA) from Oracle University
OCP - Database Administrator (DBA) from Oracle University
3. By undergoing the Database Administrator (DBA) course, you will be better equipped to:
Install, configure and link a Windows/Linux system to a corporate network
Administer and manage a Windows/Linux network
Install and create an Oracle database on Windows/Linux
Administer and manage an Oracle database on Windows/Linux
Perform Backup & Recovery
Perform Automatic Memory Tuning
Supplement your classroom learning with additional online learning resources
Experience Web 2.0 tools and technologies in a learning Environment
4. DBMS Concept - 8 Hours
Database Design
Entity-Relationship Diagram
Normalization
Relational Database
5. Oracle 11g SQL - 40 Hours
Introduction
Writing Basic SQL Statement
Restricting & Sorting Data
Using Single Row Function for Customized output
Displaying Data from Multiple Tables
Reporting Aggregated Data
Sub-Queries
Using the Set Operators
Manipulating Data
Creating and Managing Tables
Creating Other Schema Objects
Hierarchical Retrieval
Regular Expression Support
6. Oracle Database 11g: Workshop l - 40 Hours
Introduction
Installing the Oracle Database Software
Creating an Oracle Database
Managing the Oracle Instance
Managing Database Storage Structure
Administering User Security
Managing Scheme Objects
Managing Data and Concurrency
Managing Undo Data
Implementing Database Security
Proactive Maintenance
Performance Management
Backup and Recovery concepts
Performing Database Backups
Performing Flashback
Moving Data
7. Oracle Database 11g: Workshop ll-40 Hours
Introduction
Configuring Recovery Manager
Using Recovery Manager
Recovering from Non- Critical Losses
Data base Recovery
Flashback
Dealing With Database Corruption
Monitoring and Managing Memory
Automatic Performance Management
Managing Schema Object
Managing Storage
Automatic Storage Management
Managing Resources
Automatic Tasks with Scheduler
Database Security
Globalization Support
8. Case Studies 11g - 24 Hours
Recovering undo tablespace
Tuning Complex Statements using SQL Access Advisor