Name: Level 7 Diploma in PR : Public Relation
Price: 12 GBP
Availability: InStock

<p>Do you need help learning SQL programming and effectively managing and manipulating data in relational databases?</p><p>It can be frustrating to feel like you need to make progress or get the results you need from your database queries. With the right skills and knowledge, you may gain valuable insights and opportunities for growth.</p><p>Our SQL Programming online course is the solution you've been looking for. With our comprehensive curriculum and expert instructors, you'll gain the skills and knowledge to confidently create and manipulate databases, design and execute complex queries, and optimize database performance.</p><p>In addition, our hands-on learning experience and practical exercises will enable you to apply your skills to real-world scenarios, giving you the confidence to tackle challenging SQL programming tasks and advance your career.</p><p><strong>Reality Check:</strong> By the end of our course, you'll have the skills and knowledge to make informed decisions based on your findings and drive business success through effective data management and analysis. Don't let SQL programming hold you back - sign up for our course today and take your skills to the next level!</p><p><strong>Expert Support</strong></p><p>Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.</p><p><strong>Key Benefits</strong></p><ul><li>Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.</li><li>Get 24/7 access to all content for a full year.</li><li>Each of our students gets full tutor support on weekdays (Monday to Friday)</li></ul><p>This masterclass Mastering SQL Programming online training course is designed by industry experts and will give you an in-depth understanding of this topic. The course features easy-to-digest modules that break down each topic and ensure all our students receive an unrivalled and thorough learning experience.</p><p>If you want to work in this rapidly growing sector and stand out from the competition, then our Mastering SQL Programming is the perfect place to kickstart your dream career.</p><p>On the Mastering SQL Programming course, we guarantee that you will gain relevant skills and acquire tremendous knowledge on the subject. The certificate you'll achieve after completing the course will help you land the job you want in a related field.</p><p>Enjoy a pleasant and professional 100% online learning experience and enrol in our Mastering SQL Programming today and take control of your career!</p><p><strong>Course Curriculum:</strong></p><p><strong>Unit 01: Introduction</strong></p><ul><li>Introduction</li><li>Tools Used in This Course</li></ul><p><strong>Unit 02: Setting up Course Tools</strong></p><ul><li>Download PostgreSQL</li><li>Install PostgreSQL</li><li>Download SQLectron</li><li>Install SQLectron</li><li>Connect to PostgreSQL - Credentials</li><li>Connect to PostgreSQL Using SQLectron</li><li>Import Course Data Using SQLectron</li><li>FOR WINDOWS 32-BIT USERS: Download, Install, Configure &amp; Import Data</li></ul><p><strong>Unit 03: Browsing &amp; Filtering Data</strong></p><ul><li>Check Imported Data</li><li>What is a Database?</li><li>Data Types</li><li>Finally Some Fun! Extracting Data Based on Requirements</li><li>Filtering Data using WHERE Keyword</li><li>Filter Data by Range Using BETWEEN</li><li>Filter Data by Set of Values Using IN</li><li>Filter Data by Date</li><li>More Filtering by Date</li><li>Another Query Filtering by Date</li><li>Filter Data by Strings</li><li>More Filtering by Strings</li><li>More Filtering by Strings 2</li><li>More Filtering by Strings 3</li><li>How to Ignore Caps when Filtering by String</li></ul><p><strong>Unit 04: Filter Data with AND, OR, NOT Operators</strong></p><ul><li>AND Operator</li><li>OR Operator</li><li>NOT Operator</li><li>AND, OR &amp; NOT Operators: Which Has the Highest Priority?</li></ul><p><strong>Unit 05: Math Operations</strong></p><ul><li>Basic Math Operations</li><li>Modulo Operator</li><li>Calculate The Net Salary for Employees</li><li>Filter Data with Math Equations</li></ul><p><strong>Unit 06: String Concatenation</strong></p><ul><li>Concatenate Strings with '||' Operator</li><li>Concatenate Strings with Numbers</li></ul><p><strong>Unit 07: Tidy Up Your Results: Sorting, Alias Names, Limit Records</strong></p><ul><li>Give Your Report Fields A Cool Name</li><li>A Report for Payroll</li><li>Order Records by Column</li><li>Order Records by Multiple Columns</li><li>How Alias Names Cannot Be Used with WHERE</li><li>LIMIT Record Count Fetched by Your Query</li></ul><p><strong>Unit 08: NULL, DISTINCT &amp; CASE Statements</strong></p><ul><li>Fetch A Field's Unique Values Using DISTINCT</li><li>Using DISTINCT Keyword with Multiple Columns</li><li>What is a NULL Value Anyway?</li><li>Build More Sophisticated Queries with CASE Statements</li><li>Your Knowledge So Far Under A Great Test</li></ul><p><strong>Unit 09: Functions in SQL: Multiple-Row Functions</strong></p><ul><li>Let Me Introduce You to Functions</li><li>SUM Function</li><li>AVG (Average) Function</li><li>COUNT Function</li><li>MIN &amp; MAX Functions</li><li>How To Count Your Field's Unique Values</li><li>GROUP BY Clause: Use Functions with Dimensions</li><li>GROUP BY More Than One Dimension</li><li>Now For Some Tough Workout</li><li>Filter By Aggregate Functions with HAVING Clause</li></ul><p><strong>Unit 10: Functions in SQL: Single-Row Functions</strong></p><ul><li>Character Functions - UPPER, LOWER &amp; INITCAP</li><li>Character Functions - CONCAT &amp; LENGTH</li><li>Character Functions - LPAD &amp; RPAD</li><li>Character Functions - TRIM</li><li>Character Functions - REPLACE</li><li>Character Functions - SUBSTR</li><li>Number Functions - MOD &amp; ROUND</li><li>Number Functions - TRUNC</li></ul><p><strong>Unit 11: Nested Queries</strong></p><ul><li>Selectception: A Select Query inside another Select Query!</li></ul><p><strong>Unit 12: Casting &amp; Data Conversion</strong></p><ul><li>Auto Data Conversion</li><li>Cast Date to Character</li><li>Cast Number to Character</li><li>Cast Timestamp to Character</li><li>Cast Character to Number</li><li>Cast Character to Date &amp; Timestamp</li></ul><p><strong>Unit 13: Combination Relationships</strong></p><ul><li>UNION</li><li>UNION ALL</li><li>Important Note about Combining Queries</li><li>INTERSECT</li><li>EXCEPT</li></ul><p><strong>Unit 14: Joins in SQL</strong></p><ul><li>Employees &amp; Departments Tables Revised</li><li>Entity Relationship Diagram (ERD)</li><li>Cartesian Join</li><li>Table Aliases with Joins</li><li>Why I Don't Recommend Cartesian Joins</li><li>Inner Join</li><li>In-Depth Look into Join Types in SQL</li><li>Outer Join - Right, Left &amp; Full</li></ul><p><strong>Unit 15: Data Manipulation (DML)</strong></p><ul><li>INSERT a New Record to a Table</li><li>Insert Without Specifying Column Names</li><li>UPDATE a Record's Field Values</li><li>CAUTION! How an UPDATE Query Can Go Wrong</li><li>Update a Record Using Single-Row Functions</li><li>A Good Exercise: Extract Employee's Email Address</li><li>Solution: Extract Employee's Email Address</li><li>DELETE a Table's Record</li><li>Insert Records with Nested Select Queries</li></ul><p><strong>Unit 16: SQL Data Definition Language (DDL)</strong></p><ul><li>SQL Data Types Revised</li><li>Bookstore Data Set: Let's Move It to Database</li><li>Create Your First Table!</li><li>Insert Data to Your New Table</li><li>Change Column Data Type</li><li>Rename Column</li><li>Add a New Column to Table</li><li>Constraints in SQL</li><li>Primary Keys</li><li>NOT NULL Constraint</li><li>UNIQUE Constraint</li><li>DEFAULT Constraint</li><li>Foreign Keys</li><li>Use Foreign Keys with Joins - Books &amp; Publishers</li><li>Foreign Keys - Properties</li><li>Drop Column</li><li>DROP Table</li><li>Create a New Table with Select Statement</li><li>A Trick to Create an Empty Table with Select Statement</li><li>Insert New Records Using Select Statement</li><li>Views</li><li>Schemas</li><li>Create &amp; Use Schemas</li></ul><p><strong>Course Assessment </strong></p><p>To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%.</p><p>When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme.</p><p><strong>Exam &amp; Retakes:</strong></p><p>It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.</p><p><strong>Certification</strong></p><p>Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).</p><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This Mastering SQL Programming course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This Mastering SQL Programming course is open to all, with no formal entry requirements.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Upon successful completion of the Mastering SQL Programming Course, learners will be equipped with many indispensable skills and have the opportunity to grab, such as:</p><ul><li>SQL Developer</li><li>Database Administrator</li><li>Data Analyst</li><li>Business Intelligence Developer</li><li>Data Engineer</li><li>Data Scientist</li><li>Database Analyst</li><li>ETL Developer</li><li>SQL Server Developer</li><li>Reporting Analyst</li></ul>
                        </div>

One Education

SQL Programming: The SQL Database Programming Fundamentals Complete Training Course

General Admission

