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.
SAFe® Scrum Master: In-House Training Build your skills as a high-performing team member of an Agile Release Train (ART) and prepare to support the facilitation of team and program events when you become a SAFe® 5 Scrum Master (SSM). In this course, you'll gain an understanding of the role of Scrum Master in a SAFe® enterprise. Unlike traditional Scrum Master training that focuses on the fundamentals of team-level Scrum, the SAFe® Scrum Master course explores the role of the Scrum Master in the context of the entire enterprise and prepares you to successfully plan and execute the Program Increment (PI), the primary enabler of alignment throughout all levels of a SAFe® organization. What you will Learn To perform the role of a SAFe® Scrum Master, attendees should be able to: Describe Scrum in a SAFe® enterprise Facilitate Scrum events Facilitate effective Iteration execution Support effective Program Increment execution Support relentless improvement Coach Agile teams for maximum business results Support DevOps implementation Build a high-performing ART by becoming a servant leader and coach Develop an action plan to continue your learning journey Introducing Scrum in SAFe® Characterizing the role of the Scrum Master Experiencing Program Increment planning Facilitating Iteration execution Finishing the Program Increment Coaching the Agile team
Lean Six Sigma Yellow Belt Certification Program: In-House Training This course is designed to instill an in-depth understanding of Lean Six Sigma and a clear sense of what is required to define high-impact improvement projects, establish Lean Six Sigma measurements, and complete Lean Six Sigma projects using the systematic and proven Define, Measure, Analyze, Improve, and Control (DMAIC) methodology. This course is designed to instill an in-depth understanding of Lean Six Sigma and a clear sense of what is required to define high-impact improvement projects, establish Lean Six Sigma measurements, and complete Lean Six Sigma projects using the systematic and proven Define, Measure, Analyze, Improve, and Control (DMAIC) methodology. Participants will learn basic tools and techniques of Lean Six Sigma and those who pass a thirty-question exam (70% or above) will become a Certified Lean Six Sigma Yellow Belt. This course is delivered through four 3-hour online sessions. What you Will Learn You'll learn how to: Establish the structure that supports and sustains Lean Six Sigma Quality Identify and calculate key Lean Six Sigma Measurements (Sigma, DPMO, and Yield) Select successful, high-impact projects that match strategic objectives Document, measure, and improve key processes using the DMAIC (Define, Measure, Analyze, Improve, and Control) Methodology Utilize data-based thinking to make key business decisions Introduction to the Fundamentals and Vision of Lean Six Sigma Lean Six Sigma's focus on the customer, on quality, and on results The costs of poor quality Critical factors to consider when deploying Lean Six Sigma Lean Six Sigma as a process improvement methodology Lean Six Sigma metrics Why do it - ROI and payback for Lean Six Sigma Business Process Management Critical Lean Six Sigma roles and responsibilities Main aspects of managing the organizational change Project selection Metrics of Lean Six Sigma and the DMAIC Model How to strategically align business metrics and projects within an organization How to identify and measure quality characteristics which are critical to customers What does the customer (internal or external) really want from our products and services? Establishing appropriate teams and setting those teams up to be successful What defines a good measurement system? How are we doing (learning the secret to measuring the right things, right)? How to improve output measures by understanding and measuring the process Where are there defects (how to properly select and scope high-impact projects)? Where is the process broken (the Lean Six Sigma version of root cause analysis)? How to determine the process efficiency, or value add, of a process The appropriate use of quality tools Understanding the concept of variation and how to reduce knee-jerk reactions How to achieve breakthrough results for any key measure How can we ensure the identified improvements will be sustainable (the basics of process control)?
Recovering Troubled Projects: In-House Training Despite our best intentions, many of the projects that organizations undertake either don't achieve their intended business results or end in complete failure. Most seasoned project managers have had their share of experiences with difficult or troubled projects and unless they are careful, they will encounter more. This workshop does not focus on 'failed' projects but rather on those projects which without appropriate intervention would be headed for failure. Failed projects are those beyond help and which should be terminated. Here we focus on projects that are salvageable. It is an exercise-driven, no-nonsense, professional practice-focused workshop positioning the participant to immediately apply the tools and lessons learned in the classroom. The workshop employs the use of both illustrative and practical/working case studies. Illustrative case studies will examine insights from real-world troubled projects. Participants will be asked to bring descriptions of their own examples of troubled projects on which they're currently working or on which they have worked in the past. A number of these will be used as the basis for the practical/working case studies. The approach builds on and complements the disciplines addressed in Project Management Institute's PMBOK® Guide and also addresses issues that arise when managing projects in a complex environment. What You Will Learn You will learn to: Recognize the value of a structured project recovery process Explain the reasons most projects fail Analyze the causes of a project's troubles Construct a negotiation process to use with key stakeholders Apply an effective strategy to planning the recovery effort Manage, evaluate, and adjust the ongoing recovery effort Foundation Concepts Recognizing a troubled project Defining the project recovery process The Reasons Projects Fail Putting failure in perspective Reviewing management issues Analyzing planning issues Exploring complexity issues Assess the Project Stabilizing the project Determining preliminary Go / No-Go Conducting a detailed recovery assessment Negotiate the Recovery Reviewing the basics of negotiation Setting reasonable expectations Obtaining appropriate PM authority Securing key stakeholder support Plan the Recovery Planning for recoveries Rebuilding the project team Reshaping the project plan Managing parallel activities Planning for change management Implement and Adjust the Project Implementing project recoveries Facilitating change Enabling continuous learning Fostering the project team Sustaining stakeholder engagement
SAFe® Scrum Master: Virtual In-House Training Build your skills as a high-performing team member of an Agile Release Train (ART) and prepare to support the facilitation of team and program events when you become a SAFe® 5 Scrum Master (SSM). In this course, you'll gain an understanding of the role of Scrum Master in a SAFe® enterprise. Unlike traditional Scrum Master training that focuses on the fundamentals of team-level Scrum, the SAFe® Scrum Master course explores the role of the Scrum Master in the context of the entire enterprise and prepares you to successfully plan and execute the Program Increment (PI), the primary enabler of alignment throughout all levels of a SAFe® organization. What you will Learn To perform the role of a SAFe® Scrum Master, attendees should be able to: Describe Scrum in a SAFe® enterprise Facilitate Scrum events Facilitate effective Iteration execution Support effective Program Increment execution Support relentless improvement Coach Agile teams for maximum business results Support DevOps implementation Build a high-performing ART by becoming a servant leader and coach Develop an action plan to continue your learning journey Introducing Scrum in SAFe® Characterizing the role of the Scrum Master Experiencing Program Increment planning Facilitating Iteration execution Finishing the Program Increment Coaching the Agile team
ICA International Diploma in Anti Money Laundering -Flagship qualification This ICA Diploma in Anti Money Laundering training course is an in-depth, graduate level programme which will provide Participants with a professional qualification in anti-money laundering upon completion and helps individuals develop best practice initiatives and prepares them to face present and future challenges, reducing risk. This qualification is increasingly important for professionals as money laundering prevention remains high on the agenda for financial services professionals. This Diploma will help Participants find an integrated approach to fighting the risk is needed and knowledgeable. There are many benefits of studying with ICA: Flexible learning solutions that are suited to you Our learner-centric approach means that you will gain relevant practical and academic skills and knowledge that can be used in your current role Improve your career options by undertaking a globally recognised qualification that hiring managers look for as part of their hiring criteria Many students have stated that they have received a promotion and/or pay rise as a direct result of gaining their qualification The qualifications ensure that you are enabled to develop strategies to help manage and prevent risk within your firm, thus making you an invaluable asset within the current climate Course format 9-month course assessed by 3 written assignments (3,000 - 3,500 words) A mixture of guided online study and participation in live sessions: 2 x virtual classrooms* 1 x immersive learning scenario (putting you at the centre of a story) 3 x tutorials (a chance to discuss elements of the course in more depth) 3 x assessment preparation sessions Videos covering the latest industry developments and case studies Access to the ICA members' portal containing additional reading and resources Proactive support throughout the course to help you stay on track Students of this course will achieve the following outcomes: Increased potential for career progression Extensive knowledge and highly developed AML skills Enhanced workplace performance Professional membership of the ICA Ability to reduce reputational and financial risk for the organisation On successful completion of this ICA Diploma in Anti Money Laundering training course students will be awarded an ICA Diploma in Anti Money Laundering and will be able to use the designation 'Dip.(AML)'. This course is awarded in association with Alliance Manchester Business School, the University of Manchester. The ICA Diploma in Anti Money Laundering training course instructs students in the following areas: Anti money laundering (AML) and countering the financing of terrorism CFT in context Terrorist financing proliferation financing and sanctions Designing a comprehensive AML/CTF risk-based approach for a financial services business Risk-based customer due diligence (CDD), customer risk profiling and monitoring Governance and leadership Suspicious activity reports/ suspicious transaction reports and dealing with the authorities
Getting Started BA (Hons) Business and Management focuses on gaining practical knowledge in management. This program supports the learner to acquire the skills needed to manage a business organisation, such as communication, decision-making, and problem-solving. BA (Hons) Business and Management aims to make the learners aware of the various day-to-day operations and activities in a business organisation. Also, it aims for the students to understand the effective management of the business. In this qualification, learners will have the chance to study International Business. After completing this program, a learner will acquire the skills to make a prompt decisions in a competitive, changing business world. Besides, the qualification will help the student understand the techniques of modern business, and further, this course will provide knowledge to become a successful businessman in the contemporary world. Learners will bridge the gap between theory and practice upon completing the programme. The course improves the chances of progression in a career and helps the learner to manage the activities in a business organisation. The program comprises two phases; the first is the Level 4 and 5 Diploma in Business Management awarded by Qualifi and delivered by School of Business and Technology London. The second phase is the BA (Hons) Business and Management Top Up, delivered and awarded online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, PC or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. About Awarding Body Anglia Ruskin University began in 1858 as the Cambridge School of Art founded by William Beaumont. It was then merged with the Cambridge shire College of Arts and Technology and the Essex Institute of Higher Education and was renamed Anglia Polytechnic. It was then given university status in 1992 and renamed Anglia Ruskin University in 2005. The university has campuses in the UK (Cambridge, Chelmsford, London and Peterborough), as well as they are partnered with institutions around the world including Berlin, Budapest, Trinidad, Singapore and Kuala Lumpur. Assessment Assignments and Project No examinations Entry Requirements Applicants are required to have the following entry requirements: A level or Equivalent Minimum 1 Year of Business Management work experience Further, candidates are also required to demonstrate their English language proficiency. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. Structure Phase 1 - QUALIFI Level 4 and 5 Diploma in Business Management Programme Structure Level 4 The Qualification is made up of 6 units. All units are mandatory and required by learners to be awarded the Level 4 Diploma in Business Management. Level 4 diploma in Business Management made up of 120 credits which equates to 1200 hours of TQT and include 480 hours of GLH. Communications in Organisations Unit Reference Number : D/507/1581 TQT : 200 Credit : 20 This unit assists managers in examining the connections between effective communication and the cultivation of workforce comprehension and commitment to change. It does so by delving into the concept of good communication practices. Leadership and the Organisation Unit Reference Number : H/507/1582 TQT : 200 Credit : 20 This unit offers learners the chance to explore the characteristics and skills essential for successful leadership comprehensively. Learners will also be equipped to contemplate the application of various leadership theories and models to specific scenarios and understand the methods for developing leadership skills. Financial Awareness Unit Reference Number : M/507/1584 TQT : 200 Credit : 20 This unit is crafted to acquaint learners with the nature, role, and significance of financial information within organisations, specifically focusing on the managerial viewpoint. Managing Change Unit Reference Number : A/507/1586 TQT : 200 Credit : 20 This unit delves into the planning, implementation, and evaluation of change. It strongly emphasises involving those directly impacted, seeking their insights, knowledge, commitment, and ownership in the change process. Business Operations Unit Reference Number : F/507/1587 TQT : 200 Credit : 20 This unit centres on the proficient and resourceful planning and supervision of work activities. It equips learners with the competence to devise, enact, and modify operational plans to enhance effectiveness and efficiency while allowing for designing and overseeing suitable systems to ensure product and service quality. Developing Teams Unit Reference Number : J/507/1588 TQT : 200 Credit : 20 This unit centres on establishing, growing, and reinforcing teams to enable them to attain their goals and objectives. Learners are tasked with recognising the skills and potential of team members, and they should create avenues for team members to acquire new skills and experiences. Level 5 The Qualification is made up of 6 units. All units are mandatory and required by learners to be awarded the Level 5 Diploma in Business Management Responding to the Changing Business Environment Unit Reference Number : R/507/1612 TQT : 200 Credit : 20 The central focus of this unit revolves around the evolving dynamics among business, government, and their constituents, leading to a landscape that presents both prospects and challenges for contemporary organisations. Profoundly grasping the organisational implications of these trends enables managers to adapt constructively to the shifting socio-economic milieu. Effective Decision Making Unit Reference Number : Y/507/1513 TQT : 200 Credit : 20 This unit will examine diverse approaches to corporate decision-making, encompassing the decision implementation process and effectively utilising knowledge within organisations. Business Development Unit Reference Number : D/507/1614 TQT : 200 Credit : 20 The primary objective of this unit is to equip learners with the essential knowledge and skills required for researching a market and formulating a development strategy, which may involve launching a new business model, establishing a new enterprise, or introducing a fresh product or service line. Business Models and Growing Organisations Unit Reference Number : H/507/1615 TQT : 200 Credit : 20 This unit delves into the growth journey of small businesses, the factors contributing to their success, and the optimal management of available growth opportunities. This comprehensive exploration will enhance the learner's comprehension of rapidly expanding organisations in the economy's private and social sectors. Customer Management Unit Reference Number : K/507/1616 TQT : 200 Credit : 20 This unit's primary goal is to give learners a profound understanding of customer behaviour. It will foster skills development and empower learners to employ tools and strategies organisations can utilise to enhance customer retention and cultivate stronger customer relationships. Risk Management and Organisations Unit Reference Number : T/507/1618 TQT : 200 Credit : 20 In this unit, learners will engage in the process of constructing risk profiles and devising risk management strategies for specific case studies. These case studies, accessible online, will serve as illustrative examples of the varied approaches organisations employ when addressing change. Phase 2 - BA (Hons) Business and Management Programme Structure Strategic Management Sustainability and Responsible Business Marketing Communications Business Management Undergraduate Major Project Delivery Methods The program comprises two phases; the first is the Level 4 and 5 Diploma in Business Management awarded by Qualifi and delivered by School of Business and Technology London. The School of Business and Technology London offers flexible learning methods, including online and blended learning, allowing students to choose the mode of study that suits their preferences and schedules. The program is self-paced and facilitated through an advanced Learning Management System. Students can easily interact with tutors through the SBTL Support Desk Portal System for course material discussions, guidance, assistance, and assessment feedback on assignments. School of Business and Technology London provides exceptional support and infrastructure for online and blended learning. Students benefit from dedicated tutors who guide and support them throughout their learning journey, ensuring a high level of assistance. The second phase is the BA (Hons) Business and Management Top Up, delivered and awarded online by Anglia Ruskin University. At Anglia Ruskin University, you will study through Canvas, a world-class online Learning Management System (LMS), accessed from your phone, PC or tablet at home or on the move. Canvas provides instant access to study materials, forums, and support from tutors and classmates, as well as enabling easy submission of your assignments. After successfully completing your studies, you'll be invited to attend a graduation ceremony on campus at Anglia Ruskin University. If attending the ceremony in person is not possible, we'll arrange to send your certificate to you. School of Business and Technology London partners with Chestnut Education Group to promote this programme. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.
Duration 2 Days 12 CPD hours This course is intended for Any professionals who need to work effectively with others without direct authority, as well as mid- and upper-level executives and managers who would benefit from understanding the motivations of others to achieve successful results for the business. Overview Build workplace relationships based on mutual trust and respect Collaborate effectively through influence and persuasion Recognize and enhance your sources of personal power Choose and apply appropriate influence strategies Work with resistance to gain commitment and buy-in In this course, you will learn to become proficient in the art of persuasion, selecting and utilizing appropriate styles and strategies to have the most influential effect, as well as understanding how to protect yourself from being manipulated by others. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. An Influence Baseline Enabling Collaboration Facilitating Constructive Dialogue 2. Elements of Influence Focusing on the Outcome Seeing Influence as a Mental Equation Differentiating Influence from Manipulation 3. Power and Persuasion Developing and Using Power Sources Developing the Art of Persuasion Appealing to Integrity, Emotions, and Intellect Building Five Types of Trust Applying Five Principles of Influence 4. A Network of Influence Building a Purposeful Network Strategic Reputation Management Protecting Your Credibility 5. Applying Influence Strategies Adapting the Approach Identifying Thinking Differences Applying Strategies to Styles 6. Working With Resistance Encountering and Addressing Resistance Building Collaboration through Quality Dialogue Getting Results through Persistence and Persuasion Additional course details: Nexus Humans Extending Your Sphere of Influence 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 Extending Your Sphere of Influence 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.