1644 Architecture courses in Syston delivered Online

Course Overview The Computer Maintenance, PAT & Cyber Security course offers a comprehensive introduction to the essential components of modern IT systems, combining core knowledge in hardware setup, system troubleshooting, and security protocols. Designed to build foundational understanding as well as introduce advanced cybersecurity concepts, this course equips learners with the confidence to navigate today’s digital infrastructure. From building a computer to understanding network vulnerabilities, learners will explore a variety of modules that address both traditional and emerging technologies, including IoT and encryption. By the end of the course, students will have developed the skills to identify risks, support device performance, and understand secure systems architecture—essential for any role in technology-focused sectors. Course Description This course blends key topics across computer hardware maintenance, PAT (Portable Appliance Testing), and cyber security to prepare learners for a well-rounded understanding of IT system management. The curriculum begins with assembling and configuring computers, progressing into network security and advanced Windows troubleshooting. Learners are introduced to essential software tools and coding applications like C++ with OpenCV, and gain insights into the Internet of Things and encryption principles. Additionally, the course includes training in cyber security awareness, addressing the latest threats and preventative frameworks. With clear instructional guidance and structured content delivery, the course is suitable for learners aiming to understand technical environments and the protocols behind secure computing. It is ideal for those seeking career progression or looking to explore new opportunities in IT security, maintenance, or systems analysis. Course Modules: Module 01: Building Your Own Computer Module 02: Computer Networks Security from Scratch to Advanced Module 03: Computer Vision By Using C++ and OpenCV with GPU support Module 04: Advance Windows 10 Troubleshooting for IT HelpDesk Module 05: Portable Appliance Testing (PAT) Module 06: Internet of Things Module 07: Cyber Security Awareness Training Module 08: Encryption (See full curriculum) Who is this course for? Individuals seeking to understand IT maintenance and cybersecurity principles. Professionals aiming to broaden their knowledge of system configuration and data protection. Beginners with an interest in computer technology and digital safety. Employers looking to upskill their IT or facilities staff in security and device compliance. Career Path IT Support Specialist Systems Administrator Network Security Analyst Cyber Security Consultant Electrical Safety Compliance Officer Technical Services Coordinator

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type  

Develop Big Data Pipelines with R, Sparklyr & Power BI Course Overview: This course offers a comprehensive exploration of building and managing big data pipelines using R, Sparklyr, and Power BI. Learners will gain valuable insight into the entire process, from setting up and installing the necessary tools to creating effective ETL pipelines, implementing machine learning techniques, and visualising data with Power BI. The course is designed to provide a strong foundation in data engineering, enabling learners to handle large datasets, optimise data workflows, and communicate insights clearly using visual tools. By the end of this course, learners will have the expertise to work with big data, manage ETL pipelines, and use Sparklyr and Power BI to drive data-driven decisions in various professional settings. Course Description: This course delves into the core concepts and techniques for managing big data using R, Sparklyr, and Power BI. It covers a range of topics including the setup and installation of necessary tools, building ETL pipelines with Sparklyr, applying machine learning models to big data, and using Power BI for creating powerful visualisations. Learners will explore how to extract, transform, and load large datasets, and will develop a strong understanding of big data architecture. They will also gain proficiency in visualising complex data and presenting findings effectively. The course is structured to enhance learners' problem-solving abilities and their competence in big data environments, equipping them with the skills needed to manage and interpret vast amounts of information. Develop Big Data Pipelines with R, Sparklyr & Power BI Curriculum: Module 01: Introduction Module 02: Setup and Installations Module 03: Building the Big Data ETL Pipeline with Sparklyr Module 04: Big Data Machine Learning with Sparklyr Module 05: Data Visualisation with Power BI (See full curriculum) Who is this course for? Individuals seeking to understand big data pipelines. Professionals aiming to expand their data engineering skills. Beginners with an interest in data analytics and big data tools. Anyone looking to enhance their ability to analyse and visualise data. Career Path: Data Engineer Data Analyst Data Scientist Business Intelligence Analyst Machine Learning Engineer Big Data Consultant

