Name: Job-Ready SQL in an Afternoon
Price: 82.99 GBP
Availability: InStock

<h2>Description</h2><p><span><strong>Strategic Planning For Business Diploma</strong></span></p><p><span>Welcome to the Strategic Planning for Business Diploma course. An online course meticulously curated for aspirants seeking to lead their businesses with a robust strategic approach. This exceptional course emphasises the art of strategic planning and its vital importance in achieving a company's growth and success.</span></p><p><span>Strategic planning is the cornerstone of every thriving business. It maps out the direction of the company and provides an invaluable framework to guide the decisions and actions that shape its destiny. Through this course, the Strategic Planning for Business Diploma, you will delve into the intricacies of strategic planning, learning to formulate a comprehensive and efficient plan that helps your organisation stay ahead in a dynamic business environment.</span></p><p><span>This online course takes you on an enriching journey, beginning with the understanding of what strategic planning truly signifies and why it holds such colossal importance in today's fast-paced business world. As you progress through the course, you will get hands-on experience in setting up a strategic plan. This vital skill will be your stepping stone into the world of strategic planning, assisting you in mapping the route to success.</span></p><p><span>An integral part of strategic planning is the review and evaluation process. Our course takes a deep dive into these aspects, enabling you to scrutinise plans and outcomes, making crucial amendments when necessary to ensure your strategies yield the desired results.</span></p><p><span>The course, Strategic Planning for Business Diploma, also places significant emphasis on defining a company's vision, mission, and values. You will learn to outline the fundamental principles that underpin your company's identity, providing a clear direction for all decision-making and strategic planning efforts.</span></p><p><span>Understanding your company's position is equally essential. This course will equip you with the knowledge to assess the company's standing, analysing strengths, weaknesses, opportunities and threats to develop effective strategies.</span></p><p><span>In an ever-evolving business landscape, growth is the key to survival. Our course helps you strategise your company's growth, focusing on strategic priorities and successfully integrating them into your plan. This ensures that your company stays relevant, competitive, and prosperous.</span></p><p><span>Putting the plan together is the next crucial stage. The Strategic Planning for Business Diploma provides comprehensive training to help you compile an actionable, realistic, and effective strategic plan. This step encapsulates everything learned so far, offering a holistic view of the strategic planning process.</span></p><p><span>Moreover, the course also caters to department managers and entrepreneurs, offering them tailor-made guidance. The Strategic Planning for Business Diploma teaches them the art of efficient strategic planning, helping them steer their departments or businesses towards the pinnacle of success.</span></p><p><span>Lastly, but importantly, the course focuses on maintaining strategic planning efficiency. It lays down effective methodologies to keep the planning process smooth, ensuring strategies stay in tune with the evolving business landscape and continue delivering maximum benefits.</span></p><p><span>In conclusion, the Strategic Planning for Business Diploma course is a comprehensive online programme designed for anyone seeking to revolutionise their strategic approach to business. With its balanced focus on theory and practical application, this course equips you with the tools and knowledge necessary to drive your company's success. The skills you will acquire from this course can change your professional trajectory, leading you to the vanguard of strategic planning. Enrol now and let the journey to success commence.</span></p><p><span><strong>What you will learn</strong></span></p><p><span><strong>1</strong>:Strategic Planning and its Importance</span><br />
<span><strong>2</strong>:Setting Up a Strategic Plan</span><br />
<span><strong>3</strong>:Review and Evaluation</span><br />
<span><strong>4</strong>:Defining Vision, Mission and Values </span><br />
<span><strong>5</strong>:Understanding Company Position</span><br />
<span><strong>6</strong>:Growth</span><br />
<span><strong>7</strong>:Strategic Priorities</span><br />
<span><strong>8</strong>:Putting the Plan Together</span><br />
<span><strong>9</strong>:Planning for Department Managers and Entrepreneurs</span><br />
<span><strong>10</strong>:Keeping a Strategic Planning Efficient</span></p><h4>Course Outcomes</h4><p>
After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college.</p><h4>Assessment</h4><p>
Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter.</p><h4>Accreditation</h4><p>
Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.</p>

Elearncollege

Strategic Planning For Business Course

General Admission

<h2>Description</h2><p><span><strong>Corporate Brand Management Diploma</strong></span></p><p><span>In today's dynamic business landscape, corporate branding isn't merely about a logo or a catchy slogan; it's about crafting a company's very identity, ensuring it resonates with both internal stakeholders and the wider public. The Corporate Brand Management Diploma offers an immersive online learning experience for those who wish to gain profound insights into the multifaceted realm of corporate branding.</span></p><p><span>When we think of corporate brands, we often picture globally renowned entities. But even these giants started with foundational strategies, and their journey towards global recognition is one of meticulous planning, strategy, and relentless execution. This diploma provides aspirants with the essential tools to start on this journey, whether for a budding start-up or an established conglomerate.</span></p><p><span>Beginning with an introduction to corporate branding, students will grasp the nuances that distinguish it from product branding, appreciating the broader implications for a company's long-term strategy. From understanding the basic building blocks of Corporate Brand Management, learners will move onto the intricacies of brand strategy and planning. This section anchors the theoretical knowledge required for structuring a formidable corporate brand.</span></p><p><span>Effective communication stands at the crux of brand success. Hence, the module on communicating the corporate brand offers a step-by-step guide to ensuring a company's message is clear, compelling, and consistent. As the digital realm reshapes our world, digital brand management has become an indispensable component of any brand strategy. Students will be equipped with the tools and techniques to navigate this digital era, ensuring their brands remain contemporary and engaging.</span></p><p><span>Yet, in this ever-evolving business environment, even established brands need to reinvent themselves. The Corporate Brand Management Diploma touches upon the sensitive topic of corporate rebranding, imparting the necessary skills to transition seamlessly, keeping core values intact while ensuring relevance in new markets or changing conditions.</span></p><p><span>Brands don't operate in isolation. Their performance and resonance with their audience are pivotal. Therefore, the course covers the intricacies of brand performance and measurement, ensuring students understand how to gauge brand health and, if necessary, make adjustments.</span></p><p><span>However, branding isn't restricted to localised strategies. As we transition to a global village, the significance of global corporate brand management intensifies. This diploma will unravel the complexities of managing a brand on a global scale, ensuring cultural sensitivities, regional nuances, and international standards are all in harmony.</span></p><p><span>In recent times, consumers have become increasingly conscious of the brands they align with, not just in terms of quality or appeal but in terms of ethics and values. The course recognises this paradigm shift and introduces learners to the world of corporate social responsibility and brand management. How can a brand be a force for good? How can it ensure ethical considerations without compromising on profitability?</span></p><p><span>Lastly, in a forward-looking approach, the course explores the future of corporate brand management. What lies ahead in this domain? What are the emerging trends that aspirants should be wary of, and how can they be best prepared to tackle new challenges?</span></p><p><span>To conclude, the Corporate Brand Management Diploma is not just another course. It is an online journey, meticulously designed for those who truly believe in the power of branding, offering a comprehensive understanding, from basic tenets to futuristic insights. Enrol today and embark on a journey to master the art and science of corporate brand management.</span></p><p><span><strong>What you will learn</strong></span></p><p><span><strong>1</strong>:Introduction to Corporate Branding</span><br />
<span><strong>2</strong>:The Building Blocks of Corporate Brand Management</span><br />
<span><strong>3</strong>:Brand Strategy and Planning</span><br />
<span><strong>4</strong>:Communicating the Corporate Brand</span><br />
<span><strong>5</strong>:Digital Brand Management</span><br />
<span><strong>6</strong>:Corporate Rebranding </span><br />
<span><strong>7</strong>:Brand Performance and Measurement</span><br />
<span><strong>8</strong>:Global Corporate Brand Management </span><br />
<span><strong>9</strong>:Corporate Social Responsibility and Brand Management </span><br />
<span><strong>10</strong>:The Future of Corporate Brand Management</span></p><h4>Course Outcomes</h4><p>
After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college.</p><h4>Assessment</h4><p>
Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter.</p><h4>Accreditation</h4><p>
Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.</p>

Corporate Brand Management Course

<section>
<div>
<h4><strong>About this course</strong></h4><p><br /></p><p>In this 4 hours of teaching and interaction we lift the lid on boys identity and behaviour and look at the emotional world beneath.</p><p><br /></p><p>We explore how developing emotional worlds can be impacted upon by race, LGBTQ+, gender and poverty.</p><p><br /></p><p>We provide the Circle of Courage robust model for understanding emotional worlds and generating strategies.</p><p><br /></p><p>This course gives an opportunity to focus on the emotional needs of boys and how to meet these. We lift the lid on an emerging urgent inclusion issue, namely meeting the emotional needs of boys. Everyone knows a boy. They may be pupil, son, brother, parent or partner. Boys when they become adults are over represented in the prison, and mental health system.</p><p>In one recent year 1300 young men committed suicide in the UK. In the UK the commonest cause of death among those aged 16-35 is suicide. Three men for every one woman kill themselves every year).</p><p>1 in 4 women experience domestic violence and 2 women a week are killed by a current or ex partner. Boys and men are a major concern. We need to find ways to allow them to unclench their hearts and learn to experience, process, communicate and manage their own emotional lives for their own and for the good of the wider community.</p><p><br /></p><h3><strong>Benefits to you</strong></h3><p><br /></p><ol>
<li>Increased understanding of boys' emotional needs</li>
<li>Access to a wider range of practical strategies to impact on meeting emotional and behaviour problems</li>
<li>Deeper understanding of core values surrounding inclusion of boys</li>
<li>Opportunity to reflect on professional attitudes and behaviour towards boys and their emotional challenges</li>
<li>New skills and processes to make boys' inclusion and achievement more successful</li>
</ol><p><br /></p>
</div>
</section>

Inclusive Solutions

Transforming our approaches to meeting boys emotional needs with some radical fresh thinking

Understanding Emotional Needs of Boys

Packt

Ruby

Programming

In this course, we will master the syntax and structure of RSpec then learn to utilize test-driven development principles to design and implement clean test specs and reduce dependencies in the test suite by mocking objects with class and instance doubles. We will also explore the wide collection of RSpec matches available to test the code.

Testing Ruby with RSpec: The Complete Guide

