City & Guilds Level 4 Diploma For ICT Professionals (Systems and Principles)

What you'll be able to do

• Deploy server images, including selecting appropriate deployment methods and configuring deployment settings
• Manage Domain Name Systems (DNS), including configuring DNS zones, records, and resolvers
• Maintain domain controllers, including performing routine maintenance tasks, troubleshooting issues, and managing replication
• Implement a group policy infrastructure, including creating and configuring Group Policy Objects (GPOs)
• Manage remote access, including configuring VPNs and other remote access technologies
• Manage the network server, including configuring network services and managing network resources
• Optimise file services, including configuring file sharing permissions and optimising file server performance
• Manage group policy, including troubleshooting group policy issues and managing group policy settings

What you'll be able to do

• Install SQL Server, following the correct procedures and configurations.
• Use databases, including creating, modifying, and querying databases.
• Restore SQL Server databases, ensuring data integrity and availability.
• Authorise users, granting appropriate access permissions to different users.
• Audit SQL Server Environments, monitoring and analysing database activity for security and compliance purposes.
• Automate SQL Server Management, using scripting and scheduling tools to streamline administrative tasks.
• Configure security for SQL Server Agent, protecting the agent from unauthorised access and misuse.
• Perform ongoing database maintenance, including tasks such as backups, index maintenance, and performance tuning.
• Use tracing options, capturing and analysing database events to diagnose performance issues and identify potential problems.
• Manage multiple servers, administering and monitoring multiple SQL Server instances from a central location.
• Troubleshoot SQL Server administrative issues, identifying and resolving common problems related to database administration.

What you'll be able to do

• Understand the purpose and benefits of Business Intelligence (BI) systems
• Understand the components of a typical BI architecture
• Understand different types of BI tools and techniques
• Design Business Intelligence solutions to meet specific business needs
• Select appropriate data sources for a BI solution
• Design data models for a BI solution
• Implement Business Intelligence solutions using appropriate tools and technologies
• Extract, transform, and load (ETL) data into a BI system
• Create reports and dashboards to visualise data
• Test Business Intelligence solutions to ensure accuracy and reliability
• Document Business Intelligence solutions, including design specifications and implementation details

What you'll be able to do

• Understand the structure of different types of business organisations
• Understand the aims and objectives of business organisations
• Understand the impact of e-Commerce on business operations
• Design effective e-Commerce solutions for a given business scenario

What you'll be able to do

• Understand the fundamental principles of routing services and protocols
• Understand routing concepts such as distance vector and link-state routing
• Implement an EIGRP-based routing solution in a network environment
• Configure and verify EIGRP routing protocols
• Implement an OSPF-based routing solution in a network environment
• Configure and verify OSPF routing protocols
• Understand the manipulation of routing updates using route maps and filters
• Understand how to control routing updates to optimise network performance
• Understand path control mechanisms such as policy-based routing
• Understand how to influence traffic flow using path control techniques
• Implement a BGP solution for ISP connectivity
• Configure and manage BGP routing protocols for external connectivity
• Implement routing facilities for branch offices and mobile workers using VPNs
• Configure and manage VPN connections for remote access
• Implement IPv6 in an enterprise network
• Configure and manage IPv6 routing protocols

What you'll be able to do

• Understand how to analyse an Enterprise Campus Architecture
• Implement VLANs in Campus Networks
• Implement Spanning Tree protocols
• Implement inter-VLAN Routing techniques
• Understand High Availability and Redundancy mechanisms in a Campus Network
• Understand Campus Infrastructure Security measures
• Understand the preparation of the Campus Infrastructure for Advanced Services

What you'll be able to do

• Plan maintenance for complex networks
• Understand troubleshooting processes for complex enterprise networks
• Implement maintenance and troubleshooting tools and applications
• Maintain and troubleshoot campus switched solutions
• Maintain and troubleshoot routing solutions
• Maintain and troubleshoot addressing services
• Maintain and troubleshoot network performance issues on converged networks
• Maintain and troubleshoot network security implementations
• Maintain and troubleshoot integrated, complex enterprise networks

What you'll be able to do

• Design a network infrastructure that meets specified requirements.
• Implement a prototype network according to the design specifications.
• Maintain a prototype network, ensuring its continued functionality and performance.

What you'll be able to do

• Configure a switched infrastructure according to specified requirements
• Test and troubleshoot a routed and switched infrastructure to identify and resolve issues
• Understand traffic filtering techniques and implement a suitable solution to manage network traffic

What you'll be able to do

• Understand the diverse types of network systems in common use
• Understand the diverse types of network devices in common use
• Explain how different network technologies operate
• Explain how different network technologies communicate
• Understand basic security and its impact on the user
• Configure cross network communication
• Troubleshoot cross network communication

What you'll be able to do

• Identify different routing protocols used in small-to-medium businesses and ISPs
• Understand the function of different routing protocols
• Configure a router to communicate with a Wide Area Network (WAN) infrastructure
• Test the functionality of a configured network system
• Troubleshoot issues within a network system using appropriate tools and techniques
• Implement address management strategies within a network environment

What you'll be able to do

• Implement a Wide Area Network (WAN) according to specified requirements.
• Test a Wide Area Network (WAN) implementation to ensure functionality.
• Troubleshoot a Wide Area Network (WAN) implementation to identify and resolve issues.
• Plan security measures for a Wide Area Network (WAN) to protect against threats.
• Evaluate the performance and security of a Wide Area Network (WAN).
• Implement security technologies to protect a Wide Area Network (WAN).
• Implement network address management technologies to efficiently manage IP addresses within a Wide Area Network (WAN).

What you'll be able to do

• Configure a switched and trunked VLAN infrastructure according to specified requirements.
• Test and troubleshoot a VLAN infrastructure to identify and resolve any issues.
• Enable a VLAN Trunk Protocol (VTP) client/server structure to operate and effectively manage a LAN environment.
• Understand the operation of wireless systems, including their configuration and security aspects.

What you'll be able to do

