1435 Basic courses delivered Live Online

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. Course Schedule: The 8 x 2-hour online sessions on -  What the course covers * Wine tasting: You will learn how to taste and describe wines using the WSET Systematic Approach to Tasting (SAT) * Food and wine pairing: You will learn the principles of food and wine pairing * Wine service and storage: You will learn the correct way to store and serve wine and how to recognise common faults found in wine * Labelling: You will learn how to decode and understand wine labels * Factors influencing the style of wine: You will explore how environmental factors, grape-growing, vineyard and maturation options influence the style and quality of the wines made all over the world * 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. No prior wine knowledge is required however the course builds upon the WSET Level 1 Award in Wines [https://www.localwineschool.com/manchester/events/professional-courses/wset-courses/wset-course-level-1-online/] course. It is not essential to complete Level 1 to join the Level 2 course but if you are a complete begineer you may wish to consider this option. We recommend you read the course specification document HERE [https://www.wsetglobal.com/media/11718/wset_l2wines_specification_en_jun2022_issue11.pdf] for full details of the content, structure and assesment criteria. Any questions please get in touch [https://www.localwineschool.com/manchester/contact/]. Course delivery * The Level 2 Award in Wines online course covers the same syllabus as the classroom course and is delivered in LIVE interactive online lessons by one of our certified wine educators * This course includes 16 hours online tuition in 8 x 2hr sessions and we recommend a minimum of 12 hours additional study * Your tutor will give you a guided tasting of 12 wines on this course (for details of how to order the wines see below) * You will receive access to practice multiple-choice revision questions specific to this course - FREE OF CHARGE Please note a reliable broadband connection is essential for the completion of this online course as are basic computer skills. Examination To obtain the WSET Level 2 Award in Wines Qualification, you will need to successfully pass the exam. The exam is made up of 50 multiple-choice questions to be completed in 1 hour. A mark of 55% is required to pass the exam. The exam is taken online via a Remote Invigilation [https://www.youtube.com/watch?v=DarWJz6dUbU] service giving you the flexibility to take the exam at a time and date of your choice. More details will be sent upon registration. Please ensure you read the information HERE [https://www.wsetglobal.com/wset-remote-invigilation-essential-guidance/?dm_i=5G5C,KRHB,4A50QU,2G285,1] if you wish to take the exam online.  Whats included * All WSET course materials posted to you at no extra charge including: Looking Behind the Label course manual, Study Guide, specification and SAT Tasting Card * LIVE virtual interactive sessions taught by a Local Wine School WSET Certified Tutor * Exclusive access to practice multiple choice questions provided FREE OF CHARGE * WSET exam fee  * Remote Invigilation service  * Internationally recognised WSET qualification, certificate and pin for those who pass the exam * VAT at 20%  (VAT receipt can be provided on request) Course Wines It is recommended that at least 12 wines are tasted as part of this course, although this is optional and the cost of wines is not included in the course fee above. Our wine experts have specially selected wines for this course designed to demonstrate specific learning outcomes. We have negotiated a discounted price only available to our online students. Details of how to order your case of wines will be provided when you book your place. The cost is approx £150 including VAT and delivery.  Wine preservation advice is give so that after each tasting exercise you can reseal and return to the wines over the coming days.   Special Educational Needs Please make the school aware if you have a condition which may mean that you will qualify for additional help during the exam such as dyslexia. Important dates Registration deadline: please book at least 5 days before the start of the course, to allow time to send materials and order the tasting wines.

Duration 1 Days 6 CPD hours This course is intended for Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology. Overview Upon successful completion of this course, students will be able to: - Use subqueries to generate query output. - Manipulate table data by inserting, updating, and deleting records in a table. - Manipulate the table structure. - Create views, manipulate data through views, modify the view structure, and drop views. - Create indices on table columns and drop inefficient indices. - Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction. In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process. Prerequisites * SQL Querying Fundamentals - Part 1 1 - USING SUBQUERIES TO PERFORM ADVANCED QUERYING * Search Based on Unknown Values * Compare a Value with Unknown Values * Search Based on the Existence of Records * Generate Output Using Correlated Subqueries * Filter Grouped Data Within Subqueries * Perform Multiple-Level Subqueries 2 - MANIPULATING TABLE DATA * Insert Data * Modify and Delete Data 3 - MANIPULATING THE TABLE STRUCTURE * Create a Simple Table * Create a Table with Constraints * Add or Drop Table Columns * Add or Drop Constraints * Modify the Column Definition * Back Up Tables * Delete Tables 4 - WORKING WITH VIEWS * Create a View * Manipulate Data in Views * Create Aliases * Modify and Drop Views 5 - INDEXING DATA * Create Indices * Drop Indices 6 - MANAGING TRANSACTIONS * Create Transactions * Commit Transactions

This course aims to demystify the accounting language so that you are in control of the financial performance of your business, helping you forecast for the future, evaluate your current efforts, and establish strategies to meet your goals.

Build your Rent to Rent business over 12 weeks with expert trainers, a structured business plan and key actions to get results. Generate cashflow without the capital injection using this dynamic property investment and business strategy.

Online webinar aimed at newcomers and beginners to road rallying helping to learn the basics.

Duration 1 Days 6 CPD hours Overview After completing this course, students will know how to: - Identify difficult personality types and the effect they can have in an organization - Manage difficult employees and monitor their behavior - Document ongoing changes in behavior and performance - Communicate clearly and effectively, both verbally and nonverbally - Improve your listening skills - Communicate with difficult supervisors and co-workers - Identify types of employee dismissals - Identify the focus of feedback and give and receive feedback effectively - Provide positive and constructive feedback - Monitor performance afterwards - Identify communication styles - Manage difficult feedback sessions and identify when to avoid giving feedback - Identify some common myths associated with workplace conflicts, common reasons that conflicts arise, and types of workplace conflict - Distinguish between conflict management and conflict resolution - Identify conflict resolution styles, resolve workplace conflicts, including team conflicts, and identify the communication skills required to In this course, students learn to identify and manage difficult employees, monitor their behavior, develop clear and effective communications techniques, give and receive feedback, identify workplace conflicts and present resolutions. 1 - GETTING STARTED * Workshop Objectives 2 - THE BASICS * What is Performance Management? * How Does Performance Management Work? * Tools * Case Study 3 - THE BASICS (II) * Three Phase Process * Assessments * Performance Reviews * Case Study 4 - GOAL SETTING * SMART Goal Setting * Specific Goals * Measurable Goals * Attainable Goals * Realistic Goals * Timely Goals * Monitoring Results * Case Study 5 - ESTABLISHING PERFORMANCE GOALS * Strategic Planning * Job Analysis * Setting Goals * Motivation * Case Study 6 - 360 DEGREE FEEDBACK * What is 360 Degree Feedback? * Vs. Traditional Performance Reviews * The Components * Case Study * Module Six: Review Questions 7 - COMPETENCY ASSESSMENTS * Competency Assessment Defined * Implementation * Final Destination * Case Study 8 - KOLB'S LEARNING CYCLE * Experience * Observation * Conceptualization * Experimentation * Case Study 9 - MOTIVATION * Key Factors * The Motivation Organization * Identifying Personal Motivators * Evaluating and Adapting * Case Study 10 - THE PERFORMANCE JOURNAL * Record Goals and Accomplishments * Linking with Your Employees or Managers * Implementing a Performance Coach * Keeping Track * Case Study 11 - CREATING A PERFORMANCE PLAN * Goals * Desired Results * Prioritization * Measure * Evaluation * Case Study 12 - WRAPPING UP * Words from the Wise * Lessons Learned ADDITIONAL COURSE DETAILS: Nexus Humans Performance Management 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 Performance Management 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.

THIS COURSE PACKAGE INCLUDES: 1: INTRODUCTION TO PHLEBOTOMY COURSE (GPT003) - Level 3 (Ireland Level 5) 2: ADVANCED PHLEBOTOMY COURSE (GPT005) - Level 4 (Ireland Level 6) 3: GEOPACE COMPETENCY CERTIFICATE - CPD Certified (optional with Virtual Classroom) Learn how to take blood ... train as a Phlebotomist FAST-TRACK YOUR PHLEBOTOMY TRAINING WITH OUR COMPLETE TRAINING PACKAGE 20% off - Multi-Course Discount Cover all stages from beginner through to Level 4 Available as Classroom or Virtual Classroom Complete your beginner to advanced training in 2 days Awards 2 accredited qualifications - Introduction to Phlebotomy and Advanced Phlebotomy qualifications Both courses are dually accredited (OCN & CPD) Geopace Certificate of Competency included with classroom attendance or available as an option when booking virtual classroom Covers all steps up to live blood draw Learn advanced skills and techniques Virtual Classroom options include comprehensive Practise@Home Training Kits (yours to keep) Basic understanding of English language required OPEN TO ALL APPLICANTS

Learn how to administer vaccines or injections ... Nationally Recognised Qualification Includes IM, ID and Sub-Cut Injection methods OCN Accredited - Level 4 (Foundation Degree - FDSc) Covers all steps to safely perform a vaccination Use same techniques and skills for aesthetic therapies Includes B12, Vitamin C and other treatments Essential qualification for all injections Basic understanding of English language required OPEN TO ALL APPLICANTS

Duration 5 Days 30 CPD hours This course is intended for This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills. Overview Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling. Prerequisites * Basic understanding of relational databases. * Basic Windows knowledge. MODULE 1: INTRODUCTION TO TRANSACT-SQL * What is Transact-SQL * The SELECT statement * The WHERE clause * Sorting results * Calculations * CASE expressions MODULE 2: JOINING TABLES WITH TRANSACT-SQL * The JOIN clause * Inner joins * Outer joins * Self joins and cross joins MODULE 3: FILTERING AND SORTING RESULTS * Implement the ORDER BY clause * Filter data with the WHERE clause * Limit the number of rows returned by a query * Implement NULL logic MODULE 4: SQL SERVER DATA TYPES * Understand data types * Implement string data types * Implement temporal data types MODULE 5: INSERTING, UPDATING AND DELETING DATA * Insert new records * Update existing records * Delete data MODULE 6: USING SQL SERVER FUNCTIONS WITH TRANSACT-SQL * Understand function types in SQL Server * Convert data using functions * Implement logical functions * Work with NULL data using functions MODULE 7: AGGREGATING DATA WITH TRANSACT-SQL * Implement aggregation in SQL Server * Group records in SQL Server * Filter aggregated data MODULE 8: IMPLEMENT SUBQUERIES WITH TRANSACT-SQL * Implement scalar and multi-valued sub-queries * Implement correlated subqueries * Implement existence checks with subqueries MODULE 9: CREATE QUERIES THAT USE TABLE EXPRESSIONS * Create views * Create table-valued functions * Implement derived tables * Implement common table expressions MODULE 10: USE UNION, INTERSECT, EXCEPT AND APPLY ON MULTIPLE SETS OF DATA * Write queries with the UNION operator * Write queries with the INTERSECT and EXCEPT operators * Write queries with the APPLY operator MODULE 11: IMPLEMENT WINDOW FUNCTIONS IN QUERIES * Understand window functions * Impement window functions MODULE 12: USE PIVOT AND GROUPING SETS IN QUERIES * Implement PIVOT in queries * Implement grouping sets in queries MODULE 13: USE STORED PROCEDURES IN QUERIES * Query data with stored procedures * Interact with stored procedures using input and output parameters * Write simple stored procedures * Pass dynamic SQL to SQL Server MODULE 14: IMPLEMENT PROGRAMMING FEATURES IN TRANSACT-SQL * Understand T-SQL programming elements * Implement loops and conditions in T-SQL queries MODULE 15: ADD ERROR HANDLING TO QUERIES * Understand SQL Server error handling * Implemet structured exception handling MODULE 16: USE TRANSACTIONS IN QUERIES * Understand database transactions * Implement transactions in T-SQL

Duration 5 Days 30 CPD hours This course is intended for This course is targeted to those seeking A+ Certification and anyone in these roles: IT Support Specialist Helpdesk Technician Field Technician Tier I Support Specialist Desktop Support Specialist Associate Network Engineer Systems Support Technician Junior Systems Administrator Overview At completion of this course, you will be able to: Install and configure end-user devices and software Address connectivity problems Perform basic cybersecurity mitigations Troubleshoot common problems to diagnose and resolve issues Demonstrate basic knowledge of scripting, the cloud, and virtualization CompTIA A+ certified professionals are proven problem solvers. They support today?s core technologies from security to networking to virtualization and more. CompTIA A+ is the industry standard for launching IT careers into today?s digital world. This course, prepares you for the CompTIA A+ Certification exams 220-1101 and 220-1102. LESSON 1: INSTALLING MOTHERBOARDS AND CONNECTORS * Topic 1A: Explain Cable Types and Connectors * Topic 1B: Install and Configure Motherboards * Topic 1C: Explain Legacy Cable Types LESSON 2: INSTALLING SYSTEM DEVICES * Topic 2A: Install and Configure Power Supplies and Cooling * Topic 2B: Select and Install Storage Devices * Topic 2C: Install and Configure System Memory * Topic 2D: Install and Configure CPUs LESSON 3: TROUBLESHOOTING PC HARDWARE * Topic 3A: Apply Troubleshooting Methodology * Topic 3B: Configure BIOS/UEFI * Topic 3C: Troubleshoot Power and Disk Issues * Topic 3D: Troubleshoot System and Display Issues LESSON 4: COMPARING LOCAL NETWORKING HARDWARE * Topic 4A: Compare Network Types * Topic 4B: Compare Networking Hardware * Topic 4C: Explain Network Cable Types * Topic 4D: Compare Wireless Networking Types LESSON 5: CONFIGURING NETWORK ADDRESSING AND INTERNET CONNECTIONS * Topic 5A: Compare Internet Connection Types * Topic 5B: Use Basic TCP/IP Concepts * Topic 5C: Compare Protocols and Ports * Topic 5D: Compare Network Configuration Concepts LESSON 6: SUPPORTING NETWORK SERVICES * Topic 6A: Summarize Services Provided by Networked Hosts * Topic 6B: Compare Internet and Embedded Appliances * Topic 6C: Troubleshoot Networks LESSON 7: SUMMARIZING VIRTUALIZATION AND CLOUD CONCEPTS * Topic 7A: Summarize Client-Side Virtualization * Topic 7B: Summarize Cloud Concepts LESSON 8: SUPPORTING MOBILE DEVICES * Topic 8A: Set Up Mobile Devices and Peripherals * Topic 8B: Configure Mobile Device Apps * Topic 8C: Install and Configure Laptop Hardware * Topic 8D: Troubleshoot Mobile Device Issues LESSON 9: SUPPORTING PRINT DEVICES * Topic 9A: Deploy Printer and Multifunction Devices * Topic 9B: Replace Print Device Consumables * Topic 9C: Troubleshoot Print Device Issues LESSON 10: CONFIGURING WINDOWS * Topic 10A: Configure Windows User Settings * Topic 10B: Configure Windows System Settings LESSON 11: MANAGING WINDOWS * Topic 11A: Use Management Consoles * Topic 11B: Use Performance and Troubleshooting Tools * Topic 11C: Use Command-line Tools LESSON 12: IDENTIFYING OS TYPES AND FEATURES * Topic 12A: Explain OS Types * Topic 12B: Compare Windows Editions LESSON 13: SUPPORTING WINDOWS * Topic 13A: Perform OS Installations and Upgrades * Topic 13B: Install and Configure Applications * Topic 13C: Troubleshoot Windows OS Problems LESSON 14: MANAGING WINDOWS NETWORKING * Topic 14A: Manage Windows Networking * Topic 14B: Troubleshoot Windows Networking * Topic 14C: Configure Windows Security Settings * Topic 14D: Manage Windows Shares LESSON 15: MANAGING LINUX AND MACOS * Topic 15A: Identify Features of Linux * Topic 15B: Identify Features of macOS LESSON 16: CONFIGURING SOHO NETWORK SECURITY * Topic 16A: Explain Attacks, Threats, and Vulnerabilities * Topic 16B: Compare Wireless Security Protocols * Topic 16C: Configure SOHO Router Security * Topic 16D: Summarize Security Measures LESSON 17: MANAGING SECURITY SETTINGS * Topic 17A: Configure Workstation Security * Topic 17B: Configure Browser Security * Topic 17C: Troubleshoot Workstation Security Issues LESSON 18: SUPPORTING MOBILE SOFTWARE * Topic 18A: Configure Mobile OS Security * Topic 18B: Troubleshoot Mobile OS and App Software * Topic 18C: Troubleshoot Mobile OS and App Security LESSON 19: USING SUPPORT AND SCRIPTING TOOLS * Topic 19A: Use Remote Access Technologies * Topic 19B: Implement Backup and Recovery * Topic 19C: Explain Data Handling Best Practices * Topic 19D: Identify Basics of Scripting LESSON 20: IMPLEMENTING OPERATIONAL PROCEDURES * Topic 20A: Implement Best Practice Documentation * Topic 20B: Use Proper Communication Techniques * Topic 20C: Use Common Safety and Environmental Procedures