Name: Level 3 Health and Social Care with Care Assistance Training Course
Price: 999 GBP
Availability: InStock

<strong>Welcome to this beginner's level course on Microsoft SQL Servers. Understand the concepts of SQL and learn to create a new database and table to perform various operations on it, with live running queries as examples. Work on hands-on exercises and understand database concepts in a real-world scenario.</strong>
        <p>SQL Server is a relational database management system (RDBMS) developed by Microsoft. SQL Server also allows user-defined composite types (UDTs) to be used. The SQL Server services operate within SQL server instances, allowing people to do machine learning and data analytics.

In this course, you will understand the difference between SQL and NoSQL. You will query SQL and learn about built-in SQL functions. You will create and modify databases and tables using the CREATE DATABASE and CREATE TABLE statements. You will create, select, and modify records and create constraints in SQL. You will advance to create indexes, drop tables, and databases in SQL. You will learn about operators (AND, OR, NOT, LIKE, BETWEEN, IN, LIKE), functions, statements, and constraints in SQL. You will look at stored procedures and aliases, and learn to back up databases in SQL. You will use the WHERE clause to query and learn about the SELECT and DISTINCT functions. You will arrange data using the ORDER BY keyword and ASC and DESC keywords.

After completing the course, you will thoroughly understand SQL's features and components. You will create complex databases and maintain existing databases. Finally, you will acquire complex SQL query capabilities and write complex queries.

All resources are available at: https://github.com/PacktPublishing/SQL-Server-Course-for-Beginners-with-100-examples</p>
        <h2>What You Will Learn</h2><p>Create databases and tables from the start<br>Learn to handle MySQL queries<br>Learn to query SQL to manipulate records in tables<br>Explore functions, statements, and constraints in SQL<br>Create and maintain complex databases and table structures<br>Write complex query statements for maximum data optimization</p>
        <h2>Audience</h2><p>This course delivers a substantial learning experience for database creators, web developers, application developers, and programmers who must operate with SQL and database structures. Database analysts and administrators who are looking to advance/refresh their knowledge skillsets can benefit from this course. The course has no additional prerequisites besides basic computer use knowledge.</p>
        <h2>Approach</h2><p>Well-structured and high-quality video lectures provide step-by-step explanations in a tutorial-like environment, making it easily understandable for beginners about a new database, tables, and their features with live running queries as examples. The course also provides carefully created quizzes to refresh and hone your SQL skillsets.</p>
        <h2>Key Features</h2><p>Understand the SQL query process and the role of databases in real-world applications * Create new databases and tables and perform operations to manipulate records using SQL queries * Master SQL querying and write complex query statements to enhance your understanding of MySQL</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/SQL-Server-Course-for-Beginners-with-100-examples</p>
        <h2>About the Author</h2><h3>Amit Diwan</h3><p>Studyopedia was founded by Amit Diwan in 2018 after working for Tutorialspoint , IIT, IASRI, Sitepoint, DU, and C# Corner. Studyopedia sells courses on Udemy, Tutorialspoint, Geeksforgeeks, and Skillshare, providing video courses to master various technologies and programming languages, databases, frameworks, Python, data science, machine learning, Java, Android, C/C++, HTML5, Bootstrap, JavaScript, jQuery, PHP, CSS, WordPress, Drupal, Joomla, Magento, osCommerce, OpenCart, PrestaShop, and other disciplines. Studyopedia delivers high-quality video courses to millions of students and professionals enrolled through their website on multiple programming languages and technologies.</p>
        <h2>Course Outline</h2><h4>1. SQL Introduction</h4><p>This section focuses on a cursory introduction to SQL, the benefits of using SQL, and also the features of SQL.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>Learn what SQL is and how it is based on RDBMS. We will discuss the features and Microsoft SQL Server and SQL Server Management Studio.</p></td></tr><tr><td style='padding: 15px;'><p>2. SQL Versus NoSQL</p><p style='margin: 0'>Learn the difference between SQL and NoSQL. We have considered the example of MySQL (SQL-based) and MongoDB (NoSQL-based) to understand the concept.</p></td></tr></tbody></table><br><h4>2. SQL Installation and Setup</h4><p>This section focuses on the installation and setup process of SQL server over Windows 10 and 11 and also to fix installation errors.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Install SQL Server on Windows 10</p><p style='margin: 0'>Learn how to download and install Microsoft SQL Server on Windows 10. We will also install SQL Server Management Studio (SSMS).</p></td></tr><tr><td style='padding: 15px;'><p>2. Install SQL Server on Windows 11</p><p style='margin: 0'>Learn how to download and install Microsoft SQL Server on Windows 11. We will also install SQL Server Management Studio (SSMS).</p></td></tr><tr><td style='padding: 15px;'><p>3. Fix SQL Server Installation Error</p><p style='margin: 0'>While installing SQL Server, you may get the following error: Learn how to fix the following error while installing Microsoft SQL Server 2019: A required file could not be downloaded. This could mean the version of the installer is no longer supported.</p></td></tr></tbody></table><br><h4>3. Create and Insert</h4><p>This section focuses over creating a database and table and adding records or populating the table and database.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Create a Database</p><p style='margin: 0'>Learn how to create a new database in SQL Server. The CREATE DATABASE statement is used to create a new SQL server database.</p></td></tr><tr><td style='padding: 15px;'><p>2. Create a Table</p><p style='margin: 0'>Learn how to create a new table with SQL Server. The CREATE TABLE statement is used to create a new table in SQL Server.</p></td></tr><tr><td style='padding: 15px;'><p>3. Insert Records</p><p style='margin: 0'>Use the INSERT INTO Statement in SQL to learn how to insert records in a table.</p></td></tr></tbody></table><br><h4>4. Select Records in SQL</h4><p>This section delves over records in SQL, how to select them, how to select distinct elements, and use the where clause to segregate records.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. SELECT Statement in SQL</p><p style='margin: 0'>Learn how to select records in SQL using the SELECT statement. We will also see how to choose multiple columns in a single query.</p></td></tr><tr><td style='padding: 15px;'><p>2. SELECT DISTINCT Statement in SQL</p><p style='margin: 0'>Learn how to select and return only distinct values from a table using the SQL SELECT DISTINCT statement.</p></td></tr><tr><td style='padding: 15px;'><p>3. WHERE Clause in SQL</p><p style='margin: 0'>Learn how to work with the WHERE clause in SQL. WHERE clause filters records based on condition(s).</p></td></tr></tbody></table><br><h4>5. Order Records in SQL</h4><p>This section focuses on the order records function of SQL using the ORDER BY keyword.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. ORDER BY Keyword in SQL</p><p style='margin: 0'>Learn how to order records in SQL using the ORDER BY keyword. The default sorts in ascending order. We will see examples of both ASC and DESC keywords as well.</p></td></tr></tbody></table><br><h4>6. Operators in SQL</h4><p>This section focuses on the arithmetic and logical operators used in SQL, including AND, OR, NOT, IN, BETWEEN, and LIKE.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. AND Operator</p><p style='margin: 0'>Learn how to work with the AND operator in SQL to display records only if both conditions are TRUE. These two conditions should be separated by the AND operator.</p></td></tr><tr><td style='padding: 15px;'><p>2. OR Operator</p><p style='margin: 0'>Learn how to work with the OR operator in SQL to display records only if one condition is TRUE. The OR operator should separate these two conditions.</p></td></tr><tr><td style='padding: 15px;'><p>3. NOT Operator</p><p style='margin: 0'>Learn how to work with the NOT operator in SQL to display records only if the condition isn't met, that is, FALSE.</p></td></tr><tr><td style='padding: 15px;'><p>4. IN Operator</p><p style='margin: 0'>Learn how to implement the IN operator in SQL. We will check whether a specific value matches.</p></td></tr><tr><td style='padding: 15px;'><p>5. BETWEEN Operator</p><p style='margin: 0'>Learn how to implement the BETWEEN operator in SQL. We will find values in a range.</p></td></tr><tr><td style='padding: 15px;'><p>6. LIKE Operator</p><p style='margin: 0'>Learn how to implement the LIKE operator in SQL. We will find values based on a specific pattern using percentages and underscore.</p></td></tr></tbody></table><br><h4>7. Built-In Functions in SQL</h4><p>This section focuses on the built-in functions in SQL and helps us understand maximum, minimum, sum, average, and count functions in detail.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. MAX() Function</p><p style='margin: 0'>Learn how to implement the MAX() function in SQL. We will find the maximum of column values.</p></td></tr><tr><td style='padding: 15px;'><p>2. MIN() Function</p><p style='margin: 0'>Learn how to implement the MIN() function in SQL. We will find the minimum of column values.</p></td></tr><tr><td style='padding: 15px;'><p>3. SUM() Function</p><p style='margin: 0'>Learn how to implement the SUM() function in SQL. We will find the sum of column values.</p></td></tr><tr><td style='padding: 15px;'><p>4. AVG() Function</p><p style='margin: 0'>Learn how to implement the AVG() function in SQL. We will find the average of column values.</p></td></tr><tr><td style='padding: 15px;'><p>5. COUNT() Function</p><p style='margin: 0'>Learn how to implement the COUNT() function in SQL. We will find the count of the number of rows.</p></td></tr></tbody></table><br><h4>8. Constraints in SQL</h4><p>This section focuses on constraints in SQL and the different types of constraints that can be used to manipulate data.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. NOT NULL Constraint</p><p style='margin: 0'>Learn how to work with the NOT NULL constraint in SQL to enforce a column with values, that is, not null. Remember, as columns can have NULL by default, we use the NOT NULL constraint to enforce a column NOT to accept values.</p></td></tr><tr><td style='padding: 15px;'><p>2. UNIQUE Constraint</p><p style='margin: 0'>Learn how to work with the UNIQUE constraint in SQL to uniquely identify each record in a database table. It enforces the uniqueness of column values.</p></td></tr><tr><td style='padding: 15px;'><p>3. PRIMARY KEY Constraint</p><p style='margin: 0'>Learn how to work with the PRIMARY KEY constraint in SQL. A PRIMARY KEY uniquely identifies each record. Not a Primary Key column can never have NULL values.</p></td></tr><tr><td style='padding: 15px;'><p>4. FOREIGN KEY Constraint</p><p style='margin: 0'>Learn how to work with the FOREIGN KEY constraint in SQL. A FOREIGN KEY is a field in one table that refers to the PRIMARY KEY in another. A child table is a table with a foreign key.</p></td></tr><tr><td style='padding: 15px;'><p>5. CHECK Constraint</p><p style='margin: 0'>Learn how to work with the CHECK constraint in SQL to allow only specific values for a column. You can limit the value range set in a column, for example, Age > 18, Marks > 75, and so on.</p></td></tr></tbody></table><br><h4>9. Alter and Update in SQL</h4><p>This section focuses on the ALTER TABLE and UPDATE TABLE functions in SQL that allow us to manipulate records in a table.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. ALTER TABLE Statement</p><p style='margin: 0'>Learn how to work with the ALTER TABLE in SQL to add or delete columns in the existing table. To add a column to an existing table, use the ALTER TABLE with ADD command. To delete a column from an existing table, use the ALTER TABLE with DROP COLUMN.</p></td></tr><tr><td style='padding: 15px;'><p>2. UPDATE Statement</p><p style='margin: 0'>Learn how to work with the UPDATE statement in SQL to update existing records in a table. Use the WHERE clause with the UPDATE statement to avoid updating all records in the table.</p></td></tr><tr><td style='padding: 15px;'><p>3. Aliases</p><p style='margin: 0'>Learn how to work with Aliases in SQL to give a temporary name to a table or column. The AS keyword creates an alias, making column names more readable. Remember that the alias's existence expires when that query's duration ends.</p></td></tr></tbody></table><br><h4>10. Advanced SQL</h4><p>This advanced section delves deep into stored procedures, indexes, and other advanced statements. We will also look at backing up a database and removing tables from a database.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Stored Procedures in SQL</p><p style='margin: 0'>Use the CREATE PROCEDURE statement to learn how to work with stored procedures in SQL. If you want to reuse a query again and again, then create a procedure and save the query in it. Call the procedure whenever you need that same query. Therefore, stored procedures work like a function.</p></td></tr><tr><td style='padding: 15px;'><p>2. Indexes in SQL</p><p style='margin: 0'>Learn how to work with the CREATE INDEX statement in SQL to create indexes in a table. Indexes retrieve data quickly from the database. We will also see how to delete indexes using the DROP INDEX statement.</p></td></tr><tr><td style='padding: 15px;'><p>3. SELECT INTO Statement in SQL</p><p style='margin: 0'>Learn how to work with the SELECT INTO statement in SQL to create a backup copy of your table to a new table. The new table will have the same type and columns as in the first.</p></td></tr><tr><td style='padding: 15px;'><p>4. SELECT TOP Clause in SQL</p><p style='margin: 0'>Learn how to implement the SELECT TOP statement in SQL. We will work with the SELECT TOP PERCENT statement as well.</p></td></tr><tr><td style='padding: 15px;'><p>5. Back Up a Database in SQL</p><p style='margin: 0'>Learn how to back up a database in SQL. We will back up the database in a local directory with the extension .bak.</p></td></tr><tr><td style='padding: 15px;'><p>6. SQL Views</p><p style='margin: 0'>Learn how to work with Views in SQL. A view is a virtual table created from the actual table, displaying the current result set. We will use the CREATE VIEW and DROP VIEW statements to develop and delete views.</p></td></tr><tr><td style='padding: 15px;'><p>7. Drop a Table in SQL</p><p style='margin: 0'>Learn how to drop a table in SQL. Dropping will delete all the records of the table. It will also obliterate the existence of the table.</p></td></tr></tbody></table>

