6191 Courses in Cardiff delivered On Demand

SQL programming is the programming that manages data in the Relational Database Management System. The Mastering SQL Programming course aims to teach you how to optimise the accessibility and maintenance of data with the Structured Query Language SQL programming language, and gain a solid foundation for building, querying, and manipulating databases. This SQL Programming course will provide you the standard language, but also identifies deviations from the standard in two widely-used database products, Oracle and Microsoft SQL Server. You will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful SELECT, INSERT, UPDATE and DELETE statements. Learn what SQL is and how to create, manipulate, and create reports from database tables from the best SQL courses. Important concepts associated with relational databases will be covered. You will run SQL commands to create database tables and define data element types. Enrol Now to start boosting your SQL skills! Key topics to be covered Stored Procedures Returning Data Testing and Debugging SQL CLR Code Dynamic SQL Column sets Learning Outcomes Know the tools for creating views with examples, columns and indexed views, creating stored procedures, testing and debugging. Learn how to create triggers, execute with result sets, use inline table valued functions, and use the multi statement function. Learn about transaction concepts, explicit transactions, and structured error handling. Understanding of different functions, data tools, database management, comparing database schemas, offline database management and much more. Master partitioning, managing partitions, querying partitions, complex querying, table expressions, efficient queries and complex queries. Why Choose this Course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of- Video lessons Online study supplies Mock tests Multiple-choice evaluation Assignment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this course for? Anyone who wants to gain extensive knowledge, potential experience and expert skills in SQL programming. Those who have an interest in production planning. Students from any academic backgrounds

Security Management Diploma - CPD Accredited Course In today’s world, securing people, property and information isn’t just a role—it’s a necessity. From office buildings to online networks, the demand for knowledgeable individuals in security management continues to grow. This CPD Accredited Security Management Diploma gives you the confidence to understand modern risks, assess threats, and manage situations with clarity. Whether it’s about preventing losses, managing people, or preparing emergency plans, this course is tailored to guide you through essential strategies with ease. If you’ve got an interest in protection, planning and leadership, this is where theory meets real responsibility—without needing to leave your desk. With security concerns shifting rapidly, employers look for those who stay ahead of threats and think smart. This course covers key areas including risk assessment, surveillance basics, access control, emergency procedures, and conflict management. It’s serious knowledge, served in a structured and accessible way—no jargon, no fluff. Learn it all online, at your own pace, and gain insights that are relevant across industries from retail and logistics to corporate offices and public services. Course Curriculum: Module 01: Introduction to Security Management Module 02: Organisational Security Management Module 03: Security Risk Analysis and Risk Reduction Module 04: Physical and Information Security Protection Module 05: Business Resilience and Crisis Management Module 06: Cyber Security and Fraud Prevention Module 07: Security Investigations and Threat Awareness Module 08: Laws and Regulations Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Security Management Diploma - CPD Accredited course, you will qualify for the CPD Quality Standards certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality StandardsService Who is this course for? The Security Management Diploma - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Security Management Diploma - CPD Accredited training.

Working alone doesn’t mean being left without support. This CPD Accredited Lone Worker Training Course is designed to help professionals understand the key safety, legal, and communication considerations when working remotely, off-site, or without direct supervision. Whether you're visiting clients, managing field work, or simply working from a location where colleagues aren’t nearby, this course offers essential knowledge to help you stay alert, informed and confident in your role. With a touch of clarity and just the right amount of dry wit, this course gets straight to the point: safety matters, and knowing how to handle yourself in isolated working environments is no longer optional. You’ll explore risk awareness, situational judgement, emergency response, and communication strategies—all presented in a sharp, digestible format that respects your time and intelligence. Whether you're self-employed, part of a larger organisation, or somewhere in between, this training gives you the know-how to stay safe and sensible while flying solo. Course Curriculum: Module 01: Basics of Lone Working Module 02: Legal Duties of Lone Working Module 03: Rights and Responsibilities in Lone Working Module 04: Risk Assessment and Control Measures Module 05: Monitoring and Supervision Module 06: Training and Development Module 07: Problems that Affect Lone Workers Module 08: Practical Tips to Avoid Violence Module 09: Personal Safety Module 10: Safe Workplace Arrangements Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Lone Worker Training - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards Who is this course for? The Lone Worker Training - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Lone Worker Training - CPD Accredited training.

