2189 Courses delivered Live Online

Duration 3 Days 18 CPD hours This course is intended for Data Wrangling with Python takes a practical approach to equip beginners with the most essential data analysis tools in the shortest possible time. It contains multiple activities that use real-life business scenarios for you to practice and apply your new skills in a highly relevant context. Overview By the end of this course, you will be confident in using a diverse array of sources to extract, clean, transform, and format your data efficiently. In this course you will start with the absolute basics of Python, focusing mainly on data structures. Then you will delve into the fundamental tools of data wrangling like NumPy and Pandas libraries. You'll explore useful insights into why you should stay away from traditional ways of data cleaning, as done in other languages, and take advantage of the specialized pre-built routines in Python.This combination of Python tips and tricks will also demonstrate how to use the same Python backend and extract/transform data from an array of sources including the Internet, large database vaults, and Excel financial tables. To help you prepare for more challenging scenarios, you'll cover how to handle missing or wrong data, and reformat it based on the requirements from the downstream analytics tool. The course will further help you grasp concepts through real-world examples and datasets. Introduction to Data Structure using Python Python for Data Wrangling Lists, Sets, Strings, Tuples, and Dictionaries Advanced Operations on Built-In Data Structure Advanced Data Structures Basic File Operations in Python Introduction to NumPy, Pandas, and Matplotlib NumPy Arrays Pandas DataFrames Statistics and Visualization with NumPy and Pandas Using NumPy and Pandas to Calculate Basic Descriptive Statistics on the DataFrame Deep Dive into Data Wrangling with Python Subsetting, Filtering, and Grouping Detecting Outliers and Handling Missing Values Concatenating, Merging, and Joining Useful Methods of Pandas Get Comfortable with a Different Kind of Data Sources Reading Data from Different Text-Based (and Non-Text-Based) Sources Introduction to BeautifulSoup4 and Web Page Parsing Learning the Hidden Secrets of Data Wrangling Advanced List Comprehension and the zip Function Data Formatting Advanced Web Scraping and Data Gathering Basics of Web Scraping and BeautifulSoup libraries Reading Data from XML RDBMS and SQL Refresher of RDBMS and SQL Using an RDBMS (MySQL/PostgreSQL/SQLite) Application in real life and Conclusion of course Applying Your Knowledge to a Real-life Data Wrangling Task An Extension to Data Wrangling

Duration 5 Days 30 CPD hours This course is intended for This course is intended for Database Administrators, Database Developers, BI professionals, and Business reporting users. Overview Upon successful completion of this course, students will be able to run Queries and retrieve results, perform conditional searches, and retrieve data from multiple tables. Before starting this course, make sure you meet at least one of the following prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Basic working knowledge of Relational Databases. In this course, students will gain a good understanding of the Transact-SQL language. They will be able to create queries, sort, filter the data, execute procedures with T-SQL. Course Outline 1.Introduction to Microsoft SQL Server 2.Introduction to T-SQL Querying 3.Writing SELECT Queries 4.Querying Multiple Tables 5.Sorting and Filtering Data 6.Working with SQL Server Data Types 7.Using DML to Modify Data 8.Using Built-In Functions 9.Grouping and Aggregating Data 10.Using Subqueries 11.Using Table Expressions 12.Using Set Operators 13.Using Windows Ranking, Offset, and Aggregate Functions 14.Pivoting and Grouping Sets 15.Executing Stored Procedures 16.Programming with T-SQL

Duration 3 Days 18 CPD hours This course is intended for This intermediate course is for all computer professionals who will use z/OS UNIX. Overview Discuss the role of z/OS in an open systems environmentIdentify the basic terms used in z/OS UNIXDefine the components of z/OS UNIXExplain major functions provided in z/OS UNIXDiscuss opportunities for applications in a z/OS UNIX environmentIdentify z/OS base elements and optional features that make up z/OS UNIXUse the two interactive interfaces available to access the services This course describes how open standards are implemented in a z/OS system by z/OS UNIX. UNIX System Services are introduced, and the role of z/OS as a server in the open systems environment is discussed. Day 1 Welcome and introduction Unit 1. z/OS UNIX overview Unit 2. Introduction to z/OS UNIX Unit 3. Hierarchical file system Exercises Day 2 Unit 4. z/OS UNIX shell and utilities Unit 5. z/OS UNIX shell commands Unit 6. Working with the shell Unit 7. Functions in z/OS UNIX Exercises Day 3 Unit 8. Working with the z/OS UNIX environment Exercises

