Intro to UNIX
Learn and master the basics of the Unix Operating system. Gain the requisite System administration skills needed to operate and function as a Database administrator.
Intro to SQL
Understand the universal language of databases. Master basic query techniques, retrieval and reporting methods. Interact with the database through SQL & Learn SQL tools.
DB Workshop I
Intro to Oracle architecture. Instance, Database, SGA Components. Setup and create your own oracle system. Create an enterprise database. Secure access and manage users.
DB Workshop II
Learn & master advanced administration techniques. Performance Tuning, Backup & Recovery methods, RMAN, Patching, Data transfer methods and more.
Intro to OBIEE
Take a foundation course in OBIEE. Learn how best to access corporate data for business users. Learn how to build and manage the common infrastructure for producing and delivering enterprise reports, scorecards, dashboards, ad-hoc analysis, and OLAP analysis.
Learn to install, patch and upgrade Oracle WebLogic Server. Get insights on new configuration features in 12c, server templates, dynamic clusters, fusion middleware control, etc. Get key foundation knowledge of Middleware mgmt and administration.
OEM Cloud Control 12c
Learn Oracle’s complete, integrated and business-driven enterprise cloud management solution. Install and setup an enterprise administrative, management and monitoring solution. Repository, Management server and Agent sub-system.
Learn one of Oracle’s solutions for real-time data integration & replication in heterogeneous IT environments. Install & administer GoldenGate to enable HA solutions, real-time data integration, transactional change data capture, verification, etc across environments.
Learn & master Oracle HA solution & concepts. Install and configure one or more standby databases. Implement HA, data protection, and DR solutions for enterprise data. Execute failover, switch-over scenarios in real time.
RAC 11GR2 Implementation
Learn the new features and concepts of Oracle’s HA solution – RAC. Install, configure and implement RAC on a 2-node cluster. Implement RAC One Node, execute Failover scenarios, Live Migration, Rolling upgrade + patching and Scale out scenarios and lots more.