836 Courses in London

Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. We also learn Data Definition Language and Data Manipulation Language statements. as well as course automation of queries using T-SQL. Hands-on, Practical SQL Advanced Course. PCWorkshops SQL Advanced Course Certificate. Max 4 people per course; we keep it personalised.

Blue CSCS Card NVQ Level 2 Specialist This qualification provides you with the opportunity to showcase their knowledge, skills and understanding in their chosen specialism. You will have the relevant experience in one of the specific areas. You will work in one of the following areas: Formwork Insulation and Building Treatments Steelfixing Occupations Highways Maintenance Construction Operations Steel Erecting Induction - As soon as you register you will be given a dedicated assessor. They will arrange an induction and together with your assessor, you will get to decide on the pathway which best proves your competency. The induction is used to plan out how you will gather the relevant evidence to complete the course. During the course - The assessor will work with you to build a portfolio of evidence that allows you to showcase your knowledge, skills and experience. The assessor will also regularly review and provide you with feedback. This will allow you to keep on track to progress quickly. You will be assessed through various methods such as observations, written questions, evidence generated from the workplace, professional discussion, and witness testimonials. On completion - Once all feedback has been agreed, the Internal Quality Assurer will review your portfolio and in agreement with your assessor the certificate will be applied for. To download our PDF for this course then please click here.

If you want to start installing independently or with an electrical contractor look no further as this course will give you the skills and knowledge required. This package which will allow you to become a fully qualified domestic installer and enable you to join a Competent Person Self-Certification Scheme and certify your own domestic work.

Level 4 NVQ in Controlling Lifting Operations - Supervising Lifts Lift Supervisor The Lift Supervisor Level 4 NVQ is accessible to those that undertake the duties of a Lift Supervisor / Crane Supervisor. They will work as part of a team to ensure the lifting operations comply with the law and secure the health and safety of employees and of all those affected by the operations. Induction - As soon as you register you will be given a dedicated assessor. They will arrange an induction and together with your assessor you'll get to decide on the pathway which best proves your competency. The induction is used to plan out how you will gather the relevant evidence to complete the course. During the course - The assessor will work with you to build a portfolio of evidence that allows you to showcase your knowledge, skills and experience. The assessor will also regularly review and provide you with feedback. This will allow you to keep on track to progress quickly. You will be assessed through various methods such as observations, written questions, evidence generated from the workplace, professional discussion and witness testimonials. On completion - Once all feedback has been agreed, the Internal Quality Assurer will review your portfolio and in agreement with your assessor the certificate will be applied for. To download our PDF for this course then please click here.