<p>The Worry Control with Cognitive Behavioral Therapy at QLS Level 3 is all you need to advance your career in relevant fields.</p><p>Enrol now to discover everything you need to know about the Worry Control with Cognitive Behavioral Therapy at QLS Level 3 and the skills to improve your talents in this field and be confident in your knowledge bucket with One Education as your right hand!</p><p><strong>Meet the Endorsement</strong></p><p>The Quality Licence Scheme has been designed specifically to recognise high-quality courses. This Worry Control with Cognitive Behavioral Therapy at QLS Level 3 course materials are recognised by Quality Licence Scheme (QLS). This ensures the deep research and quality resource allocation behind the development phase of the course. In addition, the QLS certificate enriches your CV and recognises your quality study on the relevant subject.</p><p><strong>Meet the Accreditation</strong></p><p>CPD Quality Standards (CPD QS) accreditation assure the Worry Control with Cognitive Behavioral Therapy at QLS Level 3 course training and learning activities are relevant, reliable, and upto date.</p><p><strong>Expert Support</strong></p><p>Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.</p><p><strong>Key Benefits</strong></p><ul><li>Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.</li><li>Get 24/7 access to all content for a full year.</li><li>Each of our students gets full tutor support on weekdays (Monday to Friday)</li></ul><p><strong>Course Curriculum:</strong></p><ul><li>Unit 01 : Introduction to the Course</li><li>Unit 02 : Uncovering Automatic Thought</li><li>Unit 03 : Changing Patterns of Limited Thinking</li><li>Unit 04 : Changing Hot Thoughts</li><li>Unit 05 : CBT Relaxation Exercise</li><li>Unit 06 : Worry Control</li><li>Unit 07 : Thought Diffusion and Techniques</li><li>Unit 08 : Reconnecting to Values</li><li>Course Conclusion</li></ul><p><strong>ADDITIONAL COURSES</strong></p><p><strong>**Acceptance and Commitment Therapy**</strong></p><ul><li>Unit 01 : Introduction to Acceptance and Commitment Therapy (ACT)</li><li>Unit 02 : ACT Techniques</li></ul><p>**<strong>Counselling and Psychotherapy Level 3</strong>**</p><ul><li>Introduction to the course</li><li>Understanding Psychotherapy</li><li>Starting Psychotherapy Practice</li><li>Your Potential Clients in Therapy</li><li>Different Types of Psychotherapy</li></ul><p>**<strong>Level 2 REBT Therapist Training</strong>**</p><ul><li>Introduction</li><li>REBT: Its Theoretical Principles &amp; Philosophy</li><li>Thinking patterns &amp; Beliefs</li><li>Using REBT for various psychological problems</li><li>How to work as REBT therapist</li></ul><p>**<strong>Meditation &amp; Mindfulness</strong>**</p><ul><li>Introduction &amp; First Concepts</li><li>Understanding &amp; Beating Anxiety</li><li>More Anti-Anxiety Skills &amp; Concepts</li></ul><p>**<strong>Self-Help Psychology: Mental Freedom</strong>**</p><p><strong>Course Assessment </strong></p><p>To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%.</p><p>When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme.</p><p><strong>Certificate of Achievement</strong></p><p><strong>Endorsed Certificate of Achievement from the Quality Licence Scheme</strong></p><p>After successfully completing the Worry Control with Cognitive Behavioral Therapy at QLS Level 3 course, learners will be able to order an endorsed certificate as proof of their achievement. Hardcopy of this certificate of achievement endorsed by the Quality Licence Scheme can be ordered and received straight to your home by post, by paying</p><ul><li>Within the UK: £79</li><li>International: £79 + £10 (postal charge) = £89</li><li>CPD Accredited Certification from One Education</li></ul><p>After successfully completing this Worry Control with Cognitive Behavioral Therapy at QLS Level 3 course, you will qualify for the CPD accredited certificate from One Education. Certification is available in both PDF &amp; hardcopy format, which can be received by paying -</p><ul><li>PDF Certificate: £9</li><li>Hardcopy Certificate (within the UK): £15</li><li>Hardcopy Certificate (international): £15 + £10 (postal charge) = £25</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        120 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 Worry Control with Cognitive Behavioral Therapy at QLS Level 3 course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This Worry Control with Cognitive Behavioral Therapy at QLS Level 3 course is open to all, with no formal entry requirements.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Upon successful completion of the Course, learners will be equipped with many indispensable skills and have the opportunity to grab.</p>
                        </div>

Worry Control with Cognitive Behavioral Therapy at QLS Level 3 Course

<strong>This course teaches you how to use Elementor, one of the most popular plugins for building pages in WordPress, with over a million downloads already. It is fast and comes with a wide variety of widgets and elements that help you build webpages effortlessly without using any code.</strong>
        <p>Are you ready to unlock the full potential of Elementor and elevate your website-building skills to new heights? In this comprehensive course, we will guide you step-by-step through the entire website-building process using the powerful Elementor page builder plugin. Starting with the fundamentals, you will learn how to set up your WordPress website, seamlessly install Elementor, and optimize the general settings for peak performance.

Our hands-on projects will empower you to design two captivating websites from scratch. First, you will create a fully functional travel blog using the free version of Elementor. Explore how to craft engaging sections, integrate compelling videos and images, incorporate Google Maps, and construct a stunning homepage featuring blog sections and testimonials.

Second, you will build a one-page website for a fictional company known as the White Hat Hackers. Specializing in cybersecurity, this company helps businesses fortify their defenses against cyber-attacks and hackers.

Moving forward, you will advance your skills with the paid version of Elementor, crafting a dynamic business website for 'SEO Experts.'

By the end of this course, you will emerge as a master of the Elementor plugin, armed with the knowledge and expertise to build extraordinary, professional-grade websites that leave a lasting impression on your visitors.</p>
        <h2>What You Will Learn</h2><p>Build dynamic web layouts with sections, columns, and widgets<br>Combine videos and text boxes effectively<br>Design an attractive image carousel for content display<br>Add Google Maps for location-based information<br>Explore page templates for efficient website creation<br>Utilize Elementor Cloud hosting for optimal performance</p>
        <h2>Audience</h2><p>This course is for WordPress students who want to learn how to use a page builder plugin and for web developers looking to learn how to use the Elementor page builder plugin. This course assumes prior knowledge of WordPress and website building.</p>
        <h2>Approach</h2><p>The course takes a practical hands-on approach to use the Elementor plugin and teaches you how to build engaging webpages.</p>
        <h2>Key Features</h2><p>Step-by-step website creation using Elementor, from setup to launch * Hands-on projects building captivating travel and business websites * Master Elementor Pro for advanced header, footer, and flip box designs</p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/elementor---build-amazing-wordpress-pages-with-elementor</p>
        <h2>About the Author</h2><h3>Alexander Oni</h3><p>Alexander Oni is a bestselling instructor, with 70,000 students enrolled in his courses. His passion includes teaching through online courses in an entertaining way. Alex has been teaching online for more than five years and has created over 25 courses with numerous students registered worldwide.

