20039 Courses in Cardiff delivered Online

Change Management™ Practitioner - Going Beyond the Basics and Practitioner Exam Preparation: On-Demand This course will further develop some of the knowledge of Change Management learned during the Foundation certification. You will consider what learning is required and how best to design and deliver it. Then the course will provide an understanding of how Change Management fits into the project management environment. A major challenge with change is making it stick. The course will show how to sustain change by understanding the levers for change, models of adoption, and reinforcing systems. This course also prepares you for the APMG Change Management Practitioner exam. Given that a primary course goal is to achieve the Practitioner Certification, daily homework assignments and practice exams will be provided. The Practitioner-level exam is taken at the end of the second day of the Traditional Classroom course. Virtual Classroom and On-Demand participants must make separate arrangements to schedule their exam following course completion (See "Important Note for Virtual and On-Demand Participants"). What You Will Learn You'll learn how to: Understand the key principles in defining what is to be learned by all involved in a change initiative Describe the project environment in which change is governed and delivered Understand the organizational "levers", adoption approaches, and reinforcing systems typically used to sustain change Improve your ability to pass the APMG Change Management Practitioner Certification exam Getting Started Introductions Course structure Course goals and objectives Learning and Change Defining and managing the required learning to enable change The Project Management Environment Understanding the project environment Identifying key roles Developing a change delivery plan Sustaining Change How levers enable the adoption of change Types of levers (Environmental levers, Leadership levers, and Organizational Development levers) Models of adoption and reinforcing systems APMG Change Management Practitioner Exam Preparation Review of and practice with APMG sample questions and test papers APMG Change Management Practitioner Exam Traditional Classroom: The exam is taken and submitted to APMG for marking Virtual Classroom and On-Demand: The exam is scheduled by the Participant and taken subsequent to the course

  The course imparts knowledge about the fundamental principles and concepts underpinning crisis management, as well as how to effectively establish and implement a crisis management framework. In addition to elucidating the theoretical aspects of crisis management, the training program incorporates practical examples and scenario-based quizzes to bolster your understanding and prepare you for real-life crisis management situations. Upon successfully completing the training course, participants are eligible to take the exam and, upon passing, gain the "IECB Certified Lead Crisis Manager" Certification. This credential attests to the participant's possession of both theoretical and practical expertise, enabling them to guide and support an organization in crafting and enhancing its crisis management capability in alignment with ISO 22361 standards and industry best practices. Learning Objectives   Upon completing this training course, participants will achieve the following learning objectives: Elucidate the fundamental principles and concepts underpinning crisis management, as per ISO 22361 standards. Establish, sustain, and enhance a crisis management framework that encompasses leadership, structure, culture, and competence. Foresee, evaluate, avert, and ready for potential crises. Respond to, recuperate from, and garner insights from crises to enhance an organization's crisis management prowess.   Our approach   This training is based on both theory and best practice Lessons are illustrated with examples based on case studies Practical exercises are based on a real world case study Practice tests are similar to the Certification Exam   Course Agenda   Day 1: Introduction to ISO 22361 Day 2: The Crisis Management framework Day 3: Preparedness and Crisis prevention Day 4: Crisis response and recovery and the Certification exam   Who Should Attend?   The Lead Crisis Manager training course is designed for: Professionals accountable for establishing a crisis management capability within their organization. Professionals tasked with executing a crisis management plan and framework within their organization. Leaders responsible for managing crises. Members of crisis management teams. Individuals with a keen interest in comprehending crisis management. Those looking to initiate or progress their careers in the field of crisis management. Consultants, advisors, and experts seeking comprehensive insight into ISO 22361 crisis management guidelines. Accreditation Assessment   All candidates at official training courses are tested throughout their course with quizzes and exercises, in combination with a final exam held on the last day of the course. Both elements are a part of the overall score. For this course, the final exam constitutes a 12 question essay type which should be completed within 180 minutes. A passing score is achieved at 70%.   Exam results are returned within 24 hours, with successful candidates receiving both a digital badge and a Certificate of Achievement. Prerequisites   Delegates should have a basic understanding of ISO 22361 What's Included?   Participant Guide Study materials Exam Pass Guarantee Provided by   This course is Accredited by NACS and Administered by the IECB

This beginner to intermediate level qualification course provides a structured exploration of the world of wine and is suitable for both wine industry professionals and wine enthusiasts. Individuals on this course will gain knowledge of the principal and regionally important grape varieties of the world and the styles of wine they produce. Through a combination of tasting and theory, candidates will explore the factors that impact style and quality and learn how to describe wines with confidence.