The PRINCE2® Practitioner course provides delegates with in-depth knowledge of project management methodologies. In this 2-day PRINCE2® Practitioner course enables learners to tailor the PRINCE2® methodology to any given project scenario. At the end of this PRINCE2® Practitioner course, delegates will be able to do delegating tolerances Course Overview The PRINCE2® Practitioner course provides delegates with in-depth knowledge of project management methodologies. In this 2-day PRINCE2® Practitioner course enables learners to tailor the PRINCE2® methodology to any given project scenario. They will learn about various essential topics such as communication management approach, tailoring the SU process, giving Ad Hoc direction, setting up the project controls, risk management procedure, PRINCE2® quality requirements, PRINCE2® approach to plan, tailoring SB, and many more. At the end of this PRINCE2® Practitioner course, delegates will be able to do delegating tolerances and report actual and forecast progress effectively. They will also be able to properly prepare the risk management, change control approach, quality management, and communication management approaches. The PRINCE2® Practitioner enables learners to apply their acquired knowledge and obtain highly reputed jobs with upgraded salaries. Concepts covered: • Balance of justification • Create the project plan • Quality audit trail • Quality review technique • Designing a plan • Gantt chart and tailoring • Change control approach Who should attend this PRINCE2® training course? This PRINCE2® Practitioner training course is for anybody interested in the field of project management. This PRINCE2® course is also intended for anyone looking to build their knowledge of how to tailor the PRINCE2® method to workplace scenarios. Other individuals that would benefit from undertaking PRINCE2® certifications include: • Project Managers • Aspiring Project Managers • Project Board Members • Project Support Staff • Office Support and Line Managers • Product Deliver Managers • Senior Responsible Owners • Change Analysts PRINCE2® Practitioner Prerequisites: It is required that delegates provide sufficient evidence of having satisfied the prerequisites before attending the PRINCE2® Practitioner training course. Delegates must hold the 2009 or 2017 version of the PRINCE2® Foundation certification or another valid qualification such as PMP, CAPM, or an IPMA Level A-D qualification. What’s Included in this PRINCE2® Practitioner Training Course? The following is included in this PRINCE2® Practitioner course: • PRINCE2® Practitioner Examination • Pre-course material • Post-course material • PDUs • Experienced PRINCE2® Instructor • Certificate • Refreshments Course Content: Module 1: Organisation Theme: • Four Levels of Management • PRINCE2® Organisation Requirements • Project Management Team • Project Management Team Roles • Project Board • Project Assurance • Change Authority • Project Support • Communication Management Approach Module 2: Starting Up a Project (SU): • Process Overview • Feasibility Study and Mandate • Appoint the Executive and the Project Manager • Capture Previous Lessons • Design and Appoint the Project Management Team • Prepare the Outline Business Case • Project Product Description • Select the Project Approach and Assemble the Project Brief • Plan the Initiation Stage • Tailoring the SU Process Module 3: Directing a Project (DP): • Authorise Initiation • Authorise the Project • Authorise a Stage or Exception Plan • Authorise Project Closure • Give Ad Hoc Direction • Tailoring the DP Process • Theme Overview • Balance of Justification • Continued Business Justification • PRINCE2® Requirements • Contents of a Business Case • Business Case Development • Benefits Management Approach • Key Responsibilities Module 4: Initiating a Project (IP): • Agree the Tailoring Requirements • Prepare the Risk Management Approach • Prepare the Change Control Approach • Prepare the Quality Management Approach • Prepare the Communication Management Approach • Set Up the Project Controls • Create the Project Plan • Prepare the Benefits Management Approach • Assemble the Project Initiation Documentation • Tailoring the IP process Module 5: Risk Theme: • Risk Definition • Effective Risk Management • PRINCE2® Risk Requirements • Risk Management Approach • Probability/Impact Grid • Risk Register • Risk Management Procedure • Identify Step • Risk Budget • Key Responsibilities Module 6: Quality Theme: • Quality Definitions • Quality Management • Quality Planning and Control • What is Quality Assurance? • PRINCE2® Quality Requirements • PRINCE2® Quality Documentation Requirements • Quality Management Approach • Quality Audit Trail • Project Product Description • Product Description • Quality Review Technique • Quality Review Roles/Responsibilities • Quality Review Meeting • Off-Specifications and Concessions • Review Follow-Up • Quality Review Benefits • Key Responsibilities • Communication Management Approach Module 7: Plans Theme: • Dealing with the Planning Horizon • PRINCE2® Planning Requirements • Documentation Requirements • Project and Stage Plans • Team Plans and Work Packages • Plans Relationship • What is in a Plan? • PRINCE2® Approach to Plans • Designing a Plan • Delivery Approaches • Defining and Analysing the Products • Product Breakdown Structures • Product Description • Product Flow Diagram • Identify the Activities and Dependencies • Preparing Estimates • Preparing a Schedule • Documenting the Plan • Analysing Risks to a Plan • Gantt Chart and Tailoring • Key Responsibilities Module 8: Progress Theme: • Progress Definition • PRINCE2® Requirements • Progress Control • Management by Exception • Delegating Tolerances and Reporting Actual and Forecast Progress • Types of Control • Management Products and Progress Control Module 9: Change Theme: • Issue Definition • PRINCE2® Approach to Change • PRINCE2® Change Documentation • Issue Register • Change Control Approach • Change Budget • Issue and Change Control Procedure • Issue Report • Exception Report Module 10: Controlling a Stage (CS): • Activity Breakdown • Authorise a Work Package • Work Package • Review Work Package Status • Receive Completed Work Packages • Review the Management Stage Status • Report Highlights • Highlight Report • Capture and Assess Issues and Risks • Escalate Issues and Risks • Take Corrective Action • Tailoring CS Module 11: Managing Product Delivery (MP): • Accept a Work Package • Execute a Work Package • Checkpoint Report • Deliver a Work Package • Tailoring MP Module 12: Managing a Stage Boundary (SB) : • Plan the Next Management Stage • What is in a Plan? • Update the Project Plan • Update the Business Case • Report the Management Stage End • End-Stage Report • Produce an Exception Plan • Tailoring SB Module 13: Closing a Project (CP): • Prepare Planned Closure • Hand Over Products • Evaluate the Project • End Project Report • Recommend Project Closure • Tailoring CP DURATION 2 Days WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