Alex believes we all have one shot at life and should live life to the fullest, constantly stepping out of our comfort zone, visiting places, and trying new things. His online success has given him financial freedom and the ability to travel and settle anywhere. The author is currently avidly traveling, spending a month in every city, and moving to the next. His hobbies include watching movies, sports, and chess.</p>
        <h2>Course Outline</h2><h4>1. Free Hosting Offer</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Course Introduction</p><p style='margin: 0'>In this video, we will get introduced to the course and cover what you are going to learn from this course.</p></td></tr><tr><td style='padding: 15px;'><p>2. Special Offer - One Month Free Hosting</p><p style='margin: 0'>In this video, we will share a special offer for one-month free hosting. Find the offer link in the resource folder.</p></td></tr><tr><td style='padding: 15px;'><p>3. How to Create a Temporary Domain and Install WordPress</p><p style='margin: 0'>In this video, you will learn how to create a temporary domain and install WordPress.</p></td></tr><tr><td style='padding: 15px;'><p>4. How to Create a Sub Domain</p><p style='margin: 0'>In this video, you will learn how to create a sub domain.</p></td></tr><tr><td style='padding: 15px;'><p>5. How to Create a Web Mail Account</p><p style='margin: 0'>In this video, you will learn how to create a web mail account.</p></td></tr></tbody></table><br><h4>2. Introduction to Web Hosting and Domains</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction to Domains and Web Hosting</p><p style='margin: 0'>In this video, we will get introduced to domains and web hosting and understand them.</p></td></tr><tr><td style='padding: 15px;'><p>2. Buying Hosting and Domain Names</p><p style='margin: 0'>In this video, you will learn how to buy the hosting and domain names.</p></td></tr><tr><td style='padding: 15px;'><p>3. Installing WordPress Quickly</p><p style='margin: 0'>In this video, you will learn how to install WordPress quickly.</p></td></tr><tr><td style='padding: 15px;'><p>4. Installing WordPress Locally with Local by Flywheel</p><p style='margin: 0'>In this video, you will learn how to install WordPress locally with Local.</p></td></tr></tbody></table><br><h4>3. Elementor - Build a Business Website</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. What We Shall Build Together</p><p style='margin: 0'>In this video, we will cover our learning goal.</p></td></tr><tr><td style='padding: 15px;'><p>2. Elementor General Settings</p><p style='margin: 0'>In this video, you will learn about Elementor general settings.</p></td></tr><tr><td style='padding: 15px;'><p>3. Setting Up the Elementor Home Page</p><p style='margin: 0'>In this video, you will learn how to set up the Elementor home page.</p></td></tr><tr><td style='padding: 15px;'><p>4. Setting Up our Global Values</p><p style='margin: 0'>In this video, you will learn how to set up our global values.</p></td></tr><tr><td style='padding: 15px;'><p>5. Adding our First Section - Headline Text and Background Video</p><p style='margin: 0'>In this video, you will learn how to add our first section with headline text and background video.</p></td></tr><tr><td style='padding: 15px;'><p>6. The Second Section - Who We Are</p><p style='margin: 0'>In this video, we will work on the second section - who we are.</p></td></tr><tr><td style='padding: 15px;'><p>7. The Navigator and History Tools</p><p style='margin: 0'>In this video, we will cover the navigator and history tools.</p></td></tr><tr><td style='padding: 15px;'><p>8. Creating Advanced Structures</p><p style='margin: 0'>In this video, you will learn how to create advanced structures.</p></td></tr><tr><td style='padding: 15px;'><p>9. Adding the Our Services Section</p><p style='margin: 0'>In this video, you will learn how to add the Our Services section.</p></td></tr><tr><td style='padding: 15px;'><p>10. Adding the Why Work with Us Section</p><p style='margin: 0'>In this video, you will learn how to add the Why Work with Us section.</p></td></tr><tr><td style='padding: 15px;'><p>11. Adding the Meet the Team Section</p><p style='margin: 0'>In this video, you will learn how to add the Meet the Team section.</p></td></tr><tr><td style='padding: 15px;'><p>12. Adding the Our Clients Section</p><p style='margin: 0'>In this video, you will learn how to add the Our Clients section.</p></td></tr><tr><td style='padding: 15px;'><p>13. Adding the Testimonials Section</p><p style='margin: 0'>In this video, you will learn how to add the Testimonials section.</p></td></tr><tr><td style='padding: 15px;'><p>14. Working with Margins and Paddings</p><p style='margin: 0'>In this video, we will be working with margins and paddings.</p></td></tr><tr><td style='padding: 15px;'><p>15. Working with the Spacing Elements</p><p style='margin: 0'>In this video, we will be working with the spacing elements.</p></td></tr><tr><td style='padding: 15px;'><p>16. Working with the Number Counter Element</p><p style='margin: 0'>In this video, we will be working with the number counter element.</p></td></tr><tr><td style='padding: 15px;'><p>17. Creating the Footer Section</p><p style='margin: 0'>In this video, you will learn how to create the footer section.</p></td></tr><tr><td style='padding: 15px;'><p>18. Creating the Header Part One - Anchor Links</p><p style='margin: 0'>In this video, you will learn how to create the header part one - Anchor links.</p></td></tr><tr><td style='padding: 15px;'><p>19. Creating the Header Part Two - Adding our Menu and Logo</p><p style='margin: 0'>In this video, you will learn how to create the header part two - Adding our menu and logo.</p></td></tr><tr><td style='padding: 15px;'><p>20. Responsive Mode</p><p style='margin: 0'>In this video, you will learn about Responsive mode.</p></td></tr><tr><td style='padding: 15px;'><p>21. Working with Page Templates and Blocks</p><p style='margin: 0'>In this video, we will be working with page templates and blocks.</p></td></tr><tr><td style='padding: 15px;'><p>22. Round Up</p><p style='margin: 0'>In this video, you will learn about round up.</p></td></tr></tbody></table><br><h4>4. Using Elementor Pro</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction to Elementor Pro</p><p style='margin: 0'>In this video, we will get introduced to Elementor Pro.</p></td></tr><tr><td style='padding: 15px;'><p>2. Affiliate Promo</p><p style='margin: 0'>In this video, you will learn about Affiliate promo.</p></td></tr><tr><td style='padding: 15px;'><p>3. Elementor Pro Section Preview</p><p style='margin: 0'>In this video, we will cover Elementor Pro section preview.</p></td></tr><tr><td style='padding: 15px;'><p>4. Adding the Main Menu</p><p style='margin: 0'>In this video, you will learn how to add the Main menu.</p></td></tr><tr><td style='padding: 15px;'><p>5. Creating an Animated Headline</p><p style='margin: 0'>In this video, you will learn how to create an Animated headline.</p></td></tr><tr><td style='padding: 15px;'><p>6. Adding a Countdown Timer</p><p style='margin: 0'>In this video, you will learn how to add a countdown timer.</p></td></tr><tr><td style='padding: 15px;'><p>7. Recreating the Services Section with Flip Boxes</p><p style='margin: 0'>In this video, we will be working on recreating the services section with flip boxes.</p></td></tr><tr><td style='padding: 15px;'><p>8. Recreating the Why Work with Us Section</p><p style='margin: 0'>In this video, we will be working on recreating the Why Work with Us section.</p></td></tr><tr><td style='padding: 15px;'><p>9. Recreating the Contact Us Section</p><p style='margin: 0'>In this video, we will be working on recreating the Contact Us section.</p></td></tr><tr><td style='padding: 15px;'><p>10. Conclusion</p><p style='margin: 0'>In this video, you will learn about conclusion.</p></td></tr></tbody></table><br><h4>5. Updates in Elementor Developers</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Section Preview</p><p style='margin: 0'>In this video, we will cover the section preview.</p></td></tr><tr><td style='padding: 15px;'><p>2. Creating a Responsive Header Logo and Nav Menu</p><p style='margin: 0'>In this video, you will learn how to create a responsive header logo and Nav menu.</p></td></tr><tr><td style='padding: 15px;'><p>3. Elementor Version 2.8.4/2.9.4 Updates</p><p style='margin: 0'>In this video, you will learn about Elementor version 2.8.4/2.9.4 updates.</p></td></tr><tr><td style='padding: 15px;'><p>4. Elementor Themes</p><p style='margin: 0'>In this video, you will learn about Elementor themes.</p></td></tr><tr><td style='padding: 15px;'><p>5. The Elementor Popup Builder</p><p style='margin: 0'>In this video, you will learn about the Elementor popup builder.</p></td></tr><tr><td style='padding: 15px;'><p>6. Working with Global Templates</p><p style='margin: 0'>In this video, we will be working with global templates.</p></td></tr><tr><td style='padding: 15px;'><p>7. Working with Global Widgets</p><p style='margin: 0'>In this video, we will be working with global widgets.</p></td></tr><tr><td style='padding: 15px;'><p>8. Working with the Portfolio Widget</p><p style='margin: 0'>In this video, we will be working with the portfolio widget.</p></td></tr><tr><td style='padding: 15px;'><p>9. Building a Post Template</p><p style='margin: 0'>In this video, you will learn about building a post template.</p></td></tr><tr><td style='padding: 15px;'><p>10. Working with the Font Icon Library</p><p style='margin: 0'>In this video, we will be working with the Font Icon library.</p></td></tr><tr><td style='padding: 15px;'><p>11. The Table of Contents Element</p><p style='margin: 0'>In this video, you will learn about the Table of Contents element.</p></td></tr><tr><td style='padding: 15px;'><p>12. Rank Math and Elementor</p><p style='margin: 0'>In this video, you will learn about Rank Math and Elementor.</p></td></tr><tr><td style='padding: 15px;'><p>13. The Tilt Effect</p><p style='margin: 0'>In this video, you will learn about the Tilt effect.</p></td></tr><tr><td style='padding: 15px;'><p>14. The Position Property</p><p style='margin: 0'>In this video, you will learn about the position property.</p></td></tr><tr><td style='padding: 15px;'><p>15. Advanced Custom Fields and Elementor</p><p style='margin: 0'>In this video, you will learn about advanced custom fields and Elementor.</p></td></tr><tr><td style='padding: 15px;'><p>16. Working with Custom Post Types</p><p style='margin: 0'>In this video, we will be working with custom post types.</p></td></tr><tr><td style='padding: 15px;'><p>17. How to Set Up Your Blog Page as Your Homepage with Elementor</p><p style='margin: 0'>In this video, you will learn about how to set up your blog page as your homepage with Elementor.</p></td></tr></tbody></table>

Packt

WordPress

Web Development

Elementor

Web Design

This course teaches you how to use Elementor, one of the most popular plugins for building pages in WordPress, with over a million downloads already. It is fast and comes with a wide variety of widgets and elements that help you build webpages effortlessly without using any code.

Elementor - Build Amazing WordPress Pages with Elementor

<strong>This course covers the essential topics necessary for working with Microsoft SQL Server. You will understand the various scenarios and techniques to write queries and build and administer databases, along with delving into advanced SQL topics that are in great demand in the industry.</strong>
        <p>Do you want to gain knowledge of Microsoft SQL Server to understand how it stores and retrieves huge amounts of data? This course will help you learn about Microsoft SQL Server, including the features and functionalities that are needed to design and develop reliable database systems.

The course starts with an introduction to SQL Server and databases and takes you through the installation of SQL Server Express. Once you are ready with the setup, you will learn to connect to a database instance and create a database and tables inside the database. As you advance, you will learn to run queries against tables to manipulate tables and data and create relationships in the SQL Server with foreign keys and normalization.

Later, you will be able to perform mathematical operations using aggregate functions, such as AVG, COUNT, MAX, and SUM. Finally, you will get to grips with advanced SQL Server objects and concepts such as views, triggers, stored procedures, database scripting, and more.

By the end of this course, you will be well-versed in using SQL Server and have developed the skills to write SQL queries for manipulating databases.