Packt

Database Programming

SQL Server

MySQL

Welcome to this beginner's level course on Microsoft SQL Servers. Understand the concepts of SQL and learn to create a new database and table to perform various operations on it, with live running queries as examples. Work on hands-on exercises and understand database concepts in a real-world scenario.

SQL Server Course for Beginners with 100+ examples

General Admission

<p><strong>***Note: This Price is Valid for the First 50 Lucky Learners***</strong></p><p>|NCFE CACHE Level 3 Teaching Assistant Training |</p><p>Develop a cooperative connection with the students and acquire the skills necessary to satisfy the support requirements of youngsters by this <strong>NCFE CACHE Level 3 Award in Supporting Teaching and Learning </strong>qualification. Strengthen your interaction, cooperation, flexibility, empathy, and patience qualities while delivering an engaging classroom presence, real-world learning value, best-practice exchange, and a lifetime love of learning.</p><p>This Ofqual-regulated <strong>NCFE CACHE Level 3 Teaching Assistant </strong>qualification is both inspirational and manageable to grasp. It will provide learners with a grasp of the knowledge required when working directly with children and young people in a school or college setting. The certification includes topics such as child and adolescent development as well as child and adolescent welfare. You'll be able to analyse, make inferences from, interpret, and rationalise occurrences or environments involving children.</p><p>You can get access to the remarkable <strong>Speech Therapy and SEN Teaching Assistant Course, Teaching Assistant</strong> and<strong> EYFS and Phonics Teaching Diploma - </strong>CPD courses for free with this widely acclaimed <strong>NCFE CACHE Level 3 Award in Supporting Teaching and Learning</strong> qualification!</p><p>Enrol right away to get ahead of the competition by taking part in this one-of-a-kind qualification!</p><p><strong>Learning outcome of NCFE CACHE Level 3 Teaching Assistant Qualification</strong></p><ul><li>Gain an understanding of the expected teaching assistant pattern and influencing development factors for children and young people from birth to 19 years.</li><li>Determine teaching assistant legislation, guidelines, policies and procedures for safeguarding children and young people.</li><li>Respond as a teaching assistant to evidence that a child or young person has been abused or harmed and take proper actions.</li><li>Recognise and manage risks as a teaching assistant to health, safety and security in a learning environment or during off-site visits.</li><li>Acknowledge the teaching assistant responsibilities and accountabilities concerning the administration of medication.</li><li>Learn more about the educational ethos, mission aims and values essential for a teaching assistant to perceive</li></ul><p><strong>Qualification Key facts:</strong></p><ul><li>Qualification Title: NCFE CACHE Level 3 Award in Supporting Teaching and Learning</li><li>Qualification number: 603/2495/8</li><li>Learning aim reference: 60324958</li><li>Credit value: 12</li><li>Assessment method: Portfolio of evidence</li><li>Guided learning hours (GLH): 80</li><li>Total qualification time (TQT): 120</li><li>Features: Nested Qualification</li></ul><p><strong>What is a Nested Qualification?</strong></p><p>This <strong>NCFE CACHE Level 3 Award in Supporting Teaching and Learning </strong> qualification is nested. Qualifications within a nested suite allow learners to be topped up to a qualification that is the same level and subject within the Award, Certificate, Diploma structure.</p><p><strong>14 DAYS MONEYBACK GUARANTEE:</strong><br />Experience worry-free learning with our 14-day unconditional money-back guarantee. If you're not completely satisfied with your purchase, simply let us know, and we'll give you a full refund. No questions asked. Invest in your future today, and shine bright with the knowledge and skills you'll gain through our learning program!</p><p><strong>****Qualification Curriculum of Level 3 Teaching Assistant****</strong></p><p>Students have to complete the following units to achieve 12 credits of <strong> NCFE CACHE Level 3 Award in Supporting Teaching and Learning Qualification.</strong></p><ul><li><strong>Unit 1:</strong> Schools and colleges as organisations</li><li><strong>Unit 2:</strong> Support health and safety in a learning environment</li><li><strong>Unit 3:</strong> Understand how to safeguard children and young people</li><li><strong>Unit 5:</strong> Understand how children and young people develop</li></ul><p><strong>Curriculum Details of Level 3 Teaching Assistant:</strong></p><p><strong>***Level 3 Teaching Assistant Unit 1: Schools and colleges as organisations</strong></p><ul><li>Unit number: T/616/5878</li><li>Credit: 2</li><li>GLH: 10</li><li>Level: 3</li></ul><p><strong>Unit Introduction:</strong> This unit aims to prepare the learner for working in a learning environment. It covers knowledge and understanding of the structure of education; how schools and colleges are organised; ethos, mission, aims and values; policy frameworks; and the broader context in which schools and colleges operate.</p><p><strong>***Level 3 Teaching Assistant Unit 2: Support health and safety in a learning environment</strong></p><ul><li>Unit number: A/616/5879</li><li>Credit: 3</li><li>GLH: 20</li><li>Level: 3</li></ul><p><strong>Unit Introduction:</strong> This unit provides the knowledge and understanding required to support children and young people's health and safety in a learning environment.</p><p><strong>***Level 3 Teaching Assistant Unit 3: Understand how to safeguard children and young people</strong></p><ul><li>Unit number: M/616/5880</li><li>Credit: 4</li><li>GLH: 25</li><li>Level: 3</li></ul><p><strong>Unit Introduction:</strong> This unit provides the knowledge and understanding required to support the safeguarding of children and young people.</p><p><strong>*** Unit 5: Understand how children and young people develop</strong></p><ul><li>Unit number: A/616/5882</li><li>Credit: 3</li><li>GLH: 25</li><li>Level: 3</li></ul><p><strong>Unit Introduction:</strong> This unit provides knowledge and understanding of how children and young people develop from birth to 19 years, including underpinning theoretical perspectives. It also includes actions taken when differences in development are identified.</p><p><strong>Total Qualification Time of Level 3 Teaching Assistant</strong></p><p>This is an estimate of the total length of time it is expected that a learner will typically take to achieve and demonstrate the level of attainment necessary for the award of the qualification, i.e. to achieve all learning outcomes.</p><p>Total Qualification Time comprises GLH and an estimate of the number of hours a learner is likely to spend in preparation, study or any other learning, including assessment, which takes place as directed by, but not under the supervision of a lecturer supervisor or tutor. The credit value, where given for qualification, is determined by TQT, as one credit corresponds to 10 hours of learning.</p><p><strong>Total Qualification Time for this qualification is 120 hours.</strong></p><p><strong>Total Credit Value for this qualification is 12</strong></p><p><strong>Guided Learning Hours</strong></p><p>These hours are made up of all real-time contact time, guidance or supervision of a learner by a lecturer, supervisor, tutor, trainer or other appropriate provider of education or training.</p><p><strong>GLH for this qualification is 80.</strong></p><p><strong>Method of Assessment of Level 3 Teaching Assistant:</strong></p><p>Internally assessed and externally quality assured portfolio of evidence.</p><p>All units will be internally assessed using various methods, including multiple assignments or tasks such as designing a leaflet or booklet, charts or diagrams, or setting up an information board.</p><p><strong>Certification of Level 3 Teaching Assistant</strong></p><p>Successful candidates will be awarded an Ofqual regulated certificate for <strong> NCFE CACHE Level 3 Award in Supporting Teaching and Learning </strong>qualification<strong>. </strong></p><p>Also, you can earn three CPD certificates from One Education for the <strong>EYFS and Phonics Teaching Diploma, Teaching Assistant and Speech</strong><strong> Therapy and SEN Teaching Assistant </strong>Courses<strong>.</strong></p><p><strong>Progression</strong></p><p>This <strong>NCFE CACHE Level 3 Award in Supporting Teaching and Learning</strong> qualification aims to provide learners with a number of progression options, including higher-level studies at university or FE colleges.</p><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p><strong>Level 3 Teaching Assistant</strong></p><p>The <strong>NCFE CACHE Level 3 Award in Supporting Teaching and Learning</strong> qualification is appropriate for:</p><ul><li>Those who want to start an initial training.</li><li>Beginners who are interested in gaining in-demand teaching skills.</li><li>Individuals who wish to gain formal recognition of their abilities.</li><li>Students who want to study from home at their own convenience.</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p><strong>Level 3 Teaching Assistant</strong></p><ul><li>There are no specific entry requirements, but we recommend that learners have a minimum level 2 qualification.</li><li>The qualification is suitable for learners 16 years old or above.</li></ul>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p><strong>Level 3 Teaching Assistant</strong></p><p>You will be eligible to work in the following sectors after attaining the <strong> NCFE CACHE Level 3 Award in Supporting Teaching and Learning </strong>qualification:</p><ul><li>Teaching Assistant</li><li>Learning Support Assistant</li><li>Special Needs Assistant.</li><li>Specialist EY SEN Teaching Assistant</li><li>EY Phonics Specialist Teacher</li></ul>
                        </div>