• Know the diverse types of network systems and devices in common use, including their functions and characteristics
• Know how different network technologies operate and communicate, including protocols and standards
• Understand the OSI and TCP/IP models and their relationship to the operation of network systems
• Configure a workstation for connection to a network, including setting up IP addresses, DNS servers, and gateway settings
• Design a sub-network scheme, including IP addressing and subnetting
• Recommend improvements to an existing network infrastructure, based on performance, security, and scalability considerations

What you'll be able to do

• Identify and understand different routing protocols, including distance vector, link-state, and path vector protocols
• Configure a router to communicate with a WAN infrastructure, including configuring routing protocols and network interfaces
• Test and troubleshoot a network system to identify faults and quality of communication, including using network diagnostic tools and techniques

What you'll be able to do

• Understand the principles involved in managing computer systems effectively.
• Manage the support of operating systems, including installation, configuration, and troubleshooting.
• Manage and maintain networked systems, ensuring their stability and security.

What you'll be able to do

• Know the installation procedure for Linux based systems.
• Manage Linux based clients effectively.
• Configure system settings for Linux based systems.
• Configure network services on Linux based systems.
• Configure access rights on Linux based systems.
• Implement security options on Linux based systems.
• Complete documentation for Linux system configurations and procedures.
• Know the hardware components that relate to typical Linux client systems.
• Know the hardware components that relate to typical Linux server systems.

What you'll be able to do

• Understand different network media and topologies, including their advantages and disadvantages.
• Understand network protocols and standards, including TCP/IP, Ethernet, and wireless protocols.
• Understand network implementation, including cabling, configuration, and security.
• Carry out network support tasks, including troubleshooting, maintenance, and upgrades.

What you'll be able to do

• Understand general security concepts and their application in IT environments.
• Recognise and understand communication security protocols and technologies.
• Understand and differentiate infrastructure security components and configurations.
• Understand and apply the basics of cryptography to secure data and communications.
• Understand and apply the basics of cryptography to secure data and communications.
• Understand operational and organisational security policies and procedures.

What you'll be able to do

• Know the specifications of general server hardware components and their functions.
• Install a server operating system and related software components.
• Configure a server to meet specific requirements, including network settings and security policies.
• Upgrade server hardware and software components to improve performance and security.
• Proactively maintain a server to ensure optimal performance and prevent potential issues.
• Protect the server environment from threats by implementing security measures and best practices.
• Troubleshoot and identify server problems, including hardware failures and software errors.
• Know the components of a disaster recovery plan for servers and how to implement it.

What you'll be able to do

• Understand the systems that support ‘Shells, Scripting and Data management’ within a Linux environment.
• Effectively manage user interfaces and desktops in a Linux operating system.
• Manage Linux-based administrative tasks, including user management and system configuration.
• Manage essential system services within a Linux environment.
• Understand networking fundamentals relevant to Linux server administration.
• Manage Linux-based security measures to protect systems and data.

What you'll be able to do

• Deploy Client Agents and Policies according to organisational requirements
• Configure Server Products to meet specified performance criteria
• Maintain the Infrastructure of the Client and Server to ensure optimal operation
• Monitor Protection Status and Activity to identify and address potential security threats

What you'll be able to do

• Implement advanced network services according to organisational requirements
• Implement advanced file services according to organisational requirements
• Implement Dynamic Access Control according to security policies
• Implement directory services according to organisational procedures
• Implement certificate services according to industry best practices
• Implement Rights Management Services (RMS) according to data protection regulations
• Implement Federation Services (FS) according to interoperability standards
• Implement Network Load Balancing (NLB) to ensure high availability
• Implement failover clustering to minimise downtime
• Implement disaster recovery plans to ensure business continuity

What you'll be able to do

• Configure Microsoft Office SharePoint Server 2007 to meet specified requirements
• Manage search functionality within Microsoft Office SharePoint Server 2007
• Configure content management features in Microsoft Office SharePoint Server 2007
• Configure business forms within Microsoft Office SharePoint Server 2007
• Manage business intelligence capabilities in Microsoft Office SharePoint Server 2007
• Manage the administration of Microsoft Office SharePoint Server 2007
• Deploy or upgrade Microsoft Office SharePoint Server 2007 according to best practices

What you'll be able to do

• Install Windows operating systems on a computer
• Manage user state, including profiles and data migration
• Use Windows tools for system administration and troubleshooting
• Configure network connections, including wired and wireless connections
• Configure resource access, including file sharing and printer sharing
• Secure networks, including firewalls and intrusion detection systems
• Manage file access, including permissions and encryption
• Secure Windows devices, including passwords and biometrics
• Maintain Windows client computers, including updates and backups
• Configure applications for Windows, including installation and settings
• Configure remote access, including VPNs and remote desktop
• Configure desktop virtualisation, including virtual machines and thin clients
• Recover a Windows based operating system from a failure

What you'll be able to do

• Understand the principles of hierarchical network design and its benefits for scalability and manageability.
• Understand the different Wide Area Network (WAN) access technologies available for small to medium-sized networks.
• Configure a serial interface to enable WAN communication between network devices.
• Configure an Ethernet interface to enable broadband communication for network access.
• Implement network address translation (NAT) for IP address conservation and security.
• Configure a tunnelling protocol to enable secure site-to-site communication over a public network.
• Configure network monitoring tools and techniques to track network performance and identify issues.
• Troubleshoot data networks using appropriate diagnostic tools and methodologies.

What you'll be able to do

• Implement a software design using procedural programming techniques, adhering to coding standards
• Refine a procedural program to improve quality, considering factors such as efficiency and maintainability
• Test the operation of a procedural program thoroughly to ensure it meets requirements
• Document a computer program clearly and comprehensively, including comments and user guides

What you'll be able to do

• Implement a software design by writing code using event driven programming principles and techniques
• Refine an event driven program to improve its quality, considering factors such as efficiency, maintainability, and user experience
• Test the operation of an event driven program to ensure it functions correctly and meets the specified requirements
• Document an event driven program, including its design, functionality, and usage instructions

What you'll be able to do