All the resources and supportive files are available at:
https://github.com/PacktPublishing/Microsoft-SQL-Server-Development-for-Everyone-</p>
        <h2>What You Will Learn</h2><p>Install SQL Server and SQL Server Management Studio<br>Create, manipulate, and connect databases<br>Export data to Excel using SQL Server Management Studio<br>Create and manage database views<br>Explore custom functions, table views, and stored procedures<br>Find techniques to back up and restore databases</p>
        <h2>Audience</h2><p>This course is for beginner- and intermediate-level database developers and administrators who are looking to create, manipulate, and connect databases using Microsoft SQL Server.<br><br>This course is for the individual who is already comfortable with fundamental database operations.<br><br>There are no prerequisites for this course as it provides you with fundamental SQL Server training.</p>
        <h2>Approach</h2><p>This practical course will help you get started with the fundamentals of database design and development using Microsoft SQL Server. Featuring examples, real-world scenarios, exercises, and more, it will help you get hands-on experience in developing Microsoft SQL databases and querying.</p>
        <h2>Key Features</h2><p>Understand basic and advanced database operations and become familiar with SQL Server * Explore best practices in database development using SQL Server Express * Learn how to craft flawless SQL queries based on real-world scenarios</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Microsoft-SQL-Server-Development-for-Everyone-</p>
        <h2>About the Author</h2><h3>Trevoir Williams</h3><p>Trevoir Williams is a software engineer and part-time lecturer. With a master's degree in computer science, he has spent over a decade teaching web, software, and database development courses. He also has extensive industry experience in web application development, Azure Cloud system, and server administration. He enjoys teaching IT and development courses and hopes to impart knowledge of the latest developments in industry standards and techniques to his students.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction to SQL Server and Databases</p><p style='margin: 0'>This video provides an introduction to SQL Server and databases.</p></td></tr><tr><td style='padding: 15px;'><p>2. Understanding Types of Data and Storage</p><p style='margin: 0'>This video helps you with understanding different types of data and storage.</p></td></tr></tbody></table><br><h4>2. Environment Setup</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Download and Install SQL Server Express (Windows)</p><p style='margin: 0'>This video demonstrates how to download and install SQL Server Express on Windows machines.</p></td></tr><tr><td style='padding: 15px;'><p>2. Download and Install SQL Server Express on Mac and Linux</p><p style='margin: 0'>This video demonstrates how to download and install SQL Server Express on Mac and Linux machines.</p></td></tr></tbody></table><br><h4>3. Understanding the Toolset</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Explore SQL Server Management Studio</p><p style='margin: 0'>This video helps you explore SQL Server Management Studio (SSMS).</p></td></tr><tr><td style='padding: 15px;'><p>2. Explore Azure Data Studio</p><p style='margin: 0'>This video demonstrates and explores Azure Data Studio.</p></td></tr><tr><td style='padding: 15px;'><p>3. Explore Draw.io</p><p style='margin: 0'>This video takes a tour of Draw.io.</p></td></tr></tbody></table><br><h4>4. Creating and Manipulating Databases</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Section Overview</p><p style='margin: 0'>This video provides an overview of the section.</p></td></tr><tr><td style='padding: 15px;'><p>2. Create a Database Using Management Studio</p><p style='margin: 0'>This video explains how to create a database using Management Studio.</p></td></tr><tr><td style='padding: 15px;'><p>3. Create a Database Using SQL Script</p><p style='margin: 0'>This video explains how to create a database using SQL Script.</p></td></tr><tr><td style='padding: 15px;'><p>4. How to Remove a Database</p><p style='margin: 0'>This video demonstrates how to remove a database.</p></td></tr><tr><td style='padding: 15px;'><p>5. How to Change Database Name</p><p style='margin: 0'>This video explains how to change the database name.</p></td></tr><tr><td style='padding: 15px;'><p>6. Section Review</p><p style='margin: 0'>This video helps you with the section review and conclusion.</p></td></tr></tbody></table><br><h4>5. Managing Tables and Data</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. What Is a Database Table?</p><p style='margin: 0'>This video explains the database table and its application.</p></td></tr><tr><td style='padding: 15px;'><p>2. Create Entity Data Model</p><p style='margin: 0'>This video explains how to create the Entity Data model.</p></td></tr><tr><td style='padding: 15px;'><p>3. Create a Database Table Using Management Studio</p><p style='margin: 0'>This video explains how to create a database table using Management Studio.</p></td></tr><tr><td style='padding: 15px;'><p>4. What Is SQL?</p><p style='margin: 0'>This video talks about SQL in detail.</p></td></tr><tr><td style='padding: 15px;'><p>5. Create a Database Table Using SQL Script</p><p style='margin: 0'>This video explains how to create a database table using SQL Script.</p></td></tr><tr><td style='padding: 15px;'><p>6. Review Table Creation</p><p style='margin: 0'>This video demonstrates how to review table creation.</p></td></tr><tr><td style='padding: 15px;'><p>7. Insert Data into the Table Using Management Studio</p><p style='margin: 0'>This video helps you with inserting data into the table using Management Studio.</p></td></tr><tr><td style='padding: 15px;'><p>8. Insert Data into the Table Using SQL Scripts</p><p style='margin: 0'>This video focuses on inserting data into the table using SQL Scripts.</p></td></tr><tr><td style='padding: 15px;'><p>9. Select Data from Tables - Simple Queries</p><p style='margin: 0'>This video explains how to select data from tables; we will focus on simple queries.</p></td></tr><tr><td style='padding: 15px;'><p>10. Select Data from Tables - Adding Filtering</p><p style='margin: 0'>This video explains how to select data from tables; we will focus on adding filtering.</p></td></tr><tr><td style='padding: 15px;'><p>11. Select Data from Tables - Exporting Data</p><p style='margin: 0'>This video explains how to select data from tables; we will focus on exporting data.</p></td></tr><tr><td style='padding: 15px;'><p>12. Update Data in Tables</p><p style='margin: 0'>This video explains how to update data in tables.</p></td></tr><tr><td style='padding: 15px;'><p>13. Delete Data from the Tables</p><p style='margin: 0'>This video explains how to delete data from the tables.</p></td></tr><tr><td style='padding: 15px;'><p>14. SQL Transactions</p><p style='margin: 0'>This video explains SQL transactions in detail.</p></td></tr><tr><td style='padding: 15px;'><p>15. Review CRUD Operations</p><p style='margin: 0'>This video explains how to review CRUD operations.</p></td></tr></tbody></table><br><h4>6. Normalization, Relationships, and Foreign Keys</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. What Are Relationships, Foreign Keys, and Normalization?</p><p style='margin: 0'>This video talks about relationships, foreign keys, and normalization in a database.</p></td></tr><tr><td style='padding: 15px;'><p>2. Normalizing Our Database</p><p style='margin: 0'>This video is about normalizing our database.</p></td></tr><tr><td style='padding: 15px;'><p>3. Creating a Relationship in SQL Server</p><p style='margin: 0'>This video demonstrates how to create a relationship in the SQL Server.</p></td></tr><tr><td style='padding: 15px;'><p>4. Inserting Records in One-to-Many Related Tables</p><p style='margin: 0'>This video helps you with inserting records in one-to-many related tables.</p></td></tr><tr><td style='padding: 15px;'><p>5. Inserting Records in Many-to-Many Related Tables</p><p style='margin: 0'>This video helps you with inserting records in many-to-many related tables.</p></td></tr><tr><td style='padding: 15px;'><p>6. Using Inner Joins to Read Related Data</p><p style='margin: 0'>This video explains how to use inner joins to read related data.</p></td></tr><tr><td style='padding: 15px;'><p>7. Understanding Left, Right, and Full Joins</p><p style='margin: 0'>This video helps you in understanding left, right, and full joins.</p></td></tr><tr><td style='padding: 15px;'><p>8. Foreign Key Cascade Options</p><p style='margin: 0'>This video explains the foreign key cascade options.</p></td></tr><tr><td style='padding: 15px;'><p>9. Section Review</p><p style='margin: 0'>This video focuses on the section review and conclusion.</p></td></tr></tbody></table><br><h4>7. GROUP BY and Aggregate Functions</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Grouping Data Using the SQL GROUP BY Clause</p><p style='margin: 0'>This video explains how to group data using the SQL GROUP BY clause.</p></td></tr><tr><td style='padding: 15px;'><p>2. SQL COUNT Aggregate Function</p><p style='margin: 0'>This video explains the SQL COUNT aggregate function.</p></td></tr><tr><td style='padding: 15px;'><p>3. SQL AVG Aggregate Function</p><p style='margin: 0'>This video focuses on the SQL AVG aggregate function.</p></td></tr><tr><td style='padding: 15px;'><p>4. SQL MAX and MIN Aggregate Functions</p><p style='margin: 0'>This video explains the SQL MAX and MIN aggregate functions.</p></td></tr><tr><td style='padding: 15px;'><p>5. SQL SUM Aggregate Function</p><p style='margin: 0'>This video talks about the SQL SUM aggregate function.</p></td></tr><tr><td style='padding: 15px;'><p>6. Filtering on Aggregate Values</p><p style='margin: 0'>This video explains how to filter on aggregate values.</p></td></tr></tbody></table><br><h4>8. Advanced SQL Server Objects and Concepts</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Section Overview</p><p style='margin: 0'>This video provides an overview of the section.</p></td></tr><tr><td style='padding: 15px;'><p>2. Creating and Managing Views</p><p style='margin: 0'>This video explains how to create and manage views.</p></td></tr><tr><td style='padding: 15px;'><p>3. Scalar Valued Functions</p><p style='margin: 0'>This video explains the scalar valued functions.</p></td></tr><tr><td style='padding: 15px;'><p>4. Inline Table-Valued Functions</p><p style='margin: 0'>This video focuses on the inline table-valued functions.</p></td></tr><tr><td style='padding: 15px;'><p>5. Multi-Statement Table-Valued Functions</p><p style='margin: 0'>This video explains the multi-statement table-valued functions.</p></td></tr><tr><td style='padding: 15px;'><p>6. Stored Procedures</p><p style='margin: 0'>This video focuses on stored procedures.</p></td></tr><tr><td style='padding: 15px;'><p>7. Table Triggers</p><p style='margin: 0'>This video talks about the table triggers and their application.</p></td></tr><tr><td style='padding: 15px;'><p>8. Generating Database Scripts</p><p style='margin: 0'>This video helps in generating database scripts.</p></td></tr><tr><td style='padding: 15px;'><p>9. Database Backup and Restoring</p><p style='margin: 0'>This video sheds light on database backup and restoration.</p></td></tr></tbody></table><br><h4>9. SQL Server Security</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Section Overview</p><p style='margin: 0'>This video provides an overview of the section.</p></td></tr><tr><td style='padding: 15px;'><p>2. Create a SQL User Login</p><p style='margin: 0'>This video explains how to create a SQL user login.</p></td></tr><tr><td style='padding: 15px;'><p>3. Add Windows Authenticated Login</p><p style='margin: 0'>This video explains how to add Windows authenticated login.</p></td></tr><tr><td style='padding: 15px;'><p>4. Add Server Logins with Script</p><p style='margin: 0'>This video explains how to add server logins with script.</p></td></tr></tbody></table>

