Introduction to Oracle 9i- SQL

Introduction:
Concepts of relational and object relational databases, SQL programming language, create and maintain database objects and to store, retrieve, and manipulate data. Participants also learn to retrieve data by using advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval. Learn how to write SQL and SQL*Plus script files using the iSQL*Plus tool. 

Duration: 40 hours  

Program Contents:

• Describe relational and object relational database concepts 
• Retrieve, insert, update, and delete data
• Use the Single row and Group functions  
• Retrieve data using additional advanced techniques like using
• ROLLUP, CUBE, set operators, correlated subqueries and hierarchical queries
• Solve problems by using multicolumn subqueries
• subqueries in the from clause of a SELECT statement, correlated subqueries, and scalar subqueries
• Use the iSQL*Plus environment
• Write scripts to generate script files
• Generate reports using iSQL*Plus
• Create and maintain database objects
• Control transactions
• Control data/user access
• Use the Oracle9i Single row functions
• Use GROUPING SETS and the WITH clause
• Use the Oracle9i extensions to DML and DDL statements
• Apply techniques in real life simulation

Pre Requisites:

• Participants must be familiar with Data manipulation concepts and RDBMS concepts

Exit Profile:

• The candidate would learn how to use Data Server Technology

Global Certification Mapped:

• Program is mapped with OCP vendor certification

Oracle 9i-Program with PL/SQL

Introduction
This course introduces PL/SQL and understand the benefits of PL/SQL Students learn to create procedures, functions, packages, and database triggers. Use iSQL*Plus to develop these program units, manage PL/SQL program units and database triggers, to manage dependencies, to manipulate large objects, and to use some of the Oracle-supplied packages.

Duration: 40 hours  

Program Contents:

• Describing PL/SQL 
• Declaring Variables
• Writing Executable Statements 
• Interacting with the Oracle Server
• Writing Control Structures
• Working with Composite Data types
• Writing Explicit Cursors
• Advanced Explicit Cursor Concepts
• Handling Exceptions
• Creating Procedures
• Creating Functions
• Managing Subprograms
• Creating Packages
• More Package Concepts
• Using Oracle-Supplied Packages
• Creating Database Triggers
• More Trigger Concepts
• Managing Dependencies
• Manipulating Large Objects

Pre Requisites:

• Participants should be familiar with development 
• Prior knowledge of RDBMS

Exit Profile:

• The candidate would learn how to create PL/SQL blocks of application code that can shared by multiple forms, reports and data management applications

Global Certification Mapped:

• Program is mapped with OCP vendor certification

Oracle9i-Database Administration Fundamentals (Production - I)

Introduction
Creates a foundation in basic database tasks. Participants learn how to design, create, and maintain an Oracle database. Get a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. How to create an operational database and properly manage the various structures in an effective and efficient manner. The lesson topics are reinforced with structured hands-on practices.

Duration: 40 hours  

Program Contents:

• Manage tablespaces, segments, extents and blocks 
• Manage users, privileges, and resources
• Create an operational database 
• Start up and shut down an Oracle instance and database
• Manage Oracle database files
• Use Globalization Support features
• Understand Oracle Architectural Components
• Defining the Optimal Flexible Architecture (OFA)
• Manage Instances
• Data Distionary
• Control Files
• Redo Log Files 

Pre Requisites:

• Introduction to Oracle 9i SQL is a must
• Understanding of RDBMS concepts is necessary

Exit Profile:

• The candidate would be able to develop and maintain an Oracle 9i Database

Global Certification Mapped:

• Program is mapped with OCP vendor certification

Oracle9i-Database Administration Fundamentals (Production - II)

Introduction
Learn several methods to backup and to recover your Oracle database. Develop skills for basic network administration. Simplify your duties with Oracle Recovery Manager. Learn Oracle Net administration and backup and recovery operations. Learn about transporting data between databases and the utilities used to perform these activities. Networking concepts and configuration parameters, as well as how to solve some common network problems. Configure network parameters so that database clients and tools can communicate with the Oracle database server. Learn how to addresses backup and recovery techniques, and examines various backup, failure, restore and recovery scenarios. Examine backup methodologies based on business requirements in a mission critical enterprise.

Duration: 40 hours  

Program Contents:

• Define networking requirements and the solutions provided by Oracle to implement these requirements 
• Perform database and data file backups with and without Recovery Manager (RMAN)
• Configure the network environment for an Oracle client-server system 
• List the different Oracle backup methods and recovery operations that can be used to resolve database failure
• Describe the database utilities (Export and Import) and the situations where they can be used
• Develop network configuration and recovery techniques through various workshop scenarios
• List the Oracle architecture components related to backup and recovery operations
• Basic Oracle Net Architecture
• Oracle Shared Server
• Complete Backup and Recovery using RMAN
• Repository Maintenance

Pre Requisites:

• Introduction to Oracle 9i SQL is a must. 
• Understanding of RDBMS concepts is necessary
• Oracle Database Administration Fundamentals Production 1 course is a must

Exit Profile:

• The candidate would learn methods to backup and recover oracle database

Global Certification Mapped:

• Program is mapped with OCP vendor certification

Oracle 9i Forms Developer-Build Internet Applications

Introduction
 This course teaches you to develop and deploy Internet applications using Oracle9i Forms. Working in a rapid development environment, participants learn how to customize forms through user input items and how to control data access by creating event-related triggers. In this practical course, you also learn how to test and debug your Web applications through the Forms environment.

Duration: 40 hours  

Program Contents:

