8572 Courses

Intro to SQL training course description A hands on course focusing on the use of SQL. In particular this course does not concentrate on any particular version of SQL but rather enables delegates to recognise the differences found in SQL on different platforms. What will you learn Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to define databases. Intro to SQL training course details Who will benefit: Anyone working with databases. Prerequisites: None. Duration 2 days Intro to SQL training course contents What is SQL? What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends. Database basics RDBMS, Tables. Hands on Investigating a database. Basic SQL commands SQL Overview: SQL DML, SQL DDL, SQL queries. SELECT, WHERE and ORDER BY clauses. Combining conditions. IN, LIKE and BETWEEN. Hands on Querying a database from existing tables. SQL data retrieval Scalar functions. Hands on Selecting data from an existing database. More SQL data retrieval Scalar functions, variations. Aggregate functions, GROUP BY. HAVING. Hands on Selecting data from an existing database. Table joins Multiple tables, joins, keys, inner joins, left joins, right joins. Hands on Selecting data from an existing database. SQL basic data manipulation INSERT, UPDATE, MERGE, DELETE. Transaction controls: COMMIT, ROLLBACK. Hands on Modifying data in tables. SQL Data Definition USE, CREATE, DROP, TRUNCATE, ALTER. Hands on Managing new tables and columns. Data control GRANT, REVOKE. Hands on Defining permissions.

The objective of this qualification the Highfield Level 2 Award in Food Safety is to prepare learners for employment in catering role, or to support a role in the workplace. Learners gaining this qualification will know that safety in catering and manufacturing is the responsibility of everyone involved in the storage, preparation, cooking service and handling of ingredients. Its topics are regarded by the Foods Standards Agency as being important to maintaining good practice in the production of safe food, and are as follows: An introduction to food safety Microbiological hazards Contamination hazards and controls Food poisoning and its control Personal hygiene Design of premises and equipment Cleaning and disinfection Food pests and control Food safety management from purchase to service Food safety law and enforcement Revision and examination technique

To facilitate a group, family, team or organisation in thinking together around a given challenge or issue here is an opportunity to experience for real the person centred, futures planning tool – MAP (Pearpoint, Forest et. al. 1989). This is a process not a training day. Let us facilitate your planning and refocus your story whilst strengthening you and your group. This tool uses both process and graphic facilitation to help any group develop a shared vision and then to make a start on working out what they will need to do together to move towards that vision. MAPS are great for threshold moments. Is your team stuck? Want to move on, haunted by the past cannot get any useful dialogue about the future? Facing a challenging transition into a new school or setting? Leaving school? Bored with annual reviews, transition plans and review meetings? Want to find a way of making meetings and planning feel more real and engaging? Need an approach, which engages a young person respectfully together with his or her family and friends? Want the ultimate visual record of the process of a meeting, which will help everyone, keep track? Want to problem solve and plan for the future of a small or large group, service or organisation up to the size of an LEA Learning Objectives To create a shared vision To talk through the story so far and reflect upon it To name the worse nightmares that will block progress To strengthen the group by focussing on gifts and capacity To detail needs To specify an Action Plan To create a visual graphic record of the whole event Course Content The MAP process has 6 Steps: The story so far. The group is required to think back over the years to describe their collective experience of changes and events over time within their settings. Stories and events are recorded on the graphic. Building Shared Dreams. The group thinks together about what they would love to see happening for children, families and practitioners in their settings if they could have it all. If there were no constraints on time, money, resources, people or anything else what do they see happening in their imaginations? The various ideas that the group comes up with are then recorded in key words, images and colours on the MAP graphic. The purpose of this Step is to give the group a sense of direction, their North Star, an image of the place they want to work towards. Nightmare. In this Step, the group imagines the worst scenarios. What is the opposite of their dreams? How bad could it get? This is a shorter but powerful process that can give some groups more energy than dreaming together. Gifts and Capacity. In this Step the group is asked to take explicit stock of their capacities and what they already have going for them as they begin working towards the vision. This is a strong reminder for any group of the wealth of knowledge and experience that is already and always in the room. Needs. In this Step the group is invited to begin to name some of the needs they will have if they are to move forward to wards the dream and away from the nightmare. Actions. This is the final Step in the MAP and calls for individuals within the group to name a range of very specific actions (however small) that they will take within a definite time scale. This is not a time for declaring good intentions or suggesting good ideas for someone else to do. The purpose of this Step is to end the MAP process with a range of clearly understood actions that carry this planning process forward into the real world.