• Implement a software design by using event driven programming techniques.
• Refine an event driven program to improve its overall quality and efficiency.
• Test the operation of an event driven program to ensure it functions correctly.
• Document an event driven program, including its design, implementation, and testing processes.

What you'll be able to do

• Implement a software design by utilising event-driven programming techniques and principles.
• Refine an event-driven program to improve its overall quality, performance, and maintainability.
• Test the operation of an event-driven program to ensure it functions correctly and meets specified requirements.
• Document an event-driven program, including its design, functionality, and usage.

What you'll be able to do

• Implement a software design using object oriented programming techniques
• Refine an object oriented program to improve its quality and performance
• Test the operation of an object oriented driven program to ensure it functions correctly
• Document an object oriented driven program, including its design and functionality

What you'll be able to do

• Implement a software design by writing code using object oriented programming principles
• Refine an object oriented program to improve its overall quality, efficiency and maintainability
• Test the operation of an object oriented driven program to ensure it functions correctly and meets requirements
• Document an object oriented driven program, including its design, functionality, and usage

What you'll be able to do

• Implement a software design using object-oriented programming principles and techniques
• Refine an object-oriented program to improve its quality, efficiency, and maintainability
• Test the operation of an object-oriented driven program to ensure it meets specified requirements
• Document an object-oriented driven program, including its design, functionality, and usage

What you'll be able to do

• Identify and analyse a problem, defining its scope and impact.
• Plan, monitor, and evaluate the implementation of a problem solution, ensuring its effectiveness and efficiency.
• Review their approach to problem solving and the proposed problem solution, identifying areas for improvement and learning.

What you'll be able to do

• Provide technical support to customers in a professional and timely manner
• Gather feedback from customers regarding their experience with technical support provision
• Evaluate customer feedback to identify areas for improvement in technical support provision
• Implement a recommended action plan to improve technical support provision based on customer feedback
• Provide remote technical customer support using appropriate tools and techniques
• Provide coaching in technical skills for customers to enhance their understanding and capabilities

What you'll be able to do

• Understand the principles of data communication networks and the necessity for open systems architecture
• Understand the various methods and protocols used for effective data communication
• Know the functions and control methods employed in local area networks (LANs) to ensure efficient operation
• Understand the concepts and technologies behind wide area networks (WANs) and internetworking principles

What you'll be able to do

• Understand databases and data management systems, including relational and non-relational databases.
• Understand database design techniques, including normalisation and entity-relationship modelling.
• Design, create and document databases according to specified requirements.

What you'll be able to do

• Plan the structure of relational database tables to meet specific requirements.
• Create and modify relational database tables using appropriate database management system tools.
• Enter, edit, and organise structured information within a database, ensuring data integrity.
• Use database software tools to create, edit, and run data queries to retrieve specific information.
• Produce reports from the database, presenting data in a clear and organised manner.

What you'll be able to do

• Plan Microsoft Exchange Server 2007 upgrades and migrations, considering different upgrade paths and migration strategies.
• Plan for high availability implementation in Microsoft Exchange Server 2007, including clustering and redundancy.
• Plan the Exchange topology deployment, considering factors such as site design and server roles.
• Plan messaging security and compliance implementation, including anti-spam, anti-virus, and data loss prevention.
• Plan for messaging environment maintenance, including patching, backups, and disaster recovery.

What you'll be able to do

• Obtain, insert and combine information from various sources for designs, ensuring accuracy and relevance
• Use design software tools to create, manipulate and edit designs, applying appropriate techniques and features

What you'll be able to do

• Survey a site for the provision of an external overhead telecoms infrastructure, understanding the factors that need to be considered.
• Survey a site for the provision of an external overhead telecoms infrastructure, accurately recording relevant information.
• Produce preliminary designs for the provision of an external overhead communications cabling infrastructure and select an optimum solution, understanding the design principles and selection criteria.
• Produce preliminary designs for the provision of an external overhead Communications cabling infrastructure and select an optimum solution, creating viable design options and justifying the chosen solution.
• Produce a design for the provision of an external overhead communications cabling infrastructure, understanding the detailed design requirements.
• Produce a design for the provision of an external overhead communications cabling infrastructure, creating a comprehensive and accurate design document.

What you'll be able to do

• Conduct a preliminary site survey for the provision of an external underground communications infrastructure.
• Survey a site to determine the requirements for the provision of an external underground communications cabling infrastructure.
• Produce preliminary designs for the provision of an external underground communications cabling infrastructure and select an optimum solution.
• Produce preliminary designs for the provision of an external underground communications cabling infrastructure and select an optimum solution based on given criteria.
• Produce a detailed design for the provision of an external underground communications cabling infrastructure, incorporating relevant standards and regulations.
• Plan and produce a comprehensive design for the provision of an external underground communications cabling infrastructure, taking into account all relevant factors such as cost, environmental impact, and future scalability.

What you'll be able to do

• Design a database strategy, considering business requirements and long-term scalability.
• Design database tables, including appropriate data types, constraints, and relationships.
• Design programming objects, such as stored procedures and functions, to encapsulate database logic.
• Design a transaction and concurrency strategy, ensuring data integrity and consistency.
• Design an XML strategy, including schema design and data transformation techniques.
• Design queries for performance, optimising query execution plans and minimising resource consumption.
• Design a database for optimal performance, considering indexing, partitioning, and other performance-enhancing techniques.

What you'll be able to do

• Understand different desktop deployment options available for a Windows desktop infrastructure
• Understand how to plan an image management strategy for a Windows desktop infrastructure
• Implement security measures for a desktop operating system
• Manage a desktop operating system image within a Windows desktop infrastructure
• Implement user state migration techniques within a Windows desktop infrastructure
• Design an Active Directory Domain Services physical infrastructure to support a Windows desktop environment
• Implement a remote desktop services infrastructure within a Windows desktop environment
• Manage user state virtualisation for an enterprise desktop environment
• Design network access services for a Windows desktop infrastructure
• Protect an enterprise desktop environment from security threats
• Monitor the performance of a Windows desktop infrastructure