Master React and Redux with our comprehensive App Development Training course. Learn to build dynamic web applications, manage state, and integrate with backend services like Firebase. Ideal for aspiring UI/UX developers and frontend developers. Enroll now to start your journey in app development!

**Neuroscience of Learning Basics - CPD Accredited Course - Free Certificate** Curious minds learn better—and that’s exactly what the Neuroscience of Learning Basics Course is all about. This course explores how the brain responds to learning, memory, focus, and motivation in a way that’s simple, sharp, and surprisingly interesting. Whether you're involved in education, training, coaching, or just love learning about how learning works, this course walks you through key ideas with clarity and depth—minus the jargon. You’ll get a solid grasp of how neurons communicate, what affects attention spans, and why certain methods help information stick. Backed by research and laid out in a friendly, no-nonsense format, this course gives your curiosity something to chew on—without drowning in theory. If you’ve ever wondered why some lessons click while others vanish into thin air, you’re in the right place. Learn the science behind how we learn—and have a bit of fun with it too. Key Features of Neuroscience of Learning Basics: This Neuroscience of Learning Basics Course is CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchase of Neuroscience of Learning Basics Course. Course Curriculum of Neuroscience of Learning Basics Course: Module 01: Introduction to Neuroscience and Learning Module 02: Basics of Neuroscience Module 03: Neuroplasticity and Learning Module 04: Cognitive Development and Learning Module 05: Attention and Focus Module 06: Emotions and Learning Module 07: Motivation and Reward Systems Module 08: Learning Disorders and Neurodiversity Module 09: Brain-Based Learning Strategies Learning Outcomes of Neuroscience of Learning Basics Course: Understand brain anatomy and functions in relation to learning processes. Explore neuroscience impact on adapting to new cognitive challenges. Analyse the role of emotions in shaping effective learning strategies. Gain insights into motivation and reward systems for enhanced learning. Recognize and address various learning disorders and neurodiversity challenges. Apply brain-based learning strategies for improved educational approaches. Accreditation This Neuroscience of Learning Basics course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this Neuroscience of Learning Basics course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Neuroscience of Learning Basics Aspiring educators seeking a deeper understanding of neuroscience principles in teaching. Parents keen on leveraging neuroscience insights to enhance their child's learning. Educational administrators aiming to implement brain-based strategies for curriculum improvement. Students interested in psychology, neuroscience, or related fields. Individuals in training and development roles seeking to refine learning methodologies of neuroscience. Career path Neuroscience of Learning Basics Educational Consultant Learning Support Specialist Child Psychologist Curriculum Developer Special Education Teacher Neuroscience Researcher Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Imagine transforming your city into a green oasis, where rooftops, balconies, and unused spaces become vibrant gardens, helping to tackle environmental challenges. In this course, you'll explore how urban gardening can be a key solution to creating more sustainable cities. With a focus on growing your own food in urban areas, we’ll delve into the methods, techniques, and tools needed to bring nature to the concrete jungle. Whether you have a tiny balcony or a larger space, the course will provide you with the insights to maximise your growing area and contribute to a greener environment. Urban gardening isn’t just about planting a few herbs in a pot; it's about rethinking how cities use space to support local food systems, improve air quality, and promote biodiversity. By understanding the fundamentals of soil health, crop rotation, and companion planting, you’ll gain knowledge to create thriving garden ecosystems right in your urban environment. The course covers everything you need to know, including sustainable gardening practices that conserve water, reduce waste, and increase food security. This isn't just gardening; it’s an investment in your city’s future. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to Urban Gardening Module 02: Planning an Urban Garden Module 03: Essential Gardening Techniques for Urban Environments Module 04: Container Gardening in Urban Spaces Module 05: Vertical Gardening and Green Walls Module 06: Edible Urban Landscapes Module 07: Urban Gardening in Limited Light Conditions Module 08: Rainwater Harvesting and Sustainable Irrigation Module 09: Urban Gardening and Biodiversity Module 10: Community Engagement and Advocacy for Sustainable Cities Learning Outcomes: Introduction to Urban Gardening: Grasp urban gardening fundamentals for sustainable green initiatives. Planning an Urban Garden: Develop strategic skills to plan and optimise urban green spaces. Essential Gardening Techniques for Urban Environments: Master urban-specific gardening techniques for thriving plants in city settings. Container Gardening in Urban Spaces: Explore effective container gardening methods tailored for urban environments. Vertical Gardening and Green Walls: Acquire expertise in vertical gardening, transforming urban landscapes with green walls. Urban Gardening and Biodiversity: Enhance urban spaces by fostering biodiversity through strategic gardening practices. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on transforming urban spaces into sustainable green paradises. Garden enthusiasts aspiring to elevate their skills within an urban context. Urban planners aiming to integrate greenery seamlessly into city development. Environmentalists committed to promoting biodiversity in urban landscapes. Community advocates eager to lead sustainable urban gardening initiatives. Career path Urban Landscape Designer Sustainable Agriculture Consultant Urban Biodiversity Specialist Green Infrastructure Planner Community Garden Coordinator Environmental Advocacy Coordinator Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Cloud Computing Essentials Overview Imagine accessing computing power as vast as the sky, scaling it up or down with the agility of a feather, and only paying for what you use. Cloud computing makes this dream a reality, revolutionizing the way we store, manage, and process data. This 'Cloud Computing Essentials' course is your launchpad into this transformative technology, empowering you to navigate the digital stratosphere with confidence. Unravel the mysteries of the cloud as we delve into its core principles and delve into its diverse service models. Explore the compelling reasons businesses are migrating to the cloud, discovering the cost-efficiency, scalability, and agility it offers. Compare and contrast public, private, and hybrid cloud deployments, understanding their unique strengths and suitability for different scenarios. Master key cloud concepts like Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and Software as a Service (SaaS), uncovering their functionalities and use cases. Grasp the economic advantages of cloud computing, including economies of scale and the shared responsibility model. By the end of this journey, you'll be equipped to harness the power of the cloud and elevate your career to new heights. Why You Should Choose Cloud Computing Essentials Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Cloud Computing Essentials is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Cloud Computing Essentials is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Cloud Computing Essentials Introduction 00:04:00 The Need for Cloud Computing 00:13:00 What is Cloud Computing - I 00:05:00 What is Cloud Computing- II 00:06:00 Benefits of Cloud Computing 00:09:00 CapEx Vs OpEx 00:03:00 What are Public Clouds 00:02:00 Characteristics of Public Cloud 00:01:00 What are Private Clouds 00:01:00 Characteristics of Private Cloud 00:02:00 What are Private Clouds 00:01:00 What is Hybrid Cloud 00:01:00 Characteristics of Hybrid Cloud 00:01:00 Review and What Next!! 00:01:00 What is Infrastructure as a service 00:04:00 Use cases of IAAS 00:02:00 What is Platform as a Service? 00:02:00 Use cases of PAAS 00:04:00 What is Software as a Service 00:02:00 Key Concepts and Terminology 00:06:00 Economies of Scale 00:01:00 What is Shared Responsibility model 00:09:00

Discover Ethereum blockchain development with our comprehensive course. From the fundamentals of Solidity to advanced topics such as NFTs and Truffle, we will gain practical skills through hands-on projects. Whether a beginner or an experienced developer, this course equips us with the tools and knowledge to excel in Ethereum blockchain development.

With expert guidance and easy-to-understand narration, this course gets you up and running with the SwiftUI framework. You will learn how to use the SwiftUI framework, its tools, and its technology to build applications with ease.

Embark on a transformative DevOps journey! This comprehensive course equips you with skills in Ansible, Docker, GitLab, backups, and more. Master the art of self-hosting your infrastructure, streamlining deployments, and boosting efficiency. Launch your DevOps career today and unleash the endless possibilities!