MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins
Hydrotherapy has long been recognised for its restorative benefits, both physically and mentally. This CPD-accredited course takes you beneath the surface to explore how water-based techniques can support wellness, rehabilitation, and overall health. Whether you're looking to broaden your knowledge in health sciences or add depth to your therapeutic expertise, this course offers a refreshing take on hydrotherapy through flexible, structured online learning—no wellies required. Guided by detailed modules, you’ll discover the principles behind hydrotherapy’s effectiveness, its role in managing various conditions, and how it fits within broader healthcare approaches. The course is ideal for learners eager to dive into the topic at their own pace, from the comfort of wherever they fancy. With engaging content and clear explanations, it’s all about soaking up knowledge without the fuss. Course Curriculum: Module 01: Introduction to Hydrotherapy Module 02: Anatomy and Physiology Review Module 03: Types of Hydrotherapy Module 04: Effects of Hydrotherapy Module 05: Common Conditions Treated with Hydrotherapy Module 06: Hydrotherapy for Shoulder and Lower Limb Module 07: Hydrotherapy for Animals Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing Hydrotherapy - CPD Accredited course. For each test, the pass mark will be set to 60%. CPD 10 CPD hours / points Accredited by The CPD Certification Service Who is this course for? The Hydrotherapy - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Hydrotherapy - CPD Accredited training.
To provide the knowledge and skills required to perform an internal audit of part of a occupational health and safety management system based on ISO 45001 and report on the effective implementation and maintenance of the management system in accordance with ISO 19011.
To provide the knowledge and skills required to perform an internal audit of part of a Food safety management system based on ISO 22000 and report on the effective implementation and maintenance of the management system in accordance with ISO 19011.
Dive into the realm of Solar PV Systems Modelling and Analysis through EnergyEdge's course. Stay ahead in the field of renewable energy with expert training.
About this Training Course Whether you are maintaining an oil rig or processing plant, good quality maintenance is critical to delivering a safe reliable product to your customers. Whatever your level of maintenance experience, this course will equip you with the valuable skills and understanding that will enhance your maintenance career. Too often the maintenance department is seen as the cause of why assets are unavailable, in poor condition yet are costing too much to maintain. By comparison, pace setting companies see maintenance as adding value to their assets and employ an integrated, holistic approach to their maintenance activities. This course will help you move towards that pace setting performance. This course is based on an integrated maintenance model that has been used by leading companies and consultants with success and recognised as best practice. Participants will learn the total impact that maintenance can have on a business, identify key elements (and value) of effective maintenance for their own plants to not only reduce costs but also improve performance. The critical types of maintenance will be covered from day-to-day activities to shutdowns and reliability improvement. The course will break down traditional functional boundaries and encourage a holistic approach to maintenance. With an organisation's maintenance process only as good as its weakest link, this course will guide participants through all the key steps of a maintenance process and its supply chain. Participants will understand what is considered a good standard for each step in the maintenance process, how to identify the weakest links and subsequently how they can accelerate their performance improvement. Participants will have the option of gaining a Bronze Level qualification from the Academy of Turnarounds Operations of Maintenance. For those who obtain a pass, they will receive a Pass certificate and for those who achieve the top quartile score, they will receive a Distinction level pass. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives By the end of the course, participants will be able to: Explain the challenges and objectives facing maintenance organisations today Demonstrate the importance of work order systems and use techniques for time estimations and priority assignments Prepare a preventive maintenance program Apply project management techniques to effectively manage major maintenance activities and shut downs Use capital budgeting techniques to evaluate maintenance capital expenditures Demonstrate understanding of how to maintain the optimal stock levels of spare parts to ensure operational continuity Prepare the right Key Performance Indicators (KPIs) to evaluate and improve performance in maintenance Target Audience This course is not just for maintenance professionals. Maintenance teams cannot perform without effective integration with operations and supply chain functions. Availability losses are often caused by operations or design issues and pace setting companies have generated significant benefits by integrating operation and maintenance strategies and working more collaboratively. This course will help all members of the operations and maintenance teams and their supply chain better understand their respective roles in ensuring that maintenance is benefitting and not inhibiting their business. Course Level Basic or Foundation Trainer Your expert course leader is a highly experienced facilitator in maintenance improvement, change management, continuous improvement and capability development as a management coach and trainer. He has a strong focus on people with an emphasis on developing people and the practicalities of improving maintenance performance rather than just the theory. He has worked internationally across Europe, America, the Middle East and Africa with extensive experience in Oil and Gas, the Chemicals sector and manufacturing as well as working with clients in Steel and Power Generation. As a result, he can bring best practice from a wide variety of sources. He spent the first fifteen years of his career as a specialist trainer working for companies such as Lloyds British Training Services and Rolls Royce. He then went on to work as a Principal consultant for ABB consulting for 15 years. During this time, he refined some of the established improvement tools including how and when to apply them for maximum impact whilst still continuing to develop and deliver training in support of this. Recent work has included improvements to the Work Order to Work Execution processes of Engineering departments and focused on Reliability, Planning and Scheduling. This ongoing field experience has helped him test and refine specialist training in a number of areas. He has been able to use his own experience to contribute with other maintenance specialists to the Carcharodon models of excellence. Its methodologies are recognised as 'Best of the Best' standards providing the inspiration for two books, projects that have won awards such as the prodigious UK Chemical Industries annual Excellence in Engineering award and form the basis of this training. He was recently awarded a national award as coach of the year. He uses the same skills to ensure that he does not just preach maintenance best practice, he discusses it, explains it and ensures that delegates have a much more personal and flexible experience. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations
Interior valeting is often overlooked as 'simple' but it is a vital skill for any detailer to master - the difference between an acceptable job and a fantastic job can be vast. With the range of materials and surfaces in modern vehicles, navigating the most efficient way to care for interiors is sometimes difficult. Learning the chemistry behind stain removal, the correct tools for the job and how best to employ them, and how to deal with unusual and stubborn tasks is the aim of this course. We push your knowledge further and advance your skillset through technique and demonstration, enabling you to reduce time spent cleaning and re-cleaning interiors, increasing efficiency, and advancing your interior valeting skills to a new level. Availability If no dates are showing as available in the calendar, you can sign up for updates to find out when new dates are released and new course developments. Interior valeting is often overlooked as 'simple' but it is a vital skill for any detailer to master - the difference between an acceptable job and a fantastic job can be vast. With the range of materials and surfaces in modern vehicles, navigating the most efficient way to care for interiors is sometimes difficult. Learning the chemistry behind stain removal, the correct tools for the job and how best to employ them, and how to deal with unusual and stubborn tasks is the aim of this course. We push your knowledge further and advance your skillset through technique and demonstration, enabling you to reduce time spent cleaning and re-cleaning interiors, increasing efficiency, and advancing your interior valeting skills to a new level. You will cover: Interior materials - identifying, cleaning and their issues. Removal of components for deep cleaning, including seats, trim and steering wheels. Cleaner Chemistry and how it applies to different stains. Vacuum, steam and wet extraction technique and efficiency. Specific stain removal; such as Biro ink, oils, sand, tannins, paints, and hard-to-shift materials, such as sand, and chewing gum. Pet hair removal and allergen information. Glass cleaning and access. Odour removal and biocidal sanitising treatments. Surface protection - hard surface, leather and fabric protection and application. Screens and delicate surfaces - including HUDs, touch controls and binnacles. Finally, we teach a proven and methodical checklist to run down with each vehicle to ensure complete thoroughness, whilst sticking to an agreed schedule with a client and upselling additional services. Course Length 1 Day (0930-1600) Location UK Detailing Academy, 2 Purlieus Barn, Ewen, Cirencester, GL7 6BY Group Size Up to 5 people
Python remains one of the most sought-after programming languages across industries—from automation and analytics to app development and machine learning. This Python Programming course has been thoughtfully designed to take you on a smooth and structured learning journey from absolute beginner to confident expert. Whether you're exploring coding for the first time or brushing up on advanced concepts, each module offers clarity, consistency, and depth without unnecessary jargon. Beginning with the foundations and gradually moving through control flow, functions, libraries, and object-oriented principles, the course ensures you build lasting knowledge with every step. You’ll also explore essential tools like NumPy and Pandas, and by the end, you’ll gain insightful guidance on shaping your future career path using Python. Clear, well-organised, and industry-relevant—this course is built for learners who want lasting skills and direction in the field of Python programming. ________________________________________________________________________ Key Features: CPD Certified Diploma in Python Programming: Beginner To Expert With Complete Career Guide 10 Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum: Module 01: Introduction to Python Programming from A-Z Module 02: Getting Familiar with Python Module 03: Basic Data Types Module 04: Python Operators Module 05: Advanced Data Types Module 06: Control Flow Part 1 Module 07: Control Flow Part 2 Module 08: Python Functions Module 09: User Input and Error Handling Module 10: Python Advanced Functions Module 11: Python Scripting and Libraries Module 12: NumPy Module 13: Pandas Module 14: Introduction to OOP Module 15: Advanced OOP Module 16: Starting a Career in Python ________________________________________________________________________ Complete Career Guide for Python Programming: Beginner To Expert(A to Z) This isn't just a course; it's your ticket to thriving in the sector and your roadmap to the Programming. In addition to mastering the essentials of Programming, you'll also gain valuable skills in CV writing, job searching, communication, leadership, and project management. These 9 complementary courses are designed to empower you at every stage of your journey. Stand out in your career, from crafting a winning CV to excelling in interviews. Develop the leadership skills to inspire your team and efficiently manage projects. This holistic approach ensures you're not just job-ready but career-ready. Enrol today, and let's build your success story together in Programming. Your dream career starts here! List of career guide courses included in Python Programming: Beginner To Expert With Complete Career Guide: Course 01: Professional CV Writing and Job Searching Course 02: Communication Skills Training Course 03: Career Development Training Course 04: Time Management Course 05: Returning to Work Training Course 06: Level 3 Diploma in Project Management Course 07: Leadership Skills Course 08: Body Language Course 09: Interview and Recruitment ________________________________________________________________________ Learning Outcomes: Understand Python programming fundamentals comprehensively. Apply Python operators effectively in program development. Demonstrate proficiency in handling basic and advanced data types. Implement control flow structures for efficient program execution. Develop and utilize Python functions, including advanced concepts. Gain practical skills in scripting, using libraries, and mastering OOP. ________________________________________________________________________ Accreditation All of our courses, including the Python Programming: Beginner To Expert With Complete Career Guide, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Python Programming: Beginner To Expert With Complete Career Guide, you will immediately be sent your digital certificates. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we recommend renewing them every 12 months. Assessment At the end of the courses, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals new to programming seeking a thorough Python foundation. Students or professionals aiming to enhance data handling skills. Aspiring developers interested in scripting and library usage. Those pursuing a career in Python and object-oriented programming. Career path Python Developer - £35K to 55K/year. Data Analyst - £30K to 45K/year. Software Engineer - £40K to 65K/year. Machine Learning Engineer - £45K to 75K/year. Data Scientist - £50K to 80K/year. Certificates 10 CPD Accredited e-Certificates Digital certificate - Included 10 CPD Accredited Hard Copy Certificates Hard copy certificate - Included
Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. Overview Create sophisticated SSIS packages for extracting, transforming, and loading data Use containers to efficiently control repetitive tasks and transactions Configure packages to dynamically adapt to environment changes Use Data Quality Services to cleanse data Successfully troubleshoot packages Create and Manage the SSIS Catalog Deploy, configure, and schedule packages Secure the SSIS Catalog SQL Server Integration Services is the Community Courseware version of 20767CC Implementing a SQL Data Warehouse. This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. This course is similar to the retired Course 20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation. Prerequisites Working knowledge of T-SQL and SQL Server Agent jobs is helpful, but not required. Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of relational databases. Some experience with database design. 1 - SSIS Overview Import/Export Wizard Exporting Data with the Wizard Common Import Concerns Quality Checking Imported/Exported Data 2 - Working with Solutions and Projects Working with SQL Server Data Tools Understanding Solutions and Projects Working with the Visual Studio Interface 3 - Basic Control Flow Working with Tasks Understanding Precedence Constraints Annotating Packages Grouping Tasks Package and Task Properties Connection Managers Favorite Tasks 4 - Common Tasks Analysis Services Processing Data Profiling Task Execute Package Task Execute Process Task Expression Task File System Task FTP Task Hadoop Task Script Task Introduction Send Mail Task Web Service Task XML Task 5 - Data Flow Sources and Destinations The Data Flow Task The Data Flow SSIS Toolbox Working with Data Sources SSIS Data Sources Working with Data Destinations SSIS Data Destinations 6 - Data Flow Transformations Transformations Configuring Transformations 7 - Making Packages Dynamic Features for Making Packages Dynamic Package Parameters Project Parameters Variables SQL Parameters Expressions in Tasks Expressions in Connection Managers After Deployment How It All Fits Together 8 - Containers Sequence Containers For Loop Containers Foreach Loop Containers 9 - Troubleshooting and Package Reliability Understanding MaximumErrorCount Breakpoints Redirecting Error Rows Logging Event Handlers Using Checkpoints Transactions 10 - Deploying to the SSIS Catalog The SSIS Catalog Deploying Projects Working with Environments Executing Packages in SSMS Executing Packages from the Command Line Deployment Model Differences 11 - Installing and Administering SSIS Installing SSIS Upgrading SSIS Managing the SSIS Catalog Viewing Built-in SSIS Reports Managing SSIS Logging and Operation Histories Automating Package Execution 12 - Securing the SSIS Catalog Principals Securables Grantable Permissions Granting Permissions Configuring Proxy Accounts Additional course details: Nexus Humans 55321 SQL Server Integration Services training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55321 SQL Server Integration Services course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
The WSET Level 2 Wine award course is suitable for anybody who has a serious interest in wine and wishes to broaden their knowledge in a structured way. The WSET Level 2 Award in Wines has full accreditation from OfQual as a Level 2 Vocational Qualification. Through a combination of tasting and theory you will explore the factors that impact the style and quality of wine and learn how to describe wines with confidence. What the course covers Wine Tasting: Taste and describe wines using the WSET Systematic Approach to Tasting Food and Wine Matching: You will learn about the key considerations when matching food and wine successfully Wine Service and Storage: Learn the correct way to store and serve wine and recognise common faults found in wines Labelling: Learn how to decode and understand labels Factors influencing the Style of Wine: Study the factors influencing the style, quality and price of wine in the vineyard and winery Grape Varieties: You'll learn about the styles of wines produced by the key international red and white grape varieties (Chardonnay, Pinot Grigio, Sauvignon Blanc, Riesling, Cabernet Sauvignon, Pinot Noir, Merlot and Syrah/Shiraz) as well as the styles of wines made with 22 regionally important grape varieties grown in 70 wine regions (GI's) around the world Sparkling and Fortified wines: You will be taught how grape varieties and winemaking processes influence the style of wines in these two key wine categories Key Wine-Producing regions of the World: Learn about the main styles of wines from the key wine-producing regions. France, Germany, Italy, Spain, Portugal, USA, Argentina, Chile, Australia, New Zealand and South Africa Examination: The 1 hour, 50 multiple-choice question exam is taken in the afternoon of the final day of the course and the exam fee is included in the course cost. A mark of 55% required to pass. Certification: All students who pass will be issued with a certificate suitable for framing and a lapel pin. N.B. In addition to classroom teaching, students are expected to complete around 12 hours of private study in their own time. No prior wine knowledge is required however the course builds upon the WSET Level 1 Award in Wines course. It is not essential to complete Level 1 to join the Level 2 course but if you are a complete beginner you may wish to consider this option. We recommend you read the course specification document HERE for full details of the content, structure and assessment criteria. Any questions please get in touch. The course fee includes All WSET course materials including; Looking Behind the Label course manual, Study Guide, Specification book, and SAT ® Tasting Card Approx 40 delicious wines to taste including Champagne & Port The use of professional ISO tasting glasses 3 days of professional WSET tuition by a WSET Certified tutor Teaching of the WSET Level 2 Systematic Approach to Tasting Wine (SAT) ® which will enable you to analyse wines objectively and consistently Registration with WSET and all examination fees Internationally-recognised certificate and pin badge upon successful completion Practice multiple choice questions provided FREE OF CHARGE Comprehensive student support outside of class time should you have any questions before, during and after the course VAT at 20% (VAT receipt can be provided on request) Special Educational Needs Please make us aware if you have a condition that may mean you qualify for additional help during the exam such as dyslexia. Funding Funding for this course is available: DEVELOP is the educational programme of The Drinks Trust, the drinks and hospitality industry charity. DEVELOP offers fully funded training and skills courses, delivered by industry-leading providers for people already working, or with an ambition to work, in the drinks and hospitality industry. Manchester Wine School has partnered with The Drinks Trust to bring courses free of charge to eligible students. All of the WSET courses are available for funding with DEVELOP. To learn more please visit the Drinks Trust website HERE Criteria of eligibility for DEVELOP funding: must be 18 or over, eligible to work in the UK, have a National Insurance Number, and be earning less than £26k/pa