Harpenden

<p>This workshop is designed to build participants' knowledge, skills and confidence in mental health and resilience in the workplace. The workshop will benefit all those looking to increase their knowledge around the subject enabling them to support someone exhibiting sigs of mental ill health, as well as increasing their own resilience and being aware of their own mental wellbeing.</p><ul><li>AN IN DEPTH UNDERSTANDING OF MENTAL HEALTH AND THE FACTORS THAT CAN AFFECT WELLBEING</li><li>PRACTICAL SKILLS TO SPOT THE TRIGGERS AND SIGNS OF MENTAL HEALTH ISSUES</li><li>CONFIDENCE TO STEP IN, REASSURE AND SUPPORT A PERSON IN DISTRESS</li><li>KNOWLEDGE, SKILLS AND CONFIDENCE THROUGH PRACTICAL EXERCISES TO INCREASE LEVELS OF PERSONAL RESILIENCE</li></ul><section>
                    <h3>1. Introduction</h3><ul><li>Workshop objectives and benefits from attending</li><li>Participants' experience and confidence in this area</li><li>Personal objectives</li></ul><h3>2. Understanding mental health</h3><ul><li>What is mental health?</li><li>Mental health and stigma</li><li>Types of mental ill health disorders</li></ul><h3>3. Supporting others</h3><ul><li>Warning signs of mental ill health</li><li>How to support someone exhibiting signs of mental ill health</li></ul><h3>4. Supporting yourself</h3><ul><li>Stess: coping mechanisms and self-care</li><li>What is resilience, why is it important and how can you increase your levels?</li><li>Building your support network</li></ul><h3>5. Next steps</h3><ul><li>Individual learning and action planning</li><li>Group review and close</li></ul>


                </section>

Maximum Performance

Mental Health Awareness in the Workplace

<p>Consciously or not, most of us use a coaching approach at work to one degree or another. When we are clearer about what we do that works we get even better results. When we invest time in building our skills, by getting some training in the subject, we get the best results of all. If you're interested in improving your coaching skills, then this is the programme for you.</p><ul><li>ENHANCE YOUR UNDERSTANDING OF THE SKILLS AND APPROACHES THAT UNDERPIN COACHING EXCELLENCE</li><li>IMPROVE THE QUALITY OF YOUR COACHING BY LEVERAGING THE SKILLS THAT YOU ALREADY HAVE</li><li>LEARN HOW TO MAKE YOUR COACHING CONVERSATIONS MORE EFFECTIVE</li><li>DEVELOP AN ACTION PLAN TO TAKE YOUR COACHING TO THE NEXT LEVEL</li></ul><section>
                    <h3>1. Welcome and introduction</h3><ul><li>What will make today worthwhile for you?</li></ul><h3>2. Coaching or 'a coaching approach'?</h3><ul><li>What is coaching? Myths and reality</li><li>What is 'a coaching approach'? What's the difference?</li><li>How does 'a coaching approach' differ from a management conversation?</li><li>Heron's model for 'coaching styles'</li><li>Your coaching / communication style</li></ul><h3>3. Four key coaching skills</h3><ul><li>Building trust and rapport</li><li>Active listening</li><li>Powerful questions</li><li>Designing action</li></ul><h3>4. A framework for a coaching conversation</h3><ul><li>The OSCAR model</li><li>Encourage accountability and responsibility with team members</li><li>Empower colleagues / clients</li></ul><h3>5. Application</h3><ul><li>Skills practice: using the OSCAR framework and core coaching skills to achieve effective outcomes from a coaching conversation</li></ul><h3>6. Review and next steps</h3><ul><li>Reflections and action planning</li></ul>


                </section>

Coaching Skills in a Day!

<h2>Mediation Mindsets and Skills: In-House</h2><p>This is an interactive and dynamic workshop designed to help participants increase their understanding of conflict and of the use of mediation mindsets and skills to manage it. Mediation facilitates people in conflict finding their own way forward. By using mediation mindsets and skills, participants will be able to understand the sources of conflict and how to manage it and will become more effective in dealing with it in their organisations.</p><h3>Learning objectives</h3><p>At the end of the session participants will:</p><ul><li>Understand themselves better when they are in conflict</li><li>Be aware of how people in conflict behave, feel and think</li><li>Understand, and be able to apply, mediation mindsets and skills to managing conflict</li><li>Be able to deal with conflict more effectively, becoming more confident and assertive</li></ul><section>
                    <h3>Introduction</h3><ul><li>Workshop objectives</li><li>Participants' experience and confidence in this area</li><li>Personal objectives</li></ul><h3>Overview of conflict</h3><ul><li>Conflict in organisations and teams</li><li>The conflict escalation spiral</li><li>Constructive or destructive conflict?</li></ul><h3>Causes of conflict</h3><ul><li>Neurobiology and conflict: reaction and response</li><li>Observations and interpretations</li><li>Mayer's Wheel of Conflict</li><li>The PIN model: Positions-Interests-Needs</li></ul><h3>Key mindsets in mediation</h3><ul><li>Impartiality and neutrality</li><li>Creating space</li><li>Creating safety</li></ul><h3>Key skills</h3><ul><li>Listening for facts, feelings, needs and assumptions</li><li>Reflecting and summarising</li><li>Powerful questioning</li><li>Empathy</li></ul><h3>Assertive communication and non-violent communication</h3><ul><li>NVC model</li><li>I statements</li></ul><h3>Application and review of the day</h3><ul><li>So, what do you need to deal with conflict successfully?</li><li>Diffusing a reaction</li><li>Action planning</li><li>Review and close</li></ul>


                </section>

Mediation Mindsets and Skills: In-House

<h2>Mediation Skills</h2><p>This is an interactive and dynamic workshop designed to help participants increase their understanding of conflict and of the use of mediation mindsets and skills to manage it. Mediation facilitates people in conflict finding their own way forward. By using mediation mindsets and skills, participants will be able to understand the sources of conflict and how to manage it and will become more effective in dealing with it in their organisations.</p><h3>Learning objectives</h3><p>At the end of the session participants will:</p><ul><li>Understand themselves better when they are in conflict</li><li>Be aware of how people in conflict behave, feel and think</li><li>Understand, and be able to apply, mediation mindsets and skills to managing conflict</li><li>Be able to deal with conflict more effectively, becoming more confident and assertive</li></ul><section>
                    <h3>Introduction</h3><ul><li>Workshop objectives</li><li>Participants' experience and confidence in this area</li><li>Personal objectives</li></ul><h3>Overview of conflict</h3><ul><li>Conflict in organisations and teams</li><li>The conflict escalation spiral</li><li>Constructive or destructive conflict?</li></ul><h3>Causes of conflict</h3><ul><li>Neurobiology and conflict: reaction and response</li><li>Observations and interpretations</li><li>Mayer's Wheel of Conflict</li><li>The PIN model: Positions-Interests-Needs</li></ul><h3>Key mindsets in mediation</h3><ul><li>Impartiality and neutrality</li><li>Creating space</li><li>Creating safety</li></ul><h3>Key skills</h3><ul><li>Listening for facts, feelings, needs and assumptions</li><li>Reflecting and summarising</li><li>Powerful questioning</li><li>Empathy</li></ul><h3>Assertive communication and non-violent communication</h3><ul><li>NVC model</li><li>I statements</li></ul><h3>Application and review of the day</h3><ul><li>So, what do you need to deal with conflict successfully?</li><li>Diffusing a reaction</li><li>Action planning</li><li>Review and close</li></ul>


                </section>

Mediation Mindsets and Skills