News Writing, Production and Reporting Course Overview This course on News Writing, Production and Reporting offers a comprehensive introduction to the core elements of newspaper journalism. Learners will explore essential techniques in news writing, interviewing, reporting, and production, equipping them with the skills needed to craft clear, accurate, and engaging news stories. The programme emphasises the ethical and legal responsibilities of journalists, alongside developing strong writing and reporting skills tailored to contemporary media environments. By the end of the course, participants will understand the principles of newspaper journalism and gain confidence in producing professional news content suitable for a variety of platforms, ensuring readiness for roles in the fast-paced journalism sector. Course Description Delving deeper into the craft of newspaper journalism, this course covers the historical context, development, and evolving nature of the industry. Learners will study interview techniques, news writing formats, production workflows, and specialised reporting areas such as court reporting and niche journalism. Legal frameworks and journalistic ethics form a critical part of the curriculum, ensuring an informed and responsible approach to reporting. Additional topics include feature story writing and health and safety considerations for journalists. Through a structured learning experience, students will develop analytical, communication, and editorial skills vital for effective storytelling in print and digital media, preparing them for a dynamic and rewarding career in journalism. News Writing, Production and Reporting Curriculum Module 01: Introduction and Principles of Newspaper Journalism Module 02: History and Development of Newspaper Journalism Module 03: Interviewing for Newspaper Journalism Module 04: News Writing Module 05: News Production Module 06: News Reporting Module 07: Writing Skills for Newspaper Journalists Module 08: Newspaper Journalism Law Module 09: Court Reporting Module 10: Journalism Ethics Module 11: Niche Journalism Module 12: Tips on Writing a Good Feature Story Module 13: Health and Safety for Journalists (See full curriculum) Who is this course for? Individuals seeking to build foundational skills in newspaper journalism. Professionals aiming to advance their career in media and communications. Beginners with an interest in news writing, reporting, and media production. Anyone wishing to understand the legal and ethical aspects of journalism. Career Path Newspaper Reporter News Editor Broadcast Journalist Feature Writer Court Reporter Media Communications Specialist Digital Content Producer

IT for Dummies Course Overview This course, IT for Dummies, provides a straightforward introduction to the fundamental concepts of information technology. Designed for beginners and those with limited prior knowledge, it covers a broad range of essential topics including hardware, software, networking, security, and cloud technologies. Learners will develop a clear understanding of how IT systems operate, how different components interact, and the key principles that underpin modern digital environments. By the end of the course, participants will be equipped with foundational IT knowledge that supports both personal and professional development, enabling confident navigation of common IT tasks and providing a stepping stone to more advanced studies or career progression in the technology sector. Course Description IT for Dummies offers a comprehensive exploration of the core elements of information technology in a clear and accessible format. The course covers the basics of IT infrastructure, including hardware components, operating systems, software applications, and network configurations. Learners will also gain insight into IT security measures, data storage solutions, database management, and emerging trends such as virtualisation and cloud computing. Through structured lessons, participants will develop a broad skill set that enhances their understanding of IT environments and prepares them for various roles in the sector. This course is structured to build confidence and competence in IT concepts, suitable for those starting their journey in the technology field or seeking to broaden their digital literacy. IT for Dummies Curriculum: Module 01: Introduction Module 02: Information Technology Module 03: Components of IT Module 04: Hardware Module 05: Operating System Module 06: Application/Software Module 07: Networking Module 08: Security Module 09: Traffic Flow & Enterprise Level IT Components Module 10: Storage Module 11: Database Module 12: Virtualisation & Cloud Module 13: Management & Other IT Jobs (See full curriculum) Who is this course for? Individuals seeking to understand fundamental IT concepts. Professionals aiming to enhance their digital knowledge for career growth. Beginners with an interest in technology and computing. Those preparing for further IT qualifications or certifications. Career Path IT Support Technician Network Administrator Systems Analyst Database Administrator Cloud Services Coordinator Junior IT Manager Technical Assistant in various industries

Domestic Violence and Abuse Awareness Diploma Course Overview This Domestic Violence and Abuse Awareness Diploma provides a comprehensive introduction to recognising, understanding, and responding to domestic violence and abuse. The course equips learners with the knowledge to identify different forms of abuse, assess risks, and understand the profound impacts on victims and children. It emphasises the importance of supporting victims effectively and navigating the relevant UK legislation. Learners will develop skills essential for safeguarding and reporting, alongside accurate record keeping. Ideal for those wishing to increase awareness or pursue careers in social care, healthcare, education, or community support, this diploma fosters confidence and competence in addressing sensitive issues with professionalism and compassion. Course Description This course delves deeply into the nature and dynamics of domestic violence and abuse, exploring its various forms and the psychological, physical, and emotional consequences for victims, including children. Learners will examine risk assessment techniques and appropriate methods for supporting victims, while gaining a clear understanding of the UK legal framework governing domestic abuse. The programme also covers essential administrative skills such as incident reporting and record keeping to ensure accountability and protection. Delivered in a structured format, the course offers a thorough learning experience designed to build expertise for those working or intending to work in sectors focused on safeguarding, welfare, and community assistance. Domestic Violence and Abuse Awareness Diploma Curriculum: Module 01: Introduction to Domestic Violence & Abuse Module 02: The Components of Domestic Violence Module 03: The Impact of Domestic Violence on Victims Module 04: The Impact of Domestic Violence and Abuse on Children Module 05: Assessing the Risks of Domestic Violence and Abuses on Children Module 06: Supporting the Victim and Reporting Incidents Module 07: Record Keeping Module 08: Domestic Violence and Abuse Legislation in the UK (See full curriculum) Who is this course for? Individuals seeking to understand domestic violence and abuse awareness. Professionals aiming to enhance their safeguarding and support skills. Beginners with an interest in social care, health, or community support. Volunteers and advocates working with vulnerable populations. Career Path Safeguarding Officer Social Care Worker Healthcare Support Worker Community Support Worker Victim Support Advisor Early Years Practitioner