Database Programming

Database

Docker

SQL Server

This course covers the essential topics necessary for working with Microsoft SQL Server. You will understand the various scenarios and techniques to write queries and build and administer databases, along with delving into advanced SQL topics that are in great demand in the industry.

Microsoft SQL Server Development for Everyone

School of Business and Technology London

ILM Level 5 Award In Leadership And Management

<p>Give a compliment to your career and take it to the next level. This <strong>Cross-Cultural Awareness Training </strong>will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this <strong>Cross-Cultural Awareness Training </strong>will help you keep ahead of the pack.</p> <p>The <strong>Cross-Cultural Awareness Training </strong>incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and knowledge, reaching out to the level of expertise required for your position. Further, this <strong>Cross-Cultural Awareness Training </strong>will add extra value to your resume to stand out to potential employers.</p> <p>Throughout the programme, it stresses how to improve your competency as a person in your profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the <strong> Cross-Cultural Awareness Training,</strong> you can equip yourself with the essentials to keep you afloat into the competition.</p> <p>Along with this <strong>Cross-Cultural Awareness Training </strong>course<strong>,</strong> you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free.</p> <p><strong>This Cross-Cultural Awareness Training Bundle Consists of the following Premium courses: </strong></p> <ul> <li><strong>Course 01: </strong>Cross-Cultural Awareness Training</li><li><strong>Course 02: </strong>Working Effectively Across Cultures</li><li><strong>Course 03: </strong>Equality and Diversity</li><li><strong>Course 04: </strong>Assertiveness and Self Confidence Development</li><li><strong>Course 05: </strong>The Formula to Talk with Strangers</li><li><strong>Course 06: </strong>People Management Skills Level 3</li><li><strong>Course 07: </strong>Resilience Masterclass</li><li><strong>Course 08: </strong>Customer Relationship Management</li><li><strong>Course 09: </strong>Public Speaking and Presentation Skill Course<strong><br /></strong></li><li><strong>Course 10: </strong>Workplace Confidentiality<strong><br /></strong></li><li><strong>Course 11: </strong>Sexual Harassment Awareness Training<strong><br /></strong></li></ul> <p>As one of the top course providers in the UK, we're committed to providing you with the best educational experience possible. Our industry experts have designed the <strong>Cross-Cultural Awareness Training</strong> to empower you to learn all at once with accuracy. You can take the course at your own pace - anytime, from anywhere.</p> <p>So, enrol now to advance your career!</p> <p><strong>Benefits you'll get choosing Apex Learning for this Cross-Cultural Awareness Training:</strong></p> <ul> <li>One payment, but lifetime access to 11 CPD courses</li><li>Certificate, student ID for the title course included in a one-time fee</li><li>Full tutor support available from Monday to Friday</li><li>Free up your time - don't waste time and money travelling for classes</li><li>Accessible, informative modules taught by expert instructors</li><li>Get 24/7 help or advice from our email and live chat teams</li><li>Learn at your ease - anytime, from anywhere</li><li>Study the course from your computer, tablet or mobile device</li><li>CPD accredited course - improve the chance of gaining professional skills</li></ul> <p><strong>How will I get my Certificate?</strong></p> <p>After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p> <ul> <li>PDF Certificates: Free (Previously it was £10*11= £110)</li><li>Hard Copy Certificates: Free (Previously it was £20*11= £220)</li></ul><p><strong>Curriculum of the Bundle </strong></p> <p><strong>Course 01: Cross-Cultural Awareness Training</strong></p> <ul> <li>Module 1: Introduction to Cross-Cultural Awareness</li><li>Module 2: Cross-Cultural Communication</li><li>Module 3: Corporate Cross-Cultural Awareness</li><li>Module 4: Cross-Cultural Design</li><li>Module 5: Cross-Cultural Competency</li><li>Module 6: Cultural Values</li><li>Module 7: Working with and Managing a Culturally Diverse Team</li></ul> <p><strong>Course 02: Working Effectively Across Cultures</strong></p> <ul> <li>Section 1: Introduction</li><li>Section 2: Cultural identity</li><li>Section 3: OBSERVE</li><li>Section 4: Learn</li><li>Section 5: APPLY</li><li>Section 6: More practical TIPS</li><li>Section 7: Wrap up</li></ul> <p><strong>Course 03: Equality and Diversity</strong></p> <ul> <li>Module 01: Introduction to Equality, Diversity and Discrimination</li><li>Module 02: Equality and Diversity Legislation</li><li>Module 03: Integrating Equality and Diversity into Policy</li><li>Module 04: Human Rights</li><li>Module 05: Promoting Diversity and Social Inclusion</li><li>Module 06: Equality Analysis</li><li>Module 07: Links between Values, Attitudes and Beliefs</li><li>Module 08: Basics of Discrimination</li><li>Module 09: Stereotypes, Prejudice, Discrimination and Bias</li><li>Module 10: Institutional Discrimination</li><li>Module 11: Unconscious Bias</li><li>Module 12: Affirmative Action</li><li>Module 13: Monitoring Equality and Diversity</li></ul> <p><strong>Course 04: Assertiveness and Self Confidence Development</strong></p> <ul> <li>Self Confidence Introduction</li><li>Ways to Find Yourself</li><li>Positive Mindset vs Negative Mindset</li><li>Do it, Feel it and Achieve it</li><li>Believe it and Achieve it</li><li>ESTEEM SELF ANALYSIS</li><li>STILL STRUGGLING TO FIND AND TO BE CONFIDENT</li></ul> <p><strong>Course 05: The Formula to Talk with Strangers</strong></p> <ul> <li>Section 01: Course Overview</li><li>Section 02: The Formula</li><li>Section 03: Summary</li><li>Section 04: End</li></ul> <p><strong>Course 06: People Management Skills Level 3</strong></p> <ul> <li>Introduction to Human Resources</li><li>Employee Recruitment and Selection Procedure</li><li>Employee Training and Development Process</li><li>Performance Appraisal Management</li><li>Employee Relations</li><li>Motivation and Counselling</li><li>Ensuring Health and Safety at the Workplace</li><li>Employee Termination</li><li>Employer Records and Statistics</li><li>Essential UK Employment Law</li></ul> <p><strong>Course 07: Resilience Masterclass</strong></p> <ul> <li>Module 01: 3 Reasons Therapy May Help Boost Your Resilience</li><li>Module 02: 3 Signs That You Are Resilient</li><li>Module 03: 3 Ways to Boost Your Child's Resilience</li><li>Module 04: 4 Myths about Resilience to Stop Believing Today</li><li>Module 05: 4 Reasons Why Resilience Matters in the Workplace</li><li>Module 06: Become Resilient With the Seven Cs of Resilience</li><li>Module 07: Top 5 Attributes Of Resilient People</li><li>Module 08: Top 5 Benefits of Resilience</li><li>Module 09: Top 5 Ways to Boost Resilience to Overcome Adversity in Life</li><li>Module 10: What is Resilience?</li></ul> <p><strong>Course 07: Customer Relationship Management</strong></p> <ul> <li>Module 01: Introduction to Customer Relationship Management (CRM)</li><li>Module 02: CRM Fundamentals</li><li>Module 03: CRM Strategies CRM Strategies</li><li>Module 04: Data Analysis in CRM</li><li>Module 05: CRM Databases</li><li>Module 06: Deepening Customer Relationship</li><li>Module 07: Handling Customer Complaints</li><li>Module 08: Future of CRM</li></ul> <p><strong>Course 09: Public Speaking and Presentation Skill Course</strong></p> <ul> <li>Introduction</li><li>QUICK UNLEARNING Before Starting this "SKILL"</li><li>IS THIS HAPPENED WITH YOU????</li><li>Impressive Methods of Hooking Audience, even before your Speech or Presentation</li><li>6 Highly Impressive Methods of Starting any Speech or Presentation!!</li><li>Body Language: 6 Methods for Impressive Body Language for Speech or Presentation</li><li>Vocal Variety: 3 Methods (VST) for POWERFUL Vocal Variety</li><li>Effective Methods of Ending Any Speech or Presentation</li></ul> <p><strong>Course 10: Workplace Confidentiality<br /></strong></p> <ul> <li>Module 01: Introduction to workplace confidentiality</li><li>Module 02: Business Etiquettes and Types of Confidentiality</li><li>Module 03: The Importance of Confidentiality</li><li>Module 04: Confidentiality with Co-workers</li><li>Module 05: Preventing Confidentiality Breach</li><li>Module 06: How Employers Can Protect Confidential Information</li></ul> <p><strong>Course 11: Sexual Harassment Awareness Training<br /></strong></p> <ul> <li>Module 01: What is Sexual Harassment?</li><li>Module 02: Sexual Harassment in the Workplace</li><li>Module 03: The Law and Sexual Harassment</li><li>Module 04: Addressing Sexual Harassment</li><li>Module 05: Prevent Sexual Harassment at Work</li><li>Module 06: Policies and Procedures</li><li>Module 07: How to Deal with Sexual Harassment in the Workplace?</li><li>Module 08: Mediation and the Aftermath</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        110 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>Anyone from any background can enrol in this <strong>Cross-Cultural Awareness Training </strong>bundle<strong>. </strong>Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future.</p> 
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Our <strong>Cross-Cultural Awareness Training </strong>is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p> <p>There is no time limit for completing this course, it can be studied in your own time at your own pace.</p> 
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Having these various expertise will increase the value in your CV and open you up to multiple job sectors.</p> 
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Apex Learning