<p><strong>The ATHE Level 3 Diploma in Health and Social Care </strong>is a comprehensive course that provides learners with the knowledge and skills needed to succeed in the health and social care industry. <strong>Regulated by Ofqual</strong>, this course is designed to meet the needs of those who want to develop their understanding of health and social care principles and practices. The diploma is an ideal choice for anyone who wants to progress in their career or pursue further education.</p><p>In addition to the diploma, learners will also have access to <strong>5 CPD accredited courses </strong>that complement the core topics of the diploma. This course is designed to enhance the learner's knowledge in specific areas of health and social care and provide them with the tools to excel in their profession.</p><p>The ATHE Level 3 Diploma in Health and Social Care (2020) is an excellent choice for anyone who wants to develop their understanding of health and social care principles and practices. The 5 CPD accredited courses that come with the diploma offer learners the opportunity to enhance their knowledge and skills in specific areas of health and social care. With these courses, learners will be well-equipped to succeed in their profession and make a positive impact on the lives of those in their care.</p><p>The regulated qualification package includes the following:</p><ul><li><strong>Qualification Specification</strong></li><li><strong>Support Materials </strong></li><li><strong>24/7 access to the Course Library</strong></li><li><strong>Assessment Guidance</strong></li><li><strong>Tutor Support</strong></li><li><strong>On-Demand Customer Service</strong></li><li><strong>Assignment, Observation, and Report Templates. </strong></li></ul><p>These additional benefits ensure that you have all the necessary resources and support to complete your qualification.</p><p>The qualification number for the <strong>ATHE Level 3 Diploma in Health and Social Care (2020)</strong> is <strong>603/0390/6</strong>. The total credit value offered by this qualification is <strong>60</strong> credits, with all of the units being level 3. The normal age range for this qualification's learners is <strong>16 and above. </strong></p><p>By enrolling, learners will also be able to develop study skills like critical thinking, planning, organising, research, analysis, reflection and IT skills. Individual learners will be able to identify their strengths while improving areas that need more attention.</p><p><strong>Learning Outcome for the CPD Course Bundle: </strong></p><ul><li>Demonstrate an understanding of the fundamentals of first aid and be able to administer basic first aid in a range of situations</li><li>Develop the necessary clinical observation skills required to monitor and assess patients effectively and ensure their safety and wellbeing</li><li>Identify and understand different types of brain injuries and concussions, their causes, symptoms, and potential treatments, as well as how to provide appropriate care and support for those affected by these conditions</li><li>Develop knowledge and skills related to nurse prescribing, including pharmacology, drug calculations, and legal and ethical considerations, and be able to prescribe safely and effectively within the scope of their practice</li><li>Demonstrate a comprehensive understanding of medical law, including legal and ethical issues surrounding healthcare delivery and patient rights and responsibilities</li><li>Apply critical thinking and problem-solving skills to effectively manage medical emergencies, make informed decisions, and provide appropriate care and support to patients in different settings</li><li>Develop effective communication and interpersonal skills to work collaboratively with other healthcare professionals, patients, and their families, and provide person-centered care that meets their individual needs and preferences.</li></ul><p><strong>Curriculum Breakdown of ATHE Level 3 Diploma in Health and Social Care (2020)</strong></p><ul><li><strong>Unit 01:</strong> Structure and Overview of the Health and Social Care Sector</li><li><strong>Unit 02</strong>: Principles, Values and Regulation in the Health and Social Care Sector</li><li><strong>Unit 03: </strong>Human Growth and Development</li><li><strong>Unit 04:</strong> Working in Health and Social Care</li><li><strong>Unit 05:</strong> Research in Health and Social Care</li><li><strong>Unit 06:</strong> Personal and Professional Development in the Health and Social Care Sector</li></ul><p><strong>Guided Learning Hours(GLH) -</strong><strong>360</strong></p><p><strong>Total Qualification Time(TQT) -</strong><strong>600</strong></p><p><strong>Further Progression for ATHE Level 3 Diploma in Health and Social Care (2020)</strong>:</p><p>After successfully completing the course, learners may progress to:</p><ul><li>Employment or have increased opportunities for progression in their current role</li><li>A higher level ATHE qualification at Level 4 or above, in a related subject</li><li>The first year of a degree programme</li><li>Higher level apprenticeships</li></ul><p><strong>CPD Courses in this bundle are:</strong></p><ul><li>First Aid Training Course</li><li>Clinical Observation Skills for Carers</li><li>Brain - Injuries &amp; Concussion</li><li>Nurse Prescribing Diploma</li><li>Medical Law</li></ul><p>The course bundle includes a First Aid Training Course, which covers essential skills and techniques to provide immediate care in emergency situations. Clinical Observation Skills for Carers will provide learners with knowledge on how to observe, record and report patient's condition accurately. Brain - Injuries &amp; Concussion will focus on the identification and management of head injuries and concussions. The Nurse Prescribing Diploma provides a comprehensive understanding of the prescribing process and the legal and ethical aspects of prescribing. Medical Law will cover the legal framework that governs the practice of healthcare professionals and the impact of legal decisions on healthcare practices. This course bundle will equip learners with the necessary skills and knowledge to provide effective care and support to patients, while ensuring compliance with the legal and ethical standards in the healthcare industry.</p><p><strong>Assessment</strong></p><p>For the <strong>ATHE Level 3 Diploma in Health and Social Care (2020)</strong>, learners will have to prepare written assignments for knowledge-based units and show practical demonstrations or submit observation reports for Competence/Skill-Based units.</p><p>All evidence will be initially assessed by a qualified assessor and further assessed by an Internal Quality Assurer (IQA) to ensure that all the learning outcomes of the qualification are properly accomplished by the learner.</p><p>At the end of each CPD-accredited course in this bundle, there are quizzes and assignments which will test the learner's knowledge and help them to remember the most important information. After completion, a learner can order either a PDF or Hard-copy Certificate for a predetermined price for every course.</p><p><strong>Certification</strong></p><p>After completing the assessment, learners will receive a prestigious <strong>ATHE</strong> certificate that has been approved by <strong>The Office of Qualifications and Examinations Regulation (Ofqual)</strong>. This certificate holds a <strong>Level 3</strong><strong> status in the Regulated Qualifications Framework (RQF).</strong></p><p>This is an impressive achievement that hiring managers hold in high regard, and they actively seek candidates who possess RQF qualifications on their resumes. So, not only will you gain valuable knowledge and skills in health and social care, but you'll also boost your employability with a sought-after certification!</p><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p><strong>Entry Requirements for ATHE Level 3 Diploma in Health and Social Care (2020):</strong></p><p>For professionals who have recently gone through education or training, the entry requirements include the following:</p><ul><li>5 or more GCSEs at grades C and above</li><li>Other related level 2 subjects</li><li>Other equivalent international qualifications</li><li>Professionals must have good English skills to access resources and complete the unit assignments</li></ul>
                        </div>

One Education

Ofqual Regulated Health and Social Care Level 3 & First Aid Training Course

<p style="color: rgb(149, 146, 146); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(149, 146, 146);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Outline:</strong></p><p data-mce-fragment="1" style="color: rgb(149, 146, 146); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(149, 146, 146);">This course discusses various aspects of thermal performance and condensation risk of glazed systems in some detail, and identifies key British, European and CWCT standards and guides relevant to those issues.</p><p data-mce-fragment="1" style="color: rgb(149, 146, 146); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(149, 146, 146);">The course has a significant engineering and physics content.</p><p data-mce-fragment="1" style="color: rgb(149, 146, 146); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(149, 146, 146);"><strong data-mce-fragment="1" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Target audience:</strong></p><p data-mce-fragment="1" style="color: rgb(149, 146, 146); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(149, 146, 146);">This course is intended for those with an interest in understanding thermal and condensation performance of glazed facades, and those who wish to specify thermal performance at an advanced level.</p><p data-mce-fragment="1" style="color: rgb(149, 146, 146); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(149, 146, 146);">This course is focused on the thermal and condensation of glazed systems. &nbsp;If you are more interested in the thermal and condensation performance of built-up walls, we recommend attending the built-up walls thermal course (C107).</p><p data-mce-fragment="1" style="color: rgb(149, 146, 146); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(149, 146, 146);"><strong data-mce-fragment="1" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learning objectives:</strong></p><ul data-mce-fragment="1" style="color: rgb(149, 146, 146); box-sizing: border-box;" fr-original-style=" color: rgb(149, 146, 146);"><li data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Overview of building regulations requirements</li><li data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">How heat moves through a wall</li><li data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Understand how window and curtain wall U-values are calculated, and factors affecting performance</li><li data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Understand how glazing U-values are calculated, and factors affecting performance</li><li data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Fundamentals of condensation</li></ul><p style="color: rgb(149, 146, 146); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(149, 146, 146);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Assessment:</strong></p><ul style="color: rgb(149, 146, 146); box-sizing: border-box;" fr-original-style=" color: rgb(149, 146, 146);"><li fr-original-style="" style="box-sizing: border-box;">Assessment will be via a series of multiple-choice questions following the course,</li><li fr-original-style="" style="box-sizing: border-box;">The assessment is timed and must be passed in order to receive a CPD certificate for the course,</li><li fr-original-style="" style="box-sizing: border-box;">If the assessment is failed, one re-take will be permitted.</li></ul><p style="color: rgb(149, 146, 146); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(149, 146, 146);"><b fr-original-style="" style="box-sizing: border-box;">Prerequisites:</b></p><p style="color: rgb(149, 146, 146); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(149, 146, 146);">None, although C201 Introduction to contemporary cladding and fa&ccedil;ade systems is recommended.<span data-mce-style="font-weight: 400;" fr-original-style="" style="box-sizing: border-box;"></span></p><p style="color: rgb(149, 146, 146); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(149, 146, 146);"><b fr-original-style="" style="box-sizing: border-box;">Course availability:&nbsp;</b></p><p style="color: rgb(149, 146, 146); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(149, 146, 146);">16&nbsp;<span data-mce-style="font-weight: 400;" fr-original-style="" style="box-sizing: border-box;">September - 13 October 2024</span></p><p style="color: rgb(149, 146, 146); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(149, 146, 146);"><b fr-original-style="" style="box-sizing: border-box;">Lecture time:</b><span data-mce-style="font-weight: 400;" fr-original-style="" style="box-sizing: border-box;"></span></p><p style="color: rgb(149, 146, 146); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(149, 146, 146);"><span data-mce-style="font-weight: 400;" fr-original-style="" style="box-sizing: border-box;">1/2 day<br fr-original-style="" style="box-sizing: border-box;"></span></p><p data-mce-fragment="1" style="color: rgb(149, 146, 146); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(149, 146, 146);"><b data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Price:&nbsp;</b></p><table data-mce-style="font-weight: 400;" style="color: rgb(149, 146, 146); border: none; border-collapse: collapse; empty-cells: show; max-width: 100%; box-sizing: border-box;" fr-original-style=" color: rgb(149, 146, 146);"><tbody fr-original-style="" style="box-sizing: border-box;"><tr fr-original-style="" style="box-sizing: border-box;"><td width="208" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Member price</p></td><td width="208" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Non-Member price</p></td></tr><tr fr-original-style="" style="box-sizing: border-box;"><td width="208" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&pound;90 + VAT</p></td><td width="208" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&pound;180 + VAT</p></td></tr></tbody></table>

CWCT

C203- THERMAL AND CONDENSATION PERFORMANCE (1/2-DAY)

Member Price

Non-Member Price