Veterinary Nursing Level 3 Course Overview This Veterinary Nursing Level 3 course offers a comprehensive introduction to the essential knowledge and skills required for supporting animal health and welfare across multiple species. Learners will explore vital topics such as animal care, emergency response, and relevant legislation, equipping them to assist effectively in veterinary environments. The course emphasises critical understanding of veterinary nursing roles, including recognising and managing common emergencies like shock, seizures, and poisoning. Upon completion, learners will have developed the confidence and competence to contribute responsibly to animal care teams, while enhancing their career prospects in the veterinary sector. Course Description The Veterinary Nursing Level 3 course covers a wide range of key subjects designed to build foundational expertise for those interested in animal health and veterinary support. Topics include basic animal welfare, emergency scenarios such as cardiopulmonary resuscitation and fracture management, and the legal framework governing veterinary nursing. Learners will gain insight into recognising and responding to critical situations including unconsciousness, bleeding, burns, and poisoning. The course also addresses career development, providing guidance on professional growth within the veterinary nursing field. This structured learning experience develops knowledge, decision-making abilities, and an understanding of the responsibilities involved in veterinary care. Veterinary Nursing Level 3 Curriculum Module 01: Introduction to Veterinary Nursing Module 02: Basic Care and Animal Welfare of All Species Module 03: Career Prospect and Development Module 04: Veterinary Nursing Legislation Module 05: Collapse & Unconsciousness Module 06: Cardiopulmonary Resuscitation Module 07: Shock Module 08: Bleeding Module 09: Bandage Module 10: Fractures Module 11: Seizures Module 12: Choking & Drowning Module 13: Heat Stroke & Hypothermia Module 14: Burns & Scalds Module 15: Poisoning Module 16: Bites and Stings Module 17: Common Emergencies Module 18: Managing a First Aid Scenario Module 19: Pet First Aid Kit (See full curriculum) Who is this course for? Individuals seeking to build a career in veterinary nursing. Professionals aiming to enhance their knowledge of animal care and emergency management. Beginners with an interest in animal welfare and veterinary support roles. Those pursuing formal education to work alongside veterinary practitioners. Career Path Veterinary Nurse Assistant Animal Care Assistant Veterinary Clinic Support Staff Emergency Animal Care Provider Veterinary Nursing Student Progression Roles in Animal Welfare Organisations

Fashion Law Course Overview This Fashion Law course offers a comprehensive exploration of the legal principles and frameworks shaping the fashion industry. Learners will gain insight into essential areas such as intellectual property rights, brand protection, retail regulations, counterfeiting, and ethical practices including sustainability. The course equips individuals with the knowledge to navigate complex legal challenges faced by fashion businesses, designers, and retailers. By the end, learners will understand how fashion law intersects with business law and how it protects creativity and commerce in a dynamic global market. This course is valuable for anyone interested in the legal aspects influencing fashion, helping them to make informed decisions, safeguard brand identity, and foster ethical practices within the industry. Course Description This course delves into the key legal topics relevant to the fashion sector, starting with an introduction to fashion law and its role within broader business law contexts. It covers retailing regulations, detailed analysis of intellectual property rights with a two-part focus on brand protection, and the impact of counterfeiting on the industry. Brand licensing is also examined as a strategic business tool. Additionally, the course addresses contemporary issues such as ethics, sustainability, and the rise of green fashion, reflecting the industry's growing environmental concerns. Learners will develop a thorough understanding of legal frameworks and gain skills to assess legal risks, protect intellectual property, and contribute to responsible fashion business practices. Fashion Law Curriculum Module 01: Introduction to Fashion Law Module 02: Fashion Law as Business Law Module 03: Retailing Module 04: Intellectual Property Rights: Brand Protection Part-I Module 05: Intellectual Property Rights: Brand Protection Part-II Module 06: Counterfeiting Module 07: Brand Licensing Module 08: Ethics, Sustainability and Green Fashion (See full curriculum) Who is this course for? Individuals seeking to understand legal issues in the fashion industry. Professionals aiming to enhance their knowledge of fashion business law. Beginners with an interest in fashion, law, and intellectual property. Entrepreneurs and brand managers in the fashion sector. Career Path Fashion Legal Consultant Brand Protection Specialist Intellectual Property Advisor for Fashion Businesses Retail Compliance Officer Ethical Fashion Coordinator Brand Licensing Manager

