11522 Environment courses in Mayfield delivered Online

Business Leadership & Management Training Masterclass Step into the world of effective leadership with our Business Leadership & Management Training Masterclass. This all-in-one course teaches you how to lead teams, manage change, and build a strong work environment. You'll explore leadership models, develop personal mastery, and learn practical skills like delegation, feedback, and strategic planning. With easy-to-follow lessons and real-world tips, this course will help you grow into the confident leader every organisation needs. Course Curriculum About the Learning Organization Achieving Personal Mastery Analyzing Our Mental Models Achieving a Shared Vision Team Learning Systems Thinking Understanding Leadership Five Practices Building Trust Managing Change The Four Room Apartment Time Management Tips and Tricks Managers vs. Leaders Types of Thinking Influence Strategies Managing Relationships Strategic Planning Doing Delegation Right Criteria for Useful Feedback Feedback Techniques Mastering Your Body Language Meeting Management Pumping up a Presentation What’s Your Type? How About Mine? Understanding Leadership Manage Your Time and Your Energy Employee Development Models Dealing with Conflict and Difficult Issues What Successful Leaders Do What’s In A Word? Fundamental Elements The Four-I Model of Organizational Conversation The Conversational Leadership Framework World Cafe What is Self-Leadership? Knowing Who You Are Knowing What You Do Motivation for Optimists Using What You Know Women and the Workforce Barriers and Benefits to Women’s Leadership Social and Emotional Intelligence Self-Awareness Developing Leadership Awareness and Brand Leadership Skills Making Good Decisions Creating Your Workplace Philosophy (Learn more about this online course)

Level 5 QLS Endorsed Course | Endorsed Certificate Included | Plus 5 Career Guided Courses | CPD Accredited

Duration 3 Days 18 CPD hours This course is intended for This is an introductory- level course appropriate for those who are developing applications using relational databases, or who are using SQL to extract and analyze data from databases and need to use the full power of SQL queries. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert practitioner, attendees will learn to: Maximize the potential of SQL to build powerful, complex and robust SQL queries Query multiple tables with inner joins, outer joins and self joins Construct recursive common table expressions Summarize data using aggregation and grouping Execute analytic functions to calculate ranks Build simple and correlated subqueries Thoroughly test SQL queries to avoid common errors Select the most efficient solution to complex SQL problems A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. SQL is the cornerstone of all relational database operations. In this hands-on course, you learn to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, and avoid common errors and pitfalls. It also teaches alternative solutions to given problems, enabling you to choose the most efficient solution in each situation. Introduction: Quick Tools Review Introduction to SQL and its development environments Using SQL*PLUS Using SQL Developer Using the SQL SELECT Statement Capabilities of the SELECT statement Arithmetic expressions and NULL values in the SELECT statement Column aliases Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword Use of the DESCRIBE command Restricting and Sorting Data Limiting the Rows Rules of precedence for operators in an expression Substitution Variables Using the DEFINE and VERIFY command Single-Row Functions Describe the differences between single row and multiple row functions Manipulate strings with character function in the SELECT and WHERE clauses Manipulate numbers with the ROUND, TRUNC and MOD functions Perform arithmetic with date data Manipulate dates with the date functions Conversion Functions and Expressions Describe implicit and explicit data type conversion Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions Nest multiple functions Apply the NVL, NULLIF, and COALESCE functions to data Decode/Case Statements Using the Group Functions and Aggregated Data Group Functions Creating Groups of Data Having Clause Cube/Rollup Clause SQL Joins and Join Types Introduction to JOINS Types of Joins Natural join Self-join Non equijoins OUTER join Using Subqueries Introduction to Subqueries Single Row Subqueries Multiple Row Subqueries Using the SET Operators Set Operators UNION and UNION ALL operator INTERSECT operator MINUS operator Matching the SELECT statements Using Data Manipulation Language (DML) statements Data Manipulation Language Database Transactions Insert Update Delete Merge Using Data Definition Language (DDL) Data Definition Language Create Alter Drop Data Dictionary Views Introduction to Data Dictionary Describe the Data Dictionary Structure Using the Data Dictionary views Querying the Data Dictionary Views Dynamic Performance Views Creating Sequences, Synonyms, Indexes Creating sequences Creating synonyms Creating indexes Index Types Creating Views Creating Views Altering Views Replacing Views Managing Schema Objects Managing constraints Creating and using temporary tables Creating and using external tables Retrieving Data Using Subqueries Retrieving Data by Using a Subquery as Source Working with Multiple-Column subqueries Correlated Subqueries Non-Correlated Subqueries Using Subqueries to Manipulate Data Using the Check Option Subqueries in Updates and Deletes In-line Views Data Control Language (DCL) System privileges Creating a role Object privileges Revoking object privileges Manipulating Data Overview of the Explicit Default Feature Using multitable INSERTs Using the MERGE statement Tracking Changes in Data