<p><strong>24 Hours Left! Don't Let Year-End Deals Slip Away - Enrol Now!</strong></p><p>There has never been a more important time to gain a deep understanding of British citizenship and the laws and regulations surrounding it. With the uncertainty brought about by Brexit and the ongoing changes in the political landscape, having a comprehensive knowledge of British citizenship has become essential. Our British Citizenship Diploma bundle offers learners the opportunity to gain this vital knowledge and much more.</p><p>The QLS-endorsed British Citizenship Diploma course is a must-have for anyone looking to gain British citizenship or work in fields that require an in-depth knowledge of British citizenship. The course covers the history, values, and traditions of the United Kingdom, as well as the laws and regulations that govern British citizenship. Upon completion of the course, learners will receive a QLS hardcopy certificate, which is a valuable asset in today's competitive job market.</p><p>In addition to the British Citizenship Diploma, our bundle features 10 relevant courses that are CPD-QS accredited. These courses cover topics such as Equality &amp; Diversity, Human Rights, Employment Law, Contracts Law, Mental Health Awareness, and Entrepreneurship. Each course has been designed to provide learners with the skills and knowledge they need to succeed in their chosen field.</p><p>Investing in our British Citizenship Diploma bundle is an investment in your future. With the skills and knowledge gained from our courses, you will be well-equipped to navigate the complex world of British citizenship and excel in your personal and professional life. Enrol today and take the first step towards a brighter future.</p><p><strong>This </strong><strong>British Citizenship Diploma</strong><strong> Bundle Package includes:</strong></p><ul><li><strong>Course 01:</strong> Diploma in British Citizenship at QLS Level 4</li></ul><p><strong>10 Premium Additional CPD QS Accredited Courses -</strong></p><ul><li><strong>Course 01:</strong> Equality &amp; Diversity - Discrimination</li><li><strong>Course 02:</strong> Human Rights</li><li><strong>Course 03:</strong> Cross-Cultural Awareness Training</li><li><strong>Course 04:</strong> Communicate and Work with People from Other Culture Course</li><li><strong>Course 05:</strong> Employment Law</li><li><strong>Course 06:</strong> Contracts Law</li><li><strong>Course 07:</strong> Mental Health Awareness Course</li><li><strong>Course 08:</strong> Effective Methods of Public Speaking and Presentation Skill</li><li><strong>Course 09:</strong> Tax Accounting Diploma</li><li><strong>Course 10:</strong> Entrepreneurship</li></ul><p><strong>Why Prefer This </strong><strong>British Citizenship Diploma</strong><strong> Bundle?</strong></p><ul><li>You will receive a completely free certificate from the Quality Licence Scheme</li><li>Option to purchase 10 additional certificates accredited by CPD</li><li>Get a free Student ID Card - (£10 postal charges will be applicable for international delivery)</li><li>Free assessments and immediate success results</li><li>24/7 Tutor Support</li></ul> <p><strong>After taking this </strong><strong>British Citizenship Diploma</strong><strong> bundle courses, you will be able to learn:</strong></p><ul><li>Develop a comprehensive understanding of British citizenship, including its history, values, and traditions.</li><li>Gain in-depth knowledge of the laws and regulations surrounding British citizenship.</li><li>Learn about Equality &amp; Diversity and how to promote equality in the workplace.</li><li>Understand fundamental Human Rights and freedoms.</li><li>Enhance your communication skills and learn how to work with people from other cultures.</li><li>Develop an understanding of Employment and Contracts Law.</li><li>Learn how to manage Mental Health and promote well-being.</li></ul><p><strong>***Curriculum breakdown of </strong><strong>British Citizenship Diploma</strong><strong>***</strong></p><ul><li><strong>Module 01:</strong> What Is British Citizenship?</li><li><strong>Module 02: </strong>Different Types of British Citizenship</li><li><strong>Module 03: </strong>Nationality, Immigration and Legislation</li><li><strong>Module 04:</strong> Enter and Stay in the UK Both Temporarily and Permanently</li><li><strong>Module 05: </strong>Citizenship Application Tests</li><li><strong>Module 06: </strong>Dual Nationality and Citizenship</li><li><strong>Module 07:</strong> Brexit and Its Implications for EEA and Non-EEA Citizens</li><li><strong>Module 08: </strong>Living Rights in the UK</li><li><strong>Module 09: </strong>Seeking Employment in the UK (Before and After the Application)</li><li><strong>Module 10:</strong> Obtaining Visas for the UK</li><li><strong>Module 11: </strong>British Life and Culture</li></ul><p><strong>How is the British Citizenship Diploma Bundle Assessment Process?</strong></p><p>You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment.</p><p>You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you successfully pass the exams.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        220 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div> <h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course bundle is perfect for:</p><ul><li>British people</li><li>Individuals seeking British citizenship or working in fields that require an in-depth knowledge of British citizenship.</li><li>Professionals looking to improve their communication skills and cultural awareness.</li><li>Those interested in pursuing a career in law, business, or mental health.</li></ul>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>This bundle will be beneficial for anyone looking to pursue career as:</p><ul><li>Legal Assistant: £16,000 - £30,000 per annum.</li><li>Human Rights Officer: £24,000 - £32,000 per annum.</li><li>Cross-Cultural Trainer: £22,000 - £35,000 per annum.</li><li>Employment Law Specialist: £30,000 - £50,000 per annum.</li><li>Mental Health Support Worker: £18,000 - £30,000 per annum.</li></ul>
                        </div> <h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>CPD QS Accredited Certificate </h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div><p>Upon successfully completing the Bundle, you will need to place an order to receive a PDF Certificate for each course within the bundle. These certificates serve as proof of your newly acquired skills, accredited by CPD QS. Also, the certificates are recognised throughout the UK and internationally.</p></div>
        <h4>CPD QS Accredited Certificate </h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div><p>International students are subject to a £10 delivery fee for their orders, based on their location.</p></div>
        <h4>Diploma in British Citizenship at QLS Level 4</h4>
        <p>
            Hard copy certificate -
            Included
        </p>

                        </div>

Academy for Health and Fitness

British Citizenship Diploma - CPD Certified

<p fr-original-style="" id="isPasted" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Advanced Professional Certificate Courses</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">These are short online certificate courses of a more advanced nature designed to help you develop professionally and achieve your career goals, while you earn a professional certificate which qualifies you for the appropriate continuous professional development (CPD).</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; user-select: none; break-after: page; box-sizing: border-box;"><p fr-original-style="" id="isPasted" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Advanced Professional Certificate in Strategic Leadership</strong></p><p fr-original-style=" color: rgb(33, 37, 41);" id="isPasted" style="color: rgb(33, 37, 41); font-size: 16px; box-sizing: border-box;">The Advanced Professional Certificate in Strategic Leadership aims to chalk out the role played by the senior leadership in shaping the future of an organization so that learner can be trained as a successful leader of the future.</p><p fr-original-style=" color: rgb(33, 37, 41);" style="color: rgb(33, 37, 41); font-size: 16px; box-sizing: border-box;">The course outlines strategies to be implemented to develop leadership that envision the company strategic direction by understanding the dynamics of team building, the concept of bringing people together to work on shared goals and successfully achieve team results.</p><p fr-original-style=" color: rgb(33, 37, 41);" style="color: rgb(33, 37, 41); font-size: 16px; box-sizing: border-box;">The learner will learn the strategic visionary direction and its roots in exceptional leadership qualities that create organizational culture and values for an inclusive environment of motivation, achievement and success.</p><p fr-original-style=" color: rgb(33, 37, 41);" style="color: rgb(33, 37, 41); font-size: 16px; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learning Outcomes</strong></p><p fr-original-style=" color: rgb(33, 37, 41);" style="color: rgb(33, 37, 41); font-size: 16px; box-sizing: border-box;">After the successful completion of the certificate, the student will be able to learn:</p><ul fr-original-style=" color: rgb(33, 37, 41);" style="color: rgb(33, 37, 41); box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">What truly is the meaning and importance of leadership</li><li fr-original-style="" style="box-sizing: border-box;">How to evaluate the role of leaders in strategic direction</li><li fr-original-style="" style="box-sizing: border-box;">Ten theories of leadership</li><li fr-original-style="" style="box-sizing: border-box;">Leadership stages and the strategies implemented in each stage</li><li fr-original-style="" style="box-sizing: border-box;">The relationships between leaders of workgroups, and leaders of the organization.</li><li fr-original-style="" style="box-sizing: border-box;">The influence of leadership on groups and teams.</li><li fr-original-style="" style="box-sizing: border-box;">Evaluate the characteristics of an effective workgroup and team.<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong></li><li fr-original-style="" style="box-sizing: border-box;">Role of leadership in the strategic management process</li><li fr-original-style="" style="box-sizing: border-box;">The relevance of internal and external environment</li><li fr-original-style="" style="box-sizing: border-box;">Importance of a vision and mission statement</li><li fr-original-style="" style="box-sizing: border-box;">Relationship between corporate objectives and strategies</li><li fr-original-style="" style="box-sizing: border-box;">Importance of strategy evaluation</li><li fr-original-style="" style="box-sizing: border-box;">5-step process to crisis risk assessment</li><li fr-original-style="" style="box-sizing: border-box;">3 phases of the change process</li><li fr-original-style="" style="box-sizing: border-box;">Major reasons for resisting change</li><li fr-original-style="" style="box-sizing: border-box;">People and task-oriented techniques for overcoming resistance to change</li><li fr-original-style="" style="box-sizing: border-box;">Explore the exercise of leadership power and influence.</li><li fr-original-style="" style="box-sizing: border-box;">Review the importance of ethics, values and corporate social responsibilities to an organization&#39;s value.</li><li fr-original-style="" style="box-sizing: border-box;">Ethical framework for leadership guidance</li><li fr-original-style="" style="box-sizing: border-box;">Evaluate leadership and sustainability concepts and trends.</li></ul><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; user-select: none; break-after: page; box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Accreditation</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><span fr-original-style="color: rgb(33, 37, 41);" id="isPasted" style="color: rgb(33, 37, 41); box-sizing: border-box;">All MSBM courses are accredited by the relevant partners and awarding bodies. &nbsp;Please refer to&nbsp;</span><a fr-original-style=" color: rgb(51, 51, 51);" href="https://msbm.org.uk/about-msbm/accreditation" style="color: rgb(51, 51, 51); user-select: auto; box-sizing: border-box; text-decoration: inherit; cursor: pointer;">MSBM accreditation</a><span fr-original-style="color: rgb(33, 37, 41);" style="color: rgb(33, 37, 41); box-sizing: border-box;">&nbsp;in about us for more details.</span></p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; user-select: none; break-after: page; box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry Requirements</strong></p><span fr-original-style="color: rgb(33, 37, 41);" id="isPasted" style="color: rgb(33, 37, 41); box-sizing: border-box;">There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course.</span><br style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><p fr-original-style=" color: rgb(33, 37, 41);" style="color: rgb(33, 37, 41); font-size: 16px; box-sizing: border-box;">The certificate is designed to enhance the knowledge of the learner in the field. This certificate is for everyone eager to know more and gets updated on current ideas in their respective field. We recommend this certificate for the following audience.</p><ul fr-original-style=" color: rgb(33, 37, 41);" style="color: rgb(33, 37, 41); box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">CEO, Director, Manager, Supervisor</li><li fr-original-style="" style="box-sizing: border-box;">Corporate Leader</li><li fr-original-style="" style="box-sizing: border-box;">Team Leader</li><li fr-original-style="" style="box-sizing: border-box;">Social Leader</li><li fr-original-style="" style="box-sizing: border-box;">Business Leaders</li><li fr-original-style="" style="box-sizing: border-box;">Leadership Academic</li><li fr-original-style="" style="box-sizing: border-box;">HR Manager</li><li fr-original-style="" style="box-sizing: border-box;">Change Leader, Change Agent</li><li fr-original-style="" style="box-sizing: border-box;">Project Manager</li><li fr-original-style="" style="box-sizing: border-box;">Key Human Resources Roles</li></ul>

Metropolitan School of Business & Management UK

Advanced Professional Certificate in Strategic Leadership

<strong>Welcome to a hands-on SQL course. In this course, you will learn the fundamentals of SQL databases and the relational model. We will cover core concepts such as inserting data into SQL databases, extracting data from SQL databases, aggregations, subqueries, joins, unions, and window functions. This course will help you write complex queries to perform tasks as required in technical interviews or on the job.</strong>
        <p>SQL is the language that you can use to interact with one major database type (SQL databases), one that is very widespread in today's world.

Knowing SQL will give you a nice ability and understanding of how to handle data and databases and being able to integrate it into Python code enables you to create great, dynamic, and automatic systems that combine the power of programming and data.

In this course, you will be learning SQL. We will start by going through some fundamental knowledge such as learning about the relational model, as well as what schemas are, the different data types available, and how database tables are organized. Then we will go ahead and set up our own local Postgres database and populate it with data so that we have data to run queries against. Once our setup is done, we are then ready to jump directly into writing SQL code.

We will start with the basics such as creating databases and tables, inserting, and selecting data, and performing filtering and result order. This way, we can ensure we are comfortable with how the data is laid out and that we feel good performing the basic operations that usually make up all queries. Then we will jump deeper into SQL by learning about aggregations, subqueries, joins, unions, and window functions.

By the end of this course, you should be ready to successfully apply your SQL knowledge in technical interviews and on the job.

All the resources for this course are available at: https://github.com/PacktPublishing/Job-Ready-SQL-in-an-Afternoon</p>
        <h2>What You Will Learn</h2><p>Understand SQL databases<br>Understand the relational model<br>Learn to insert data into SQL databases<br>Extract data from SQL databases<br>Learn about aggregations, subqueries, joins, and unions<br>Learn about different window functions</p>
        <h2>Audience</h2><p>Anyone who wishes to learn about databases, integrate databases into their programs, or learn about SQL databases should take this course. One should be familiar with Python's fundamentals.</p>
        <h2>Approach</h2><p>In this practical, hands-on course, we will start with the fundamentals, such as building databases and tables, adding and choosing data, and performing filtering and result ordering. Then, by studying aggregations, subqueries, joins, unions, and window functions, we will dive even further into the world of SQL.</p>
        <h2>Key Features</h2><p>Write complex queries to perform tasks as required in technical interviews or on the job * A hands-on course, designed for complete beginners * Cover different self-learning exercises to improve your query-writing skills</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Job-Ready-SQL-in-an-Afternoon</p>
        <h2>About the Author</h2><h3>Maximilian Schallwig</h3><p>Maximilian Schallwig is a data engineer and a proficient Python programmer. He holds a bachelor's degree in physics and a master's degree in astrophysics. He has been working on data for over five years, first as a data scientist and then as a data engineer. He can talk endlessly about big data pipelines, data infrastructure, and his unwavering devotion to Python.

