2382 Courses

Even if you have completed a level 3 NVQ or a previous version of the wiring regulations, you still will have to prove you are conversant with the current standards. So therefore, keeping up to date with the latest wiring regulations satisfies these requirements. Although the BS 7671 can be a tricky book to navigate, our course has been designed in such a way as to ensure that you will have the knowledge to identify and find the topics covered in each of the relevant parts of the book. Further information can be found here: C&G 2382-22 BS7671 18th Edition — Optima Electrical Training (optima-ect.com)

Are you looking for a sewing machine workshop nearby? Want to learn the fundamentals? Then visit the sewing machine workshop in London and enjoy the joy of stitching! This session will teach you everything from threading your machine and winding up the small bobbin to trying out different stitches and embroidering with your machine. This course is ideal for beginners who want to learn in an enjoyable and casual setting. Sign up today and let's start stitching!

These comprehensive Total Electrical 20 training courses fully meet the qualification certification requirements of Part P schemes and are aimed at non-electrical and electrical persons wishing to up-skill or re-train. The aim of the Total Electrical 20 training courses is to provide a level of competence, which will allow work to be safely and efficiently carried out on Electrical Equipment and Systems all within a 4 or 6 week period. A 4 week Total Electrical 20 training course which gives you the foundation knowledge you need to commence working as a domestic electrician. The Total Electrical 20 training courses are a mixture of both practical work and theoretical study, with the emphasis being put on as much practical as possible. This Total Electrical 20 training course can be supplemented to a 6 week course with additional modules to enhance your existing skills and therefore widen your market. The Total Electrical 20 training courses are designed to be as PRACTICAL as they possibly can be, with over 50% of the course time being practical, because we believe that the best way to learn is to do it!! With ALL our courses we offer unbiased technical support and access to a wealth of knowledge and information upon completion. Once you’ve completed your course with Technique, you can be assured that our service doesn’t end there… There are NO hidden costs on our courses, everything is included. The above Total Electrical 20 training courses are inclusive of examination registration entry fees, stationary, and a FREE tool kit*. All test instrumentation required for the course will be available for use during the course, should you require to purchase you own, advice will be readily available to assist you with your selection. These items can either be pre-ordered or purchased during the course.

These comprehensive Total Electrical 20 training courses fully meet the qualification certification requirements of Part P schemes and are aimed at non-electrical and electrical persons wishing to up-skill or re-train. The aim of the Total Electrical 20 training courses is to provide a level of competence, which will allow work to be safely and efficiently carried out on Electrical Equipment and Systems all within a 4 or 6 week period. A 4 week Total Electrical 20 training course which gives you the foundation knowledge you need to commence working as a domestic electrician. The Total Electrical 20 training courses are a mixture of both practical work and theoretical study, with the emphasis being put on as much practical as possible. This Total Electrical 20 training course can be supplemented to a 6 week course with additional modules to enhance your existing skills and therefore widen your market. The Total Electrical 20 training courses are designed to be as PRACTICAL as they possibly can be, with over 50% of the course time being practical, because we believe that the best way to learn is to do it!! With ALL our courses we offer unbiased technical support and access to a wealth of knowledge and information upon completion. Once you’ve completed your course with Technique, you can be assured that our service doesn’t end there… There are NO hidden costs on our courses, everything is included. The above Total Electrical 20 training courses are inclusive of examination registration entry fees, stationary, and a FREE tool kit*. All test instrumentation required for the course will be available for use during the course, should you require to purchase you own, advice will be readily available to assist you with your selection. These items can either be pre-ordered or purchased during the course.

Get your Award for Personal Licence Holders qualification here with us at Knight Training! The Award for Personal Licence Holders (APLH) is the prerequisite for you to get your Personal Licence, aimed at anyone who wishes to sell or authorise the sale of alcohol. The course is a legal requirement, and it basically runs through the responsibilities that one must know in order to sell alcohol in a designated premises. Here at Knight Training we welcome our customers with open arms and provide the best service possible. Why waste more time? Call us now at 01524 388279 to get your APLH today!

The Wine and Spirit Education Trust (WSET) Level 1 Award in Wines is an ideal starting point for any wine enthusiast who: is considering embarking on a professional career in the drinks industry would like to improve their knowledge of wine through more structured training, and be awarded a certificate to prove they know their stuff It is an enjoyable, relaxed and interactive course designed to introduce participants, in a structured way, to wine styles, storing and serving of wine, and food and wine matching. No prior experience of wine tasting is necessary. There is a short multiple-choice assessment at the end of the day to ensure you have met all the criteria, and can be awarded the certificate. The WSET Level 1 Award in Wines has full accreditation from OfQual as part of the UK Qualifications & Credits Framework as a Level 1 Vocational Qualification. The Fee includes: All WSET course materials Professional WSET tuition by WSET Certified tutor Wine samples to taste during the day. We teach you the WSET Level 1 Systematic Approach to Tasting Wine (SAT) ® which will enable you to analyse wines objectively and consistently registration with WSET, all examination fees, and an internationally-recognised certificate upon successful completion Tea & coffee breaks VAT at 20% 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

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.

Help with anxiety Life guidance Objective led life coaching Help with ptsd Help with exam stress Student dating advice Discovering your purpose Combat trauma issues High performance coaching Introspection test and personality test Confidence building Gain understanding of self Help with combating negative behavioural patterns https://relationshipsmdd.com/product/student-life-coaching-package/

