OCR Level 3 Certificate in ICT Systems and Principles for Professionals (PROCOM) (QCF)

What you'll be able to do

• Apply matrix methods to solve problems in IT contexts.
• Apply series, probability, and recursions to model and analyse IT-related scenarios.
• Apply graph theory to represent and solve problems related to networks and data structures.

What you'll be able to do

• Understand asset management activities in an IT environment.
• Understand configuration management activities in an IT environment.
• Carry out identified IT/technology asset management activities.
• Carry out identified IT/technology configuration management activities.
• Document IT/technology assets.
• Document IT/technology configuration management activities.
• Monitor IT/technology assets.
• Monitor IT/technology configuration management activities.

What you'll be able to do

• Evaluate asset and configuration management activities in an IT environment, considering their effectiveness and impact.
• Carry out asset and configuration management activities for an identified task, following established procedures and best practices.
• Document and monitor IT/technology assets and configuration management activities, ensuring accurate records and timely updates.

What you'll be able to do

• Implement an SQL Server Integration Services (SSIS) solution using Microsoft SQL Server 2008
• Configure SSIS using Microsoft SQL Server 2008
• Deploy SSIS using Microsoft SQL Server 2008
• Maintain SSIS using Microsoft SQL Server 2008
• Implement an SQL Server Analysis Services (SSAS) solution using Microsoft SQL Server 2008
• Configure SSAS using Microsoft SQL Server 2008
• Deploy SSAS using Microsoft SQL Server 2008
• Maintain SSAS using Microsoft SQL Server 2008
• Implement an SQL Server Reporting Services (SSRS) solution using Microsoft SQL Server 2008
• Configure SSRS using Microsoft SQL Server 2008
• Deploy SSRS using Microsoft SQL Server 2008
• Maintain SSRS using Microsoft SQL Server 2008

What you'll be able to do

• Explain the principles of Routing Services, including routing protocols, metrics, and path selection.
• Implement an EIGRP-Based Solution, including configuring EIGRP, troubleshooting issues, and optimising performance.
• Implement an OSPF-based Solution, including configuring OSPF, troubleshooting issues, and optimising performance.
• Explain the manipulation of Routing Updates, including route filtering, redistribution, and summarisation.
• Explain path control mechanisms, including policy-based routing and route maps.
• Implement a BGP solution for ISP connectivity, including configuring BGP, troubleshooting issues, and optimising performance.
• Implement Routing Facilities for Branch Offices and Mobile Workers, including VPNs and remote access solutions.
• Implement IPv6 in an Enterprise Network, including addressing, routing, and security considerations.

What you'll be able to do

• Understand the analysis required for an Enterprise Campus Architecture.
• Implement Virtual LANs (VLANs) in Campus Networks.
• Implement Spanning Tree Protocol (STP) to prevent network loops.
• Implement inter-VLAN Routing to facilitate communication between VLANs.
• Understand High Availability and Redundancy mechanisms in a Campus Network.
• Understand Campus Infrastructure Security measures to protect against unauthorised access.
• Understand the preparation of the Campus Infrastructure for Advanced Services.

What you'll be able to do

• Plan maintenance schedules for complex network infrastructures.
• Understand the processes involved in troubleshooting complex enterprise networks.
• Implement maintenance and troubleshooting tools and applications effectively.
• Maintain and troubleshoot campus switched solutions to ensure optimal performance.
• Maintain and troubleshoot routing solutions to ensure network connectivity.
• Maintain and troubleshoot addressing services within a complex network environment.
• Maintain and troubleshoot network performance issues on converged networks.
• Maintain and troubleshoot network security implementations to protect against threats.
• Maintain and troubleshoot integrated, complex enterprise networks to resolve issues efficiently.

What you'll be able to do

• Design a network infrastructure to meet specified requirements.
• Implement a prototype network based on a given design.
• Maintain a prototype network, including troubleshooting and resolving issues.

What you'll be able to do

• Configure a switched infrastructure to support network communication.
• Test and troubleshoot a routed and switched infrastructure to identify and resolve network issues.
• Understand traffic filtering techniques and implement a solution to control network traffic.

What you'll be able to do

• Understand the diverse types of network systems and devices in common use and how the different technologies operate and communicate with each other
• Understand basic security principles and their impact on the user experience and network integrity
• Configure and troubleshoot cross network communication to ensure seamless connectivity

What you'll be able to do

• Identify and understand different routing protocols used in networks
• Configure a router to communicate effectively with a WAN infrastructure
• Test and troubleshoot a network system to identify and resolve issues
• Implement address management techniques within a network environment

What you'll be able to do

• Understand the growth process of a business
• Plan for business growth, including setting objectives and strategies
• Analyse the business environment and forecast future trends to support growth
• Manage change effectively during periods of business expansion

What you'll be able to do

• Understand the strategic requirements for starting a new enterprise
• Manage and develop a suitable business model for an enterprise
• Effectively manage an enterprise

What you'll be able to do

• Understand the strategic requirements of an enterprise
• Manage and develop a strategic plan for an enterprise
• Manage a corporate portfolio

What you'll be able to do

• Implement a Wide Area Network (WAN)
• Test and troubleshoot a WAN implementation
• Plan security measures for a WAN
• Evaluate a WAN and implement appropriate security and network address management technologies

What you'll be able to do

• Configure a switched and trunked VLAN infrastructure, including setting up VLANs and trunk links
• Test and troubleshoot a VLAN infrastructure to ensure proper functionality and connectivity
• Enable a VLAN Trunk Protocol (VTP) client/server structure to operate and manage a LAN effectively
• Understand the operation of wireless systems, including wireless standards, security protocols, and network configurations

What you'll be able to do

• Know the diverse types of network systems and devices in common use
• Know how different network technologies operate and communicate
• Understand the OSI model and TCP/IP protocol suite and their relationship to the operation of network systems
• Configure a workstation for connection to a network
• Design a sub-network scheme
• Recommend improvements to an existing network infrastructure

What you'll be able to do

• Identify and understand different routing protocols and their characteristics
• Configure a router to communicate with a WAN infrastructure, using appropriate routing protocols
• Test and troubleshoot a network system to identify faults and assess the quality of communication, using appropriate tools and techniques

What you'll be able to do

• Understand the fundamental hardware principles that underpin the operation of a computer system.
• Safely assemble a range of computer systems and their components, adhering to health and safety guidelines.
• Maintain a range of computer systems and their components, including troubleshooting and repair.
• Maintain operating system components, including updates, drivers, and system configuration.
• Maintain security components, including anti-virus software, firewalls, and user access controls.
• Maintain network communication for a computer system, including configuring network settings and troubleshooting connectivity issues.

What you'll be able to do

• Understand the principles of managing computer systems
• Manage the support of operating systems
• Manage security requirements for computer systems
• Maintain networked systems

What you'll be able to do

• Use personal computer components effectively
• Understand the features and functionality of laptops and portable devices
• Understand the principles of operating systems, including Microsoft Windows 2000, XP Professional, XP Home and Media Center
• Use printers and scanners effectively
• Install and configure networks
• Work with networks effectively
• Apply security measures to computer systems and networks
• Know safety and environmental issues related to computer hardware and software
• Understand the importance of communication and professionalism in a technical support role

What you'll be able to do

• Understand the function of various personal computer components, including motherboards, CPUs, memory, storage devices, and peripherals.
• Understand the principles of operating systems, including installation, configuration, troubleshooting, and maintenance.
• Understand the operation of printers and scanners, including installation, configuration, troubleshooting, and maintenance.
• Understand the fundamentals of computer networks, including network topologies, protocols, and devices.
• Understand security fundamentals, including common threats, vulnerabilities, and security measures.
• Understand the principles of effective communication and professionalism in a technical support environment.

What you'll be able to do

• Understand the function of Personal Computer Components
• Understand the function of Laptop and Portable Devices
• Understand the function of Printers and Scanners
• Understand the fundamentals of security relating to computer systems
• Understand Safety and Environmental Issues relating to computer systems

What you'll be able to do