Even after two unsuccessful attempts in high school, he still decided to learn Python at the University. He cautiously stepped into the realm of data, beginning with a simple Google search for 'what does a data scientist do'.

He was determined to pursue a career in data science to become a data engineer by learning about big data tools and infrastructure design to build scalable systems and pipelines. He enjoys sharing his programming skills with the rest of the world.</p>
        <h2>Course Outline</h2><h4>1. Fundamentals and Setup</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Intro to Relational Databases</p><p style='margin: 0'>In this video, we will have a quick introduction to Relational databases.</p></td></tr><tr><td style='padding: 15px;'><p>2. Data Types and Schemas</p><p style='margin: 0'>In this video, you will learn about data types and schemas.</p></td></tr><tr><td style='padding: 15px;'><p>3. [Mac] Setting Up a Local PostgreSQL Server</p><p style='margin: 0'>In this video, we will work on setting up a local PostgreSQL server for Mac systems.</p></td></tr><tr><td style='padding: 15px;'><p>4. [Windows] Setting Up a Local PostgreSQL Server</p><p style='margin: 0'>In this video, we will work on setting up a local PostgreSQL server for Windows systems.</p></td></tr><tr><td style='padding: 15px;'><p>5. [Mac] SQL Editor Postico</p><p style='margin: 0'>In this video, we will cover SQL Editor Postico for Mac.</p></td></tr><tr><td style='padding: 15px;'><p>6. SQL Editor DataGrip</p><p style='margin: 0'>In this video, we will explore SQL Editor DataGrip.</p></td></tr><tr><td style='padding: 15px;'><p>7. SQL Editor CLI (Command Line Interface)</p><p style='margin: 0'>In this video, we will explore SQL Editor CLI (Command Line Interface).</p></td></tr><tr><td style='padding: 15px;'><p>8. Creating and Removing a Database</p><p style='margin: 0'>In this video, you will learn how to create and remove a database.</p></td></tr></tbody></table><br><h4>2. Databases, Tables, and Basic Queries</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Creating Schemas</p><p style='margin: 0'>In this video, you will learn how to create schemas.</p></td></tr><tr><td style='padding: 15px;'><p>2. Creating Tables</p><p style='margin: 0'>In this video, you will learn how to create tables.</p></td></tr><tr><td style='padding: 15px;'><p>3. Altering Tables</p><p style='margin: 0'>In this video, you will learn how to alter tables.</p></td></tr><tr><td style='padding: 15px;'><p>4. Enumerated Types</p><p style='margin: 0'>In this video, you will learn about Enumerated types.</p></td></tr><tr><td style='padding: 15px;'><p>5. Inserting Values</p><p style='margin: 0'>In this video, you will learn how to insert values.</p></td></tr><tr><td style='padding: 15px;'><p>6. Running an SQL Script</p><p style='margin: 0'>In this video, you will learn how to run an SQL script.</p></td></tr><tr><td style='padding: 15px;'><p>7. Reading Data</p><p style='margin: 0'>In this video, you will learn how to read data.</p></td></tr><tr><td style='padding: 15px;'><p>8. Creating Tables Using Query Results</p><p style='margin: 0'>In this video, you will learn how to create tables using query results.</p></td></tr><tr><td style='padding: 15px;'><p>9. Aliases and Ordering</p><p style='margin: 0'>In this video, you will learn about aliases and ordering.</p></td></tr></tbody></table><br><h4>3. Conditionals and Arithmetic</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Conditional Filtering Direct Comparisons</p><p style='margin: 0'>In this video, we will cover conditional filtering direct comparisons.</p></td></tr><tr><td style='padding: 15px;'><p>2. Conditional Filtering Grouped Comparisons</p><p style='margin: 0'>In this video, we will cover conditional filtering grouped comparisons.</p></td></tr><tr><td style='padding: 15px;'><p>3. Joining Conditionals</p><p style='margin: 0'>In this video, we will cover joining conditionals.</p></td></tr><tr><td style='padding: 15px;'><p>4. Negating Conditionals</p><p style='margin: 0'>In this video, we will cover negating conditionals.</p></td></tr><tr><td style='padding: 15px;'><p>5. Filtering Null Values</p><p style='margin: 0'>In this video, we will cover filtering null values.</p></td></tr><tr><td style='padding: 15px;'><p>6. Creating New Columns and Arithmetic</p><p style='margin: 0'>In this video, you will learn how to create new columns and arithmetic.</p></td></tr><tr><td style='padding: 15px;'><p>7. Datatype Conversions</p><p style='margin: 0'>In this video, we will cover datatype conversions.</p></td></tr><tr><td style='padding: 15px;'><p>8. Logic Statements</p><p style='margin: 0'>In this video, we will cover the logic statements.</p></td></tr></tbody></table><br><h4>4. Dates, Times, and Manipulating Data</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Manipulating Strings</p><p style='margin: 0'>In this video, we will cover manipulating strings.</p></td></tr><tr><td style='padding: 15px;'><p>2. String Positional Information</p><p style='margin: 0'>In this video, we will cover string positional information.</p></td></tr><tr><td style='padding: 15px;'><p>3. String Subsets and Concatenations</p><p style='margin: 0'>In this video, we will cover string subsets and concatenations.</p></td></tr><tr><td style='padding: 15px;'><p>4. String Replacements</p><p style='margin: 0'>In this video, we will cover string replacements.</p></td></tr><tr><td style='padding: 15px;'><p>5. Date and Time</p><p style='margin: 0'>In this video, we will cover date and time.</p></td></tr><tr><td style='padding: 15px;'><p>6. Date and Time Intervals</p><p style='margin: 0'>In this video, we will cover date and time intervals.</p></td></tr><tr><td style='padding: 15px;'><p>7. Comments</p><p style='margin: 0'>In this video, we will cover comments.</p></td></tr><tr><td style='padding: 15px;'><p>8. Aggregation Functions</p><p style='margin: 0'>In this video, we will cover aggregation functions.</p></td></tr><tr><td style='padding: 15px;'><p>9. Grouping and Filtering Aggregations</p><p style='margin: 0'>In this video, you will learn how to group and filter aggregations.</p></td></tr></tbody></table><br><h4>5. Joins, Unions, and Subqueries</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Inner Joins</p><p style='margin: 0'>In this video, we will cover inner joins.</p></td></tr><tr><td style='padding: 15px;'><p>2. Left, Right, and Outer Joins</p><p style='margin: 0'>In this video, we will cover left, right, and outer joins.</p></td></tr><tr><td style='padding: 15px;'><p>3. Self Joins</p><p style='margin: 0'>In this video, we will cover self joins.</p></td></tr><tr><td style='padding: 15px;'><p>4. Unions</p><p style='margin: 0'>In this video, we will cover unions.</p></td></tr><tr><td style='padding: 15px;'><p>5. Subqueries</p><p style='margin: 0'>In this video, we will cover subqueries.</p></td></tr><tr><td style='padding: 15px;'><p>6. CTEs</p><p style='margin: 0'>In this video, we will cover CTEs (Common Table Expressions).</p></td></tr></tbody></table><br><h4>6. Window Functions</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Window Functions and Aliases</p><p style='margin: 0'>In this video, we will cover Window functions and aliases.</p></td></tr><tr><td style='padding: 15px;'><p>2. Row Numbers and Ranks</p><p style='margin: 0'>In this video, we will cover row numbers and ranks.</p></td></tr><tr><td style='padding: 15px;'><p>3. Using Other Rows with Window Functions</p><p style='margin: 0'>In this video, you will learn how to use other rows with Window functions.</p></td></tr><tr><td style='padding: 15px;'><p>4. NTiles</p><p style='margin: 0'>In this video, we will cover NTiles.</p></td></tr><tr><td style='padding: 15px;'><p>5. Understanding Query Performance</p><p style='margin: 0'>In this video, we will understand query performance.</p></td></tr></tbody></table><br><h4>7. Exercises</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Exercise 1</p><p style='margin: 0'>In this exercise video, we will practice understanding a new database, as we may not always be the creator of the database.</p></td></tr><tr><td style='padding: 15px;'><p>2. Exercise 2</p><p style='margin: 0'>In this exercise video, we will work on data filtering for easier analysis.</p></td></tr><tr><td style='padding: 15px;'><p>3. Exercise 3</p><p style='margin: 0'>In this exercise video, we will work on data preparation so that we have clean data to work with.</p></td></tr><tr><td style='padding: 15px;'><p>4. Exercise 4</p><p style='margin: 0'>In this exercise video, we will find out if there are any customers who purchased a track more than once.</p></td></tr><tr><td style='padding: 15px;'><p>5. Exercise 5</p><p style='margin: 0'>In this exercise video, we will find out how much people from each country spent on tracks in total.</p></td></tr></tbody></table>

PostgreSQL

Database Programming

Database

Python

Welcome to a hands-on SQL course. In this course, you will learn the fundamentals of SQL databases and the relational model. We will cover core concepts such as inserting data into SQL databases, extracting data from SQL databases, aggregations, subqueries, joins, unions, and window functions. This course will help you write complex queries to perform tasks as required in technical interviews or on the job.

Job-Ready SQL in an Afternoon

For new users and the curious.
IMPORTANT: Once you are signed up, send us your requests on what you would like to see within the demonstration and learn on the course. We will then cater for your needs and answer them during the session.
This is designed to be an introduction into how to start a room by room survey using the Heat Engineer app, then sending this survey to the online dashboard. We will then go through the different steps to complete this heat loss report. Optional pages will also be worked through and shown. 
Examples of how to select the flow temperature and the heat source (heat pumps and boilers) will be presented once the heat loss result is completed. 
Scope of works
Estimated Start Time	Duration mins	Topic	Platform / Device
7:00:00 PM	5	Welcome introduction - Show an example Heat loss report from online - The end result	Website
7:05:00 PM	2	How to sign up and the different account types 5 mins	Website
7:07:00 PM	4	What the app is used for and sending to the online account – Show about page	Website & app
7:11:00 PM	2	Login into the app (Example used is an iPhone 14) – what is My Info and the History	App (mobile & tablets)
7:13:00 PM	3	Briefly show the estimator tool	App (mobile & tablets)
7:16:00 PM	2	How to start a new room by room survey	App (mobile & tablets)
7:18:00 PM	10	Open up example from History and enter two rooms - One standard and one vaulted. PowerPoint to help visualise	App (mobile & tablets)
7:28:00 PM	1	Send survey to main dashboard	App (mobile & tablets)
7:29:00 PM	3	Quick Intro to dashboard.	Website
7:32:00 PM	1	Show profile setup	Website
7:33:00 PM	7	Open sent survey go through step 1 to step 8	Website
7:40:00 PM	2	Selecting a heat source - Heat Pump in this example	Website
7:42:00 PM	15	Optional pages overview, emitters and performance, current radiators, new radiators, DHW, Bivalent system and fuel comparison page.	Website
7:57:00 PM	2	Print report off or send copy to a supplier	Website
7:59:00 PM	5	Adding Designers	
8:04:00 PM	1	Our future plans	Website
8:05:00 PM	15	Heat Manager - Digital file system for you and your customers	Website
8:20:00 PM	Any feedback and further questions please email to support@heat-engineer.com		
Questions - You will be able to ask further questions after the event.
Delivered by Rich Cartwright BEng DipEd MCIPHE
NEW RADIATORS
We use EN442 standard to enable you to customise the defined MWT (°c) and the results will highlight if the radiator will heat the room for a given internal design temperature. We like to promote the need to design low temperature systems!
Add multiple designers to your account
You can now add extra dashboard users to complete heat loss and heating design reports on your Heat Engineer Software account.
DHW (DOMESTIC HOT WATER)
This will calculate the projected energy demand and running costs for DHW and domestic cylinder sizing.
EMITTERS AND PERFORMANCE
This page is primarily used for heat pump designs. Once you specify the flow temperature for each room the SCOP (Seasonal Coefficient of Performance) values will be shown, and the system will show if radiators are over or undersized.
CURRENT RADIATORS
Use the app on site to enter the current radiators and our system will display the output values for different flow temperatures.
FUEL COMPARISON
Multiple fuels to compare against, you can adjust the price per unit and CO2 factor (kg/kWh). Present these running costs to your clients.
PHOTOS AND NOTES
Photos and notes which you or your surveyors have taken will be shown when you open the report from your dashboard. You may also upload and download photos from your PC / laptop too.
 

