Oracle DBA Training in Chennai

Oracle DBA Training in Chennai

Oracle Certified Professional(OCP)

Introduction :

Oracle DBA is a fundamental course for candidates willing to make their careers in field of Oracle Database administrator. Oracle DBA covers basics of Structured Query Language(SQL),Basic of PL/SQL, 10g Administration-I And 10g Administration-II. After completing DBA course, candidates can apply for OCA AndOCPexamination.

DBAs who take the time to understand the proper application of new Oracle technology to their everyday jobs will enjoy many time-saving, and ultimately, money-saving new capabilities.

Objective :

• Evaluate Oracle features and Oracle related products
• Establish and maintain sound backup and recovery policies and procedures
• Take care of the Database design and implementation
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Perform database tuning and performance monitoring
• Perform application tuning and performance monitoring
• Setup and maintain documentation and standards
• Plan growth and changes (capacity planning)
• Work as part of a team and provide 7x24 support when required
• Perform general technical trouble shooting and give consultation to development teams

Eligibility : Knowledge of C and Basic of Networking is essential to learn Oracle DBA.

Course Content : 10g SQL Expert:

• Retrieving Data Using the SQL SELECT Statement
• Restricting and Sorting Data
• Using Single-Row Functions to Customize Output
• Use character, number, and date functions in SELECT statements
• Reporting Aggregated Data Using the Group Functions
• Displaying Data from Multiple Tables
• Using Subqueries to Solve Queries
• Using the Set Operators
• Manipulating Data
• Using DDL Statements to Create and Manage Tables
• Creating Other Schema Objects
• Managing Objects with Data Dictionary Views
• Controlling User Access
• Managing Schema Objects
• Manipulating Large Data Sets
• Generating Reports by Grouping Related Data
• Managing Data in Different Time Zones
• Hierarchical Retrieval
• Regular Expression Support

Course Content : 10g Administration

• Outline the Oracle Architecture
• Installing the Oracle Database Software
• Creating an Oracle Database
• Managing the Oracle Instance
• Managing Database Storage Structures
• Administering User Security
• Managing Schema Objects
• Managing Data and Concurrency
• Managing Undo Data
• Implementing Oracle Database Security
• Configuring the Oracle Network Environment
• Proactive Maintenance
• Performance Management
• Backup and Recovery Concepts
• Performing Database Backup
• Performing Database Recovery
• Performing Flashback
• Moving Data

Course Content : 10g Administration-

• Using Globalization Support Objectives
• Configuring Recovery Manager
• Recovering from User Errors
• Dealing with Database Corruption
• Automatic Database Management
• Using Recovery Manager
• Recovering from Non-Critical Losses
• Monitoring and Managing Storage
• Automatic Storage Management
• Monitoring and Managing Memory
• Database Recovery
• Flashback Database
• Managing Resources
• Automating Tasks with the Scheduler

Exit Profile :

• SQL Developer
• Oracle Database Administrator

DBA Support engineer/Administrator