Windows Vista / XP / 2003 - Exchange - IIS - SQL Server - SharePoint

Objective
To provide the knowledge and skills required to effectively configure and administer Windows Vista systems.

Target audience
System or network administrators and IT technicians.

Prerequisites
Knowledge of the Windows user interface.

Topics covered

• Overview of Windows Vista
• Comparison with Windows XP
• Tools for checking hardware compatibility
• Automating an installation
• The management interface
• Configuring the working environment
• Network configuration
• Managing wireless devices
• Security concepts
• Optimizing performance
• Remote management and control
• Maintenance tools
• Backups and Shadow Copy

Objective
To provide the knowledge and skills required to administer Windows XP Professional.

Target audience
System or network administrators and IT technicians.

Prerequisites
Knowledge of the Windows XP user interface.

Topics covered

• Installing Microsoft Windows XP Professional
• Automating the installation of Windows XP Professional
• Configuring hardware on a computer running Windows XP Professional
• Troubleshooting the boot process and other system issues
• Configuring Windows XP Professional to operate in a Windows network
• Configuring the desktop environment
• Configuring and supporting TCP/IP
• Configuring name resolution
• Supporting remote users
• Configuring Windows XP for mobile computing
• Managing disks
• Configuring and managing File Systems
• Security parameters for Windows XP
• Monitoring resources and performance
• Managing service packs
• Managing the built-in firewall

Objective
To provide the knowledge and skills required to install and configure a Windows 2008 server and to administer an Active Directory domain.

Target audience
System and network administrators, and technical support personnel.

Prerequisites
Experience with Windows XP / 2003 / Vista.

Topics covered

• Installing Window Server 2008
• Local and remote server administration
• DDNS administration
• Setting up and managing Active Directory services
• The roles of servers in Active Directory
• Managing objects in Active Directory
• Introduction to group strategies and application deployment
• Managing security
• Preventive maintenance and system monitoring

Objective
To provide the knowledge and skills required to configure a Windows 2003 Server and to administer an Active Directory domain.

Target audience
System or network administrators and IT technicians.

Prerequisites
Knowledge of the Windows XP/2003 user interface.

Topics covered

• Overview and installation of Windows 2003 Server
• Configuring the working environment
• Local and remote server administration
• Implementing and administering Active Directory
• User accounts and groups in an Active Directory domain
• Introduction to group strategies
• Managing the security of file system resources and partitions (NTFS and EFS)
• Data backup and restoration
• Disk management and crash protection
• Preventive maintenance and system monitoring
• Managing print services
• Managing service packs

Objective
To provide the knowledge and skills required to carry out Active Directory and network service administrative tasks.

Target audience
System or network administrators and IT technicians.

Prerequisites
Practical experience with Windows XP administration (Course MS306) and Windows Server 2003 administration (Course MS307).

Topics covered

• Designing a Windows XP/2003 network
• Implementing the TCP/IP protocol
• Configuring sites
• Installing a domain name server (DNS)
• Implementing and administering Active Directory
• Integrating DNS and Active Directory
• Administering group policy
• Managing Active Directory performance
• Implementing Windows Internet Name Service (WINS) and Dynamic Host Configuration Protocol (DHCP)
• Deploying Windows XP using WDS
• Managing disks with Distributed File System (DFS) and maintaining versions with Shadow copy and VSS
• Remote access: routing and virtual private networks (VPN)
• Supporting address translation (NAT)
• Security: IPSec and monitoring

Objective
To provide the knowledge and skills required to use scripts to automate various Windows administration tasks, such as user account management, directory security and driver installation.

Target audience
System or network administrators and IT technicians with little or no knowledge of programming.

Prerequisites
Practical experience with Windows 2000 administration (Course MS305) or Windows XP administration (Course MS306) and Windows Server 2003 administration (Course MS307).

Topics covered

• Basic features of Windows Scripting Host (WSH)
• Loops in VBScript: for, do, while and do until
• Testing conditions in VBScript: if, then, else and elseif
• Handling arguments and arrays
• Managing files and directories
• Windows Management Instrumentation (WMI): its usefulness, and how to execute requests
• Active Directory Services Interface (ADSI)
• Executing requests with ADSI
• Searching with Active Directory
• Using subroutines
• Configuring authentication and network component management scripts
• Basic configuration of printers and the registry
• Design of scripts for other environments (IIS, Exchange, etc.)