• Use personal computer components effectively for assembly and maintenance
• Understand personal computer troubleshooting techniques for diagnosing hardware and software issues
• Apply repair and maintenance procedures to personal computers
• Understand operating system principles and functionalities
• Understand basic networking fundamentals, including network topologies and protocols
• Understand security concepts and technology to protect personal computers from threats
• Understand operational considerations when working with personal computers, including safety and best practises

What you'll be able to do

• Understand computer hardware components and their functions
• Understand the principles and functionalities of Operating Systems, including Microsoft Windows 2000, Windows XP Professional, XP Home, XP MediaCenter, Windows Vista Home, Home Premium, Business and Ultimate
• Understand networking concepts and technologies
• Understand computer security principles and practices

What you'll be able to do

• Know the fundamental principles of telephony
• Engineer a functional computer network
• Identify the purpose of an application within a converged network
• Know the key components of hardware and architecture within a converged network
• Manage a converged network effectively
• Know the principles of security design within a converged network

What you'll be able to do

• Configure home networks
• Set up home networks
• Implement audio solutions
• Implement video solutions
• Know telephony principles
• Know VoIP principles
• Install security systems
• Maintain security systems
• Use home control systems
• Use home management systems
• Apply troubleshooting methodology
• Create documentation

What you'll be able to do

• Describe the installation procedure for Linux
• Manage Linux based clients effectively
• Configure system settings, network services and access rights appropriately
• Implement security options effectively
• Complete documentation accurately
• Describe the hardware that relates to typical Linux client and server systems

What you'll be able to do

• Understand Network Technologies
• Understand Network Media and Topologies
• Understand Network Devices
• Understand Network Management
• Understand Network Tools
• Understand Network Security

What you'll be able to do

• Understand media and topologies
• Understand Protocols and Standards
• Understand Network Implementation
• Carry out network support

What you'll be able to do

• Understand general security concepts relating to information technology systems
• Recognise and understand communication security protocols and methods
• Understand and differentiate infrastructure security components and configurations
• Understand and apply the basics of cryptography in securing data
• Understand and apply the basics of cryptography in securing data
• Understand operational and organisational security policies and procedures

What you'll be able to do

• Understand systems security principles
• Understand network infrastructure components and security considerations
• Understand access control methods and technologies
• Understand security assessments and audits
• Understand cryptography principles and applications
• Understand organisational security policies and procedures

What you'll be able to do

• Know general server hardware
• Install a server
• Configure a server
• Upgrade a server
• Proactively maintain a server
• Protect the server environment
• Troubleshoot Server Problems
• Identify Server Problems
• Know the disaster recovery plan

What you'll be able to do

• Understand system hardware components and their functions
• Understand software installation, configuration, and management
• Understand storage technologies and their implementation
• Understand the IT environment and its impact on server operations
• Understand disaster recovery planning and implementation
• Understand troubleshooting methodologies for server-related issues

What you'll be able to do

• Understand computer storage systems
• Understand computer software systems
• Know the methods used to secure computer systems
• Understand the statutory requirements of computer forensic investigation
• Understand the regulatory requirements of computer forensic investigation
• Know the software tools required to carry out a computer forensic investigation

What you'll be able to do

• Know the principles of digital storage devices
• Know the physical Topologies relevant to computer networks
• Know the logical Topologies relevant to computer networks
• Know the Systems relevant to computer networks
• Understand how to use software tools to investigate digital storage devices
• Carry out imaging of a storage device

What you'll be able to do

• Deploy client agents and policies using Microsoft Forefront Client and Server
• Configure server products within the Microsoft Forefront Client and Server environment
• Maintain the infrastructure of the Microsoft Forefront Client and Server environment
• Monitor protection status and activity within the Microsoft Forefront Client and Server environment

What you'll be able to do

• Configure Group Policy Objects (GPOs) by Using Advanced Group Policy Management (AGPM)
• Monitor desktops by Using Microsoft Desktop Error Monitoring (DEM)
• Manage software inventory by Using the Asset Inventory Service (AIS)
• Repair computer systems by Using the Diagnostics and Recovery Toolset (DaRT)
• Diagnose computer systems by Using the Diagnostics and Recovery Toolset (DaRT)
• Configure Application Virtualization Servers
• Configure Application Virtualization Clients
• Deploy the Application Virtualization Sequencer
• Manage the Application Virtualization Sequencer

What you'll be able to do

• Plan and install ISA Server 2006, considering network topology and security requirements
• Install and configure client computers to work with ISA Server 2006, ensuring proper authentication and access control
• Configure and manage ISA Server 2006, including its firewall rules, web filters, and intrusion detection system
• Configure web caching in ISA Server 2006 to improve web performance and reduce bandwidth consumption
• Configure firewall policy in ISA Server 2006 to protect the network from external threats
• Configure and manage remote network connectivity in ISA Server 2006, allowing remote users to securely access the network

What you'll be able to do

• Install and manage Office Communications Server (Communications Server) 2007 R2, including server roles and features
• Deploy and configure Communications Server 2007 R2 clients, ensuring proper connectivity and functionality
• Configure conferencing features in Communications Server 2007 R2, including audio, video, and web conferencing
• Configure enterprise voice functionality in Communications Server 2007 R2, enabling VoIP and PBX integration
• Configure external connectivity in Communications Server 2007 R2, allowing users to communicate with external contacts
• Monitor and maintain Communications Server 2007 R2, ensuring its performance, security, and availability

What you'll be able to do

• Configure Microsoft SQL Server 2005 for Project Server 2007
• Configure Analysis Services 2005 for Project Server 2007
• Configure Microsoft SharePoint for Project Server 2007
• Deploy Project Server
• Administer Project Web Access

What you'll be able to do

• Configure Microsoft Office SharePoint Server 2007
• Manage Search functionality within Microsoft Office SharePoint Server 2007
• Configure Content Management features in Microsoft Office SharePoint Server 2007
• Configure Business Forms using Microsoft Office SharePoint Server 2007
• Manage Business Intelligence tools within Microsoft Office SharePoint Server 2007
• Manage the Administration of Microsoft Office SharePoint Server 2007
• Deploy or Upgrade Microsoft Office SharePoint Server 2007

What you'll be able to do

• Deploy a System Center Configuration Manager 2007 (SCCM) Server
• Configure an SCCM Infrastructure
• Manage Resources using SCCM
• Distribute Applications using SCCM
• Deploy Operating Systems using SCCM
• Secure a Network Infrastructure using SCCM
• Manage an SCCM Infrastructure
• Maintain an SCCM Infrastructure

What you'll be able to do

• Configure System Center Operations Manager 2007 to meet specific monitoring requirements.
• Deploy and configure Management Packs to monitor specific applications and services.
• Build and deploy custom Management Packs to address unique monitoring needs.
• Maintain System Center Operations Manager to ensure its continued functionality and effectiveness.
• Configure Client Monitoring to gather data from client computers.

What you'll be able to do

• Install and upgrade Windows Vista correctly
• Configure and troubleshoot post-installation system settings effectively
• Configure Windows security features appropriately
• Configure network connectivity efficiently
• Configure applications included with Windows Vista correctly
• Maintain and optimise systems that run Windows Vista effectively
• Configure and troubleshoot mobile computing issues

What you'll be able to do

• Prepare a system for the deployment of Windows Essential Business Server
• Install and configure Windows Essential Business Server according to best practise
• Manage Windows Essential Business Server, including user accounts and security settings
• Configure remote access to Windows Essential Business Server for authorised users

What you'll be able to do

• Configure Domain Name System (DNS) for Active Directory to ensure proper name resolution
• Configure the Active Directory infrastructure, including domains, forests, and trusts
• Configure additional Active Directory server roles to provide specific services
• Create and maintain Active Directory objects, such as users, groups, and computers
• Maintain the Active Directory environment to ensure its stability and performance
• Configure Active Directory Certificate Services for secure authentication and encryption

What you'll be able to do

• Deploy servers within a Windows Server 2008 environment
• Configure Terminal Services within a Windows Server 2008 environment
• Configure a Web Services Infrastructure within a Windows Server 2008 environment
• Configure Network Application Services within a Windows Server 2008 environment

