• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

12120 Environment courses in Formby delivered Online

Store Assistant

By NextGen Learning

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

Store Assistant
Delivered OnlineFlexible Dates
£9.99

Introduction to Writing SQL Queries (TTSQL003)

By Nexus Human

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

Introduction to Writing SQL Queries (TTSQL003)
Delivered OnlineFlexible Dates
Price on Enquiry

ITIL 4 Foundation: Virtual In-House Training

By IIL Europe Ltd

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

ITIL 4 Foundation: Virtual In-House Training
Delivered OnlineFlexible Dates
Price on Enquiry

Level 7 Diploma in Gardening and Horticulture - QLS Endorsed

4.7(47)

By Academy for Health and Fitness

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that over 11 million households in the UK grow their own vegetables, and that the demand for organic food is skyrocketing? As Monty Don himself said, "Gardening is not a chore, it's a relationship with nature." This Gardening and Horticulture Training Bundle is your chance to cultivate that relationship and turn your passion into a rewarding career. Our Gardening and Horticulture bundle explores gardening and horticulture, teaching organic gardening, homesteading principles, and growing fruits and vegetables. It covers botany, agriculture, sustainable practices, carbon literacy, environmental health, land management, and conserving natural resources through courses on carbon literacy and environmental health. With a single payment, you will gain access to Gardening and Horticulture Training course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This Gardening and Horticulture Bundle Package includes: Main Course : Advanced Diploma in Gardening and Horticulture at QLS Level 7 10 Additional CPDQS Accredited Premium Courses - Course 01: Benefits of Organic Gardening Course 02: Understanding of Homesteading Gardening Diploma Course 03: Kitchen Gardening Course 04: Mushroom Growing Course Course 05: Agricultural Science Course 06: Botany Course 07: Carbon Literacy Knowledge Course 08: Environmental Health Course 09: Land Management Course 10: Conservation Whether you're a budding enthusiast or a seasoned gardener seeking to refine your skills, this comprehensive Gardening and Horticulture training bundle empowers you to flourish. Enhance your knowledge, nurture your passion, and unlock exciting career opportunities in the ever-evolving world of horticulture. Take the first step towards a greener future, enrol today! Learning Outcomes of Gardening and Horticulture Bundle Understand the fundamentals and benefits of organic gardening. Gain knowledge in homesteading and kitchen gardening techniques. Learn the process and intricacies of growing mushrooms. Acquire essential insights into agricultural science and practices. Develop a deep understanding of botany and plant biology. Grasp key concepts in carbon literacy and environmental health. Why Choose Us? Get a Free QLS Endorsed Certificate upon completion of Gardening and Horticulture Get a free student ID card with Gardening and Horticulture Training program (£10 postal charge will be applicable for international delivery) The Gardening and Horticulture is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Gardening and Horticulture course materials The Gardening and Horticulture comes with 24/7 tutor support Take a step toward a brighter future! ***Curriculum breakdown*** Main Course : Advanced Diploma in Gardening and Horticulture at QLS Level 7 Basic Botany Plant Classification Soil Science Plant Nutrition Requirements Plant Pests and Diseases Basic Concepts of Organic Gardening Weed Control Plant Propagation Amenity Horticulture, Plant Selection and Native Plants And much more... Course 01: Benefits of Organic Gardening Benefits Of Organic Gardening Organic Gardening Basics Having a Plan Having the Right Tools Making your Own Mulch Natural Pest Control Organic Fertilizer Planting Harvesting What to Avoid Benefits of Organic Gardening Course 02: Understanding of Homesteading Gardening Diploma Understanding Homesteading Homestead Gardening Types of Current Gardening Planting Foods Keeping Animals- Part 1 Keeping Animals- Part 2 Homestead Food Making and Preservation Homestead Crafts Homestead Activities Voltage Current and Resistance =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your QLS Endorsed Certificates and CPD Accredited Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £139) CPD 280 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Gardening and Horticulture Training Bundle is ideal for: Aspiring gardeners Agriculture enthusiasts Career changers Sustainability advocates Nature lovers Horticulture students Requirements No prior background or expertise is required for this Gardening and Horticulture bundle. Career path This Gardening and Horticulture Training bundle will allow you to kickstart or take your career to the next stage in the related sector such as: Garden Manager Landscape Architect Conservationist Agricultural Scientist Environmental Consultant Horticulturist Certificates Advanced Diploma in Gardening and Horticulture at QLS Level 7 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. Certificate Accredited by CPDQS Digital certificate - Included Upon passing the Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPDQS.