What you'll be able to do

• Understand how to plan a server upgrade or migration, taking into account existing infrastructure and business requirements.
• Implement a server deployment strategy, including planning for installation, configuration, and testing.
• Implement an address management solution, such as DHCP or static addressing, ensuring network connectivity and avoiding conflicts.
• Implement a name resolution strategy, such as DNS, to allow users and applications to easily locate network resources.
• Implement Active Directory Domain Services logical infrastructures, including domains, organisational units, and group policies.
• Design an Active Directory Domain Services physical infrastructure, including domain controllers, sites, and replication topology.
• Implement storage solutions, including configuring disks, volumes, and file systems.
• Implement file services, including sharing files and folders, setting permissions, and managing quotas.
• Design network access services, including VPNs, remote access, and network policies.
• Design network protection measures, including firewalls, intrusion detection systems, and anti-malware software.

What you'll be able to do

• Select and use appropriate designs and page layouts for publications, considering the target audience and purpose of the publication.
• Input and combine text and other information within publications, ensuring accuracy and consistency.
• Use desktop publishing software techniques to edit and format publications, including text formatting, image manipulation, and page layout adjustments.

What you'll be able to do

• Query and display data from a single table using SQL
• Query and display data from multiple tables using SQL
• Manipulate data within tables using SQL commands
• Create and manage tables, views, and indexes using SQL
• Control user access to database objects using SQL

What you'll be able to do

• Understand the principles of application security and its importance
• Understand application security features and how they protect against threats
• Understand network security considerations for mobile applications
• Understand data security measures for protecting sensitive information in mobile apps
• Understand secure Java coding practices for developing secure Android applications

What you'll be able to do

• Understand the fundamental principles of application security in the context of mobile applications.
• Understand the core concepts of Objective-C coding relevant to iOS application development.
• Understand the various application security features available within the iOS operating system.
• Understand the principles of network security as they apply to mobile applications and data transmission.
• Understand the methods and techniques for ensuring data security within mobile applications, including storage and access control.
• Understand the techniques involved in application hardening to protect against common vulnerabilities and attacks.

What you'll be able to do

• Understand the core principles and concepts of distributed computing systems.
• Design robust and scalable distributed software applications.
• Implement distributed software applications, considering factors such as concurrency and communication.
• Test distributed software applications to ensure reliability and performance across different environments.

What you'll be able to do

• Input, organise, and combine information effectively for the creation of drawings or plans
• Use appropriate tools and techniques to edit, manipulate, format, and present drawings or plans to a professional standard

What you'll be able to do

• Understand the key differences between business-to-business (B2B) and business-to-consumer (B2C) purchase transactions in the context of e-business
• Understand the principles and applications of Electronic Data Interchange (EDI) and other electronic transaction methods
• Demonstrate the benefits of electronic transactions to supply chain management, including improved efficiency, reduced costs, and enhanced visibility
• Understand key issues in e-business, including quality recruitment strategies, data security protocols, and fraud prevention measures

What you'll be able to do

• Understand the importance of effective communication in business, including its impact on productivity and relationships.
• Understand the importance of effective written communication in business, including different formats and styles.
• Understand the importance of effective verbal communication in business, including active listening and clear articulation.
• Understand how to communicate effectively in a non-verbal way, recognising the impact of body language and visual cues.
• Understand the purpose and value of getting feedback when developing communication skills, and how to use feedback constructively.
• Recommend appropriate communication methods for specific purposes, considering the audience and context.

What you'll be able to do

• Understand the characteristics and applications of emerging technologies.
• Understand the potential impact of emerging technologies on society and various sectors.
• Conduct research into emerging technologies, gathering information from reliable sources.
• Understand the ethical implications associated with the development and use of emerging technologies.

What you'll be able to do

• Understand the core principles of event driven programming, including event handling, event loops, and asynchronous programming
• Design event driven programming solutions, considering factors such as user interaction, data flow, and system responsiveness
• Implement event driven programming solutions, utilising appropriate programming languages, frameworks, and libraries
• Test and document event driven programming solutions, ensuring functionality, performance, and maintainability

What you'll be able to do

• Operate Linux based operating systems effectively.
• Use package management tools to install and update software.
• Use Linux based operating system commands to perform common tasks.
• Manage files and directories within a Linux based operating system.

What you'll be able to do

• Understand recent developments in human computer interaction and their practical application
• Understand the key issues related to the design and evaluation of a chosen human computer interface
• Develop a human computer interface that is user-friendly and effective

What you'll be able to do

• Describe the legislative requirements for repair centre operations
• Detail specific technical resource requirements for repair centre operations
• Develop a repair centre specification
• Provide technical support to others

What you'll be able to do

• Understand the role that the consultant plays in helping to bring about technology driven organisational change
• Structure a client assignment and specify the key management deliverables involved
• Capture, document and present back the functional requirements of business users
• Agree and document the manner in which the success of an assignment will be judged
• Use standard techniques to plan and control the work involved in producing the products associated with a consulting assignment
• Manage the client during an assignment and develop an appreciation of the challenges faced when dealing with difficult clients

What you'll be able to do

• Understand the commercial impact and potential of virtualisation technologies, including cost savings, improved resource utilisation, and increased flexibility.
• Design virtualisation deployments that meet specific business requirements, considering factors such as server consolidation, disaster recovery, and application isolation.
• Implement virtualisation deployments using appropriate virtualisation platforms and tools, following best practices for configuration and security.
• Manage virtualisation environments, including monitoring performance, allocating resources, and troubleshooting issues.

What you'll be able to do

• Obtain information for images from various sources
• Insert information into images
• Combine different types of information within images
• Use imaging software tools to create images
• Use imaging software tools to manipulate images
• Use imaging software tools to edit images

What you'll be able to do

• Implement over-the-air (OTA) technologies for mobile device management.
• Understand the network infrastructure required to support a mobile computing environment.
• Manage mobile devices effectively, including configuration and monitoring.
• Understand mobile security issues and implement appropriate security measures.
• Troubleshoot mobile problems and provide effective solutions.

