Microsoft Server Systems
SQL Server 2008
Your Data, Any Place, Any Time
SQL Server 2008 delivers on Microsoft’s Data Platform vision by helping your organization manage any data, any place, any time. Store data from structured, semi-structured, and unstructured documents, such as images and rich media, directly within the database. SQL Server 2008 delivers a rich set of integrated services that enable you to do more with your data such as query, search, synchronize, report, and analyze.
SQL Server 2008 provides the highest levels of security, reliability, and scalability for your business-critical applications. To take advantage of new opportunities in today's fast-moving business world, companies need the ability to create and deploy data-driven solutions quickly. SQL Server 2008 reduces time and cost of management and development of applications.
Access data from across your enterprise and provide control over your data no matter where it’s stored—from the largest servers within the data center to desktops to mobile devices. SQL Server 2008 provides a comprehensive platform that delivers intelligence where your users want it. Information workers can access data directly using the tools they use every day, such as the 2007 Microsoft Office system.
SQL Server 2008 enables data to be consumed from custom applications developed using Microsoft .NET and Visual Studio and from within service-oriented architectures (SOA) and business processes through Microsoft BizTalk Server.
Core Features:
- Business Intelligence
- Server Consolidation
- Data Warehousing
- Application Development
- OLTP
SQL Server 2008
| Code | Course Title | Duration |
|---|---|---|
| 6158 | Updating Your SQL 2005 Skills to SQL Server 2008 | 3 |
| 2778 | Writing Queries Using Microsoft SQL Server 2008 Transact-SQL | 3 |
| 6231A | Maintaining a Microsoft SQL Server 2008 Database | 5 |
| 6232A | Implementing a Microsoft SQL Server 2008 Database | 5 |
| 6234A | Implementing a Microsoft SQL Server 2008 Database Analysis Services | 3 |
| 6235A | Implementing a Microsoft SQL Server 2008 Database Integration Services | 3 |
| 6236A | Implementing a Microsoft SQL Server 2008 Database Reporting Services | 3 |
SQL Server 2005
| Code | Course Title | Duration |
|---|---|---|
| 2779 | Implementing a Microsoft SQL Server 2005 Database | 5 |
| 2780 | Maintaining a Microsoft SQL Server 2005 Database | 5 |
| 2781 | Designing Microsoft SQL Server 2005 Server-Side Solutions | 3 |
| 2782 | Designing Microsoft SQL Server 2005 Databases | 2 |
| 2783 | Designing the Data Tier for Microsoft SQL Server 2005 | 1 |
| 2784 | Tuning and Optimizing Queries Using Microsoft SQL Server 2005 | 3 |
| 2786 | Designing a Microsoft SQL Server 2005 Infrastructure | 2 |
| 2787 | Designing Security for Microsoft SQL Server 2005 | 2 |
| 2788 | Designing High Availability Database Solutions Using Microsoft SQL Server 2005 | 3 |
| 2789 | Administering and Automating Microsoft SQL Server 2005 Databases and Services 2005 | 1 |
| 2790 | Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 | 2 |
| 2791 | Implementing & Maintaining Microsoft SQL Server 2005 Analysis Services | 3 |
| 2792 | Implementing & Maintaining Microsoft SQL Server 2005 Integration Services | 3 |
| 2793 | Implementing & Maintaining Microsoft SQL Server 2005 Reporting Services | 3 |
| 2794 | Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005 | 2 |
| 2795 | Designing an ETL Solution Architect Using Microsoft SQL Server 2005 Integration Services | 2 |
| 2796 | Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services | 3 |
| 2797 | Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Services | 2 |
Exchange Server 2007
For most businesses today, e-mail is the mission-critical communications tool that allows their people to produce the best results. This greater reliance on e-mail has increased the number of messages sent and received, the variety of work getting done, and even the speed of business itself. Amid this change, employee expectations have also evolved. Today, employees look for rich, efficient access—to e-mail, calendars, attachments, contacts, and more—no matter where they are or what type of device they are using.
For IT professionals, delivering a messaging system that addresses these needs must be balanced against other requirements such as security and cost. Enterprise security requirements have become more complex as the demand and use for e-mail has increased. Today, IT departments must contend with e-mail security threats that are wide ranging: continually evolving spam and viruses, noncompliance risks, the vulnerability of e-mail to interception and tampering, in addition to the potential harmful effects of natural and man-made disasters.
While security is clearly a priority, IT is ever cognizant of the need to manage cost. Time, money, and resource constraints are a fact of life as IT is made accountable to do more with less. As a result, IT professionals look for a messaging system that addresses both enterprise and employee needs while also being cost-effective to deploy and manage.
Microsoft Exchange Server 2007 has been designed specifically to meet these challenges and address the needs of the different groups who have a stake in the messaging system. The new capabilities of Microsoft Exchange Server 2007 deliver the advanced protection your company demands, the anywhere access your people want, and the operational efficiency you, in IT, need.
Exchange Server 2007
| Code | Course Title | Duration |
|---|---|---|
| 3938 | Updating Your Skills from Microsoft Exchange Server 2000/2003 to Microsoft Exchange Server 2007 | 3 |
| 5047 | Introduction to Installing and Managing Microsoft Exchange Server 2007 | 3 |
| 5049 | Managing Messaging Security using Microsoft Exchange Server 2007 | 1 |
| 5050 | Recovering Messaging Servers and Databases using Microsoft Exchange Server 2007 | 1 |
| 5051 | Monitoring and Troubleshooting Microsoft Exchange Server 2007 | 2 |
| 5053 | Designing a Messaging Infrastructure using Microsoft Exchange Server 2007 | 3 |
| 5054 | Designing a High Availability Messaging Solutions using Microsoft Exchange Server 2007 | 2 |
Exchange Server 2003
| Code | Course Title | Duration |
|---|---|---|
| 2400 | Implementing and Managing Microsoft Exchange Server 2003 | 5 |
| 2011 | Troubleshooting Microsoft Exchange Server 2003 | 3 |
System Center Configuration Manager
System Center Configuration Manager 2007 is the solution to
comprehensively assess, deploy, and update your servers,
clients, and devices—across physical, virtual, distributed, and
mobile environments. Optimized for Windows and extensible
beyond, it is the best choice for gaining enhanced insight into,
and control over, your IT systems.
Built on key Microsoft technologies, such as Microsoft Windows
Server Update Services (WSUS), Windows Server Active Directory,
and the Windows architecture, System Center Configuration
Manager 2007 enhances your insight into, and control over, your
IT infrastructure.
With Configuration Manager 2007, organizations can ensure that IT systems comply with desired configuration states to improve systems’ availability, security, and performance network-wide. System Center Configuration Manager 2007 includes:
- Comprehensive deploying and updating
- Enhanced IT infrastructure insight and control
- Optimization for Windows and extensible beyond
System Center Configuration Manager provides system management tools for key IT areas:
- Asset Intelligence
- Software Update Management
- Desired Configuration Management
- Software Distribution
- Operating System Deployment
System Center Operations Manager
System Center Operations Manager is the end-to-end service-management product that is the best choice for Windows because it works seamlessly with Microsoft software and applications, helping organizations increase efficiency while enabling greater control of the IT environment.
- End-to-End Service Management
- Best of Breed for Windows
- Increased Efficiency and Control
System Center
| Code | Course Title | Duration |
|---|---|---|
| 6451 | Planning, Deploying and Managing Microsoft System Center Configuration Manager 2007 | 5 |
| 50028 | Managing System Center Operations Manager 2007 | 5 |
| 2287 | Managing Your Infrastructure Using Microsoft Operation Manager 2005 | 3 |
| 2596 | Managing Microsoft Systems Management Server 2003 | 5 |
Biztalk Server
| Code | Course Title | Duration |
|---|---|---|
| 2157 | Developing E-Business Solutions Using Microsoft® BizTalk® Server 2004 | 5 |
| 2933 | Developing Business Process and Integration Solution Using Microsoft BizTalk Server 2006 | 5 |
| 2934 | Deploying and Managing Business Process and Integration Solution Using Microsoft BizTalk Server 2006 | 2 |