Online Course Marketing

Certificate in Further Education & Training (Cert Ed)

Centre for Counselling & Psychotherapy Training (CCPT)

Life Coach Training

Professional Skills Course (PSC)

Trainers Course

Cross-Cultural Awareness Training

<p><strong>Duties and Responsibilities of a Care Worker</strong></p><p>Are you ready to make a real difference in people's lives? Whether you're starting your journey in the healthcare field or looking to enhance your skills, our <strong>Duties and Responsibilities of a Care Worker Course</strong> is your gateway to a rewarding career. Discover a path where compassion meets professionalism, and every day is an opportunity to impact lives positively.</p><p>According to <strong>Reed, </strong>a <strong>Support Worker</strong> can earn from <strong>£25,000 to £30,000</strong> in a year depending on qualification, experience, location and other factors.</p><p><strong>Enrol</strong> in our "<strong>Duties and Responsibilities of a Care Worker</strong>" course and start your journey towards becoming a trusted, skilled, and empathetic care worker.</p><p><strong>Key Features:</strong></p><ul><li>CPD Certified</li><li>Instant e-certificate and hard copy dispatch by next working day</li><li>Fully online, interactive course with audio voiceover</li><li>Developed by qualified professionals in the field</li><li>Self-paced learning and laptop, tablet, smartphone-friendly</li><li>24/7 Learning Assistance</li></ul><p><strong>Course Curriculum of Duties and Responsibilities of a Care Worker</strong></p><ul><li>The Duties and Responsibilities of a Care Worker </li><li> Employment Rights and Responsibilities </li><li> Aims, objectives and values of the service </li><li> Responsibilities to the Individuals </li><li> Different Working Relationships in Care Settings </li><li> The Importance of Partnership Working </li></ul><p><strong>Learning Outcomes:</strong></p><ul><li>Understand duties and responsibilities of a care worker in various settings.</li><li>Recognise employment rights and responsibilities within the care sector.</li><li>Comprehend aims, objectives, and values of care services.</li><li>Identify responsibilities to individuals receiving care.</li><li>Differentiate between various working relationships in care environments.</li><li>Appreciate the importance of partnership working in care settings.</li></ul><p><strong>Accreditation</strong></p><p>All of our courses are fully accredited, including this Duties and Responsibilities of a Care Worker Course, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in Duties and Responsibilities of a Care Worker.</p><p><strong>Certification</strong></p><p>Once you've successfully completed your Duties and Responsibilities of a Care Worker Course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our Duties and Responsibilities of a Care Worker Course certification has no expiry dates, although we do recommend that you renew them every 12 months.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        10 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">
                            <ul><li>Aspiring care workers in residential homes.</li><li>Individuals considering a career in domiciliary care.</li><li>Those new to the healthcare sector.</li><li>People interested in supporting vulnerable individuals.</li><li>Career changers exploring care work.</li></ul>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Care Assistant</li><li>Support Worker</li><li>Residential Care Worker</li><li>Domiciliary Care Worker</li><li>Healthcare Assistant</li><li>Personal Care Assistant</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Digital certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div><p>Once you've successfully completed your course, you will immediately be sent a FREE digital certificate.</p></div>
        <h4>Hard copy certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div><p>Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK).<br />For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.<br />Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.</p></div>

                        </div>

Training Express

Duties and Responsibilities of a Care Worker Course

<h2><strong>Course Overview:</strong></h2>
<span>Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. </span>

<span>This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.</span>

<span>By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. </span><span>Enrol in this course today and start your journey!</span>

<hr />

<h2><strong>Key Features of the Course:</strong></h2>
<ul>
 	<li>CPD certificate upon completion</li>
 	<li>24/7 learning assistance and support</li>
</ul>

<hr />

<h2><strong>Who is This Course For?</strong></h2>
This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners.

<hr />

<h2><strong>What You Will Learn:</strong></h2>
<ul>
 	<li><strong>Foundations of SQL programming:</strong> Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron.</li>
 	<li><strong>Data manipulation:</strong> Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators.</li>
 	<li><strong>Advanced querying techniques:</strong> Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques.</li>
 	<li><strong>Data conversion and manipulation:</strong> Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries.</li>
 	<li><strong>Joining tables:</strong> Understand the different types of joins and how to combine data from multiple tables using join operations effectively.</li>
 	<li><strong>Data modification:</strong> Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.<strong>Joining tables:</strong> Understand the different types of joins and how to combine data from multiple tables using join operations effectively.</li>
 	<li><strong>Views and schemas:</strong> Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively.</li>
</ul>

<hr />

<h2><strong>Why Enrol in This Course:</strong></h2>
<strong>Top-reviewed course:</strong> Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples.

<strong>Recently updated curriculum:</strong> Benefit from the most up-to-date information and industry best practices in SQL programming.

<strong>In-demand skills:</strong> SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries.

<hr />

<h2><strong>Requirements:</strong></h2>
No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn.

<hr />

<h2><strong>Career Path:</strong></h2>
Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including:
<ul>
 	<li>Data Analyst - Average UK salary: £35,000 per year</li>
 	<li>Database Administrator - Average UK salary: £40,000 per year</li>
 	<li>Business Intelligence Analyst - Average UK salary: £45,000 per year</li>
 	<li>SQL Developer - Average UK salary: £40,000 per year</li>
 	<li>Data Engineer - Average UK salary: £55,000 per year</li>
 	<li>Software Developer - Average UK salary: £45,000 per year</li>
 	<li>Data Scientist - Average UK salary: £60,000 per year</li>
</ul>

<hr />

<h2><strong>Certification:</strong></h2>
Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a <strong>CPD certificate.</strong> It demonstrates your commitment to maintaining the highest standards of hygiene and infection control.