What you'll be able to do

• Understand fundamental networking concepts, including network topologies, protocols, and addressing schemes.
• Implement networks according to given specifications, configuring network devices and services.
• Understand the components of network infrastructure, including hardware, software, and cabling.
• Manage networks effectively, monitoring performance, troubleshooting issues, and maintaining network security.
• Secure networks against unauthorised access and cyber threats, implementing security measures and protocols.

What you'll be able to do

• Design an application distribution strategy that considers factors such as user needs, network bandwidth, and security requirements.
• Resolve application compatibility issues to ensure that applications function correctly in the target environment.
• Deploy software using appropriate methods, such as manual installation, group policy, or software distribution tools.
• Configure self-service applications to allow users to install and manage their own software.
• Implement presentation virtualization infrastructure to centralise application management and improve security.
• Deploy presentation virtualization applications to users, ensuring a seamless user experience.
• Deploy an application virtualisation environment to isolate applications from the underlying operating system.
• Deploy virtual applications to users, providing access to applications without installing them locally.
• Implement application updates to ensure that applications are up-to-date with the latest security patches and features.
• Implement application upgrades to provide users with new versions of applications.
• Monitor application deployment to track progress, identify issues, and ensure successful deployment.

What you'll be able to do

• Understand the hardware requirements for a data warehouse, including server specifications and storage capacity.
• Implement a data warehouse solution, including database design and configuration.
• Create an Extract, Transform and Load (ETL) solution for populating the data warehouse.
• Implement an incremental ETL process to update the data warehouse with new data.
• Use a cloud data warehousing solution, understanding its benefits and limitations.
• Use Data Quality Services (DQS) to ensure data accuracy and consistency.
• Use Master Data Services to manage and maintain master data entities.
• Use SSIS packages to automate data integration and transformation tasks.
• Understand the principles and applications of Business Intelligence (BI) in data warehousing.

What you'll be able to do

• Analyse and identify ICT system security issues and vulnerabilities
• Implement security measures on email and instant messaging systems to protect against threats
• Implement and maintain internet and network security protocols to safeguard the ICT system
• Maintain data integrity and system security through appropriate policies and procedures

What you'll be able to do

• Install system hardware
• Implement Network Operating System (NOS) software
• Configure storage
• Implement server access
• Implement disaster recovery
• Troubleshoot server problems

What you'll be able to do

• Prepare thoroughly for the installation of software, ensuring compatibility and necessary prerequisites are met.
• Install and configure a range of system and application software according to specified requirements.
• Check that the system operates as planned during and after the installation of system and application software, verifying functionality and stability.
• Resolve any unwanted changes to the system caused by the installation and configuration of system and application software, restoring the system to its desired state.

What you'll be able to do

• Deploy Windows based servers according to organisational requirements and best practices.
• Understand the role and function of domain controllers in a Windows Server environment.
• Manage user accounts, including creation, modification, and deletion, in accordance with security policies.
• Implement Internet Protocol (IP) addressing and subnetting for network communication.
• Implement dynamic host configuration protocols (DHCP) to automatically assign IP addresses to network devices.
• Implement domain name systems (DNS) to resolve domain names to IP addresses.
• Configure server storage, including RAID configurations and disk management.
• Manage group policy to enforce security settings and configurations across the domain.
• Implement server virtualization using appropriate technologies and best practices.

What you'll be able to do

• Understand the fundamental principles of Internet technologies and their applications
• Understand different Internet server architectures, including their components and configurations
• Implement Internet servers and associated services according to specified requirements
• Manage Internet servers and services, ensuring their optimal performance and security

What you'll be able to do

• Understand the role of networking within a business context and its impact on communication and collaboration.
• Understand how standardisation supports interoperable end-to-end communications across different network devices and systems.
• Understand the process by which devices access network resources using the TCP/IP suite of protocols.
• Design an IP addressing scheme to provide network connectivity for a given network infrastructure.
• Implement network connectivity between devices using appropriate cabling, hardware, and protocols.
• Configure network access controls and security measures to protect network resources.
• Configure initial Inter Network Operating System (IOS) device settings for routers and switches.

What you'll be able to do

• Understand the core elements of the Linux Kernel, including its structure and functionality.
• Manage system start-up processes in Linux environments.
• Manage the Linux file system and devices, including partitioning and mounting.
• Manage advanced storage device administration tasks in Linux.
• Manage Linux networking configuration, including IP addressing and routing.
• Support system maintenance activities in Linux environments.
• Implement a Linux domain name server (DNS).

What you'll be able to do

• Manage web services on a Linux system, including configuration and troubleshooting.
• Manage file sharing services on a Linux system, including NFS and Samba.
• Manage network clients on a Linux system, including DHCP and DNS.
• Manage e-mail services on a Linux system, including sendmail and postfix.
• Manage system security on a Linux system, including firewalls and intrusion detection.
• Understand Linux troubleshooting technologies, including system logs and debugging tools.

What you'll be able to do

• Understand the impact of LAN technologies on network performance and security
• Design LAN infrastructures that meet specific business needs
• Implement LAN infrastructures using appropriate hardware and software components
• Manage LAN infrastructures to ensure their ongoing operation and security

What you'll be able to do

• Identify different types of system maintenance procedures and their applications.
• Collect information on technical problems encountered with ICT systems, using appropriate methods and tools.
• Evaluate technical problems with ICT systems to determine the root cause and potential impact.
• Implement solutions to resolve identified technical problems with ICT systems, following established procedures.

What you'll be able to do

• Prepare a budget for a creative and cultural organisation and agree it with relevant stakeholders.
• Monitor financial activity and report on it accurately and in a timely manner.
• Manage the budget effectively within the relevant frameworks for financial governance, ensuring compliance and accountability.

What you'll be able to do

• Understand the fundamental principles of staff management within an IT context
• Effectively utilise software management tools for various IT tasks
• Actively participate in strategic planning processes within an IT organisation
• Understand current developments and emerging trends in information technology