• Create form modules 
• Including components for database interaction and GUI controls
• Display form modules in multiple windows using a variety of layout styles 
• Link one form module to another
• Implement triggers
• Reuse objects and code
• Test form modules in a Web browser 
• Debug form modules in a 3-tier environment 
• Working with data blocks
• frames
• Canvases
• Triggers
• Alerts
• Messages
• Writing Flexible codes
• Sharing Objects and codes
• Transaction Management

Pre Requisites:

• Introduction to Oracle 9i SQL 
• Oracle 9i Program with Pl/SQL is a must
• Concepts of RDBMS is mandatory

Exit Profile:

• The candidate would be able to develop and deploy Internet Applications

Global Certification Mapped:

• Program is mapped with OCP vendor certification

Oracle9i Database: Performance Tuning

Introduction
Reducing wait times, increasing users' productivity and maximizing the performance Oracle database are critical factors. Participants learn the methods for tuning an Oracle database for maximum performance. Introduce the importance of good initial database design, and the method used to tune a production Oracle9i database, Database and Instance tuning. Learn how to tune an Oracle database, using the available Oracle tools, such as Oracle Enterprise Manager (with the Diagnostics and Tuning Packs) and STATSPACK. Participants also learn how to recognize, troubleshoot and resolve common performance related problems in administering an Oracle database.

Duration: 40 hours  

Program Contents:

• Overview of Oracle 9i Performance Tuning 
• Diagnostic and Tuning Tools
• Sizing the Shared Pool 
• Sizing the Buffer Cache
• Sizing other SGA Structures
• Database Configuration and I/O Issues
• Optimize Sort Operations
• Diagnosing Contention For Latches
• Tuning Rollback (or UNDO) Segments
• Monitoring and Detecting Lock Contention
• Tuning Oracle Shared Server
• Application Tuning
• SQL Statement Tuning
• Using Oracle Blocks Efficiently
• Tuning the Operating System and Using Resource Manager 

Pre Requisites:

• Participants would have taken Oracle PL/SQL program before taking this course 
• Knowledge of RDBMS is a must
• Database Administration know how is advantageous
• Participants must have taken the Oracle Database Administration Fundamentals Part I and II course before attending this program

Exit Profile:

• The candidate would learn how to Tune the Oracle Database effectively with Reducing wait times, increasing users' productivity and maximizing the performance of the Oracle database

Global Certification Mapped:

• Program is mapped with OCP vendor certification

Diploma in Database Administration using Oracle 10g

Introduction:
Oracle Database 10g is Oracle’s revolutionary new grid offering for database administrators, which include breakthrough self-management, storage management, and clustering features. It is designed to relieve system administrators from repetitive, low-value administrative work and provide them with an opportunity to increase their value and expand their technical skills.
Oracle database is generally implemented in large-scale organization managing voluminous amount of data and users. Therefore, organization requires Database Administrator (DBA) to administer the same. 

Duration: 288 hours  

Program Contents:

Oracle 10g: Introduction to SQL Ed 3

This course is divided into 2 parts:

1. Oracle Database 10g: SQL Fundamentals (Part I) 
2. Oracle Database 10g: SQL Fundamentals (Part II) 

• Run data manipulation statements (DML) to update data in the Oracle Database 10g
• Create tables to store and utilize views to display and retrieve data 
• Identify the major structural components of Oracle Database 10g  
• Create reports of sorted, restricted and aggregated data
• Employ SQL functions to generate and retrieve customized data
• Retrieve row and column data from tables with the SELECT statement
• Manage Schema Objects
• Manipulate large Datasets
• Generate Reports by Grouping Related Data
• Retrieve data using Sub-queries
  
  

Oracle Database 10g: PL/SQL Fundamentals

• Use PL/SQL programming constructs and conditional control statements
• Write PL/SQL code to interface with the database
• Design PL/SQL program units that execute efficiently
• Handle run-time errors
• Describe stored procedures and functions

Oracle Database 10g: Administration Workshop I

• Install Oracle Database 10g and configure a database
• Manage the Oracle instance
• Manage the Database storage structures
• Create and administer user accounts
• Perform backup and recovery of a database
• Monitor, troubleshoot, and maintain a database
• Configure Oracle Net services
• Move data between databases and files

Oracle Database 10g: Administration Workshop II

• Use RMAN to create and manage backup sets and image copies
• Recover the database to a previous point in time
• Use Oracle Secure Backup to backup and recover a database
• Use Oracle's Flashback technology to recover your database
• Detect block corruptions and take appropriate measures to correct them
• Use the various Database advisors and views to monitor and improve database performance
• Control database resource usage with the Resource Manager
• Simplify management tasks by using the Scheduler
• Review database log files for diagnostic purposes
• Customize language-dependent behavior for the database and individual sessions
• Administer a VLDB
• Implement a secure database
• Transport data across platforms

Oracle Database 10g: Backup and Recovery

• Plan effective backup and recovery procedures
• Use Recovery Manager to create backups and perform recovery operations
• Use Oracle Flashback technologies to recover from human error
• Install Oracle Secure Backup
• Perform an Oracle-suggested backup to tape
• Use Oracle Secure Backup to perform a file system backup
• Use Oracle Secure Backup to perform a file system restoration
• Perform an encrypted database backup and restore
• Manage the Oracle Secure Backup environment
• Monitor and tune Recovery Manager
• Perform tablespace point-in-time recovery
• Create a duplicate database
• Create and manage a recovery catalog database

Oracle Database 10g: Performance Tuning