ITIL® 4 Leader: Digital and IT Strategy: Virtual In-House Training The ITIL® 4 Leader: Digital and IT Strategy (DITS) is one of the two modules in the ITIL® 4 Strategic Leader (SL) certification scheme. The other module in the SL designation is the ITIL® 4 Strategist: Direct, Plan & Improve. Accredited training for the ITIL® 4 Strategic Leader modules is mandatory to enable full understanding of the core material. The ITIL ® 4 Digital and IT Strategy certification focuses on enabling business success through the creation of digital and IT strategies. The IT and Digital Strategy certification adds a new perspective to the ITIL suite and elevates the discussion around ITIL concepts to a strategic level among business leaders and aspiring leaders. The ITIL® 4 Digital and IT Strategy course is based on the ITIL® 4 Digital and IT Strategy exam specification from AXELOS. With the help of ITIL® 4 concepts and terminology, exercises, and examples included in the course, you will acquire relevant knowledge to pass the certification exam. The core learning material in the course is supported by interactive case study, discussions and activities. What You Will Learn The ITIL ® 4 Digital and IT Strategy course covers the content in relation to the following learning outcomes of the exam specification for ITIL ® 4 Digital and IT Strategy: Demonstrate the use of the ITIL guiding principles in Digital and IT Strategy decisions and activities Understand how to leverage digital strategy to react to digital disruption Understand the relationship between the concepts of Digital and IT Strategy, the service value system and the service value chain, and explain how to utilize them to create value Understand how an organization uses Digital and IT Strategy to remain viable in environments disrupted by digital technology Understand strategic approaches made possible by digital and information technology to achieve customer/market relevance and operational excellence Understand the risks and opportunities of Digital and IT Strategy Understand the steps and techniques involved in defining and advocating for a Digital and IT Strategy Understand how to implement a Digital and IT Strategy Key Concepts of Digital and IT Strategy Digital, Information, and Communication Technology Digital Transformation Services, Products, and Competitive Advantage Tiers of Strategy Business Models Operating Models Strategy and the Service Value System Opportunity and Demand Value Governance ITIL® Guiding Principles Continual Improvement ITIL® Practices What is Vision? Disruptions Vision Digital Disruptions Balanced Strategic Focus Positioning Tools for Digital Organizations Assignment 1: Digital Disruption and Digital Positioning Where Are We Now? Environmental Analysis Opportunity Analysis Digital Readiness Assessment How Do We Get There (Strategic Planning) Strategy Planning Financial Aspects of Digital and IT Strategy Business Models for Strategy Planning Portfolio Optimization How Do We Get There (Strategic Approaches) Strategic Approaches for Digital Organizations Strategic Approaches for Operational Excellence Strategic Approaches to Evolution Strategic Approaches to Social Responsibility and Sustainability Assignment 2: Strategic Approaches for Digital Organizations Take Action (Managing Strategic Initiatives) How Strategies are Implemented Coordinating Strategy and Strategic Initiatives Leading Digital Transformation Digital Leadership Assignment 3: Strategy Planning and Communication Did We Get There? (Measuring Strategy) Key Facts About Measurement Measuring a Strategy Instrumenting Strategy How Do We Keep the Momentum Going Long-Term Momentum: Ensuring Organizational Viability Short-Term Momentum: Parallel Operation Assignment: Digital Strategy in VUCA Environment Managing Innovation and Emerging Technologies Managing Innovation Formal Approach to Innovation Management Culture that Supports Innovation Approaches to Innovation Evaluating and Adopting Emerging Technology Managing Strategic Risk Risk Management Risk Identification Risk Posture Risk Treatment