Heat Engineer

Heating Engineer

For new users and the curious.

Hello,

For new users and the curious.

IMPORTANT: Firstly, once you are signed up, send us your requests on what you would like to see within the demonstration and learn on the course. We will then cater for your needs and answer them during the session.

This is designed to be an introduction into how to start a room by room survey using the Heat Engineer app, then sending this survey to the online dashboard. We will then go through the different steps to complete this heat loss report. Optional pages will also be worked through and shown. 

Examples of how to select the flow temperature and the heat source (heat pumps and boilers) will be presented once the heat loss result is completed. 

How to use Heat Engineer Software V2 (Selectable dates)

General admission

<div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Menopause Update</strong></div><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></div><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Focus:</strong></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">This specialised training day is meticulously designed for healthcare professionals, including nurses, allied healthcare practitioners (AHPs), and general practitioners (GPs), who are already practicing in the field of menopause care. With established NICE (National Institute for Health and Care Excellence) Guidance, practitioners can gain heightened confidence in effectively managing women experiencing menopause-related issues.</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Meet the Expert:</strong></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">Dr. Katie Barber, a seasoned GP with 15 years of experience in Oxfordshire and Buckinghamshire, leads this comprehensive update. Dr. Barber&#39;s journey into Women&#39;s Health began during her GP training when she earned diplomas from the Royal College of Obstetricians and Gynaecologists and the Faculty of Sexual and Reproductive Healthcare. Her work at the John Radcliffe Hospital&#39;s Gynaecology department, where she held a special interest in Gynaecology, sparked her enthusiasm for assisting women in navigating the various facets of menopause. Dr. Barber&#39;s expertise is further underlined by her Advanced Certificate of Menopause Care from the Faculty of Sexual and Reproductive Healthcare and her accreditation as a British Menopause Society specialist and Menopause trainer in Oxfordshire. She served as the Clinical Lead for the NHS Menopause service at the John Radcliffe in Oxfordshire until March 2021 and currently holds the role of Clinical Lead for the NHS Community Gynaecology Service in Oxfordshire. In 2020, she launched her private service, Oxford Menopause.</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Agenda:</strong></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">09.15 - Coffee and Registration</div><div fr-original-style="" style="box-sizing: border-box;">09.30 - Introduction and Course Objectives</div><div fr-original-style="" style="box-sizing: border-box;">09.40 - Physiology, Diagnosis, and Principles of Treatment</div><div fr-original-style="" style="box-sizing: border-box;">10.45 - Coffee</div><div fr-original-style="" style="box-sizing: border-box;">11.00 - Risks, Benefits, and Special Considerations (e.g., Premature Ovarian Insufficiency)</div><div fr-original-style="" style="box-sizing: border-box;">13.00 - Lunch</div><div fr-original-style="" style="box-sizing: border-box;">14.00 - Practical Prescribing and Common Pitfalls</div><div fr-original-style="" style="box-sizing: border-box;">14.30 - Vulvo-Vaginal Symptoms and Testosterone</div><div fr-original-style="" style="box-sizing: border-box;">14.30 - Case Studies and Q&amp;A</div><div fr-original-style="" style="box-sizing: border-box;">15.30 - Discussion and Sharing Good Practice - Close</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">Learning Outcomes:</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">1. Stay Current with Menopausal Evidence: Develop an up-to-date awareness of the latest evidence and clinical guidance concerning menopausal issues and treatment options.</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">2. Foster Critical Patient Discussions: Demonstrate a critical understanding of key discussion points with patients, enabling more informed and productive consultations.</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">3. Problem-Solving Skills: Engage in discussions about relevant practice problems and collaboratively explore solutions within the context of menopause care.</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">4. Values and Attitudes: Develop an awareness of how personal attitudes and values may influence practice in menopause care, fostering a more patient-centric approach.</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">5. Professional Accountability: Understand the ongoing development of practice in the field of menopause care and embrace professional accountability as an integral aspect of providing high-quality care.</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">6. Navigating NICE Guidance: Gain a comprehensive understanding of the NICE Guidance, empowering practitioners to align their practice with established best practices.</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">Please note: Course content may be subject to minor updates and adjustments.</div><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>

BBO Training

Clinical

Menopause Update

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>This course is intended for IT Professionals who are already experienced in general Windows Server, Windows client, Azure, and Microsoft 365 administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of PowerShell or any scripting language is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Microsoft Exchange Server, Microsoft SharePoint Server, and Microsoft SQL Server.</p><p></p><p></p><p>This course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches.</p><p></p>Prerequisites<p>Before attending this course, students must have: </p><ul><li>-Experience with Windows networking technologies and implementation.</li> <li>- Experience with Windows Server administration, maintenance, and troubleshooting.</li></ul><p></p></div><div id="course-pills-2"><h3>1 - Review Windows PowerShell</h3> <ul> <li>Learn about Windows PowerShell</li> <li>Get familiar with Windows PowerShell applications</li> <li>Identify factors to install and use Windows PowerShell</li> <li>Configure the Windows PowerShell console</li> <li>Configure the Windows PowerShell Integrated Scripting Environment (ISE)</li> <li>Use Visual Studio Code with PowerShell</li> </ul> <h3>2 - Understand the command syntax in Windows PowerShell</h3> <ul> <li>Discover the structure of PowerShell cmdlets</li> <li>Discover the parameters for using PowerShell cmdlets</li> <li>Review the tab completion feature in PowerShell</li> <li>Display the About files content in PowerShell</li> </ul> <h3>3 - Find commands and Get-Help in Windows PowerShell</h3> <ul> <li>Define modules in PowerShell</li> <li>Find cmdlets in PowerShell</li> <li>Use command aliases in PowerShell</li> <li>Use Show-Command and Get-Help in PowerShell</li> <li>Interpret the help file contents and update the local help content in PowerShell</li> </ul> <h3>4 - Manage Active Directory Domain Services using PowerShell cmdlets</h3> <ul> <li>Manage user accounts in PowerShell</li> <li>Manage groups and group memberships in PowerShell</li> <li>Manage computer accounts in PowerShell</li> <li>Manage organizational units and Active Directory objects in PowerShell</li> </ul> <h3>5 - Manage network service settings for Windows devices using PowerShell cmdlets</h3> <ul> <li>Manage IP addresses in PowerShell</li> <li>Manage IP routing in PowerShell</li> <li>Manage DNS clients in PowerShell</li> <li>Manage Windows Firewall settings in PowerShell</li> </ul> <h3>6 - Manage Windows Server settings using PowerShell cmdlets</h3> <ul> <li>Automate management tasks using the Group Policy management cmdlets</li> <li>Manage server roles and services using PowerShell cmdlets</li> <li>Manage Hyper-V Virtual Machines using PowerShell cmdlets</li> <li>Manage Internet Information Services using PowerShell cmdlets</li> </ul> <h3>7 - Manage settings for a local Windows machine using PowerShell cmdlets</h3> <ul> <li>Manage Windows 10 using PowerShell</li> <li>Manage permissions with PowerShell</li> </ul> <h3>8 - Understand the Windows PowerShell pipeline</h3> <ul> <li>Review Windows PowerShell pipeline and its output</li> <li>Discover object members in PowerShell</li> <li>Control the formatting of pipeline output</li> </ul> <h3>9 - Select, sort, and measure objects using the pipeline</h3> <ul> <li>Sort and group objects by property in the pipeline</li> <li>Measure objects in the pipeline</li> <li>Select a set of objects in the pipeline</li> <li>Select object properties in the pipeline</li> <li>Create and format calculated properties in the pipeline</li> </ul> <h3>10 - Filter objects out of the pipeline</h3> <ul> <li>Learn about the comparison operators in PowerShell</li> <li>Review basic filter syntax in the pipeline</li> <li>Review advanced filter syntax in the pipeline</li> <li>Optimize the filter performance in the pipeline</li> </ul> <h3>11 - Enumerate objects in the pipeline</h3> <ul> <li>Learn about enumerations in the pipeline</li> <li>Review basic syntax to enumerate objects in the pipeline</li> <li>Review advanced syntax to enumerate objects in the pipeline</li> </ul> <h3>12 - Send and pass data as output from the pipeline</h3> <ul> <li>Write pipeline data to a file</li> <li>Convert pipeline objects to other forms of data representation in PowerShell</li> <li>Control additional output options in PowerShell</li> </ul> <h3>13 - Pass pipeline objects</h3> <ul> <li>Pipeline parameter binding</li> <li>Identify ByValue parameters</li> <li>Pass data by using ByValue</li> <li>Pass data by using ByPropertyName</li> <li>Identify ByPropertyName parameters</li> <li>Use manual parameters to override the pipeline</li> <li>Use parenthetical commands</li> <li>Expand property values</li> </ul> <h3>14 - Connect with data stores using PowerShell providers</h3> <ul> <li>Define Windows PowerShell providers</li> <li>Review the built-in providers in PowerShell</li> <li>Access provider help in PowerShell</li> </ul> <h3>15 - Use PowerShell drives in PowerShell</h3> <ul> <li>Explain PowerShell drives in PowerShell</li> <li>Use PowerShell drive cmdlets in PowerShell</li> <li>Manage the file system in PowerShell</li> <li>Manage the registry in PowerShell</li> <li>Work with certificates in PowerShell</li> <li>Work with other PowerShell drives in PowerShell</li> </ul> <h3>16 - Review CIM and WMI</h3> <ul> <li>Review architecture of CIM and WMI</li> <li>Review repositories in CIM and WMI</li> <li>Locate online class documentation by using CIM and WMI cmdlets</li> </ul> <h3>17 - Query configuration information by using CIM and WMI</h3> <ul> <li>List local repository namespaces and classes by using CIM and WMI</li> <li>Query instances by using commands and WMI Query Language</li> <li>Connect to remote computers by using CIM and WMI cmdlets</li> <li>Query repository classes from remote computers by using CIMSession objects</li> </ul> <h3>18 - Query and manipulate repository objects by using CIM and WMI methods</h3> <ul> <li>Discover methods of repository objects by using CIM and WMI</li> <li>Locate class methods and documentation by using CIM and WMI</li> <li>Invoke methods of repository objects by using CIM and WMI</li> </ul> <h3>19 - Manage variables in Windows PowerShell scripts</h3> <ul> <li>Define variables in Windows PowerShell scripts</li> <li>Create variable names in Windows PowerShell scripts</li> <li>Assign values and types to variables in Windows PowerShell scripts</li> <li>Identify the methods and properties of variables in Windows PowerShell scripts</li> <li>Use string variables and methods in Windows PowerShell scripts</li> <li>Use date variables and methods in Windows PowerShell scripts</li> </ul> <h3>20 - Work with arrays and hash tables in Windows PowerShell scripts</h3> <ul> <li>Define an array in Windows PowerShell scripts</li> <li>Work with array lists in Windows PowerShell scripts</li> <li>Define hash tables in Windows PowerShell Scripts</li> <li>Work with hash tables in Windows PowerShell scripts</li> </ul> <h3>21 - Create and run scripts by using Windows PowerShell</h3> <ul> <li>Review Windows PowerShell scripts</li> <li>Modify scripts in the PowerShell Gallery</li> <li>Create scripts using Windows PowerShell</li> <li>Review the PowerShellGet module in Windows PowerShell</li> <li>Run scripts and set the execution policy in Windows PowerShell</li> <li>Review Windows PowerShell and AppLocker</li> <li>Sign the scripts digitally in Windows PowerShell</li> </ul> <h3>22 - Work with scripting constructs in Windows PowerShell</h3> <ul> <li>Review and use the ForEach loop in Windows PowerShell scripts</li> <li>Review and use the If construct in Windows PowerShell scripts</li> <li>Review and use the Switch construct in Windows PowerShell scripts</li> <li>Review the For construct in Windows PowerShell scripts</li> <li>Review other loop constructs in Windows PowerShell scripts</li> <li>Review Break and Continue in Windows PowerShell scripts</li> </ul> <h3>23 - Import data in different formats for use in scripts by using Windows PowerShell cmdlets</h3> <ul> <li>Use the Get-Content command in Windows PowerShell scripts</li> <li>Use the Import-Csv cmdlet in Windows PowerShell scripts</li> <li>Use the Import-Clixml cmdlet in Windows PowerShell scripts</li> <li>Use the ConvertFrom-Json cmdlet in Windows PowerShell scripts</li> </ul> <h3>24 - Use methods to accept user inputs in Windows PowerShell scripts</h3> <ul> <li>Identify values that might change in Windows PowerShell scripts</li> <li>Use the Read-Host cmdlet in Windows PowerShell scripts</li> <li>Use the Get-Credential cmdlet in Windows PowerShell scripts</li> <li>Use the Out-GridView cmdlet in Windows PowerShell scripts</li> <li>Pass parameters to a Windows PowerShell script</li> </ul> <h3>25 - Troubleshoot scripts and handle errors in Windows PowerShell</h3> <ul> <li>Interpret error messages generated for Windows PowerShell commands</li> <li>Add output to Windows PowerShell scripts</li> <li>Use breakpoints in Windows PowerShell scripts</li> <li>Interpret error actions for Windows PowerShell commands</li> </ul> <h3>26 - Use functions and modules in Windows PowerShell scripts</h3> <ul> <li>Review functions in Windows PowerShell scripts</li> <li>Use variable scope in Windows PowerShell scripts</li> <li>Create modules in Windows PowerShell scripts</li> <li>Use the dot sourcing feature in Windows PowerShell</li> </ul> <h3>27 - Manage single and multiple computers by using Windows PowerShell remoting</h3> <ul> <li>Review the remoting feature of Windows PowerShell</li> <li>Compare remoting with remote connectivity</li> <li>Review the remoting security feature of Windows PowerShell</li> <li>Enable remoting by using Windows PowerShell</li> <li>Use one-to-one remoting by using Windows PowerShell</li> <li>Use one-to-many remoting by using Windows PowerShell</li> <li>Compare remoting output with local output</li> </ul> <h3>28 - Use advanced Windows PowerShell remoting techniques</h3> <ul> <li>Review common remoting techniques of Windows PowerShell</li> <li>Send parameters to remote computers in Windows PowerShell</li> <li>Set access protection to variables, aliases, and functions by using the scope modifier</li> <li>Enable multi-hop remoting in Windows PowerShell</li> </ul> <h3>29 - Manage persistent connections to remote computers by using Windows PowerShell sessions</h3> <ul> <li>Review persistent connections in Windows PowerShell</li> <li>Create and manage persistent PSSessions by using Windows PowerShell</li> <li>Disconnect PSSessions by using Windows PowerShell</li> <li>Review the feature of implicit remoting in Windows PowerShell</li> </ul> <h3>30 - Review Azure PowerShell module</h3> <ul> <li>Review Azure PowerShell</li> <li>Review the benefits of the Azure PowerShell module</li> <li>Install the Azure PowerShell module</li> <li>Migrate Azure PowerShell from AzureRM to Azure</li> <li>Review Microsoft Azure Active Directory module for Windows PowerShell and Azure Active Directory PowerShell for Graph modules</li> </ul> <h3>31 - Review the features and tools for Azure Cloud Shell</h3> <ul> <li>Review the characteristics of Azure Cloud Shell</li> <li>Review the features and tools of Azure Cloud Shell</li> <li>Configure and experiment with Azure Cloud Shell</li> </ul> <h3>32 - Manage Azure resources with Windows PowerShell</h3> <ul> <li>Create a new Azure virtual machine by using Windows PowerShell commands</li> <li>Manage Azure virtual machines by using Windows PowerShell commands</li> <li>Manage Azure related storage by using Azure PowerShell</li> <li>Manage Azure subscriptions by using Azure PowerShell</li> </ul> <h3>33 - Manage users, groups, and licenses in Microsoft Entra ID by using Windows PowerShell</h3> <ul> <li>Review benefits to manage Microsoft 365 services by using Windows PowerShell</li> <li>Connect to the Microsoft 365 tenant by using Windows PowerShell</li> <li>Manage users in Microsoft 365 by using Windows PowerShell</li> <li>Manage groups in Microsoft 365 by using Windows PowerShell</li> <li>Manage roles in Microsoft 365 by using Windows PowerShell</li> <li>Manage licenses in Microsoft 365 by using Windows PowerShell</li> </ul> <h3>34 - Manage Exchange Online by using Windows PowerShell</h3> <ul> <li>Connect to Exchange Online by using Windows PowerShell</li> <li>Manage mailboxes in Exchange Online by using Windows PowerShell</li> <li>Manage resources in Exchange Online by using Windows PowerShell</li> <li>Manage admin roles in Exchange Online by using Windows PowerShell</li> </ul> <h3>35 - Manage SharePoint Online by using Windows PowerShell</h3> <ul> <li>Install and connect to SharePoint Online Management Shell by using Windows PowerShell</li> <li>Manage SharePoint Online users and groups by using Windows PowerShell</li> <li>Manage SharePoint sites by using Windows PowerShell</li> <li>Manage SharePoint Online external user sharing by using Windows PowerShell</li> </ul> <h3>36 - Manage Microsoft Teams by using Windows PowerShell</h3> <ul> <li>Review Microsoft Teams PowerShell module</li> <li>Install the Microsoft Teams PowerShell module</li> <li>Manage teams with Microsoft Teams PowerShell module</li> </ul> <h3>37 - Create and manage background jobs using Windows PowerShell</h3> <ul> <li>Define the types of background jobs in Windows PowerShell</li> <li>Start remote jobs and CIM/WMI jobs in Windows PowerShell</li> <li>Monitor jobs in Windows PowerShell</li> <li>Retrieve results for running jobs in Windows PowerShell</li> </ul> <h3>38 - Create and manage scheduled jobs using Windows PowerShell</h3> <ul> <li>Create and run Windows PowerShell scripts as scheduled tasks</li> <li>Define scheduled jobs in Windows PowerShell</li> <li>Create job option and job trigger objects in Windows PowerShell</li> <li>Create and register a scheduled job in Windows PowerShell</li> <li>Retrieve the results from a scheduled job in Windows PowerShell</li> </ul></div>

