11429 Environment courses in Viewpark delivered Online

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

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

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

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)

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

The Admin, Secretarial & PA - Mega Bundle online course is a comprehensive and tailored program designed to enhance your skills and knowledge in the field of administrative support. Whether you're aspiring to become a professional administrator, a skilled secretary, or a proficient personal assistant, this course provides you with the essential tools and techniques to excel in your role. This Mega Bundle course offers a wide range of modules that cover various aspects of administrative responsibilities. You'll delve into the fundamentals of office management, including organizing schedules, coordinating meetings, and maintaining effective communication channels. Additionally, you'll learn vital skills such as record-keeping, data management, and file organization, ensuring efficiency and productivity in your daily tasks. The course also focuses on honing your interpersonal and communication skills, as these are crucial in providing exceptional support to executives and teams. You'll gain insights into effective communication strategies, professional etiquette, and how to handle challenging situations with tact and diplomacy. Moreover, the Admin, Secretarial & PA - Mega Bundle online course goes beyond the traditional administrative roles by incorporating modules on project management, event planning, and even digital marketing. This allows you to expand your skill set and become a valuable asset in today's fast-paced and dynamic work environments. As an online course, it offers the flexibility to learn at your own pace and convenience. You can access the course materials from anywhere, at any time, making it ideal for busy professionals or individuals seeking to upgrade their skills while juggling other commitments. Upon completion of the Admin, Secretarial & PA - Mega Bundle online course, you'll have gained a comprehensive understanding of the administrative field, acquired practical skills, and developed the confidence to excel in your chosen career path. Whether you're looking to start a new career or enhance your existing role, this course provides the knowledge and tools necessary to thrive in the world of administration and support. Contains: Admin, PA and Secretarial Certification PA Telephone Skills Certification Touch Typing and Shorthand Executive Admin & PA Certification Level 3

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

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

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