<hr /> <h3>Course Curriculum</h3><div><p>17 sections • 117 lectures • 10:47:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Tools Used in This Course: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Download PostgreSQL: 00:02:00</p></div><div><div><p>•Install PostgreSQL: 00:03:00</p></div><div><div><p>•Download SQLectron: 00:02:00</p></div><div><div><p>•Install SQLectron: 00:01:00</p></div><div><div><p>•Connect to PostgreSQL - Credentials: 00:01:00</p></div><div><div><p>•Connect to PostgreSQL Using SQLectron: 00:02:00</p></div><div><div><p>•Import Course Data Using SQLectron: 00:02:00</p></div><div><div><p>•FOR WINDOWS 32-BIT USERS: Download, Install, Configure &amp; Import Data: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Check Imported Data: 00:06:00</p></div><div><div><p>•What is a Database?: 00:01:00</p></div><div><div><p>•SQL Data Types: 00:02:00</p></div><div><div><p>•Finally Some Fun! Extracting Data Based on Requirements: 00:01:00</p></div><div><div><p>•Filtering Data using WHERE Keyword: 00:08:00</p></div><div><div><p>•Filter Data by Range Using BETWEEN: 00:03:00</p></div><div><div><p>•Filter Data by Set of Values Using IN: 00:03:00</p></div><div><div><p>•Filter Data by Date: 00:05:00</p></div><div><div><p>•More Filtering by Date: 00:03:00</p></div><div><div><p>•Another Query Filtering by Date: 00:01:00</p></div><div><div><p>•Filter Data by Strings: 00:04:00</p></div><div><div><p>•More Filtering by Strings: 00:05:00</p></div><div><div><p>•More Filtering by Strings 2: 00:10:00</p></div><div><div><p>•More Filtering by Strings 3: 00:02:00</p></div><div><div><p>•How to Ignore Caps when Filtering by String: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•AND Operator: 00:10:00</p></div><div><div><p>•OR Operator: 00:12:00</p></div><div><div><p>•NOT Operator: 00:09:00</p></div><div><div><p>•AND, OR &amp; NOT Operators: Which Has the Highest Priority?: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Basic Math Operations: 00:06:00</p></div><div><div><p>•Modulo Operator: 00:04:00</p></div><div><div><p>•Calculate The Net Salary for Employees: 00:06:00</p></div><div><div><p>•Filter Data with Math Equations: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Concatenate Strings with '||' Operator: 00:06:00</p></div><div><div><p>•Concatenate Strings with Numbers: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Give Your Report Fields A Cool Name: 00:04:00</p></div><div><div><p>•A Report for Payroll: 00:07:00</p></div><div><div><p>•Order Records by Column: 00:06:00</p></div><div><div><p>•Order Records by Multiple Columns: 00:12:00</p></div><div><div><p>•How Alias Names Cannot Be Used with WHERE: 00:02:00</p></div><div><div><p>•LIMIT Record Count Fetched by Your Query: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Fetch A Field's Unique Values Using DISTINCT: 00:03:00</p></div><div><div><p>•Using DISTINCT Keyword with Multiple Columns: 00:06:00</p></div><div><div><p>•What is a NULL Value Anyway?: 00:05:00</p></div><div><div><p>•Build More Sophisticated Queries with CASE Statements: 00:10:00</p></div><div><div><p>•Your Knowledge So Far Under A Great Test: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Let Me Introduce You to Functions: 00:04:00</p></div><div><div><p>•SUM Function: 00:04:00</p></div><div><div><p>•AVG (Average) Function: 00:04:00</p></div><div><div><p>•COUNT Function: 00:07:00</p></div><div><div><p>•MIN &amp; MAX Functions: 00:04:00</p></div><div><div><p>•How To Count Your Field's Unique Values: 00:04:00</p></div><div><div><p>•GROUP BY Clause: Use Functions with Dimensions: 00:06:00</p></div><div><div><p>•GROUP BY More Than One Dimension: 00:05:00</p></div><div><div><p>•Now For Some Tough Workout: 00:09:00</p></div><div><div><p>•Filter By Aggregate Functions with HAVING Clause: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Character Functions - UPPER, LOWER &amp; INITCAP: 00:08:00</p></div><div><div><p>•Character Functions - CONCAT &amp; LENGTH: 00:10:00</p></div><div><div><p>•Character Functions - LPAD &amp; RPAD: 00:13:00</p></div><div><div><p>•Character Functions - TRIM: 00:04:00</p></div><div><div><p>•Character Functions - REPLACE: 00:09:00</p></div><div><div><p>•Character Functions - SUBSTR: 00:10:00</p></div><div><div><p>•Number Functions - MOD &amp; ROUND: 00:11:00</p></div><div><div><p>•Number Functions - TRUNC: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Selectception: A Select Query inside another Select Query!: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Auto Data Conversion in SQL: 00:11:00</p></div><div><div><p>•Cast Date to Character: 00:10:00</p></div><div><div><p>•Cast Number to Character: 00:09:00</p></div><div><div><p>•Cast Timestamp to Character: 00:07:00</p></div><div><div><p>•Cast Character to Number: 00:08:00</p></div><div><div><p>•Cast Character to Date &amp; Timestamp: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•UNION: 00:03:00</p></div><div><div><p>•UNION ALL: 00:02:00</p></div><div><div><p>•Important Note about Combining Queries: 00:02:00</p></div><div><div><p>•INTERSECT: 00:01:00</p></div><div><div><p>•EXCEPT: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Employees &amp; Departments Tables Revised: 00:03:00</p></div><div><div><p>•Entity Relationship Diagram (ERD): 00:09:00</p></div><div><div><p>•Cartesian Join: 00:09:00</p></div><div><div><p>•Table Aliases with Joins: 00:07:00</p></div><div><div><p>•Why I Don't Recommend Cartesian Joins: 00:08:00</p></div><div><div><p>•Inner Join: 00:06:00</p></div><div><div><p>•In-Depth Look into Join Types in SQL: 00:03:00</p></div><div><div><p>•Outer Join - Right, Left &amp; Full: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•INSERT a New Record to a Table: 00:09:00</p></div><div><div><p>•Insert Without Specifying Column Names: 00:09:00</p></div><div><div><p>•UPDATE a Record's Field Values: 00:07:00</p></div><div><div><p>•CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00</p></div><div><div><p>•Update a Record Using Single-Row Functions: 00:04:00</p></div><div><div><p>•A Good Exercise: Extract Employee's Email Address: 00:02:00</p></div><div><div><p>•Solution: Extract Employee's Email Address: 00:13:00</p></div><div><div><p>•DELETE a Table's Record: 00:06:00</p></div><div><div><p>•Insert Records with Nested Select Queries: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•SQL Data Types Revised: 00:13:00</p></div><div><div><p>•Bookstore Data Set: Let's Move It to Database: 00:04:00</p></div><div><div><p>•Create Your First Table!: 00:08:00</p></div><div><div><p>•Insert Data to Your New Table: 00:08:00</p></div><div><div><p>•Change Column Data Type: 00:07:00</p></div><div><div><p>•Rename Column: 00:04:00</p></div><div><div><p>•Add a New Column to Table: 00:04:00</p></div><div><div><p>•Constraints in SQL: 00:01:00</p></div><div><div><p>•Primary Keys: 00:14:00</p></div><div><div><p>•NOT NULL Constraint: 00:05:00</p></div><div><div><p>•UNIQUE Constraint: 00:04:00</p></div><div><div><p>•DEFAULT Constraint: 00:04:00</p></div><div><div><p>•Foreign Keys: 00:08:00</p></div><div><div><p>•Use Foreign Keys with Joins - Books &amp; Publishers: 00:06:00</p></div><div><div><p>•Foreign Keys - Properties: 00:06:00</p></div><div><div><p>•Drop Column: 00:01:00</p></div><div><div><p>•DROP Table: 00:01:00</p></div><div><div><p>•Create a New Table with Select Statement: 00:05:00</p></div><div><div><p>•A Trick to Create an Empty Table with Select Statement: 00:03:00</p></div><div><div><p>•Insert New Records Using Select Statement: 00:06:00</p></div><div><div><p>•Views: 00:03:00</p></div><div><div><p>•Schemas: 00:02:00</p></div><div><div><p>•Create &amp; Use Schemas: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resources - SQL Programming Masterclass: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Computing Skills

Microsoft SQL Server

Microsoft SQL

Computer Programming

SQL Programming Masterclass

Academy for Health and Fitness

Level 7 Diploma in PR : Public Relation

Bournemouth

London Waterloo Academy

Flight Attendant

Stewardess

FLIGHT ATTENDANT VIRTUAL VIA ZOOM COURSE, EVENINGS

Registration Fee

Course Fee

Tom Reynolds

Product Management

Agile

Agile PM

Productivity

Kanban

Agile Coach

Attend our world class Kanban University accredited Certified Kanban System Design training course and learn to implement Kanban in your company

Certified Kanban System Design – KMP I - 24-26 September

Standard

Early Bird

<h4 style="color: rgb(12, 46, 63); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(12, 46, 63);">Hello and thank you for joining us.</h4><h4 style="color: rgb(12, 46, 63); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(12, 46, 63);">In this WebWorkshop, you will learn:</h4><ul style="color: rgb(12, 46, 63); box-sizing: border-box;" fr-original-style=" color: rgb(12, 46, 63);"><li 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;">How to get everyone home safe every day.</p></li><li 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;">How to shift from &lsquo;doing&rsquo; safety to &lsquo;being&rsquo; safe.</p></li><li 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;">How to accommodate humans for being human.&nbsp;</p></li><li 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;">How the definition of safety must move beyond the physical to include psychological, emotional and spiritual.</p></li></ul><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">We run these WebWorkshops in a way which makes the information stick. You will not get an hour of PowerPoint slides, and instead will be taken on a journey through what Compassionate Safety is and what it can achieve.</span></div>

Hello and thank you for joining us.In this WebWorkshop, you will learn:
How to get everyone home safe every day.
How to shift from ‘doing’ safety to ‘being’ safe.
How to accommodate humans for being human.
How the definition of safety must move beyond the physical to include psychological, emotional and spiritual.
We run these WebWorkshops in a way which makes the information stick. You will not get an hour of PowerPoint slides, and instead will be taken on a journey through what Compassionate Safety is and what it can achieve.

Ppwd Consulting

PPWD’s Compassionate Safety approach generates environments that accommodate humans for being human. Our approach aligns personal and organisational mindsets, beliefs and values. In doing so, workplaces are created where people thrive and flourish.

PPWD Compassionate Safety WebWorkshop

<p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(37, 46, 57);">When it comes to designing our dream future, there are a few &nbsp;aspects to be considered...</p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);">Firstly, amongst the chaos, how often do we actually create space to think about what we genuinely want for ourselves?</p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);">And then when we do, are they our own desires, or someone else&#39;s?</p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Vision boards help you to gain clarity</strong>&nbsp;on what you truly want from life</p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);">I will teach you to&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">connect&nbsp;</strong>back in with your&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">core values,&nbsp;</strong>an overview behind&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">manifestation</strong>&nbsp;and how our early life experiences may have impacted us now (positively and negatively).</p><ul style="color: rgb(37, 46, 57); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><li fr-original-style="" style="box-sizing: border-box;">Experience a short meditation to clear and open the mind</li><li fr-original-style="" style="box-sizing: border-box;">Identify your big dreams and goals, your values and how this aligns with your identity and purpose.</li><li fr-original-style="" style="box-sizing: border-box;">Create your unique vision board from scratch.</li></ul><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);">The Workshop will be a hybrid of meditation, fun and networking helping you to connect back in with who you truly are, your centre of creativity, and visualise your dream life.</p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);">This is for you if you say yes to one or more of the following:</p><ul style="color: rgb(37, 46, 57); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><li fr-original-style="" style="box-sizing: border-box;">you are ready to explore what you want from life</li><li fr-original-style="" style="box-sizing: border-box;">you feel stuck and uninspired</li><li fr-original-style="" style="box-sizing: border-box;">you have a vision, but you want to have a daily reminder of your dreams and goals</li><li fr-original-style="" style="box-sizing: border-box;">you want to manifest your vision or dream life quicker</li><li fr-original-style="" style="box-sizing: border-box;">you would like to passionately connect with your goals and dreams</li><li fr-original-style="" style="box-sizing: border-box;">you would like to connect with your sacral chakra and instil some creativity into your energy</li></ul><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Are you ready to create the life that lights you up?</strong></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Resources required:</strong></em><em fr-original-style="" style="box-sizing: border-box;">&nbsp;</em></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;">Everyone: Notepad + pen, quiet space for reflection.&nbsp;</em></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;">If you know you definitely want to create your Vision Board on your Computer, then please come ready with access to Microsoft word or Canva. &nbsp;</em></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;">Otherwise (and this is my favourite way to start a vision board experience), you will also need;</em></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;">Access to images that you can cut out. &nbsp;Here are some ideas on building your portfolio of images:</em></p><ul style="color: rgb(37, 46, 57); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">buy your favourite magazine/ ask around your friends/ family if you can have it rather than being thrown away</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">local supermarkets that offer their free magazine</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">travel agents&nbsp;</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">keep hold of local magazines/ newspapers/ flyers dropped through the door</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">photos that you don&#39;t mind cutting up</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">celebratory cards</em></li></ul><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;">Please also have access to A3 card (you can buy these from craft stores) ; scissors, glue.</em></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;">You can go super creative here as much as you would like; feathers, sparkle. you could even connect with the outdoors if you know how to preseve your items.&nbsp;</em></p>