ITIL® 4 Foundation: Virtual In-House Training ITIL® 4 is built on the established core of best practice in the ITIL® guidance. ITIL® 4 provides a practical and flexible approach to move to the new world of digital transformation and embrace an end-to-end operating model for the delivery and operation of products and services. ITIL® 4 also provides a holistic end-to-end picture that integrates frameworks such as Lean IT, Agile, and DevOps. The ITIL® 4 Foundation is based on the exam specifications specified by AXELOS for the ITIL® 4 Foundation certification. The fundamental objective of this course is to help the participants understand the key concepts of service management and the ITIL® 4 service management framework and prepare for the ITIL® 4 Foundation exam. In addition, this course offers a rich learning experience that helps the participants relate ITIL® to their own work environment. The course includes a case study (based on a fictitious organization, 'Axle Car Hire') that will help the participants understand and experience the ITIL® guiding principles, service value, practices through real-world challenges and opportunities. The rich learning experience is supported by additional learning tools such as pre-course reading materials, post-course reading material, and a set of quick reference cards. What You Will Learn At the end of this program, you will be able to: Understand the key concepts of ITIL® service management Understand how ITIL® guiding principles can help an organization to adopt and adapt ITIL® service management Understand the four dimensions of ITIL® service management Understand the purpose and components of the ITIL® service value system, and activities of the service value chain, and how they interconnect Understand the key concepts of continual improvement Learn the various ITIL® practices and how they contribute to value chain activities Course Introduction Let's Get to Know Each Other Course Overview Course Learning Objectives Course Structure Course Agenda Introduction to IT Service Management in the Modern World Introduction to ITIL® 4 Structure and Benefits of ITIL® 4 Case Study: Axle Car Hire Case Study: Meet the Key People at Axle Case Study: The CIOs Vision for Axle Exam Details ITIL® 4 Certification Scheme Service Management - Key Concepts Intent and Context Key Terms Covered in the Module Module Learning Objectives Value and Value Co-Creation Value: Service, Products, and Resources Service Relationships Value: Outcomes, Costs, and Risks Exercise: Multiple-Choice Questions The Guiding Principles Intent and Context Identifying Guiding Principles Key Terms Covered in the Module Module Learning Objectives The Seven Guiding Principles Applying the Guiding Principles Exercise: Multiple-Choice Questions The Four Dimensions of Service Management Intent and Context The Four Dimensions Key Terms Covered in the Module The Four Dimensions and Service Value System Module Learning Objectives Organizations and People Information and Technology Partners and Suppliers Value Streams and Processes External Factors and Pestle Model Exercise: Multiple-Choice Questions Service Value System Intent and Context Service Value System and Service Value Chain Module Learning Objectives Overview of Service Value System Overview of the Service Value Chain Exercise: Multiple-Choice Questions Continual Improvement Intent and Context Key Terms Covered in the Module Introduction to Continual Improvement Module Learning Objectives The Continual Improvement Model Relationship between Continual Improvement and Guiding Principles Exercise: Multiple-Choice Questions The ITIL® Practices Intent and Context ITIL® Management Practices Key Terms Covered in the Module Module Learning Objectives The Continual Improvement Practice The Change Control Practice The Incident Management Practice The Problem Management Practice The Service Request Management Practice The Service Desk Practice The Service Level Management Practice Purpose of ITIL® Practices Exercise: Crossword Puzzle