PRINCE2® Practitioner Projects fail for a variety of reasons including poor planning, lack of defined quality criteria, poor understanding of the business drivers, inadequate control, and lack of senior management involvement in other words, lack of a structured best practice approach to project delivery. PRINCE2® (6th Edition is the current version) is a structured, process-based approach for project management providing a methodology which can be easily tailored and scaled to suit all types of projects. It is the de facto standard for project management in the UK Government and is also used extensively in more than 150 countries worldwide with in excess of 20,000 organizations already benefitting from its powerful approach. It can be used easily in combination with PMI®'s PMBOK® Guide to provide a robust project methodology, or to augment an existing PMBOK®-based methodology with additional rigor around areas such as Quality, Organization, and Benefits Realization. The goals of this course are to take participants to the next level of understanding and application of the PRINCE2® methodology and to prepare them to sit the Practitioner exam. Using APMG provided sample exam papers and additional project case studies, participants will learn how to apply what they learned during the Foundation course and how to approach the OTE Practitioner exam, which is aimed at testing their ability to apply PRINCE2® in an actual project environment simulated via a case study provided as part of the exam. What you will Learn You'll learn how to: Tailor and apply the principles, themes, process structure, techniques, and management products of PRINCE2® within a work environment, via carefully selected case studies Define the PRINCE2® 6th Edition method at the Practitioner level Prepare for and take the Practitioner exam Getting Started Introductions Course structure Course goals and objectives Tailoring PRINCE2® Tailoring PRINCE2® Adopting PRINCE2® Tailoring PRINCE2® to suit different projects Adopting PRINCE2® in an organizational environment Controlled Start Recap management products Study business case and risk Study activities and responsibilities in: Starting up a project Initiating a project Controlled Progress Study management products and risk Study activities and responsibilities in: Getting work done Monitoring and reporting Issues and escalation Controlled Close Study Activities and Responsibilities in Closing a Project Activities and roles Roles and Responsibilities Principles Exercise Product-basedPlanning Producing a product breakdown structure (PBS) Producing a product flow diagram (PFD) Linking product breakdown structures and product flow diagrams to product descriptions

Cloud technologies training course description This course provides an introduction to cloud technologies, including, configuration and deployment, security, maintenance, and management. It covers all aspects of cloud computing infrastructure. It will help you to master the fundamental concepts, terminology, and characteristics of cloud computing. . What will you learn Contrast and compare AWS, GCP and Azure. Explain the different cloud services, models and characteristics. Explain cloud virtualization components and options. Explain cloud security options. Describe cloud automation, orchestration, monitoring and performance options. Cloud technologies training course details Who will benefit: Anyone working with or looking to work with cloud technologies. Prerequisites: None. Duration 2 days Cloud technologies training course contents What is the cloud? The Internet Cloud computing Benefits Disadvantages Cloud services IaaS, PaaS, SaaS, others. Cloud service providers AWS, GCP Microsoft Azure, others Cloud architectures Private, public, hybrid others Cloud based delivery The cloud and virtualization Virtual Machines, networks, storage, deployment. Accessing the Virtual Machine Secure cloud environments Security considerations. Data privacy considerations Automation and orchestration Monitoring and performance Performance Cost issues Cost containment