One Education

Cache Level 3 Teaching Assistant & SEN Certificate Course

UK Wide Travel Costs

<p fr-original-style=" color: rgb(119, 119, 119);" id="isPasted" style="color: rgb(119, 119, 119); font-size: 16px; box-sizing: border-box;">This can be introduced in one day but is better offered over a series of twilight or half day workshops with individualised coaching. We will provide background context for this approach and will directly model the process with real live issues facing participants. So bring your most challenging concerns to this training.</p>

<p style="color: rgb(119, 119, 119); font-size: 16px; box-sizing: border-box;" fr-original-style=" color: rgb(119, 119, 119);"></p>

<h3 fr-original-style=" color: rgb(71, 199, 245);" style="color: rgb(71, 199, 245); box-sizing: border-box;">Course Category</h3>

<p fr-original-style=" color: rgb(119, 119, 119);" style="color: rgb(119, 119, 119); font-size: 16px; box-sizing: border-box;">Behaviour and Relationships
<br fr-original-style="" style="box-sizing: border-box;">Visioning and Problem Solving
<br fr-original-style="" style="box-sizing: border-box;">Team Building and Leadership</p>

<h3 fr-original-style=" color: rgb(71, 199, 245);" style="color: rgb(71, 199, 245); box-sizing: border-box;">Description</h3>

