The Oracle Certified Associate (OCA): Oracle 11 G Administrator certification is designed to give you a firm foundation in basic administration of Oracle Database 11g. In this class, participants learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.

Students and working professionals who wish to gain expertise in Database Administration.

After the completion of this course, you will be able to:

• Describe Oracle Database Architecture
• Install and configure Oracle Database 11g
• Configure Oracle Net services
• Manage the database storage structures
• Create and administer user accounts
• Perform basic backup and recovery of a database
• Manage users and schemas
• Manage data and concurrency
• Monitor and administer undo data
• Backup and recover a database
• Monitor performance
• Use the database diagnostic monitor

The Oracle Certified Associate (OCA): Oracle Database 11 G Administration certification is designed to provide you with the concepts and architecture that support backup and recovery. It provides hands-on experience to define and test your own backup and recovery scenarios.

Also, the participants learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered. Topics are reinforced with hands-on practices.

Students and working professionals who wish to gain expertise in Oracle Database Administration

After the completion of this course, the student will be able to:

• Describe the Oracle Architecture
• Identify the features of the Oracle Universal Installer
• Start-up and Shutdown of an Oracle instance
• Describe the process of Database Creation
• Build Data Dictionary and Dynamic Performance Views
• Use Control File and Redo Log Files
• Manage Table Spaces and Data Files
• Create and use different types of Indexes
• Manage Resources and Privileges
• Build Auditing Functions
• Describe and use Globalization support in Oracle

BASIS is a set of Middleware Programs and Tools from SAP, that provides the underlying base (thus the name) that enables applications (such as FI, CO, and SD, for example) to be seamlessly Interoperable and Portable across Operating Systems and Database products. R/3 BASIS includes Client/Server Architecture, a Relational Database Management System (RDBMS), and a Graphical User Interface (GUI).

Professionals who wish to build upon their ABAP programming experience or Database Administration experience and gain expertise in SAP - Administration.

After the completion of this course, you will be able to:

• Understand and apply SAP Administration concepts like Login, Personalization, Work Process Types, Booting and Stopping SAP system on Windows and UNIX.
• Computer Center Management System (CCMS) configuration
• Create and Schedule Background Jobs
• Manage User Administration Manage Client Administration
• Manage Spool and Print Administration
• Understand and apply the concepts of Database Administration, Backup / Recovery strategies
• SAP Installation and Patch management

The Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Implementation and Maintenance certification demonstrates you have the skills to work with SQL Server 2008 and performing database administrator tasks: installing, configuring, and maintaining.

Students and working professionals who wish to gain expertise in Microsoft SQL Server 2008, Installation and Maintenance.

After the completion of this course, you will be able to:

• Install and Configure SQL Server 2008
• Maintain SQL Server Instances
• Manage SQL Server Security
• Maintain a SQL Server Database
• Perform Data Management Tasks
• Monitor and Troubleshoot SQL Server
• Optimize SQL Server Performance
• Implement High Availability

The Microsoft Certified Information Technology Professional (MCITP): validates your ability to design, optimize and maintain a Database Server Infrastructure using Microsoft SQL Server 2008

Students and working professionals who wish to gain expertise in database administration.

After the completion of this course, you will be able to:



• Design a SQL Server Instance and a Database Solution
• Design a Database Server Security Solution
• Design a Database Solution for High Availability
• Design a Backup and Recovery Solution
• Design a Monitoring Strategy
• Design a Strategy to Maintain and Manage Databases
• Design a Strategy for Data Distribution

The MySQL for Database Administrators course is the foundation course for database administrators and developers who want to use this powerful database. In this course you will learn how to secure users privileges, set resource limitations, and access controls. In addition, you will learn multiple new features such as creating and using Stored Procedures, Triggers and Views.

Who will the course benefit?

• Developers who want to learn how to administer MySQL
• People who want to prepare for the MySQL DBA certification

At the end of the course, you will be able to:

• Install and Upgrade MySQL for the most common operating systems
• Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server
• Use the INFORMATION_SCHEMA database to access metadata
• Configure MySQL server options at runtime
• Evaluate data types and character sets for performance issues
• Understand data locking concepts and the different levels of locking in MySQL
• Differentiate between the multiple storage engines available in MySQL
• Perform backup and restore operations utilizing multiple MySQL tools
• Maintain integrity of a MySQL installation utilizing security protocols
• Use stored routines and triggers for administration tasks
• Manage, apply and understand the reason for using views
• Improve performance through query optimization
• Optimize Schemas (Databases) utilizing multiple techniques
• Utilize MySQL monitoring tools to improve server performance
• Compare multiple environment options to improve server performance

This course offers students an introduction to the general features and capabilities of Oracle Database 10g Release 2 for Oracle Real Application Clusters (RAC). Students learn how to install and administer OracleClusterware, Real Application Clusters, and Automatic Storage Management. Students also learn how to administer their Database in a Real Application Clusters environment using Enterprise Manager Grid Control. Increase your efficiency by learning how to configure and use database services as well as the Load Balancing Advisory in a RAC environment. Learn how to add and remove nodes in clusters and how to patch both Oracle Clusterware and Real Application Clusters software in a rolling fashion.
This course counts toward the Hands-on course requirement for the following certifications

• Oracle Database 10g Administrator Certification
• Oracle Database 10g: Real Application Clusters Administrator Certified Expert

• Data Warehouse Administrator
• Database Designers
• Database Administrators
• System Analysts
• Project Manager
• Technical Administrator
• Support Engineer
• Technical Consultant

After the completion of this course, you will be able to:

• Identify common data structures
• Gather requirements
• Create a baseline project
• Prepare reusable metadata
• Model for predictable results
• Create calculations and filters
• Implement a time dimension
• Create the presentation view
• Create analysis objects
• Manage OLAP data sources
• Set Security
• Manage packages
• Basic model maintenance and extensibility
• Working with different query subject types
• Identify generated SQL and complex queries
• Optimize and tune Framework Manager model
• Work in a multi-modeler environment
• Use advanced parameterization techniques
• Manage MUNs and model for drill-through
• Employ additional modeling techniques