• Use the Oracle Database tuning methodology appropriate to the available tool
• Utilize database advisors to proactively tune an Oracle database
• Use the tools based on the Automatic Workload Repository to tune the database
• Use Statspack reports to tune the database
• Diagnose and tune common database performance problems
• Use Enterprise Manager performance-related pages to monitor an Oracle database

Oracle Database 10g: Security Release 2

• Use basic database security features
• Choose a user authentication model
• Secure the database and its listener
• Use the Enterprise Security Manager tool
• Manage users using proxy authentication
• Implement Enterprise User Security
• Describe the benefits and requirements associated with the Advanced Security Option
• Manage secure application roles
• Implement fine-grain access control
• Manage the Virtual Private Database (VPD)
• Implement fine-grain auditing
• Use Transparent Data Encryption
• Use file encryption
• Encrypting and Decrypt table columns
• Setup a simple Label Security policy

Oracle Database 10g: SQL Tuning Workshop

• Describe the basic steps in processing SQL statements
• Describe the causes of performance problems
• Understand where SQL tuning fits in an overall tuning methodology
• Describe Automatic SQL Tuning
• Use the diagnostic tools to gather information about SQL statement processing
• Understand Optimizer behavior
• Influence the optimizer behavior
• Influence the physical data model so as to avoid performance problems

Pre Requisites:

• Working knowledge of Computers and Windows
• Knowledge of Linux is desirable

Exit Profile:

• The candidate will have “Diploma in Database Administration using Oracle 10g”

Global Certification Mapped:

• Oracle Database SQL Certified Expert
• Oracle Database 10g Administrator Certified Associate
• Oracle Database 10g Administrator Certified Professional

Oracle 10g: Introduction to SQL

Introduction:
Oracle Database 10g is Oracle’s revolutionary new grid offering for database administrators, which include breakthrough self-management, storage management, and clustering features. It is designed to relieve system administrators from repetitive, low-value administrative work and provide them with an opportunity to increase their value and expand their technical skills. Oracle database is generally implemented in large-scale organization managing voluminous amount of data and users.

Duration: 48 hours

Program Contents:

• Identify the major structural components of Oracle Database 10g
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted, restricted and aggregated data
• Run data manipulation language (DML) statements to update data in Oracle Database 10g
• Obtain metadata by querying the dictionary views

Pre Requisites:

• The students should have: Knowledge of SQL, equivalent to Oracle 10g: Introduction to SQL module

Exit Profile:

• Learner will be able to apply key concepts of relational databases and SQL Programming Language

Global Certification Mapped:

• Oracle Database SQL Certified Expert

Oracle Database 10g: PL/SQL Fundamentals

Introduction:
Oracle Database 10g is Oracle’s revolutionary new grid offering for database administrators, which include breakthrough self-management, storage management, and clustering features. It is designed to relieve system administrators from repetitive, low-value administrative work and provide them with an opportunity to increase their value and expand their technical skills.
Oracle database is generally implemented in large-scale organization managing voluminous amount of data and users. 

Duration: 18 hours  

Program Contents:

• Use PL/SQL programming constructs and conditional control statements
• Write PL/SQL code to interface with the database
• Design PL/SQL program units that execute efficiently
• Handle run-time errors
• Describe stored procedures and functions

Pre Requisites:

• The student should have knowledge of SQL equivalent to:- Oracle Database 10g : Introduction to SQL

Exit Profile:

• Learner will be able to design PL/SQL program units to interface with the database

Oracle Database 10g: Administration Workshop I

Introduction:
Oracle Database 10g is Oracle’s revolutionary new grid offering for database administrators, which include breakthrough self-management, storage management, and clustering features. It is designed to relieve system administrators from repetitive, low-value administrative work and provide them with an opportunity to increase their value and expand their technical skills.
Oracle database is generally implemented in large-scale organization managing voluminous amount of data and users. 

Duration: 48 hours  

Program Contents:

• Install Oracle Database 10g and configure a database
• Manage the Oracle instance
• Manage the Database storage structures
• Create and administer user accounts
• Perform backup and recovery of a database
• Monitor, troubleshoot, and maintain a database
• Configure Oracle Net services
• Move data between databases and files

Pre Requisites:

• The student should have knowledge of SQL equivalent to:- Oracle Database 10g : Introduction to SQL and Oracle Database 10gPL/SQL Fundamental
• Knowledge of Linux is desirable

Exit Profile:

• Learner will be able to administer and maintain the Oracle 10G database

Global Certification Mapped:

• Oracle Database 10g Administrator Certified Associate

Oracle Database 10g: Administration Workshop II

Introduction:
Oracle Database 10g is Oracle’s revolutionary new grid offering for database administrators, which include breakthrough self-management, storage management, and clustering features. It is designed to relieve system administrators from repetitive, low-value administrative work and provide them with an opportunity to increase their value and expand their technical skills.
Oracle database is generally implemented in large-scale organization managing voluminous amount of data and users. 

Duration: 48 hours  

Program Contents:

• Use RMAN to create and manage backup sets and image copies
• Recover the database to a previous point in time
• Use Oracle Secure Backup to backup and recover a database
• Use Oracle's Flashback technology to recover your database
• Detect block corruptions and take appropriate measures to correct them
• Use the various Database advisors and views to monitor and improve database performance
• Control database resource usage with the Resource Manager
• Simplify management tasks by using the Scheduler
• Review database log files for diagnostic purposes
• Customize language-dependent behavior for the database and individual sessions
• Administer a VLDB
• Implement a secure database
• Transport data across platforms

Pre Requisites:

• The student should have knowledge of Oracle Database 10g: Administration Workshop I
• Knowledge of Linux is desirable