<p fr-original-style=" color: rgb(119, 119, 119);" style="color: rgb(119, 119, 119); font-size: 16px; box-sizing: border-box;">&lsquo;Insights and Solutions Circle&rsquo; a new expanded version of Solution Circle that uses some of the best of the Circle of Adults process. Its a 50 minute process and works really well with families and professionals! Contact us today for a live demo or training&hellip;</p>

<h4 fr-original-style=" color: rgb(71, 199, 245);" style="color: rgb(71, 199, 245); box-sizing: border-box;">Steps</h4>

<ol fr-original-style=" color: rgb(119, 119, 119);" style="color: rgb(119, 119, 119); box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Problem presented</li>
<li fr-original-style="" style="box-sizing: border-box;">Questions asked</li>
<li fr-original-style="" style="box-sizing: border-box;">Theories Shared</li>
<li fr-original-style="" style="box-sizing: border-box;">Strategies listed</li>
<li fr-original-style="" style="box-sizing: border-box;">Dialogue regarding selected strategies</li>
<li fr-original-style="" style="box-sizing: border-box;">Next steps</li>
</ol>

<h3 fr-original-style=" color: rgb(71, 199, 245);" style="color: rgb(71, 199, 245); box-sizing: border-box;">Testimonials</h3>
<div fr-original-style="" style="box-sizing: border-box;"><iframe width="560" height="315" src="https://www.youtube.com/embed/TB87aq0IjFQ" title="YouTube video player" frameborder="0" allowfullscreen="" fr-original-style="" style="box-sizing: border-box;"></iframe></div>
<div fr-original-style="" style="box-sizing: border-box;">
</div><blockquote fr-original-style=" color: rgb(119, 119, 119);" id="isPasted" style="color: rgb(119, 119, 119); border-left: 2px solid rgb(94, 53, 177); margin-left: 0px; padding-left: 5px; box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; box-sizing: border-box;">Excellent!</p></blockquote><blockquote fr-original-style=" color: rgb(119, 119, 119);" style="color: rgb(119, 119, 119); border-left: 2px solid rgb(94, 53, 177); margin-left: 0px; padding-left: 5px; box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; box-sizing: border-box;">It was great how we all cam up with ideas and theories including us parents</p></blockquote><blockquote fr-original-style=" color: rgb(119, 119, 119);" style="color: rgb(119, 119, 119); border-left: 2px solid rgb(94, 53, 177); margin-left: 0px; padding-left: 5px; box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; box-sizing: border-box;">I wish all meeting about my child&rsquo;s behaviour were like this</p></blockquote><blockquote fr-original-style=" color: rgb(119, 119, 119);" style="color: rgb(119, 119, 119); border-left: 2px solid rgb(94, 53, 177); margin-left: 0px; padding-left: 5px; box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; box-sizing: border-box;">The whole world is going to be interested in this&hellip;</p></blockquote><blockquote fr-original-style=" color: rgb(119, 119, 119);" style="color: rgb(119, 119, 119); border-left: 2px solid rgb(94, 53, 177); margin-left: 0px; padding-left: 5px; box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; box-sizing: border-box;">The empowerment is great</p></blockquote><blockquote fr-original-style=" color: rgb(119, 119, 119);" style="color: rgb(119, 119, 119); border-left: 2px solid rgb(94, 53, 177); margin-left: 0px; padding-left: 5px; box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; box-sizing: border-box;">The buzz after the meeting says it all.</p></blockquote><h3 fr-original-style=" color: rgb(71, 199, 245);" style="color: rgb(71, 199, 245); box-sizing: border-box;">Learning Objectives</h3><ol fr-original-style=" color: rgb(119, 119, 119);" style="color: rgb(119, 119, 119); box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Deeper understanding of what is actually happening underneath the presenting behaviour</li><li fr-original-style="" style="box-sizing: border-box;">Increased confidence in managing and building relationships with challenging pupils in mainstream schools</li><li fr-original-style="" style="box-sizing: border-box;">Learn process for locating richer and wider range of practical strategies to impact on behaviour problems</li><li fr-original-style="" style="box-sizing: border-box;">Deeper understanding of yourself and the psychodynamic processes happening between pupils, staff and pupils and families</li><li fr-original-style="" style="box-sizing: border-box;">Opportunity to reflect on professional practice</li><li fr-original-style="" style="box-sizing: border-box;">Mutual support established with other front line practitioners</li></ol><h3 fr-original-style=" color: rgb(71, 199, 245);" style="color: rgb(71, 199, 245); box-sizing: border-box;">Who Is It For ?</h3><ul fr-original-style=" color: rgb(119, 119, 119);" style="color: rgb(119, 119, 119); box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Team Around the Child agencies</li><li fr-original-style="" style="box-sizing: border-box;">Parents and Professional working together</li><li fr-original-style="" style="box-sizing: border-box;">Families</li><li fr-original-style="" style="box-sizing: border-box;">Multi Agency Teams</li><li fr-original-style="" style="box-sizing: border-box;">Social workers</li><li fr-original-style="" style="box-sizing: border-box;">CAMHS teams</li><li fr-original-style="" style="box-sizing: border-box;">Year Managers</li><li fr-original-style="" style="box-sizing: border-box;">Primary and secondary staff teams</li><li fr-original-style="" style="box-sizing: border-box;">Early Years and School based Practitioners</li><li fr-original-style="" style="box-sizing: border-box;">Heads and Deputies</li><li fr-original-style="" style="box-sizing: border-box;">SENCOs</li><li fr-original-style="" style="box-sizing: border-box;">Advanced Skills Teachers</li><li fr-original-style="" style="box-sizing: border-box;">Primary and secondary teachers</li><li fr-original-style="" style="box-sizing: border-box;">Local Authority Support Services</li></ul><h3 fr-original-style=" color: rgb(71, 199, 245);" style="color: rgb(71, 199, 245); box-sizing: border-box;">Course Content</h3><p fr-original-style=" color: rgb(119, 119, 119);" style="color: rgb(119, 119, 119); font-size: 16px; box-sizing: border-box;">This can be introduced in one day but is better offered over a series of twilight or half day workshops with individualised coaching. We will provide background context for this approach and will directly model the process with real live issues facing participants. So bring your most challenging concerns to this training.</p><p fr-original-style=" color: rgb(119, 119, 119);" style="color: rgb(119, 119, 119); font-size: 16px; box-sizing: border-box;">The course answers the questions:</p><ul fr-original-style=" color: rgb(119, 119, 119);" style="color: rgb(119, 119, 119); box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Can we find an alternative to permanent exclusion or special unit or school placement?</li><li fr-original-style="" style="box-sizing: border-box;">Cannot understand why a child is behaving as they do?</li><li fr-original-style="" style="box-sizing: border-box;">Struggling with a child for whom praise is ineffective?</li><li fr-original-style="" style="box-sizing: border-box;">Feeling isolated in your responses to a child&rsquo;s needs?</li><li fr-original-style="" style="box-sizing: border-box;">Worried about where your instinctive reactions are leading you?</li><li fr-original-style="" style="box-sizing: border-box;">Cannot seem to get any consensus view of a young person&rsquo;s behaviour/needs amongst all the family and professionals involved &ndash; is everyone pulling in different directions?</li></ul><p fr-original-style=" color: rgb(119, 119, 119);" style="color: rgb(119, 119, 119); font-size: 16px; box-sizing: border-box;">We will cover:</p><ul fr-original-style=" color: rgb(119, 119, 119);" style="color: rgb(119, 119, 119); box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Setting the tone</li><li fr-original-style="" style="box-sizing: border-box;">Background and detailed teaching of process</li><li fr-original-style="" style="box-sizing: border-box;">Inclusion values underpinning this work</li><li fr-original-style="" style="box-sizing: border-box;">Graphic and process facilitation skills</li><li fr-original-style="" style="box-sizing: border-box;">Processes modelled and opportunities to try process out with coaching</li><li fr-original-style="" style="box-sizing: border-box;">Practical setting up of insights and solutions circles</li><li fr-original-style="" style="box-sizing: border-box;">Lessons learned</li></ul><p fr-original-style=" color: rgb(119, 119, 119);" style="color: rgb(119, 119, 119); font-size: 16px; box-sizing: border-box;">If you liked this you may like:</p><p fr-original-style=" color: rgb(119, 119, 119);" style="color: rgb(119, 119, 119); font-size: 16px; box-sizing: border-box;"><a fr-original-style=" color: rgb(71, 199, 245);" href="https://inclusive-solutions.com/training/circles-of-adults/" style="color: rgb(71, 199, 245); user-select: auto; box-sizing: border-box; text-decoration: inherit; cursor: pointer;">CIRCLES OF ADULTS&hellip;</a></p><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">
</div>