<h2>Influencing and Negotiating</h2><p>You can't do it all. Whatever your role, you rely on other people. Whose support do you need? Who needs your support? How is that support gained? It all comes down to influencing and negotiating. Those who are better at it find it easier to achieve success.</p><p>So this workshop is designed to help you develop your influencing and negotiating skills.</p><p>It's not about &amp;'hard' contract or sales negotiations. It is about working out how best to work with others, particularly in terms of getting what you need from them so that you can achieve your specific objectives. And doing so in a positive, constructive way - win / win!</p><h3>Learning objectives</h3><p>By the end of this workshop you will be able to:</p><ul><li>Assess your influencing and negotiating skills (from development areas to over-done strengths)</li><li>and build on them for specific situations</li><li>Take a proactive approach to developing your network of stakeholders and influencers</li><li>Apply the push-pull model of influencing skills</li><li>Influence others more effectively, both on a one-to-one basis and in meetings</li><li>Choose the most appropriate negotiating approach for each specific situation</li></ul><section>
                    <h3>Welcome and introduction</h3><ul><li>Workshop objectives</li><li>Personal objectives and workplace challenges</li><li>Personal action plans</li></ul><h3>What do we mean by influencing and negotiating?</h3><ul><li>Persuading? Negotiating? Influencing? What's the difference?</li><li>Where do you need to influence and negotiate in your role?</li><li>The skills, knowledge and attitude required to be a successful influencer and negotiator</li><li>How good are you?</li></ul><h3>How can you influence others?</h3><ul><li>Your pre-work questionnaire</li><li>7 influencing power bases</li><li>Influencing your manager</li><li>Powerful stakeholders - using the power/interest grid</li><li>The emotional bank account</li><li>Influencing in meetings</li></ul><h3>Negotiation approaches</h3><ul><li>Preparing for a negotiation</li><li>Self-assessment inventory</li><li>5 approaches to negotiation</li><li>You want some water?</li><li>Let go of the orange!</li><li>Win-win</li></ul><h3>Negotiation scenarios</h3><ul><li>Practical negotiation exercises</li></ul><h3>Review and action plans</h3><ul><li>Review</li><li>Next steps</li></ul>


                </section>

Influencing and Negotiating

<h2>Influencing and Negotiating: In-House</h2><p>You can't do it all. Whatever your role, you rely on other people. Whose support do you need? Who needs your support? How is that support gained? It all comes down to influencing and negotiating. Those who are better at it find it easier to achieve success.</p><p>So this workshop is designed to help you develop your influencing and negotiating skills.</p><p>It's not about &amp;'hard' contract or sales negotiations. It is about working out how best to work with others, particularly in terms of getting what you need from them so that you can achieve your specific objectives. And doing so in a positive, constructive way - win / win!</p><h3>Learning objectives</h3><p>By the end of this workshop you will be able to:</p><ul><li>Assess your influencing and negotiating skills (from development areas to over-done strengths)</li><li>and build on them for specific situations</li><li>Take a proactive approach to developing your network of stakeholders and influencers</li><li>Apply the push-pull model of influencing skills</li><li>Influence others more effectively, both on a one-to-one basis and in meetings</li><li>Choose the most appropriate negotiating approach for each specific situation</li></ul><section>
                    <h3>Welcome and introduction</h3><ul><li>Workshop objectives</li><li>Personal objectives and workplace challenges</li><li>Personal action plans</li></ul><h3>What do we mean by influencing and negotiating?</h3><ul><li>Persuading? Negotiating? Influencing? What's the difference?</li><li>Where do you need to influence and negotiate in your role?</li><li>The skills, knowledge and attitude required to be a successful influencer and negotiator</li><li>How good are you?</li></ul><h3>How can you influence others?</h3><ul><li>Your pre-work questionnaire</li><li>7 influencing power bases</li><li>Influencing your manager</li><li>Powerful stakeholders - using the power/interest grid</li><li>The emotional bank account</li><li>Influencing in meetings</li></ul><h3>Negotiation approaches</h3><ul><li>Preparing for a negotiation</li><li>Self-assessment inventory</li><li>5 approaches to negotiation</li><li>You want some water?</li><li>Let go of the orange!</li><li>Win-win</li></ul><h3>Negotiation scenarios</h3><ul><li>Practical negotiation exercises</li></ul><h3>Review and action plans</h3><ul><li>Review</li><li>Next steps</li></ul>


                </section>

Influencing and Negotiating: In-House

<h2>Strategy in a Day</h2><p>Success in 21st century organisations is more dependent than ever on being able to convert long term vision and goals in to detailed operating plans and, even more critically, employing an effective strategic management framework to ensure successful execution.</p><p>Being able to think, plan and implement in a strategic way is becoming increasingly called upon in many more management roles. Our practical one-day expert workshop is designed for anyone wanting to develop the knowledge and skills required to take on a strategic role or management position.</p><h3>Learning objectives</h3><p>After completing this course Participants will be able to:</p><ul><li>Understand the purpose and key components of business strategy</li><li>Use an effective framework for developing and executing strategy</li><li>Apply powerful strategic analysis tools to inform strategy development</li><li>Evaluate strategic options using established frameworks for strategy formulation</li><li>Develop and apply a winning business model for their organisation</li><li>Use effective tools to manage and control strategy implementation</li><li>Identify some common causes of strategic failure</li></ul><section>
                    <h3>Basic principles</h3><ul><li>What strategy is and why it's important</li><li>A framework for strategic development and management</li><li>Vision, values, goals and mission</li></ul><h3>Developing a winning strategy</h3><ul><li>The components of strategy</li><li>Sources of competitive advantage</li><li>Strategic analysis tools: PESTLE, Five Forces and SWOT analysis</li><li>Porter's generic strategies</li><li>The Strategy Clock</li><li>The Blue Ocean strategy framework</li></ul><h3>Putting strategy in to action - defining your business model</h3><ul><li>Defining your customer value proposition</li><li>Understanding the profit formula for your business</li><li>Building strategic capability</li></ul><h3>Managing strategic implementation and performance</h3><ul><li>Strategic management tools: strategy maps and balanced scorecard</li><li>Converting big goals in to SMART objectives</li><li>Identifying the key success factors for your industry</li><li>Selecting the right measures and setting targets</li><li>The role of budgeting in strategic management</li><li>Measuring and improving shareholder value</li><li>Monitoring and controlling strategic performance</li></ul><h3>Identifying and managing strategic threats</h3><ul><li>Analysing and managing risk</li><li>Testing and adapting your strategy</li><li>Learning from strategic failure: Kodak and Nokia</li><li>Understanding and dealing with business model disruption</li></ul>


                </section>

Strategy in a Day