Agile is not what you do, Agile is what you become! An introduction to the essentials of Agile Scrum as a delivery method. The same learning objectives as used in central government & public sector digital delivery projects. Agile is not what you do, Agile is what you become! Since 2012, all government departments have been required to use the Agile approach to project management, to build and run new digital services. As you begin your Agile journey, one of your first challenges will be understanding the rules and roles that support Agile delivery, some of the most frequently asked questions are "Which Agile framework is applicable to our business operating model?" or, "Is the Project Manager role equivalent to that of theProduct Owner?" and, "What does a Scrum Master do?" A strong corporate culture not accustomed to the Agile mindset can also be a difficult environment in which to implement Agile methods. In some cases, the company’s culture and practices may reward non-Agile milestones while inadvertently discouraging Agile success. This intensive two-day training course combines PowerPoint presentations, informal discussions and practical exercises to introduce you to Agile Scrum as a Delivery Method, without the impending pressure of having to pass a formal certification examination. Previous experience of Agile delivery is not a pre-requisite to attending this course, although it is assumed delegates have previously attended the Primer course, or have some understanding of Agile Scrum terms and practices. This course, designed by Agile Scrum practitioners and coaches with specialist experience of working on GDS (Government Digital Service) Service Standards compliant government and public sector projects has been accredited by The CPD Certification Service and is now available outside its usual central government and public sector digital delivery setting. Who this course is for Service and Programme Managers If you are a Service Manager or Programm Manager who wants to explore the benefits of transitioning to Agile ways of working and want to understand how your existing business processes and resource landscape will fit into an Agile delivery model, then this course aims to provide you with enough information to enable you to make an informed decision. Career ambitions If you are new to Agile and your intention is to pursue a career either as an Agile Scrum Master or Agile Product Owner, you will hopefully be provided with enough knowledge to enable you to determine which role best suits your Agile career ambitions. Frequently Asked Questions How this course differs from other Agile courses Delegates will learn the 'How', not just the 'What'! This course has been designed by highly experienced Agile practitioners and coaches with specialist real-life experience of working on GDS (Government Digital Service) Service Design Standard projects. Delegates will find that the learning objectives are significantly more detailed than with other Agile courses which only focus on teaching the learning objectives of The Scrum Guide. Delegates must take the certification assessment. No! During enrolment, delegates can opt out of taking the C-ASDM certification assessment. The online Agile Scrum as a Delivery Method – Essentials course quiz is optional Absolutely! Delegates are provided access to the online Agile knowledge quiz which accompanies the Agile Scrum as a Delivery Method – Essentials course. The quiz helps delegates gauge their level of attainment but is entirely optional. Delegates can take the certification assessment without enrolling on the course. Yes! Delegates with existing Agile project delivery experience can choose to take the certification assessment without enrolling on the course. I will receive my certificate as soon as I have completed the course You will initially receive an Assessment Completion report after completing the assessment. The report details the certification status: 'Pass' or 'Fail', and includes information on which questions were answered incorrectly. Your certificate is issued by the CPD Certification Service approximately four-to six-weeks after successfully completing and passing the C-ASDM Certification Assessment. A CPD certification is recognised by employers Yes! CPD certification is recognised by private and public sector employers, and in central government departments as a valuable way to evaluate the skills of an individual, and the quality of the learning activities. Listing your CPD certification as well as the number of CPD Points you have achieved on your CV is essentially showcasing your achievements in continuing your professional development. One CPD Point is equivalent to an hour of training CPD points are units that quantify time, and the quality of learning and development activities. Delegates will earn 3 CPD Points upon successful completion of the C-ASDM Certification Assessment or 13 CPD Points after completing the two-day course. My CPD certificate will expire after three years Your certificate will not expire however, best practice suggests a renewal after three years. You can do this by enrolling on the C-ASDM course to ensure your knowledge of Agile as a Delivery Method is up to date. Service features Two-day Agile Scrum training course The course uses eCommerce and other Business Case examples for context Optional online CPD certification assessment Optional Agile knowledge quiz to help delegates gauge level of attainment Online Retrospective feedback to enable continuous course improvements. Service benefits Delegates will understand the concepts and benefits of Agile Scrum development Scrum team roles and role accountabilities INVEST-compliant User Stories and BDD formatted Acceptance Criteria Agile approach to incremental project delivery Agile artefacts and Agile reports (burn-down & burn-up charts) Agile Events & Scrum rules Comparison: Agile methodologies (Lean, XP, SAFe & Scrum) Use of Kanban for workflow management Government Digital Service (GDS) Service Standards and Service Assessment Be able to communicate the ideals of Agile to stakeholders Service Agenda General knowledge Agile Delivery 101 Scrum process and sprints Applicability of Scrum Agile Manifesto Scrum roles and accountabilities Overview of Scrum roles (Core & Ancillary) Scrum Master role and role responsibilities Scrum Product Owner role and role responsibilities Scrum team Scrum events Sprint Planning Daily Scrums Sprint Reviews Sprint Retrospectives Scrum artefacts Product Backlog Sprint Backlog Increments Scrum Reports Burn-down and Burn-up Charts Scaling Scrum Working with multiple Scrum teams Working with distributed Scrum teams GDS (Government Digital Service) Service Standards Service Assessments Risks and challenges Risks and challenges of transitioning to Agile delivery Frequently asked questions Discussion on frequently asked Agile questions Agile knowledge quiz Examples of the multiple-choice questions in the optional online quiz On-going support Email support No Telephone support No Webchat support No Online support No Community Support Yes! Delegates are offered access to our private online 'Community of Agile Scrum Practitioners'. Delegates who achieve the pass mark for CPD certification are additionally offered access to our private 'Certified Scrum Practitioners’ Guild', a private Slack community of like-minded Agile professionals.