Understanding explosive atmospheres isn't just for chemists in lab coats—it's vital knowledge for any workplace handling flammable substances. This online DSEAR Training course unpacks the essentials of the Dangerous Substances and Explosive Atmospheres Regulations 2002 with clarity and precision. Whether you're overseeing operations or managing risk assessments, this CPD-accredited programme is built to sharpen your awareness of potential hazards and guide you through the control measures expected in today's regulatory environment. Delivered entirely online, the course offers flexible learning with no compromise on quality. From defining hazardous substances to exploring key safety responsibilities, learners gain insights into how to reduce risks and promote safer working conditions. With clear explanations and structured learning modules, it’s a smart choice for professionals in sectors such as manufacturing, engineering, and facilities management. No fuss, no fluff—just the essentials presented in a way that actually sticks. Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with DSEAR Safety Trainer profession Free Assessment to test learners' knowledge and skills Accredited learning and widely recognised certificate from reputed CPD Accreditation Bodies Course Curriculum: Introduction to DSEAR ATEX and Explosive Atmospheres General Safety Safe Working with Flammable Substances Equipment and Protection System Risk Assessment Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the DSEAR Training - CPD Accredited course. For each test, the pass mark will be set to 60%. CPD 10 CPD hours / points Accredited by The CPD Certification Service Who is this course for? The DSEAR Training - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our DSEAR Training - CPD Accredited training.

Designed for school staff navigating the daily challenges of pupil behaviour, this CPD-accredited online course offers clear, structured guidance on how to respond calmly and safely in situations where positive handling may be required. Delivered entirely online with flexible access, this course is ideal for teachers, teaching assistants, SEN support staff, and senior leadership teams who want to develop a confident, legally informed approach to managing conflict and preventing escalation. Rather than overcomplicating things, this course focuses on what matters: understanding appropriate intervention, the legal framework, and how to protect both pupils and staff in high-pressure scenarios. With a straight-talking tone and accessible format, you’ll gain the confidence to make well-judged decisions under pressure—without needing to wade through unnecessary fluff. No travel, no awkward role play, just relevant knowledge you can absorb at your own pace—then apply with confidence in your school setting. Course Curriculum: Module 01: Introduction to Positive Handling in School Module 02: A Serious Business Module 03: The Aggression Curve Module 04: Trauma and Disability Management Module 05: The SCARF Model Module 06: Government Advice and Guidance Module 07: Making Decisions: Duty of Care Module 08: The Law Module 09: Physical Intervention and Restraint Module 10: Screening, Searching and Confiscation Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Positive Handling in Schools - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards Who is this course for? The Positive Handling in Schools - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Positive Handling in Schools - CPD Accredited training.

In today’s fast-paced business environment, effective material management is a cornerstone for operational efficiency. This CPD Accredited course offers a comprehensive exploration of the core principles and best practices involved in managing materials within any organisation. From procurement and inventory control to forecasting and distribution, you will gain valuable insights that will directly contribute to streamlining operations and reducing costs. Designed for professionals across various industries, this course delves into key aspects that will enhance your ability to manage materials with precision and foresight. By completing this course, you’ll build a solid foundation in material management, learning how to optimise stock levels, improve supplier relationships, and implement strategies that contribute to a smoother supply chain. Whether you’re looking to improve processes within your current role or looking to advance your career, this course offers a flexible and effective approach to mastering material management. With its clear structure and in-depth content, it provides the knowledge you need to navigate the complexities of this vital area with confidence. Course Curriculum: Module 01: Introduction to Material Management Module 02: Purchasing and Supply Chain Management Module 03: Inventory Management, Planning and Control Module 04: Stores Management and Control Module 05: Forecasting Module 06: Material Requirements Planning Module 07: Materials Handling Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Material Management - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Material Management - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Material Management - CPD Accredited training.