Gold CSCS Card NVQ Level 4 Diploma in Construction Site Supervision This qualification is for managers on-site who are working as a site supervisor or assistant site manager. You should be liaising with contractors, supervisors, and construction site management, organising resources, and have responsibility for health and safety and quality control such as inductions, briefings toolbox talks and inspections. You may work across one or more of the following Pathways: Building and Civil Engineering Highways Maintenance Residential Development Conservation Demolition Induction - As soon as you register you will be given a dedicated assessor. They will arrange an induction and together with your assessor you'll get to decide on the pathway which best proves your competency. The induction is used to plan out how you will gather the relevant evidence to complete the course. During the course - The assessor will work with you to build a portfolio of evidence that allows you to showcase your knowledge, skills and experience. The assessor will also regularly review and provide you with feedback. This will allow you to keep on track to progress quickly. You will be assessed through various methods such as observations, written questions, evidence generated from the workplace, professional discussion and witness testimonials. On completion - Once all feedback has been agreed, the Internal Quality Assurer will review your portfolio and in agreement with the assessor your certificate will be claimed. To download our PDF for this course then please click here.

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

The NVQ Level 3 is designed to provide both new entrants and those seeking progression in their career, with the opportunity to develop the necessary skills to carry out job roles and responsibilities associated with the installation and maintenance of Electrotechnical systems. There are two options to complete the NVQ Level 3 in Electrical Installations, these are the C&G 2346 and C&G 2357. Successful completion of the NVQ and AM2 assessment will satisfy the entry criteria for JIB accredited electricians

Learn to teach basic life support effectively with our "Promoting Best Practice in Basic Life Support Instruction" course. Ideal for healthcare professionals, educators, and individuals interested in life-saving interventions.

Students will learn and develop skills needed for a range of financial processes, including maintaining cost accounting records, advanced bookkeeping and the preparation of financial reports and returns.  Course Overview This qualification covers a range of essential and higher-level accounting techniques and disciplines. Students will learn and develop skills needed for a range of financial processes, including maintaining cost accounting records, advanced bookkeeping and the preparation of financial reports and returns. Study the Level 3 Diploma to learn higher accounting techniques and disciplines and qualify for AAT bookkeeping membership (AATQB). The jobs it can lead to: • Accounts assistant • Accounts payable clerk • Audit trainee • Credit controller • Payroll administrator/supervisor • Practice bookkeeper • Finance assistant • Tax assistant • Accounts payable and expenses supervisor Entry requirements: Students can start with any qualification depending on existing skills and experience. For the best chance of success we recommend that students begin their studies with a good standard of English and maths. Course Content: Business Awareness: This unit provides students with an understanding of the business, its environment and the influences that this has on an organisation’s structure, the role of its accounting function and its performance. Students will examine the purpose and types for businesses that exist and the rights and responsibilities of the key stakeholders, as well as gain an understanding of the importance of professional ethics and ethical management within the finance function. Learning outcomes: • Understand business types, structure and governance and the legal framework in which they operate. • Understand the impact of the external and internal environments on business, their performance and decisions. • Understand how businesses and accounts comply with principles of professional ethics. • Understand the impact of new technologies in accounting and the risks associated with data security. • Communicate information to stakeholders. Financial Accounting: Preparing Financial Statements: This unit provides students with the skills required to produce statements of profit or loss and statements for financial position for sole traders and partnerships, using a trial balance. Students will gain the double-entry bookkeeping skills needed to record financial transactions into an organisation’s accounts using a manual bookkeeping system. Learning outcomes: • Understand the accounting principles underlaying final accounts preparation. • Understand the principles of advanced double-entry bookkeeping. • Implement procedures for the acquisition and disposal of non-current assets. • Prepare and record depreciation calculations. • Record period end adjustments. • Produce and extend the trial balance. • Produce financial statements for sole traders and partnerships. • Interpret financial statements using profitability ratios. • Prepare accounting records from incomplete information. Management Accounting Techniques: This unit provides students with the knowledge and skills needed to understand the role of management accounting in an organisation, and how organisations use such information to aid decision making. Students will learn the principles that underpin management accounting methodology and techniques, how costs are handled in organisations and why organisations treat costs in different ways. Learning outcomes: • Understand the purpose and use of management accounting within organisations. • Use techniques required for dealing with costs. • Attribute costs according to organisational requirements. • Investigate deviations from budgets. • Use spreadsheet techniques to provide management accounting information. • Use management accounting techniques to support short-term decision making. • Understand principles of cash management. Tax Processes for Businesses: This unit explores tax processes that influence the daily operations of businesses and is designed to develop students’ skills in understanding, preparing and submitting Value Added Tax (VAT) returns to HM Revenue and Customs (HMRC). The unit provides students with the knowledge and skills that are needed to keep businesses, employers and clients compliant with laws and practices that apply to VAT and payroll. Learning outcomes: • Understand legislation requirements relating to VAT. • Calculate VAT. • Review and verify VAT returns. • Understand principles of payroll. • Report information within the organisation. DURATION 250-300 Hours WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate