537 Courses in Cardiff delivered Live Online

Duration 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Advanced Query Techniques Join inner outer (Left, Right, Full) Subqueries Simple Correlated Using the Exists Operator Tips for Developing Complex Queries Performing Set Operations Aggregating Results Using Group by Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) Inserting Data into Tables Updating Existing Data Deleting Records Truncating Tables Implementing Data Integrity with Transactions Beginning Explicit Transactions Committing Transactions Rolling Back Transactions User-Defined Functions Definition and Benefits of Use CREATE FUNCTION Syntax RETURN Clause and the RETURNS Statement Scalar vs. Table Functions Comparison with Stored Procedures Returning Scalar Values and Tables ALTER and DROP FUNCTION Stored Procedures Definition and Benefits of Use CREATE PROCEDURE Syntax Variables and Parameters Control of Program Flow ALTER and DROP PROCEDURE Implementation Differences Triggers Definition and Benefits of Use Alternatives (e.g., Constraints) CREATE TRIGGER Syntax Trigger Types 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables Event Handling and Trigger Execution ALTER and DROP TRIGGER Additional course details: Nexus Humans Advanced SQL Programming (TTSQL005) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Advanced SQL Programming (TTSQL005) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 4 Days 24 CPD hours This course is intended for This course is for IT Professionals with expertise in designing and implementing solutions running on Microsoft Azure. They should have broad knowledge of IT operations, including networking, virtualization, identity, security, business continuity, disaster recovery, data platform, budgeting, and governance. Azure Solution Architects use the Azure Portal and as they become more adept they use the Command Line Interface. Candidates must have expert-level skills in Azure administration and have experience with Azure development processes and DevOps processes. Overview Recommend solutions to minimize costs Recommend a solution for Conditional Access, including multi-factor authentication Recommend a solution for a hybrid identity including Azure AD Connect and Azure AD Connect Recommend a solution for using Azure Policy Recommend a solution that includes KeyVault Recommend a solution that includes Azure AD Managed Identities Recommend a storage access solution Design an Azure Site Recovery solution Recommend a solution for autoscaling Recommend a solution for containers Recommend a solution for network security Recommend a solution for migrating applications and VMs Recommend a solution for migration of databases This course teaches Solutions Architects how to translate business requirements into secure, scalable, and reliable solutions. Lessons include design considerations related to logging, cost analysis, authentication and authorization, governance, security, storage, high availability, and migration. This role requires decisions in multiple areas that affect an overall design solution. Design a Compute Solution Recommend a Solution for Compute Provisioning Determine Appropriate Compute Technologies Recommend a Solution for Containers Recommend a Solution for Automating Compute Management Design a Network Solution Recommend a Solution for Network Addressing and Name Resolution Recommend a Solution for Network Provisioning Recommend a Solution for Network Security Recommend a Solution for iInternete Connectivity and On-Premises Networks Recommend a Solution for Automating Network Management Recommend a Solution for Load Balancing and Rraffic Routing Design for Migration Assess and On-Premises Servers and Applications for Migration Recommend a Solution for Migrating Applications and VMs Recommend a Solution for Migration of Databases Design Authentication and Authorization Tips for Identity and Access Management Recommend a Solution for Multi-Factor Authentication Five Steps for Securing Identity Infrastructure Recommend a Solution for Single-Sign On (SSO) Recommend a Solution for a Hybrid Identity Recommend a Solution for B2B Integration Recommend a Hierarchical Structure for Management Groups Design Governance Recommend a Solution for using Azure Policy Recommend a Solution for using Azure Blueprint Design a Solution for Databases Select an Appropriate Data Platform Based on Requirements Overview of Azure Data Storage Recommend Database Service Tier Sizing Dynamically Scale Azure SQL Database and Azure SQL Managed Instances Recommend a Solution for Encrypting Data at Rest, Transmission, and In Use Select an Appropriate Storage Account Understanding Storage Tiers Recommend a Storage Access Solution Recommend Storage Management Tools Design Data Integration Recommend a Data Flow Recommend a Solution for Data Integration Design a Solution for Logging and Monitoring Azure Monitoring Services Azure Monitor Design a Solution for Backup and Recovery Recommend a Recovery Solution for Hybrid and On-Premises Workloads Design and Azure Site Recovery Solution Recommend a Solution for Recovery in Different Regions Recommend a Solution for Azure Backup Management Design a Solution for Data Archiving and Retention Design for High Availability Recommend a Solution for Application and Workload Redundancy Recommend a Solution for Autoscaling Identify Resources that Require High Availability Identify Storage Tpes for High Availability Recommend a Solution for Geo-Redundancy of Workloads Design for Cost Optimization Recommend Solutions for Cost Management Recommended Viewpoints for Minimizing Costs Design an Application Architecture Recommend a Microservices Architecture Recommend an Orchestration Solution for Deployment of Applications Recommend a Solution for API Integration Design Security for Applications Security for Applications and Services Recommend a Solution using Key Vault Recommend Solutions using Azure AD Managed Identities