Course Highlights: Course Type: Self-Paced Online Learning Total Qualification Time: 60 hours Guided Learning: 55 hours Accreditation: Pearson Edexcel Qualification: Nationally Recognised Qualification Study Materials: High-Quality E-Learning Study Materials Assessment: Internally graded and externally verified Access: 1 Year Access Certificate: Certificate upon completion of the official exam (hard copy) Tutor Support: Paid Tutor Support Customer Support: 24/7 live chat available Entry Level 1 Functional Skills English Training Course This Functional Skills Entry Level 1 English Course is governed by Ofqual, accredited by Pearson Edexcel making it a nationally recognized credential that will improve your CV while helping you stand out from the rest of the applicants. You will be able to enhance your overall English speaking, listening, writing and reading skills via a range of well-designed and updated course materials. Upon successful completion of this course, you will be prepared with the necessary English skills to advance to this qualification’s higher levels. Why is this course right for you? This comprehensive Functional Skills Entry Level 1 English Course is suitable for: Anyone looking to secure a skill-oriented job Anyone who wants to enhance their English communication skills People of all ages and academic backgrounds Anyone who wants to advance to functional skills level 1 or 2 Anyone who wants to take GCSE English Anyone seeking to add a certified qualification to their university application Anyone aspiring to accelerate their career in this as an English instructor or teacher Anyone who wants to gain in-depth knowledge of functional skills in English Whether you are a beginner into the field of functional English or any professional seeking to reinforce your expertise in basic English, this Functional Skills Entry Level 1 English will set you up with the advanced skills to boost your career profile. EXAM Booking & Results Details You can decide the exam date and place according to your convenience. Awarding Body Paper-Based Exam in Centre Results Pearson Edexcel Book within 15 days Get results in 20 working days *Offline examinations will be held at our Swindon and London centres. Please contact us for more information.  Functional Skills Entry Level 1 English Qualification Purpose and Outcomes This Functional Skills Entry Level 1 English Qualification will help you to: Listen, comprehend, and react to verbal communication in a variety of scenarios Develop an understanding of common words and their effects Use that understanding of common words in various contexts Read common texts at work and in daily life accurately Gain the confidence to read more widely Write common texts and documents clearly and effectively Show a firm command of spelling, punctuation, and grammar Course Curriculum Say the names of the letters of the alphabet Identify and extract the main information from short statements and explanations Follow single-step instructions, asking for them to be repeated if necessary Make requests and ask straightforward questions using appropriate terms and registers Respond to questions about specific information Make clear statements about basic information and communicate feelings and opinions on straightforward topics Understand and participate in simple discussions or exchanges with another person about a straightforward topic Read correctly words designated for Entry Level 1 (see Annexe B) Read simple sentences containing one clause Understand a short piece of text on a simple subject Punctuate simple sentences with a capital letter and a full stop Use a capital letter for the personal pronoun ‘I’ and the first letter of proper nouns Use lower-case letters when there is no reason to use capital letters Write the letters of the alphabet in sequence and in both upper and lower case Spell correctly words designated for Entry Level 1 (see Annexe B) Communicate information in words, phrases and simple sentences How This Course Will Work? This Functional Skills Entry Level 1 English course will help you build a solid foundation in english. Throughout the course, it will provide you with various learning materials and activities to enhance your understanding of these subjects. Initial Assessment: To identify the current level of a student's abilities and recommend the appropriate course to enrol in upon completion. Diagnostic Assessment: Identifies skill gaps and produces an individual learning plan Learning Resources: Comprehensive video tutorials, practice quizzes & topic-based tests Progress Tracker: To record your progress in the course Free Mock Test: Access our free mock test facility for professional feedback and to prepare for the final exam. Entry Requirement This Functional Skills Entry Level 1 English qualification is available to all students of all academic backgrounds; no experience or previous qualifications are required. Exam Structure The Pearson Edexcel Functional Skills Qualification in English at Entry Level 1 comprises a writing and reading assessment that is externally set, internally graded, and externally verified by the exam body. The listening and speaking assessment is, however, internally set. Your exam results will be forwarded to the awarding body’s internal verifier once you finish the exam. The writing and reading assessment is available as paper-based for which you will be required to appear for the exam at our designated office in London or Swindon on the exam day. You will be required to take the speaking, listening, and communicating assessment via Zoom. You need to be registered for the exam three weeks prior to the exam date. The Pearson Edexcel Functional Skills Qualification in English at Level 2 consist of 3 exams, these are Reading, Writing and Speaking, Listening and Communicating. Speaking, Listening and Communicating (SLC) Exam Awarding Body Duration Number of Marks Pearson Edexcel Up to 25 minutes Pass/Fail SLS Exam Pearson Edexcel: Speaking, listening and communicating are assessed through one 5-minute presentation and linked question and answer session in groups of three to five and one 15-minute formal discussion together in groups of three to five learners. This exam will be conducted via Microsoft Teams. Reading Exam Awarding Body Duration Number of Marks Pass Mark Pearson Edexcel 40 minutes 12 65% Reading is assessed through a test consisting of multiple-choice, short open-response and medium open-response questions. Writing Exam Awarding Body Duration Number of Marks Pass Mark Pearson Edexcel 40 minutes 30 63% Reading/Writing Exam Pass Mark: Learners are required to achieve an overall percentage of marks mentioned in the above table to pass the English reading exam. However, the awarding process will determine specifically where the pass mark sits for each assessment version. Therefore, the pass mark may vary between assessments. Progression Opportunities in this Functional Skills Entry Level 1 English Qualification Upon achieving the Pearson Edexcel Functional Skills Qualification in English at Entry Level 1, you can: Progress to Level 1 and Level 2 Study GCSE English Advance to further vocational studies Access a wide range of professions within your chosen field Recognised Accreditation This Functional Skills Entry Level 1 English has been independently accredited by Pearson Edexcel also regulated by Ofqual. The Office of Qualifications and Examinations Regulation (Ofqual) is responsible for regulating qualifications, assessments, and examinations in England. Pearson Edexcel is the most prestigious awarding body, for an academic and vocational qualifications. Pearson Edexcel qualifications are regulated by Ofqual and recognised by universities and employers across the world. Certificate of Achievement You will be rewarded with an Ofqual Regulated Pearson Edexcel Functional Skills Qualification in English at Entry Level 1 (depending on what you choose as an accreditation) upon successful completion of this Functional Skills Entry Level 1 English and passing the assessments. A certified hard copy of this qualification will be posted at your given address which is accepted by employers and universities across the globe. You can flaunt this qualification in your CV which will give you a competitive advantage over others in case of securing a job.  FAQs What are functional skills? Functional skills are practical skills in Maths, English, and ICT that enable people to apply their knowledge to real-life situations. These skills are designed to provide learners with the essential knowledge needed to succeed in the workplace and in their personal lives. Functional Skills are recognised qualifications in the UK and are offered at different levels, including Entry Level, Level 1 and Level 2. What is the difference between entry-level and level 1 and 2 functional skills? Both are recognised qualifications, but levels 1 and 2 are more advanced levels that will provide you with comprehensive skills and knowledge while entry-level courses are an introduction and basic level qualification to go to subsequent levels. Is it required to complete entry-level qualifications to move onto a level? No, you are not obliged to complete entry-level courses before moving on to higher levels. However, entry-level courses serve as a starting point for acquiring basic skills and knowledge that will help you strive and boost your chances of securing better marks at higher levels. Are functional skills qualifications recognised and accepted in the UK? Yes, functional skills qualifications are an accepted part of all apprenticeship standards and a way to progress to further education in the UK. Do I have to physically appear for the exam? Yes, for the writing and reading assessment, you will be required to appear for the exam at our designated office in London or Swindon on the exam day. You will be required to take the speaking, listening, and communicating assessment via Zoom. Do I have to register for the exam? Yes, you need to be registered for the exam three weeks prior to the exam date. What is the assessment procedure for an entry-level 1 English course? This course comprises a writing and reading assessment that is externally set, internally graded, and externally verified by the exam body. The listening and speaking assessment is, however, internally set. Your exam results will be forwarded to Pearson Edexcel's internal verifier once you finish the exam. If you pass all three components, you'll be able to receive the qualification certificate from the awarding body. How to pass the Functional Skills English entry level 1 exam? Tips for preparing for the exam include understanding the exam format, practising regularly, mastering the basics and managing time well during the exam, and seeking help from a teacher or tutor. To assist you in gaining the skills and knowledge required to pass the exam, Lead Academy offers 24/7 tutor support. As a result, you will be adequately prepared to ace the exam. Can I take entry-level courses online? Yes, you can take functional skills entry-level courses online. Lead Academy offers an extensive range of entry-level courses from level 1 to 3, available for both English and Maths. Are Functional skills easier than GCSE? Functional Skills qualifications may require hard work and revision, but they can be a better fit for students who have found Maths and English challenging. Unlike GCSEs, Functional Skills qualifications are flexible and designed to meet the needs of diverse learners, making them more adaptable to different learning styles. What will I get after finishing the course? After successfully completing the Entry Level 1 English course, you will receive a Pearson Edexcel Functional Skills Qualification in English at Entry Level 1 (depending on what you choose as an accreditation) that is highly regarded by universities and employers across the UK.

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

