10775A: Administering Microsoft SQL Server 2012 Databases

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database. Also this course helps you prepare for the Exam 70-462
http://www.microsoft.com/learning/en-us/course.aspx?ID=10776A

10776A: Developing Microsoft SQL Server 2012 Databases

This 5-day instructor-led course introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as transactions, concurrency, error handling, triggers, and SQL CLR are also covered in this course. Also this course helps you prepare for the Exam 70-464

20336A Core Solutions of Microsoft Lync Server 2013

This 5 day class teaches IT professionals how to plan, design, deploy, configure, and administer a Microsoft Lync Server 2013 solution. The course emphasizes Lync Server 2013 Enterprise Unified Communications features with particular emphasis on coexisting with and migrating from legacy communication services. The labs in this course create a solution that includes IM and Presence, Conferencing, and Persistent Chat. This course helps the student prepare for Exam 70-336.

20341A: Core Solutions of Microsoft Exchange Server 2013

In this 5 day course, students will learn to configure and manage a Microsoft Exchange Server 2013 messaging environment. This course will teach students guidelines, best practices, and considerations that will help them optimize their Exchange server deployment. Course 20341 is an instructor-led course and will provide you with the knowledge and skills to plan, install, and manage the mailbox role, client access, transport, and Exchange infrastructure.

20342 Advanced Solutions of Microsoft Exchange Server 2013

This 5 day course will provide you with the knowledge and skills to configure and manage a Microsoft Exchange Server 2013 messaging environment. This course will teach you how to configure Exchange Server 2013, and it will provide guidelines, best practices, and considerations that will help you optimize your Exchange Server deployment.

20411: Administering Windows Server 2012

Learn how to administer Windows Server 2012 with this five-day course. This course is part two in a series of three courses that provides the skills and knowledge necessary to implement a core Windows Server 2012 Infrastructure in an existing enterprise environment. The three courses collectively cover implementing, managing, maintaining and provisioning services and infrastructure in a Windows Server 2012 environment. Although there is some cross-over of skills and tasks across these courses, this course primarily covers the administration tasks necessary to maintain a Windows Server 2012 infrastructure such as Implementing Server Images, User and Group management with Active Directory Domain Services(AD DS) and Group Policy, Remote Access and Network Policies, Data Security, Monitoring and Update Management
For full course description please go to: http://www.microsoft.com/learning/en/us/course.aspx?ID=20411D

20412A: Configuring Advanced Windows Server 2012 Services

In this 5 day class learn how to configure advanced services using Windows Server 2012. This course will primarily cover advanced configuration and services tasks necessary to deploy, manage and maintain a Windows Server 2012 infrastructure, such as identity management, network load balancing, business continuity and disaster recovery, fault tolerance and rights management. This course maps directly to exam 70-412
For full course description please go to: http://www.microsoft.com/learning/en/us/course.aspx?ID=20412B

50322: Configuring and Administering Windows 7

This five-day instructor-led course provides students with the knowledge and skills to configure and administer Microsoft Windows 7 as a standalone installation or in a corporate environment as a part of a Windows Active Directory domain. It can also be used to prepare for exam 70-680 TS: Windows 7, Configuring.
The contents of the course provide students with the ability to create and deploy images, configure hardware and software, configure networking and backup and restore system information. The course also provides a complete set of exercises on installing and configuring DirectAccess in the classroom.

6293A: Troubleshooting and Supporting Windows 7 in the Enterprise

This 3 day course is designed for Information Technology (IT) professionals who have experience with Windows XP and Windows Vista who work as Windows 7 Enterprise Desktop Support Technicians (EDSTs) in Tier 2 support environments. The goal of this training is to enable these individuals to support the Windows 7 operating system and solve technical troubleshooting problems in a Windows 7 and Windows Server 2008 R2 networking environment.
This course helps candidates prepare for Exam 70-685, the final requirement for the Enterprise Desktop Support Technician (EDST) professional credential.

Microsoft SQL Queries Advanced

In the course SQL: Fundamentals of Querying, you performed basic SQL querying. Because of various business conditions and requirements, in addition to querying the database, you may need to restructure and index tables. You may also need to manipulate the data in the tables using advanced queries. In this course, SQL: Advanced Querying, you will create advanced SQL queries to manipulate and index tables. You will learn to:
Use subqueries to generate query output.
Manipulate table data by inserting, updating, and deleting records in a table.
Manipulate the table structure.
Create views, manipulate data through views, modify the view structure, and drop views.
Create indices on table columns and drop inefficient indices.
Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction.

Microsoft SQL Queries Fundamentals

You have access to company databases and your job may require you to retrieve data from these databases. Retrieval of information from a database is dependent on precisely ordered logic and specific information. The course, SQL: Fundamentals of Querying will help you use Structured Query Language (SQL) as a tool to implement logic and define instructions.
You will learn how to compose SQL queries to retrieve information from the database.