The Medical Receptionist – CPD Accredited Course is tailored for individuals keen to develop their career in the healthcare sector. It offers a thorough understanding of the crucial tasks involved in managing front-of-house operations in medical environments, including patient interaction, appointment scheduling, and maintaining professional standards. This course provides a solid foundation for those who wish to work in medical practices, clinics, or healthcare facilities, without the need for in-person attendance. Throughout the course, learners will explore administrative skills, customer service excellence, and the essential organisational techniques that ensure a smooth-running practice. With accreditation from CPD, this course offers valuable insights into the duties of a medical receptionist, preparing learners for a variety of roles within the healthcare industry. Whether you're aiming to enter the field or elevate your existing knowledge, this course is a practical choice for career advancement. It ensures that you acquire the right knowledge to handle both day-to-day tasks and the more specific challenges encountered in a busy healthcare setting. Course Curriculum: Module 1: Introduction to Healthcare and Receptionists Module 2: Organise Schedules Module 3: Maintaining Medical Records Module 4: Effective Filing Systems in Medical Offices Module 5: Confidentiality in a Medical Environment Module 6: Time Management Module 7: Medical Jargon and Terminology Module 8: Maintaining Workplace Safety Module 9: Information Technology in Health Care Module 10: Legal aspects and Ethics Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Medical Receptionist - CPD Accredited course, you will qualify for the CPD Certification Service (CPD UK) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Certification Service Who is this course for? The Medical Receptionist - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Medical Receptionist - CPD Accredited training.

The Digital Product Management - CPD Accredited Course is designed to equip learners with the strategic mindset and techniques needed to manage digital products in today's fast-paced market. In an era where technology drives business success, this course offers a deep dive into the methodologies and frameworks used by top-tier product managers. Whether you're aspiring to break into the field or aiming to refine your skills, this course ensures you gain a robust understanding of digital product lifecycles, from ideation to launch and beyond. Delivered entirely online, this course will guide you through the latest tools, trends, and challenges in digital product management. The curriculum blends theory with insight into current industry practices, focusing on the strategies required to steer digital products toward success. With a strong emphasis on data-driven decision-making, you’ll be able to navigate the complexities of user experience, market research, and cross-functional collaboration. If you’re looking to master the art of managing digital products effectively, this course is the perfect choice for you. Enrol with confidence, train with Training Express and supercharge your career in no time. Course Curriculum: Module 01: Basics of Digital Product Management Module 02: Understanding Market and Customers Module 03: Strategy Development Module 04: Roadmap Module 05: Development Methodologies Module 06: Analytics and Metrics Module 07: Marketing Module 08: Legal Aspects Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Digital Product Management - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Digital Product Management - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Digital Product Management - CPD Accredited training.

