719 Courses delivered On Demand

Data speaks volumes—if you know how to listen. This course offers a clever route into the world of MySQL, showing you how structured data can turn into smart decisions. Whether you're sifting through figures, building dashboards, or deciphering patterns, understanding SQL isn’t just helpful—it’s essential. You’ll be guided through the foundations of MySQL with clarity and precision, making sense of tables, queries, joins, and more—all without the fluff or confusion. Designed with the analytical mind in focus, this course shines a light on how MySQL powers insights behind the scenes in data science and analytics. It's tailored for learners who prefer clarity over jargon and structure over noise. If you're curious about how databases work and how data fuels smart outcomes, this course is your ideal stepping stone—organised, engaging and purposefully built for those who appreciate logic and clean learning paths. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Course Curriculum: Section 01: Getting Started Introduction How to get course requirements Getting started on Windows, Linux or Mac How to ask great questions FAQ's What is Source Code? Section 02: SQL Server setting up Section Introduction MySQL Server Installation Connect MySQL Server Instance MySQL Workbench overview Download and Restore Sample Database Section 03: SQL Database basics Section Introduction Overview of Databases Creating Database SQL Data Types Column Data Types on Workbench Creating Table Overview of Primary and Foreign Key Primary Key Foreign Key Creating Temporary tables EER - Enhanced Entity Relationship Diagrams Section 04: SQL DML (Data Manipulation Language) Section Introduction Insert statement Update statement Delete statement Section 05: SQL DDL (Data Definition Language) Section Introduction CREATE table statement DROP statement ALTER statement TRUNCATE statement COMMENT in query RENAME table Section 06: SQL DCL (Data Control Language) Create Database user GRANT permissions REVOKE permissions Section 07: SQL Statement Basic Section Introduction SQL Statement basic SELECT Statement SELECT DISTINCT SELECT with column headings Column AS statement DASHBOARD Analytics Section 08: Filtering Data rows SELECT WHERE Clause - theory SELECT WHERE Clause - practical Section 09: Aggregate functions for Data Analysis Sum() Min()-Max() Section 10: SQL Data Analyticstatements Order By statement SELECT TOP 3 records BETWEEN command IN operator Search Data usingLIKE cards Section 11: SQL Group by statement Section Introduction Group by - theory Data Analytics with Group By HAVING statement Section 12: JOINS Overview of Joins What are Joins Inner join Left outer join Right outer join Union CERTESIAN Product or Cross Join Query Exercise Solution for Query Exercise Section 13: SQL Constraints Section introduction Check constraint NOT NULL constraint UNIQUE constraint Section 14: Views Creating Views Data Analytic Viewsfrom multiple tables Section 15: Advanced SQL Functions Section Introduction Timestamp Extract from timestamp Mathematical scalar functions String functions Advanced functions Sub Queries SELECT with calculations Section 16: SQL Stored procedures Create stored procedure Stored procedure with parameter Drop Procedure Section 17: Import & Export data Section Introduction Import .csv file Export Data to .csv file Section 18: Backup and Restore Database Section Introduction Creating Database backup Restoring Database backup Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). Who is this course for? This Learn MySQL from Scratch for Data Science and Analytics course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Learn MySQL from Scratch for Data Science and Analytics course is open to all, with no formal entry requirements. Career path Upon successful completion of The Learn MySQL from Scratch for Data Science and Analytics Course, learners will be equipped with many indispensable skills and have the opportunity to grab.