Nexus Human

Azure PowerShell

Powershell

Microsoft AZ-104

Power Automate

Microsoft AZ-303

Microsoft Power Automate

AZ-040T00 Automating Administration with Powershell

Bournemouth

London Waterloo Academy

Flight Attendant

Stewardess

FLIGHT ATTENDANT VIRTUAL VIA ZOOM COURSE, EVENINGS

Registration Fee

Course Fee

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">This live virtual <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">Agility in HR (ICP-AHR) Training &amp; Certification Program</span></strong> enables the participants to learn:</span></p><ol fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">How to <u fr-original-style="" style="box-sizing: border-box;">adopt and apply agile principles, values, and methodologies within the HR department</u> itself &ndash; <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">&ldquo;<span style="color: rgb(147, 101, 184); box-sizing: border-box;" fr-original-style="color: rgb(147, 101, 184);">Agile for HR</span>.&rdquo;</em></strong> &ndash; and</li><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">The <u fr-original-style="" style="box-sizing: border-box;">role of HR in facilitating and supporting the adoption of Agile practices and principles across the organization</u> &ndash; <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">&ldquo;<span style="color: rgb(147, 101, 184); box-sizing: border-box;" fr-original-style="color: rgb(147, 101, 184);">HR for Agile</span>.&rdquo;</em></strong></li></ol><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">During this&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">live-immersive interactive workshop</span></strong>, participants will learn&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">essential concepts</strong>&nbsp;related to&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">&ldquo;Agile for HR&rdquo;</em></strong>&nbsp;through&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);">practical, easy-to-follow, hands-on exercises</span></strong>. By actively participating, attendees will develop a comprehensive understanding of:</span></p><ol fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Agile HR processes:</strong>&nbsp;adopting iterative and incremental approaches to HR processes like performance management, recruitment, and onboarding.</li><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Agile HR project management:</strong>&nbsp;This involves using Agile project management frameworks (e.g., Scrum or Kanban) to manage HR initiatives.</li><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Cross-functional collaboration:</strong>&nbsp;Promoting collaboration between HR and other departments using Agile principles, such as self-organizing teams and regular feedback loops.</li></ol><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Throughout the course, participants will&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">acquire knowledge</strong>&nbsp;on&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">&ldquo;HR for Agile&rdquo;</em></strong>&nbsp;and&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);">gain the ability to facilitate and support agile transformation within their organization</span></strong>. The training program includes&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);">relevant case studies, useful tools, and effective techniques related to</span>:</strong></span></p><ol fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Agile talent acquisition:</strong>&nbsp;Implementing recruitment strategies prioritizing individuals with an Agile mindset and values.</li><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Agile performance management:</strong>&nbsp;shifting to Agile-friendly approaches such as continuous feedback and frequent check-ins.</li><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Agile Learning and Development:</strong>&nbsp;Providing training programs that equip employees with Agile skills and mindsets.</li><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Agile organizational design:</strong>&nbsp;collaborating on restructuring the organization to support Agile practices like cross-functional teams and autonomy.</li></ol><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(65, 168, 95); box-sizing: border-box;" fr-original-style="color: rgb(65, 168, 95);">Bonus Module:</span></strong><span style="color: rgb(65, 168, 95); box-sizing: border-box;" fr-original-style="color: rgb(65, 168, 95);"> </span><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(65, 168, 95); box-sizing: border-box;" fr-original-style="color: rgb(65, 168, 95);"><u fr-original-style="" style="box-sizing: border-box;">Enhancing HR Agility with AI &amp; Analytics:</u></span>&nbsp;</em></strong>This module explores the integration of AI and analytics to revolutionize HR practices, aligning them with agile principles. Participants will learn how these technologies can automate tasks, enhance decision-making, and support agile transformations across the organization. Through focused examples, the session highlights the impact on recruitment, performance management, and overall HR efficiency, offering a forward-looking approach to agile HR management.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">This course will be delivered through <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">live virtual sessions via Zoom</span></strong>.&nbsp;<span style="font-size: 14px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 14px;">There are the following dates on which you can opt for this course:</span></span></p><ol fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR | 8-10 Apr | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</span></li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR | 13-15 May | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</span></li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR | 12-14 Jun | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</span></li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR | 22-24 Jul | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</span></li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR | 14-16 Aug | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</span></li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR | 16-18 Sep | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</span></li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR | 9-11 Oct | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</span></li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR | 18-20 Nov | 9 am - 2 pm GMT | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</span></li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR | 18-20 Dec | 9 am - 2 pm GMT | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</span></li></ol><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">The following are the links to the<span style="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);"> <u fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">essential documents</strong></u></span> that will help you make an informed decision:<br fr-original-style="" style="box-sizing: border-box;"></span></div><ol fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Detailed <span style="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);">course brochure</span>: </strong><a href="https://drive.google.com/file/d/1PARAqO_uN8WLtXb8e6OKoawB60afNwJ_/view?usp=drive_link" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(147, 101, 184); box-sizing: border-box;" fr-original-style="color: rgb(147, 101, 184);">Click Here</span></strong></a><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;or download via the link below:&nbsp;</strong></div></li></ol><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><a href="https://drive.google.com/file/d/1PARAqO_uN8WLtXb8e6OKoawB60afNwJ_/view?usp=drive_link" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">https://drive.google.com/file/d/1PARAqO_uN8WLtXb8e6OKoawB60afNwJ_/view?usp=drive_link</span></a><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">&nbsp;</span></strong></div></li></ul><ol fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(243, 121, 52); box-sizing: border-box;" fr-original-style="color: rgb(243, 121, 52);">Testimonials</span> from global HR professionals: </strong><a href="https://drive.google.com/file/d/1wYNCJAMiNQeeihcluQEY5JdBkjgYtW6S/view?usp=drive_link" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(147, 101, 184); box-sizing: border-box;" fr-original-style="color: rgb(147, 101, 184);">Click Here</span></strong></a><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;or download via the link below:&nbsp;</strong></div></li></ol><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><a href="https://drive.google.com/file/d/1wYNCJAMiNQeeihcluQEY5JdBkjgYtW6S/view?usp=drive_link" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">https://drive.google.com/file/d/1wYNCJAMiNQeeihcluQEY5JdBkjgYtW6S/view?usp=drive_link</span></a><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">&nbsp;</span></div></li></ul>