What you'll be able to do

• Configure IP Addressing and Services within a Windows Server 2008 network infrastructure
• Configure Name Resolution within a Windows Server 2008 network infrastructure
• Configure Network Access within a Windows Server 2008 network infrastructure
• Configure File and Print Services within a Windows Server 2008 network infrastructure
• Monitor and Manage a Windows Server 2008 Network Infrastructure

What you'll be able to do

• Install Hyper-V to enable virtualisation capabilities
• Configure and optimise Hyper-V to maximise performance and resource utilisation
• Deploy virtual machines to create isolated environments for applications and services
• Manage and monitor virtual machines to ensure availability and performance

What you'll be able to do

• Deploy Windows SharePoint Services 3.0 (WSS)
• Monitor the performance of Windows SharePoint Services
• Configure security settings for Windows SharePoint Services
• Administer Windows SharePoint Services effectively
• Manage customisation options within Windows SharePoint Services
• Configure the network infrastructure to support Windows SharePoint Services

What you'll be able to do

• Deploy Hardware for Small Business Server (SBS) Servers
• Deploy Software for Small Business Server (SBS) Servers
• Migrate to SBS 2008
• Deploy Hardware for Computers on the Network
• Deploy Software for Computers on the Network
• Maintain Systems Availability
• Maintain Services Availability
• Maintain Remote Access
• Maintain Users
• Maintain Computers
• Maintain Collaboration
• Maintain Messaging

What you'll be able to do

• Plan a hosted environment that meets specific requirements
• Deploy a core hosting infrastructure to support hosted services
• Deploy and configure IIS to serve web content
• Deploy hosted services to provide functionality to users
• Design and configure automated provisioning to streamline service deployment
• Administer, manage, and optimise hosted solutions to ensure optimal performance
• Troubleshoot a hosted environment to resolve issues and maintain uptime

What you'll be able to do

• Analyse different customer types and their specific requirements
• Effectively manage customer expectations in various situations
• Research and identify the varying workplace cultures that exist within organisations
• Apply appropriate communication techniques to interact effectively with customers

What you'll be able to do

• Manipulate real numbers and integers within IT applications
• Use co-ordinate systems and vectors in IT contexts
• Apply linear transformations within IT systems
• Use simple functions in IT applications
• Apply basic algebraic operations to solve IT-related problems
• Apply Boolean algebra to analyse and solve problem situations in IT

What you'll be able to do

• Plan Microsoft Exchange Server 2007 upgrades and migrations, considering all relevant factors.
• Plan for High Availability implementation to ensure continuous messaging service.
• Plan the Exchange Topology Deployment to meet organisational needs.
• Plan Messaging Security and Compliance implementation to protect sensitive data.
• Plan for Messaging Environment Maintenance to ensure optimal performance and reliability.

What you'll be able to do

• Deploy the 2007 Microsoft Office System to client desktops.
• Configure Windows Vista automated installation settings for efficient deployment.
• Deploy Windows Vista operating system to client desktops.
• Use Business Desktop Deployment (BDD) Workbench to manage desktop deployments.
• Use the Application Compatibility Toolkit to resolve application compatibility issues.
• Manage user state migration during operating system deployments.

What you'll be able to do

• Design a database strategy that aligns with business objectives
• Design database tables to efficiently store and manage data
• Design programming objects to enhance database functionality
• Design a transaction and concurrency strategy to ensure data integrity
• Design an XML strategy for data exchange and storage
• Design queries for performance to optimise data retrieval
• Design a database for optimal performance to ensure efficiency and scalability

What you'll be able to do

• Design database testing procedures using Microsoft SQL Server 2005
• Design code management procedures using Microsoft SQL Server 2005
• Design an application solution for SQL Server 2005
• Design database objects using Microsoft SQL Server 2005
• Design a database using Microsoft SQL Server 2005
• Develop applications that use SQL Server support services

What you'll be able to do

• Design and plan messaging services using Microsoft Exchange Server 2007 to meet organisational needs
• Design and plan server high availability solutions for Microsoft Exchange Server 2007 to ensure business continuity
• Design and plan coexistence and migration strategies for Microsoft Exchange Server 2007 environments
• Define policies and security procedures for Microsoft Exchange Server 2007 messaging systems to protect data and maintain compliance

What you'll be able to do

• Create the Conceptual Design for Network Infrastructure Security by Gathering and Analysing Business and Technical Requirements
• Create the Logical Design for Network Infrastructure Security
• Create the Physical Design for Network Infrastructure Security
• Design an Access Control Strategy for Data
• Create the Physical Design for Client Infrastructure Security

What you'll be able to do

• Design reports for a business intelligence infrastructure using Microsoft SQL Server 2008
• Manage reports within a business intelligence infrastructure using Microsoft SQL Server 2008
• Design data mining models for a business intelligence infrastructure using Microsoft SQL Server 2008
• Administer a business intelligence (BI) solution using Microsoft SQL Server 2008
• Design the business intelligence architecture using Microsoft SQL Server 2008
• Design SQL Server Integration Services (SSIS) packages
• Deploy SQL Server Integration Services (SSIS) packages
• Design an Analysis Services database

What you'll be able to do

• Plan BI Solutions
• Design SSRS Solutions
• Design SSAS Solutions
• Maintain and Optimise SSAS Solutions
• Maintain SSAS solutions by using either online or offline methods

What you'll be able to do

• Design a database server infrastructure
• Design security for a database server solution
• Design a physical database
• Design a database solution for high availability
• Design a data recovery solution for a database
• Design a strategy for data archiving

What you'll be able to do

• Create the conceptual design by gathering business requirements
• Create the conceptual design by analysing business requirements
• Create the conceptual design by gathering technical requirements
• Create the conceptual design by analysing technical requirements
• Create the logical design for an Active Directory infrastructure
• Create the logical design for a network services infrastructure
• Create the physical design for an Active Directory infrastructure
• Create the physical design for a network infrastructure

What you'll be able to do

• Envisage and design an enterprise application using the Microsoft .NET Framework 3.5
• Design and develop an application framework using the Microsoft .NET Framework 3.5
• Design application components using the Microsoft .NET Framework 3.5
• Stabilise and test an application developed using the Microsoft .NET Framework 3.5
• Migrate, deploy, and maintain an application developed using the Microsoft .NET Framework 3.5

What you'll be able to do

• Envision an application
• Design an application
• Design a component
• Develop a component
• Design an application framework
• Develop an application framework
• Test an application
• Stabilise an application
• Deploy an application
• Support an application

What you'll be able to do

• Envision an application using the Microsoft .NET Framework
• Design an application using the Microsoft .NET Framework
• Design and develop a user interface using the Microsoft .NET Framework
• Design and develop a component using the Microsoft .NET Framework
• Design and develop an application framework using the Microsoft .NET Framework
• Test an application developed using the Microsoft .NET Framework
• Stabilise an application developed using the Microsoft .NET Framework
• Deploy an application developed using the Microsoft .NET Framework
• Support an application developed using the Microsoft .NET Framework

What you'll be able to do

• Validate an application design against specifications
• Plan data management
• Plan user interaction and presentation strategy
• Design security implementation
• Plan application deployment and maintenance
• Design the application architecture
• Design for optimised performance

What you'll be able to do

• Envision and design an application based on specified requirements and user needs.
• Design and develop a user interface that is intuitive and user-friendly.
• Design and develop a component that performs a specific function within the application.
• Design and develop an application framework to provide a foundation for the application.
• Test and stabilise an application to ensure it meets quality standards.
• Deploy and support an application to ensure its successful implementation and ongoing operation.

What you'll be able to do

• Design efficient methods for accessing data within a Microsoft SQL Server 2005 service
• Design a database query strategy to optimise data retrieval from a Microsoft SQL Server 2005 database
• Design error-handling routines to manage exceptions and errors during data access operations in Microsoft SQL Server 2005
• Design a transaction strategy to ensure data integrity and consistency in Microsoft SQL Server 2005
• Carry out performance tuning of a database and a database application interacting with Microsoft SQL Server 2005 to improve efficiency