Ever stared at a website and thought, “How did they build that?” This course is your no-nonsense route to understanding the hows, whats and whys of web development—without needing a computer science degree or a background in tech. Whether you’re just curious or keen to reshape your digital future, we’ll walk you through HTML, CSS, JavaScript, and more—step by step, with clarity, purpose and the occasional chuckle where appropriate. Designed for complete beginners, this online course delivers the technical foundations of building websites from the ground up—clearly and without any fluff. By the end, you’ll understand how web pages come to life, how to structure content, and how styling and scripts bring everything together. No over-the-top jargon, no pressure—just a solid, well-paced approach to the world behind the screen. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Course Curriculum: Here is a curriculum breakdown of the Learn Web Development from Scratch course: Section 01: Introduction Introduction How to Get Course requirements Getting Started on Windows, Linux or Mac How to ask Great Questions FAQ's Section 02: HTML Introduction HTML Choosing Code Editor Installing Code Editor (Sublime Text) Overview of a Webpage Structure of a Full HTML Webpage First Hello World! Webpage Section 03: HTML Basic Heading tags Paragraph Formatting Text List Items Unordered List Items Ordered Classes IDs Comments Section 04: HTML Intermediate Images Forms Marquee Text area Tables Links Navbar - Menu HTML Entities Div tag Google Maps Section 05: HTML Advanced HTML Audio HTML Video Canvas Iframes Input Types Input Attributes Registration Form Contact Us Form Coding Exercise Solution for Coding Exercise Section 06: JavaScript Introduction What is JavaScript Hello World Program Getting Output Internal JavaScript External JavaScript Inline JavaScript Async and defer Section 07: JavaScript Basics Variables Data Types Numbers Strings String Formatting Section 08: JavaScript Operators Arithmetic operators Assignment operators Comparison operators Logical operators Section 09: JavaScript Conditional Statements If-else statement If-else-if statement Section 10: JavaScript Control Flow Statements While loop Do-while loop For loop Coding Exercise Solution for Coding Exercise Section 11: JavaScript Functions Creating a Function Function Call() Function with parameters Section 12: JavaScript Error Handling Try-catch Try-catch-finally Section 13: JavaScript Client-Side Validations On Submit Validation Input Numeric Validation Section 14: Python Introduction Introduction to Python Python vs Other Languages Why It's Popular Command Line Basics Python Installation (Step By Step) PyCharm IDE Installation Getting Start PyCharm IDE First Python Hello World Program Section 15: Python Basic Variables Data Types Type Casting User Inputs Comments Section 16: Python Strings Strings String Indexing String Slicing String Built-in Functions Formatting String (Dynamic Data) Section 17: Python Operators Arithmetic Operators Assignment Operators Comparison Operators Logical Operators AND Operator OR Operator NOT Operator Booleans Section 18: Python Data Structures Arrays in Earlier Lists Add List Items Remove List Items Sort Lists Join Lists Tuples Update tuples Join tuples Dictionaries Add Dictionary Items Remove Dictionary Items Nested Dictionaries Sets Add Set Items Remove Set Items Join Set Items Section 19: Python Conditional Statements If Statement If-else Statement If-elif-else Statement If Statement Coding Exercise Section 20: Python Control Flow Statements Flow Charts While Loops Statement For Loops Statement The range() Function Nested Loops 2D List using Nested Loop Section 21: Python Core Games Guessing Game Car Game Section 22: Python Functions Creating a Function Calling a Function Function with Arguments Section 23: Python args, KW args for Data Science args, Arbitary Arguments kwargs, Arbitary Keyword Arguments Section 24: Python Project Project Overview ATM Realtime Project Course Assessment To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%. When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). Who is this course for? This Learn Web Development from Scratch course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Learn Web Development from Scratch course is open to all, with no formal entry requirements. Career path Upon successful completion of the Learn Web Development from Scratch Course, learners will be equipped with many indispensable skills and have the opportunity to grab.