Duration 5 Days 30 CPD hours Overview SDWAN Review Advanced Template Design and Troubleshooting Advanced Security Policies on vEdge and IOS-XE Platforms Advanced Local Policies on vEdge and IOS-XE Platforms Advanced Central Policies on vEdge and IOS-XE Platforms Advanced Troubleshooting of Policies on vEdge and IOS-XE Platforms In this Advanced Lab focused SDWAN Course, Students willExplore and Troubleshoot the initials environmentLearn Advanced Techniques to Deploy Templates with the theme of reusabilityDeploy and Troubleshoot Transport BridgingDeploy and Troubleshoot Routing including OSPF, BGP, EIGRPDeploy and Troubleshoot Multicast RoutingDesign, Configure, and Troubleshoot Advanced Security PoliciesDesign, Configure, and Troubleshoot Local PoliciesDesign, Configure, and Troubleshoot Application Aware RoutingDesign, Configure, and Troubleshoot Quality of ServiceDesign, Configure, and Troubleshoot Central Policies Including Hub Spoke, Full Mesh and Custom TopologiesDesign, Configure, and Troubleshoot Central Policies Including Service ChainingDesign, Configure, and Troubleshoot Central Policies Including Traffic Rules & CFLOW Cisco SD-WAN Overview Dashboard SD-WAN Architecture SD-WAN WAN Edges SD-WAN Controllers SD-WAN Fabric SD-WAN Advanced Settings Advanced Controller Settings Overlay and vEdge Recommended Settings Forward Error Correction (FEC) Packet Duplication System IP Design LTE Operation SD-WAN High Availability Controller High Availability Controller Scalability Active vManage, Backup Inactive vManage Clustering vManages Disaster Recovery SD-WAN Templates Template Overview Future Templates Device template using Future Templates Device template using CLI Templates Designing templates for Reusability Attaching Devices to Templates Bridging Transparent Bridging Bridging Template Configuration cEdge Bridging Template Configuration vEdge Bridging Template Configuration Monitoring Bridging Routing Protocols Static Routes Dynamic Routing Protocols Multicast Multicast Terms Requirements vEdge Multicast Support cEdge Multicast Support Multicast RPs Multicast Replicators PIM IGMP Network Optimization Optimization Overview TCP Optimization vEdge Optimization Requirements vEdge Optimization Implementation cEdge (IOS-XE) Optimization Requirements cEdge (IOS-XE) Optimization Implementation AppNAV Per Tunnel QoS Direct Internet Access (DIA) Overview SD-WAN Direct Internet Access (DIA) SD-WAN DIA Requirements SD-WAN Direct Internet Access Use Cases SD-WAN Direct Internet Access Design Components SD-WAN Direct Internet Access Design Considerations SD-WAN Direct Internet Access Failover Scenarios Cisco SD-WAN Direct Internet Access Monitoring Unified Communications Voice Integration in SD-WAN Voice Feature Templates Voice Policies IOS-XE UC Device Template SD-WAN Security Policy Authentication/Encryption/Integrity Firewall IPS (Snort) URL Filtering Web Layer Security Pairwise IPsec Keys SD-WAN Local Policy Policy Configuration Overview Policy Framework-Localized Policies Local Control Policy Local Control (Route) Policy Localized Control Policy Configuration Local Data Policy Configure Localized Data Policy for IPv4 SD-WAN Central Policy Policy Creation and Management Guidelines Centralized Data Policies Application Aware Routing Service Chaining Traffic Flow Monitoring with Cflowd Policy Construction Platform Support and Scalability SDWAN Migration Sequence of Migration Migration Planning DC/Hub Site Migration Branch/Spoke Site Migration Additional course details: Nexus Humans ADV-SDWAN-CT - Advanced Cisco SD-WAN Routing, Templates, Policy Configure, and Tshoot training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the ADV-SDWAN-CT - Advanced Cisco SD-WAN Routing, Templates, Policy Configure, and Tshoot course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Join Me For This 8 Week Qigong and Breathwork Online Course HARNESSING THE POWER OF THE BREATH The way we breathe affects everything we do, everything we think and everything we feel. It affects our sleep, our digestion, our immune system, our energy levels, our emotions, our ability to think clearly and our relationships, to name but a few. In this course we will be combining my passions of Qigong and Breathwork to help bring us into balance so we can move though Autumn into winter full of peace and vitality. Why Qigong and Breathwork? Qigong is breathwork (Qi is Breath), it is an amazing way of opening and clearing the body, of making space for our healthy energy to flow. It allows us to stay relaxed and receptive without forcing or pushing. It is easy to learn and naturally attuned to your individual body and how it wants to expand, release and recharge. Breathwork is simply bringing our conscious attention to our breath and is one of the most powerful ways we have to change our state at any given moment. In the course i will introduce you to eight different breath techniques to help you to breathe better. Commit to just 10mins a day and you’ll be amazed at the results you can achieve. Everyone is welcome to join the course no matter your experience. When: 8th October 2024 – 5th December Tuesday Evenings 6-7pm and Thursday mornings 9-9.30am (via Zoom) Dates: Tuesdays 6-7pm: October 8th, 15th, 22nd November 5th, 12th, 19th, 26th, December 3rd. Thursdays 9-9.30am: October 10th, 17th, 24th, November 7th, 14th, 21st, 28th December 5th. Price: £110 (Concessions £80: Super concession £60) What is included: Eight live 60min evening zoom classes Eight live 30min morning meditation zoom classes Access to replays of all classes so you can catch up in your own time. Learn a Qigong routine for healthy lungs Learn how to clear the meridian pathways for increased vitality Learn 8 new powerful breath practices Access to private Whats App group to share experiences and ask questions Weekly supporting material for home practice : – A Weekly video with a guided 10min Breath Practice – PDF – explanations of each practice – Key acupuncture points for self massage What will I get out of the course? Reconnect with your breath Learn how to improve your respiration Learn to regulate your own nervous system Access deeper body awareness Less physical tension Reduced pain Improved mental clarity Strengthened immune system Improved sleep Improved digestion Less stress and anxiety, depression and panic attacks Deepening meditation practice More energy Just Breathe Just Be