<h2>Strategy in a Day: In-House</h2><p>Success in 21st century organisations is more dependent than ever on being able to convert long term vision and goals in to detailed operating plans and, even more critically, employing an effective strategic management framework to ensure successful execution.</p><p>Being able to think, plan and implement in a strategic way is becoming increasingly called upon in many more management roles. Our practical one-day expert workshop is designed for anyone wanting to develop the knowledge and skills required to take on a strategic role or management position.</p><h3>Learning objectives</h3><p>After completing this course Participants will be able to:</p><ul><li>Understand the purpose and key components of business strategy</li><li>Use an effective framework for developing and executing strategy</li><li>Apply powerful strategic analysis tools to inform strategy development</li><li>Evaluate strategic options using established frameworks for strategy formulation</li><li>Develop and apply a winning business model for their organisation</li><li>Use effective tools to manage and control strategy implementation</li><li>Identify some common causes of strategic failure</li></ul><section>
                    <h3>Basic principles</h3><ul><li>What strategy is and why it's important</li><li>A framework for strategic development and management</li><li>Vision, values, goals and mission</li></ul><h3>Developing a winning strategy</h3><ul><li>The components of strategy</li><li>Sources of competitive advantage</li><li>Strategic analysis tools: PESTLE, Five Forces and SWOT analysis</li><li>Porter's generic strategies</li><li>The Strategy Clock</li><li>The Blue Ocean strategy framework</li></ul><h3>Putting strategy in to action - defining your business model</h3><ul><li>Defining your customer value proposition</li><li>Understanding the profit formula for your business</li><li>Building strategic capability</li></ul><h3>Managing strategic implementation and performance</h3><ul><li>Strategic management tools: strategy maps and balanced scorecard</li><li>Converting big goals in to SMART objectives</li><li>Identifying the key success factors for your industry</li><li>Selecting the right measures and setting targets</li><li>The role of budgeting in strategic management</li><li>Measuring and improving shareholder value</li><li>Monitoring and controlling strategic performance</li></ul><h3>Identifying and managing strategic threats</h3><ul><li>Analysing and managing risk</li><li>Testing and adapting your strategy</li><li>Learning from strategic failure: Kodak and Nokia</li><li>Understanding and dealing with business model disruption</li></ul>


                </section>

Strategy in a Day: In-House

<p>Performance reviews and appraisals are an essential tool in managing staff and team performance effectively. This one-day workshop has been designed to help managers implement their organisation's performance appraisal system effectively. It focuses on how to prepare for appraisal meetings, how to get the most out of the meeting itself, and how to ensure that the appraisal informs and supports performance management on a day-to-day basis. Particular attention is paid to setting SMART objectives.</p><ul><li>UNDERSTAND THE BENEFITS OF PERFORMANCE APPRAISALS AND HOW THEY SUPPORT THE MANAGEMENT OF PERFORMANCE ON A DAY-TO-DAY BASIS</li><li>PREPARE AND CONDUCT POSITIVE AND MEANINGFUL PERFORMANCE APPRAISALS AND REVIEW MEETINGS - INCLUDING THE SETTING OF SMART OBJECTIVES</li><li>MONITOR AND MEASURE PERFORMANCE OBJECTIVELY AND CONSISTENTLY AGAINST DEFINED OBJECTIVES / TARGETS</li><li>IMPLEMENT THE ORGANISATION'S PERFORMANCE APPRAISAL SYSTEM IN A POSITIVE AND PROACTIVE WAY, WITH A FULL UNDERSTANDING AS TO HOW THEIR ROLE AS A MANAGER FITS INTO THE BIGGER PICTURE</li></ul><section>
                    <h3>1. Introduction</h3><ul><li>Programme objectives and benefits from attending</li><li>Participants' experience and confidence in this area</li><li>Personal objectives</li></ul><h3>2. Effective appraisals</h3><ul><li>Participants' experiences of conducting / receiving appraisals</li><li>What makes them successful or unsuccessful?</li><li>Purpose and benefits of appraisals</li><li>Appraisals and performance management</li></ul><h3>3. The process</h3><ul><li>Your performance appraisal system</li><li>The performance management cycle</li><li>Documenting the appraisal</li><li>Roles and responsibilities</li></ul><h3>4. Preparing for a performance appraisal</h3><ul><li>Preparing to hold a performance appraisal</li><li>Assessing performance and gathering evidence</li><li>Determining future objectives</li><li>Identifying development needs</li></ul><h3>5. The performance appraisal meeting</h3><ul><li>Structuring the meeting</li><li>Encouraging participation</li></ul><h3>6. Setting objectives</h3><ul><li>Goals, objectives and outcomes - what are they and why do we use them?</li><li>Start with the end in mind - what needs to be achieved and / or delivered and how will you know?</li><li>Making objectives SMART</li><li>Exercise - are these objectives SMART?</li><li>Practical tips - diagnostic questions to help set objectives, verbs to use, verbs to avoid, etc</li><li>Making SMART objectives even SMARTER</li></ul><h3>7. On-going review</h3><ul><li>Monitoring, measuring and reviewing performance</li><li>Providing support and effective feedback</li><li>Developing your staff to improve performance</li></ul><h3>8. And finally...</h3><ul><li>Open forum - remaining challenges and 'what if' scenarios</li><li>Action planning - identifying how participants will transfer this learning into the workplace and what else they may need which will help them to do this effectively</li><li>Review and close</li></ul>


                </section>

Performance Reviews and Appraisals

<p>No workplace investigation is easy, but those involving allegations of sexual harassment have the potential to be particularly difficult.</p>
<p>This one-day workshop is designed specifically to build on participants' existing investigative knowledge and skills in order to enable them to investigate allegations of sexual harassment appropriately.</p>
<p>The skills and processes learnt will ensure that participants are able to carry out robust investigations in line with both best practice and the law. Your organisation's policies and procedures will be referred to throughout the workshop as appropriate.</p><ul><li>HAVE A MUCH CLEARER IDEA AS TO WHAT CONSTITUTES SEXUAL HARASSMENT</li><li>APPRECIATE THE DIFFERENT FACTORS THAT MAY COMPLICATE THE SITUATION</li><li>UNDERSTAND THE LEGAL PROTECTION SPECIFIC TO SEXUAL HARASSMENT</li><li>RECOGNISE THE DIFFERENCES BETWEEN INVESTIGATIONS INTO SEXUAL HARASSMENT AND OTHER WORKPLACE INVESTIGATIONS</li><li>DEAL BETTER WITH CHALLENGING SITUATIONS, EMOTION AND DISTRESS</li><li>KNOW HOW TO ACCESS APPROPRIATE SUPPORT AND RESOURCES</li><li>BE ABLE TO MAKE APPROPRIATE RECOMMENDATIONS</li></ul><section>
                    <h3>1. Introduction</h3><ul><li>Workshop objectives and benefits from attending</li><li>Participants' experience and confidence in this area</li><li>Introductions and personal objectives</li></ul><h3>2. The context</h3><ul><li>Sexual harassment in the spotlight</li><li>Implications and risk for workplaces - the need to manage complaints robustly and take a preventative approach</li></ul><h3>3. Is this sexual harassment?</h3><ul><li>Quiz / scenarios</li><li>Differences in individual perception</li><li>Confusion in workplaces as to what constitutes sexual harassment</li><li>Factors which may affect an investigation</li></ul><h3>4. Defining sexual harassment and bullying</h3><ul><li>Group exercise</li><li>Definitions in law</li><li>Behaviours that constitute sexual harassment and bullying</li><li>Using your organisation's policies</li></ul><h3>5. Legal protection</h3><ul><li>Protection in law: employment and criminal matters</li><li>Duty of care</li><li>Equality Act 2010</li><li>Other statutes, eg, Protection from Harassment Act</li><li>Case law</li></ul><h3>6. Investigations into sexual harassment</h3><ul><li>Similarities and differences in approach to other workplace investigations</li><li>Impact and evidence</li><li>Investigating in line with internal policies and ACAS guidelines</li><li>Dealing with challenging situations, eg, emotion and distress</li><li>Managing yourself</li><li>Identifying support and resources</li></ul><h3>7. Recommendations</h3><ul><li>Communicating the outcome of the investigation and lessons learnt / corrective actions</li><li>Identifying and minimising risk factors</li><li>Encouraging a preventative approach: Making recommendations in line with best practice</li><li>A checklist of steps that all workplaces should implement</li></ul><h3>8. Challenging scenarios</h3><ul><li>Group work to consider approach in particularly challenging or sensitive 'what if ...' scenarios such as what happens when counter-allegations are made</li></ul><h3>9. And finally...</h3><ul><li>Open forum - remaining challenges and 'what if' scenarios</li><li>Action planning - identifying how participants will transfer this learning into the workplace and what else they may need which will help them to do this effectively</li><li>Review and close</li></ul>


                </section>