Stepping into the world of personal protection requires more than just a sharp suit and a stern look—it demands confidence, discretion, and the ability to anticipate trouble before it even crosses the street. Our Bodyguard Training course is crafted for those who are serious about understanding the foundations of professional close protection, threat awareness, risk management, and security protocols. Whether you're eyeing a future in private security or simply keen to broaden your understanding of this high-responsibility role, this course delivers solid theoretical knowledge to get you on track. From managing secure environments to understanding the psychology of potential threats, this training dives into the essentials of operating with a calm head and sharp eyes. Learn about situational awareness, surveillance tactics, and the core duties of a professional bodyguard—all from a flexible, online learning format. No fluff, no overblown promises—just straight-talking, well-organised training that respects your time and your goals. Meet the Accreditation The CPD Certification Service (CPD QS) assures the Bodyguard Training course training and learning activities are relevant, reliable, and upto date. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Course Curriculum: Here is a curriculum breakdown of the Bodyguard Training course: Module 01: Introduction to Bodyguard Training Who Is a Bodyguard? Roles and Responsibilities Close Protection in the UK What You Need to Become a Bodyguard How to Become a Professional Bodyguard Training RequirementsQualities You Must Possess Conflict Management Interpersonal Skills Module 02: Personal Security Definition of Personal Security Responsibility for Own Security Security Commensurate with Threat Constant Awareness Limiting Information Patterns and Habits Briefing the Principal Home Security Advice Module 03: Laws and Legislation UK Licensing The Security Industry Authority (SIA) Standards in Training Performance Criteria Range Statement Knowledge Criteria Core Competency Training Module 04: Threat Assessment and Risk Management Threat Assessment Why Do You Need Threat Assessment? Salting the Step Types of Threat Assessment Threat Pyramid Attentional Control Profiling Risk Assessment Motivation of Possible Attackers Possible Dangers Module 05: Operational Planning Preliminaries or Task Ground Situation Mission Execution Service Support Command and Signals The Close Protection Team Security Objectives Module 06: Behavioural Intelligence Identifying the Human Danger Factor Protective Intelligence Investigation Intelligence Analysis Psychological Perspectives Identifying the Dangerous Person in a Crowd Assessments Module 07: Anti-Ambush Drills Ambush Attack Fatal Mistakes Basic Principles Anti-Ambush Drill Techniques Stationary Cut-Off (Roadblock)Defensive TacticsTwo Car DrillsBlocked Front and RearVIP Vehicle DisabledRammingKerb JumpMotorcycle Attacks Module 08: Searching Techniques Efficient Searching Search Routine Searching People Bag Searches Hiding Places on a Person Effectively Searching Premises Degrees of Premises Search Module 09: On Foot Protection Foot Protection Alertness Arc of Vision Options to Consider in Foot Formation (Regarding Possible Threat Situations) Body Protection Formation Solo BodyguardTwo-Man TeamThree-Man TeamFour-Man TeamOpen Formation (Box)Close Formation (Box)Diamond FormationBox FormationSeven Man Circle FormationFence Line Formation MovementMoving Between Two Buildings via Corridors or PassagewaysMoving in Escalators, Malls, Office, Buildings, Airports etc.StaircasesLifts Module 10: Physical Intervention What Is Physical Intervention? Non-Restrictive Physical Intervention Restrictive Physical Intervention When Is Physical Intervention Necessary? Physical Intervention Training Different Types of Physical Intervention Risks of Physical Intervention Module 11: Vehicle Escort Procedures General Rules Choice of Vehicle Safety on the Road Two Car Drills Speed Convoy Control Laying Procedure Additional Vehicles Communication Module 12: Route Reconnaissance Introduction Security Considerations in General Principles of Route Selection and Planning Points of Vulnerability Checking the Route Thoroughly Targets at High Risk Looking for Communication Gaps Close Protection Drivers Diver Training Module 13: Surveillance and Basic Anti Surveillance Techniques What Is Surveillance? Observation Levels of Awareness Gathering and Controlling Information Electronic Surveillance Mobile Surveillance PreparationSurveillance VehicleConcealment TechniquesFoot Following The Urban Observation Post (OP) Module 14: Firearms and Explosive Handling How Guns Work Shooting Techniques Anatomy of a SlingHow to Attach a Rifle SlingHow to Adjust a SlingTransition from a Shoulder Carry to Solid Standing Shooting Position Gun Safety Tips Bomb Protection and Evacuation Explosive Search Improvised Explosive Devices (IEDs) Module 15: Protectee Variations VIP Protection Family Protection Details SpouseChildren to Age TwelveTeenagers Module 16: Medical Emergency Assistance Medical Emergencies Primary Survey AirwayBleedingCirculationShock Secondary Survey Rescue Breathing Resuscitation Control of Bleeding Treatment for Shock Choking Heart Attack Stroke Burns Medical Kit Module 17: How COVID-19 Affected Close Protection Services COVID-19 and the Guarding Industry How Close Protection Works in Practice? Guarantee Your Safety with Close Protection Services Inspection in Advance Making Advance Arrangements Defence Responsibilities Course Assessment To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%. When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by The CPD Certification Service Who is this course for? This Bodyguard Training course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Bodyguard Training course is open to all, with no formal entry requirements. Career path Upon successful completion of the Bodyguard Training Course, learners will be equipped with many indispensable skills and have the opportunity to grab.