Duration 4 Days 24 CPD hours This course is intended for The course content is aimed at operators of devices running the Junos OS in a NOC environment. These operators include network engineers, administrators, support personnel, and reseller support personnel. Overview After successfully completing this course, you should be able to: Reduce the time it takes to identify and isolate the root cause of an issue impacting your network. Gain familiarity with Junos products as they pertain to troubleshooting. Become familiar with online resources valuable to Junos troubleshooting. Gain familiarity with Junos tools used in troubleshooting. Identify and isolate hardware issues. Troubleshoot problems with the control plane. Troubleshoot problems with interfaces and other data plane components. Describe the staging and acceptance methodology. Troubleshoot routing protocols. Describe how to monitor your network with SNMP, RMON, Junos Traffic Vision (formerly known as JFlow), and port mirroring. Become familiar with JTAC procedures. This instructor-led four-day course is designed to provide introductory troubleshooting skills for engineers in a network operations center (NOC) environment. Chapter 1: Course Introduction Course Introduction Chapter 2: Troubleshooting as a Process Before You Begin The Troubleshooting Process Challenging Network Issues The Troubleshooting Process Lab Chapter 3: Junos Product Families The Junos OS Control Plane and Data Plane Field-Replaceable Units Junos Product Families Lab: Identifying Hardware Components Chapter 4: Troubleshooting Toolkit Troubleshooting Tools Best Practices Lab: Using Monitoring Tools and Establishing a Baseline Chapter 5: Hardware and Environmental Conditions Hardware Troubleshooting Overview Memory and Storage Boot Monitoring Hardware-Related System Logs Chassis and Environmental Monitoring Lab: Monitoring Hardware and Environmental Conditions Chapter 6: Control Plane Control Plane Review System and User Processes Monitoring Routing Tables and Protocols Monitoring Bridging Monitoring the Address Resolution Protocol Lab: Control Plane Monitoring and Troubleshooting Chapter 7: Control Plane Protection Protection Overview DDOS Protection Loopback Filter Lab: Control Plane Monitoring and Troubleshooting Chapter 8: Data Plane ? Interfaces Interface Properties General Interface Troubleshooting Ethernet Interface Troubleshooting Lab: Monitoring and Troubleshooting Ethernet Interfaces Chapter 9: Data Plane ? Other Components Definition of a Data Plane Problem Data Plane Components Data Plane Forwarding Load-Balancing Behavior Firewall Filters and Policers Data Plane Troubleshooting Case Study Lab: Isolate and Troubleshoot PFE Issues Chapter 10: Staging and Acceptance Testing Initial Inspection and Power-on General System Checks Interface Testing Chapter 11: Troubleshooting Routing Protocols Troubleshooting OSPF Troubleshooting BGP Troubleshooting Routing Loops and Route Oscillation Lab: Troubleshooting Routing Protocols Chapter 12: High Availability High Availability Overview Graceful Routing Engine Switchover Graceful Restart Nonstop Active Routing and Bridging Unified In-Service Software Upgrade Chapter 13: Network Monitoring SNMP RMON Telemetry Flow Monitoring Lab: Monitoring the Network Chapter 14: vMX Troubleshooting vMX Overview Troubleshooting Lab: Monitoring vMX Chapter 15: JTAC Procedures Opening a Support Case Customer Support Tools The Content of a PR Transferring Files to JTAC Chapter 16: Automated Support and Prevention Overview Service Now Service Insight Lab: Automated Support and Prevention Additional course details: Nexus Humans JTNOC - Junos Troubleshooting in the NOC training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the JTNOC - Junos Troubleshooting in the NOC course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