Investigating Sexual Harassment Allegations

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>The Power BI in a Day course is designed for beginners and intermediate users of Power BI.</p>Overview<p>#NAME?</p><p>Students will discover the full capabilities of Power BI in a one-day, hands-on workshop. Please Note: This workshop is primarily self-directed and students will work at their own pace while having access to an instructor for questions.</p></div><div id="course-pills-2"><h3>1 - Accessing &amp; Preparing data</h3> <ul> <li>Data Set</li> <li>Power BI Desktop</li> <li>Power BI Desktop ? Accessing Data</li> <li>Power BI Desktop ? Data Preparation</li> </ul> <h3>2 - Data Modeling and Exploration</h3> <ul> <li>Power BI Desktop ? Data Modeling and Exploration</li> <li>Power BI Desktop ? Data Exploration Continued</li> <li>References</li> </ul> <h3>3 - Data Visualization</h3> <ul> <li>Power BI Desktop</li> <li>Power BI Desktop ? Data Visualization</li> <li>References</li> </ul> <h3>4 - Publishing &amp; Accessing Reports</h3> <ul> <li>Power BI Desktop ? Creating Mobile View</li> <li>Power BI Service</li> <li>Power BI Service ? Publishing Report</li> <li>Power BI Mobile ? Accessing Report on Mobile Device</li> <li>Power BI Service ? Collaboration and Distribution</li> <li>References</li> </ul> <h3>5 - Dashboard and Collaboration</h3> <ul> <li>Power BI Service</li> <li>Building Dashboard</li> <li>References</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Power BI: Dashboard in a Day training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the Power BI: Dashboard in a Day 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.  <p></p>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.<p></p></div>

Nexus Human

Powerbi

Tableau Desktop Specialist

Business Analytics & Intelligence

Microsoft Power BI

Microsoft Power Platform

Microsoft BI

Power BI: Dashboard in a Day

General Admission

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Life is hectic. Finding time out feels almost impossible. We want to pray, we want to reflect, but when we do find a snatched moment to ourselves, we remain distracted.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">I&#39;ve designed this space to help you reconnect with your breath, to gently stretch your body, and to listen... to the voice of your inner wisdom, and to the voice of your Beloved.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We will meditate with scripture, we will journal, we will use creative means to listen to the Spirit.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We will sit with Love.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">I hope you will come away feeling centred, refreshed and assured of your belovedness.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;Two hours, on Zoom.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">"Come away with me to a quiet place"</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Past Participants are Saying:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">"<span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">A really well led session allowing time for reflection and prayer." - Ellie</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Mini-Retreats are hosted by Lissy Clarke, Spiritual Director, Yoga Teacher and the voice behind the meditations at Contemplative at Home.&nbsp;</em></p>

Life is hectic. Finding time out feels almost impossible. We want to pray, we want to reflect, but when we do find a snatched moment to ourselves, we remain distracted.
I've designed this space to help you reconnect with your breath, to gently stretch your body, and to listen... to the voice of your inner wisdom, and to the voice of your Beloved. 
We will meditate with scripture, we will journal, we will use creative means to listen to the Spirit.
We will sit with Love.
I hope you will come away feeling centred, refreshed and assured of your belovedness.
 Two hours, on Zoom.
"Come away with me to a quiet place"

The sessions will be shaped around the following themes this year:
October: Teresa of Avila
November: Letting Go
December: Advent / Expectant Hope
January: The Gifts of Winter Darkness
February: Love
March: Lent
April: No Session
May: Resurrection / Spring
June: TBC

July: The Gifts of Summer

August: No Session


You are invited to participate from the comfort of your own home. Ideally you'll be able to find a little space where you won't be interrupted. You might wish to ask those you share space with to help you protect this time by respecting your privacy.
All who sign up will be sent a link to the recording of the retreat which will remain live until the following session. If you would like to participate via recording, simply register for the event. It would be great if you could let me know that you won't be with us in real time.

Past Participants are Saying:


"A really well led session allowing time for reflection and prayer." - Ellie


Virtual Mini-Retreats are hosted by Lissy Clarke, Spiritual Director, Yoga Teacher and the voice behind the meditations at Contemplative at Home. 

NB: Virtual Mini-Retreats are FREE for members who support the show at £15/ month and above (thank you!! ✨) - but you must still register to secure a place on a particular date, as places are limited. Memberships can be started or stopped at any time. More information here.

Contemplative at Home

Virtual Mini-Retreats

Suggested Donation

Elevate your auditing expertise and lead the way in quality management with our ISO 9001:2015 Lead Auditor course, certified by CQI and IRCA. This comprehensive program is designed for professionals seeking to conduct first, second, and third-party audits of Quality Management Systems (QMS) against the ISO 9001:2015 standard.
Our course provides in-depth training on the principles and practices of auditing, equipping you with the knowledge and skills to effectively lead audit teams and assess the conformance and effectiveness of QMS in organizations. You will learn how to plan, conduct, report, and follow up on audits in compliance with ISO 19011 guidelines and ISO/IEC 17021 standards.
Key Features of the Course:
Certified Expertise: Achieve a globally recognized certification from CQI and IRCA, enhancing your professional credibility and career prospects.
Experienced Instructors: Learn from industry experts with extensive experience in quality management and auditing, who provide real-world insights and practical guidance.
Interactive Learning: Engage in hands-on exercises, case studies, and role-play scenarios that simulate real auditing situations, ensuring that you can apply what you learn directly to your work.
Comprehensive Curriculum: Cover all aspects of the ISO 9001:2015 standard, audit principles, and techniques, as well as risk-based thinking and the process approach.
Career Advancement: This course is ideal for those aspiring to become lead auditors, quality managers, or consultants, offering a pathway to new opportunities and enhanced professional status.
Upon successful completion of the course and examination, you will be awarded the prestigious CQI and IRCA certification, recognized globally as a mark of excellence in auditing. This certification will enable you to conduct audits for certification bodies and help organizations achieve compliance and continual improvement.
Enroll in our ISO 9001:2015 Lead Auditor course today and take the next step in your journey to becoming a leader in quality management.

QUALITY ACADEMY

Quality Management System

ISO 9001

Quality Management

Quality Assurance

Quality Auditor

Become a certified ISO 9001:2015 Lead Auditor with our CQI and IRCA accredited course. Gain the skills to lead quality management audits and enhance your career. Enroll now!

ISO 9001:2015 Lead Auditor (CQI and IRCA Certified)

<div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);">Aims:&nbsp;</strong>To develop the exercise professional&rsquo;s understanding of mental health conditions and the benefits of activity and positive lifestyle behaviours.</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);">Outcome:</strong>&nbsp;You will be able to plan, deliver, and evaluate activity sessions in the community and/or clinical settings with clients with a range of mental health conditions.</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(235, 92, 35);">Qualification Structure:</strong></span></p><ol start="1" type="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learners will cover:</span><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Key mental health conditions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The relationships between mental health, society and lifestyle</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Legislation and government policy relating to mental health</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The role of national organisations relating to mental health</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Roles and boundaries of the people involved in programming physical activity for individuals with mental health conditions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to motivate and support individuals with mental health conditions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to evaluate the usefulness of a range of resources of information on mental health and its relationship to physical activity</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to evaluate the effectiveness of a range of mental health interventions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to program physical activity for individuals with mental health conditions How to deliver physical activity programmes to individuals with mental health conditions</li></ul></ol><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(235, 92, 35);">Entry Requirements:</strong></span></div><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">We recommend you hold an Exercise Referral Qualification</span></div><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></div><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);">Assessments:</strong></span></div><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Theory paper</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Research worksheet</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Analysis task</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Knowledge questions</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Programme design</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Programme delivery</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Professional discussion (programme delivery)</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Evaluation of programme delivery</p></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></div>