Introduction to Applied Accounting Course Overview The Introduction to Applied Accounting course is the perfect starting point for anyone looking to build a strong foundation in the world of accounting. Covering everything from basic accounting principles to financial reporting, management accounting, and cost analysis, this course offers a well-rounded view of real-world accounting practices. You'll explore key topics like the accounting cycle, double-entry bookkeeping, balance sheets, cash flow management, working capital, and even cost accounting techniques. Whether you're aiming to kickstart a new career or sharpen your skills for business success, this course provides essential knowledge delivered in an easy-to-follow and practical way. With businesses increasingly relying on accurate financial data to drive decisions, there's never been a better time to master the fundamentals of accounting and open new career opportunities! Extra Included: Free Course Included: Basic of Accounting Lifetime Access Free Student ID Card Learning Outcome Understand the core concepts and principles of accounting. Master the accounting cycle and double-entry system. Analyse financial statements including balance sheets and income statements. Explore key financial ratios to assess business health. Manage working capital, liquidity, and cash flows. Gain insights into cost accounting, budgeting, and financial reporting. Identify the limitations of accounting systems and recognise intangible assets. Understand internal and external auditing processes. Who is this Introduction to Applied Accounting Course for? This course is ideal for anyone interested in developing a solid foundation in accounting. It's perfect for beginners considering a career in finance, small business owners managing their own accounts, professionals looking to refresh or formalise their knowledge, and students planning to pursue further studies in accounting or business. Entry Requirements There are no formal prerequisites for this course. It is open to anyone with an interest in British Sign Language, particularly those who have completed a basic BSL course or have prior exposure to the language. A foundational understanding of BSL is beneficial to get the most out of the advanced content. Accredited Certification After successfully completing the course, you can get a UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. For the PDF certificate, you’ll need to pay £9.99. You can get the hard copy for 15.99, which will reach your doorstep by post.

Try Grow with this taster session! We've extracted a snippet of module 1 to give you a flavour for how our CPD programme works. Give it a try! Comprehensive, inclusive and accessible CPD for EAL teaching – designed for all educators.   At FlashAcademy®, we believe in a whole-school approach to EAL teaching, empowering every educator to contribute to the success of multilingual learners.  Our CPD programme provides:  Practical knowledge and evidence-based strategies. Resources to reflect, refine, and grow your school’s EAL provision. Actionable tools designed by experienced teachers and EAL specialists who understand the challenges of teaching multilingual learners. With real-life context learning, you’ll gain the skills to deliver impactful teaching and help your EAL students thrive.  About Grow with FlashAcademy®  Developed in collaboration with EAL Inclusive, we have created a comprehensive CPD journey for educators. Whether you’re new to EAL or looking to refine your strategies, Grow with FlashAcademy® offers flexible, on-demand learning.  What’s included?  A blend of video lessons, interactive content and a downloadable reflection journal. On-demand access via Cademy so you can learn at your own pace. Expert virtual drop-in sessions to connect with EAL specialists and ask your questions. Modules designed for practical implementation in schools. Why Grow with FlashAcademy®?  The challenge  EAL coordinators and practitioners often highlight the growing gap in whole-school teaching support for EAL provision. With budget constraints shifting responsibility to classroom teachers, the need for accessible, high-quality CPD has never been greater.  The solution  Grow with FlashAcademy® bridges this gap by offering a blend of online training and expert-led support. Developed with insights from leading EAL experts, our programme addresses the challenges schools face today. We’re creating meaningful change to equip educators with the tools they need to succeed.  Programme tiers We have created three tiers, you can purchase just one tier or a mix depending on your existing knowledge and requirements. Tier 1: Foundations of EAL pedagogy  Tier 2: Advanced pedagogy and assessment (Coming in 2025)  Tier 3: Whole-school systems and strategy (Coming in 2025)  Each tier includes 6 modules (60–90 minutes each), providing over 18 hours of evidence-based CPD.  How it works  1) Learn  Complete each module at your own pace. We recommend completing two modules per term to allow time for the following steps. 2) Reflect  Use the downloadable reflection journal to evaluate your learning and its impact. 3) Implement  Trial strategies in your classroom. 4) Connect  Join one live virtual drop-in session per tier to ask an EAL expert for advice and support.  Meet the experts  Our network of passionate EAL practitioners are ready to support your journey with actionable insights and proven strategies. These experts are an integral part of our mission to drive wider change in EAL provision.  Speakers in this tier include:  Anna Leaman, EAL Specialist and Director, EAL Inclusive. Anna is our programme leader, she'll be your guide throughout the programme. Chris Woodhams, Assistant Campus Principal, OneSchool Global. Soofia Amin, Assistant Head Teacher and Specialist Lead in Education for Multilingualism at Kensington Primary. Ready to get started?  Enrol in Grow with FlashAcademy®. Start building your expertise and refining your school’s EAL action plan today. 