Objective
To provide the knowledge and skills required to use Group Policy Objects to administer Active Directory in Windows 2003 networks.

Target audience
System or network administrators and IT technicians.

Prerequisites
Practical experience with Windows Server 2003 administration and Active Directory (Course MS307).

Topics covered

• How Group Policy Objects (GPOs) work
• Security features provided by GPOs
• Differences between local policies and Active Directory domain policies
• Security models and administrative models
• Using the Group Policy Management Console
• Restricting access to software with GPOs
• Managing Internet access with GPOs
• Using GPOs to deploy service packs
• Using GPOs to deploy applications (Office)
• Configuring firewalls with GPOs
• Documenting and policy validation

Objective
To provide the knowledge and skills required to describe the structure of the Windows Registry, and to manage it correctly and efficiently.

Target audience
System or network administrators and IT technicians.

Prerequisites
Practical experience with Windows XP administration (Course MS306) and Windows Server 2003 administration (Course MS307).

Topics covered

• Registry architecture, hierarchy, components and files
• Tools for editing the Registry
• Searching for parameters in the Registry
• Import, export, backup and restore operations
• The Microsoft Tweak UI utility
• Local strategies and the Registry
• Managing security
• Handling data corruption in the Registry
• Registry clean-up utilities
• Automating modifications to the Registry
• User profiles and the Registry
• Examples of support and maintenance applications

Objective
To provide the knowledge and skills required to configure, administer and optimize terminal services with Windows Server 2008, and to deploy applications that make use of terminal services.

Target audience
System or network administrators and IT technicians.

Prerequisites
Practical experience with Windows Server 2008 administration and Active Directory (Course MS307).

Topics covered

• Advantages and disadvantages of Server Based Computing
• Installing and configuring Terminal Services (TS) with Windows Server 2008
• Thin clients and communication protocols
• Administering and configuring the user environment
• Deploying applications on a server that provides terminal services (TS server)
• Publishing office and windowing applications
• Managing security for a TS server
• Setting up a server farm
• Monitoring and optimizing a TS server
• Organizing the production environment

Objective
To provide the knowledge and skills required to secure a Windows Vista/XP/2003 network.

Target audience
System or network administrators and IT technicians.

Prerequisites
Practical experience with Windows XP administration (Course MS306), Windows Server 2003 and Active Directory administration (Course MS307).

Topics covered

• Introduction to Microsoft Windows Vista/XP/2003 security
• Security issues at the Active Directory level
• Authenticating users and clients
• Planning the administrative structure for security groups
• Security issues related to designing group policies
• Using smart cards for network authentication
• Securing file systems with EFS encryption
• Evaluating and analyzing workstation security
• Securing network services: DNS, DHCP, RIS, SNMP and TS
• Planning a public key infrastructure (PKI)
• Securing data at the application layer
• Remote access and Internet security

Objective
To provide the knowledge and skills required to install, configure and manage ISA Server 2006, and to set up a security infrastructure.

Target audience
System and network administrators, computer technicians

Prerequisites
Experience with Windows 2003 administration (Course MS307).

Topics covered

• Introduction to ISA 2006
• ISA 2006 administration and maintenance
• Planning a deployment strategy for ISA 2006
• Installing ISA 2006
• Network configuration with ISA 2006
• Managing firewall strategy parameters
• Controlling access to virtual private networks (VPNs)
• Configuring common ISA 2006 parameters (clients, connections, delegation, etc.)
• Configuring cache parameters
• Deploying applications under ISA 2006
• Understanding and configuring ISA 2006 monitoring tools

Objective
To provide the knowledge and skills required to deploy and maintain Microsoft operating systems and applications.

Target audience
System and network administrators, computer technicians

Prerequisites
Experience with Windows 2003 administration (Course MS307).

Topics covered

• Introduction to Microsoft's new deployment tools
• Deploying the Windows Vista operating system
• Automating and customizing deployments
• Configuring deployment images
• Using the Microsoft Deployment Toolkit (formerly Business Desktop Deployment, BDD)
• Customizing and setting up Windows PE (Preinstallation Environment)
• Configuring parameters and components for Office 2007
• Upgrading existing systems

Objective
To provide the knowledge and skills required to deploy test, training and production environments using Virtual PC 2004, Virtual Server 2005 and VMware Server 1.0 in order to implement the best possible virtualization strategy for the needs of the business.

Target audience
System or network administrators and IT technicians.