What you'll be able to do

• Implement management procedures for a Windows based operating system
• Implement an installation strategy for a Windows based system
• Implement Windows authentication methods to secure a system
• Implement intranet connectivity for a Windows based system
• Implement an application strategy for Windows based systems
• Implement a solution for managing user settings within Windows
• Configure access to cloud services from a Windows based system
• Implement access to file and print services within a Windows environment
• Implement encryption techniques for Windows based systems
• Implement endpoint security measures for Windows based systems
• Implement extranet connectivity for a Windows based system
• Implement recovery solutions for Windows based systems

What you'll be able to do

• Understand core mathematical skills required for software engineers, including number systems, logic, and set theory.
• Understand the application of algebraic concepts in software development, including equations, inequalities, and matrices.
• Apply the fundamentals of formal methods to software development, including specification and verification.
• Apply statistical techniques to analyse data relevant to software development, including descriptive statistics and hypothesis testing.

What you'll be able to do

• Plan the content and organisation of multimedia products to meet identified user needs and project specifications
• Obtain, input, and combine various content types (e.g., text, images, audio, video) to build multimedia outcomes
• Use appropriate software tools and techniques to build and edit multimedia content effectively
• Play and present multimedia outcomes in a suitable format for the intended audience

What you'll be able to do

• Understand network operating systems principles, including their architecture, functions, and protocols.
• Plan the implementation of network operating systems, considering factors such as hardware requirements and network topology.
• Implement network operating systems, including installation, configuration, and testing.
• Manage network operating systems, including user administration, security management, and performance monitoring.

What you'll be able to do

• Understand the fundamental principles of network infrastructure management, including its importance and key components
• Design complex network infrastructure systems, considering factors such as scalability, security, and performance
• Implement complex network infrastructure systems, following industry best practices and ensuring seamless integration
• Test complex network infrastructure systems to identify and resolve any issues, ensuring optimal functionality and reliability

What you'll be able to do

• Understand networking principles, including network models, protocols, and addressing schemes.
• Understand the function and characteristics of various networking components, such as routers, switches, and firewalls.
• Design networked systems that meet specified requirements, considering factors such as scalability, security, and performance.
• Implement and support networked systems, including configuring network devices, troubleshooting network issues, and maintaining network security.

What you'll be able to do

• Understand the fundamental principles of object oriented programming, including concepts such as encapsulation, inheritance, and polymorphism.
• Design object oriented programming solutions that meet specified requirements, using appropriate design patterns and UML diagrams.
• Implement object oriented programming solutions using a suitable programming language, adhering to coding standards and best practices.
• Test object oriented programming solutions to ensure they function correctly and meet performance criteria, and document the solutions effectively.

What you'll be able to do

• Understand the context of database systems and data design principles within an organisational setting
• Design an entity relationship diagram (ERD) to model data requirements
• Create a normalised data structure to ensure data integrity and efficiency

What you'll be able to do

• Understand the purpose and application of various SQL functions for data manipulation and analysis
• Construct Data Manipulation Language (DML) and Data Definition Language (DDL) statements to manage database data and structure
• Construct data views to simplify complex queries and provide controlled access to data
• Manage database integrity by implementing constraints, triggers, and other mechanisms to ensure data accuracy and consistency

What you'll be able to do

• Understand the fundamental principles of PL/SQL programming.
• Construct PL/SQL code to meet specified requirements.
• Construct PL/SQL structures, including procedures, functions, and triggers.

What you'll be able to do

• Create and execute Java technology applications that effectively leverage the object-oriented features of the Java language.
• Implement robust error-handling techniques to ensure application stability and prevent unexpected crashes.
• Create a graphical user interface (GUI) for Java applications to enhance user interaction.
• Implement input/output (I/O) functionality to enable data processing and storage within Java applications.
• Create a simple TCP/IP networked client for communication with other systems.
• Define multithreaded programs to improve application performance and responsiveness.

What you'll be able to do

• Demonstrate knowledge of Java technology, the Java programming language, and the product life cycle for Java applications.
• Use Java programming language constructs to create Java technology applications that meet specified requirements.
• Use decision and looping constructs and methods to dictate program flow within Java applications.
• Implement Java technology programming concepts in Java technology programs.
• Implement object-oriented (OO) concepts in Java technology programs.

What you'll be able to do

• Demonstrate a comprehensive knowledge of the Oracle database architecture and its components.
• Prepare the database environment for optimal performance and security.
• Manage the Oracle instance, including startup, shutdown, and configuration.
• Configure the Oracle network to enable client connectivity and data transfer.
• Manage the physical database storage structures, including tablespaces and datafiles.
• Create and administer user accounts, assigning appropriate privileges and roles.
• Manage data concurrency to prevent data corruption and ensure data integrity.
• Monitor and administer undo to facilitate transaction rollback and data recovery.
• Manage database security, implementing access controls and auditing mechanisms.
• Monitor database performance and identify areas for optimisation.
• Implement backup and recovery strategies to protect against data loss.
• Perform data movement operations, such as importing and exporting data.
• Work effectively with support resources to resolve database issues.

What you'll be able to do

• Understand how to plan for personal and professional development, including identifying goals, assessing skills, and setting priorities
• Understand different learning styles and theories to optimise personal and professional development
• Produce personal and professional development plans, outlining specific actions, timelines, and resources
• Make recommendations for personal and professional development activities, based on individual needs and organisational requirements

What you'll be able to do

• Understand the common types of threat to ICT systems and data, including malware, phishing, and social engineering.
• Understand how to protect ICT systems 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

• Prepare for and carry out a site survey for the provision of telecoms services, identifying relevant factors and potential challenges.
• Identify a range of options for the provision of telecoms services and select the optimum solution based on technical and commercial considerations.
• Produce designs for the provision of telecoms services, incorporating relevant standards and regulations.
• Produce detailed plans for telecoms services, including resource allocation, timelines, and risk assessments.
• Co-ordinate the provision of telecoms services, ensuring effective communication and collaboration between stakeholders.

What you'll be able to do