Inclusive Solutions

INSIGHTS AND SOLUTIONS CIRCLE

Full Day

1-3 Hours / Half Day

We can supply our own PA system if you do not have your own for us to use

PA system

Written by Colin Newton and Derek Wilson. Price is per person

"Creating Circles of Friends" Book

UK Wide. Select this addon if you want us to travel to your location to deliver the course.

I will travel to the customer

Buxton

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Landscape Painting Workshop - Big Skies</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This exciting one-day workshop is set in the heart of the Peak National Park. My name is Pippa Pixley, I am a published author and artist. I will reveal how to master light within the landscape using various techniques.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We will start by understanding the fundamental principles of light and tone, experimenting with a range of mixed media materials, including how to make your own signature paint from pigment. I will show you how to translate and transcribe the landscape by slowing down and observing the landscape through sketching exercises.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You will discover how to apply contrast, colour theory, and tonal values to create beautiful skies that burst with light, dramatic seascapes and moody landscapes.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This workshop is suitable for beginners as well as anyone interested in creating beautiful landscapes. Everyone will complete this course feeling relaxed, refreshed and infused with creativity.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>

Pippa Pixley

art landscape big skies  creativity painting

Landscape Painting workshop

Loughborough

<div>
		

		<div>
			
			<p>Data Ethics for Business Professionals is designed for individuals who are seeking to demonstrate an understanding of the ethical uses of data in business settings.</p>
			<div><i></i> 6 hours or 3 x 90 min sessions</div>
			<div><i></i>  £45.00 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><span>This course empowers professionals to identify sources of ethical risk and move beyond transparency to understand all ethical principles while balancing business considerations of ethically driven technology.</span></p>
<p></p>
	
		<h3>Modules/Lessons</h3>
		<p></p><h4>Overview</h4>
<p>The power of extracting value from data utilizing Artificial Intelligence, Data Science and Machine Learning exposes the learning differences between humans and machines. Humans can apply ethical principles throughout the decision-making process to avoid discrimination, societal harm, and marginalization to maintain and even enhance acceptable norms. Machines make decisions autonomously. So how do we apply ethical principles to data driven technology? This course provides business professionals and consumers of technology core concepts of ethical principles, how they can be applied to emerging data driven technologies and the impact to an organization which ignores ethical use of technology.</p>
<h4>Course Length:</h4>
<p>6 hours instructional time Content is designed to be presented as a full day class, or in three 90-minute sessions by lesson.</p>
<h4>Course Content:</h4>
<p>Each lesson includes activities, indicated in orange and may include resources for learners to integrate ethical practices into their own organization, indicated in blue.</p>
<h4>Introduction to Data Ethics</h4>
<p>Define Ethics <br />Define Data <br />Define Data Ethics <br />Principles of Data Ethics <br />The Case for Data Ethics<br />Identifying Ethical Issues</p>
<h4>Ethical Principles</h4>
<p>Ethical Frameworks <br />Applying Ethical Frameworks <br />Privacy, Fairness, and Safety <br />Applying Privacy, Fairness, and Safety Principles <br />Algorithms and Human-Centered Values <br />Discussing True and False Positives and Negatives <br />Discussing Accuracy and Precision <br />Discussing Correlation and Causation <br />Transparency and Explainability: The Black Box Problem <br />Discussing Black Box Parallels <br />Inclusive Growth, Sustainable Development, and Well-Being <br />Examining a Tech for Good Organization <br />Improving Ethical Data Practices</p>
<h4>Sources of Ethical Risk</h4>
<p>Bias and Discrimination <br />Case Study: Allegheny Family Screening Tool <br />Data Surveillance <br />Safety and Security <br />Case Study: PredPol</p>
<h4>Business Considerations</h4>
<p>Data Legislation <br />Manage the Effects of Data <br />Case Study <br />Embed Organizational Values in the Data Value Chain <br />Building a Data Ethics Culture/Code of Ethics</p>
<h4>Exam</h4>
<p><span>A Data Ethics Business Professional is an individual who has demonstrated foundational knowledge of the ethical use of data in emerging technologies in a business. A credential holder is able to identify, explain, and document how organizations identify ethical principles and considerations, understand sources of risk, and explain how businesses can create sustainable, ethical decision-making processes.</span></p>
<p><span>Exam Details: 40 Mins, Multiple Choice Online Assessment. </span></p>
<p></p>
	
		<h3>Target Student</h3>
		<p></p><p>This course is designed for business leaders and decision makers, including C-level executives, project and product managers, HR leaders, Marketing and Sales leaders, and technical sales consultants, who have a vested interest in the representation of ethical values in technology solutions. Other individuals who want to know more about data ethics are also candidates for this course.</p>
<p></p>
	
		<h3>Prerequisites</h3>
		<p></p><p>To ensure your success in this course, you should have a working knowledge of general business concepts and practices. You should also have a basic understanding of Artificial Intelligence and or Data Science.</p>
<p></p>

Mpi Learning - Professional Learning And Development Provider

Data Ethics for Business Professionals is designed for individuals who are seeking to demonstrate an understanding of the ethical uses of data in business settings.

Data Ethics for Business Professionals

Nottingham

<h3 fr-original-style=" color: rgb(34, 34, 34);" id="isPasted" style="color: rgb(34, 34, 34); box-sizing: border-box;">Overview</h3><p fr-original-style=" color: rgb(68, 68, 68);" style="color: rgb(68, 68, 68); font-size: 16px; box-sizing: border-box;">A course which will equip participants with the skills and knowledge they need to become more confident in their exchanges at work and in the wider aspects of their life. &nbsp; The course will consider aspects such as personal brand, self esteem, values, responses to potential or actual conflict and situational self confidence.</p><h3 fr-original-style=" color: rgb(34, 34, 34);" style="color: rgb(34, 34, 34); box-sizing: border-box;">Aim</h3><p fr-original-style=" color: rgb(68, 68, 68);" style="color: rgb(68, 68, 68); font-size: 16px; box-sizing: border-box;">To provide tools and techniques to enable delegates to evaluate and adjust their behaviours to appear more assertive in their discussions with others including colleagues, customers and other stakeholders.</p><h3 fr-original-style=" color: rgb(34, 34, 34);" style="color: rgb(34, 34, 34); box-sizing: border-box;">Content</h3><p fr-original-style=" color: rgb(68, 68, 68);" style="color: rgb(68, 68, 68); font-size: 16px; box-sizing: border-box;">By the end of the course, delegates will be able to:</p><ul fr-original-style=" color: rgb(68, 68, 68);" style="color: rgb(68, 68, 68); box-sizing: border-box;"><li fr-original-style="" id="isPasted" style="box-sizing: border-box;">Understand the importance of effective communication within the workplace and recognise the triggers for certain behaviours in themselves and others.</li><li fr-original-style="" style="box-sizing: border-box;">Identify the skills and behaviours displayed by effective communicators and the range of behaviours from submissive through to aggressive.</li><li fr-original-style="" style="box-sizing: border-box;">Understand how to improve both self-esteem and confidence through positive thinking and actions.</li><li fr-original-style="" style="box-sizing: border-box;">Recognise non-verbal behaviours and the signals they portray.</li><li fr-original-style="" style="box-sizing: border-box;">Encourage self analysis and drivers behind certain behaviours and the basics of transactional analysis to change automatic responses.</li><li fr-original-style="" style="box-sizing: border-box;">Give a clear description of what assertiveness is and why it is important for effective working relationships.</li><li fr-original-style="" style="box-sizing: border-box;">Identify which situations they find hardest to deal with in an assertive manner at work and techniques for dealing with them.</li><li fr-original-style="" style="box-sizing: border-box;">Appreciate that avoiding situations will often lead to conflict in the long run.</li></ul>