Prerequisites
Practical experience with Windows XP administration (Course MS306) and Windows Server 2003 administration (Course MS307).

Topics covered

• Introduction to virtual machines
• Main uses of virtual environments: test environments for developers or administrators, training environments, and production environments
• Licensing and legal aspects related to virtual machines
• Host/Guest systems
• Virtual PC 2004 vs Virtual PC 2005
• Installing, configuring and deploying Virtual PC 2004 and Virtual PC 2005
• Using Virtual PC 2005 for consolidating legacy systems and dedicated application servers
• Aspects of the physical infrastructure required for Virtual Server 2005: clustering and high availability
• Tools for migrating from physical to virtual machines (VSMT and alternative solutions)
• Presentation of VMware products

Objective
To provide the knowledge and skills required to install, configure and administer Exchange Server 2007 at a central site.

Target audience
System or network administrators and IT technicians.

Prerequisites
Practical experience with Windows 2003 administration (Course MS307).

Topics covered

• Overview of Exchange 2007
• Pre-deployment planning
• Exchange 2007 installation
• The architecture of Exchange 2007
• Mailbox management
• Public folders
• The Anywhere Access tools (OWA, Outlook AnyWhere)
• Anti-spam/Anti-virus features
• Exchange Server 2007 roles
• Implementation tools
• The Outlook 2007 client
• Migration strategies and planning

Objective
To provide the knowledge and skills required to install, configure and administer Internet Information Services (IIS) 7.

Target audience
System or network administrators and IT technicians.

Prerequisites
Practical experience with Windows 2003 administration (Course MS307) or Windows Server 2008 administration (Course MS320).

Topics covered

• Web administration fundamentals
• Overview of IIS and its architecture
• Administering Web services
• Administration via the command line
• Configuring virtual services and sites
• Configuring ASP.NET sites
• Web server security: NTFS permissions and authentication
• Implementing security strategies
• Administering messaging services (SMTP and POP3)
• Performance tracking and IIS optimization
• Backing up and restoring sites and IIS configurations

Objective
To provide the knowledge and skills required to administer a SCCM 2007 environment.

Target audience
System or network administrators and IT technicians.

Prerequisites
Practical experience with Windows 2003 administration (Course MS307).

Topics covered

• Overview of System Center Configuration Manager 2007
• Planning an installation of the System Configuration Manager 2007 infrastructure
• Site configuration
• Resource discovery
• Installing the Configuration Manager client
• Inventory management and remote control
• Managing pools
• Managing and publishing applications
• Managing Windows updates
• Managing requests and creating reports
• Security management
• Recovery processes
• SCCM 2007 maintenance

Objective
To provide the knowledge and skills required to master the new features and functionality provided by SQL Server 2008.

Target audience
System administrators and IT professionals.

Prerequisites
None.

Topics covered

• The SQL date and time types (date, time, datetime2, datetimeoffset), support for the ISO week, and time zone management
• Data compression for the Data Warehouse command SQL MERGE (INSERT and UPDATE combined)
• Implementing security rules
• The spatial data module (GIS)
• Creating new server roles
• The new "hierarchy" type (trees)
• The new filestream type (similar to the SQL standard datalink), which permits a file reference to appear as a field in a table
• The table type
• Parameterizing the table name in requests (e.g. SELECT FROM @TableName)
• Compressed back-ups
• Support for LINQ (Language Integrated Query), which provides sophisticated queries
• GROUPING SETS for OLAP functions on OLTP databases
• Data traceability
• Improved integration with Office

Accredited course.
6 PDU

Objective
To provide the knowledge and skills required to install, configure and manage SQL Server 2008

Target audience
System administrators and technical support personnel.

Prerequisites
Experience with SQL Server 2005 administration (Course MS509).

Topics covered

• Description of new functionality in SQL Server 2008
• New features in Management Studio: IntelliSense
• Beyond relational: presenting new data types
• Migrating from SQL Server 2005 to SQL Server 2008
• Managing dates and times with the new data types
• Optimizing storage with compressed backups
• Detecting bottlenecks with extended event management
• Setting up CDC
• Restoring an encrypted database on another instance of SQL Server
• Optimizing SQL Server 2008
• Securing an SQL Server 2008 database
• Monitoring and fixing performance problems with Management Studio
• Using SQL Server 2008 Integration Services (SSIS)
• Using SQL Server 2008 Reporting Services (SSRS)
• Using SQL Server 2008 Analysis Services (SSAS)

