Oracle Certification Training Institute in CBE REDLEAF

Redleaf Technologies - Creating a new world of opportunities

Redleaf Technologies is a leading centre of learning in imparting technical education par excellence. It has carved a niche in the IT training sector with modern curriculum and technical expertise on most sought-after application development programs. The training division of Redleaf Technologies provides intensive training in Oracle, SAP, Java, SmartGrid and Smallworld GIS.

At Redleaf Technologies, we strive to provide more pragmatic approach to our training procedures rather than the conventional one. Our training activities enable the students to acquaint with technology in the working environment and empower their skills through real-time experience. All our courses are designed to provide a comprehensive learning experience for students, from the fundamentals of programming languages to its extensive level of developing applications. The training division is managed by a team of experienced and dedicated professionals with a proven track record.

Started in 2010, Redleaf Technologies provides smart and intelligent IT solutions in transforming organizations to become Eco-enterprises. It is primarily focused on consultancy and implementation of SmartGrid, ERP, Mobile Application and GIS solutions.
ORACLE
For more than three and a half decades, Oracle has been the leader in database software. And as it has further developed technologies and acquired best-in-class companies over the years, that leadership has expanded to the entire technology stack, from servers and storage, to database and middleware, through applications and into the cloud.
Throughout its history Oracle has proved it can build for the future on the foundation of its innovations and its knowledge of customer challenges and successes analyzed by the best technical and business minds in the world.
What does Oracle have in store for tomorrow? Oracle will continue to provide the customers with hardware and software engineered to work together—integrated from disk to applications that meet their business needs and solve their business problems. And will continue to innovate and to lead the industry, while always assuring to focus on solving the problems of the customers who rely on Oracle’s technology.

Database Administrator (DBA Track):
ORACLE DATABASE ADMINISTRATION 10g: DBA TRACK

MODULE 1
ORACLE 10g: INTRODUCTION TO SQL (#1Z0-007)

OCA CERTIFICATION (Module 1,2)

OCP CERTIFICATION (Module 1,2,3)
MODULE 2
ORACLE 10g DBA: WORKSHOP 1 (#1Z0-042)

MODULE 3
ORACLE 10g DBA: WORKSHOP 2 (#1Z0-043)

TRAINING DURATION:
#1Z0-007: 40 Hrs (7 Days, 6 Hrs/ Day)
#1Z0-042: 40 Hrs (7 Days, 6 Hrs/ Day)
#1Z0-043: 40 Hrs (7 Days, 6 Hrs/ Day)
COURSE OVERVIEW
DATABASE ADMINISTRATION TRACK:
Introduction to Oracle 10g: SQL – ( 40 Hrs )
Writing a Basic SQL Statement, Restricting and Sorting Data, Single Row Functions, Displaying Data from Multiple Tables, Aggregating Data by Using Group Functions, Writing 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 9i Datetime Functions, Enhancements to the GROUP BY Clause, Advanced Subqueries, Hierarchical Retrieval, Oracle9i Extensions to DML and DDL Statements

Oracle 10g Database Administration: Workshop I - ( 40 Hrs )
Introduction, Describe the basic concepts of a relational database, Know core database administrator tasks, Installing Oracle Database 10g Software, Create an Oracle Database, Database interfaces, Use the Oracle C++ Call Interface (OCCI), Controlling the database, Storage Structures, Create and manage tablespaces using Oracle Managed Files (OMF), Administering users, Managing Schema Objects, Managing Data, PL/SQL, Identify PL/SQL objects, Identify configuration options that affect PL/SQL performance, Oracle Database Security, Oracle Net Services, Oracle Shared Server, Performance Monitoring, Proactive Maintenance: Objectives, Undo Management, Monitoring and Resolving Lock Conflicts, Backup and Recovery Concepts, Database backups, Database Recovery

Oracle 10g Database Administration: Workshop II –( 40 Hrs )
Using Globalization Support, Securing the Oracle Listener, Configuring Recovery Manager, Retention Policies, Using Recovery Manager, Parallelization of Backup Sets, Diagnostic Sources, Editing Thresholds, Recovering from non-critical losses, Recreating Redo Log Files, Database Recovery, Point-in-time recovery using RMAN, Flashback database, Best Practices for the Database and Flash Recovery Area, Recovering from User Errors, , Dealing with Database Corruption, The ANALYZE command, Using RMAN to Repair Corrupt Blocks, Automatic Database Management, Automatic Undo Retention Tuning, Monitoring and Managing Storage, Segment Resource Estimation, Automatic Storage Management, Migrating a tablespace to use ASM storage, Monitoring and Managing Memory, Automatic PGA Memory Management, Managing Resources, Adaptive Consumer Group Mapping, Automating Tasks with the Scheduler, Creating a job that runs a program outside of the database.
For Further Details Please Contact, Deepa @ 8754025233,
Redleaf Technologies Private Limited,
T5A, Manchester Square,
12, Puliakulam Road,
Coimbatore – 641037,
Phone: 0422 - 4242742