Aims: To develop the exercise professional’s understanding of mental health conditions and the benefits of activity and positive lifestyle behaviours.
Outcome: You will be able to plan, deliver, and evaluate activity sessions in the community and/or clinical settings with clients with a range of mental health conditions.
Qualification Structure:
Learners will cover:
Key mental health conditions
The relationships between mental health, society and lifestyle
Legislation and government policy relating to mental health
The role of national organisations relating to mental health
Roles and boundaries of the people involved in programming physical activity for individuals with mental health conditions
How to motivate and support individuals with mental health conditions
How to evaluate the usefulness of a range of resources of information on mental health and its relationship to physical activity
How to evaluate the effectiveness of a range of mental health interventions
How to program physical activity for individuals with mental health conditions How to deliver physical activity programmes to individuals with mental health conditions
Entry Requirements:We recommend you hold an Exercise Referral QualificationAssessments:
Theory paper
Research worksheet
Analysis task
Knowledge questions
Programme design
Programme delivery
Professional discussion (programme delivery)
Evaluation of programme delivery

Platinum Training Institute

Physical Activity

Health

Mental Health

Aims: To develop the exercise professional’s understanding of mental health conditions and the benefits of activity and positive lifestyle behaviours.

Outcome: You will be able to plan, deliver, and evaluate activity sessions in the community and/or clinical settings with clients with a range of mental health conditions.

YMCA Level 4 Certificate in Delivering Physical Activity for Individuals with Mental Health Conditions

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The primary audience for this course is any IT, facilities or data centre professional, who are involved in the design/build, renovation or relocation of a mission-critical data centre.</p>Overview<p>This 5-day course is designed to prepare participants to analyse a given business case and perform technical evaluation for a project plan and a set of designs for the implementation of a mission critical data centre.<br />The course also engages participants in product evaluations and demonstrates how to select equipment and develop equipment test scripts (IET) and integrated performance and validation testing (IPVT). CDCEÂ© builds upon knowledge gained in CDCP and CDCS courses. Participants who pass the exam will join the industry's elite data centre project design experts.<br />CDCEÂ© is the highest level training in the EPI Design and Build training track under the EPI Data Centre Training Framework. Participants must hold a valid CDCS certificate in order to be able to register for the CDCE class.</p><p>CDCEÂ© is the premier certification for data centre professionals in the data centre design/build and related fields.</p></div><div id="course-pills-2"><h4>Data Centre Life Cycle</h4><ul><li>Data centre lifecycle stages and phases<br />Exercise: Stage/Phase/Milestone/Document mapping</li></ul><h4>Design Preparation</h4><ul><li>Creation of a SON ? Statement Of Need<br />Technology review<br />Conceptual sizing<br />How to calculate for computer room space<br />How to calculate facility space<br />How to calculate incoming power<br />Exercise: Conceptual sizing building and power<br />Analysing capacity of existing facility<br />Analysing investment options<br />Site selection<br />Permits and approvals<br />Exercise: Site selection<br />Conceptual design<br />Budget and project timeline<br />Business case preparation<br />Project delivery structure<br />Project management options<br />Project manager and team</li></ul><h4>Design Planning</h4><ul><li>OSRA?Operational Systems Requirement Analysis<br />TFRA?Technical Facilities Requirement Analysis<br />Operations and maintenance review<br />RFP?Request For Proposal process<br />Vendor selection</li></ul><h4>Design Development</h4><ul><li>Project planning<br />Design development<br />PDR ? Preliminary Design Review<br />Equipment selection<br />FDR/V ? Final Design Review/Validation<br />Exercise: Full design validation of power, cooling, floor plans, fire suppression<br />Design freeze and LLTI<br />Creation of construction documents<br />BOM/BOQ ? Bill Of Material/Bill Of Quantity<br />Exercise: Equipment selection</li></ul><h4>Acquire</h4><ul><li>Requirements of purchase orders<br />Shipping terms<br />FWT/FAT ? Factory Witness Test/Factory Acceptance Test<br />Sequencing<br />Incoming goods inspection and handling<br />Asset management</li></ul><h4>Construct</h4><ul><li>Temporary essential services<br />Erection of the building<br />Permanent essential services<br />Building inspection<br />Snag list<br />COF?Certificate Of Fitness</li></ul><h4>Fit-Out</h4><ul><li>Fit-Out<br />Builders cleaning<br />As-Built Drawings</li></ul><h4>Test &amp; Commissioning</h4><ul><li>IET?Individual Equipment Test<br />IPVT/IST?Integrated Performance Verification Test/Integrated Systems Test<br />Common mistakes with IET/IPVT<br />Deep cleaning<br />Exercise: IET/IPVT scripting</li></ul><h4>Hand-Over</h4><ul><li>Facility hand-over requirements and documents<br />PCC?Practical Completion Certificate<br />DLP?Defect Liability Period<br />Defect Management<br />ICT Systems Installation<br />ICT Systems Testing<br />Hand-Over/DLP Expiry<br />FCC?Final Completion Certificate</li></ul><h4>Retirement</h4><ul><li>Reasons and definitions of retirement<br />Building the business case and project plan<br />Sequencing<br />Transfer of site<br />Demolishing of site<br />Legal matters<br />FCC?Final Completion Certificate</li></ul><h4>Exam: Certified Data Centre Expert (CDCEÂ©)</h4><ul><li>The CDCEÂ© exam is in two parts: Part A is a 90-minute closed book exam, with 60 multiple-choice questions. For Part A, the candidate requires a minimum of 45 correct answers to pass the exam. Part B is a 90-minute closed book exam, with 25 open questions. For Part B the candidate needs to obtain a minimum of 75% to pass.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Certified Data Centre Expert (CDCE) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the Certified Data Centre Expert (CDCE) 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.  <p></p>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.<p></p></div>

Certified in Cybersecurity (CC)

IT Certifications

Construction Design & Management (CDM)

Cisco Certified Internetwork Expert (CCIE)

Certified in Data Protection (CDP)

Certified Cyber Professional (CCP)