• Understand the principles of procedural programming.
• Design procedural programming solutions to meet specified requirements.
• Implement procedural programming solutions using appropriate programming techniques.
• Test procedural programming solutions to ensure they function correctly.

What you'll be able to do

• Understand the fundamental principles of programming using a .NET framework
• Design .NET solutions that meet specified requirements
• Implement .NET solutions using appropriate programming techniques and tools
• Test and document .NET solutions to ensure their quality and maintainability

What you'll be able to do

• Create HTML5 pages using appropriate elements and structure
• Code using JavaScript to add functionality to web pages
• Create forms using HTML5 elements for data input
• Communicate with a remote data source using appropriate techniques
• Style HTML5 elements by using CSS3 to control appearance
• Create interactive pages using HTML5 Application Programming Interfaces (APIs) to enhance user experience
• Add offline support to web applications using appropriate technologies
• Implement an adaptive User Interface (UI) that responds to different screen sizes and devices
• Create graphics using HTML5 canvas or other relevant technologies
• Animate the User Interface (UI) to provide visual feedback and enhance engagement
• Implement Real Time communications by using Web sockets for interactive applications
• Create a Web Worker Process to perform tasks in the background without blocking the main thread

What you'll be able to do

• Understand the fundamental principles of programming using the Java language.
• Design effective and efficient software solutions using Java.
• Implement Java solutions based on given designs and specifications.
• Thoroughly test and document Java solutions to ensure quality and maintainability.

What you'll be able to do

• Understand why organisations utilise project management methodologies and the benefits they provide.
• Understand how to effectively set up projects, defining scope, objectives, and resources.
• Use project management tools to maintain, control, and monitor project progress.
• Review projects at all stages of their lifecycle, identifying successes and areas for improvement.

What you'll be able to do

• Plan for the identification of customer requirements
• Establish customer requirements
• Produce logical and physical design specifications
• Identify implementation and maintenance procedures

What you'll be able to do

• Understand different research methodologies, including quantitative, qualitative, and mixed methods approaches
• Conduct a comprehensive literature review, identifying relevant sources and synthesising information
• Present a well-structured research proposal, outlining the research question, methodology, and expected outcomes
• Contribute effectively to a research seminar, presenting findings and engaging in constructive discussion

What you'll be able to do

• Understand the impact of routing technologies on network performance and scalability.
• Design complex routed environments, considering factors such as network topology and routing protocols.
• Implement complex routed environments, configuring routing devices and protocols.
• Troubleshoot and monitor routed environments to identify and resolve network issues.

What you'll be able to do

• Configure switch ports to effectively manage network access and security.
• Implement Virtual Local Area Networks (VLANs) to logically segment networks and improve performance.
• Configure routing technologies to facilitate seamless internetwork communications.
• Implement static routing to enable reliable end-to-end connectivity between network devices.
• Implement Open Shortest Path First (OSPF) to enable efficient end-to-end connectivity.
• Automate IP addressing configuration for end devices using appropriate protocols.
• Implement Access Control Lists (ACL) to filter network traffic and enhance security.
• Implement network address translation (NAT) for efficient IP address conservation.

What you'll be able to do

• Configure switching hardware to facilitate network access
• Implement wireless Local Area Networks (LANs) to provide network access
• Implement Open Shortest Path First (OSPF) to enable end-to-end connectivity
• Implement Enhanced Interior Gateway Routing Protocol (EIGRP)
• Manage Inter Network Operating System (IOS) system image files

What you'll be able to do

• Implement network security measures to protect against unauthorised access and cyber threats
• Implement operational security procedures in an ICT environment to ensure data integrity and system availability
• Discover potential threats and vulnerabilities in ICT systems and networks through risk assessments and security audits
• Implement data host security measures to protect sensitive information stored on servers and workstations
• Configure access control mechanisms to restrict user privileges and prevent unauthorised actions
• Implement cryptography techniques to encrypt data and secure communications

What you'll be able to do

• Understand the fundamental principles that underpin software application testing.
• Design comprehensive test strategies for software applications.
• Implement test plans effectively, using appropriate testing methodologies.
• Evaluate the effectiveness of test plans and identify areas for improvement.

What you'll be able to do

• Understand the principles of software design, including modularity, abstraction, and information hiding.
• Apply the techniques of software design, including use case modelling, class diagrams, and sequence diagrams.

What you'll be able to do

• Analyse a complex problem in the context of the workplace to identify key issues and contributing factors.
• Apply decision-making techniques when assessing possible solutions to a workplace problem.
• Plan how you will implement the chosen solution to a workplace problem, including resource allocation and timelines.

What you'll be able to do

• Use a spreadsheet to enter, edit, and organise numerical and other data efficiently.
• Select and use appropriate formulas and data analysis tools and techniques to meet specified requirements.
• Use tools and techniques to present, format, and publish spreadsheet information in a clear and professional manner.

What you'll be able to do

• Manage a Microsoft Exchange Server environment effectively
• Configure Mailbox Servers to meet organisational requirements
• Manage recipient objects within the Exchange Server environment
• Configure self-service applications for end-users
• Configure messaging client connectivity to the Exchange Server
• Configure high availability options to ensure continuous service
• Implement disaster recovery procedures for the Exchange Server environment
• Deploy virtual applications related to the Exchange Server
• Implement message security measures to protect sensitive information
• Configure administrative security roles and permissions within the Exchange Server

What you'll be able to do

• Understand different systems life cycles and their characteristics.
• Understand the importance of conducting a feasibility study before systems development.
• Perform a systems investigation to gather information about an existing or proposed system.

What you'll be able to do

• Understand how information is represented within a computer system and the processes involved in its manipulation.
• Use and develop the operating environment of current computer systems, demonstrating an understanding of their functionality.
• Understand the communication processes involved in distributed operating systems and computer networks.
• Understand the principles of distributed applications and transaction processing in mainframe systems.

What you'll be able to do