PMI-RMP® Exam Prep This course is aimed at preparing the participant to pass the PMI-RMP® (Risk Management Professional) exam. The course will also provide practical tips and tools that can be used in any organization's project management risk practices. In this expanded session, you will also have time to practice your exam taking skills with coaching from a credentialed instructor. The course includes the tool RMP-IQ, with sample exam questions to practice for the exam and allow participants to see their knowledge level in the various domains. What You Will Learn At the end of this course, participants will be able to: Explain the value and benefits of the PMI-RMP® credential Perform a self-assessment of your knowledge and skills Prepare a study plan that will allow you to pass the exam Foundation Concepts The Risk Management Professional (PMI-RMP®) Exam PMI's Standard for Risk Management Portfolios, Programs and Projects Key risk definitions Risk management life cycle Levels of Risk Management Enterprise Risk Management Portfolio Risk Management Program Risk Management Project Risk Management Risk Strategy and Planning: Part 1 Task 1: Perform a preliminary document analysis Task 2: Assess project environment for threats and opportunities Task 3: Confirm risk thresholds based on risk appetites Risk Strategy and Planning: Part 2 Task 4: Establish risk management strategy Task 5: Document the risk management plan Task 6: Plan and lead risk management activities with stakeholders Agile, programs, and portfolio aspects of risk strategy and planning Risk Identification: Part 1 Objectivity and bias Task 1: Conduct risk identification exercises Risk Identification: Part 2 Task 2: Examine assumption and constraint analysis Task 3: Document risk triggers and thresholds based on context / environment Task 4: Develop risk register Agile, programs, and portfolio aspects of risk identification Risk Analysis: Part 1 Task 1: Perform qualitative analysis Risk analysis in an agile environment Risk Analysis: Part 2 Task 2: Perform quantitative analysis Task 3: Identify threats and opportunities Program and portfolio aspects of risk analysis Risk Response Task 1: Plan risk responses Agile, programs, and portfolio aspects of risk response planning Task 2: Implement risk responses Monitor and Close Risks: Part 1 Task 1: Gather and analyze performance data Monitor and Close Risks: Part 2 Task 2: Monitor residual and secondary risks Task 4: Monitor project risk levels Task 3: Provide information required to update relevant project documents Agile, programs, and portfolio aspects of monitoring and closing risks

Managing Successful Programmes (MSP®) 5th Edition Practitioner: In-House Training Managing Successful Programmes (MSP®) is a globally-recognized framework for best practice programme management. MSP certification provides guidance for programme managers, business change managers, and the next step for project managers to develop their knowledge and skills to be able to positively respond to the challenges of managing programmes and larger, more strategic, or multiple projects. MSP 5th Edition emphasizes flexibility, adaptability, and responsiveness by adopting an incremental approach to the programme lifecycle and thus enabling organizational agility. AXELOS offers two levels of MSP Examination: MSP Foundation and MSP Practitioner. The MSP 5th Edition Foundation Examination is intended to assess whether the candidate can demonstrate sufficient recall and understanding of the MSP programme management framework. MSP 5th Edition Practitioner is for project, programme, and business change managers that want to build on their knowledge of MSP in order to practically apply the MSP framework to real-life scenarios, providing the skills to lead and manage a programme. It is a must-have certification for both project and programme management professionals to deliver organizational value to their employers and boost their careers. What you will Learn At the end of this course, participants will be able to: Understand how to apply the MSP principles in context Understand how to apply and tailor relevant aspects of the MSP themes in context Understand how to apply and tailor relevant aspects of the MSP processes in context Course Introduction Application of MSP Principles Program Strategy and Themes Application of Organization Theme Application of Design Theme Application of Justification Theme Application of Structure Theme Application of Knowledge Theme Application of Assurance Theme Application of Decisions Theme Application of MSP Processes

