ISO 45001 is the first global Occupational Health and Safety Management System standard that replaces OHSAS 18001. The ISO 45001 Lead Auditor training enables you to develop the necessary expertise to perform an Occupational Health and Safety Management System (OH&S MS) audit by applying widely recognized audit principles, procedures and techniques. About This Course During this training course, you will acquire the knowledge and skills to plan and carry out internal and external audits in compliance with ISO 19011 and ISO/IEC 17021-1 certification process. Based on practical exercises, you will be able to master the audit techniques and become competent to manage an audit program, audit team, communication with customers, and conflict resolution. After acquiring the necessary expertise to perform this audit, you can sit for the exam and gain the 'IECB Certified ISO 45001 Lead Auditor' credential. By holding an IECB Certificate, you will demonstrate that you have the capabilities and competencies to audit organizations based on best practices. Learning objectives Understand the operations of an Occupational Health and Safety Management System (OH&S MS) based on ISO 45001 Acknowledge the correlation between ISO 45001 and other standards and regulatory frameworks Understand the auditor's role in planning, leading and following-up on a management system audit in accordance with ISO 19011 Learn how to interpret the requirements of ISO 45001 in the context of an OH&S MS audit Educational approach This training is based on both theory and best practices used in OH&S MS audits Lecture sessions are illustrated with practical questions and examples Practical exercises include examples and case study discussions Practice tests are similar to the Certification Exam Prerequisites A foundational understanding of ISO 45001 and knowledge of audit principles. What's Included? Refreshments & Lunch* Course Slide Deck Official Study Guides Official Exam Q&A The Exam * Classroom based courses only Who Should Attend? Auditors seeking to perform and lead Occupational Health and Safety Management System (OH&S MS) certification audits Managers or consultants seeking to master an Occupational Health and Safety Management System audit process Individuals responsible for maintaining conformance with OH&S MS requirements Technical experts seeking to prepare for an Occupational Health and Safety Management System audit Expert advisors in Occupational Health and Safety Management Accreditation Assessment Delegates sit a combined exam, consisting of in-course quizzes and exercises, as well as a final 12 question essay type exam on Day 4 of the course. The overall passing score is 70%, to be achieved within the 150 minute time allowance. Exam results are provided within 24 hours. Provided by This course is Accredited by NACS and Administered by the IECB.
ISO 14001 Lead Auditor training enables you to develop the necessary expertise to perform an Environmental Management System (EMS) audit by applying widely recognized audit principles, procedures and techniques. About This Course During this training course, you will acquire the knowledge and skills to plan and carry out internal and external audits in compliance with ISO 19011 and ISO/IEC 17021-1 certification process. Based on practical exercises, you will be able to master audit techniques and become competent to manage an audit program, audit team, communication with customers, and conflict resolution. After acquiring the necessary expertise to perform this audit, you can sit for the exam and gain "Certified ISO 14001 Lead Auditor' Certificate. By holding this Certificate, you will demonstrate that you have the capabilities and competencies to audit organizations based on best practices. Learning objectives Understand the operations of an Environmental Management System (EMS) based on ISO 14001 Acknowledge the correlation between ISO 14001, ISO 14040 and other standards and regulatory frameworks Understand an auditor's role to: plan, lead and follow-up on a management system audit in accordance with ISO 19011 Learn how to lead an audit and audit team Learn how to interpret the requirements of ISO 14001 in the context of an EMS audit Acquire the competencies of an auditor to: plan an audit, lead an audit, draft reports, and follow-up on an audit in compliance with ISO 19011 Educational approach This training is based on both theory and best practices used in EMS audits Lecture sessions are illustrated with examples based on case studies Practical exercises are based on a case study which includes role playing and discussions Practice tests are similar to the Certification Exam Prerequisites A fundamental understanding of ISO 14001 and comprehensive knowledge of audit principles. Who Should Attend? Auditors seeking to perform and lead Environmental Management System (EMS) certification audits Managers or consultants seeking to master an Environmental Management System audit process Individuals responsible for maintaining conformance with EMS requirements Technical experts seeking to prepare for an Environmental Management System audit Expert advisors in Environmental Management What's Included? Refreshments & Lunch (Classroom courses only) Course Slide Deck Official Study Guides CPD Certificate The Exam Accreditation Assessment Delegates sit a combined exam, consisting of in-course quizzes and exercises, as well as a final 12 question, essay type exam on Day 4 of the course. The overall passing score is 70%, to be achieved within the 150 minute time allowance. Exam results are provided within 24 hours, with both a Certificate and a digital badge provided as proof of success. Provided by This course is Accredited by NACS and Administered by the IECB
Find out more about how your Church can partner with Restored to stand against violence against women and support survivors of domestic abuse.
Duration 2 Days 12 CPD hours Overview What is JIRA Software? Managing agile projects using JIRA Software Managing project backlog Managing iterations / sprints Managing releases / versions Managing project components Managing security Managing fields and screens Managing custom issue types Viewing various burn-down/burn-up reports This course introduces students to JIRA Software which is one of the most popular agile project management tool. Agile methods help in accelerating the delivery of initial business value. Continuous planning and feedback ensures that value is maximized throughout the development process. JIRA Software lets you manage project backlog, plan and execute sprints, and manage releases. It also lets you view useful reports, such as, velocity, various burndown / burn-up charts. Navigating JIRA Connecting to JIRA Software JIRA Account System Dashboard Sidebars Global Sidebar Search Help Dashboards Projects Boards Issues Project Sidebar Summary Managing Projects What is a Project? What is a Project (Contd.)? Backlog Sprints Versions / Releases Issues What is Component? Project Name and Key Project Key Format Editing Project Key Caveats Editing Project Key Deleting Project Summary Managing Versions What is Version What is Version (Contd.)? Merging Versions Other Version Options Version Fields What is Version? Summary Managing Issues Issues What are Epics? Epics ? Types Creating a new Epic What is a Story? Creating a Story Story Estimation Tasks Sub-tasks Summary Managing Sprints Sprints What is typically done in Sprint Planning? Velocity Agile Board Sprint Naming Convention Sprint Execution Summary Search & Using JQL Search Search Types JQL JQL Examples Sharing search result Save Search and Reuse in a Board Summary Working with JIRA Dashboards and Reports What is a JIRA Dashboard? Creating a JIRA Dashboard Choosing a Dashboard Layout What is a Gadget? Gadgets Available Out-of-the-box Adding a Gadget to a Dashboard Adding a Gadget to a Dashboard (Example Calendar Gadget) Moving a Gadget Removing a Gadget from a Dashboard Viewing Dashboard as a Wallboard Deleting a Dashboard JIRA Reports Generating a JIRA Report Generating a JIRA Report (Example ? Burndown Chart) Viewing the Burndown Chart Report Categories Available Out-of-the-box Agile Reports Issue Analysis Reports Forecast & Management Reports For further details ? Summary Jira Agile Common Jira Software boards Scrum Agility Kanban Scrum vs. Kanban Scrumban History of Kanban Kanban for software teams Kanban boards Kanban boards (Contd.) Kanban cards The benefits of Kanban Planning flexibility Shortened time cycles Fewer bottlenecks Visual metrics Continuous Delivery Kanban ? Kanban backlog Summary Miscellaneous Issue Features Voting Watching an Issue Adding/Removing Labels Linking Issues Linking Issue (Contd.) Commenting on Issue Attaching a File to an Issue Attaching a File to an Issue (Contd.) Cloning (Copying) an Issue Cloning (Copying) an Issue (Contd.) Cloning (copying) an Issue (Contd.) Viewing an Issue?s Change History Viewing an Issue's Change History (Contd. Summary Managing Fields & Screens (OPTIONAL: TIME PERMITTING) Fields OOB Fields Custom Fields Field Type Screens Summary
Wireshark 101 training course description Wireshark is a free network protocol analyser. This hands-on course focuses on troubleshooting networks using the Wireshark protocol analyser. The course concentrates on the product and students will gain from the most from this course only if they already have a sound knowledge of the TCP/IP protocols What will you learn Download and install Wireshark. Capture and analyse packets with Wireshark. Configure capture and display filters. Customise Wireshark. Troubleshoot networks using Wireshark. Wireshark 101 training course details Who will benefit: Technical staff looking after networks. Prerequisites: TCP/IP Foundation for engineers Duration 2 days Wireshark 101 training course contents What is Wireshark? Protocol analysers, Wireshark features, versions, troubleshooting techniques with Wireshark. Installing Wireshark Downloading Wireshark, UNIX issues, Microsoft issues, the role of winpcap, promiscuous mode, installing Wireshark. Wireshark documentation and help. Hands on Downloading and installing Wireshark. Capturing traffic Starting and stopping basic packet captures, the packet list pane, packet details pane, packet bytes pane, interfaces, using Wireshark in a switched architecture. Hands on Capturing packets with Wireshark. Troubleshooting networks with Wireshark Common packet flows. Hands on Analysing a variety of problems with Wireshark. Capture filters Capture filter expressions, capture filter examples (host, port, network, protocol), primitives, combining primitives, payload matching. Hands on Configuring capture filters. Working with captured packets Live packet capture, saving to a file, capture file formats, reading capture files from other analysers, merging capture files, finding packets, going to a specific packet, display filters, display filter expressions. Hands on Saving captured data, configuring display filters. Analysis and statistics with Wireshark Enabling/disabling protocols, user specified decodes, following TCP streams, protocol statistics, conversation lists, endpoint lists, I/O graphs, protocol specific statistics. Hands on Using the analysis and statistics menus. Command line tools Tshark, capinfos, editcap, mergecap, text2pcap, idl2eth. Hands on Using tshark. Advanced issues 802.11 issues, management frames, monitor mode, packet reassembling, name resolution, customising Wireshark. Hands on Customising name resolution.
AgilePM® Practitioner: In-House Training This course offers preparation for the Practitioner-level examination to gain the APMG-International™ / Agile Project Management Practitioner Certification. Agile Project Management (AgilePM) is the result of collaboration between APMG-International and The DSDM Consortium. DSDM (Dynamic Systems Development Method) is the longest-established Agile method, launched in 1995, and is the only Agile method to focus on the management of Agile projects. The method has evolved over the years and the DSDM Agile Project Framework is the latest version of which AgilePM is a subset. DSDM has always operated predominantly in the corporate environment and has consistently demonstrated its ability to successfully work with and complement existing corporate processes. APMG-International is a global Examination Institute accredited by The APM Group Ltd. It is one of the Examination Institutes accredited by AXELOS. APMG-International has regional offices located in Australia, China, Denmark, Germany, the Netherlands, Malaysia, the United States, and the United Kingdom. Their portfolio of qualifications includes the Best Practice qualifications of ITIL®, PRINCE2®, MSP®, M_o_R®, and P3O®. AgilePM is one of their specialist management qualifications, which also include Change Management and Service Catalogue. The course covers all the Practitioner elements of the AgilePM Handbook v2 with: Clear explanations of the method and practical examples provided by your course tutor Sample exam paper for the Practitioner-level exams to enrich your knowledge and understanding A case study to allow you to practice the application of the method to an agile project The Traditional Classroom option includes the Practitioner exam to provide you with the right opportunity to verify your new skill set by way of a professional qualification The Virtual Classroom option includes a Practitioner exam voucher to allow you to choose the date and time of your online exam to verify your new skill set by way of a professional qualification What You Will Learn You will learn how to: Identify and apply the concepts, tools, and techniques described in Section 2 (Digging Deeper) of the APMG-International's Agile Project Management Handbook (v2.0) to agile projects Tailor and customize AgilePM to suit the needs of different projects Use AgilePM in conjunction with other project management methods such as PRINCE2® Prepare yourself for the Practitioner exam in AgilePM Roles and Responsibilities - The PM View The roles Key project manager relationships Agile Project Management - Through the Lifecycle The DSDM process and the project lifecycle Project management focus phase by phase The Effective Use of Products The products Deliver on Time - Combining MoSCoW & Timeboxing Ensuring effective prioritisation Bringing MoSCoW and timeboxing together People, Teams, and Interactions Effective communication Collaboration Requirements and User Stories What is a requirement? User stories Estimating - How and When Coping with uncertainty Estimating through the lifecycle Project Planning through the Lifecycle Planning in a DSDM project Planning activities phase by phase Quality - Never Compromise Quality What do we mean by quality? Solution and process quality Risk Management Project risk How DSDM helps mitigate project risk Tailoring the Approach The project approach questionnaire Summary and Next Steps
Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence 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 55232 Writing Analytical Queries for Business Intelligence 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.
BOHS P304 is designed to give practical guidance on assessing the health risks caused by hazardous substances, in order to meet the requirements of the Control of Substances Hazardous to Health (COSHH) Regulations 2002 for a 'suitable and sufficient' risk assessment.
What does this course cover? This is an online course for developing history leadership in primary teaching. This term, we will be piloting the course as an immersive programme covering the key elements of primary history subject leadership, enabling all involved in history leadership at primary to carry out their role effectively. How is this course structured and delivered? Sessions 1, 8 and 10 are compulsory to attend live. Participants will be required to complete a gap task after each session and contribute to an online reflection diary. The other sessions will be recorded for participants to work through at their convenience. Who is this course for? This programme is designed for anyone who is a subject coordinator or subject leader for history in their primary school. You may have just been appointed as a subject leader, or be more experienced but looking for formal training or fresh inspiration and direction. What are the outcome? This course will: equip you fully for the demands of history leadership in primary schools increase your confidence to develop an innovative, inclusive and effective history curriculum in your school develop your understanding of efficient action planning and how to make a wider impact help you to make the case for history with senior leaders enable you to enthuse others and lead staff meetings about history develop your understanding of current issues in primary history education The course will include a chance to share resources and assessment approaches, plus much more What will each session cover? Session 1: Introductory meeting (Live attendance) Wednesday 15 October 2025, 4pm–5.30pm Introduction and aims Reflection activity on the current state of history in your school Key responsibilities of the history subject leader Current Ofsted implications for the subject and what to expect in an inspection How the HA and latest Ofsted material can support you Session 2: What makes an effective history subject leader? (Recorded) How to effectively support teachers and learners as a history leader How to create a vision, lead change, and manage time Effective action planning and improvement Auditing your history provision and building your evidence trail Developing an innovative, inclusive and effective history curriculum in your school Disciplinary knowledge: What is history? What do historians do? Suggested gap task: Conducting teacher and/or pupil voice questionnaires. Compulsory gap task: Add to your reflection diary for the programme. If relevant, reflect on how you will use the teacher questionnaire or pupil voice. Session 3: What makes effective teaching of history? (Recorded) The role of the teacher Supporting SEND pupils Securing substantive knowledge and concepts across the curriculum How to support colleagues by identifying core knowledge How to involve the whole staff in mapping out and embedding the progression of concepts across the curriculum Suggested gap task: Consider SEND in your curriculum. Compulsory gap task: Add to your reflection diary for the programme reflecting on SEND. Session 4: Curriculum and practice at EYFS (Recorded) Unpicking and supporting the requirements of the EYFS curriculum and Development Matters Developing historical and chronological understanding in EYFS as part of Understanding the world Progression and transition from EYFS to Key Stage 1 Ensuring coherence: how to start developing concepts Making use of the local history on your doorstep for EYFS and KS1 Accessing resources and support for EYFS Suggested gap task: Fact finding and liaison. Compulsory gap task: Add to your reflection diary for the programme reflecting on current EYFS practice. Session 5: Curriculum and practice at Key Stage 1 (Recorded) Unpicking and supporting the requirements of the National Curriculum for KS1 Progression: building upon transition from EYFS What do KS1 require before KS2? Ensuring coherence: further developing the school’s chosen substantive concepts How to develop disciplinary concepts Developing appropriate chronological understanding in KS1 Enhancing and engaging children’s knowledge and retention through enquiry The use of working walls in KS1 to support learning Accessing resources and support for KS1 Suggested gap task: Check your KS1 curriculum for coverage and progression, building upon what they have learnt in EYFS. Compulsory gap task: Add to your reflection diary for the programme reflecting on KS1 practice in your setting. Session 6: Curriculum and practice at Key Stage 2 (Recorded) Unpicking and supporting the requirements of the National Curriculum for KS2 How to incorporate local history with progression in KS2 What do we want the children in Year 6 to leave with? Developing appropriate chronological understanding in KS2 Preparing for transition to Key Stage 3 Ensuring coherence: building upon the school’s chosen concepts for progression What the HA can do to support the teaching of KS2 units? Resources and support for KS2 Suggested gap task: Check your KS2 curriculum for coverage and progression, building upon what they have learnt in EYFS and KS1. Compulsory gap task: Add to your reflection diary for the programme reflecting on KS2 practice in your setting. Session 7: Approaching sensitive issues in history (Recorded) What do we mean by diversity in history and why is it important? How to ensure a wider diversity in your history teaching Barriers to making the curriculum more diverse and how to overcome them Approaches to sensitive issues in history lessons, including: - Refugees and migration history - War - Climate change Suggested gap task: Consider opportunities for increasing diverse voices and raising climate issues in your curriculum. Compulsory gap task: Add to your reflection diary for the programme considering how you might address the sensitive or current issues raised in this session. Session 8: Interim review meeting (Live attendance) Monday 19 January 2026, 4pm–5.30pm A review session allowing subject leaders to reflect upon their progress so far Opportunity to respond to suggestions, clarify information, or raise issues from the previous sessions Time to ask questions, share good practice or recommended resources with the rest of the cohort Suggested gap task: Time to follow up on anything raised in this session or to complete any previous tasks, following clarification and inspiration from this session. Compulsory gap task: Add to your reflection diary for the programme, reflecting on your priorities and actions using suggestions from the presenter or other delegates. Session 9: Assessment and evidence (Recorded) Assessment and expectations A word about writing Triangulating the evidence What to look for in a work scrutiny Suggested gap task: Conduct a work scrutiny on one aspect to check across the school, in conjunction with a focused pupil voice on the same aspect. Compulsory gap task: Add to your reflection diary considering how you will conduct a work scrutiny and what you will focus on – or, if relevant, reflect on what you discovered and how you will address any issues. Session 10: Final meeting (Live attendance) Wednesday 11 February 2026, 4pm–5.30pm Following up any requests arising from the interim meeting (Session 8) Discussion or clarification of any issues arising from previous sessions Discussion of priorities, next steps and any issues Sharing ideas for enthusing others and leading staff meetings: “What worked for me?” Communicating with headteachers, governors, colleagues and parents Are you ready for the HA Quality Mark? Suggested gap task: Identifying your school’s next steps Compulsory gap task: Complete your final piece in your reflection diary.