What you'll be able to do

• Analyse the existing IT environment of a small- or medium-sized business to identify needs and challenges
• Design a business technology solution for a small- or medium-sized business, considering its specific requirements and budget
• Install and configure Windows Small Business Server 2003, including its core components and services
• Support and maintain Windows Small Business Server 2003, ensuring its stability and security
• Expand the Windows Small Business Server 2003 network by adding new users, devices, and services
• Install and configure Windows Server 2003 in conjunction with Windows Small Business Server 2003 to provide additional functionality

What you'll be able to do

• Configure Provisioning for mobile devices, including setting up automatic configuration and deployment processes.
• Manage Devices by Using Exchange Server, including configuring policies, managing security settings, and tracking device usage.
• Configure a Messaging Infrastructure for mobile devices, including email, SMS, and instant messaging.
• Design a Mobile Infrastructure, including planning network connectivity, security measures, and device management strategies.
• Configure Network Connectivity for mobile devices, including Wi-Fi, cellular data, and VPN connections.
• Manage Mobile Applications, including deploying, updating, and securing applications on mobile devices.
• Implement Security for Mobile Devices, including password policies, encryption, and remote wipe capabilities.

What you'll be able to do

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

What you'll be able to do

• Plan a BizTalk application, taking into account business requirements and technical constraints
• Develop and debug an integration application using Microsoft BizTalk Server
• Develop and debug a business process application using Microsoft BizTalk Server
• Implement business rules within a BizTalk application to automate decision-making
• Enable business activity monitoring to track and analyse the performance of BizTalk applications
• Deploy a BizTalk application to a production environment, ensuring its stability and scalability

What you'll be able to do

• Identify and describe the hardware components and functionality of an ICT system, including processors, memory, storage, and peripherals.
• Plan the installation of an ICT system, taking into account factors such as power requirements, space constraints, and network connectivity.
• Carry out the planned installation of hardware components, following safety procedures and manufacturer's instructions.

What you'll be able to do

• Understand the different hardware components of an ICT system and their functionality
• Develop a detailed plan for the installation of hardware components, providing justification for the chosen approach
• Carry out the installation of hardware components according to the developed plan
• Evaluate the completed hardware installation, identifying any issues and suggesting improvements

What you'll be able to do

• Manage SQL Server Analysis Services (SSAS) instances, including configuration, security, and performance tuning.
• Develop SSAS Solutions by Using Business Intelligence Development Services (BIDS), including creating cubes, dimensions, and measures.
• Implement Data Mining by Using BIDS, including selecting appropriate algorithms and evaluating results.
• Manage SQL Server Reporting Services (SSRS) instances, including configuration, security, and report deployment.
• Develop Reporting Solutions by Using SSRS, including creating reports, dashboards, and data visualisations.
• Develop Business Intelligence Solutions by Using SQL Server Integration Services (SSIS), including creating packages, tasks, and data flows.
• Create event handlers within SSIS packages to manage errors and exceptions.
• Administer SSIS Packages, including scheduling, monitoring, and troubleshooting.

What you'll be able to do

• Plan and Install Microsoft Internet Security and Acceleration (ISA) Server 2004
• Install and Configure Client Computers to work with ISA Server 2004
• Configure and Manage Microsoft Internet Security and Acceleration (ISA) Server 2004
• Configure Web Caching within ISA Server 2004
• Configure Firewall Policy within ISA Server 2004
• Configure and Manage Remote Network Connectivity using ISA Server 2004
• Monitor and Report on ISA Server 2004 Activity

What you'll be able to do

• Implement tables and views within a Microsoft SQL Server 2008 database
• Implement programming objects, such as stored procedures and functions, within a Microsoft SQL Server 2008 database
• Work with query fundamentals to retrieve and manipulate data
• Apply additional query techniques to optimise data retrieval and manipulation
• Work with additional SQL Server components to enhance database functionality
• Work with XML data within a Microsoft SQL Server 2008 database
• Gather performance information to optimise database performance

What you'll be able to do

• Implement security policies within a Microsoft Windows Server 2003 network environment
• Manage security policies within a Microsoft Windows Server 2003 network environment
• Troubleshoot security policies within a Microsoft Windows Server 2003 network environment
• Implement a patch management infrastructure within a Microsoft Windows Server 2003 network environment
• Manage a patch management infrastructure within a Microsoft Windows Server 2003 network environment
• Troubleshoot a patch management infrastructure within a Microsoft Windows Server 2003 network environment
• Implement security measures for network communications within a Microsoft Windows Server 2003 network environment
• Manage security measures for network communications within a Microsoft Windows Server 2003 network environment
• Troubleshoot security measures for network communications within a Microsoft Windows Server 2003 network environment
• Plan authentication, authorisation, and Public Key Infrastructure (PKI) within a Microsoft Windows Server 2003 network environment
• Configure authentication, authorisation, and Public Key Infrastructure (PKI) within a Microsoft Windows Server 2003 network environment
• Troubleshoot authentication, authorisation, and Public Key Infrastructure (PKI) within a Microsoft Windows Server 2003 network environment

What you'll be able to do

• Install and configure Microsoft SQL Server 2008 according to specified requirements
• Maintain SQL Server instances to ensure their ongoing stability and performance
• Manage SQL Server security to protect data and prevent unauthorised access
• Maintain a SQL Server database, including tasks such as backups and recovery
• Perform data management tasks within SQL Server, such as importing, exporting, and transforming data
• Monitor and troubleshoot SQL Server to identify and resolve performance issues
• Optimise SQL Server performance to ensure efficient data processing
• Implement high availability solutions for SQL Server to minimise downtime

What you'll be able to do

• Install Exchange Server 2003
• Configure Exchange Server 2003
• Troubleshoot Exchange Server 2003
• Manage Exchange Server computers
• Monitor Exchange Server computers
• Troubleshoot Exchange Server computers
• Manage the Exchange organisation
• Monitor the Exchange organisation
• Troubleshoot the Exchange organisation
• Manage security in the Exchange environment
• Manage technologies that support Exchange Server 2003
• Monitor technologies that support Exchange Server 2003

What you'll be able to do

• Implement, manage and maintain IP addressing within a Windows Server 2003 network infrastructure.
• Implement, manage, and maintain name resolution services within a Windows Server 2003 network infrastructure.
• Implement, manage, and maintain network security measures within a Windows Server 2003 network infrastructure.
• Implement, manage, and maintain routing and remote access services within a Windows Server 2003 network infrastructure.
• Maintain a network infrastructure to ensure optimal performance and reliability.

What you'll be able to do

• Prepare the Infrastructure to Deploy Live Communications Server 2005, including hardware, software, and network requirements.
• Install Live Communications Server 2005, including configuring server settings and integrating with existing infrastructure.
• Implement Remote User Access and Federation, including configuring access for remote users and integrating with other communication systems.
• Manage a Live Communication Server Infrastructure, including monitoring server performance, troubleshooting issues, and managing user accounts.
• Configure Microsoft Office Communicator 2005, including user settings, communication preferences, and integration with other applications.

What you'll be able to do

• Understand the principles of information management within an IT environment
• Understand the requirements for supporting the management of information in the IT environment
• Apply the principles of information management in a practical IT environment
• Carry out their defined role and responsibilities in the information management area

What you'll be able to do

• Understand the principles of information management within an IT environment
• Understand the requirements for supporting the management of information in the IT environment
• Apply the principles of information management in the IT environment to identified tasks
• Understand individual responsibility for the security and integrity of information assets

What you'll be able to do

• Install Windows 2000 Professional operating system.
• Implement and conduct administration of resources within Windows 2000 Professional.
• Implement, manage, and troubleshoot hardware devices and drivers within Windows 2000 Professional.
• Monitor and optimise system performance and reliability within Windows 2000 Professional.
• Configure and troubleshoot the desktop environment within Windows 2000 Professional.
• Implement, manage, and troubleshoot network protocols and services within Windows 2000 Professional.
• Implement, monitor, and troubleshoot security within Windows 2000 Professional.

What you'll be able to do

• Install Windows XP Professional according to best practices
• Implement and conduct administration of resources within Windows XP Professional
• Implement, manage, monitor, and troubleshoot hardware devices and drivers within Windows XP Professional
• Monitor and optimise system performance and reliability of Windows XP Professional
• Configure and troubleshoot the desktop environment within Windows XP Professional
• Implement, manage, and troubleshoot network protocols and services within Windows XP Professional
• Configure, manage and troubleshoot security settings within Windows XP Professional

What you'll be able to do

• Install ISA Server
• Configure ISA Server Services
• Troubleshoot ISA Server Services
• Configure Policies and Rules within ISA Server
• Manage Policies and Rules within ISA Server
• Troubleshoot Policies and Rules within ISA Server
• Deploy the Client Computer for ISA Server
• Configure the Client Computer for ISA Server
• Troubleshoot the Client Computer for ISA Server
• Monitor ISA Server Use
• Manage ISA Server Use
• Analyse ISA Server Use

What you'll be able to do

• Install and configure SQL Server 2000
• Create SQL Server 2000 Databases
• Manage SQL Server 2000 Databases
• Monitor SQL Server 2000 Databases
• Troubleshoot SQL Server 2000 Databases
• Extract and transform data with SQL Server 2000
• Manage SQL Server 2000 Security
• Monitor SQL Server 2000 Security
• Manage SQL Server 2000
• Monitor SQL Server 2000
• Troubleshoot SQL Server 2000

What you'll be able to do

• Know the main technologies used in Cisco networks, including their functions and applications.
• Plan and design simple networks using Cisco technology, considering factors such as scalability and security.
• Implement and operate simple networks using Cisco devices and configurations.
• Troubleshoot simple networks to identify and resolve common issues.

What you'll be able to do

• Know the main features of IT networks related to Cisco technology.
• Provide basic support to simple Cisco networks.
• Implement and operate simple Cisco networks.

What you'll be able to do

• Develop applications that use system types and collections to manage data
• Trace, configure, and deploy applications to ensure proper functionality
• Customise and personalize a web application to meet user preferences
• Implement authentication and authorisation to secure web applications
• Create ASP.NET mobile web applications for mobile devices
• Envision and design an application to meet specific requirements
• Design and develop a user interface to provide a user-friendly experience
• Design and develop a component to encapsulate functionality
• Design and develop an application framework to provide a foundation for applications
• Test and stabilise an application to ensure quality and reliability
• Deploy and support an application to make it available to users
• Embed configuration, diagnostic, management, and installation features into a .NET Framework application to simplify administration
• Implement serialization and input/output functionality in a .NET Framework application to manage data
• Improve the security of .NET Framework applications by using the .NET Framework 2.0 security features to protect against threats
• Implement interoperability, reflection, and mailing functionality in a .NET Framework application to integrate with other systems
• Implement globalization, drawing, and text manipulation functionality in a .NET Framework application to support different languages and cultures
• Create and program a web application to provide web-based functionality
• Integrate data in a web application by using ADO.NET, XML, and data-bound controls to access and display data
• Create custom web controls to extend the functionality of web applications

What you'll be able to do

• Develop applications that use system types and collections
• Implement Asynchronous Programming Techniques to Improve the User Experience
• Configure and Deploy Applications
• Envision and Design an Application
• Design and Develop a User Interface
• Design and Develop a Component
• Design and Develop an Application Framework
• Test and Stabilise an Application
• Deploy and Support an Application
• Embed configuration, diagnostic, management, and installation features into a .NET Framework application
• Implement serialisation and input/output functionality in a .NET Framework application
• Improve the security of .NET Framework applications by using the .NET Framework 2.0 security features
• Implement interoperability, reflection, and mailing functionality in a .NET Framework application
• Implement globalisation, drawing, and text manipulation functionality in a .NET Framework application
• Create a UI for a Windows Forms Application by Using Standard Controls
• Integrate Data in a Windows Forms Application
• Enhance Usability

What you'll be able to do

• Develop applications that use system types and collections
• Trace, configure, and deploy applications
• Customise and personalise a web application
• Implement authentication and authorisation
• Create ASP.NET mobile web applications
• Embed configuration, diagnostic, management, and installation features into a .NET Framework application
• Implement serialization and input/output functionality in a .NET Framework application
• Improve the security of .NET Framework applications by using the .NET Framework 2.0 security features
• Implement interoperability, reflection, and mailing functionality in a .NET Framework application
• Implement globalisation, drawing, and text manipulation functionality in a .NET Framework application
• Create and programme a web application
• Integrate data in a web application by using ADO.NET, XML, and data-bound controls
• Create custom web controls

What you'll be able to do

• Develop applications that use system types and collections
• Implement asynchronous programming techniques to improve the user experience
• Configure and deploy applications
• Embed configuration, diagnostic, management, and installation features into a .NET Framework application
• Implement serialization and input/output functionality in a .NET Framework application
• Improve the security of .NET Framework applications by using the .NET Framework 2.0 security features
• Implement interoperability, reflection, and mailing functionality in a .NET Framework application
• Implement globalisation, drawing, and text manipulation functionality in a .NET Framework application
• Create a UI for a Windows Forms Application by using standard controls
• Integrate data in a Windows Forms Application
• Enhance usability

What you'll be able to do

• Install a Windows Desktop Operating System
• Manage access to resources on a Windows Desktop Operating System
• Troubleshoot access to resources on a Windows Desktop Operating System
• Configure hardware devices and drivers on a Windows Desktop Operating System
• Troubleshoot hardware devices and drivers on a Windows Desktop Operating System
• Configure the desktop environment on a Windows Desktop Operating System
• Configure the user environment on a Windows Desktop Operating System
• Troubleshoot the desktop environment on a Windows Desktop Operating System
• Troubleshoot the user environment on a Windows Desktop Operating System

What you'll be able to do

• Configure applications on a Microsoft Windows XP operating system
• Troubleshoot applications on a Microsoft Windows XP operating system
• Resolve issues related to application usability on a Microsoft Windows XP operating system
• Resolve issues related to application customisation on a Microsoft Windows XP operating system
• Configure connectivity for applications on a Microsoft Windows XP operating system
• Troubleshoot connectivity for applications on a Microsoft Windows XP operating system
• Configure application security on a Microsoft Windows XP operating system

What you'll be able to do

• Understand routine preventative maintenance procedures for equipment components and sub-assemblies.
• Understand routine remedial maintenance procedures for equipment components and sub-assemblies.
• Understand health and safety procedures when carrying out routine maintenance.
• Understand health and safety procedures when carrying out remedial maintenance.
• Diagnose component faults for identified tasks.
• Locate component faults for identified tasks.
• Repair component faults for identified tasks.

What you'll be able to do

• Perform routine preventative maintenance procedures for equipment components and sub-assemblies
• Perform routine remedial maintenance procedures for equipment components and sub-assemblies
• Comply with health and safety procedures for carrying out routine maintenance
• Comply with health and safety procedures for carrying out remedial maintenance
• Diagnose component faults for identified tasks
• Locate component faults for identified tasks
• Repair component faults for identified tasks

What you'll be able to do

• Plan and manage own workload effectively to meet deadlines
• Identify opportunities for professional development to enhance skills and knowledge
• Understand the implications of relevant legislation and regulations on assigned tasks

What you'll be able to do

• Manage physical devices
• Maintain physical devices
• Manage logical devices
• Maintain logical devices
• Manage users
• Manage computers
• Manage groups
• Manage access to resources
• Maintain access to resources
• Manage a server environment
• Maintain a server environment
• Manage and implement disaster recovery

What you'll be able to do

• Develop applications that use system types and collections within the .NET Framework.
• Implement service processes, threading, and application domains in a .NET Framework application.
• Embed configuration, diagnostic, management, and installation features into a .NET Framework application.
• Implement serialization and input/output functionality in a .NET Framework application.
• Improve the security of .NET Framework applications by using the .NET Framework security features.
• Implement interoperability, reflection, and mailing functionality in a .NET Framework application.
• Implement globalization, drawing, and text manipulation functionality in a .NET Framework application.

What you'll be able to do

• Create and access XML Web Services within the Microsoft .NET Framework 2.0.
• Configure and customise a Web Service application to meet specific requirements.
• Create, configure, and deploy remoting applications using the Microsoft .NET Framework 2.0.
• Implement asynchronous calls and remoting events within a distributed application.
• Implement Web Services Enhancements (WSE) 3.0 to improve web service capabilities.
• Create and access a serviced component and utilise message queuing within the Microsoft .NET Framework 2.0.

What you'll be able to do

• Create and program a Web application using appropriate technologies and frameworks to meet specified requirements
• Integrate data in a Web application by using ADO.NET, XML, and data-bound controls, ensuring data is accessible and properly displayed
• Create custom Web controls to extend the functionality and appearance of the Web application
• Trace, configure, and deploy Web applications, ensuring they are properly installed and run on target servers
• Customise and personalise a Web application to meet individual user preferences and needs
• Implement authentication and authorisation mechanisms to secure the Web application and protect sensitive data
• Create ASP.NET mobile Web applications that are optimised for viewing on mobile devices

What you'll be able to do

• Create a user interface for a Windows Forms application by using standard controls from the .NET Framework 2.0
• Integrate data into a Windows Forms application using appropriate data access techniques
• Implement printing and report functionality within a Windows Forms application
• Enhance the usability of a Windows Forms application through effective design and user interaction
• Implement asynchronous programming techniques to improve the user experience in a Windows Forms application
• Develop custom Windows Forms controls to extend the functionality of the user interface
• Configure and deploy Windows Forms applications to end-users

What you'll be able to do

• Create Services using Microsoft .NET Framework 3.5 – Windows Communication Foundation
• Expose and Deploy Services using Microsoft .NET Framework 3.5 – Windows Communication Foundation
• Instrument and Administer Services using Microsoft .NET Framework 3.5 – Windows Communication Foundation
• Consume Services using Microsoft .NET Framework 3.5 – Windows Communication Foundation
• Secure Services using Microsoft .NET Framework 3.5 – Windows Communication Foundation
• Manage the Service Life Cycle using Microsoft .NET Framework 3.5 – Windows Communication Foundation

What you'll be able to do

• Create a Windows Presentation Foundation (WPF) application
• Build user interfaces using WPF tools and techniques
• Add and manage content within a WPF application
• Bind WPF elements to data sources for dynamic content display
• Customise the appearance of WPF applications to meet design specifications
• Configure and deploy WPF applications for distribution and use

What you'll be able to do

• Create and host workflows using the Microsoft .NET Framework 3.5 – Windows Workflow Foundation
• Communicate with workflows to exchange data and control execution
• Create and configure custom activities to extend workflow functionality
• Apply rules and conditions to control workflow execution paths
• Manage transactions and compensations within workflows to ensure data integrity
• Create and manage runtime services to support workflow execution

What you'll be able to do

• Connect to data sources using appropriate methods and technologies
• Select and query data from various data sources effectively
• Modify data within data sources, ensuring data integrity
• Synchronise data between different data sources to maintain consistency
• Work with disconnected data, enabling offline access and data manipulation
• Perform object relational mapping by using the Entity Framework to interact with databases

What you'll be able to do

• Configure web applications
• Deploy web applications
• Consume server controls
• Create server controls
• Work with data
• Work with services
• Troubleshoot web applications
• Debug web applications
• Work with ASP.NET AJAX
• Work with client-side scripting
• Target mobile devices
• Programme web applications

What you'll be able to do

• Create a User Interface (UI) for a Windows Forms Application by using standard controls to meet specified design requirements
• Integrate data from various sources into a Windows Forms Application, ensuring data integrity and accessibility
• Implement printing and report functionality within a Windows Forms Application, enabling users to generate hard copies and summaries of data
• Enhance the usability of a Windows Forms Application through intuitive design, clear navigation, and user-friendly features
• Implement asynchronous programming techniques to improve the user experience by preventing the application from freezing during long-running operations
• Develop custom Windows Forms controls to extend the functionality and appearance of the application
• Configure and deploy Windows Forms Applications, ensuring they are properly installed and run on target systems

What you'll be able to do

• Manage Groove Workspaces, including creating, configuring, and administering workspaces for collaboration.
• Maintain Groove Accounts, including user account management, permissions, and security settings.
• Manage the Groove Domain, including domain configuration, policies, and security settings.
• Install Groove Servers, including planning, configuring, and deploying Groove servers.
• Administer Groove Servers, including monitoring server performance, troubleshooting issues, and managing server resources.
• Deploy the Groove Client, including planning, configuring, and deploying the Groove client software to users.
• Interpret Groove Communications, including understanding and analysing communication logs and data within the Groove environment.

What you'll be able to do

• Configure Dimensions within Microsoft Office PerformancePoint Server 2007
• Configure Models within Microsoft Office PerformancePoint Server 2007
• Configure Business Roles and Process Management within Microsoft Office PerformancePoint Server 2007
• Develop Business Rules within Microsoft Office PerformancePoint Server 2007
• Build Microsoft Office Excel Add-In Forms and Reports using PerformancePoint Server 2007
• Develop Dashboards using Microsoft Office PerformancePoint Server 2007
• Install PerformancePoint Server

What you'll be able to do

• Configure Tools and Options within Microsoft Office Project 2007
• Set Up a Project within Microsoft Office Project 2007
• Estimate, Schedule, and Budget Tasks within Microsoft Office Project 2007
• Resource Project Plans within Microsoft Office Project 2007
• Update and Report on Project Performance using Microsoft Office Project 2007

What you'll be able to do

• Initiate projects effectively using Microsoft Office Project Server 2007.
• Plan projects comprehensively within the Microsoft Office Project Server 2007 environment.
• Execute projects according to the project plan using Microsoft Office Project Server 2007.
• Monitor and control projects, tracking progress and managing issues within Microsoft Office Project Server 2007.
• Manage Project Professional and PWA (Project Web Access) environments to support project management activities.

What you'll be able to do

• Manage enterprise content effectively within Microsoft Office SharePoint Server 2007
• Audit Windows SharePoint Services content by using a custom policy to ensure compliance
• Create business intelligence solutions by using Office SharePoint Server 2007 to support decision-making
• Integrate business data with Office SharePoint Server 2007 by using the Business Data Catalog (BDC) to provide a unified view of information
• Access Office SharePoint Server 2007 Application Platform Services to extend functionality
• Search data effectively by using the Search Service within Office SharePoint Server 2007
• Target content based on audience membership to deliver personalised experiences
• Customise functionality by using profiles to tailor the user experience

What you'll be able to do

• Deploy Visio solutions effectively within a specified environment
• Work with external data sources to enhance Visio diagrams
• Develop Visio libraries for re-use in multiple diagrams
• Automate Visio diagrams using scripting or other automation techniques
• Publish and view Visio diagrams using appropriate methods

What you'll be able to do

• Install and configure SQL Server 2005 according to specified requirements
• Implement high availability and disaster recovery solutions for SQL Server 2005
• Support data consumers by providing access to SQL Server 2005 databases
• Maintain databases within SQL Server 2005 to ensure optimal performance and data integrity
• Monitor and troubleshoot SQL Server 2005 performance to identify and resolve issues
• Create and implement database objects within SQL Server 2005 to meet application requirements

What you'll be able to do

• Retrieve location solution data effectively
• Analyse location data accurately
• Display location solution data clearly
• Administer your location platform efficiently
• Manipulate the map effectively
• Create and customise the map display appropriately

What you'll be able to do

• Develop Mobile Applications by Using the Microsoft .NET Compact Framework 2.0
• Design a Windows Mobile User Interface
• Develop a Windows Mobile User Interface
• Integrate Data in a Windows Mobile-Based Application by Using File System
• Integrate Data in a Windows Mobile-Based Application by Using ADO.NET
• Integrate Data in a Windows Mobile-Based Application by Using XML
• Manage Data by Using Microsoft SQL Server 2005 Everywhere Edition
• Develop Communication capabilities in Windows Mobile-Based Applications
• Develop Connection capabilities in Windows Mobile-Based Applications
• Implement Interoperability features in Windows Mobile-Based Applications
• Implement Platform-Specific Features in Windows Mobile-Based Applications
• Optimise Windows Mobile Based Applications
• Package Windows Mobile Based Applications
• Deploy Windows Mobile Based Applications

What you'll be able to do

• Deploy Windows SharePoint Services and custom components
• Create site and feature provisioning components within Windows SharePoint Services
• Create metadata and workflow provisioning components within Windows SharePoint Services
• Develop Windows SharePoint Services components by using the .NET Framework

What you'll be able to do

• Understand physical topologies
• Understand logical topologies
• Understand physical systems
• Understand logical systems
• Understand the Open System Interconnection (OSI) model
• Understand the Internet Protocol Suite (TCP/IP)

What you'll be able to do

• Know the OSI model.
• Know the TCP/IP suite.
• Know different network topologies.
• Know different transmission systems.
• Know the advantages of different types of network.
• Know the disadvantages of different types of network.
• Know media access control methods used in local area networks.

What you'll be able to do

• Understand the context of database systems and data design within organisations
• Design an entity relationship diagram to represent data requirements
• Create a normalised data structure to optimise data storage and retrieval

What you'll be able to do

• Understand the purpose and application of different SQL functions within database management systems.
• Construct Data Manipulation Language (DML) statements to modify data within a database.
• Construct Data Definition Language (DDL) statements to define and manage the structure of a database.
• Construct data views to present data in a specific format or for specific users.
• Manage database integrity through constraints, validation rules, and transaction management.

What you'll be able to do

• Understand PL/SQL principles, including its syntax, data types, and control structures
• Construct PL/SQL code to perform various database operations
• Construct PL/SQL structures such as procedures, functions, triggers, and packages

What you'll be able to do

• Plan and manage workload effectively, prioritising tasks and meeting deadlines.
• Evaluate own performance and identify areas for improvement.
• Identify relevant Legislation and Regulations that affect your role within an organisation.

What you'll be able to do

• Plan and implement server roles within a Microsoft Windows Server 2003 network infrastructure.
• Plan and implement server security measures to protect the network from threats.
• Plan, implement, and maintain a network infrastructure using Microsoft Windows Server 2003.
• Plan, implement, and maintain routing and remote access services within the network.
• Plan, implement, and maintain server availability to ensure business continuity.
• Plan and maintain network security protocols and procedures.
• Plan, implement, and maintain a security infrastructure to protect sensitive data and resources.

What you'll be able to do

• Design and Plan the Systems Management Server (SMS) Environment
• Plan and Manage Feature Packs
• Configure an SMS Environment
• Manage and Maintain an SMS Environment
• Monitor and Troubleshoot SMS

What you'll be able to do

• Plan and implement an Active Directory Infrastructure, considering organisational requirements.
• Manage and maintain an Active Directory Infrastructure to ensure its stability and security.
• Plan and implement user, computer, and group strategies within Active Directory.
• Plan and implement Group Policy to manage user and computer settings.
• Manage and maintain Group Policy to ensure consistent application of settings.

What you'll be able to do

• Prepare the OEM Pre-Installation Kit (OPK) environment for pre-installing operating systems
• Create and modify configuration sets to customise the operating system installation
• Capture and audit images to ensure quality and compliance
• Deploy and test images to verify functionality and performance
• Perform image maintenance on existing images to address issues and apply updates

What you'll be able to do

• Identify and describe common types of threat to ICT systems and data, including malware, phishing, and social engineering.
• Describe methods to protect ICT systems, including firewalls, anti-virus software, and access controls.
• Explain the applications of cryptography to ICT systems and data, including encryption, digital signatures, and hashing.

What you'll be able to do

• Understand the common types of threats to ICT systems and data, including malware, phishing, and social engineering
• Understand how to protect ICT systems from threats through measures such as firewalls, antivirus software, and access controls
• Understand the applications of cryptography to ICT systems and data, including encryption, digital signatures, and hashing

What you'll be able to do

• Design and implement controls within an ASP.NET application
• Design the presentation and layout of an ASP.NET application
• Access data and services within an ASP.NET application
• Establish a robust ASP.NET solution structure
• Leverage and extend ASP.NET architecture
• Apply security principles when designing and developing ASP.NET applications

What you'll be able to do

• Understand the operational activities involved in managing service events
• Understand how to prepare for designated service operations activities under supervision
• Monitor the progress and completion of designated service operational activities effectively
• Understand organisational standards and procedures for service operations, ensuring alignment with professional, ethical, and legal standards

What you'll be able to do

• Understand the operational procedures for service events
• Identify relevant stakeholders for service events
• Plan service operation activities
• Implement service operation activities
• Maintain the service operation plan for the service operational activities
• Support future decisions for service operations from the analysis of historical information

What you'll be able to do

• Understand the principles of software design
• Apply the techniques of software design

What you'll be able to do

• Know about testing strategies.
• Know about testing techniques.
• Contribute to a test process for a software solution.

What you'll be able to do

• Understand different software testing strategies and techniques, including black box testing, white box testing, and unit testing
• Manage a test process for a software solution, including planning, execution, and reporting

What you'll be able to do

• Identify the existing products for an organisation.
• Identify the existing suppliers for an organisation.
• Understand how to develop agreements with partners and suppliers.
• Understand how to maintain agreements with partners and suppliers.
• Understand how to develop relationships with partners and suppliers.
• Understand how to maintain relationships with partners and suppliers.
• Understand the need to comply with organisation requirements.
• Understand the need to comply with regulatory requirements.
• Monitor preferred IT/Technology supplier performance.
• Review preferred IT/Technology supplier performance.

What you'll be able to do

• Know how existing procedures are applied in IT/technology supplier management activities
• Know how existing techniques are applied in IT/technology supplier management activities
• Understand how to develop agreements with IT/Technology partners and suppliers
• Understand how to maintain agreements with IT/Technology partners and suppliers
• Understand how to develop relationships with IT/Technology partners and suppliers
• Understand how to maintain relationships with IT/Technology partners and suppliers
• Understand the need to comply with organisational IT/technology requirements
• Understand the need to comply with regulatory IT/technology requirements
• Monitor preferred IT/Technology partner performance
• Review preferred IT/Technology partner performance
• Monitor preferred IT/Technology supplier performance
• Review preferred IT/Technology supplier performance

What you'll be able to do

• Install Windows Vista
• Upgrade Windows Vista
• Customise Windows Vista settings post-installation
• Configure Windows Vista settings post-installation
• Configure Windows Vista security
• Configure networking on Windows Vista
• Troubleshoot networking on Windows Vista
• Repair networking on Windows Vista
• Install devices on Windows Vista
• Configure devices on Windows Vista
• Troubleshoot devices on Windows Vista
• Repair devices on Windows Vista
• Troubleshoot Windows Vista
• Repair Windows Vista

What you'll be able to do

• Deploy Windows Vista on a client machine
• Manage Windows Vista security settings
• Maintain systems that run Windows Vista
• Configure networking on a Windows Vista client
• Troubleshoot networking issues on a Windows Vista client
• Support desktop applications running on Windows Vista
• Maintain desktop applications running on Windows Vista

What you'll be able to do

• Understand the representation of information within a computer
• Understand the way information is processed within a computer
• Use the operating environment of current computer systems
• Develop the operating environment of current computer systems
• Understand the communication process in distributed operating systems
• Understand the communication process in computer networks
• Understand distributed applications in mainframe systems
• Understand transaction processing in mainframe systems

What you'll be able to do

• Describe the representation of information within a computer system, including binary, hexadecimal, and other relevant formats.
• Explain the purpose and functions of an operating environment, and demonstrate its use for common tasks.
• Explain the communication processes involved in distributed operating systems and computer networks, including protocols and architectures.

What you'll be able to do