Instantly get that 'Dream Job' working in Spa, Salon or Cruise Ship and charging up to £50.00 per treatment. This is the perfect course for students starting out in 'Beauty Therapy'. You can choose to learn for 33 evenings or the 'Fast Track' of ONLY 5 Days plus coursework, case studies and homework. This course is accredited by the VTCT and recognised by the HABIA- Hair and Beauty regulated government standards. Professional Skincare & Facials This unit will allow a student to give a professional facial using a leading brand. It will prepare them for work in a salon/spa, allow them to identify different skin types and textures and provide a facial which is tailor-made to each client. Course Objectives To prepare students for certification in Professional Skincare & Facials, by covering the following: How to identify areas of improvement and apply the correct products Related anatomy and physiology Contraindications Health, safety and hygiene Consultation and record keeping Treatment planning Product knowledge Correct cleansing Spritz toning Controlled exfoliation Steam & extraction Different types of face mask Correct moisturisation Use of sun screen Mineral make up Manicures & Pedicures This unit will allow the student to perform a professional manicure and pedicure on a paying customer. It will prepare them for work in a salon/spa and allow them to identify potential nail conditions, to file and paint correctly and to apply luxury applications such as paraffin wax. Course Objectives To prepare students for certification in Manicures & Pedicures, by covering: Removal of nail polish Cuticle work Correct nail filing Nourishing and conditioning the nails and hands How to apply nail polish Arm and hand massage Correct washing and cleansing of the feet Exfoliation and removal of dead skin cells Correct nail filing Nourishing and conditioning the feet and toe nails Cuticle work How to apply nail polish Leg and foot massage Health & Safety Related anatomy & physiology (The hands and nails) Contra-indications After-care Extras not offered in other schools: Heated paraffin wax Hand and foot masks Deep exfoliation Heated hand mitts and booties Hot oil treatment Waxing This unit will prepare the student to provide a professional waxing service using warm and hot wax to specific areas of the body. They will learn about hair growth cycles, correct application of wax and removal. What To Expect From This Course This is an exciting and intensive course which will teach students how to perform strip waxing. Areas covered will include: Arms Legs Back Eyebrows Lip Chin and face An extra unit is now covered with hot wax application for the more safe removal of hair to the following area: Bikini Eyelash and Brow Tinting This unit will teach a student how to correctly identify the correct colour for tinting of eyebrow and eyelash and will allow them to improve the appearance of clients who may have pale or uneven hair growth. Client consultation Contra-indications and Contra-actions Related Anatomy & Physiology Patch Testing prior to treatment Health & Safety pre-requisites Tinting Eyelashes & Eyebrows Identifying the correct Colour for All Types of Skin Tone and Hair Colour Aftercare advice Cosmetic Make Up This unit will guide the student on how to perform a correct make-up application. They will be able to perform the correct application for day, evening and occasional. Client consultation Contra-indications and Contra-actions Related Anatomy & Physiology and Health and Safety Facial Examination and skin analysis Cleansing and preparing the Skin Skin Anatomy and facts Correct choice of Make Up Products Correction Techniques Day, Evening & Special Occasion Make Up How to identify Diiferent Face, eye and lip Shapes, Skin Types and skin tone Aftercare advice Mineral Make Up Our school works with the accredited mineral make-up Bella Pierre. Know for camouflage and health purposes, mineral make-up is one of the only make-ups that can be applied after a facial treatment. Health & Safety, Client Care Health and safety in salon and spa is an essential criteria which is necessary to ensure the safety of the student and the client. How to avoid cross-contamination First Aid Coshh Riddor Hygiene in the workplace Related Anatomy & Physiology The study and certification of Anatomy and Physiology is a pre-requisite required in order to legally carry out treatments as a working therapist. It allows a therapist to recognise how their treatment can effect and improve bodily functions. The course will cover the following: Cells and Tissues The Skeletal System The Integumentary System The Blood Lymph Systems The Muscular System Neurology The Digestive and Excretory Systems The Respiratory and Olfactory Systems The Endocrine and Reproductive Systems Arthrology Health and Safety Issues Salon Management Hygiene in the Workplace Certification Upon completing all units, assessments and criteria and receiving 85% achievement, an NVQ Level 2 Certificate will be issued Pre-Requisites This course is for a complete beginner and offers a full introduction into the beauty industry What You Need To Bring What you need to bring along to the course. Towels, creams, oils, lunch! What We Provide We provide - massage couches, safe and enjoyable place to learn. Purchasing a kit for this course We provide a fully operational kit for our students. Please enquire as to costs. Duration 1 day a week on Friday for 8 weeks, 9.30am – 4.30pm Evening course option: 1 evening per week 6pm – 9pm for 13 weeks -- OR -- Optional training tailor-made to suit your needs and requirements These courses are on going so you can join at any stage and integrate into existing classes. FAST TRACK AVAILABILITY ONE PLACE LEFT FOR: Sat 5th April to Tue 8th April and Tue 15th and Wed 16th April FURTHER FAST TRACK DATES AVAILABLE ON REQUEST. WE OFFER ONE TO ONE TRAINING TOO! (Subject to availability and a price supplement). Remember, we are different, there is NO other Academy like us. We set our dates around you. OUR MISSION STATEMENT: Here at The Angel Academy of Teaching and Training, we go that step further to help our students. We offer the opportunity for a student to attend a course as many times as they would like until they feel truly confident and they only ever have to pay ONCE! We also offer assistance and guidance throughout their course and unlike other Schools will assist student's in completion of their log book, assessments and portfolio. Don't Miss Out- BOOK NOW! Dates and Costs Please see below our list of upcoming courses. Click on the course for further information, request a call or email regarding the course or book now! We are quite flexible in terms of course dates so if you would like to organise a course around your timetable, please contact us! Course Days Dates Cost NVQ Level 2 In Beauty Therapy ** FAST TRACK OPTION ** 8 OPEN OPEN £1599 NVQ Level 2 In Beauty Therapy ** FAST TRACK ** 8 14/10/2023 21/10/2023 £1680 NVQ Level 2 In Beauty Therapy 'FAST TRACK' 8 7/11/2023 14/11/2023 £1680 NVQ Level 2 In Beauty Therapy ** FAST TRACK OPTION ** 8 12/12/2023 19/12/2023 £1680 NVQ Level 2 In Beauty Therapy ** FAST TRACK OPTION ** 8 20/01/2024 28/01/2024 £1680 NVQ Level 2 In Beauty Therapy ** FAST TRACK OPTION ** 8 16/02/2024 23/02/2024 £1680 NVQ Level 2 in Beauty Therapy ** FAST TRACK WEEKENDS OPTIONAL 8 3/03/2024 10/03/2024 £1680 NVQ Level 2 In Beauty Therapy ** FAST TRACK OPTION ** 8 14/04/2024 21/04/2024 £1680 NVQ Level 2 In Beauty Therapy ** FAST TRACK OPTION ** 1 11/05/2024 17/05/2024 £1680