Course Highlights: Course Type: Self-Paced Online Learning Total Qualification Time: 58 hours Guided Learning: 55 hours Accreditation: NCFE, Pearson Edexcel & Open Awards Qualification: Nationally Recognised Qualification Study Materials: High-Quality E-Learning Study Materials Assessment: Internally graded and externally verified Access: 1 Year Access Certificate: Certificate upon completion of the official exam (hard copy) Tutor Support: Paid Tutor Support Customer Support: 24/7 live chat available Functional Skills Maths Entry Level 3 Course This Functional Skills Entry Level 3 Maths Course is regulated by Ofqual and accredited by Pearson Edexcel and Open Awards making it a nationally recognised qualification that will enhance your CV, helping you stand out from the rest of the candidates. You will acquire knowledge about the number system, common measures, geometry and handling data. Upon successful completion of this course, you will be able to apply your foundational mathematics knowledge in a range of practical scenarios. Why is this course right for you? This comprehensive Functional Skills Maths Entry Level 3 Course is suitable for: Anyone looking to secure a skill-oriented job People of all ages and academic backgrounds Anyone who wants to progress to functional skills level 1 or 2 Anyone who wants to take GCSE maths Anyone seeking to add a certified qualification to their university application Anyone aspiring to accelerate their career in this sector Anyone who wants to gain in-depth knowledge of functional skills in mathematics Whether you are a beginner into the field of functional maths or any professional seeking to reinforce your expertise in functional skills maths, this Functional Skills Maths Entry Level 3 Course will set you up with the advanced skills to boost your career profile. EXAM Booking & Results Details You can decide the exam date and place according to your convenience. Awarding Body Paper-Based Exam in Centre Results Pearson Edexcel Book within 15 days Get results in 20 working days Open Awards Book within 30 working days. The dates are fixed for each month Get results in only 16 to 32 working days *Offline examinations will be held at our Swindon and London centres. Please contact us for more information. Difference between Pearson Edexcel and Open Awards Pearson Edexcel and Open Awards are OFQUAL-regulated and nationally recognised; however, the only difference lies in the exam booking and result turn-around time. You can book your remote online exam within 7 working days for Pearson Edexcel and within 3 working days for Open Awards. You can get your Pearson Edexcel results in 20 working days and your Open Awards results within 16 working days. All of the awarding bodies are accepted by universities and apprenticeships. This distinction allows learners to choose the awarding body that aligns best with their educational and career goals. Functional Skills Entry Level 3 Maths Qualification Purpose and Outcomes This Functional Skills Entry Level 3 Maths Qualification will help you to: Develop confidence in their application of basic mathematics concepts and abilities. Prove their understanding by using their abilities and expertise to complete easy tasks or simple mathematical equations. Acquire comprehensive problem-solving and underpinning skills to utilise mathematics in the course of everyday life. Course Curriculum Count, read, write, order and compare numbers up to 1000 Add and subtract using three-digit whole numbers Divide three-digit whole numbers by single- and double-digit whole numbers and express remainder Multiply two-digit whole numbers by single- and double-digit whole numbers Approximate by rounding numbers less than 1000 to the nearest 10 or 100 and use this rounded answer to check the results Recognise and continue linear sequences of numbers up to 100 Round amounts of money to the nearest £1 or 10p Read, measure and record time using am and pm Read time from analogue and 24-hour digital clocks in hours and minutes Compare metric measures of length, including millimetres, centimetres, metres and kilometres Compare measures of weight, including grams and kilograms Use a suitable instrument to measure mass and length Sort 2-D and 3-D shapes using properties, including lines of symmetry, length, right angles, and angles, including in rectangles and triangles Use appropriate positional vocabulary to describe position and direction, including eight compass points and full/half/quarter turns Interpret information, to make comparisons and record changes, from different formats, including bar charts and simple line graphs Organise and represent information in appropriate ways, including tables, diagrams, simple line graphs and bar charts How This Course Will Work? This Functional Skills Maths Entry Level 3 course will help you build a solid foundation in mathematics. Throughout the course, it will provide you with various learning materials and activities to enhance your understanding of these subjects. Initial Assessment: To identify the current level of a student’s abilities and recommend the appropriate course to enrol in upon completion. Diagnostic Assessment: Identifies skill gaps and produces an individual learning plan Learning Resources: Comprehensive video tutorials, practice quizzes & topic-based tests Progress Tracker: To record your progress in the course Free Mock Test: Access our free mock test facility for professional feedback and to prepare for the final exam. Entry Requirement This Functional Skills Maths Entry Level 3 qualification is available to all students of all academic backgrounds; no experience or previous qualifications are required. Exam Structure The Functional Skills Pearson Edexcel and Open Awards Qualification in Mathematics Level 3 consist of one externally assessed assessment that comprises two sections- a non-calculator section (calculator prohibited) and a calculator section (calculator permitted). The assessments are available as paper-based and onscreen, on-demand assessments. Section A (Non-calculator) Awarding Body Exam Duration Total Marks Questions Cover Pearson Edexcel 30 minutes 9 25% Open Awards 30 minutes 9 25% Section B (Calculator) Awarding Body Exam Duration Total Marks Questions Cover Pearson Edexcel 1 hour 15 minutes 27 75% Open Awards 1 hour 15 minutes 27 75% Pass Mark (Open Awards): Pass Marks for Maths Entry Level 3 assessments vary per assessment version and are set following standardisation and awarding activities. Each Maths assessment is designed to enable a minimally competent learner to achieve a pass mark of 36 out of 60. However, the awarding process will determine specifically where the pass mark sits for each assessment version. Therefore, the pass mark may vary between assessments. Recognised Accreditation This Functional Skills Entry Level 3 Maths has been independently accredited by Pearson Edexcel and Open Awards also regulated by Ofqual. The Office of Qualifications and Examinations Regulation (Ofqual) is responsible for regulating qualifications, assessments, and examinations in England. Pearson Edexcel is the most prestigious awarding body, for an academic and vocational qualifications. Pearson Edexcel qualifications are regulated by Ofqual and recognised by universities and employers across the world. Open Awards is an awarding organisation that offers a wide range of qualifications across various sectors, including education, health and social care, and business. Their qualifications are regulated by Ofqual and are designed to meet the needs of learners and employers. Open Awards also works closely with educational institutions and employers to ensure their qualifications are relevant and up-to-date. Certificate of Achievement You will be rewarded with an Ofqual Regulated Pearson Edexcel or Open Awards Functional Skills Qualification in Maths at Entry Level 3 (depending on what you choose as an accreditation) upon successful completion of this Functional Skills Maths Entry Level 3 Course and passing the assessments. A certified hard copy of this qualification will be posted at your given address which is accepted by employers and universities across the globe. You can flaunt this qualification in your CV which will give you a competitive advantage over others in case of securing a job. FAQs What are functional skills? Functional skills are practical skills in Maths, English, and ICT that enable people to apply their knowledge to real-life situations. These skills are designed to provide learners with the essential knowledge needed to succeed in the workplace and in their personal lives. Functional Skills are recognised qualifications in the UK and are offered at different levels, including Entry Level, Level 1 and Level 2. What is the difference between entry-level and level 1 and 2 functional skills? Both are recognised qualifications, but levels 1 and 2 are more advanced levels that will provide you with comprehensive skills and knowledge while entry-level courses are an introduction and basic level qualification to go to subsequent levels. Is it required to complete entry-level qualifications to move onto a level? No, you are not obliged to complete entry-level courses before moving on to higher levels. However, entry-level courses serve as a starting point for acquiring basic skills and knowledge that will help you strive and boost your chances of securing better marks at higher levels. Are functional skills qualifications recognised and accepted in the UK? Yes, functional skills qualifications are an accepted part of all apprenticeship standards and a way to progress to further education in the UK. Do I have to physically appear for the exam? Yes, for the writing and reading assessment, you will be required to appear for the exam at our designated office in London or Swindon on the exam day. You will be required to take the speaking, listening, and communicating assessment via Zoom. Do I have to register for the exam? Yes, you need to be registered for the exam three weeks prior to the exam date. What is the assessment procedure for an entry-level 3 Maths course? This course comprises a single assessment that is externally set, internally graded, and externally verified by the exam body. Your exam results will be forwarded to Pearson Edexcel's internal verifier once you finish the exam. If you pass all three components, you'll be able to receive the qualification certificate from the awarding body. How to pass the Functional Skills Maths entry level 3 exam? Tips for preparing for the exam include understanding the exam format, practising regularly, mastering the basics and managing time well during the exam, and seeking help from a teacher or tutor. To assist you in gaining the skills and knowledge required to pass the exam, Lead Academy offers 24/7 tutor support. As a result, you will be adequately prepared to ace the exam. Can I take entry-level courses online? Yes, you can take functional skills entry-level courses online. Lead Academy offers an extensive range of entry-level courses from level 1 to 3, available for both English and Maths. Are Functional skills easier than GCSE? Functional Skills qualifications may require hard work and revision, but they can be a better fit for students who have found Maths and English challenging. Unlike GCSEs, Functional Skills qualifications are flexible and designed to meet the needs of diverse learners, making them more adaptable to different learning styles. What will I get after finishing the course? After successfully completing the Entry Level 3 Maths course, you will receive a Pearson Edexcel or Open Awards Functional Skills Qualification in Maths at Entry Level 3 (depending on what you choose as an accreditation) that is highly regarded by universities and employers across the UK.