Course Overview The "Store Assistant" course offers learners an in-depth understanding of the retail sector, covering essential aspects such as customer service, store management, and retail operations. By completing this course, learners will gain the skills necessary to effectively contribute to the day-to-day operations of a retail environment. The course will also equip them with knowledge of retail management practices, customer interaction strategies, and industry regulations. Learners will come away with a comprehensive understanding of the role and the ability to enhance their professional practice in a retail setting, making them well-prepared for a variety of store assistant positions. Course Description This course is designed to provide learners with essential knowledge and skills for a career as a store assistant. Topics include the roles and responsibilities of store assistants, the basics of retail management, and how to effectively manage customer relationships. Learners will explore visual merchandising, consumer behaviour, and the psychological aspects of retail, along with understanding how to interact with suppliers. Additionally, the course covers relevant retail legislation to ensure compliance in day-to-day operations. Through a structured curriculum, learners will gain insights into managing a retail store, enhancing customer experiences, and applying effective store strategies to improve business outcomes. The course is ideal for those seeking to develop a strong foundation in retail roles and prepare for a successful career in the industry. Course Modules Module 01: Introduction to Store Assistant Module 02: Roles and Responsibilities of a Store Assistant Module 03: Introduction to Retail Management Module 04: Managing a Retail Store Module 05: Visual Merchandising Module 06: Consumer Behaviour Module 07: Dealing with Customers Module 08: Dealing with Suppliers Module 09: Store Psychology Module 10: Legislations Related to Retail (See full curriculum) Who is this course for? Individuals seeking to start a career in retail. Professionals aiming to enhance their retail management skills. Beginners with an interest in customer service and retail operations. Anyone looking to understand retail environments and store dynamics. Career Path Store Assistant Retail Associate Retail Manager Visual Merchandiser Customer Service Representative Retail Supervisor Supply Chain Assistant

Course Overview This Personal Assistant (PA) course is designed to provide learners with essential skills and knowledge to excel in a variety of administrative roles. Covering everything from business communication to organisational skills, this course ensures learners are equipped to manage office duties efficiently, support executives, and contribute to the smooth running of an organisation. By completing this course, learners will gain a solid understanding of the core functions of a PA, enabling them to confidently take on responsibilities in any professional setting. Course Description The course delves into key areas including business telephone etiquette, managing travel arrangements, organising meetings, and developing effective communication skills. Learners will explore the nuances of record-keeping, minute-taking, and scheduling, essential for ensuring a well-structured office environment. With a strong emphasis on time management, organisational skills, and business writing, this course prepares learners to confidently manage multiple tasks and responsibilities in fast-paced work environments. By the end, learners will have developed the ability to enhance productivity and support executive operations effectively. Course Modules Module 01: Introduction to Personal Assistant Module 02: Business Telephone Skills Module 03: Representing Your Boss and Company Module 04: Mail Services and Shipping Module 05: Travel Arrangements Module 06: Organising Meetings and Conferences Module 07: Time Management Module 08: Record Keeping and Filing Systems Module 09: Business Writing Skills Module 10: Organisational Skills Module 11: Communication Skills Module 12: Customer Service Module 13: Effective Planning and Scheduling Module 14: Invoicing/Petty Cash Module 15: Introduction to Minute Writing Module 16: Preparation for Minute Taking Module 17: The Meeting Structure Module 18: Minute Meeting, Decision and Action Module 19: Roles and Responsibility of Minute Taker Module 20: Tips for Minute Taking Module 21: Technology in Minute Taking Module 22: Building Confidence (See full curriculum) Who is this course for? Individuals seeking to enhance their administrative skills. Professionals aiming to advance their career as a Personal Assistant. Beginners with an interest in office management and administrative roles. Anyone interested in developing organisational and communication skills. Career Path Personal Assistant Executive Assistant Administrative Assistant Office Manager Office Administrator Executive Support Specialist

Duration 2 Days 12 CPD hours Overview What's New in This Guide? Automatic Payment Reminders for open customer invoices Ability to automatically include the PO# (purchase order number) to Invoice Emails Able to combine multiple emails which allows you to attach multiple sales or purchasing documents to a single email Quickly locate a company file using the new company file search feature Smart Help is an improved search experience that includes access to live experts through messaging and call back options This course covers all features that are in QuickBooks Pro and Premier 2020 and prepares you for the QuickBooks Certified User exam. This course combines all topics in the two 1 day courses ?Get Started with QuickBooks 2020 for Windows? and ?Keep Going with QuickBooks 2020 for Windows?. First-time QuickBooks users will learn the basic features of the software. Experienced QuickBooks users will quickly learn the new features and functionality of QuickBooks 2020. Getting Started Starting QuickBooks Setting QuickBooks Preferences Components of the QuickBooks Operating Environment Using QuickBooks Help Identifying Common Business Terms Exiting QuickBooks Setting Up a Company Creating a QuickBooks Company Using the Chart of Accounts Working with Lists Creating Company Lists Working with the Customers & Jobs List Working with the Employees List Working with the Vendors List Working with the Item List Working with Other Lists Managing Lists Setting Up Inventory Entering Inventory Ordering Inventory Receiving Inventory Paying for Inventory Manually Adjusting Inventory Selling Your Product Creating Product Invoices Applying Credit to Invoices Emailing Invoices Setting Price Levels Creating Sales Receipts Invoicing for Services Setting Up a Service Item Changing the Invoice Format Creating a Service Invoice Editing an Invoice Voiding an Invoice Deleting an Invoice Entering Statement Charges Creating Billing Statements Processing Payments Displaying the Open Invoices Report Using the Income Tracker Receiving Payments for Invoices Making Deposits Handling Bounced Checks Working with Bank Accounts Writing a QuickBooks Check Voiding a QuickBooks Check Using Bank Account Registers Entering a Handwritten Check Transferring Funds Between Accounts Reconciling Checking Accounts Entering and Paying Bills Handling Expenses Using QuickBooks for Accounts Payable Using the Bill Tracker Entering Bills Paying Bills Entering Vendor Credit Memorizing Transactions Entering a New Memorized Transaction Editing a Memorized Transaction Deleting a Memorized Transaction Grouping Memorized Transactions Using a Memorized Transaction Printing the Memorized Transaction List Customizing Forms Creating a Custom Template Modifying a Template Printing Forms Using Other QuickBooks Accounts Other QuickBooks Account Types Working with Credit Card Transactions Working with Fixed Assets Working with Long-Term Liability Accounts Using the Loan Manager Creating Reports Working with QuickReports Working with Preset Reports Sharing Reports Exporting Reports to Microsoft Excel Printing Reports Creating Graphs Creating QuickInsight Graphs Using QuickZoom with Graphs Working with the Sales Graph Customizing Graphs Printing Graphs Tracking and Paying Sales Tax Using Sales Tax in QuickBooks Setting Up Tax Rates and Agencies Indicating Who and What Gets Taxed Applying Tax to Each Sale Determining What You Owe Paying Your Tax Agencies Preparing Payroll with QuickBooks Using Payroll Tracking Setting Up for Payroll Setting Up Employee Payroll Information Setting Up a Payroll Schedule Writing a Payroll Check Printing Paycheck Stubs Tracking Your Tax Liabilities Paying Payroll Taxes Preparing Payroll Tax Forms Using the EasyStep Interview Using the EasyStep Interview Using Online Banking Setting Up an Internet Connection Setting Up Bank Feeds for Accounts Viewing, Downloading, and Adding Online Transactions Creating Online Payments Transferring Funds Online Canceling Online Payments Managing Company Files Using QuickBooks in Multi-user Mode Setting Up Users and Passwords Setting a Closing Date Sharing Files with an Accountant Updating QuickBooks Backing Up and Restoring a Company File Condensing a Company File Estimating, Time Tracking, and Job Costing Creating Job Estimates Creating an Invoice from an Estimate Displaying Reports for Estimates Updating the Job Status Tracking Time Displaying Reports for Time Tracking Tracking Vehicle Mileage Displaying Vehicle Mileage Reports Displaying Other Job Reports Writing Letters Using the Letters and Envelopes Wizard Customizing Letter Templates