• Understand the representation of information within a computer
• Understand the way information is processed within a computer
• Make effective use of the operating environment of current computer systems
• Know the communication process in distributed operating systems
• Know the communication process in computer networks
• Know distributed applications in mainframe systems
• Know transaction processing in mainframe systems

What you'll be able to do

• Explain the principles of alternating current (AC) circuits, including voltage, current, resistance, and impedance.
• Describe the effects of line impairments on a transmitted signal, such as attenuation, distortion, and noise.
• Apply the characteristics of transmission lines, including impedance matching and signal propagation.
• Explain the transmission of digital signals over transmission media, including encoding and modulation techniques.
• Describe the process of modulating an analogue carrier frequency using digital signals, including various modulation schemes.
• Apply the process of multiplexing digital and analogue signals over transmission media, including time-division and frequency-division multiplexing.

What you'll be able to do

• Understand the electromagnetic spectrum as applied to telecommunications
• Know the relationship between telecommunication circuits and transmission lines and their effect on a digital signal
• Know how binary information is transmitted as a digital signal
• Understand how an analogue signal is converted to a digital signal
• Demonstrate an understanding of signal multiplexing

What you'll be able to do

• Implement an SQL Server Integration Services (SSIS) solution according to specified requirements
• Design the business intelligence (BI) architecture to meet organisational needs
• Design and deploy SSIS packages in line with best practise
• Design an Analysis Services database that fulfils business requirements
• Configure, deploy, and maintain SSIS to ensure optimal performance
• Implement an SQL Server Analysis Services (SSAS) solution that meets specified requirements
• Configure, deploy, and maintain SSAS to ensure optimal performance
• Implement an SQL Server Reporting Services (SSRS) solution that meets specified requirements
• Configure, deploy, and maintain SSRS to ensure optimal performance
• Design and manage reports to effectively present data
• Design data mining models to extract valuable insights
• Administer a business intelligence (BI) solution to ensure its smooth operation

What you'll be able to do

• Install and configure SQL Server 2008
• Design a database server security solution
• Design a database solution for high availability
• Design a backup and recovery solution
• Design a monitoring strategy
• Design a strategy to maintain and manage databases
• Design a strategy for data distribution
• Maintain SQL Server instances
• Manage SQL Server security
• Maintain a SQL Server database
• Perform data management tasks
• Monitor and troubleshoot SQL Server
• Optimise SQL Server performance
• Implement high availability
• Design a SQL Server instance and a database solution

What you'll be able to do

• Implement tables and views
• Design programming objects
• Design a transaction and concurrency strategy
• Design an XML strategy
• Design queries for performance
• Design a database for optimal performance
• Implement programming objects
• Work with query fundamentals
• Apply additional query techniques
• Work with additional SQL Server components
• Work with XML data
• Gather performance information
• Design a database strategy
• Design database tables

What you'll be able to do

• Design a database server infrastructure
• Design a database data management strategy
• Design a strategy to manage database security
• Design a strategy to maintain database security
• Design security for a database server solution
• Design a physical database
• Design a database solution for high availability
• Design a data recovery solution for a database
• Design a strategy for data archiving
• Optimise the performance of database servers
• Optimise the performance of databases
• Optimise a data recovery plan for a database
• Implement a data recovery plan for a database
• Design a strategy to monitor a database solution
• Design a strategy to maintain a database solution

What you'll be able to do

• Install Windows Vista operating system on a computer.
• Configure and troubleshoot post-installation system settings in Windows Vista.
• Manage Windows Vista security features to protect the system from threats.
• Configure and troubleshoot networking settings in Windows Vista.
• Configure and troubleshoot applications included with Windows Vista.
• Manage and maintain systems that are running Windows Vista to ensure optimal performance.
• Configure and troubleshoot mobile computing features in Windows Vista.

What you'll be able to do

• Configure additional Active Directory server roles within a Windows Server 2008 environment.
• Maintain the Active Directory environment to ensure its stability, security, and performance.
• Configure Active Directory Certificate Services for secure authentication and encryption.
• Configure IP addressing and services to ensure proper network communication.
• Configure network access to control user access to network resources.
• Monitor and manage a network infrastructure to identify and resolve potential issues.

What you'll be able to do

• Configure additional Active Directory server roles to enhance functionality
• Configure IP addressing and services to ensure network connectivity
• Monitor and manage a network infrastructure to maintain optimal performance
• Deploy servers to meet organisational needs
• Configure Terminal Services to enable remote access
• Configure a web services infrastructure to support web-based applications

What you'll be able to do

• Understand virtualisation principles
• Manage complex virtualised environments
• Deploy vSphere solutions
• Administer vSphere enterprise components

What you'll be able to do

• Understand the fundamental principles of virtualisation
• Understand the function of different data centre components
• Design a virtualisation environment that meets specified requirements
• Implement a virtualisation design according to the design specifications

What you'll be able to do

• Install and configure Microsoft Team Foundation Server according to specified requirements
• Administer Team Foundation Server instances and team projects to manage access and resources
• Administer Team Foundation Server version control to track changes and manage code
• Administer work item types and process templates to standardise workflows
• Administer a team build to automate the software development process
• Manage team project reporting and documentation to ensure effective communication and knowledge sharing

What you'll be able to do

• Deploy Visual Studio 2005 Tools for the Microsoft Office System (VSTO) solutions
• Secure Visual Studio 2005 Tools for the Microsoft Office System (VSTO) solutions
• Work with data in a VSTO solution
• Integrate XML in Office applications
• Develop application-level solutions using VSTO
• Develop document-level solutions using VSTO

What you'll be able to do

• Describe web architecture and components, including clients, servers, and networks.
• Explain the technologies used to build and operate websites, including HTML, CSS, JavaScript, and server-side scripting languages.
• Implement specified components of a website, using appropriate technologies and coding practices.

What you'll be able to do

• Understand web architecture
• Understand web components
• Understand the technologies that can be used to build a website
• Understand the technologies that can be used to operate a website
• Develop a web-site specification
• Implement elements of a web-site

What you'll be able to do

• Plan and manage a client life cycle strategy for Windows 7 deployments
• Design a standard image for Windows 7 clients to ensure consistency and efficiency
• Design client configurations for Windows 7 to meet specific user and organisational needs
• Design a Windows 7 client deployment strategy, considering various deployment methods
• Design application packages for deployment to Windows 7 clients, ensuring compatibility and ease of installation

What you'll be able to do

• Identify the cause of desktop application issues
• Resolve desktop application issues
• Identify the cause of networking issues
• Resolve networking issues
• Manage systems that run Windows 7 Client
• Maintain systems that run Windows 7 Client
• Support mobile users

What you'll be able to do

• Customise the Windows Embedded CE 6.0 Operating System design to meet specific requirements
• Build and deploy the runtime image for a Windows Embedded CE 6.0 system
• Perform system programming tasks within the Windows Embedded CE 6.0 environment
• Debug and test the Windows Embedded CE 6.0 system to ensure correct functionality
• Customise a Board Support Package (BSP) for a specific hardware platform within Windows Embedded CE 6.0
• Develop device drivers for Windows Embedded CE 6.0 to interface with hardware components

What you'll be able to do

• Plan network and application services to meet organisational requirements
• Design core identity and access management components for a secure IT infrastructure
• Design support identity and access management components to enhance security and control
• Design systems and processes for business continuity and data availability in case of disruptions

What you'll be able to do

• Plan for server deployment, including hardware requirements, operating system selection, and network configuration
• Plan for server management, including user account management, security policies, and software updates
• Monitor and maintain servers, including performance monitoring, log analysis, and troubleshooting
• Plan application and data provisioning, including software installation, data migration, and storage allocation
• Plan for business continuity and high availability, including backup and recovery strategies, failover mechanisms, and disaster recovery planning

What you'll be able to do

• Optimise the performance of database servers
• Optimise the performance of databases
• Optimise a data recovery plan for a database
• Implement a data recovery plan for a database
• Design a strategy to monitor a database solution
• Design a strategy to maintain a database solution
• Design a database data management strategy
• Design a strategy to manage database security
• Design a strategy to maintain database security