Lean Six Sigma Black Belt Certification Program: In-House Training This course is specifically for people wanting to become Lean Six Sigma Black Belts, who are already Lean Six Sigma practitioners. If advanced statistical analysis is needed to identify root causes and optimal process improvements, (Lean) Six Sigma Green Belts typically ask Black Belts or Master Black Belts to conduct these analyses. This course will change that. Green Belts wanting to advance their statistical abilities will have a considerable amount of hands-on practice in techniques such as Statistical Process Control, MSA, Hypothesis Testing, Correlation and Regression, Design of Experiments, and many others. Participants will also work throughout the course on a real-world improvement project from their own business environment. This provides participants with hands-on learning and provides the organization with an immediate ROI once the project is completed. IIL instructors will provide free project coaching throughout the course. What you Will Learn At the end of this program, you will be able to: Use Minitab for advanced data analysis Develop appropriate sampling strategies Analyze differences between samples using Hypothesis Tests Apply Statistical Process Control to differentiate common cause and special cause variation Explain and apply various process capability metrics Conduct Measurement System Analysis and Gage R&R studies for both discrete and continuous data Conduct and analyze simple and multiple regression analysis Plan, execute, and analyze designed experiments Drive sustainable change efforts through leadership, change management, and stakeholder management Successfully incorporate advanced analysis techniques while moving projects through the DMAIC steps Explain the main concepts of Design for Six Sigma including QFD Introduction: DMAIC Review IIL Black Belt Certification Requirements Review Project Selection Review Define Review Measure Review Analyze Review Improve Review Control Introduction: Minitab Tool Introduction to Minitab Minitab basic statistics and graphs Special features Overview of Minitab menus Introduction: Sampling The Central Limit Theorem Confidence Interval of the mean Sample size for continuous data (mean) Confidence Interval for proportions Sample size for discrete data (proportions) Sampling strategies (review) Appendix: CI and sample size for confidence levels other than 95% Hypothesis Testing: Introduction Why use advanced stat tools? What are hypothesis tests? The seven steps of hypothesis tests P value errors and hypothesis tests Hypothesis Testing: Tests for Averages 1 factor ANOVA and ANOM Main Effect Plots, Interaction Plots, and Multi-Vari Charts 2 factor ANOVA and ANOM Hypothesis Testing: Tests for Standard Deviations Testing for equal variance Testing for normality Choosing the right hypothesis test Hypothesis Testing: Chi Square and Other Hypothesis Test Chi-square test for 1 factor ANOM test for 1 factor Chi-square test for 2 factors Exercise hypothesis tests - shipping Non-parametric tests Analysis: Advanced Control Charts Review of Common Cause and Special Cause Variation Review of the Individuals Control Charts How to calculate Control Limits Four additional tests for Special Causes Control Limits after Process Change Discrete Data Control Charts Control Charts for Discrete Proportion Data Control Charts for Discrete Count Data Control Charts for High Volume Processes with Continuous Data Analysis: Non-Normal Data Test for normal distribution Box-Cox Transformation Box-Cox Transformation for Individuals Control Charts Analysis: Time Series Analysis Introduction to Time Series Analysis Decomposition Smoothing: Moving Average Smoothing: EWMA Analysis: Process Capability Process capability Discrete Data: Defect metrics Discrete Data: Yield metrics Process Capability for Continuous Data: Sigma Value Short- and long-term capabilities Cp, Cpk, Pp, Ppk capability indices Analysis: Measurement System Analysis What is Measurement System Analysis? What defines a good measurement system? Gage R&R Studies Attribute / Discrete Gage R&R Continuous Gage R&R Regression Analysis: Simple Correlation Correlation Coefficient Simple linear regression Checking the fit of the Regression Model Leverage and influence analysis Correlation and regression pitfalls Regression Analysis: Multiple Regression Analysis Introduction to Multiple Regression Multicollinearity Multiple Regression vs. Simple Linear Regression Regression Analysis: Multiple Regression Analysis with Discrete Xs Introduction Creating indicator variables Method 1: Going straight to the intercepts Method 2: Testing for differences in intercepts Logistic Regression: Logistic Regression Introduction to Logistic Regression Logistic Regression - Adding a Discrete X Design of Experiments: Introduction Design of Experiment OFAT experimentation Full factorial design Fractional factorial design DOE road map, hints, and suggestions Design of Experiments: Full Factorial Designs Creating 2k Full Factorial designs in Minitab Randomization Replicates and repetitions Analysis of results: Factorial plots Analysis of results: Factorial design Analysis of results: Fits and Residuals Analysis of results: Response Optimizer Analysis of results: Review Design of Experiments: Pragmatic Approaches Designs with no replication Fractional factorial designs Screening Design of Experiment Case Study Repair Time Blocking Closing: Organizational Change Management Organizational change management Assuring project sponsorship Emphasizing shared need for change Mobilizing stakeholder commitment Closing: Project Management for Lean Six Sigma Introduction to project management Project management for Lean Six Sigma The project baseline plan Work Breakdown Structure (WBS) Resource planning Project budget Project risk Project schedule Project executing Project monitoring and controlling and Closing Closing: Design for Lean Six Sigma Introduction to Design for Lean Six Sigma (DMADV) Introduction to Quality Function Deployment (QFD) Summary and Next Steps IIL's Lean Six Sigma Black Belt Certification Program also prepares you to pass the IASSC Certified Black Belt Exam (optional)