Exit Profile:

• Learner will be able to perform advanced database administration tasks on the Oracle 10G database

Global Certification Mapped:

• Oracle Database 10g Administrator Certified Professional

Microsoft Exchange Server 2007

It provides a reliable messaging system, with built-in protection against spam and viruses. Using Exchange 2007, users throughout organizations can access e-mail, voice mail, calendars, and contacts from a wide variety of devices and from any location. 

Exam	MOC Description	No. of Days
Exam 70-236: TS: Configuring Exchange 2007 (Gives you MCTS: Microsoft Exchange Server 2007 – Configuration)	Course 5047: Introduction to Installing and Managing Microsoft Exchange Server 2007 SP1	3
	Course 5049: Managing Messaging Security Using Microsoft Exchange Server 2007	1
	Course 5050: Recovering Messaging Servers and Databases Using Microsoft Exchange Server 2007	1
	Course 5051: Monitoring and Troubleshooting Microsoft Exchange Server 2007	2

Exam	MOC Description	No. of Days
Exam 70-237:PRO: Designing Messaging Solutions with Microsoft Exchange Server 2007	Course 5053: Designing a Messaging Infrastructure using Microsoft Exchange Server 2007	3
	Course 5054: Designing a High Availability Messaging Solution using Microsoft Exchange Server 2007	2