RESILIA™ Foundation: In-House Training AXELOS RESILIA™: Cyber Resilience Best Practice is designed to help commercial and government organizations around the world prevent, detect, and correct any impact cyber attacks will have on the information required to do business. Adding RESILIA to the existing AXELOS global best practice portfolio, including ITIL® and PRINCE2®, brings a common cyber resilience best practice for security, IT service management, and business. Active cyber resilience is achieved through people, process, and technology. The RESILIA™ Foundation course starts with the purpose, key terms, the distinction between resilience and security, and the benefits of implementing cyber resilience. It introduces risk management and the key activities needed to address risks and opportunities. Further, it explains the relevance of common management standards and best practice frameworks to achieve cyber resilience. Subsequently, it identifies the cyber resilience processes, the associated control objectives, interactions, and activities that should be aligned with corresponding ITSM activities. In the final part of the course, it describes the segregation of duties and dual controls related to cyber resilience roles and responsibilities. What you will Learn At the end of this course, you will be able to: Demonstrate your knowledge of the purpose, benefits, and key terms of cyber resilience Demonstrate your knowledge of the risk management and the key activities needed to address risks and opportunities Demonstrate your knowledge of the purpose of a management system and how best practices and standards can contribute Demonstrate your knowledge of the cyber resilience strategy, the associated control objectives, and their interactions with ITSM activities Demonstrate your knowledge of cyber resilience design, the associated control objectives, and their interactions with ITSM activities Demonstrate your knowledge of cyber resilience transition, the associated control objectives, and their interactions with ITSM activities Demonstrate your knowledge of cyber resilience operation, the associated control objectives, and their interactions with ITSM activities Demonstrate your knowledge of cyber resilience continual improvement, the associated control objectives, and their interactions with ITSM activities Demonstrate your knowledge of the purpose and benefits of segregation of duties and dual controls Course Introduction Course Learning Objectives Course Agenda Activities Course Book Structure RESILIA Certification Introduction to Cyber Resilience What is Cyber Resilience? Defining Cyber Resilience Balancing in Cyber Resilience Characteristics of Cyber Resilience Risk Management Understanding Risk Management: Discussion Defining Risk Management Addressing Risks and Opportunities Managing Cyber Resilience Why and What of Management Systems? Management Systems Common Management Standards and Frameworks Cyber Resilience Strategy What is Strategy? Cyber Resilience Strategy and Activities Security Controls at Cyber Resilience Strategy Interaction Between ITSM Processes and Cyber Resilience Cyber Resilience Design Why Cyber Resilience Design? Cyber Resilience Design Activities Security Controls at Cyber Resilience Design Aligning ITSM Processes with Cyber Resilience Processes Cyber Resilience Transition Why Cyber Resilience Transition? Basics of Cyber Resilience Transition Cyber Resilience Transition: Controls Interaction Between ITSM Processes and Cyber Resilience Cyber Resilience Operation The Purpose of Cyber Resilience Operation Security Controls in Cyber Resilience Operation Interaction Between IT Processes and Cyber Resilience Interaction Between ITSM Functions and Cyber Resilience Cyber Resilience Continual Improvement Continual or Continuous Improvement Maturity Models Continual Improvement Controls The Seven-Step Improvement Process The ITIL CSI Approach Cyber Resilience Roles & Responsibilities Segregating Duties Dual Controls