Certified Data Centre Expert (CDCE)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is targeted toward an IT Professional that has the technical knowledge and skills required to conceptualize, design, and engineer secure solutions across complex enterprise environments. Students should have a minimum of 10 years experience including at least 5 years of hands-on technical security experience.</p>Overview<p>Upon successful completion of this course, students will be able to:  Identify enterprise security fundamentals.  Apply enterprise security technology solutions.  Implement security design and solutions.  Manage risk, policies and procedures within an enterprise.  Integrate security solutions within an enterprise.  Conduct security research and analysis.</p><p>In this course, students will examine advanced security concepts, principles, and implementations that pertain to enterprise level security.</p>Prerequisites<p></p><ul><li>CompTIA Cybersecurity Analyst (CySA+) Certification</li></ul><p></p></div><div id="course-pills-2"><h3>1 - Enterprise Security Architecture</h3> <ul> <li>The Basics of Enterprise Security</li> <li>The Enterprise Structure</li> <li>Enterprise Security Requirements</li> </ul> <h3>2 - Enterprise Security Technology</h3> <ul> <li>Common Network Security Components and Technologies</li> <li>Communications and Collaboration Security</li> <li>Cryptographic Tools and Techniques</li> <li>Advanced Authentication</li> </ul> <h3>3 - Enterprise Resource Technology</h3> <ul> <li>Enterprise Storage Security Issues</li> <li>Distributed, Shared, and Virtualized Computing</li> <li>Cloud Computing and Security</li> </ul> <h3>4 - Security Design and Solutions</h3> <ul> <li>Network Security Design</li> <li>Conduct a Security Assessment</li> <li>Host Security</li> </ul> <h3>5 - Application Security Design</h3> <ul> <li>Application Security Basics</li> <li>Web Application Security</li> </ul> <h3>6 - Managing Risk, Security Policies, and Security Procedures</h3> <ul> <li>Analyze Security Risk</li> <li>Implement Risk Mitigation Strategies and Controls</li> <li>Implement Enterprise-Level Security Policies and Procedures</li> <li>Prepare for Incident Response and Recovery</li> </ul> <h3>7 - Enterprise Security Integration</h3> <ul> <li>The Technology Life Cycle</li> <li>Inter-Organizational Change</li> <li>Integrate Enterprise Disciplines to Achieve Secure Solutions</li> </ul> <h3>8 - Security Research and Analysis</h3> <ul> <li>Perform an Industry Trends and Impact Analysis</li> <li>Perform an Enterprise Security Analysis</li> </ul></div>

Certificate in Information Security Management Principles (CISMP)

Certified Cloud Security Professional (CCSP)

ASIS Certified Protection Professional (CPP)

Cissp

CompTIA Security+

CompTIA Advanced Security Practitioner (CASP+)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills.</p>Overview<p>Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries</p><p>This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.</p>Prerequisites<p></p><ul> <li>Basic understanding of relational databases.</li> <li>Basic Windows knowledge.</li> </ul><p></p></div><div id="course-pills-2"><h3>Module 1: Introduction to Transact-SQL</h3><ul> <li>What is Transact-SQL</li> <li>The SELECT statement</li> <li>The WHERE clause</li> <li>Sorting results</li> <li>Calculations</li> <li>CASE expressions</li> </ul>   <h3>Module 2: Joining tables with Transact-SQL</h3><ul> <li>The JOIN clause</li> <li>Inner joins</li> <li>Outer joins</li> <li>Self joins and cross joins</li> </ul>  <h3>Module 3: Filtering and sorting results</h3><ul> <li>Implement the ORDER BY clause</li> <li>Filter data with the WHERE clause</li> <li>Limit the number of rows returned by a query</li> <li>Implement NULL logic</li> </ul>  <h3>Module 4: SQL Server data types</h3><ul> <li>Understand data types</li> <li>Implement string data types</li> <li>Implement temporal data types</li> </ul>  <h3>Module 5: Inserting, updating and deleting data</h3><ul> <li>Insert new records</li> <li>Update existing records</li> <li>Delete data</li> </ul>   <h3>Module 6: Using SQL Server functions with Transact-SQL</h3><ul> <li>Understand function types in SQL Server</li> <li>Convert data using functions</li> <li>Implement logical functions</li> <li>Work with NULL data using functions</li> </ul>  <h3>Module 7: Aggregating data with Transact-SQL</h3><ul> <li>Implement aggregation in SQL Server</li> <li>Group records in SQL Server</li> <li>Filter aggregated data</li> </ul>   <h3>Module 8: Implement subqueries with Transact-SQL</h3><ul> <li>Implement scalar and multi-valued sub-queries</li> <li>Implement correlated subqueries</li> <li>Implement existence checks with subqueries</li> </ul>   <h3>Module 9: Create queries that use table expressions</h3><ul> <li>Create views</li> <li>Create table-valued functions</li> <li>Implement derived tables</li> <li>Implement common table expressions</li> </ul>  <h3>Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data</h3><ul> <li>Write queries with the UNION operator</li> <li>Write queries with the INTERSECT and EXCEPT operators</li> <li>Write queries with the APPLY operator</li> </ul>    <h3>Module 11: Implement window functions in queries</h3><ul> <li>Understand window functions</li> <li>Impement window functions</li> </ul>    <h3>Module 12: Use PIVOT and grouping sets in queries</h3><ul> <li>Implement PIVOT in queries</li> <li>Implement grouping sets in queries</li> </ul>   <h3>Module 13: Use stored procedures in queries</h3><ul> <li>Query data with stored procedures</li> <li>Interact with stored procedures using input and output parameters</li> <li>Write simple stored procedures</li> <li>Pass dynamic SQL to SQL Server</li> </ul>    <h3>Module 14: Implement programming features in Transact-SQL</h3><ul> <li>Understand T-SQL programming elements</li> <li>Implement loops and conditions in T-SQL queries</li> </ul>   <h3>Module 15: Add error handling to queries</h3><ul> <li>Understand SQL Server error handling</li> <li>Implemet structured exception handling</li> </ul>   <h3>Module 16: Use transactions in queries</h3><ul> <li>Understand database transactions</li> <li>Implement transactions in T-SQL</li> </ul></div>

Computing Skills

Microsoft SQL

Data Skills

SQL Server

Trainers Course