Counselling provides lucrative career opportunities to all kinds of people. You can find positions at your current workplace as a counsellor or even find a new job. Take this course to grasp the fundamental concepts of counselling.

Enhance your professional skills in Health & Care with our Mandatory Refresher Training. Covering critical areas from First Aid to Mental Health, this training is designed to update and deepen your knowledge in Health Care settings. Ensure compliance and excellence in Care with our comprehensive course offerings. Learning Outcomes Administer effective First Aid as a Health Care professional. Apply specialised paediatric First Aid techniques in Care settings. Understand comprehensive Care Certificate standards for Health & Care. Advance in Health & Care with a Level 3 Diploma in Health & Social Care. Fulfill Duty of Care obligations with updated practices. Enhance communication within Health Care settings. Manage information securely and efficiently in Care environments. Implement robust infection control protocols in Health & Care. Promote equality and inclusion within Care settings. Adopt person-centred approaches to improve Care quality. Address mental health issues with confidence in Health Care. This Mandatory Refresher Training Bundle comes up with the following courses:Course 01: First Aid at Work Essentials of First Aid in Health & Care: Equip Health Care professionals with the skills necessary to respond to emergencies effectively. Course 02: Paediatric First Aid Specialised First Aid for Children: Focus on paediatric emergencies and preventative measures in Care settings. Course 03: Care Certificate Foundations of Professional Care: Standardized training fulfilling the Care Certificate requirements to ensure high-quality Health & Care services. Course 04: Level 3 Diploma in Health & Social Care Advanced Practices in Health & Care: Enhance your qualifications with advanced knowledge crucial for Health & Care professionals. Course 05: Duty of Care Ethical and Legal Practices in Care: Understand and apply Duty of Care to safeguard and promote the interests of those receiving Care. Course 06: Communication in Care Settings Effective Communication Techniques: Master communication skills to improve interactions and understanding within Health Care environments. Course 07: Information Handling in Care Settings Confidentiality and Data Management: Training on secure handling of information in compliance with Care standards. Course 08: Infection Prevention and Control in Care Settings Maintaining Safe Care Environments: Strategies to prevent and control infections, critical for patient and staff safety in Health Care settings. Course 09: Equality and Inclusion in Care Settings Promoting Diverse and Inclusive Care: Address and foster equality and inclusion practices within Health Care facilities. Course 10: Person Centred Approaches in Care Settings Individualized Care Strategies: Emphasize the importance of person-centred Care to enhance patient satisfaction and outcomes. Course 11: Mental Health Mental Health Awareness and Support: Equip staff with the skills to recognize and address mental health issues effectively in Health & Care settings.

Your first steps in Floorwork through our Smart Methodology.

The course outlines some easy-to-implement tips to help you get a better night's sleep. These range from changing your sleeping environment and implementing a consistent routine, to being physically active every day. Course description This bite-size course can help identify the causes of sleep issues and offer practical strategies to address them. It raises awareness of the impact of sleep on emotional and physical well-being, memory, learning, and success. Sleep is a vital building block in the foundations of health and well-being, and the course aims to empower you with knowledge on a broad range of sleep issues. Who is the course for? Overall, this sleep awareness course is designed to educate and provide tools for better sleep management, which can lead to improved mental, emotional, and physical health. What’s the value of this course? By understanding the importance of sleep and learning how to improve sleep quality, individuals can make informed decisions that enhance their overall health and well-being. In essence, the value of a sleep awareness course extends beyond just personal health; it has implications for workplace productivity, healthcare costs, and public health education.