• Understand the representation of information within a computer system, including different data types and encoding methods
• Understand the way information is processed within a computer system, including the roles of the CPU, memory, and input/output devices
• Make effective use of the operating environment of current computer systems, including command-line interfaces and graphical user interfaces
• Know the communication process in distributed operating systems, including the concepts of client-server architecture and message passing
• Know the communication process in computer networks, including network protocols and topologies
• Know distributed applications and their characteristics, including examples such as cloud computing and peer-to-peer networks
• Know transaction processing in mainframe systems, including the concepts of ACID properties and concurrency control

What you'll be able to do

• Plan systems development activities in accordance with agreed quality standards and project requirements.
• Establish customer requirements through effective communication and analysis techniques.
• Establish procedures for system maintenance to ensure ongoing performance and reliability.
• Understand system implementation procedures, including testing, deployment, and documentation.
• Produce requirements specifications that accurately reflect customer needs and system functionality.
• Prepare for system implementation, including resource allocation and risk assessment.

What you'll be able to do

• Understand the principals of alternating current (AC) circuits, including voltage, current, and impedance
• Understand the effects of line impairments on a transmitted signal, including attenuation, noise, and distortion
• Apply the characteristics of transmission lines, including impedance matching and signal reflection
• Understand the transmission of digital signals over transmission media, including encoding and modulation techniques
• Understand the process of modulating an analogue carrier frequency using digital signals, including amplitude modulation, frequency modulation, and phase modulation
• Apply the process of multiplexing digital and analogue signals over transmission media, including time-division multiplexing and frequency-division multiplexing

What you'll be able to do

• Understand the principles of Unit Testing
• Understand the principles of Test Driven Development
• Understand Test Driven Development techniques
• Implement a Test Driven Development Solution
• Test a solution using Test Driven Development
• Evaluate a solution using Test Driven Development

What you'll be able to do

• Plan and produce standard testing procedures, documenting the steps and resources required for each test.
• Select tests and determine expected results, ensuring that the tests are appropriate for the system and that the expected results are clearly defined.
• Identify and manage consequences of testing, including potential risks to the system and data, and implementing appropriate mitigation strategies.
• Apply tests and analyse results, documenting the actual results and comparing them to the expected results to identify any issues or defects.

What you'll be able to do

• Explain the fundamental concepts behind the internet
• Describe the history and purpose of the internet
• Know the technologies that enable communication across the internet
• Explain the technologies behind the World Wide Web
• Describe how to make information available on the World Wide Web
• Understand the additional services available on the internet
• Explain the function and use of additional internet services
• Understand the security implications of making information available on the internet
• Evaluate the risks associated with online information sharing

What you'll be able to do

• Understand the role of finance within the context of an organisation and its impact on decision-making
• Understand the value of recording financial management information for analysis and reporting purposes
• Understand how to create and manage budgets for the effective management of own area of operation

What you'll be able to do

• Use e-mail software tools and techniques to compose and send messages effectively
• Manage the use of e-mail software effectively to ensure efficient communication and organisation

What you'll be able to do

• Select and set up an appropriate connection to access the Internet
• Set up and use browser software to navigate webpages
• Use browser tools to search effectively and efficiently for information from the Internet
• Use browser software to communicate information online
• Develop and apply appropriate safety and security practices and procedures when working online

What you'll be able to do

• Understand the core principles of virtualisation and its benefits in IT infrastructure
• Manage complex virtualised environments, including resource allocation and performance optimisation
• Deploy vSphere solutions, including installation, configuration, and maintenance
• Administer vSphere enterprise components, ensuring security, availability, and scalability

What you'll be able to do

• Understand the fundamental principles of virtualisation technology and its benefits.
• Understand the key components of a data centre and their roles in a virtualised environment.
• Design a virtualisation environment that meets specific business requirements.
• Implement a virtualisation design, including configuring virtual machines and networks.

What you'll be able to do

• Understand website design concepts, including user interface (UI) design, user experience (UX) design, and accessibility principles.
• Design interactive websites that engage users and meet specific business objectives, incorporating elements such as forms, databases, and multimedia content.
• Implement interactive websites using appropriate technologies, such as HTML, CSS, JavaScript, and server-side scripting languages.
• Test interactive websites to ensure they function correctly across different browsers and devices, and that they meet accessibility standards.

What you'll be able to do

• Understand the functions and requirements of website hosting services.
• Upload and manage websites effectively, including content updates and maintenance.
• Improve website performance by optimising code, images, and other elements.
• Promote websites through various online marketing channels and techniques.

What you'll be able to do

• Create website structures using appropriate markup languages (e.g., HTML)
• Create website styles using appropriate styling languages (e.g., CSS)
• Use structures and styles effectively to produce well-organised and visually appealing websites
• Select appropriate website software tools for developing websites
• Use website software features to create multiple page websites
• Develop websites with multimedia elements, such as images, audio, and video
• Incorporate interactive features into websites, such as forms and animations
• Publish websites to a web server or hosting platform
• Test websites thoroughly to ensure functionality and compatibility
• Test websites across different browsers and devices
• Test websites for accessibility and usability

What you'll be able to do

• Understand the impact of Wide Area Networking (WAN) technologies on business operations and communication
• Design WAN infrastructures to meet specific organisational needs and performance requirements
• Implement WAN infrastructures, configuring network devices and services
• Manage WAN infrastructures, monitoring performance and troubleshooting issues

What you'll be able to do

• Understand how to plan and manage a client life cycle strategy
• Understand how to design a standard image
• Understand how to design client configurations
• Understand how to design a Windows 7 client deployment
• Understand how to design application packages for deployment

What you'll be able to do

• Identify the key architectural components of the Windows operating system.
• Design solutions utilising Windows operating system features.
• Monitor the performance and health of Windows systems.
• Analyse user mode processes and applications within Windows.
• Analyse kernel mode operations and drivers within Windows.
• Debug Windows systems to resolve issues and improve performance.

What you'll be able to do

• Enter and combine text and other information accurately within word processing documents
• Create and modify appropriate layouts, structures and styles for word processing documents
• Use word processing software tools and techniques to format and present documents effectively to meet requirements