55366 Querying Data with Transact-SQL

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is designed for IT professionals who wish to develop cloud computing skills to enable them to move IT workloads to the cloud and integrate products and services from different providers and industries. Their focus is to ensure that cloud deployments are secure, that automation and orchestration are used effectively to bring business value from the cloud, and that costs are controlled through effective management of cloud vendors.   This course is also designed for students who are preparing to take the CompTIA Cloud+ certification exam CV0-003, or who plan to use Cloud+ as the foundation for more advanced cloud certifications or career roles.</p>Overview<p>In this course, you will deploy, test, secure, manage, optimize, and troubleshoot a cloud solution.   You will:  - Prepare to deploy cloud solutions  - Deploy a pilot project  - Test a pilot project deployment  - Design a secure network for cloud deployment  - Determine CPU and memory sizing for cloud deployments  - Determine storage requirements for cloud deployments  - Plan Identity and Access Management for cloud deployments  - Analyze workload characteristics to ensure successful migration to the cloud  - Secure systems to meet access requirements  - Maintain cloud systems  - Implement backup, restore, and business continuity measures  - Analyze cloud systems for required performance  - Analyze cloud systems for anomalies and growth forecasting  - Troubleshoot deployment, capacity, automation, and orchestration issues  - Troubleshoot connectivity issues  - Troubleshoot security issues</p><p>In this course, you will learn how to implement, maintain, and deliver cloud technologies including network, storage, and virtualization technologies to create cloud solutions.</p></div><div id="course-pills-2"><h3>1 - PREPARING TO DEPLOY CLOUD SOLUTIONS</h3> <ul> <li>Describe Interaction of Cloud Components and Services</li> <li>Describe Interaction of Non-cloud Components and Services</li> <li>Evaluate Existing Components and Services for Cloud Deployment</li> <li>Evaluate Automation and Orchestration Options</li> <li>Prepare for Cloud Deployment</li> </ul> <h3>2 - DEPLOYING A PILOT PROJECT</h3> <ul> <li>Manage Change in a Pilot Project</li> <li>Execute Cloud Deployment Workflow</li> <li>Complete Post-Deployment Configuration</li> </ul> <h3>3 - TESTING PILOT PROJECT DEPLOYMENTS</h3> <ul> <li>Identify Cloud Service Components for Testing</li> <li>Test for High Availability and Accessibility</li> <li>Perform Deployment Load Testing</li> <li>Analyze Test Results</li> </ul> <h3>4 - DESIGNING A SECURE AND COMPLIANT CLOUD INFRASTRUCTURE</h3> <ul> <li>Design Cloud Infrastructure for Security</li> <li>Determine Organizational Compliance Needs</li> </ul> <h3>5 - DESIGNING AND IMPLEMENTING A SECURE CLOUD ENVIRONMENT</h3> <ul> <li>Design Virtual Network for Cloud Deployment</li> <li>Determine Network Access Requirements</li> <li>Secure Networks for Cloud Interaction</li> <li>Manage Cloud Component Security</li> <li>Implement Security Technologies</li> </ul> <h3>6 - PLANNING IDENTITY AND ACCESS MANAGEMENT FOR CLOUD DEPLOYMENTS</h3> <ul> <li>Determine Identity Management and Authentication Technologies</li> <li>Plan Account Management Policies for the Network and Systems</li> <li>Control Access to Cloud Objects</li> <li>Provision Accounts</li> </ul> <h3>7 - DETERMINING CPU AND MEMORY SIZING FOR CLOUD DEPLOYMENTS</h3> <ul> <li>Determine CPU Size for Cloud Deployment</li> <li>Determine Memory Size for Cloud Deployment</li> </ul> <h3>8 - DETERMINING STORAGE REQUIREMENTS FOR CLOUD DEPLOYMENTS</h3> <ul> <li>Determine Storage Technology Requirements</li> <li>Select Storage Options for Deployment</li> <li>Determine Storage Access and Provisioning Requirements</li> <li>Determine Storage Security Options</li> </ul> <h3>9 - ANALYZING WORKLOAD CHARACTERISTICS TO ENSURE SUCCESSFUL MIGRATION</h3> <ul> <li>Determine the Type of Cloud Deployment to Perform</li> <li>Manage Virtual Machine and Container Migration</li> <li>Manage Network, Storage, and Data Migration</li> </ul> <h3>10 - MAINTAINING CLOUD SYSTEMS</h3> <ul> <li>Patch Cloud Systems</li> <li>Design and Implement Automation and Orchestration for Maintenance</li> </ul> <h3>11 - IMPLEMENTING BACKUP, RESTORE, DISASTER RECOVERY, AND BUSINESS CONTINUITY MEASURES</h3> <ul> <li>Back Up and Restore Cloud Data</li> <li>Implement Disaster Recovery Plans</li> <li>Implement Business Continuity Plans</li> </ul> <h3>12 - ANALYZING CLOUD SYSTEMS FOR PERFORMANCE</h3> <ul> <li>Monitor Cloud Systems to Measure Performance</li> <li>Optimize Cloud Systems to Meet Performance Criteria</li> </ul> <h3>13 - ANALYZING CLOUD SYSTEMS FOR ANOMALIES AND GROWTH FORECASTING</h3> <ul> <li>Monitor for Anomalies and Resource Needs</li> <li>Plan for Capacity</li> <li>Create Reports on Cloud System Metrics</li> </ul> <h3>14 - TROUBLESHOOTING DEPLOYMENT, CAPACITY, AUTOMATION, AND ORCHESTRATION ISSUES</h3> <ul> <li>Troubleshoot Deployment Issues</li> <li>Troubleshoot Capacity Issues</li> <li>Troubleshoot Automation and Orchestration Issues</li> </ul> <h3>15 - TROUBLESHOOTING CONNECTIVITY ISSUES</h3> <ul> <li>Identify Connectivity Issues</li> <li>Troubleshoot Connectivity Issues</li> </ul> <h3>16 - TROUBLESHOOTING SECURITY ISSUES</h3> <ul> <li>Troubleshoot Identity and Access Issues</li> <li>Troubleshoot Attacks</li> <li>Troubleshoot Other Security Issues</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CompTIA Cloud Plus Certification (Exam CV0-003) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the CompTIA Cloud Plus Certification (Exam CV0-003) 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.  <p></p>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.<p></p></div>

CompTIA Network+

Cloud Architecture

AWS Certified Cloud Practitioner

CompTIA A+