Sinéad Robertson

Personal Development

Mindfulness

Life Coaching

Manifestation & Law of Attraction

Meditation

Creative Therapy

𝐃𝐢𝐝 𝐘𝐨𝐮 𝐤𝐧𝐨𝐰?
😍Vision Boards improves your chance of success! 
Here's just a few benefits from the process of vision boarding ⤵️
🔸 Helps you to connect with what you truly want from life;
🔸 Shift your mindset;
🔸 Provides a tool to align and focus your goals
And are a great opportunity to meet new and like minded people!
I'm looking forward to hosting this vision board workshop with you.  
🙏🏻Give me a shout if you have any questions.

Design your Dream Life Vision Board

<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>

Nexus Human

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Microsoft Power Platform

Microsoft BI

Data Analyst

PL-300T00 Microsoft Power BI Data Analyst

<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>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>

Azure PowerShell

Powershell

Microsoft AZ-104

Power Automate

Microsoft AZ-303

Microsoft Power Automate

AZ-040T00 Automating Administration with Powershell

Loughborough

<div>
		

		<div>
			
			<p>Recruiting great people to our organisations is the key to high performance and sustainable business success.</p>
			<div><i></i> 2 x 4 hour sessions</div>
			<div><i></i>  £358.80 incl. VAT</div>
			
			
		</div>
	</div>

	

	<div id="filters">
		
		
	</div>

	

    <div>

		
		 
		

		<div></div>

		<div>
			<p>Want to run this event in-house?  Enquire about running this event in-house </p>
			
		</div>

		<div>
			<p>Interested in attending? Have a suggestion about running this event near you?<br />Register your interest now</p>
			
		</div>
	</div>
	<div></div>
	
		
        <div>
			
		</div>
				

	
		<h3>Description</h3>
		<p></p><p>Recruiting great people who not only meet our organisation's needs but also uphold our core values and beliefs has become increasingly important as we navigate the volatility of the post-pandemic employment market. As costs continue to rise, and we experience challenging times in retaining great people, the pressure is on to ensure we recruit those people who offer best fit with our organisations. This training and development course is aimed at early career leaders and managers responsible for recruitment and selection for their departments and teams. It is designed to stimulate and challenge our thinking about how to recruit great people who will, not only meet the needs of the job role, but fit with, and make a valuable contribution to, the wider organisation.</p>
<p></p>
	
		<h3>Target Student</h3>
		<p></p><p>This session is suitable for early careers leaders and managers who have, or will have, responsibility for recruitment and selection in their teams/departments.</p>
<p></p>
	
		<h3>Modules/Lessons</h3>
		<p></p><p>By the end of this course, participants will understand:</p>
<ul>
<li>the importance of designing effective, authentic recruitment and selection processes</li>
<li>how to ensure these processes reflect organisational values</li>
<li>how to design selection processes that better assess values fit with the organisation</li>
<li>how to make recruitment and selection both meaningful and inclusive</li>
<li>how to attract, and get the very best from, the strongest applicants</li>
</ul>
<p></p>

Mpi Learning - Professional Learning And Development Provider

Recruiting great people to our organisations is the key to high performance and sustainable business success.

Values Based Recruitment

<p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What is the workshop about?</strong></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);">Acceptance and Commitment Therapy (ACT) is a distinctive empirically-based psychological intervention that uses acceptance and mindfulness strategies, alongside commitment and behavior change techniques. A key objective is to work with the client to increase psychological flexibility. This focus on flexibility involves helping the client contact the present moment fully as a conscious human being.</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);">As part of the &#39;Third Wave&#39; of psychological therapies, ACT is not simply about overcoming pain or fighting emotions; but rather focuses on embracing life and experiencing everything it has to offer. Rather than suppress or avoid psychological experiences, ACT is based on the idea that acceptance and mindfulness can be more productive responses to the ups and down of life.</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);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What will the workshop cover? (indicative)</strong></p><ol style="color: rgb(57, 54, 79); box-sizing: border-box;" fr-original-style=" color: rgb(57, 54, 79);"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Introduction</strong></li><li fr-original-style="" style="box-sizing: border-box;">Foundations of ACT as a Third Wave therapy</li><li fr-original-style="" style="box-sizing: border-box;">Core Ideas in ACT - Accept, Choose, Take Action</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The Model of Psychological Flexibility</strong></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">- Acceptance</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">- Cognitive Defusion</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">- Being Present</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">- Self as Context</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">- Values</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">- Committed Action</em></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Practical Techniques in ACT</strong></li><li fr-original-style="" style="box-sizing: border-box;">- Metaphors</li><li fr-original-style="" style="box-sizing: border-box;">- Acceptance Activities</li><li fr-original-style="" style="box-sizing: border-box;">- Values exploration</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Case Study</strong></li><li fr-original-style="" style="box-sizing: border-box;">Application of ACT to ourselves as therapists</li><li fr-original-style="" style="box-sizing: border-box;">Contemporary applications, research and limitations of ACT</li><li fr-original-style="" style="box-sizing: border-box;">Summary</li></ol><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">How will the workshop be develivered?</strong></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);">Using a combination of interactive examples, case studies, video, exposition and small group work, the workshop will seek to engage attendees fully. A full set of the slides and anonymised audiences responses will be available to all delegates free of charge after the workshop.</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);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who should attend?</strong></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);">This workshop is aimed at therapists, counsellors, advisers, educationalists, health care workers, social workers and students in these areas. It is particularly useful for counsellors who do not normally work within an Acceptance and Commitment model but want to explore tried and tested techniques. Similarly, counsellors and therapists working within this tradition are likely to find this workshop a useful refresher in the latest approaches. It is also suitable for anyone with an interest in contemporary practice in this area.</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);"></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);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Delegate comment from this series</strong></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);">"An amazing training so much content in a short space of time and at that incredibly easy to follow and take all in."</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);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What have previous delegates said about previous workshops (webinar and F2F?)</strong></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);">"Educational", "Enjoyable"," Helpful", Excellent", "Informative", "Insightful"</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);">"Thoroughly enjoyed today&#39;s workshop. Most definitely learned a lot" "Brilliant" "Really helpful day""Very enjoyable and well presented""Lot&#39;s to think about and take back to practice" "Excellent - varied and comfortable". "Excellent workshop. Enjoyed all areas"</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);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Resources</strong></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);">A full set of slides with extensive clickable links to online resources, is sent free to all delegates after the event. This also includes references to key sources.</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);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">CPD</strong></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);">A CPD Certificate of Attendance confirming 2 hours skills CPD is available free on request to all delegates who attend.</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);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Facilitator</strong></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);">Professor Patrick McGhee is a CBT therapist, psychologist and UK National Teaching Fellow. Educated at the universities of Glasgow and Oxford, he has completed CPD programmes at Harvard Business School and Ashridge. In 2017 he was a Visiting Fellow/Scholar at the universities of Cornell, Yale and MIT in the USA. He has taught, researched or practised in psychology and therapy for 30 years. His first post was a Research Fellow in Psychiatry and Psychology at St George&#39;s Hospital Medical School, University of London. He is the author of Thinking Psychologically (Palgrave) and co-editor of Accounting for Relationships (Methuen). He is an occasional columnist for the Guardian, the BBC and the Times Higher. He currently works in private practice in Greater Manchester and Lancashire. He has full accreditation from the British Association for Behavioural and Cognitive Psychotherapists.</p>

Practical CBT

Psychological Wellbeing Practitioner

Cognitive Behavioural Therapy (CBT)

Therapist

Acceptance & Commitment Therapy

Psychological Skills

Acceptance and Commitment Therapy (ACT) - A Practical Introduction

<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>

1835 Courses

SQL Programming: The SQL Database Programming Fundamentals Complete Training Course

By One Education

SQL Programming: The SQL Database Programming Fundamentals Complete Training Course

By One Education

Worry Control with Cognitive Behavioral Therapy at QLS Level 3 Course

By One Education

Elementor - Build Amazing WordPress Pages with Elementor

By Packt

Microsoft SQL Server Development for Everyone

By Packt

ILM Level 5 Award In Leadership And Management

By School of Business and Technology London

Cross-Cultural Awareness Training

By Apex Learning

Duties and Responsibilities of a Care Worker Course

By Training Express

SQL Programming Masterclass

By Apex Learning

Level 7 Diploma in PR : Public Relation

By Academy for Health and Fitness

Search By Location