Advanced Kibana training course description This training course is aimed at users who already have some experience with Kibana, who are looking to further their knowledge. What will you learn Lens Timelion Maps Custom Visualisations with Vega Canvas Filters and Controls Drilldown and Dashboards KQSL and ElasticQueries Scripted and RunTime Fields Alerts and Alarms Advanced Kibana training course details Who will benefit: Users who already have some experience with Kibana, who are looking to further their knowledge. Prerequisites: None Duration 1 day Advanced Kibana training course contents Topics Lens Visualisation types (tables,bars,charts) Category breakdown Adding multiple metrics Using formulas in metrics Labels Adding reference layer Limitations Visualise Library Timeseries, Metrics Different types of aggregations Maps GeoMapping Heat Maps Using ES index as data source Visualisation, tool tips Custom Visualisations with Vega Introduction to vega scripting Canvas Widgets and Texts Elasticsearch SQL Canvas Expressions Filters and Controls Dropdown filters Ad-hoc filters Searchbar filters Drilldown Dashboards Linking one dashboard to another KQSL and ElasticQueries Bool Query AND/OR Phrase Part match vs keyword search Wildcard search Scripted and RunTime Fields Creating ad-hoc calculated fields using scripts Performance issues Alerts and Alarms Query Based Formatting output Connector types(email,index,teams etc)