WCNA training course description Wireshark is a free network protocol analyser. This hands-on course provides a comprehensive tour of using Wireshark to troubleshoot networks. The course concentrates on the information needed in order to pass the WCNA exam. Students will gain the most from this course only if they already have a sound knowledge of the TCP/IP protocols. What will you learn Analyse packets and protocols in detail. Troubleshoot networks using Wireshark. Find performance problems using Wireshark. Perform network forensics. WCNA training course details Who will benefit: Technical staff looking after networks. Prerequisites: TCP/IP Foundation for engineers Duration 5 days WCNA training course contents What is Wireshark? Network analysis, troubleshooting, network traffic flows. Hands on Download/install Wireshark. Wireshark introduction Capturing packets, libpcap, winpcap, airpcap. Dissectors and plugins. The menus. Right click. Hands on Using Wireshark. Capturing traffic Wireshark and switches and routers. Remote traffic capture. Hands on Capturing packets. Capture filters Applying, identifiers, qualifiers, protocols, addresses, byte values. File sets, ring buffers. Hands on Capture filters. Preferences Configuration folders. Global and personal configurations. Capture preferences, name resolution, protocol settings. Colouring traffic. Profiles. Hands on Customising Wireshark. Time Packet time, timestamps, packet arrival times, delays, traffic rates, packets sizes, overall bytes. Hands on Measuring high latency. Trace file statistics Protocols and applications, conversations, packet lengths, destinations, protocol usages, strams, flows. Hands on Wireshark statistics. Display filters Applying, clearing, expressions, right click, conversations, endpoints, protocols, combining filters, specific bytes, regex filters. Hands on Display traffic. Streams Traffic reassembly, UDP and TCP conversations, SSL. Hands on Recreating streams. Saving Filtered, marked and ranges. Hands on Export. TCP/IP Analysis The expert system. DNS, ARP, IPv4, IPv6, ICMP, UDP, TCP. Hands on Analysing traffic. IO rates and trends Basic graphs, Advanced IO graphs. Round Trip Time, throughput rates. Hands on Graphs. Application analysis DHCP, HTTP, FTP, SMTP. Hands on Analysing application traffic. WiFi Signal strength and interference, monitor mode and promiscuous mode. Data, management and control frames. Hands on WLAN traffic. VoIP Call flows, Jitter, packet loss. RTP, SIP. Hands on Playing back calls. Performance problems Baselining. High latency, arrival times, delta times. Hands on Identifying poor performance. Network forensics Host vs network forensics, unusual traffic patterns, detecting scans and sweeps, suspect traffic. Hands on Signatures. Command line tools Tshark, capinfos, editcap, mergecap, text2pcap, dumpcap. Hands on Command tools.