Discover the wonders of our planet and our role within it through our A-Level Geography course, specifically designed for self-paced learning. Gain deeper insights into the marvels and challenges our world faces from diverse landscapes to human interactions and the subsequent consequences on nature. Venture on a virtual journey exploring various terrains from arid deserts to dynamic glaciers, and lively coastal systems. Delve into the pressing issues of environmental stress on ecosystems, urban development implications, and the complex threads of globalisation. Master the art of collecting, processing, and interpreting valuable information using both qualitative and quantitative methods. You’ll become proficient in contextualisation and reporting, demonstrating a strong understanding of fieldwork through independent research projects. This course adheres to the latest Cambridge International A-Level Geography syllabus, offering a streamlined and engaging online learning experience. Benefit from unlimited tutor support, well-structured assignments, and a clear induction to equip you with the skills and knowledge for exam preparation. If you’re in the UK, you can avail our guaranteed exam centre access for your final A-Level examinations. Your enrolment comes with the following benefits: Access to a brand-new course, with content that is dynamic, engaging and tailored to the latest specification Fast track options for exams in 2022 Exam pass guarantee – We'll support you to your next exam for free if you don’t pass the first time Guaranteed exam venue access – Explore our network of partnership exam centres Unlimited tutor support – Benefit from personalised study planning and comprehensive support throughout your learning journey Geography extends beyond the textbook. It's about understanding our planet, recognising our responsibilities towards it, and expanding our knowledge on how human activities shape and change our environment.  About the awarding body Awarding body: Cambridge Assessment International Education (CAIE) Our course code: X923 Qualification code: 9696 Cambridge Assessment International Education is the world’s largest provider of international education programmes, qualifications and exams, delivering assessments to over 8 million learners in over 170 countries. ⏱ Study Hours: Allow 250-300 hours of study time plus additional time for assignments. 👩‍🏫 Study Method: Engage with a variety of media such as videos, quizzes, and interactive activities via our online platform. Learning resources can also be printed for convenience. 📆 Course Duration: Your enrolment lasts up to 24 months from the date of registration.  📋 Assessment: Enrol now for Summer 2022 examinations. You'll need to complete four standard A-Level written exams with a blend of short and long answer questions, and extended response questions. We also provide guaranteed exam space across the UK and a repeat exam support. Additionally, various assignments throughout the course will help gauge your progress and generate predicted grades if needed. 👩‍🎓 Course Outcomes: On successful completion, you'll receive an A-Level in Geography, issued by Cambridge International, identical to that received by students at any other institution. This syllabus (9696) is selected by Oxbridge for its suitability to distance learning. ℹ️ Additional Information: Difficulty - Level 3; Entry requirements - A GCSE or equivalent in Geography is recommended; UCAS Points - 56 Course Content: Explore a wide range of topics such as hydrology, fluvial geomorphology, atmosphere and weather, rocks and weathering, population dynamics, migration and settlement, tropical and hazardous environments, production, location, and global interdependence. Each unit explores its topic in-depth, providing a comprehensive understanding of the intricacies of physical and human geography.