Objective
To provide the knowledge and skills required to develop databases with SQL Server 2008

Target audience
Database programmers, analysts, designers and administrators

Prerequisites
Experience with SQL Server 2005 database programming (Course MS510)

Topics covered

• New functionality and new development tools in SQL Server 2008
• Introduction to dynamic development
• Using ADO.NET's Entity Framework
• Using LINQ (Language Integrated Query)
• New data types: hierarchy (trees), filestream, table
• SQL date and time types (date, time, datetime2, datetimeoffset)
• Using Integrated Full-Text Search (IFTS)
• Improvements in Transact-SQL
• Using the MERGE instruction (INSERT and UPDATE combined)
• Parameterizing the table name in requests (e.g. SELECT FROM @MyTableVariable)

Objective
To provide the knowledge and skills required to develop SQL Server 2005 databases.

Target audience
System administrators and developers.

Prerequisites
Knowledge of Windows 2000/2003 interface, conceptual data modeling (Course BD101) and SQL (Course BD102).

Topics covered

• Overview of SQL Server 2005 and Transact-SQL
• Creating data types and tables
• Data integrity: constraints, default values, etc.
• Managing and manipulating data
• Implementing views and stored procedures
• Multiserver programming: partitioned views, linked server requests, etc.
• Using XML with SQL Server 2005
• The architecture and use of Service Broker
• The use of HTTP native support
• Architecture and implementation of notification services
• Implementing the Microsoft .NET CLR
• Developing client applications
• Planning, creating and maintaining indexes
• Managing transactions and locks
• Planning and managing security
• Performance analysis and optimization

Objective
To provide the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of SQL Server 2005.

Target audience
System administrators and developers.

Prerequisites
Practical experience with Windows 2003 administration (Course MS304 or Course MS307) and basic knowledge of SQL (Course BD102).

Topics covered

• Overview of the architecture of Microsoft SQL Server 2005
• Planning an installation of SQL Server 2005
• SQL Server 2005 administration tools
• Creation and configuration of user and system databases
• Data transfer within the database
• Backing up and restoring databases
• Managing access, permissions and certificates
• Running and automating administrative procedures
• Managing and optimizing indexes
• Tracking and optimizing performance and load levels
• Implementing replication
• Maintaining high availability

Objective
To provide the knowledge and skills required to optimize SQL Server 2000/2005 to get the highest possible performance for complex and/or high-volume applications.

Target audience
Administrators and developers faced with challenging performance problems.

Prerequisites
Experience in SQL Server 2000 administration (Course MS502) or SQL Server 2005 administration (Course MS509).

Topics covered

• Introduction to performance optimization: physical design, load analysis
• SQL Server storage mechanisms: files, FILEGROUPS, extensions and pages
• Indexes: creation, options, structure, parameterization
• Indexed views, partitioned views and partitioned tables
• The role of the optimizer: how it works, query optimization, hints
• Refining queries: the query execution plan and execution statistics
• Constraining an execution plan with tags (locks, WITH and OPTION clauses)
• SQL Server with Windows: CPU utilization, virtual memory management, RAID disks
• Transactions and locks: exclusive and shared, range, page and table locks, isolation levels, hints
• Performance monitoring, stored procedures, perfmon, alerts, SQL Profiler
• Using the Index Tuning Advisor and the Tuning Wizard
• Maintaining indexes (defragmentation) and statistics

Objective
To provide the knowledge and skills required to make effective use of SQL Server Integration Services (SSIS).

Target audience
System administrators, analysts, developers and relational database programmers.

Prerequisites
Experience with SQL language (Course BD102).

Topics covered

• SSIS Architecture: the evolution from DTS to SSIS, the SSIS development environment
• Fundamental concepts of SSIS: containers, tasks, precedence constraints, data streams, connectivity, variables, and package configurations
• Creation of a control stream and package data
• Component connection and data streams
• Designing high-performance, extensible packages
• Debugging SSIS packages: executing a package, defining breakpoints, adding a data inspector
• Controlling the progress of data streams
• Configuring and deploying SSIS packages
• Using transformations: derived columns, slowing changing dimensions, fuzzy lookups and fuzzy grouping

Objective
To provide the knowledge and skills required to make effective use of SQL Server Reporting Services (SSRS).

Target audience
System administrators, business analysts, developers and relational database programmers.

Prerequisites
Experience with SQL (Course BD101 or course BD102).

Topics covered