Level 7 Diploma in Gardening and Horticulture - QLS Endorsed
Delivered Online On Demand4 weeks
£109

Get Smart With QuickBooks 2020 for Windows

By Nexus Human

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

Get Smart With QuickBooks 2020 for Windows
Delivered OnlineFlexible Dates
Price on Enquiry

Town Planning Training Courses

By Imperial Academy

Free QLS Endorsed Certificate | 12 in 1 Exclusive Bundle with Free Certificates | 150 CPD Points | Installment Payment

Town Planning Training Courses
Delivered Online On Demand32 hours
£129

Food Hygiene Level 1 Fully Accredited and Certificated Course

5.0(2)

By Intellelearn

This Food Hygiene Level 1 online course is an excellent introduction to Food Safety. This course may be used to introduce children and people with an interest in preparing food safely for a family. It is ideal for use in schools, in addition to a regular curriculum, and for students before taking work experience in a food environment.Is this course accredited and recognised? Yes, this course is fully approved by IIRSM. Employers universally accept this qualification. You will be able to instantly download and print your certificate as soon as you successfully complete the course. How long will this course take me? Roughly 30 minutes. But you don't have to do it all in one go.Who should take this course? Anyone. Anyone who works around food or who is interested in a career in the food industry.Course TopicsWe build our courses so that you're able to better retain what you learn. This course is divided into five easy to follow interactive modules and includes a multiple-choice test at the end. The course covers the following: An introduction to food safety and hygiene Food Safety Hazards and Contamination Why Food Safety is important Personal Hygiene Hygienic Premises and Equipment Aims of the Training CourseBy the end of this Food Hygiene/ Food Safety course you will be able to: Understand food safety terms commonly used when discussing industry practice Understand the consequences of poor food safety and hygiene Know about practical activities to prevent and control hazards. Understand why personal hygiene is so important Be able to keep surfaces and equipment hygienically clean

Food Hygiene Level 1 Fully Accredited and Certificated Course
Delivered Online On Demand1 hour
£8

Chef Fundamentals: A Recipe for Automating Infrastructure

By Packt

The Chef-Certified beginner's guide to developing cookbooks locally and distributing changes with a Chef Server

Chef Fundamentals: A Recipe for Automating Infrastructure
Delivered Online On Demand9 hours 40 minutes
£101.99

Educational Psychology Level 3 & 4

By Imperial Academy

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

Educational Psychology Level 3 & 4
Delivered Online On Demand
£135

Data Science and Machine Learning using Python : A Bootcamp

4.7(160)

By Janets

Learning Outcomes After completing this course, learners will be able to: Learn Python for data analysis using NumPy and Pandas Acquire a clear understanding of data visualisation using Matplotlib, Seaborn and Pandas Deepen your knowledge of Python for interactive and geographical potting using Plotly and Cufflinks Understand Python for data science and machine learning Get acquainted with Recommender Systems with Python Enhance your understanding of Python for Natural Language Processing (NLP) Description Whether you are from an engineering background or not you still can efficiently work in the field of data science and the machine learning sector, if you have proficient knowledge of Python. Since Python is the easiest and most used programming language, you can start learning this language now to advance your career with the Data Science And Machine Learning Using Python : A Bootcamp course. This course will give you a thorough understanding of the Python programming language. Moreover, it will show how can you use Python for data analysis and machine learning. Alongside that, from this course, you will get to learn data visualisation, and interactive and geographical plotting by using Python. The course will also provide detailed information on Python for data analysis, Natural Language Processing (NLP) and much more. Upon successful completion of this course, get a CPD- certificate of achievement which will enhance your resume and career. Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment After completing this course, you will be provided with some assessment questions. To pass that assessment, you need to score at least 60%. Our experts will check your assessment and give you feedback accordingly. Career Path After completing this course, you can explore various career options such as Web Developer Software Engineer Data Scientist Machine Learning Engineer Data Analyst In the UK professionals usually get a salary of £25,000 - £30,000 per annum for these positions.

Data Science and Machine Learning using Python : A Bootcamp
Delivered Online On Demand24 hours
£9.99