For more details visit Microsoft Learning (http://www.microsoft.com/learning/en/us/default.aspx)

 

Microsoft Office SharePoint Server 2007

It is an integrated suite of server capabilities that can help improve organizational effectiveness by providing comprehensive content management and enterprise search, accelerating shared business processes, and facilitating information-sharing across boundaries for better business.
 

Exam	MOC Description	No. of Days
Exam 70-631 TS: Windows SharePoint Services 3.0, Configuring	Course 5060A: Implementing Windows SharePoint Services 3.0	2
	Course 50047A: Advanced IT Pro Course for Microsoft Office SharePoint Server 2007 and Windows SharePoint Services	5
	Course 50026A: SharePoint 2007 Hands-On Labs

Exam	MOC Description	No. of Days
Exam 70-630 TS: Microsoft Office SharePoint Server 2007, Configuring	Course 5061A: Implementing Microsoft Office SharePoint Server 2007	3
	Course 50048A: Enterprise Search Solution Architect Workshop	3
	Course 50047A: Advanced IT Pro Course for Microsoft Office SharePoint Server 2007 and Windows SharePoint Services	5
	Course 50026A: SharePoint 2007 Hands-On Labs

Exam	MOC Description	No. of Days
Exam 70-541 TS: Microsoft Windows SharePoint Services 3.0 - Application Development	Course 50026A: SharePoint 2007 Hands-On Labs
	Course 50064: Advanced SharePoint 2007 Development	5

Exam	MOC Description	No. of Days
Exam 70-542 TS: Microsoft Office SharePoint Server 2007 - Application Development	Course 50046A: Introduction to Development Using Windows SharePoint Services 3.0 (Mindsharp)	2
	Course 50026: SharePoint 2007 Hands-On Labs

For more details visit Microsoft Learning (http://www.microsoft.com/learning/en/us/default.aspx)

Microsoft Visual Studio 2008

It is focused on development of Windows Vista, 2007 Office system, and Web applications. For visual design, a new Windows Presentation Foundation visual designer and a new HTML/CSS editor influenced by Microsoft Expression Web are included. 

MCPD: Windows Developer 3.5

Exam	MOC Description	No. of Days
Exam 70-536: TS: Microsoft .NET Framework 2.0 – Application Development Foundation	Course 2956: Core Foundations of Microsoft .NET 2.0 Development (three days)	3
	Course 2957: Advanced Foundations of Microsoft .NET 2.0 Development (three days)	3

Exam	MOC Description	No. of Days
Exam 70-505:     TS: Microsoft .NET Framework 3.5, Windows Forms Application Development	2546B: Core Windows Forms Technologies with Microsoft Visual Studio 2005 (3 Days)	3
	2547A: Advanced Windows Forms Technologies with Microsoft Visual Studio 2005 (2 Days)	2
	2541B: Core Data Access with Microsoft Visual Studio 2005 (3 Days)	3
	2542A: Advanced Data Access with Microsoft Visual Studio 2005 (2 Days)	2

For more details visit Microsoft Learning (http://www.microsoft.com/learning/en/us/default.aspx)

Microsoft Windows Server 2008

It is the most advanced Windows Server operating system yet, designed to power the next generation of networks, applications, and Web services. With Windows Server 2008 you can develop, deliver, and manage rich user experiences and applications, provide a highly secure network infrastructure, and increase technological efficiency and value within your organization. 

MCTS: Windows Server 2008 Exam MOC Description No. of Days Exam 70-640:    TS: Windows Server 2008 Active Directory, Configuring  Course 50046A: Introduction to Development Using Windows SharePoint Services 3.0 (Mindsharp) 2 Course 50026: SharePoint 2007 Hands-On Labs   Exam MOC Description No. of Days Exam 70-642 TS: Windows Server 2008 Network Infrastructure, Configuring Course 6420: Fundamentals of Windows Server 2008 Network and Applications Infrastructure 5 Course 6421: Configuring and Troubleshooting a Windows Server 2008 Network Infrastructure 5 Exam MOC Description No. of Days Exam 70-643 TS: Windows Server 2008 Applications Infrastructure, Configuring Course 6418: Deploying Windows Server 2008 3 Course 6427: Configuring and Troubleshooting Internet Information Services in Windows Server 2008 3 Course 6428: Configuring and Troubleshooting Windows Server 2008 Terminal Services 2 MCITP: Server Administrator Exam MOC Description No. of Days Exam 70-640 (earns MCTS: Windows Server 2008 Active Directory Configuration) Course 6425: Configuring and Troubleshooting Windows Server 2008 Active Directory Domain Services 5 Course 6426: Configuring and Troubleshooting Identity and Access Solutions with Windows Server 2008 Active Directory 3 Exam MOC Description No. of Days Exam 70-642 (earns MCTS: Windows Server 2008 Network Infrastructure Configuration) Course 6420: Fundamentals of Windows Server 2008 Network and Applications Infrastructure 5 Exam MOC Description No. of Days Exam 70-646 PRO: Windows Server 2008, Server Administrator Course 6430: Planning and Administering Windows Server 2008 Servers 5 Course 6421: Configuring and Troubleshooting a Windows Server 2008 Network Infrastructure 5 MCITP: Enterprise Administrator Exam MOC Description No. of Days Exam 70-640 (earns MCTS: Windows Server 2008 Active Directory Configuration) Course 6425: Configuring and Troubleshooting Windows Server 2008 Active Directory Domain Services 5 Course 6426: Configuring and Troubleshooting Identity and Access Solutions with Windows Server 2008 Active Directory 3 Exam MOC Description No. of Days Exam 70-642 (earns MCTS: Windows Server 2008 Network Infrastructure Configuration) Course 6420: Fundamentals of Windows Server 2008 Network and Applications Infrastructure 5 Exam MOC Description No. of Days Exam 70-643 TS: Windows Server 2008 Applications Infrastructure, Configuring Course 6418: Deploying Windows Server 2008 3 Course 6427: Configuring and Troubleshooting Internet Information Services in Windows Server 2008 3 Course 6428: Configuring and Troubleshooting Windows Server 2008 Terminal Services 2 Exam MOC Description No. of Days Exam 70-620 (earns MCTS: Windows Vista Configuration)  OR Exam 70-624 (earns MCTS: Business Desktop Deployment) Course 5116: Configuring Windows Vista Mobile Computing and Applications 2 Course 5115: Installing and Configuring the Windows Vista Operating System 3 Course 5058: Deploying Microsoft Office 2007 Professional Plus 2 Course 5105: Deploying Windows Vista Business Desktops 3

For more details visit Microsoft Learning (http://www.microsoft.com/learning/en/us/default.aspx)

Microsoft SQL Server 2008

It has transformed the way many companies secure and retain their most valuable asset: loyal, satisfied customers. From global enterprise to small business, companies are quick to capitalize on the familiar and flexible functionality offered by the only CRM solution that works inside Microsoft Office Outlook. 

MCITP: Database Administrator 2008 Exam MOC Description No. of Days Exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance Course 6231: Maintaining a Microsoft SQL Server 2008 Database 5 Course 6315: Designing, Optimizing and Maintaining SQL Server 2008 Servers 5 Exam MOC Description No. of Days Exam 70-450: PRO: Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008 Course 6315: Designing, Optimizing and Maintaining SQL Server 2008 Servers 5 MCITP: Database Developer 2008 Exam MOC Description No. of Days Exam 70-433: TS: Microsoft SQL Server 2008, Database Development Course 6232: Implementing a Microsoft SQL Server 2008 Database 5 MCITP: Business Intelligence Developer 2008 Exam MOC Description No. of Days Exam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance Course 6234: Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services 3 Course 6235: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services 3 Course 6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services 3

For more details visit Microsoft Learning (http://www.microsoft.com/learning/en/us/default.aspx)

Dynamics 2009

Microsoft Dynamics NAV

Microsoft Dynamics NAV provides companies and their people with industry specific functionality that’s relevant to the local needs of their regions of operation, even for the most highly specialized industries and organizations. Microsoft Dynamics NAV is easy to use and offers rapid adaptability and simplified customization enabling companies to easily add functionality, custom applications and online business capabilities. With Microsoft Dynamics NAV, employees can become more effective and the company more competitive. 

Program	Modules Covered	No. of Days
ERP Using MS Dynamics NAV 5.0	Introduction to Microsoft Dynamics NAV 5.0 (8601)	2
	Installation and Configuration in Microsoft Dynamics NAV 5.0 (8870)	2
	C/SIDE Solution Development in Microsoft Dynamics NAV 5.0 (8873)	5
	C/SIDE Introduction in Microsoft Dynamics NAV 5.0(8874)	5

Microsoft Dynamics CRM

Across industries, organizations need an easy way to manage customers from first contact through to purchase and support. As a result, there’s a significant opportunity for ISVs, value-added resellers and system integrators who provide customer relationship management (CRM) solutions. Use the resources on this page to learn more about Microsoft Dynamics CRM. And discover how to build a successful business by delivering fast, flexible and cost-effective Microsoft Dynamics solutions for your customers. 

Program	Modules Covered	No. of Days
CRM Using MS Dynamics NAV 5.0	Microsoft Dynamics CRM 3.0 Sales Management (8521)	1
	Microsoft Dynamics CRM 3.0 Marketing Automation(8522)	1
	Microsoft Dynamics CRM 3.0 Service Management(8523)	1
	Microsoft Dynamics CRM 3.0 Service Scheduling(8524)	1
	Microsoft Dynamics CRM 3.0 Customization(8525)	3

For more details visit Microsoft Learning (http://www.microsoft.com/learning/en/us/default.aspx)

Microsoft Certified Systems Engineer (2003)

The Microsoft Certified Systems Engineer (MCSE) certification programs helps you to prove your expertise in designing and implementing the infrastructure for business solutions based on the Microsoft Windows 2000 Server platform and Windows Server System.

Exam Name	MOC Programs	No. of Days
Exam 70-290: Managing and Maintaining a Windows Server 2003 Environment	2274: Managing a Microsoft Windows Server 2003 Environment (five days)	5 Days
	2273: Managing and Maintaining a Microsoft Windows Server 2003 Environment (five days)	5 Days
	2275: Maintaining a Microsoft Windows Server 2003 Environment (three days)	3 Days

Exam Name	MOC Programs	No. of Days
Exam 70-291: Implementing, Managing, and Maintaining a Windows Server 2003 Network Infrastructure	Course 2276: Implementing a Windows Server 2003 Network Infrastructure: Network Hosts	2 Days
	Course 2277: Implementing, Managing, and Maintaining a Windows Server 2003 Network Infrastructure: Network Services	5 Days

Exam Name	MOC Programs	No. of Days
Exam 70-294 Planning, Implementing, and Maintaining a Windows Server 2003 Active Directory Infrastructure	Course 2279B: Planning, Implementing, and Maintaining a Windows Server 2003 Active Directory Infrastructure	5 Days

Exam Name	MOC Programs	No. of Days
Exam 70-270: Installing, Configuring, and Administering Windows XP Professional	Course 2272: Implementing and Supporting Microsoft Windows XP Professional (five days)	5 Days
	Course 2285: Installing, Configuring, and Administering Microsoft Windows XP Professional (two days)	2 Days

Exam Name	MOC Programs	No. of Days
Exam 70-297: Designing a Windows Server 2003 Active Directory and Network Infrastructure	Course 2282: Designing a Microsoft Windows Server 2003 Active Directory and Network Infrastructure (five days)	5 Days

Exam Name	MOC Programs	No. of Days
Exam 70-229:Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition	(Prerequisite) Course 2071: Querying Microsoft SQL Server 2000 with Transact-SQL (two days)	2 Days
	Course 2073: Programming a Microsoft SQL Server 2000 Database (five days)	5 Days

For more details visit Microsoft Learning (http://www.microsoft.com/learning/en/us/default.aspx)

Microsoft Certified Systems Administrator (2003)

The Microsoft Certified Systems Administrator (MCSA) certification programs  helps you advance your career by ensuring that you have the skills you need to manage and troubleshoot network environments running on the Windows operating system.

Exam Name	MOC Courses	No. of Days
Exam 70-290 :Managing and Maintaining a Windows Server 2003 Environment	2274: Managing a Microsoft Windows Server 2003 Environment (five days)	5 Days
	2273: Managing and Maintaining a Microsoft Windows Server 2003 Environment (five days)	5 Days
	2275: Maintaining a Microsoft Windows Server 2003 Environment (three days)	3 Days

Exam Name	MOC Courses	No. of Days
Exam 70-291: Implementing, Managing, and Maintaining a Windows Server 2003 Network Infrastructure	Course 2276: Implementing a Windows Server 2003 Network Infrastructure: Network Hosts	2 Days
	Course 2277: Implementing, Managing, and Maintaining a Windows Server 2003 Network Infrastructure: Network Services	5 Days

Exam Name	MOC Courses	No. of Days
Exam 70-270 :Installing, Configuring, and Administering Windows XP Professional	Course 2272: Implementing and Supporting Microsoft Windows XP Professional (five days)	5 Days
	Course 2285: Installing, Configuring, and Administering Microsoft Windows XP Professional (two days)	2 Days

Exam Name	MOC Courses	No. of Days
Exam 70-431 : TS: Microsoft SQL Server 2005 – Implementation and Maintenance	Course 2780B: Maintaining a Microsoft SQL Server 2005 Database (five days)	5 Days
	Course 2785AL: Implementing and Maintaining a Microsoft SQL Server 2005 Database (five Days)	5 Days
	Course 2779B: Implementing a Microsoft SQL Server 2005 Database (five days)	5 Days

For more details visit Microsoft Learning (http://www.microsoft.com/learning/en/us/default.aspx)

Interconnecting Cisco Networking Devices Part 1 (ICND1) v1.0

Exam Code: 640-822 ICND1

Introduction
This program focuses on providing the skills and knowledge necessary to install, operate, and troubleshoot a small branch office Enterprise network, including configuring a switch, a router, and connecting to a WAN and implementing network security. A Student should be able to complete configuration and implementation of a small branch office network under supervision.

Duration: 40 Hours

Program Contents:

• Module 1 - Building a Simple Network
• Module 2 - Ethernet Local Area Networks
• Module 3 - Wireless Local Area Networks
• Module 4 - Exploring the Functions of Routing
• Module 5 - Wide Area Networks
• Module 6 - Network Environment Management

Exit Profile:

Upon completion of the program, the candidate can install, operate, and troubleshoot a small network.

Global Certification Mapping:

If student clears only ICND1(640-822), he/she gets certified as CCENT(Cisco Certified Entry Networking Technician)  certificate

Interconnecting Cisco Networking Devices Part 2 (ICND2) v1.0

Exam Code: 640-816 ICND2/640-802 CCNA

Introduction
This program focuses on providing the skills and knowledge necessary to install, operate, and troubleshoot a small to medium-size branch office Enterprise network, including configuring several switches and routers, connecting to a WAN and implementing network security.

Duration: 40 Hours

Prerequisites:
ICND1

Program Contents:

• Module 1 - Small Network Implementation
• Module 2 - Medium-Sized Switched Network Construction
• Module 3 - Medium-Sized Routed Network Construction
• Module 4 - Single Area OSPF Implementation
• Module 5 - EIGRP Implementation
• Module 6 - Access Control Lists
• Module 7 - Address Space Management
• Module 8 - LAN extension into a WAN

Exit Profile:
Upon completion of the program, the candidate can install, operate, and troubleshoot a medium-sized network, including connecting to a WAN and implementing network security.

Global Certification Mapping:
If student clears both ICND1 (640-822) and ICND2 (640-816) he/she gets certified as CCNA (Cisco Certified Network Associate) certificate.
If student clears combined exam of CCNA (640-802) he/she gets certified as CCNA (Cisco Certified Network Associate

CCDA - CISCO CERTIFIED DESIGN ASSOCIATE

Exam Code: 640-863 DESGN

Introduction
The Designing for Cisco Internetwork Solutions (DESGN) Program v 2.0 is a new version. In addition to general approaches and technologies for network design, it promotes Cisco solutions in designing and implementing scalable internetworks. Among specific goals is the promotion of the modular approach to network design that has been intuitively used for the last few years and that Cisco formalized. The early modular approaches to network design divided networks into access, distribution and core layers only, separately for the campus and the WAN part. The Enterprise Composite Model facilitates designing, planning, implementing, operating and optimizing (PDIOO) networks by concentration on a certain module and on relations between the modules. Taking into account that most network solutions today (e.g. voice, video, storage networking, content networking) are typically overlay solutions spanning several modules, the composite modular approach seems even more relevant and is the main focus of this course. In addition, services virtualization and the SONA architecture are presented. The general program objectives remain the same, because ultimately - the tasks a designer must perform did not change, however, the products, technologies, services and solutions did change.

Duration: 40 Hours

Prerequisites

The knowledge and skills that a learner must have before attending this program include the following:

• CCNA Certification is a must
• Must have completed Building Cisco Multilayer Switched Networks (BCMSN)

Program Contents:

• Module 1: Applying a Methodology to Network Design
• Module 2: Structuring and Modularizing the Network
• Module 3: Designing Basic Campus and Data Centre Networks
• Module 4: Designing Remote Connectivity
• Module 5: Designing IP Addressing and Selecting Routing Protocols
• Module 6: Evaluating Security Solutions for the Network
• Module 7: Identifying Voice Networking Considerations
• Module 8: Identifying Wireless Networking Considerations
• Module 9: Implementing and Operating the Network Design

Global Certification Mapping:
If a student clears the exam 640-863 DESGN, he/she gets certified as CCDA (Cisco Certified Design Associate).

CCNA Security - Cisco Certified Network Associate Security

Implementing Cisco IOS Network Security

Exam Code: 640-553 IINS

Introduction:
Implementing Cisco IOS Network Security (IINS) v1.0 is an instructor-led program presented by Cisco training partners to their end-user customers. This program focuses on the necessity of a comprehensive security policy and how it affects the posture of the network. Learners will be able to perform basic tasks to secure a small branch type office network using Cisco IOS security features available through web-based GUIs (Cisco Router and Security Device Manager [SDM]) and the command-line interface (CLI) on the Cisco routers and switches.

Duration: 40 hours

Prerequisites

The knowledge and skills that a learner must have before attending this program are as follows:

• Skills and knowledge equivalent to those learned in Interconnecting Cisco Networking Devices Part 1 (ICND1).
• Working knowledge of the Windows operating system.

Program Contents:

• Module 1: Introduction to Network Security Principles
• Module 2: Perimeter Security
• Module 3: Network Security Using Cisco IOS Firewalls
• Module 4: Site-to-Site VPNs
• Module 5: Network Security Using Cisco IOS IPS
• Module 6: LAN, SAN, Voice, and Endpoint Security Overview

Exit Profile:
Upon completion of the program, the candidate can install, troubleshoot and monitor Cisco Security technologies.

Global Certification Mapping:
If a student clears 640-553 IINS, then he/she gets certified as CCNA Security (Cisco Certified Network Associate Security)

CCNA VOICE - Cisco Certified Network Associate Voice

Implementing Cisco IOS Unified Communications

Exam Code: 640-460 IIUC

Introduction:
This program provides the student with Unified Communications concepts, component definition and high level designs. This is also the core technology program in the certification path to achieve the CCNA Voice designation. Students will be able implement and configure small to medium sized IP Telephony solutions. UC products covered during labs include the Cisco Unified Communications Manager Express / Cisco Unity Express and the UC500 Smart Business Communications System.

Duration: 40 hours

Prerequisites
ICND1

Program Contents:

• Cisco Unified Communications Systems Introduction
• Cisco Unified Communications Manager Express Implementation
• Cisco Unity Express Implementation
• Cisco Smart Business Communications System Implementation

Exit Profile:
Upon completion of the program, the candidate can perform baseline installation, configuration and maintenance tasks on Cisco VoIP – IP Telephony, IP PBX, Handset, call control & Voice mail solutions.

Global Certification Mapped:
If the student clears 640-460 IIUC, he/she get certified as CCNA Voice (Cisco Certified Network Associate Voice.

CCNP - CISCO CERTIFIED NETWORKING PROFESSIONAL

Introduction:
Cisco Certified Network Professional (CCNP®) validates knowledge and skills required to install, configure and troubleshoot converged local and wide area networks with 100 to 500 or more nodes. With a CCNP certification, a network professional demonstrates the knowledge and skills required to manage the routers and switches that form the network core, as well as edge applications that integrate voice, wireless, and security into the network. The CCNP curriculum includes building scalable Cisco networks, Cisco multilayer switched networks, securing converged wide area networks, and optimizing converged networks.

Duration: 120 Hours

Prerequisites
Must be CCNA certified

Program Contents:     

• Implementing Cisco IP Routing (ROUTE)
• Implementing Cisco Switched Networks (SWITCH)
• Troubleshooting and Maintaining Cisco IP Networks (TSHOOT)

Exit Profile:
Upon completion of the program, the candidate can Install, Configure and Troubleshoot Converged Local and Wide Area Networks with 100 to 500 or More Nodes.

Global Certification Mapped:
If a student clears 642-902 ROUTE, 642-813 SWITCH and 642-832 TSHOOT, he/she get certified as CCNP (Cisco Certified Networking Professional)

Implementing Cisco IP Routing (ROUTE)

Exam Code: 642-902 ROUTE

Introduction
Implementing Cisco IP Routing (ROUTE) v1.0 is an instructor-led training programme presented by Cisco training partners to their end customers. This program is designed to help students prepare for Cisco CCNP® certification. The ROUTE programme is a component of the CCNP curriculum.
The ROUTE programme is designed for network engineers with at least one year of professional work experience, who are ready to advance their skills and work independently on complex network solutions. Students will learn to plan, configure and verify the implementation of secure enterprise LAN and WAN routing solutions using a range of routing protocols. This programme also covers configuration of solutions to support branch offices and mobile workers

Duration: 40 hours

Prerequisites
CCNA

Program Contents:

• Module 0: Programme Overview
• Module 1: Planning Routing Services
• Module 2: Implementing an EIGRP based Solution
• Module 3: Implementing a Scalable Multiarea Network OSPF based Solution
• Module 4: Implement an IPv4 based redistribution solution
• Module 5: Implement Path Control
• Module 6: Connecting an Enterprise Network to ISP Networks
• E-Learning ROUTE-01 of 3: Implement Path Control
• E-Learning ROUTE-02 of 3: Implementing IPv6
• E-Learning ROUTE-03 of 3: Implementing Routing Facilities for Branch Offices and Mobile Workers

Implementing Cisco Switched Networks (SWITCH)

Exam code: 642-813 SWITCH

Duration: 40 hours

Prerequisites: CCNA

Introduction
Implementing Cisco IP Switched Networks (SWITCH) v1.0 is an instructor-led training Programme presented by Cisco training partners. This programme is designed to help students prepare for Cisco CCNP(R) certification. The SWITCH programme is one of three components in the CCNP curriculum.
SWITCH is designed for network engineers with at least one year of professional work experience, who are ready to advance their skills and work independently on complex network solutions. Students will learn to plan, configure and verify the implementation of complex enterprise switching solutions using Cisco's Campus Enterprise Architecture. The programme also covers secure integration of VLANs, WLANs, voice and video traffic into campus networks.

Programme Outline

• Module 0: Programme Overview
• Module 1: Analyzing Campus Network Designs
• Module 2: Implementing VLANs in Campus Networks
• Module 3: Implementing Spanning Tree
• Module 4: Implementing Inter-VLAN Routing
• Module 5: Implementing First Hop Redundancy in a Campus Environment
• Module 6: Implementing a Highly Available Network
• Module 7: Minimizing Service Loss and Data Theft in a Campus Network
• Module 8: Integrating Wireless LANs into a Campus Network
• Module 9: Accommodating Voice and Video in Campus Networks

Troubleshooting and Maintaining Cisco IP Networks (TSHOOT)

Exam code:   642-832 TSHOOT

Duration: 40 hours

Prerequisites: CCNA

Introduction
Troubleshooting and Maintaining Cisco IP Networks (TSHOOT) v1.0 is an instructor-led training programme presented by Cisco training partners. This programme is designed to help students prepare for Cisco CCNP(R) certification. The TSHOOT programme is one of three components in the CCNP curriculum.
TSHOOT is designed for network engineers with at least one year of professional work experience, who are ready to advance their skills and work independently on complex network solutions. Students will learn to (1) plan and perform regular maintenance on complex enterprise routed and switched networks and (2) use technology-based practices and a systematic ITIL-compliant approach to perform network troubleshooting. Extensive labs provide for hands-on learning and reinforce troubleshooting skills.

Program Contents:

• Module 0: Curriculum Overview
• Module 1: Planning Maintenance for Complex Networks
• Module 2: Selecting Maintenance and Troubleshooting Tools and Applications
• Module 3: Planning Troubleshooting Processes for Complex Enterprise Networks
• Module 4: Maintaining and Troubleshooting Campus Switching-Based Problems
• Module 5: Maintaining and Troubleshooting Routing Based Solutions
• Module 6: Maintaining and Troubleshooting Network Security Solutions
• Module 7: Maintaining and Troubleshooting Integrated, Complex Enterprise Networks
• E-Learning TSHOOT-01: Troubleshooting Performance Problems on Switches
• E-Learning TSHOOT-02: Troubleshooting Wireless Connectivity
• E-Learning TSHOOT-03: Troubleshooting Voice over IP
• E-Learning TSHOOT-04: Troubleshooting Video
• E-Learning TSHOOT-05: Troubleshooting Multicast
• E-Learning TSHOOT-06: Troubleshooting NAT and PAT
• E-Learning TSHOOT-07: Troubleshooting DHCP
• E-Learning TSHOOT-08: Troubleshooting IPv6, OSPFv3, and RIPng