• SSRS features: creating and publishing reports
• Designing ad hoc report models
• Fundamental concepts of SSRS: data sources, datasets, fields and filters
• Designing reports with Report Designer and Report Wizard
• Deploying and managing reports
• Deploying a report from Visual Studio, scripts and Report Manager
• Managing reports: configuring shared data sources and report properties, configuring subscriptions
• Planning subscriptions and report processing
• Using Report Model Designer
• Examples of report models
• Creating an ad hoc report using Report Builder

Objective
To provide the knowledge and skills required to make effective use of SQL Server Analysis Services (SSAS).

Target audience
System administrators, business analysts, developers and relational database programmers.

Prerequisites
Experience with SQL (Course BD101 or course BD102)

Topics covered

• Fundamental concepts of SSAS: data sources, dimensions, cubes, the UDM model
• New features of the SSAS architecture
• Designing and deploying a UDM model
• Generating a cube
• Implementing advanced cube functionality
• SSAS administration
• Upgrading and migrating to SSAS 2005
• Aspects of the upgrade to SSAS 2005
• Configuring roles, groups and permissions
• SSAS management: performance optimization
• Managing partitions and Business Intelligence in real time
• Generating scripts with MDX
• Using data exploration solutions in SSAS
• Using data exploration tools

Objective
To provide the knowledge and skills required to effectively use XML in database development with SQL Server.

Target audience
Architects, application designers, developers, project managers and IT planners.

Prerequisites
Knowledge of XML technologies.

Topics covered

• Introduction to XML in SQL Server 2005
• Server-side processing of XML in SQL Server 2005
• Using the XML data type
• Querying and updating XML data in SQL Server 2005
• Indexing XML data in SQL Server 2005
• XML schemas in SQL Server 2005
• Improvements in Transact-SQL to support FOR XML and OPENXML
• Client-side processing of XML in SQL Server 2005
• Creating and querying XML views
• Bulk load of XML data via an XML view
• Using XSLT in SQL Server 2005
• Support for Web Services (SOAP) in SQL Server 2005
• Client-side SOAP
• Web Services Description Language (WSDL)

Objective
To provide the knowledge and skills required to describe and use the principal features of the Windows SharePoint Services collaboration tool.

Target audience
Service directors, IT managers, project managers, system administrators.

Prerequisites
Knowledge of computer science.

Topics covered

• Overview of Windows SharePoint Services
• Differences between WSS and MOSS
• introduction to SharePoint architecture
• The site model
• Lists and libraries
• Web Part components
• Integration with Windows Office
• Managing documents with SharePoint
• Managing forms
• Project management with WSS

Accredited course.
6 PDU

Objective
To provide the knowledge and skills required to install, configure and administer SharePoint Server 2007.

Target audience
System administrators and IT professionals.

Prerequisites
Basic knowledge of system administration and of Sharepoint 2007 (Course MS102).

Topics covered

• Overview of the SharePoint product family
• The goals of Microsoft Office SharePoint 2007
• Architecture of Microsoft Office SharePoint 2007
• Planning an Office SharePoint 2007 deployment
• Installing a MOSS server
• Post-installation configuration
• Administration tools
• Shared service provider configuration
• Search administration
• Managing user profiles and audiences
• Using personal sites
• Security management
• Document management features
• Web content management
• Backup and recovery

Objective
To provide the knowledge and skills required to create personal and group Web sites and to understand the functionality of SharePoint services and the SharePoint Portal server.

Target audience
Users of Windows Office.

Prerequisites
Basic knowledge of SharePoint 2007 (Course MS102).

Topics covered

• Introduction to SharePoint
• Creating a team Web site
• Components of a team Web site
• Overview of lists and libraries
• Managing content
• Handling authorization
• Site models
• Document workspaces
• Meeting workspaces

Objective
To provide the knowledge and skills required to create and update SharePoint sites using SharePoint Designer.

Target audience
Advanced users of Windows SharePoint Services and SharePoint developers.

Prerequisites
Practical experience with Windows SharePoint Services and/or Microsoft Office SharePoint server (Course MS103), and experience with web development.

Topics covered

• Introduction to SharePoint Designer
• Overview of the user interface
• Creating and modifying pages in the navigator
• Creating and modifying pages with SharePoint Designer
• Page components and WebPart components
• Using data views
• Configuring data sources
• ASP.NET controls
• Working with master pages
• Cascading style sheets (CSS)
• Page layout techniques
• Designing workflows