Metaphysics Course Overview This Metaphysics course offers a comprehensive exploration of the fundamental principles underlying reality, existence, and the nature of being. Learners will delve into key metaphysical concepts such as existence, causality, and the relationship between mind and matter. Designed to deepen philosophical understanding, the course also examines the historical development of metaphysical thought alongside its influence on religion, spirituality, and modern New Age beliefs. Participants will gain critical thinking skills, enhancing their ability to analyse abstract ideas and apply them in philosophical, religious, or cultural contexts. By completing this course, learners will build a strong intellectual foundation for further study or professional work involving philosophy, theology, counselling, or holistic disciplines. Course Description This detailed course covers the breadth of metaphysical inquiry, beginning with an introduction to its core subjects and evolving through historical perspectives from ancient to contemporary times. Topics include fundamental questions about existence, the supernatural, and the intersection of metaphysics with religion and occultism. Learners will engage with new metaphysical concepts emerging from the New Age movement and critically examine their cultural significance. The learning experience emphasises analytical reasoning and reflective thought, encouraging students to evaluate complex ideas and theories. Skills developed include philosophical analysis, conceptual clarity, and an enhanced understanding of diverse belief systems, preparing learners for roles that require insight into metaphysical and spiritual frameworks. Metaphysics Curriculum Module 01: Introduction to Metaphysics Module 02: Core Subjects of Metaphysics Module 03: History of Metaphysics Module 04: Fundamental Questions of Existence Module 05: New Age Movement and Metaphysics Module 06: Metaphysics and the Supernatural Module 07: Metaphysics, Religion and Occultism Module 08: Other Metaphysical Concepts (See full curriculum) Who is this course for? Individuals seeking to deepen their understanding of philosophical concepts. Professionals aiming to enhance their knowledge in theology or spiritual counselling. Beginners with an interest in philosophy, spirituality, or metaphysical studies. Those exploring careers in holistic, religious, or cultural education fields. Career Path Philosophy lecturer or researcher Spiritual or holistic counsellor Religious studies advisor or educator Author or content creator in metaphysical and spiritual topics Cultural consultant or community facilitator

Sports Injuries Course Overview: This course on Sports Injuries provides a comprehensive introduction to the most common injuries athletes encounter and their management. It covers a wide range of topics, from basic injury prevention to advanced treatment strategies. Learners will gain a deep understanding of both internal and external injuries, including their medical assessment, rehabilitation, and the role of sports medicine in recovery. By the end of the course, learners will have a thorough grasp of injury types, treatment methods, and preventive strategies, equipping them with the skills to support athletes in both professional and amateur sports settings. Course Description: This in-depth course explores a variety of sports injuries and the approaches used to treat and manage them effectively. Topics include the top ten most common sports injuries, internal organ injuries, and sports-specific first aid techniques. Learners will also study the impact of drugs and doping in sports, as well as the importance of pre-participation screening. Through these modules, participants will develop an understanding of the anatomy and physiology behind injuries, as well as rehabilitation strategies to prevent recurrence. The course provides valuable knowledge applicable across a range of sports and healthcare roles, preparing learners to handle sports injuries competently in a variety of settings. Sports Injuries Curriculum: Module 01: Introduction to Sports Injuries Module 02: Top Ten Common Sports Injuries Module 03: Other Injuries Related to Sports and their Treatment Module 04: Internal Organ Injuries and their Treatment Module 05: Sports First Aid Module 06: Sports Medicine Module 07: Anatomy and Physiology of Sports Injuries Module 08: Drugs and Doping in Sport Module 09: Medical Assessment and Pre-participation Screening Module 10: Treating Medical Emergencies in Sports Module 11: Prevention and Rehabilitation Planning of Sports Related Injuries (See full curriculum) Who is this course for? Individuals seeking to deepen their knowledge of sports injuries. Professionals aiming to enhance their expertise in sports medicine or sports management. Beginners with an interest in pursuing a career in sports health. Healthcare providers looking to specialise in sports injury treatment. Career Path: Sports Therapist Physiotherapist specialising in sports injuries Sports Medicine Consultant Athletic Trainer Sports Health Coach Emergency Medical Technician in sports settings