ValueX2

https://www.valuex2.com/agile-hr-certification/
https://www.linkedin.com/company/80563537/

ICAgile's Agility in HR (ICP-AHR) Training & Certification Program by ValueX2 | 3 days - 5 hrs/day | 9 am - 2 pm UK Time

<h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">LEARN TO FOCUS ON INTERPERSONAL SKILLS, BEHAVIOR, AND ENVIRONMENT AND HOW TO PROMOTE DIVERSITY-POSITIVE INTERACTIONS.</h3><div style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">You will be able to focus on interpersonal skills, behavior, and environment, to see how they promote diversity-positive interactions, as well as learn causes for discriminatory practices and create an action plan for increasing workplace acceptance and harmony.</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);"><b fr-original-style="" style="box-sizing: border-box;">Uncover and discard beliefs and attitudes that foster or block progress</b>. By discovering your strengths as well as liabilities, you can build on the positive and move toward minimizing the negative. As a result, you will gain greater personal and professional satisfaction.</p><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">PART I &ndash; BROADENING THE VIEW</h3>&nbsp;<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Find new perspectives and ways to turn challenges into opportunities. Become skilled at ways to further develop self-awareness and sensitivity.</p><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">PART II &ndash; FAIR STANDARDS</h3>&nbsp;<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Learn about how attitudes expressed in speech and behavior promote or hinder a positive work environment. Determine and apply steps for getting past prejudice for greater productivity.</p><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">PART III &ndash; ORGANIZATIONAL UNITY</h3>&nbsp;<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Discover value in diverse perspectives and personalities and their benefits. Strategize ways to strengthen relationships and turn negative into positive interactions.</p><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ATTENDEES&nbsp;WILL BE ABLE TO:</strong></h3>&nbsp;<ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Discover new ways to &ldquo;see things differently;&rdquo;</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Use Emotional Intelligence to strengthen relationships and increase awareness of self and others;</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Define Diversity and uncover ways in which it is significantly useful in an organization;</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Develop best practices (rooted in honor and law) to use Diversity in planning, problem solving, and decision-making);</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Manage conflict through unity, using the organization&rsquo;s mission, vision, values, and goals; and</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Understand and communicate value to staff.</li></ul><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><i style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Online Class&mdash;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Diversity &ndash; Building a Thriving Business Environment</strong>&nbsp;is a 4-hour interactive virtual class.&nbsp;</i></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);">&nbsp;</p><h6 style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Register for this class and you will be sent ONLINE login instructions prior to the class date.</h6></div><div style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><br fr-original-style="" style="box-sizing: border-box;"></div><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><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);">Improving Communications brought our organization to realize how important our employees&mdash;our people&mdash;are to Baystate Dental. By helping us to develop a more thoughtful and sensitive nature, we now relate better with each other and our patients.</p><span style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style="color: rgb(33, 37, 41);">Dr. Kevin Coughlin, DMD, FAGD, MBA</span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Baystate Dental</span>

LEARN TO FOCUS ON INTERPERSONAL SKILLS, BEHAVIOR, AND ENVIRONMENT AND HOW TO PROMOTE DIVERSITY-POSITIVE INTERACTIONS.
You will be able to focus on interpersonal skills, behavior, and environment, to see how they promote diversity-positive interactions, as well as learn causes for discriminatory practices and create an action plan for increasing workplace acceptance and harmony.
Uncover and discard beliefs and attitudes that foster or block progress. By discovering your strengths as well as liabilities, you can build on the positive and move toward minimizing the negative. As a result, you will gain greater personal and professional satisfaction.
PART I – BROADENING THE VIEW
Find new perspectives and ways to turn challenges into opportunities. Become skilled at ways to further develop self-awareness and sensitivity.
PART II – FAIR STANDARDS
Learn about how attitudes expressed in speech and behavior promote or hinder a positive work environment. Determine and apply steps for getting past prejudice for greater productivity.
PART III – ORGANIZATIONAL UNITY
Discover value in diverse perspectives and personalities and their benefits. Strategize ways to strengthen relationships and turn negative into positive interactions.
ATTENDEES WILL BE ABLE TO:
Discover new ways to “see things differently;”
Use Emotional Intelligence to strengthen relationships and increase awareness of self and others;
Define Diversity and uncover ways in which it is significantly useful in an organization;
Develop best practices (rooted in honor and law) to use Diversity in planning, problem solving, and decision-making);
Manage conflict through unity, using the organization’s mission, vision, values, and goals; and
Understand and communicate value to staff.
Online Class—Diversity – Building a Thriving Business Environment is a 4-hour interactive virtual class. 
 
Register for this class and you will be sent ONLINE login instructions prior to the class date.



Improving Communications brought our organization to realize how important our employees—our people—are to Baystate Dental. By helping us to develop a more thoughtful and sensitive nature, we now relate better with each other and our patients.
Dr. Kevin Coughlin, DMD, FAGD, MBABaystate Dental

Improving Communications Uk

DIVERSITY – BUILDING A THRIVING BUSINESS ENVIRONMENT

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.</p><p></p><p></p><p>This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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>

Learning & Development

Design & Technology Courses (DT)

Data Skills

Trainers Course

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

<div data-testid="summary" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Understand and mitigate your own personal drivers of conflict</strong></p><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Have you ever said &#39;They really push my buttons&#39; or &#39;I can&#39;t stand it when people...&#39;?</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">That&#39;s the sound of you being &#39;hooked&#39;. We all have values that we want to live by, and when they are challenged, that&#39;s when we are most likely to engage in a conflict.&nbsp;</p><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;">In this online workshop, Gemma will teach you the conflict hooks model so that you can identify your common hooks and how to handle them to reduce or prevent conflict.&nbsp;</span></p><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;">What you will get from this 60-minute session:</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Self-awareness of your conflict hooks</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Empathy for what may hook others</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Confidence to diplomatically speak about conflict with others</li></ul><p 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;">How we will do it:</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Exploration of how conflict hooks show up in teams</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learning how core values are inherent to conflict hooks</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Identifying your own conflict hooks</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Practice articulating your conflict hooks to others</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Tips for how to use your self awareness to reduce or prevent conflict</li></ul></span><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);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">This online session is designed to be as interactive or passive as you wish. You are most welcome to ask questions, share challenges and discuss your ideas. You are equally we</span>lcome to join with your camera off and just listen in.</span></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><span style="color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">This session will be held on zoom &ndash; you will receive the meeting link once you book your place.</span></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><span style="color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">________</span></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><span style="color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">Meet your trainer:</span></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><span style="color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">Hi, I&rsquo;m Gemma Perella; a Personal Development Trainer and founder of The Self Leadership Initiative. The SLI is all about helping you to develop young leaders.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">As a teenager in 2006 I stumbled across a leadership training programme that changed my life. I went from an introverted outsider to a confident and driven educator. Ever since, my mission has been inspiring and empowering young people to become the best versions of themselves.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">Over the last 9 years I&#39;ve been working with organisations that support young people. I deliver interactive and practical training programmes to equip students with the kinds of skills &lsquo;they don&rsquo;t teach you in school&rsquo; in order to help them become the confident, resilient and emotionally intelligent leaders that the world needs.</span></p></div><div data-testid="organizerBrief" fr-original-style="" style="box-sizing: border-box;"><div data-testid="creator-signal-main-section" fr-original-style="" style="box-sizing: border-box;"><section data-testid="simplified-organizer-info" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></section></div></div><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>

Understand and mitigate your own personal drivers of conflict



Have you ever said 'They really push my buttons' or 'I can't stand it when people...'?
That's the sound of you being 'hooked'. We all have values that we want to live by, and when they are challenged, that's when we are most likely to engage in a conflict. 
In this online workshop, Gemma will teach you the conflict hooks model so that you can identify your common hooks and how to handle them to reduce or prevent conflict. 
What you will get from this 60-minute session:
Self-awareness of your conflict hooks
Empathy for what may hook others
Confidence to diplomatically speak about conflict with others
How we will do it:
Exploration of how conflict hooks show up in teams
Learning how core values are inherent to conflict hooks
Identifying your own conflict hooks
Practice articulating your conflict hooks to others
Tips for how to use your self awareness to reduce or prevent conflict
This online session is designed to be as interactive or passive as you wish. You are most welcome to ask questions, share challenges and discuss your ideas. You are equally welcome to join with your camera off and just listen in.
This session will be held on zoom – you will receive the meeting link once you book your place.
________
Meet your trainer:
Hi, I’m Gemma Perella; a Personal Development Trainer and founder of The Self Leadership Initiative. The SLI is all about helping you to develop young leaders.

As a teenager in 2006 I stumbled across a leadership training programme that changed my life. I went from an introverted outsider to a confident and driven educator. Ever since, my mission has been inspiring and empowering young people to become the best versions of themselves.

Over the last 9 years I've been working with organisations that support young people. I deliver interactive and practical training programmes to equip students with the kinds of skills ‘they don’t teach you in school’ in order to help them become the confident, resilient and emotionally intelligent leaders that the world needs.



The Self Leadership Initiative

Conflict Resolution

Leadership Skills

Team Leading

Conflict Management

Team Leader

Conflict

Leadership

Team Management

Leadership Development

Understand and mitigate your own personal drivers of conflict

