Database Courses

2.1 Oracle Certified Associate (OCA)
i. Oracle Database: SQL Programming 5 days
This Oracle Database program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and more.
ii. Oracle Database Administration: Fundamental 1 5 days
Designed for the Oracle beginner- to-intermediate DBA, this Oracle DBA fundamentals course describes Oracle’s architecture, its processes and database objects - instance, database, tablespaces, tables, indexes, etc. - in terms of how they work. Additionally, backup and recovery, load, import, export, etc. utilities are central to the hands-on exercises.
Finally, locking and concurrency are explored in terms of transaction processing and recovery.
2.2 Oracle Certified Professional (OCP)
i. Oracle Database Administration: Fundamental 2 5 days
This fundamentals course takes the database administrator beyond the basic tasks covered in the first workshop. You'll gain a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.
ii. Oracle Dataguard Implementation 4 days
This course will teach delegates how to use Oracle Data Guard to help protect the Database against planned and unplanned downtimes. The Data Guard architecture is used to create physical and logical standby databases, including Primary Database Configuration, Implementation and Monitoring which will be covered as well as a standby role for reporting, querying and testing purposes.
iii. Oracle RAC Implementation 5 days
The RAC (Real Application Clusters) Implementation class will equip implementation personnel with the knowledge and experience to implement RAC on the Oracle database. The course will provide an introduction to the features and functionality of RAC and lead students through a hands-on workshop for installing, configuring and running RAC with Oracle Database 11g Release 2.
iv. Oracle Performance Tuning 5 days
This Oracle Database 11g Performance Tuning training starts with an unknown database that requires tuning. Learners will then learn the steps a DBA performs to identify problem areas, diagnose common problems and fix them.
v. Oracle Database Backup and Recovery using RMAN 2 days
This training course will teach learners how to evaluate their own recovery requirements. Learners'll learn to develop appropriate backup and recovery procedures to address their business needs, employ Oracle Database recovery procedures to recover from media failure and use Flashback Technologies to complement backup and recovery procedures.