Challenge Consulting

Assertiveness & Personal Effectiveness - 1 day training course delivered in Nottingham
To provide tools and techniques to enable delegates to evaluate and adjust their behaviours to appear more assertive in their discussions with others including colleagues, customers and other stakeholders.

Assertiveness & Personal Effectiveness

<p>Benefit your career progression while saving a massive amount of your wallet by enrolling in our Ultimate ATHE Level 3 Diploma in Health and Social Care (2020) qualification bundle of Govt regulated and CPD accredited courses!</p><p>What's included with the Level 3 Health and Social Care with Mental Care Training?</p><ul><li>Ofqual Regulated <strong>ATHE Level 3 Diploma in Health and Social Care (2020)</strong></li><li>Mental Health Care Training - MCA &amp; DOLS</li><li>Certificate on ATHE Level 3 Diploma in Health and Social Care (2020)</li><li>Certificate on Mental Health Care Training - MCA &amp; DOLS</li><li>1-2-1 tutor support</li><li>24/7 access to Course library</li><li>High quality study modules</li><li>Dedicated customer support</li><li>Assessment guidance</li><li>Assessment</li></ul><p>This super saver ultimate ATHE qualification bundle will add significant value to your resume while creating numerous possibilities for your career advancement.</p><p>Register to discover the abilities and knowledge required to succeed in the field of Health &amp; Social Care according to the standards established by OFQUAL and stand out to others. Do not rely on shoddy training or a mediocre education. Focus on excellence, and whenever and wherever you need us, we'll support you in achieving your full potential.</p><p>Ensure your degree is acknowledged internationally by joining us today!</p><p><strong>Kingston Open College is the affiliate partner of One Education. Under the affiliate partnership/program this Qualification will be delivered and assessed by One Education.</strong></p><p><strong>***Curriculum Breakdown of </strong><strong>ATHE Level 3 Diploma in Health and Social Care (2020)</strong><strong>***</strong></p><p><strong>Mandatory Units</strong></p><ul><li><strong>Unit 01:</strong> Structure and Overview of the Health and Social Care Sector</li><li><strong>Unit 02:</strong> Principles, Values and Regulation in the Health and Social Care Sector</li><li><strong>Unit 03:</strong> Human Growth and Development</li><li><strong>Unit 04:</strong> Working in Health and Social Care</li><li><strong>Unit 05:</strong> Research in Health and Social Care</li><li><strong>Unit 06:</strong> Personal and Professional Development in the Health and Social Care Sector</li></ul><p><strong>***Curriculum Breakdown of Mental Health Care Training - MCA &amp; DOLS</strong><strong>***</strong></p><ul><li><strong>Module 01:</strong> The Mental Capacity Act</li><li><strong>Module 02:</strong> Assessment of Mental Capacity</li><li><strong>Module 03:</strong> Best Interest Decision Making</li><li><strong>Module 04:</strong> Advocacy and Advance Planning</li><li><strong>Module 05:</strong> Providing Care or Treatment to People Who Lack Capacity</li><li><strong>Module 06:</strong> Confidentiality and Record Keeping</li><li><strong>Module 07:</strong> Public Bodies and Services Created by MCA Act 2005</li><li><strong>Module 08:</strong> Interface with Legislation, Policy and Procedures</li><li><strong>Module 09:</strong> DOLS to LPS</li><li><strong>Module 10:</strong> Authorised Deprivation</li><li><strong>Module 11:</strong> Legal Background to DOLS</li><li><strong>Module 12:</strong> The Mental Capacity Act (2005) and Deprivation of Liberty Safeguards During a Pandemic</li><li><strong>Module 13:</strong> Liberty Protection Safeguards (LPS)</li></ul><p><strong>Total Qualification Time</strong></p><p>Total Qualification contains the Guided Learning Hours (GLH) and an estimated number of hours that a learner is likely to spend in preparation, study, or any other learning including assessment, taking place as directed by, but not under the supervision of a lecturer, supervisor or tutor.</p><p>The expected total length of time that a learner will typically take to achieve and demonstrate the level of attainment necessary for the award of the qualification is 650 hours, where one credit corresponds to 10 hours of learning.</p><p><strong>So the TQT value is </strong><strong>600</strong><strong>.</strong></p><p><strong>Guided Learning Hours</strong></p><p>These hours comprise all contact time, guidance or supervision of a learner by a lecturer, supervisor, tutor, trainer or other appropriate providers of education or training.</p><p><strong>GLH for this qualification is </strong><strong>360</strong><strong>.</strong></p><p><strong>Assessment:</strong></p><p>For the ATHE Level 3 Diploma in Health and Social Care (2020), learners will have to prepare a written assignment that will be initially assessed by a qualified assessor and further assessed by an IQA to ensure that all the learning outcomes of the qualification are properly accomplished by the learner.</p><p><strong>Certification:</strong></p><p><strong>Ofqual Regulated Certificate:</strong> Learners will be issued with ATHE awarded certificate upon successful completion of the qualification assessment. It will not require any further cost at all.</p><p><strong>CPD accredited Certification:</strong> For the Mental Health Care Training - MCA &amp; DOLS course certificate, learners don't have to pay any additional payment.</p>

Kingston Open College

The Council for Awards in Care, Health & Education (CACHE)

NVQ Assessor

Certificate in Further Education & Training (Cert Ed)

Health & Social Care

Higher Level Teaching Assistant (HLTA)

Vocational Training Charitable Trust (VTCT)

Premium Bundle of all Time | Ofqual Regulation + ATHE Awards + CPD Accreditation | Assessment & Tutor Support Included

Level 3 Health and Social Care with Mental Care Training