Welcome to 'Python Programming for Non Programmers Level 5,' a course specially designed for those new to the world of coding. This program starts with a comprehensive introduction to Python, a versatile programming language favored in numerous fields. Progressing to the second unit, participants will familiarize themselves with the initial steps of Python programming, setting a strong foundation for future learning. The course then advances to conditional branching in Python, an essential skill for logical problem-solving in coding. A highlight of this course is the practical project: building the game 'Rock Paper Scissors'. This engaging task not only consolidates learning but also adds a fun element to the process. The curriculum further includes critical topics like string operations, date and time functionalities, and the nuances of file handling in Python. Learners will navigate through the complexities of Python data structures-tuples, lists, and dictionaries-and learn to craft user functions, enhancing their coding capabilities. The course also covers email automation, ingenious import tactics, interfacing with operating systems, and handling exceptions with finesse. Furthermore, learners will get hands-on experience with package installation, scheduling tasks in Python, and managing databases using SQLite. The course wraps up with insights on running Python programs via command prompt and Jupyter Notebook, ensuring learners are well-equipped for real-world applications. Learning Outcomes Acquire foundational knowledge and setup skills in Python programming. Master conditional branching for effective problem-solving in code. Complete a practical coding project to solidify Python skills. Learn essential Python operations, including string handling and file management. Explore and apply advanced Python concepts for real-world applications. Why choose this Python Programming for Non Programmers Level 5 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Python Programming for Non Programmers Level 5 course for? Beginners eager to learn Python from scratch. Non-technical professionals desiring to add coding skills to their portfolio. Educators keen to integrate Python into their teaching methodologies. Businesspersons interested in understanding coding fundamentals for tech-based solutions. Enthusiasts exploring programming as a new hobby or career path. Career path Entry-Level Python Programmer: £25,000 - £40,000 Python-Enabled Data Analyst: £28,000 - £45,000 Python Automation Engineer: £30,000 - £50,000 Technical Support Analyst with Python Skills: £22,000 - £35,000 Python Web Developer: £26,000 - £42,000 Quality Assurance Analyst with Python Expertise: £24,000 - £38,000 Prerequisites This Python Programming for Non Programmers Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Python Programming for Non Programmers Level 5 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Unit 01: Introduction to Python Programming Section 01: Course Introduction 00:02:00 Unit 02: Getting Started with Python Section 01: Software Installation 00:02:00 Section 02: Hello World Program 00:06:00 Section 03: Input and Output 00:07:00 Section 04: Calculating Average of 5 Numbers 00:03:00 Unit 03: Conditional Branching with Python Section 01: If Loop In Python 00:06:00 Section 02: Program Using If Else part 1 00:03:00 Section 03: Program Using If Else part 2 00:08:00 Section 04: Program for Calculator 00:02:00 Section 05: Program Using For Loop 00:08:00 Section 06: For Table 00:05:00 Section 07: For loop and Mathematical Operator in Python 00:04:00 Section 08: Factorial of Number Using Python 00:06:00 Section 09: Program Using While 00:05:00 Section 10: While Loop Example 00:07:00 Section 11: Tasks for Practice 00:02:00 Unit 04: Importing external/internal library in python Section 01: Importing Library in Python 00:07:00 Unit 05: Project Rock Paper and Scissors Section 01: Rock Paper and Scissor Game 00:06:00 Unit 06: Strings Operation in Python Section 01: Program Using String part 1 00:05:00 Section 02: Program using String 2 00:06:00 Section 03: Program Using String 3 00:06:00 Section 04: Program Using String part 4 00:03:00 Unit 07: Date and time in Python Section 01: Use of Date and Time part 1 00:05:00 Section 02: Use of Date and Time part 2 00:05:00 Unit 08: File Handling, read and write using Python Section 01: File Handling Part 1 00:08:00 Section 02: File Handling Part 2 00:07:00 Unit 09: Data Storage Structures, Tuple, List and Dictionary Section 01: Tuple in Python Part 1 00:10:00 Section 02: Tuple in Python Part 2 00:07:00 Section 03: Using Lists part 1 00:07:00 Section 04: Using List part 2 00:12:00 Section 05: Using Lists part 3 00:06:00 Section 06: Using Lists part 4 00:08:00 Section 07: Using Lists part 5 00:02:00 Section 08: Use of Dictionary Part 1 00:04:00 Section 09: Use of Dictionary Part 2 00:05:00 Section 10: Use of Dictionary Part 3 00:08:00 Section 11: Use of Dictionary Part 4 00:07:00 Unit 10: Writing user functions in Python Section 01: Function in Python Part 1 00:06:00 Section 02: Function in Python Part 2 00:05:00 Section 03: Function in Python Part 3 00:04:00 Section 04: Function in Python Part 4 00:07:00 Section 05: Function in Python Part 5 00:08:00 Unit 11: Sending mail Section 01: Send Email 00:09:00 Unit 12: Import Tricks in Python Section 01: Import Study part 1 00:07:00 Section 02: Import Study part 2 00:03:00 Unit 13: Import Operating System and Platform Section 01: Importing OS 00:06:00 Section 02: Import Platform 00:05:00 Unit 14: Exceptions handling in python Section 01: Exception in Python part 1 00:11:00 Section 02: Exception in Python part 2 00:07:00 Section 03: Exception in Python part 3 00:05:00 Unit 15: Installing Packages and Scheduling In Python Section 01: Installing Packages using built in package manager 00:08:00 Section 02: Scheduler in Python 00:05:00 Unit 16: Data Base In Python using sqlite Section 01: Data Base 1 00:08:00 Section 02: Data Base 2 00:09:00 Section 03: Data Base 3 00:08:00 Section 04: Data base 4 00:07:00 Section 05: Data Base 5 00:06:00 Unit 17: Running Program from Command Prompt and jupyter Notebook Section 01: IDE_1 00:05:00 Section 02: IDE_2 00:07:00 Unit 18: Conclusion Section 01: Conclusion 00:02:00 Resources Resources - Diploma in Python Programming 00:00:00 Assignment Assignment - Diploma in Python Programming 00:00:00 Recommended Materials Workbook - Diploma in Python Programming 00:00:00

Welcome to the data manipulation in Python course. Our goal in this course is to provide you with all the tools and skills necessary to master Python, NumPy, and Pandas for data science. No previous skills or expertise are required. Only a drive to succeed!