Sterile Compounding Preparations Course Overview: This Sterile Compounding Preparations course offers in-depth training on the procedures and techniques required for preparing sterile compounds. Covering essential topics such as universal precautions, the proper use of the Laminar Air Flow Hood (LAF), and the critical role of pharmacy math in compounding, the course provides learners with the foundational knowledge to excel in this specialised field. Emphasising safety, precision, and regulatory compliance, the course ensures that participants are equipped with the necessary skills to meet industry standards. Upon completion, learners will gain confidence in performing sterile compounding tasks and understanding the necessary processes, setting them on the path to a successful career in pharmaceutical preparation. Course Description: This comprehensive course dives deep into the science and procedures behind sterile compounding. Learners will explore critical topics such as universal precautions and the operation of the Laminar Air Flow Hood (LAF), understanding their role in preventing contamination. The course also covers the essential pharmacy math skills required for accurate measurements and compounding. A review of the entire sterile compounding process is included to reinforce the concepts taught throughout the course. Students will gain the knowledge and confidence to apply these practices in real-world settings, enhancing their ability to contribute to the pharmaceutical industry. This course is designed for those looking to specialise in sterile compounding and gain an essential understanding of the industry protocols and safety measures involved. Sterile Compounding Preparations Curriculum Module 01: Introduction Module 02: Universal Precautions Module 03: The Laminar Air Flow Hood (LAF) - 3 Lectures Module 04: Sterile Compounding Pharmaceuticals Demonstrations Module 05: Compounding Pharmacy Math BONUS: REVIEW OF THE STERILE COMPOUNDING PROCESS (See full curriculum) Who is this course for? Individuals seeking to specialise in pharmaceutical compounding. Professionals aiming to advance their skills in sterile compounding. Beginners with an interest in pharmaceutical preparation and safety. Pharmacy technicians or assistants looking to enhance their expertise. Career Path: Sterile Compounding Technician Pharmacy Technician in sterile compounding settings Pharmaceutical Manufacturing Specialist Healthcare Practitioner in clinical settings requiring compounding Pharmaceutical Researcher

Financial Analysis Course Overview The "Financial Analysis" course provides a comprehensive introduction to financial analysis, equipping learners with the knowledge and skills needed to interpret and evaluate financial statements. Covering key areas such as balance sheets, income statements, and cash flow analysis, this course enables learners to assess financial performance and make informed decisions. Whether you are starting your career in finance or aiming to enhance your existing knowledge, this course offers essential tools for financial analysis. Upon completion, learners will be able to analyse financial data effectively, understand the key financial indicators of businesses, and contribute to strategic financial decision-making. Course Description This course covers the fundamentals of financial analysis, providing in-depth insights into financial statements, including balance sheets, income statements, and cash flow statements. Learners will explore various financial reporting techniques, evaluate profitability, and develop the ability to conduct ratio and equity analysis. The course also delves into the applications and limitations of EBITDA and teaches learners to assess credit risks. By the end of the course, participants will have gained valuable skills in financial data interpretation, enabling them to assess financial health and contribute to strategic financial decisions in organisations. The learning experience combines theoretical knowledge with practical analytical skills to prepare learners for roles in finance and accounting. Financial Analysis Curriculum: Module 01: Introduction to Financial Analysis Module 02: The Balance Sheet Module 03: The Income Statement Module 04: The Cash Flow Statement Module 05: Financial Reporting Module 06: Analysing Profitability Module 07: The Applications and Limitations of EBITDA Module 08: Credit Analysis Module 09: Equity Analysis Module 10: Ratio Analysis (See full curriculum) Who is this course for? Individuals seeking to understand financial analysis Professionals aiming to enhance their financial reporting and decision-making skills Beginners with an interest in finance or accounting Business owners looking to improve their financial literacy Career Path Financial Analyst Accountant Credit Analyst Financial Consultant Corporate Finance Manager Business Intelligence Analyst Investment Analyst