<p>Benefit your career progression while saving a massive amount of your wallet by enrolling in our Ultimate ATHE Level 3 Diploma in Health and Social Care (2020) qualification bundle of Govt regulated and QLS endorsed courses!</p><p>What's included with the Level 3 Health and Social Care with PSTD Treatment Diploma?</p><ul><li>Ofqual Regulated <strong>ATHE Level 3 Diploma in Health and Social Care (2020)</strong></li><li>Advanced Diploma in Trauma Treatment of Complex PTSD</li><li>Certificate on ATHE Level 3 Diploma in Health and Social Care (2020)</li><li>Certificate on Advanced Diploma in Trauma Treatment of Complex PTSD</li><li>1-2-1 tutor support</li><li>24/7 access to Course library</li><li>High quality study modules</li><li>Dedicated customer support</li><li>Assessment guidance</li><li>Assessment</li></ul><p>This super saver ultimate ATHE qualification bundle will add significant value to your resume while creating numerous possibilities for your career advancement.</p><p>Register to discover the abilities and knowledge required to succeed in the field of Health &amp; Social Care according to the standards established by OFQUAL and stand out to others. Do not rely on shoddy training or a mediocre education. Focus on excellence, and whenever and wherever you need us, we'll support you in achieving your full potential.</p><p>Ensure your degree is acknowledged internationally by joining us today!</p><p><strong>Kingston Open College is the affiliate partner of One Education. Under the affiliate partnership/program this Qualification will be delivered and assessed by One Education.</strong></p><p><strong>***Curriculum Breakdown of </strong><strong>ATHE Level 3 Diploma in Health and Social Care (2020)</strong><strong>***</strong></p><p><strong>Mandatory Units</strong></p><ul><li><strong>Unit 01:</strong> Structure and Overview of the Health and Social Care Sector</li><li><strong>Unit 02:</strong> Principles, Values and Regulation in the Health and Social Care Sector</li><li><strong>Unit 03:</strong> Human Growth and Development</li><li><strong>Unit 04:</strong> Working in Health and Social Care</li><li><strong>Unit 05:</strong> Research in Health and Social Care</li><li><strong>Unit 06:</strong> Personal and Professional Development in the Health and Social Care Sector</li></ul><p><strong>***Curriculum Breakdown of Advanced Diploma in Trauma Treatment of Complex PTSD</strong><strong>***</strong></p><ul><li><strong>Module 01:</strong> Introduction to Advanced Training for Trauma Treatment of Complex PTSD</li><li><strong>Module 02:</strong> Foundation and Knowledge</li><li><strong>Module 03:</strong> Symptoms of C-PTSD</li><li><strong>Module 04:</strong> Neurobiology of C-PTSD</li><li><strong>Module 05:</strong> Stress Response and Stages of Traumatic Response</li><li><strong>Module 06:</strong> Deliberate Practice</li><li><strong>Module 07:</strong> Self-Regulation and Co-Regulation</li><li><strong>Module 08: </strong>Introduction to Active Ingredients</li><li><strong>Module 09:</strong> Empowerment and Resilience Treatment Structure - Stage I: Preparation</li><li><strong>Module 10:</strong> Empowerment and Resilience Treatment Structure - Stage II: Psychoeduc</li><li><strong>Module 11:</strong> Graphic Timeline</li><li><strong>Module 12:</strong> Skills Development - Relaxation</li><li><strong>Module 13:</strong> Skills Development - Grounding</li><li><strong>Module 14:</strong> Skills Development Conclusion and Regression</li><li><strong>Module 15:</strong> Forward Facing Trauma Therapy (FFTT)</li><li><strong>Module 16: </strong>Therapist Driven Treatments</li></ul><p><strong>Total Qualification Time</strong></p><p>Total Qualification contains the Guided Learning Hours (GLH) and an estimated number of hours that a learner is likely to spend in preparation, study, or any other learning including assessment, taking place as directed by, but not under the supervision of a lecturer, supervisor or tutor.</p><p>The expected total length of time that a learner will typically take to achieve and demonstrate the level of attainment necessary for the award of the qualification is 650 hours, where one credit corresponds to 10 hours of learning.</p><p><strong>So the TQT value is </strong><strong>600</strong><strong>.</strong></p><p><strong>Guided Learning Hours</strong></p><p>These hours comprise all contact time, guidance or supervision of a learner by a lecturer, supervisor, tutor, trainer or other appropriate providers of education or training.</p><p><strong>GLH for this qualification is </strong><strong>360</strong><strong>.</strong></p><p><strong>Assessment:</strong></p><p>For the ATHE Level 3 Diploma in Health and Social Care (2020), learners will have to prepare a written assignment that will be initially assessed by a qualified assessor and further assessed by an IQA to ensure that all the learning outcomes of the qualification are properly accomplished by the learner.</p><p><strong>Certification:</strong></p><p><strong>Ofqual Regulated Certificate:</strong> Learners will be issued with ATHE awarded certificate upon successful completion of the qualification assessment. It will not require any further cost at all.</p><p><strong>QLS Endorsed Certification:</strong> For the Advanced Diploma in Trauma Treatment of Complex PTSD course certificate. Learners don't have to pay any additional payment.</p>

BTEC

Centre for Counselling & Psychotherapy Training (CCPT)

Premium Bundle of all Time | Ofqual Regulation + ATHE Awards + QLS Endorsement | Assessment & Tutor Support Included

Level 3 Health and Social Care with PSTD  Treatment Diploma

<p>Benefit your career progression while saving a massive amount of your wallet by enrolling in our Ultimate ATHE Level 3 Diploma in Health and Social Care (2020) qualification bundle of government-regulated and QLS-endorsed courses!</p><p>What's included with the Level 3 Health and Social Care with Care Assistance Training?</p><ul><li>Ofqual Regulated <strong>ATHE Level 3 Diploma in Health and Social Care (2020)</strong></li><li>Care Assistant Training</li><li>Certificate on ATHE Level 3 Diploma in Health and Social Care (2020)</li><li>Certificate in Care Assistant Training</li><li>1-2-1 tutor support</li><li>24/7 access to Course Library</li><li>High-quality study modules</li><li>Dedicated customer support</li><li>Assessment guidance</li><li>Assessment</li></ul><p>This super saver ultimate ATHE qualification bundle will add significant value to your resume while creating numerous possibilities for your career advancement.</p><p>Register to discover the abilities and knowledge required to succeed in Health and Social Care according to the standards established by OFQUAL and stand out to others. Do not rely on shoddy training or a mediocre education. Focus on excellence; whenever and wherever you need us, we'll support you in achieving your full potential.</p><p>Ensure your degree is acknowledged internationally by joining us today!</p><p><strong>Kingston Open College is the affiliate partner of One Education. Under the affiliate partnership/program, this Qualification will be delivered and assessed by One Education.</strong></p><p><strong>***Curriculum Breakdown of </strong><strong>ATHE Level 3 Diploma in Health and Social Care (2020)</strong><strong>***</strong></p><p><strong>Mandatory Units</strong></p><ul><li><strong>Unit 01:</strong> Structure and Overview of the Health and Social Care Sector</li><li><strong>Unit 02:</strong> Principles, Values and Regulation in the Health and Social Care Sector</li><li><strong>Unit 03:</strong> Human Growth and Development</li><li><strong>Unit 04:</strong> Working in Health and Social Care</li><li><strong>Unit 05:</strong> Research in Health and Social Care</li><li><strong>Unit 06:</strong> Personal and Professional Development in the Health and Social Care Sector</li></ul><p><strong>***Curriculum Breakdown of Care Assistant Training</strong><strong>***</strong></p><ul><li><strong>Module 01:</strong> Introduction to Health and Social Care</li><li><strong>Module 02:</strong> Introduction to Food Safety and the Law</li><li><strong>Module 03:</strong> Food Poisoning and Control Measures</li><li><strong>Module 04:</strong> Working in Health and Social Care; Promoting Equality, Diversity and Rights</li><li><strong>Module 05:</strong> Rights and Responsibilities as a Health and Social Care Worker</li><li><strong>Module 06:</strong> Role as A Caregiver and Healthcare Professional</li><li><strong>Module 07:</strong> Safeguarding Vulnerable Individuals</li><li><strong>Module 08:</strong> An Introduction to Safeguarding of Vulnerable Adults</li><li><strong>Module 09:</strong> Safeguarding Vulnerable AdultsPolicy, Roles and Responsibilities</li><li><strong>Module 10:</strong> Understanding the Importance of Communication in Care</li><li><strong>Module 11:</strong> Consenting for Someone Else</li><li><strong>Module 12:</strong> Best Interest Decision Making</li><li><strong>Module 13:</strong> Managing Service Delivery in Health and Social Care</li><li><strong>Module 14:</strong> Important Principles and Policies in Health and Social Care Work</li><li><strong>Module 15:</strong> Medical Jargon and Terminology</li><li><strong>Module 16:</strong> Information Technology in Health Care</li></ul><p><strong>Total Qualification Time</strong></p><p>Total Qualification contains the Guided Learning Hours (GLH) and an estimated number of hours a learner is likely to spend in preparation, study, or any other learning, including assessment, as directed by, but not under the supervision of a lecturer, supervisor or tutor.</p><p>The expected total length of time that a learner will typically take to achieve and demonstrate the level of attainment necessary for the qualification award is 650 hours, where one credit corresponds to 10 hours of learning.</p><p><strong>So, the TQT value is </strong><strong>600</strong><strong>.</strong></p><p><strong>Guided Learning Hours</strong></p><p>These hours comprise all contact time, guidance or supervision of a learner by a lecturer, supervisor, tutor, trainer or other appropriate education or training providers.</p><p><strong>GLH for this qualification is </strong><strong>360</strong><strong>.</strong></p><p><strong>Assessment:</strong></p><p>For the ATHE Level 3 Diploma in Health and Social Care (2020), learners will have to prepare a written assignment that will be initially assessed by a qualified assessor and further assessed by an IQA to ensure that the learner properly accomplishes all the learning outcomes of the qualification.</p><p><strong>Certification:</strong></p><p><strong>Ofqual Regulated Certificate:</strong> Upon completing the qualification assessment, learners will be issued an ATHE-awarded certificate. It will not require any further cost at all.</p><p><strong>QLS Endorsed Certification:</strong> For the Care Assistant Training course certificate. Learners don't have to pay any additional payment.</p>