CompTIA Cloud+

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>The Microsoft 365 Endpoint Administrator is responsible for deploying, configuring, securing, managing, and monitoring devices and client applications in a corporate setting. Their duties include managing identity, access, policies, updates, and apps. They work alongside the M365 Enterprise Administrator to develop and execute a device strategy that aligns with the requirements of a modern organization. Microsoft 365 Endpoint Administrators should be well-versed in M365 workloads and possess extensive skills and experience in deploying, configuring, and maintaining Windows 11 and later, as well as non-Windows devices. Their role emphasizes cloud services over on-premises management technologies.</p><p></p><p></p><p>In this course, students will learn to plan and execute an endpoint deployment strategy using contemporary deployment techniques and implementing update strategies. The course introduces essential elements of modern management, co-management approaches, and Microsoft Intune integration. It covers app deployment, management of browser-based applications, and key security concepts such as authentication, identities, access, and compliance policies. Technologies like Microsoft Entra ID, Azure Information Protection, and Microsoft Defender for Endpoint are explored to protect devices and data.</p><p></p>Prerequisites<p>The Modern Desktop Administrator must be familiar with M365 workloads and must have strong skills and experience of deploying, configuring, and maintaining Windows 11 and later, and non-Windows devices.</p></div><div id="course-pills-2"><h3>1 - Explore the Enterprise Desktop</h3> <ul> <li>Examine benefits of modern management</li> <li>Examine the enterprise desktop life-cycle model</li> <li>Examine planning and purchasing</li> <li>Examine desktop deployment</li> <li>Plan an application deployment</li> <li>Plan for upgrades and retirement</li> </ul> <h3>2 - Explore Windows Editions</h3> <ul> <li>Examine Windows client editions and capabilities</li> <li>Select client edition</li> <li>Examine hardware requirements</li> </ul> <h3>3 - Understand Microsoft Entra ID</h3> <ul> <li>Examine Microsoft Entra ID</li> <li>Compare Microsoft Entra ID and Active Directory Domain Services</li> <li>Examine Microsoft Entra ID as a directory service for cloud apps</li> <li>Compare Microsoft Entra ID P1 and P2 plans</li> <li>Examine Microsoft Entra Domain Services</li> </ul> <h3>4 - Manage Microsoft Entra identities</h3> <ul> <li>Examine RBAC and user roles in Microsoft Entra ID</li> <li>Create and manage users in Microsoft Entra ID</li> <li>Create and manage groups in Microsoft Entra ID</li> <li>Manage Microsoft Entra objects with PowerShell</li> <li>Synchronize objects from AD DS to Microsoft Entra ID</li> </ul> <h3>5 - Manage device authentication</h3> <ul> <li>Describe Microsoft Entra join </li> <li>Examine Microsoft Entra join prerequisites limitations and benefits</li> <li>Join devices to Microsoft Entra ID</li> <li>Manage devices joined to Microsoft Entra ID</li> </ul> <h3>6 - Enroll devices using Microsoft Configuration Manager</h3> <ul> <li>Deploy the Microsoft Configuration Manager client</li> <li>Monitor the Microsoft Configuration Manager client</li> <li>Manage the Microsoft Configuration Manager client</li> </ul> <h3>7 - Enroll devices using Microsoft Intune</h3> <ul> <li>Manage mobile devices with Intune</li> <li>Enable mobile device management</li> <li>Explain considerations for device enrollment</li> <li>Manage corporate enrollment policy</li> <li>Enroll Windows devices in Intune</li> <li>Enroll Android devices in Intune</li> <li>Enroll iOS devices in Intune</li> <li>Explore device enrollment manager</li> <li>Monitor device enrollment</li> <li>Manage devices remotely</li> </ul> <h3>8 - Execute device profiles</h3> <ul> <li>Explore Intune device profiles</li> <li>Create device profiles</li> <li>Create a custom device profile</li> </ul> <h3>9 - Oversee device profiles</h3> <ul> <li>Monitor device profiles in Intune</li> <li>Manage device sync in Intune</li> <li>Manage devices in Intune using scripts</li> </ul> <h3>10 - Maintain user profiles</h3> <ul> <li>Examine user profile</li> <li>Explore user profile types</li> <li>Examine options for minimizing user profile size</li> <li>Deploy and configure folder redirection</li> <li>Sync user state with Enterprise State Roaming</li> <li>Configure Enterprise State Roaming in Azure</li> </ul> <h3>11 - Execute mobile application management</h3> <ul> <li>Examine mobile application management</li> <li>Examine considerations for mobile application management</li> <li>Prepare line-of-business apps for app protection policies</li> <li>Implement mobile application management policies in Intune</li> <li>Manage mobile application management policies in Intune</li> </ul> <h3>12 - Deploy and update applications</h3> <ul> <li>Deploy applications with Intune</li> <li>Add apps to Intune</li> <li>Manage Win32 apps with Intune</li> <li>Deploy applications with Configuration Manager</li> <li>Deploying applications with Group Policy</li> <li>Assign and publish software</li> <li>Explore Microsoft Store for Business</li> <li>Implement Microsoft Store Apps</li> <li>Update Microsoft Store Apps with Intune</li> <li>Assign apps to company employees</li> </ul> <h3>13 - Administer endpoint applications</h3> <ul> <li>Manage apps with Intune</li> <li>Manage Apps on non-enrolled devices</li> <li>Deploy Microsoft 365 Apps with Intune</li> <li>Additional Microsoft 365 Apps Deployment Tools</li> <li>Configure Microsoft Edge Internet Explorer mode</li> <li>App Inventory Review</li> </ul> <h3>14 - Protect identities in Microsoft Entra ID</h3> <ul> <li>Explore Windows Hello for Business</li> <li>Deploy Windows Hello</li> <li>Manage Windows Hello for Business</li> <li>Explore Microsoft Entra ID Protection</li> <li>Manage self-service password reset in Microsoft Entra ID</li> <li>Implement multi-factor authentication</li> </ul> <h3>15 - Enable organizational access</h3> <ul> <li>Enable access to organization resources</li> <li>Explore VPN types and configuration</li> <li>Explore Always On VPN</li> <li>Deploy Always On VPN</li> </ul> <h3>16 - Implement device compliance</h3> <ul> <li>Protect access to resources using Intune</li> <li>Explore device compliance policy</li> <li>Deploy a device compliance policy</li> <li>Explore conditional access</li> <li>Create conditional access policies</li> </ul> <h3>17 - Generate inventory and compliance reports</h3> <ul> <li>Report enrolled devices inventory in Intune</li> <li>Monitor and report device compliance</li> <li>Build custom Intune inventory reports</li> <li>Access Intune using Microsoft Graph API</li> </ul> <h3>18 - Deploy device data protection</h3> <ul> <li>Explore Windows Information Protection</li> <li>Plan Windows Information Protection</li> <li>Implement and use Windows Information Protection</li> <li>Explore Encrypting File System in Windows client</li> <li>Explore BitLocker</li> </ul> <h3>19 - Manage Microsoft Defender for Endpoint</h3> <ul> <li>Explore Microsoft Defender for Endpoint</li> <li>Examine key capabilities of Microsoft Defender for Endpoint</li> <li>Explore Windows Defender Application Control and Device Guard</li> <li>Explore Microsoft Defender Application Guard</li> <li>Examine Windows Defender Exploit Guard</li> <li>Explore Windows Defender System Guard</li> </ul> <h3>20 - Manage Microsoft Defender in Windows client</h3> <ul> <li>Explore Windows Security Center</li> <li>Explore Windows Defender Credential Guard</li> <li>Manage Microsoft Defender Antivirus</li> <li>Manage Windows Defender Firewall</li> <li>Explore Windows Defender Firewall with Advanced Security</li> </ul> <h3>21 - Manage Microsoft Defender for Cloud Apps</h3> <ul> <li>Explore Microsoft Defender for Cloud Apps</li> <li>Planning Microsoft Defender for Cloud Apps</li> <li>Implement Microsoft Defender for Cloud Apps</li> </ul> <h3>22 - Assess deployment readiness</h3> <ul> <li>Examine deployment guidelines</li> <li>Explore readiness tools</li> <li>Assess application compatibility</li> <li>Explore tools for application compatibility mitigation</li> <li>Prepare network and directory for deployment</li> <li>Plan a pilot</li> </ul> <h3>23 - Deploy using the Microsoft Deployment Toolkit</h3> <ul> <li>Evaluate traditional deployment methods</li> <li>Set up the Microsoft Deployment Toolkit for client deployment</li> <li>Manage and deploy images using the Microsoft Deployment Toolkit</li> </ul> <h3>24 - Deploy using Microsoft Configuration Manager</h3> <ul> <li>Explore client deployment using Configuration Manager</li> <li>Examine deployment components of Configuration Manager</li> <li>Manage client deployment using Configuration Manager</li> <li>Plan in-place upgrades using Configuration Manager</li> </ul> <h3>25 - Deploy Devices using Windows Autopilot</h3> <ul> <li>Use Autopilot for modern deployment</li> <li>Examine requirements for Windows Autopilot</li> <li>Prepare device IDs for Autopilot</li> <li>Implement device registration and out-of-the-box customization</li> <li>Examine Autopilot scenarios</li> <li>Troubleshoot Windows Autopilot</li> </ul> <h3>26 - Implement dynamic deployment methods</h3> <ul> <li>Examine subscription activation</li> <li>Deploy using provisioning packages</li> <li>Use Windows Configuration Designer</li> <li>Use Microsoft Entra join with automatic MDM enrollment</li> </ul> <h3>27 - Plan a transition to modern endpoint management</h3> <ul> <li>Explore using co-management to transition to modern endpoint management</li> <li>Examine prerequisites for co-management</li> <li>Evaluate modern management considerations</li> <li>Evaluate upgrades and migrations in modern transitioning</li> <li>Migrate data when modern transitioning</li> <li>Migrate workloads when modern transitioning</li> </ul> <h3>28 - Manage Windows 365</h3> <ul> <li>Explore Windows 365</li> <li>Configure Windows 365</li> <li>Administer Windows 365</li> </ul> <h3>29 - Manage Azure Virtual Desktop</h3> <ul> <li>Examine Azure Virtual Desktop</li> <li>Explore Azure Virtual Desktop</li> <li>Configure Azure Virtual Desktop</li> <li>Administer Azure Virtual Desktop</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans MD-102T00 : Microsoft 365 Endpoint Administrator training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the MD-102T00 : Microsoft 365 Endpoint Administrator 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.  <p></p>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.<p></p></div>

840 Design courses in Cardiff

Mental Health Awareness in the Workplace

By Maximum Performance

Coaching Skills in a Day!

By Maximum Performance

Mediation Mindsets and Skills: In-House

By Maximum Performance

Mediation Mindsets and Skills

By Maximum Performance

Influencing and Negotiating

By Maximum Performance

Influencing and Negotiating: In-House

By Maximum Performance

Strategy in a Day

By Maximum Performance

Strategy in a Day: In-House

By Maximum Performance

Performance Reviews and Appraisals

By Maximum Performance

Investigating Sexual Harassment Allegations

By Maximum Performance

Search By Location