This five-day, instructor-led course will provide you with the knowledge and skills to configure and manage a Microsoft Exchange Server 2010 messaging environment. This course will teach you how to configure Exchange Server 2010, as well as provide guidelines, best practices, and considerations that will help you optimize your Exchange server deployment.
This course is intended for people aspiring to be enterprise-level messaging administrators. Others who may take this course include IT generalists and help desk professionals who want to learn about Exchange Server 2010. People coming into the course are expected to have at least 3 years experience working in the IT field—typically in the areas of network administration, help desk, or system administration. They are not expected to have experience with previous Exchange Server versions.

MOC 10174 Configuring and administering Sharepoint 2010

This five-day instructor-led course teaches students how to install, configure, and administer Microsoft SharePoint and also how to manage and monitor sites and users by using Microsoft SharePoint 2010. It will also cover the new features and functionality introduced with SharePoint 2010 Sp1 as well as Offices 365's SharePoint Online.

This five-day instructor-led course provides knowledge and skills on developing Web applications by using Microsoft Visual Studio 2010.
This course is intended for Web developers who are beginners and have knowledge of Hypertext Markup Language (HTML) or Dynamic HTML (DHTML), along with some knowledge of a scripting language such as Visual Basic Scripting Edition or Microsoft Jscript.
Students are required to have the following skills:
•Ability to construct a simple Web page using a Microsoft or 3rd Party tool. For example, create or customize a Web Page on a SharePoint site.

MOC 20410: Installing and Configuring Windows Server 2012

Get hands-on instruction and practice installing and configuring Windows Server 2012, including Windows Server 2012 R2, in this five-day Microsoft Official Course. This course is part one in a series of three courses that provides the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment.

MOC 20411 - Administering Windows Server 2012

Get hands-on instruction and practice administering Windows Server 2012, including Windows Server 2012 R2, in this five-day Microsoft Official Course. This course focuses on the administration tasks necessary to maintain a Windows Server 2012 infrastructure such as configuring and troubleshooting name resolution, user and group management with Active Directory Domain Services (AD DS) and Group Policy, implementing Remote Access solutions such as DirectAccess, VPNs and Web Application Proxy, implementing Network Policies and Network Access Protection, Data Security, deployment and maintenance of server images, as well as update management and monitoring of Windows Server 2012 environments.

MOC 6231 Maintaining a Microsoft SQL Server 2008 Database

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

MOC 6236 SQL server 2008 reporting services

This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.

MOC 6418 Deploying Windows Server 2008

This 3 day course will provide you with the knowledge and skills to install and deploy Windows Server 2008 R2. This course also will teach you how to automate server deployment, as well as provide guidelines, best practices, and considerations that will help you to migrate existing services to Windows Server 2008 R2.

This five-day instructor-led course combines five days worth of instructor-led training content from the Network Infrastructure Technology Specialist, Active Directory Technology Specialist, and IT Professional Server Administrator courses of Windows Server 2008 to provide students with the knowledge and skills that are required to manage accounts and resources, maintain server resources, monitor server performance, and safeguard data in a Microsoft Windows Server 2008 environment. This course covers the core skills required by anyone working with Windows Server 2008 Servers.

This five-day course provides students with the knowledge and skills to configure and troubleshoot a Windows Sever 2008 network infrastructure. Students will learn to implement and configure secure network access and implement fault tolerant storage technologies. Students will gain an understanding of the network technologies most commonly used with Windows Server 2008 and IP-enabled networks. Students will also learn how to secure servers and maintain update compliance.

MOC 6430 Planning and Administering Windows Server 2008 Servers

This 3-day course is intended for IT pros who are interested in the knowledge and skills necessary to plan a Windows Server 2008 operating system infrastructure. The course content and exercises direct you toward making decisions and providing guidance to others. This course reflects the decision-making tasks that a server administrator undertakes.

VMware vSphere: Install, Configure, Manage [V6.5]

This five-day course features intensive hands-on training that focuses on installing, configuring, and managing VMware vSphere® 6.5, which includes VMware ESXi™ 6.5 and VMware vCenter Server® 6.5. This course prepares you to administer a vSphere infrastructure for an organization of any size. It is the foundation for most other VMware technologies in the software-defined data center.

VMware vSphere: What's New [V5.5 to V6.5]

VMware vSphere: In this three-day, hands-on training course, you will explore the new features and enhancements in VMware vCenter Server® 6.5 and VMware ESXi™ 6.5. Real-world use case deployment scenarios, hands-on lab exercises, and lectures will teach you the skills that you need to effectively implement and configure VMware vSphere® 6.5. This course is recommended for customers who want to deploy vSphere 6.5 into their existing vSphere environment.