Healthcare Assistant

Level 3 Health and Social Care with Care Assistance Training Course

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

Heat Engineer

Heating Engineer

For new users and the curious.

Hello,

For new users and the curious.

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

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

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

How to use Heat Engineer Software V2 (Selectable dates)

General admission

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

BBO Training

Clinical

Menopause Update

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

Nexus Human

Azure PowerShell

Powershell

Microsoft AZ-104

Power Automate

Microsoft AZ-303

Microsoft Power Automate

AZ-040T00 Automating Administration with Powershell

Bournemouth

London Waterloo Academy

Flight Attendant

Stewardess

FLIGHT ATTENDANT VIRTUAL VIA ZOOM COURSE, EVENINGS

Registration Fee

Course Fee

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

ValueX2

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

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

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

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



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

Improving Communications Uk

DIVERSITY – BUILDING A THRIVING BUSINESS ENVIRONMENT

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.</p><p></p><p></p><p>This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Learning & Development

Design & Technology Courses (DT)

Data Skills

Trainers Course

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

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

Understand and mitigate your own personal drivers of conflict



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

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

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



The Self Leadership Initiative

Conflict Resolution

Leadership Skills

Team Leading

Conflict Management

Team Leader

Conflict

Leadership

Team Management

Leadership Development

Understand and mitigate your own personal drivers of conflict

What are your conflict hooks?

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

Microsoft AZ-900

Microsoft Azure

Microsoft AZ-700

AWS Certified Solutions Architect

AZ-204T00 Developing Solutions for Microsoft Azure

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p></p><p>The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.</p><p></p><p></p><p>This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.</p><p></p>Prerequisites<p></p><li>Understanding core data concepts.</li>  <li>Knowledge of working with relational data in the cloud.</li>  <li>Knowledge of working with non-relational data in the cloud.</li>   <li>Knowledge of data analysis and visualization concepts.</li>   <li>DP-900T00 Microsoft Azure Data Fundamentals is recommended<p></p></li></div><div id="course-pills-2"><h3>1 - Discover data analysis</h3> <ul> <li>Overview of data analysis</li> <li>Roles in data</li> <li>Tasks of a data analyst</li> </ul> <h3>2 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>3 - Get data in Power BI</h3> <ul> <li>Get data from files</li> <li>Get data from relational data sources</li> <li>Create dynamic reports with parameters</li> <li>Get data from a NoSQL database</li> <li>Get data from online services</li> <li>Select a storage mode</li> <li>Get data from Azure Analysis Services</li> <li>Fix performance issues</li> <li>Resolve data import errors</li> </ul> <h3>4 - Clean, transform, and load data in Power BI</h3> <ul> <li>Shape the initial data</li> <li>Simplify the data structure</li> <li>Evaluate and change column data types</li> <li>Combine multiple tables into a single table</li> <li>Profile data in Power BI</li> <li>Use Advanced Editor to modify M code</li> </ul> <h3>5 - Design a semantic model in Power BI</h3> <ul> <li>Work with tables</li> <li>Create a date table</li> <li>Work with dimensions</li> <li>Define data granularity</li> <li>Work with relationships and cardinality</li> <li>Resolve modeling challenges</li> </ul> <h3>6 - Add measures to Power BI Desktop models</h3> <ul> <li>Create simple measures</li> <li>Create compound measures</li> <li>Create quick measures</li> <li>Compare calculated columns with measures</li> </ul> <h3>7 - Add calculated tables and columns to Power BI Desktop models</h3> <ul> <li>Create calculated columns</li> <li>Learn about row context</li> <li>Choose a technique to add a column</li> </ul> <h3>8 - Use DAX time intelligence functions in Power BI Desktop models</h3> <ul> <li>Use DAX time intelligence functions</li> <li>Additional time intelligence calculations</li> </ul> <h3>9 - Optimize a model for performance in Power BI</h3> <ul> <li>Review performance of measures, relationships, and visuals</li> <li>Use variables to improve performance and troubleshooting</li> <li>Reduce cardinality</li> <li>Optimize DirectQuery models with table level storage</li> <li>Create and manage aggregations</li> </ul> <h3>10 - Design Power BI reports</h3> <ul> <li>Design the analytical report layout</li> <li>Design visually appealing reports</li> <li>Report objects</li> <li>Select report visuals</li> <li>Select report visuals to suit the report layout</li> <li>Format and configure visualizations</li> <li>Work with key performance indicators</li> </ul> <h3>11 - Configure Power BI report filters</h3> <ul> <li>Apply filters to the report structure</li> <li>Apply filters with slicers</li> <li>Design reports with advanced filtering techniques</li> <li>Consumption-time filtering</li> <li>Select report filter techniques</li> <li>Case study - Configure report filters based on feedback</li> </ul> <h3>12 - Enhance Power BI report designs for the user experience</h3> <ul> <li>Design reports to show details</li> <li>Design reports to highlight values</li> <li>Design reports that behave like apps</li> <li>Work with bookmarks</li> <li>Design reports for navigation</li> <li>Work with visual headers</li> <li>Design reports with built-in assistance</li> <li>Tune report performance</li> <li>Optimize reports for mobile use</li> </ul> <h3>13 - Perform analytics in Power BI</h3> <ul> <li>Explore statistical summary</li> <li>Identify outliers with Power BI visuals</li> <li>Group and bin data for analysis</li> <li>Apply clustering techniques</li> <li>Conduct time series analysis</li> <li>Use the Analyze feature</li> <li>Create what-if parameters</li> <li>Use specialized visuals</li> </ul> <h3>14 - Create and manage workspaces in Power BI</h3> <ul> <li>Distribute a report or dashboard</li> <li>Monitor usage and performance</li> <li>Recommend a development life cycle strategy</li> <li>Troubleshoot data by viewing its lineage</li> <li>Configure data protection</li> </ul> <h3>15 - Manage semantic models in Power BI</h3> <ul> <li>Use a Power BI gateway to connect to on-premises data sources</li> <li>Configure a semantic model scheduled refresh</li> <li>Configure incremental refresh settings</li> <li>Manage and promote semantic models</li> <li>Troubleshoot service connectivity</li> <li>Boost performance with query caching (Premium)</li> </ul> <h3>16 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>17 - Implement row-level security</h3> <ul> <li>Configure row-level security with the static method</li> <li>Configure row-level security with the dynamic method</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-300T00: Microsoft Power BI Data Analyst training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the PL-300T00: Microsoft Power BI Data Analyst course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

1839 Courses

SQL Server Course for Beginners with 100+ examples

By Packt

Cache Level 3 Teaching Assistant & SEN Certificate Course

By One Education

Cache Level 3 Teaching Assistant & SEN Certificate Course

By One Education

INSIGHTS AND SOLUTIONS CIRCLE

By Inclusive Solutions

Landscape Painting workshop

By Pippa Pixley

Data Ethics for Business Professionals

By Mpi Learning - Professional Learning And Development Provider

Assertiveness & Personal Effectiveness

By Challenge Consulting

Level 3 Health and Social Care with Mental Care Training

By Kingston Open College

Level 3 Health and Social Care with PSTD Treatment Diploma

By Kingston Open College

Level 3 Health and Social Care with Care Assistance Training Course

By Kingston Open College

Search By Location