Level 4 QLS Diploma | FREE QLS Endorsed Certificate | 10 CPD Courses & Certificates | 220 CPD Points | CPD Accredited

In healthcare, maintaining the highest standards of hygiene is essential. The Sterile Services Training Course offers an in-depth exploration of the principles and techniques necessary to ensure the safety and cleanliness of medical instruments and equipment. Whether you're looking to enhance your current knowledge or dive into a new area of expertise, this course provides a detailed understanding of sterilisation processes, risk management, and infection control in a sterile environment. With a focus on standards that safeguard patient health, this course offers an invaluable resource for those interested in working within sterile services. This training course focuses on the critical aspects of sterilisation, from understanding different sterilisation methods to mastering the handling and storage of sterile items. Through online learning, you will explore the latest standards and best practices that form the backbone of sterile services in healthcare settings. Whether you work in a hospital, clinic, or laboratory, knowing the principles behind effective sterilisation is crucial. Join the course to gain an essential knowledge base, boost your expertise, and contribute to the well-being of others by ensuring healthcare environments remain safe and hygienic. 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 1: Introduction to Sterile Services Module 2: Cleaning and Decontamination Module 3: Sterilisation Methods and Packaging Module 4: Quality Management in Sterilising Services Module 5: Thermal and Chemical Disinfection Module 6: Aseptic Techniques and Sterile Compounding Learning Outcomes Demonstrate understanding of essential sterile services principles. Apply effective cleaning and decontamination techniques. Evaluate various sterilisation methods and packaging practices. Implement quality management strategies in sterilising services. Comprehend thermal and chemical disinfection processes. Master aseptic techniques and sterile compounding for healthcare settings. 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? Healthcare professionals seeking specialised expertise. Individuals aspiring to enter the sterile services sector. Technicians and assistants in healthcare environments. Those keen on advancing their knowledge in healthcare practices. Career changers aiming for a role in sterile services. Professionals desiring a deeper understanding of quality management. Students pursuing a healthcare-related educational path. Anyone passionate about maintaining the highest standards in healthcare. Career path Sterile Services Technician Healthcare Assistant Infection Control Officer Theatre Support Worker Surgical Instrument Technician Quality Assurance 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.

Tired of pests running the show? Our Methods of Pest Control course delivers sharp, straight-talking knowledge on how to identify, understand, and manage pests like a seasoned pro—minus the fluff. With structured modules covering everything from common infestations to strategic control methods, this course offers clear insight for anyone keen to master the science behind pest management. No gimmicks, just solid, actionable theory. Delivered entirely online, it’s tailored for those who prefer learning with flexibility—no need to leave your seat or suit up in overalls. Whether you're working in facilities, property care, food services, or you're just fed up with unwelcome guests, this course breaks it all down with clarity, purpose, and a touch of dry wit. Expect logical content, smart delivery, and a focus on real solutions—not recycled jargon. 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 Pest Control Module 02 : Different Types of Pests Module 03 : Insects and Mites Anatomy and Prevention Module 04 : Weeds Control Module 05 : Pesticide Formulations (Liquid and Dry) Module 06 : Pesticide Formulations and Adjuvants Module 07 : Plant Diseases and Disorders Module 08 : Pest Management Methods and IPM Module 09 : Pesticide Application Module 10 : Environmental Impacts of Pest control Module 11 : Regulations of Pest Control in the UK Learning Outcomes: Identify and classify various pest types for targeted control. Understand the anatomy of insects and mites to develop prevention strategies. Implement effective weed control measures to protect crops. Differentiate between liquid and dry pesticide formulations for precise application. Evaluate the environmental impacts of pest control techniques. Comply with UK regulations governing pest control 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. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Agricultural professionals and farmers Gardeners and horticulturists Environmental enthusiasts Pest control technicians Students pursuing agricultural studies Anyone interested in sustainable pest management Career path Pest Control Technician Agricultural Advisor Horticulturalist Environmental Consultant Crop Protection Specialist Pest Control Manager 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.