PRINCE2 is a process-based project management methodology that offers a flexible and scalable solution to handle all kinds of projects. This is why many organisations favour it since it fosters better collaboration between team members and external stakeholders. Course Overview PRINCE2 is a process-based project management methodology that offers a flexible and scalable solution to handle all kinds of projects. This is why many organisations favour it since it fosters better collaboration between team members and external stakeholders. The PRINCE2 certification will surely help learners advance in terms of worth and employment opportunities if they list it as a skill in their resumes. This 3-day introductory PRINCE2® Foundation course is designed to give candidates a comprehensive overview of the PRINCE2® methodology. They will learn about various essential topics such as integrated elements, applying PRINCE2®, delivery approaches, processes, principles, tailoring, etc. The PRINCE 2 foundation course will introduce project management to students. This course will focus on different aspects of project management, providing the knowledge, tools and techniques used to understand each concept and methodology. At the end of this PRINCE2® Foundation course, delegates will be able to perform various project manager activities in an organisation effectively and efficiently. They will also be able to use various PRINCE2® methodologies properly. This training will also cover the following concepts: • Project management • Projects in context • Measuring success • Tailor to suit the project • Embedding PRINCE2® • Tailoring constraints and influences Who it’s for? Prerequisites: In this PRINCE2® Foundation course, there are no formal prerequisites. PRINCE2 Foundation can be studied on its own or as a prerequisite for the PRINCE2 Practitioner course This PRINCE2® Foundation course is designed for anyone who wants to gain in-depth knowledge about project management methodologies. What's Included in this PRINCE2 Foundation Training Course? The following is included in this PRINCE2® Foundation training course: • PRINCE2® Foundation Examination • Pre-course material • PDUs • Experienced PRINCE2® Instructor • Certificate • Refreshments PRINCE2® Foundation Exam: The PRINCE2® Foundation examination Focuses on knowledge of PRINCE2® as a methodology. • Type of Questions: Multiple choice. • Total Questions: 60. • Number of marks: 60 marks, each question is worth 1 mark. • Pass mark: 55%, or 33/60. • Duration: 60 Minutes. • Material allowed: No, this is a ‘closed book’ exam. This PRINCE2® foundation training course covers the following topics: Module 1: Introduction to Projects and the PRINCE2® Methodology: • PRINCE2® “Project” Definition • Project Characteristics • Project Management • What is PRINCE2®? • Four Integrated Elements • What Does PRINCE2® Not Provide? • What Makes a Project a PRINCE2® Project? Module 2: Project Manager Activities: • Customer/Supplier Environment • Projects in Context • Commercial Environment • Applying PRINCE2® • Delivery Approaches • Measuring Success • Organisational Capability • Seven Processes Module 3: Seven Themes: • Business Case • Organisation • Quality • Plans • Risk • Change • Progress Module 4: Seven Principles: • Continued Business Justification • Learn from Experience • Defined Roles and Responsibilities • Manage by Stages • Manage by Exception • Focus on Products • Tailor to Suit the Project Module 5: Considerations for Organisational Adoption: • Creating a PRINCE2® Based Project Management Method • Creating Tailoring Rules and Guidelines • Rating the Complexity of Projects • Embedding PRINCE2® • Tailoring • What Should Be Tailored? • Tailoring Constraints and Influences • Creating an Organisation’s Method DURATION 2-3 days WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

Facilitation Skills for Business Analysts This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals pass the IIBA® Certification exam to become a Certified Business Analysis Professional (CBAP™). Business analysts are communicators who bridge the gap between people with business needs and knowledge and the people who will provide solutions. Business analysts are continuously involved in communications with stakeholders and developers as they create the solution to business problems. They participate in information-gathering sessions including interviewing, joint requirements definition, and Joint Application Design (JAD) workshops which are used to streamline information gathering and get immediate validation from user representatives. The business analyst is also involved with negotiating the solution with the stakeholders, upper-level management, and the developers, mediating among the groups when disagreements take place, and influencing the results of decisions during the solution cycle. This course teaches the methods needed to organize and run information-gathering events. It combines the basics of graphic decision making and modeling with facilitation, communication, and meeting management skills. What you will Learn At the end of this program, you will be able to: Identify the major touch points between key BABOK® Guide knowledge areas and business analysis communication Describe the facilitation skills that are most supportive of those intersections Improve your ability to apply these skills in the context of your business analyst functions Foundation Concepts The role of the Business analyst (BA) An Introduction to the BABOK® Guide Business analyst roles and the product / project life cycle (PLC) Facilitation skills for the business analyst The BABOK® Guide and Communication An introduction to the communication process Addressing basic communications challenges Planning business analysis communication Communication and BABOK® Guide tasks Targeted Elicitation Techniques Synergy between communication and targeted elicitation techniques Preparing for elicitation Cornerstone targeted technique: interviews Other targeted elicitation techniques Related general communication skills Group Elicitation Techniques Synergy between requirements communication and group elicitation techniques Cornerstone group elicitation technique - requirements workshops Other group elicitation techniques Related general communication skills - meeting management best practices Related general communication skills - facilitating best practices Process / Model-Based Elicitation Techniques Synergy between requirements communication and process / model-based elicitation techniques Process / model-based elicitation techniques Related interpersonal skills - problem solving and decision making Investigative Elicitation Techniques Synergy between requirements communication and investigative elicitation techniques Cornerstone investigative elicitation technique - document analysis Other investigative elicitation techniques Summary of elicitation techniques by usage in the requirements process Using Presentations, Structured Walkthroughs, and Influencing Structured walkthroughs, presentations, and influencing within BABOK® Guide tasks Cornerstone technique - structured walkthroughs General communication skill - presenting Related interpersonal skill - influencing Special Facilitation Skills - Negotiating and Mediating Negotiating Mediating