Certificate in HVAC Fundamentals Course Overview The "Certificate in HVAC Fundamentals" provides a comprehensive introduction to the world of Heating, Ventilation, and Air Conditioning (HVAC) systems. This course is designed to give learners a strong foundation in the essential principles and concepts of HVAC technology. It covers the core aspects of heat flow, psychrometrics, HVAC systems, and their specific components. The practical value of this course lies in its ability to equip learners with the knowledge required to understand, evaluate, and manage HVAC systems efficiently. Upon completion, learners will have gained a well-rounded understanding of HVAC systems, enabling them to pursue further study or entry-level roles in the industry. Course Description The "Certificate in HVAC Fundamentals" explores the critical components and functions of HVAC systems in depth. Learners will cover topics such as heat flow, psychrometrics, and the various systems used for heating, cooling, and ventilation. The course also examines air conditioning systems, indoor air quality, and HVAC system selection. Through a structured learning experience, students will gain the skills needed to understand HVAC system specifications and how to maintain optimal system performance. By the end of this course, learners will be able to analyse system components, understand airflow principles, and select appropriate HVAC systems for different environments. The course is suitable for those looking to build a solid foundation for a career in the HVAC industry. Certificate in HVAC Fundamentals Curriculum Module 01: Introduction to Heating, Ventilation & Air Conditioning (HVAC) Module 02: Heat Flow Module 03: Psychrometrics Module 04: HVAC Systems Module 05: Heating Module 06: Air Conditioning Systems for HVAC Technicians Module 07: Ventilation and Indoor Air Quality Module 08: HVAC System Selection (See full curriculum) Who is this course for? Individuals seeking to understand HVAC systems. Professionals aiming to enhance their HVAC knowledge for career progression. Beginners with an interest in the HVAC industry. Anyone looking to enter the building systems or maintenance sectors. Career Path HVAC Technician Building Systems Engineer Energy Efficiency Consultant HVAC System Designer Facilities Maintenance Coordinator

Total SAGE Training (Sage 50 Accounts + Sage Payroll Training) Want to open the door to working in Finance and Accountancy Industry? Starting our Total Sage Training courses will enhance your career potentials and give you the skills and knowledge you need to get started in Finance and Accountancy Industry. Total Sage Training courses are combined with Sage 50 Accounts and Sage Payroll Training. You will receive a CPD Completion Certificate from Osborne Training once you finish the course. You also have an Option to attain Certificate from SAGE(UK) subject to passing the exams. What qualification will I gain for Sage Training Courses? CERTIFICATION FROM SAGE (UK) As Osborne Training is a Sage (UK) Approved training provider, you could gain the following qualifications provided that you book and register for exams and pass the exams successfully: Sage 50c Computerised Accounting Course (Level 1) Sage 50c Computerised Accounting Course (Level 2) Sage 50c Computerised Accounting Course (Level 3) Sage 50c Computerised Payroll Course (Level 1) Sage 50c Computerised Payroll Course (Level 2) Sage 50c Computerised Payroll Course (Level 3) Level 1 Working with Sage 50 Accounts Program Basics. Creating Account names, Numbers & Bank Payments Financials Bank Reconciliations Generating Customers Invoices Monitoring Customer Activity Generating Product Invoices & Credit Notes Compiling & Sending Customer Statements Creating Customer Receipts & Purchase Invoices Supplier Payments Managing Recurring Entries Generating Reports & Information The Active Set-Up Wizard VAT Changes. Level 2 An overview of the Sage program Entering opening balances, preparing and printing a trial balance Creating customer records Creating supplier records Setting up opening assets, liabilities and capital balances, Producing routine reports Checking data, Entering supplier invoices Posting error corrections, amending records Invoicing, generating customer letters, entering new products, checking communication history Banking and payments, producing statements, petty cash Audit trails, correcting basic entry errors, reconciling debtors and creditors Creating sales credit notes, Processing purchase credit notes Preparing journals Verifying Audit Trail Purchase orders, processing sales orders Processing Trial Balance Creating Backups Restoring data Writing-off bad debts Level 3 Creating a Chart of Accounts to Suit Company Requirements Sole Trader Accounts preparation The Trial Balance preparation Errors in the Trial Balance Disputed Items Use of the Journal Prepare and Process Month End Routine Contra Entries The Government Gateway and VAT Returns Bad Debts and Provision for Doubtful Debts Prepare and Produce Final Accounts Management Information Reports Making Decisions with Reports Using Sage The Fixed Asset Register and Depreciation Accruals and Prepayments Cash Flow and Forecast Reports Advanced Credit Control