What are your conflict hooks?

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam.</p><p></p><p></p><p>This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using KeyVault and Managed Identities. Students will also learn how to connect to and consume Azure services and third-party services, and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions.</p><p></p>Prerequisites<p>To be successful in this course, learners should have the following: Hands-on experience with Azure IaaS and PaaS solutions, and the Azure Portal. Experience writing in an Azure supported language at the intermediate level. (C#, JavaScript, Python, or Java) Ability to write code to connect and perform operations on, a SQL or NoSQL database product. (SQL Server, Oracle, MongoDB, Cassandra or similar) Experience writing code to handle authentication, authorization, and other security principles at the intermediate level. A general understanding of HTML, the HTTP protocol and REST API interfaces.</p></div><div id="course-pills-2"><h3>1 - Explore Azure App Service</h3> <ul> <li>Examine Azure App Service</li> <li>Examine Azure App Service plans</li> <li>Deploy to App Service</li> <li>Explore authentication and authorization in App Service</li> <li>Discover App Service networking features</li> </ul> <h3>2 - Configure web app settings</h3> <ul> <li>Configure application settings</li> <li>Configure general settings</li> <li>Configure path mappings</li> <li>Enable diagnostic logging</li> <li>Configure security certificates</li> </ul> <h3>3 - Scale apps in Azure App Service</h3> <ul> <li>Examine autoscale factors</li> <li>Identify autoscale factors</li> <li>Enable autoscale in App Service</li> <li>Explore autoscale best practices</li> </ul> <h3>4 - Explore Azure App Service deployment slots</h3> <ul> <li>Explore staging environments</li> <li>Examine slot swapping</li> <li>Swap deployment slots</li> <li>Route traffic in App Service</li> </ul> <h3>5 - Explore Azure Functions</h3> <ul> <li>Discover Azure Functions</li> <li>Compare Azure Functions hosting options</li> <li>Scale Azure Functions</li> </ul> <h3>6 - Develop Azure Functions</h3> <ul> <li>Explore Azure Functions development</li> <li>Create triggers and bindings</li> <li>Connect functions to Azure services</li> </ul> <h3>7 - Explore Azure Blob storage</h3> <ul> <li>Explore Azure Blob storage</li> <li>Discover Azure Blob storage resource types</li> <li>Explore Azure Storage security features</li> <li>Discover static website hosting in Azure Storage</li> </ul> <h3>8 - Manage the Azure Blob storage lifecycle</h3> <ul> <li>Explore the Azure Blob storage lifecycle</li> <li>Discover Blob storage lifecycle policies</li> <li>Implement Blob storage lifecycle policies</li> <li>Rehydrate blob data from the archive tier</li> </ul> <h3>9 - Work with Azure Blob storage</h3> <ul> <li>Explore Azure Blob storage client library</li> <li>Create a client object</li> <li>Manage container properties and metadata by using .NET</li> <li>Set and retrieve properties and metadata for blob resources by using REST</li> </ul> <h3>10 - Explore Azure Cosmos DB</h3> <ul> <li>Identify key benefits of Azure Cosmos DB</li> <li>Explore the resource hierarchy</li> <li>Explore consistency levels</li> <li>Choose the right consistency level</li> <li>Explore supported APIs</li> <li>Discover request units</li> </ul> <h3>11 - Work with Azure Cosmos DB</h3> <ul> <li>Explore Microsoft .NET SDK v3 for Azure Cosmos DB</li> <li>Create stored procedures</li> <li>Create triggers and user-defined functions</li> <li>Explore change feed in Azure Cosmos DB</li> </ul> <h3>12 - Manage container images in Azure Container Registry</h3> <ul> <li>Discover the Azure Container Registry</li> <li>Explore storage capabilities</li> <li>Build and manage containers with tasks</li> <li>Explore elements of a Dockerfile</li> </ul> <h3>13 - Run container images in Azure Container Instances</h3> <ul> <li>Explore Azure Container Instances</li> <li>Run containerized tasks with restart policies</li> <li>Set environment variables in container instances</li> <li>Mount an Azure file share in Azure Container Instances</li> </ul> <h3>14 - Implement Azure Container Apps</h3> <ul> <li>Explore Azure Container Apps</li> <li>Explore containers in Azure Container Apps</li> <li>Implement authentication and authorization in Azure Container Apps</li> <li>Manage revisions and secrets in Azure Container Apps</li> <li>Explore Dapr integration with Azure Container Apps</li> </ul> <h3>15 - Explore the Microsoft identity platform</h3> <ul> <li>Explore the Microsoft identity platform</li> <li>Explore service principals</li> <li>Discover permissions and consent</li> <li>Discover conditional access</li> </ul> <h3>16 - Implement authentication by using the Microsoft Authentication Library</h3> <ul> <li>Explore the Microsoft Authentication Library</li> <li>Initialize client applications</li> </ul> <h3>17 - Implement shared access signatures</h3> <ul> <li>Discover shared access signatures</li> <li>Choose when to use shared access signatures</li> <li>Explore stored access policies</li> </ul> <h3>18 - Explore Microsoft Graph</h3> <ul> <li>Discover Microsoft Graph</li> <li>Query Microsoft Graph by using REST</li> <li>Query Microsoft Graph by using SDKs</li> <li>Apply best practices to Microsoft Graph</li> </ul> <h3>19 - Implement Azure Key Vault</h3> <ul> <li>Explore Azure Key Vault</li> <li>Discover Azure Key Vault best practices</li> <li>Authenticate to Azure Key Vault</li> </ul> <h3>20 - Implement managed identities</h3> <ul> <li>Explore managed identities</li> <li>Discover the managed identities authentication flow</li> <li>Configure managed identities</li> <li>Acquire an access token</li> </ul> <h3>21 - Implement Azure App Configuration</h3> <ul> <li>Explore the Azure App Configuration service</li> <li>Create paired keys and values</li> <li>Manage application features</li> <li>Secure app configuration data</li> </ul> <h3>22 - Explore API Management</h3> <ul> <li>Discover the API Management service</li> <li>Explore API gateways</li> <li>Explore API Management policies</li> <li>Create advanced policies</li> <li>Secure APIs by using subscriptions</li> <li>Secure APIs by using certificates</li> </ul> <h3>23 - Explore Azure Event Grid</h3> <ul> <li>Explore Azure Event Grid</li> <li>Discover event schemas</li> <li>Explore event delivery durability</li> <li>Control access to events</li> <li>Receive events by using webhooks</li> <li>Filter events</li> </ul> <h3>24 - Explore Azure Event Hubs</h3> <ul> <li>Discover Azure Event Hubs</li> <li>Explore Event Hubs Capture</li> <li>Scale your processing application</li> <li>Control access to events</li> <li>Perform common operations with the Event Hubs client library</li> </ul> <h3>25 - Discover Azure message queues</h3> <ul> <li>Choose a message queue solution</li> <li>Explore Azure Service Bus</li> <li>Discover Service Bus queues, topics, and subscriptions</li> <li>Explore Service Bus message payloads and serialization</li> <li>Explore Azure Queue Storage</li> <li>Create and manage Azure Queue Storage and messages by using .NET</li> </ul> <h3>26 - Monitor app performance</h3> <ul> <li>Explore Application Insights</li> <li>Discover log-based metrics</li> <li>Instrument an app for monitoring</li> <li>Select an availability test</li> <li>Troubleshoot app performance by using Application Map</li> </ul> <h3>27 - Develop for Azure Cache for Redis</h3> <ul> <li>Explore Azure Cache for Redis</li> <li>Configure Azure Cache for Redis</li> <li>Interact with Azure Cache for Redis by using .NET</li> </ul> <h3>28 - Develop for storage on CDNs</h3> <ul> <li>Explore Azure Content Delivery Networks</li> <li>Control cache behavior on Azure Content Delivery Networks</li> <li>Interact with Azure Content Delivery Networks by using .NET</li> </ul></div>

Microsoft AZ-900

Microsoft Azure

Microsoft AZ-700

AWS Certified Solutions Architect

AZ-204T00 Developing Solutions for Microsoft Azure

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p></p><p>The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.</p><p></p><p></p><p>This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.</p><p></p>Prerequisites<p></p><li>Understanding core data concepts.</li>  <li>Knowledge of working with relational data in the cloud.</li>  <li>Knowledge of working with non-relational data in the cloud.</li>   <li>Knowledge of data analysis and visualization concepts.</li>   <li>DP-900T00 Microsoft Azure Data Fundamentals is recommended<p></p></li></div><div id="course-pills-2"><h3>1 - Discover data analysis</h3> <ul> <li>Overview of data analysis</li> <li>Roles in data</li> <li>Tasks of a data analyst</li> </ul> <h3>2 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>3 - Get data in Power BI</h3> <ul> <li>Get data from files</li> <li>Get data from relational data sources</li> <li>Create dynamic reports with parameters</li> <li>Get data from a NoSQL database</li> <li>Get data from online services</li> <li>Select a storage mode</li> <li>Get data from Azure Analysis Services</li> <li>Fix performance issues</li> <li>Resolve data import errors</li> </ul> <h3>4 - Clean, transform, and load data in Power BI</h3> <ul> <li>Shape the initial data</li> <li>Simplify the data structure</li> <li>Evaluate and change column data types</li> <li>Combine multiple tables into a single table</li> <li>Profile data in Power BI</li> <li>Use Advanced Editor to modify M code</li> </ul> <h3>5 - Design a semantic model in Power BI</h3> <ul> <li>Work with tables</li> <li>Create a date table</li> <li>Work with dimensions</li> <li>Define data granularity</li> <li>Work with relationships and cardinality</li> <li>Resolve modeling challenges</li> </ul> <h3>6 - Add measures to Power BI Desktop models</h3> <ul> <li>Create simple measures</li> <li>Create compound measures</li> <li>Create quick measures</li> <li>Compare calculated columns with measures</li> </ul> <h3>7 - Add calculated tables and columns to Power BI Desktop models</h3> <ul> <li>Create calculated columns</li> <li>Learn about row context</li> <li>Choose a technique to add a column</li> </ul> <h3>8 - Use DAX time intelligence functions in Power BI Desktop models</h3> <ul> <li>Use DAX time intelligence functions</li> <li>Additional time intelligence calculations</li> </ul> <h3>9 - Optimize a model for performance in Power BI</h3> <ul> <li>Review performance of measures, relationships, and visuals</li> <li>Use variables to improve performance and troubleshooting</li> <li>Reduce cardinality</li> <li>Optimize DirectQuery models with table level storage</li> <li>Create and manage aggregations</li> </ul> <h3>10 - Design Power BI reports</h3> <ul> <li>Design the analytical report layout</li> <li>Design visually appealing reports</li> <li>Report objects</li> <li>Select report visuals</li> <li>Select report visuals to suit the report layout</li> <li>Format and configure visualizations</li> <li>Work with key performance indicators</li> </ul> <h3>11 - Configure Power BI report filters</h3> <ul> <li>Apply filters to the report structure</li> <li>Apply filters with slicers</li> <li>Design reports with advanced filtering techniques</li> <li>Consumption-time filtering</li> <li>Select report filter techniques</li> <li>Case study - Configure report filters based on feedback</li> </ul> <h3>12 - Enhance Power BI report designs for the user experience</h3> <ul> <li>Design reports to show details</li> <li>Design reports to highlight values</li> <li>Design reports that behave like apps</li> <li>Work with bookmarks</li> <li>Design reports for navigation</li> <li>Work with visual headers</li> <li>Design reports with built-in assistance</li> <li>Tune report performance</li> <li>Optimize reports for mobile use</li> </ul> <h3>13 - Perform analytics in Power BI</h3> <ul> <li>Explore statistical summary</li> <li>Identify outliers with Power BI visuals</li> <li>Group and bin data for analysis</li> <li>Apply clustering techniques</li> <li>Conduct time series analysis</li> <li>Use the Analyze feature</li> <li>Create what-if parameters</li> <li>Use specialized visuals</li> </ul> <h3>14 - Create and manage workspaces in Power BI</h3> <ul> <li>Distribute a report or dashboard</li> <li>Monitor usage and performance</li> <li>Recommend a development life cycle strategy</li> <li>Troubleshoot data by viewing its lineage</li> <li>Configure data protection</li> </ul> <h3>15 - Manage semantic models in Power BI</h3> <ul> <li>Use a Power BI gateway to connect to on-premises data sources</li> <li>Configure a semantic model scheduled refresh</li> <li>Configure incremental refresh settings</li> <li>Manage and promote semantic models</li> <li>Troubleshoot service connectivity</li> <li>Boost performance with query caching (Premium)</li> </ul> <h3>16 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>17 - Implement row-level security</h3> <ul> <li>Configure row-level security with the static method</li> <li>Configure row-level security with the dynamic method</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-300T00: Microsoft Power BI Data Analyst 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 PL-300T00: Microsoft Power BI Data Analyst 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>

1839 Courses

Strategic Planning For Business Course

By Elearncollege

Corporate Brand Management Course

By Elearncollege

Understanding Emotional Needs of Boys

By Inclusive Solutions

Testing Ruby with RSpec: The Complete Guide

By Packt

Ofqual Regulated Health and Social Care Level 3 & First Aid Training Course

By One Education

Ofqual Regulated Health and Social Care Level 3 & First Aid Training Course

By One Education

C203- THERMAL AND CONDENSATION PERFORMANCE (1/2-DAY)

By CWCT

British Citizenship Diploma - CPD Certified

By Academy for Health and Fitness

Advanced Professional Certificate in Strategic Leadership

By Metropolitan School of Business & Management UK

Job-Ready SQL in an Afternoon

By Packt

Search By Location