Name: Scrum Master Exam Prep: In-House Training
Price: 1495 GBP
Availability: InStock

Birmingham

Telford

<div style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);"><section fr-original-style="" style="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);"><span style="color: rgb(32, 56, 100); box-sizing: border-box;" fr-original-style=" color: rgb(32, 56, 100);">You may have heard the saying, &#39;There is no I in the team&#39;! Well, we beg to differ. We ask leaders and managers to focus on the individuals in the team so that they get the most out of the whole team.</span></p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);"><span style="color: rgb(32, 56, 100); box-sizing: border-box;" fr-original-style=" color: rgb(32, 56, 100);">This thinking comes from our belief in Emotional Intelligence (EI). With EI, you can reach for the sky, but without EI, your dreams will die. If team members are unaware (or don&rsquo;t care) that their behaviour negatively impacts others, they will continue to behave like that. When we become self-aware, we have the opportunity to behave differently, which is a really important moment as the team needs to know how to encourage this positive behaviour.</span></p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);"><span style="color: rgb(32, 56, 100); box-sizing: border-box;" fr-original-style=" color: rgb(32, 56, 100);">High-performing teams (HPTs) are united in their approach. No one is left behind, everyone is vigilant of each other, and mental health check-ins are a daily ritual, not just a task. This level of cohesion is not a coincidence but a result of leaders and managers fostering a culture of care and support within a psychologically safe environment.</span></p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);"><span style="color: rgb(32, 56, 100); box-sizing: border-box;" fr-original-style=" color: rgb(32, 56, 100);">HPTs operate as a collective unit, with minimal need for a Team Manager or Leader. They share a common concern for each other, driven by the shared objective of achieving team-based goals and outputs. This collective responsibility is a testament to their mutual support and shared accountability.</span></p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);"><span style="color: rgb(32, 56, 100); box-sizing: border-box;" fr-original-style=" color: rgb(32, 56, 100);">There may well be individual tasks or even KPIs, but they will all work collaboratively to ensure that everyone works well together, that no one slacks or repeats mistakes and that <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">any of them</strong> will step in to help with workloads when they can without being asked.</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(32, 56, 100); box-sizing: border-box;" fr-original-style=" color: rgb(32, 56, 100);">Our workshop examines all the ingredients of the HPT, reverse engineers the recipe, and discusses each aspect, leaving everyone with a clear picture of how to create and maintain their own HPT.&nbsp;</span></p></section></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><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; -webkit-user-select: none; box-sizing: border-box;"><div style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">LENGTH</strong></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);">1 Day</div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">NEXT COURSE START</strong></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);">Let&#39;s chat and confirm a date.</div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">WORKSHOP DELIVERY</strong></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);">The best environment for this workshop is face-to-face, but we can facilitate this workshop online.</div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; -webkit-user-select: none; box-sizing: border-box;"><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><div style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);"><h2 title="Suitability - Who should attend?" style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);">Suitability - Who should attend?</h2><section fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);">Who Should Attend and Why?</h3><p id="isPasted" 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;">Who</strong>? All those who lead or manage others.&nbsp;</p><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;">Why</strong>? All leaders and managers must fully understand the hard work and challenges involved in creating and maintaining a high-performing team (HPT).</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Ask yourself: Why do some teams seem chaotic, dysfunctional, ill-tempered, and full of infighting? Answer: Their manager/leader does not know how to fix their people&#39;s behaviour.&nbsp;&nbsp;&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This workshop will give leaders and managers the tools they need to create HPTs. However, it will take hard work, commitment, and an assertive mindset from the leader/manager and the whole team.&nbsp;</p></section></div><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);"><a name="EducationText_TrainingCourseContent" style="color: rgb(21, 101, 192); -webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(21, 101, 192);"></a></span><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><h2 title="Training Course Content" style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">Workshop Content</span></h2><section fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(40, 50, 78); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(40, 50, 78);">Groups vs Teams?</li><li style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">What are the ingredients of an HPT?</li><li style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">How do they work so well together?</li><li style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">Amygdala/Emotional hijack or control (Emotional Intelligence)?</li><li style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">Values, Behaviours, ES2, Environment/Culture and your &#39;People Strategy.&#39;</li><li style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">We examine styles, delegation, collective leadership, and remote workers when determining how to lead/manage a team.</li><li style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">Saboteurs and challenging people&rsquo;s attitudes or poor performance (people leave people).</li><li style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">Our ES2/psychological safety thinking and why we MUST make this happen.</li><li style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">An analysis of our reality using our HPT Assessment tool.</li><li style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">Discussing and agreeing on actions that need to be taken.</li></ul></section></div><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);"><a name="EducationText_Coursedeliverydetails" style="color: rgb(21, 101, 192); -webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(21, 101, 192);"></a></span><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><h2 title="Course delivery details" style="color: rgb(33, 33, 33); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 33, 33);">Workshop delivery and venue</h2><section 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;"><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">This workshop, which usually lasts one day, focuses solely on how we build and maintain HPTs.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">However, it can be a two-day event incorporating aspects of Emotional Intelligence (EI), Communicating Effectively, and Managing My Day with group and individual activities to allow discussion.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">When you consider the content we deliver, we are sure you will understand why we always prefer to deliver our workshops, courses and programmes face-to-face.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">Face-to-face workshops and courses can be held at a location of your choice or, if you wish, a central UK location, such as the Macdonald Burlington Hotel in Birmingham, located directly across from the Birmingham New Street train station.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);">We can deliver our workshops, courses and programmes online, although this will mean splitting elements into manageable learning events to suit the online environment.</span></p></section></div></div><div style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);"><section fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(40, 50, 78); box-sizing: border-box;" fr-original-style="color: rgb(40, 50, 78);"><br fr-original-style="" style="box-sizing: border-box;"></span></section></div></div></div></div>

You may have heard the saying, 'There is no I in the team'! Well, we beg to differ. We ask leaders and managers to focus on the individuals in the team so that they get the most out of the whole team.
This thinking comes from our belief in Emotional Intelligence (EI). With EI, you can reach for the sky, but without EI, your dreams will die. If team members are unaware (or don’t care) that their behaviour negatively impacts others, they will continue to behave like that. When we become self-aware, we have the opportunity to behave differently, which is a really important moment as the team needs to know how to encourage this positive behaviour.
High-performing teams (HPTs) are united in their approach. No one is left behind, everyone is vigilant of each other, and mental health check-ins are a daily ritual, not just a task. This level of cohesion is not a coincidence but a result of leaders and managers fostering a culture of care and support within a psychologically safe environment.
HPTs operate as a collective unit, with minimal need for a Team Manager or Leader. They share a common concern for each other, driven by the shared objective of achieving team-based goals and outputs. This collective responsibility is a testament to their mutual support and shared accountability.
There may well be individual tasks or even KPIs, but they will all work collaboratively to ensure that everyone works well together, that no one slacks or repeats mistakes and that any of them will step in to help with workloads when they can without being asked.
Our workshop examines all the ingredients of the HPT, reverse engineers the recipe, and discusses each aspect, leaving everyone with a clear picture of how to create and maintain their own HPT. 



LENGTH - For more information about duration, please get in touch with us to discuss your specific needs, or we can offer advice.  
NEXT WORKSHOP START - Please ask for more information as we deliver bespoke closed events for your people at your location or a mutually suitable location.
WORKSHOP DELIVERY - The best environment for this workshop is face-to-face, but we can facilitate this workshop online.



Suitability - Who should attend?
Who Should Attend and Why?
Who? All those who lead or manage others. 
Why? All leaders and managers must fully understand the hard work and challenges involved in creating and maintaining a high-performing team (HPT).
Ask yourself: Why do some teams seem chaotic, dysfunctional, ill-tempered, and full of infighting? Answer: Their manager/leader does not know how to fix their people's behaviour. 
This workshop will give leaders and managers the tools they need to create HPTs. However, it will take hard work, commitment, and an assertive mindset from the leader/manager and the whole team. 
Workshop Content
Groups vs Teams?
What are the ingredients of an HPT?
How do they work so well together?
Amygdala/Emotional hijack or control (Emotional Intelligence)?
Values, Behaviours, ES2, Environment/Culture and your 'People Strategy.'
We examine styles, delegation, collective leadership, and remote workers when determining how to lead/manage a team.
Saboteurs and challenging people’s attitudes or poor performance (people leave people).
Our ES2/psychological safety thinking and why we MUST make this happen.
An analysis of our reality using our HPT Assessment tool.
Discussing and agreeing on actions that need to be taken.
Workshop delivery and venue
This workshop, which usually lasts one day, focuses solely on how we build and maintain HPTs.
However, it can be a two-day event incorporating aspects of Emotional Intelligence (EI), Communicating Effectively, and Managing My Day with group and individual activities to allow discussion.
When you consider the content we deliver, we are sure you will understand why we always prefer to deliver our workshops, courses and programmes face-to-face.
Face-to-face workshops and courses can be held at a location of your choice or, if you wish, a central UK location, such as the Macdonald Burlington Hotel in Birmingham, located directly across from the Birmingham New Street train station.
We can deliver our workshops, courses and programmes online, although this will mean splitting elements into manageable learning events to suit the online environment.

Lapd Solutions Ltd

High Performing Teams. Moccasin Approach, Moccasin Manager, 

High Performing Teams (HPTs)

Introductory daily rate.

Registered charities and non profits only.

Non profits only.

Redhill

<h3><b>MySQL for developers training course description</b></h3>
        <p>  This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                      <li>Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database.</li>
<li>Use advanced features of the MySQL Client.</li>
<li>Use advanced data types.</li>
<li>Manage the structure of databases and tables.</li>
<li>Manage and using indexes.</li>
<li>Write complex SQL query statements.</li>
<li>Use advanced SQL expressions.</li>
<li>Use advanced SQL functions.</li>
<li>Perform advanced Insert, Update, Delete, Replace and Truncate Operations.</li>
<li>Use user variable syntax and properties.</li>
<li>Import and export data from within MySQL.</li>
<li>Import and export data from the command line.</li>
<li>Perform complex joins to access multiple tables.</li>
<li>Perform complex subqueries.</li>
<li>Create, manage and us views.</li>
<li>Use prepared statements.</li>
<li>Create and use stored routines.</li>
<li>Create and use triggers.</li>
<li>Obtain database metadata.</li>
<li>Optimize queries.</li>
<li>Work with the main storage engines.</li>
<li>Debug MySQL applications.</li>

                  </ul>
        <h5>
        <b>MySQL for developers training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>MySQL foundation </p>
              
							<li><b>Duration</b></li>
							
              <p>5 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>MySQL for developers training course contents</b></h3>
      <ul>
        <li>Introduction </li><p>
Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions.

</p><li>Client/server concepts </li><p>
MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options
<br /><span>Hands on</span> Using client/server

</p><li>The MySQL client program </li><p>
Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities.
<br /><span>Hands on</span> Using the MySQL client program

</p><li>Data types </li><p>
Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options.
<br /><span>Hands on</span> Using data types 

</p><li>Identifiers </li><p>
Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names
<br /><span>Hands on</span> Using identifiers

</p><li>Databases </li><p>
Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command
<br /><span>Hands on</span> Using databases

</p><li>Tables and indexes </li><p>
Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata.
<br /><span>Hands on</span> Creating, altering and dropping tables/indexes

</p><li>Querying for data </li><p>
The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause.
<br /><span>Hands on</span> Querying for data

</p><li>SQL Expressions and functions </li><p>
Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions.
<br /><span>Hands on</span> Using expressions and functions

</p><li>Updating data </li><p>
Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements.
Exercise: Inserting, updating, replacing and deleting data

</p><li>Connectors 	</li><p>
MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached.

</p><li>Obtaining database metadata </li><p>
What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage.
<br /><span>Hands on</span> Obtaining database metadata

</p><li>Debugging 	</li><p>
Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility.
<br /><span>Hands on</span> Debugging

</p><li>Joins </li><p>
Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another.
<br /><span>Hands on</span> Coding joins

</p><li>Subqueries 	</li><p>
Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes.
<br /><span>Hands on</span> Coding subqueries

</p><li>Views </li><p>
Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views.
<br /><span>Hands on</span> Using views

</p><li>Import and Export </li><p>
Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options.
<br /><span>Hands on</span> Importing and exporting

</p><li>User variables and prepared statements </li><p>
Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors.
<br /><span>Hands on</span> Using variables and prepared statements

</p><li>Introduction to stored routines </li><p>
Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security.
<br /><span>Hands on</span> Writing simple stored routines

</p><li>Stored routines - program logic </li><p>
The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops.
<br /><span>Hands on</span> Writing stored routines with program logic

</p><li>Stored routines - exception handlers and cursors </li><p>
Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking.
<br /><span>Hands on</span> Writing stored routines with program logic

</p><li>Procedures with parameters </li><p>
Creating procedures with parameters, Calling Procedures With Parameters.
<br /><span>Hands on</span> Writing stored routines with parameters

</p><li>Functions 	</li><p>
What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses.
<br /><span>Hands on</span> Writing functions

</p><li>Triggers </li><p>
Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges.
<br /><span>Hands on</span> Writing triggers

</p><li>Basic optimizations </li><p>
Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization.
<br /><span>Hands on</span> Making use of basic optimizations

</p><li>More about indexes </li><p>
Indexes and joins
<br /><span>Hands on</span> Investigating indexes and joins
				</p>
      </ul>

Systems & Network Training

Network & Security

Network Engineer

MySQL for developers

General Admission

<h3><b>Querying Microsoft SQL Server course description</b></h3>
        <p>This course covers the technical skills required to write
basic Transact-SQL queries for Microsoft SQL Server
and provides the foundation for all SQL Server-related
disciplines; namely, database administration, database
development and business intelligence. This course
helps prepare for exam 70-761. <br />
Note: This course is
designed for SQL Server 2014or SQL Server 2016. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                       <li>Write SELECT statements.</li>

<li>Create and implement views and table-valued
functions.</li>

<li>Transform data by implementing pivot, unpivot,
rollup and cube.</li>

<li>Create and implement stored procedures.</li>

<li>Add programming constructs such as variables,
conditions, and loops to T-SQL code.</li>

                  </ul>
        <h5>
        <b>Querying Microsoft SQL Server course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Database administrators, database developers, and
business intelligence professionals. <br />SQL power users,
namely, report writers, business analysts and client
application developers.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Database fundamentals</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Querying Microsoft SQL Server course contents</b></h3>
      <ul>
        <li>Introduction to Microsoft SQL Server </li><p>
Management studio, creating and organizing T-SQL scripts, using books online.
<br /><span>Hands on</span> working with SQL Server tools.

</p><li>T-SQL querying </li><p>
Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY.
<br /><span>Hands on</span> introduction to T-SQL querying.

</p><li>Writing SELECT queries </li><p>
Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions.
<br /><span>Hands on</span> writing basic SELECT statements.

</p><li>Querying multiple tables </li><p>
cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins.
<br /><span>Hands on</span> querying multiple tables.

</p><li>Sorting and filtering data </li><p>
Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause.
<br /><span>Hands on</span> sorting and filtering data.

</p><li>SQL Server data types </li><p>
Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions.
<br /><span>Hands on</span> working with SQL Server data types.

</p><li>DML </li><p>
Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML.
<br /><span>Hands on</span> using DML to modify data.

</p><li>Built-in functions </li><p>
Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability.
<br /><span>Hands on</span> built-in functions

</p><li>Grouping and aggregating data </li><p>
Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause.
<br /><span>Hands on</span> grouping and aggregating data.

</p><li>Subqueries </li><p>
Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries.
<br /><span>Hands on</span> subqueries.

</p><li>Table expressions </li><p>
Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs).
<br /><span>Hands on</span> table expressions.

</p><li>Set operators </li><p>
The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators.
<br /><span>Hands on</span> set operators.

</p><li>Windows ranking, offset, and aggregate functions </li><p>
OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions.

</p><li>Pivoting and grouping sets </li><p>
	PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses.
<br /><span>Hands on</span> pivoting and grouping sets

</p><li>Executing stored procedures </li><p>
Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures.
<br /><span>Hands on</span> executing stored procedures.

</p><li>Programming with T-SQL </li><p>
T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms.
<br /><span>Hands on</span> programming with T-SQL

</p><li>Error handling </li><p>
T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client.
<br /><span>Hands on</span> implementing error handling.

</p><li>Implementing transactions </li><p>
Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block.
<br /><span>Hands on</span> implementing transactions.
</p>
      </ul>

Querying Microsoft SQL Server

London

<h2>Scrum Master Workshop: In-House Training</h2>
 <p>A Scrum Master helps project teams properly use the Scrum framework, increasing the likelihood of the project's overall success. Scrum Masters understand Scrum values, practices, and applications and provide a level of knowledge and expertise above and beyond that of typical project managers. Scrum Masters act as 'servant leaders', helping the rest of the Scrum Team work together and learn the Scrum framework. Scrum Masters also protect the team from both internal and external distractions.</p><h3>What you will Learn</h3>
 <p>You'll learn how to:</p>
 <ul>
 <li>Comprehend the Agile Manifesto and mindset</li>
 <li>Explain the fundamental principles of Scrum</li>
 <li>Guide the Scrum team in their responsibilities</li>
 <li>Write requirements in the form of user stories</li>
 <li>Define Ready and Done</li>
 <li>Estimate using planning poker and prioritize using MoSCoW</li>
 <li>Facilitate the team through the 5 Sprint events</li>
 <li>Fulfill the role of Scrum Master in a Scrum project</li>
 <li>Create Information Radiators to enable transparency</li>
 <li>Define the structure of the retrospective</li>
 </ul><section>
                    <h3>Foundation Concepts</h3> <ul> <li>Agile History, Values, and Mindset</li> <li>Introduction to Scrum</li> <li>Scrum events</li> <li>Scrum artifacts</li> </ul> <h3>Scrum Roles and Responsibilities</h3> <ul> <li>Product Owner responsibilities</li> <li>Scrum Master responsibilities</li> <li>The Team responsibilities</li> <li>Cross-functional Teams</li> <li>Building Effective Teams</li> </ul> <h3>The Product Backlog and User Stories</h3> <ul> <li>The Product Backlog</li> <li>User Stories</li> <li>Definition of Done</li> <li>Backlog grooming</li> <li>Estimating User Stories</li> <li>Story points, planning poker</li> <li>Prioritizing User Stories</li> </ul> <h3>The Sprint</h3> <ul> <li>Team capacity and velocity</li> <li>The Sprint Planning Meeting</li> <li>The Sprint Backlog</li> <li>The Sprint</li> <li>Learning to self-manage, self-organize, self-improve</li> <li>Sprint Review and Retrospective</li> </ul> <h3>Project Progress and Completion</h3> <ul> <li>The Daily Scrum</li> <li>The Task Board and The Burndown Chart</li> <li>Information Radiators</li> <li>Closing a Scrum Project</li> </ul> <h3>Summary and Next Steps</h3> <ul> <li>Review of course goals, objectives, and content</li> </ul>


                </section>

IIL Europe Ltd

Scrum Master Workshop: In-House Training

<h3><b>Kamailio training course description</b></h3>
      <p>Kamailio (formerly known as OpenSER) provides a scalable SIP server suitable for small through to carrier grade installations. This course will teach you how to install, configure and troubleshoot the Kamailio product. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
          <li>Install Kamailio.</li>
              <li>Control Kamailio.</li>
              <li>Configure Kamailio.</li>
              <li>Troubleshoot Kamailio.</li>
      </ul>
       
        <h5>
        <b>Kamailio training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Technical staff working with Kamailio. </p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Definitive SIP for engineers.<br />
        UNIX fundamentals.</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Kamailio training course contents</b></h3>
      <ul>
				<li>What is Kamailio?</li><p>
What is SER? SER history, OpenSER, versions. Kamailio. Supported platforms, SIP review.
<br /><span>Hands on</span> Simple SIP telephony without a SIP server.

</p><li>Installing Kamailio</li><p>
Downloading Kamailio, Installation from source, package installation, CVS, default passwords
<br /><span>Hands on</span> Kamailio installation.

</p><li>Controlling Kamailio</li><p>
Starting, stopping and controlling Kamailio. Starting Kamailio automatically at boot time.
<br /><span>Hands on</span> Controlling the server

</p><li>First configuration</li><p>
Basic configuration.
<br /><span>Hands on</span> SIP telephony with Kamailio.

</p><li>Monitoring</li><p>
Logs, xlog, openserctl, syslog.
<br /><span>Hands on</span> Logging.

</p><li>Kamailio architecture</li><p>
Kamailio core, Kamailio modules, file locations, persistent data storage, database structure.
<br /><span>Hands on</span> Database integration.

</p><li>Core configuration</li><p>
Keywords, values, parameters, functions, routing blocks, constructs.
<br /><span>Hands on</span> Advanced Kamailio configuration.

</p><li>Module configuration</li><p>
Overview of modules available, AAA integration, least cost routing. Redirects
<br /><span>Hands on</span> Configuring modules.

</p><li>Architectures</li><p>
DNS integration, peering, OSP, NAT traversal, SIP to GSM.
<br /><span>Hands on</span> peering.

</p><li>Asterisk integration</li><p>
Altering tables to work with Asterisk, Asterisk as a voicemail system. Design issues, High availability.
<br /><span>Hands on</span> Integrating Kamailio with Asterisk.
</p>
      </ul>

Definitive Kamailio for engineers

<h2>Scrum Master Exam Prep</h2>
<p>This workshop prepares you for the Scrum.org Professional Scrum Master (PSM)™ I certification. A voucher for the exam and the access information you will need to take the exam will be provided to you via email after you have completed the course. NOTE: If you have participated in any of IIL's other Scrum workshops, you can bypass this program and focus on reading/studying the Scrum Guide and taking practice exams from Scrum.org.</p>
<p>A Scrum Master helps project teams properly use the Scrum framework, increasing the likelihood of the project's overall success. Scrum Masters understand Scrum values, practices, and applications and provide a level of knowledge and expertise above and beyond that of typical project managers. Scrum Masters act as 'servant leaders', helping the rest of the Scrum Team work together and learn the Scrum framework. Scrum Masters also protect the team from both internal and external distractions.</p>
<p>The Professional Scrum Master™ I (PSM I) certificate is a Scrum.org credential that enables successful candidates to demonstrate a fundamental level of Scrum mastery. PSM I credential holders will grasp Scrum as described inThe Scrum Guide™1 and recognize how those concepts can be applied. They will also share a consistent terminology and approach to Scrum with other certified professionals.</p><h3>What you will Learn</h3>
<p>You'll learn how to:</p>
<ul>
<li>Successfully prepare for the Scrum.org PSM I exam</li>
<li>Comprehend the Agile Manifesto and mindset</li>
<li>Explain the fundamental principles of Scrum, including events, artifacts, and roles</li>
<li>Guide the Scrum team in their responsibilities</li>
<li>Define Ready and Done</li>
<li>Write requirements in the form of user stories</li>
<li>Estimate using planning poker and prioritize using MoSCoW</li>
<li>Facilitate the team through the 5 Sprint events</li>
<li>Fulfill the role of Scrum Master in a Scrum project</li>
<li>Create Information Radiators to enable transparency</li>
<li>Define the structure of the retrospective</li>
</ul><section>
                    <h3>Getting Started</h3><ul><li>Introductions</li><li>Workshop orientation</li><li>Exam prep preview</li></ul><h3>Foundation Concepts</h3><ul><li>Agile History, Values, and Mindset</li><li>Introduction to Scrum</li><li>Scrum events</li><li>Scrum artifacts</li></ul><h3>Scrum Roles and Responsibilities</h3><ul><li>Product Owner responsibilities</li><li>Scrum Master responsibilities</li><li>The Team responsibilities</li><li>Cross-functional teams</li><li>Building effective teams</li></ul><h3>The Product Backlog and User Stories</h3><ul><li>The Product Backlog</li><li>User Stories</li><li>Definition of Done</li><li>Backlog grooming</li><li>Estimating User Stories</li><li>Story points, planning poker</li><li>Prioritizing User Stories</li></ul><h3>The Sprint</h3><ul><li>Team capacity and velocity</li><li>The Sprint Planning Meeting</li><li>The Sprint Backlog</li><li>The Sprint</li><li>Learning to self-manage, self-organize, self-improve</li><li>Sprint Review and Retrospective</li></ul><h3>Project Progress and Completion</h3><ul><li>The Daily Scrum</li><li>The Task Board and The Burndown Chart</li><li>Information Radiators</li><li><br /><h3>Closing a Scrum Project</h3></li></ul><h3>Summary and Next Steps</h3><ul><li>Review of course goals, objectives, and content</li><li>Exam prep next steps</li></ul>


                </section>

Scrum Master Exam Prep: In-House Training

Bishop Stortford

Bury St Edmunds

Cambridge

Chelmsford

Colchester

Hertford

Ipswich

Newmarket

Various

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course is transformational focusing on developing leadership confidence through self-discovery, emphasising the importance of understanding one&#39;s unique leadership style and personal philosophy, developing a leadership brand. Participants will explore their core identity as leaders and learn strategies to enhance their influence, credibility, and relationships within their organisation. Exploring the link between self-discovery and effective leadership, focusing on developing confidence to lead from within.</p><h4 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Objectives:</span></strong></h4><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Discovering Your Core Identity </strong>by<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> </strong>assessing personal values, beliefs, strengths, and areas for growth through individual and group exercises.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Exploring leadership styles</strong>&nbsp;and their applications to define and refine your leadership identity.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Crafting a personal leadership philosophy </strong>to&nbsp;guide actions and decisions, with methods for ongoing reflection and development.</li></ul><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">This course is available to book for delivery in-house for your organisation and people exclusively, for either a half or full days training workshop. &nbsp;Prices are dependent on size of group ranging from a minimum of 4 to a maximum of 12 delegates. If you have a smaller number of delegates the Puritas 1:1 Leadership Coaching Programme is recommended.</span></div>

Puritas

Personal Branding

Personal Development

Personal Transformation

Leadership Development

This module focuses on developing leadership confidence through self-discovery, emphasising the importance of understanding one's unique leadership style and personal philosophy. Participants will explore their core identity as leaders and learn strategies to enhance their influence, credibility, and relationships within their organisation. Exploring the link between self-discovery and effective leadership, focusing on developing confidence to lead from within.  

Testimonial: “Without guidance, personal branding can quickly become an exercise in aspiration and competition; letting the carefully curated public personas of others dictate our own validity and definition of success. Clarity on who we truly are, what matters to us and therefore how we position ourselves in the world takes reflection and time. Rachael’s work in this area has inspired the nearly 100 delegates who have been part of our HR Leadership Academy over the past 8 years, and I have no doubt will continue to resonate with future cohorts.” MD, Nina Metson - Suffolk

Leadership Identity Through Self-Discovery

<div>
</div>
<section>
<div>
<h2><strong>About this Virtual Instructor Led Training (VILT)</strong><em> </em></h2>
<p><span>This 2-half-day Virtual Instructor Led Training (VILT) course will discuss the chemical aspects of the water-steam cycle in a power plant. The VILT course will examine the different types of chemicals used in boilers, potential issues in a water-steam cycle as well as aspects of monitoring and specifications regarding target values and alarm levels. Participants will also be equipped on what to do or key action steps to take in the event of chemistry-related incidents.</span></p>
<p>This course is delivered in partnership with ENGIE Laborelec.</p>
<p></p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p><span>The VILT course will cover the following:</span></p>
<ul>
<li><span>Detailed aspects of chemistry in a water steam cycle, including types of chemicals used in boilers depending on the treatment and type of boiler</span></li>
<li><span>Potential issues in a water-steam cycle such as corrosion and deposition</span></li>
<li><span>Monitoring &amp; analytical programmes and knowledge of specifications for the water steam cycle (normal values targets - alarm levels)</span></li>
<li><span>Chemistry aspects during transition periods: start-up, shutdown and preservation</span></li>
<li><span>Actions to be taken in the event of an alarm</span></li>
<li><span>Examples of incidents or deviations compared to normal chemistry</span></li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p><span>The VILT course is intended for:</span></p>
<ul>
<li><strong><span>Power plant chemists</span></strong></li>
<li><strong><span>Plant operation or maintenance engineers</span></strong></li>
<li><strong><span>Consultants and technical project managers</span></strong></li>
<li><strong><span>Boiler engineers</span></strong></li>
</ul>
</div>
</div>
</div>
<div>
<div>

Course Level 

</div>
<div id="collapsecl">
<div>
<ul>
<li>Basic or Foundation</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Training Methods 

</div>
<div id="collapseThree">
<div>
<p><span>The VILT course will be delivered online in 2 half-day sessions comprising 4 hours per day, with 2 x 10 minutes break per day, including time for lectures, discussion, quizzes and short classroom exercises.</span></p>
<p><span>Course Duration: 2 half-day sessions, 4 hours per session (8 hours in total).</span></p>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Your expert course leader <span>is a chemistry consultant in the energy sector. He works with operators of power plants and industrial facilities. He is active in water-steam cycle chemistry, where he provides support to increase chemistry maturity through audits, trainings or development of key performance indicators.</span></p>
<p><span>His role also includes operational assistance in the field of chemical cleaning and troubleshooting. More recently, he expanded his field of competence towards electrical storage. In this regard, he specializes in electrochemistry and is in charge of different tests on batteries and their components within the ENGIE Batteries Lab.</span></p>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS">
<div>
<p>To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster.<br />
Request for further information about post training coaching support and fees applicable for this.</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

</div>
<div id="collapseSeven">
<div>
               </div>
</div>
</div>
</div>
</section>

EnergyEdge - Training for a Sustainable Energy Future

Renewable Energy

Oil & Gas

Assessing the Water-Steam Chemistry Cycle in Thermal Power Plants

Team of 10, pp

Normal Fee, pp

<h3><b>XML primer training course description</b></h3>
      <p> This course has been designed for web and intranet developers who want to accelerate their learning of XML and its applications without the grind of book learning. Although a basic knowledge of HTML and JavaScript is assumed, it is also assumed you know very little about XML and how to use it. On completion of this course you should understand the benefits of using XML and be able to design XML solutions where applicable to your company's Internet/intranet requirements. The course will be particularly beneficial if you want to know how to communicate data to diverse applications over the Internet or company intranet.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	    <li>Write XML.</li>
					    <li>Debug XML.</li>
                        <li>Examine existing code and determine its function.</li>
                  </ul>
        <h5>
        <b>XML primer training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working with XML.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>HTML5 development fundamentals
							</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>XML primer training course contents</b></h3>
      <ul>
				<li>The origins of XML </li><p>
Markup languages, SGML, document type definitions and validity, introducing XML, IE and XML, accessing content and adding style.

</p><li>Basic XML </li><p>
XML document structure, elements and attributes, grammar, well formed documents, other XML elements and references.

</p><li>Document Type Definition (DTDs) </li><p>
Creating a DTD, basic declaration, declaring elements, content definitions, entities, entity declarations, notations, defining attributes, attribute types, forcing inclusion or exclusion of DTD sections, validation.

</p><li>Namespaces </li><p>
Declaring namespaces, scoping, removing and changing namespaces, qualified names, attribute namespaces.

</p><li>An introduction to schemas </li><p>
Constructing schemas, defining the root element and its contents,&lt;ELEMENTTYPE&gt;, defining root element contents, adding attributes definitions, &lt;ATTRIBUTETYPE&gt;, &lt;ELEMENT&gt;, &lt;ATTRIBUTE&gt;.

</p><li>XML &amp; the Document Object Model (DOM) </li><p>
What the DOM offers, DOM and W3C.

</p><li>Basic DOM concepts </li><p>
XML documents as trees, terminology of tree elements. Key DOM Objects: The document object and its creation, base objects, IE specifics, the XML node hierarchy.

</p><li>Programming DOM </li><p>
Viewing a DOM model as XML, getting the root element of a document, iterating nodes of a DOM, basic node properties, collection objects, searching for specific values, filtering a nodelist by tagname, more filtering methods, selecting nodes from their attributes.

</p><li>Amending Content and Structure </li><p>
Creating/saving a DOM as XML, changing content/structure, dynamically building a DOM.

</p><li>Using ASP and other techniques </li><p>
ASP techniques, HTTPREQUEST object, XSL, transforming and formatting XML. Formatting Using CSS. CSS And XML.

</p><li>XSL Transformations - XSLT </li><p>
Introduction, the XSL root element, applying XSL stylesheets to XML, XSL elements and operations, instructions - creating text nodes and applying templates, a 'drill-down' approach, simple output formatting, pattern filters - patterns based on position, the Match and Select attributes and their patterns, formatting output, creating new XML in output.</p>
			
      </ul>

XML primer

<h2>Scrum Master Exam Prep</h2>
 <p>This workshop prepares you for the Scrum.org Professional Scrum Master (PSM)™ I certification. A voucher for the exam and the access information you will need to take the exam will be provided to you via email after you have completed the course. NOTE: If you have participated in any of IIL's other Scrum workshops, you can bypass this program and focus on reading/studying the Scrum Guide and taking practice exams from Scrum.org.</p>
 <p>A Scrum Master helps project teams properly use the Scrum framework, increasing the likelihood of the project's overall success. Scrum Masters understand Scrum values, practices, and applications and provide a level of knowledge and expertise above and beyond that of typical project managers. Scrum Masters act as 'servant leaders', helping the rest of the Scrum Team work together and learn the Scrum framework. Scrum Masters also protect the team from both internal and external distractions.</p>
 <p>The Professional Scrum Master™ I (PSM I) certificate is a Scrum.org credential that enables successful candidates to demonstrate a fundamental level of Scrum mastery. PSM I credential holders will grasp Scrum as described in The Scrum Guide™1 and recognize how those concepts can be applied. They will also share a consistent terminology and approach to Scrum with other certified professionals.</p>
 <p>Scrum.org does not require that you take their own sponsored or any preparatory training. However, training can facilitate your preparation for this credential. And this course is based on IIL's Scrum Master Workshop, which is aligned with The Scrum Guide™ and was built based on PSM I credentialed expertise. It will provide you with the information you need to pass the exam and IIL will make the arrangements for your online exam. You will be provided with an exam code and instructions, so that you can take the exam at your convenience, any time you are ready after the course. Passwords have no expiration date, but they are valid for one attempt only.</p><h3>What you will Learn</h3>
 <p>You'll learn how to:</p>
 <ul>
 <li>Successfully prepare for the Scrum.org PSM I exam</li>
 <li>Comprehend the Agile Manifesto and mindset</li>
 <li>Explain the fundamental principles of Scrum, including events, artifacts, and roles</li>
 <li>Guide the Scrum team in their responsibilities</li>
 <li>Define Ready and Done</li>
 <li>Write requirements in the form of user stories</li>
 <li>Estimate using planning poker and prioritize using MoSCoW</li>
 <li>Facilitate the team through the 5 Sprint events</li>
 <li>Fulfill the role of Scrum Master in a Scrum project</li>
 <li>Create Information Radiators to enable transparency</li>
 <li>Define the structure of the retrospective</li>
 </ul><section>
                    <h3>Getting Started</h3> <ul> <li>Introductions</li> <li>Workshop orientation</li> <li>Exam prep preview</li> </ul> <h3>Foundation Concepts</h3> <ul> <li>Agile History, Values, and Mindset</li> <li>Introduction to Scrum</li> <li>Scrum events</li> <li>Scrum artifacts</li> </ul> <h3>Scrum Roles and Responsibilities</h3> <ul> <li>Product Owner responsibilities</li> <li>Scrum Master responsibilities</li> <li>The Team responsibilities</li> <li>Cross-functional teams</li> <li>Building effective teams</li> </ul> <h3>The Product Backlog and User Stories</h3> <ul> <li>The Product Backlog</li> <li>User Stories</li> <li>Definition of Done</li> <li>Backlog grooming</li> <li>Estimating User Stories</li> <li>Story points, planning poker</li> <li>Prioritizing User Stories</li> </ul> <h3>The Sprint</h3> <ul> <li>Team capacity and velocity</li> <li>The Sprint Planning Meeting</li> <li>The Sprint Backlog</li> <li>The Sprint</li> <li>Learning to self-manage, self-organize, self-improve</li> <li>Sprint Review and Retrospective</li> </ul> <h3>Project Progress and Completion</h3> <ul> <li>The Daily Scrum</li> <li>The Task Board and The Burndown Chart</li> <li>Information Radiators</li> <li>Closing a Scrum Project </li> </ul> <h3>Summary and Next Steps</h3> <ul> <li>Review of course goals, objectives, and content</li> <li>Exam prep next steps</li> </ul>


                </section>

<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>. There are the following dates on which you can opt for this course:</span></p><ol fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" style="font-size: 14px; color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="font-size: 14px; color: rgb(44, 130, 201);">Agile HR | 29-30 Apr | 9 am - 5 pm BST | Weekday | 2 days - 8 hrs/day | Best for UK / Europe</li><li style="font-size: 14px; color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="font-size: 14px; color: rgb(44, 130, 201);">Agile HR | 3-4 Jun | 9 am - 5 pm BST | Weekday | 2 days - 8 hrs/day | Best for UK / Europe</li><li style="font-size: 14px; color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="font-size: 14px; color: rgb(44, 130, 201);">Agile HR | 1-2 Aug | 9 am - 5 pm BST | Weekday | 2 days - 8 hrs/day | Best for UK / Europe</li><li style="font-size: 14px; color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="font-size: 14px; color: rgb(44, 130, 201);">Agile HR | 30-31 Oct | 9 am - 5 pm GMT | Weekday | 2 days - 8 hrs/day | Best for UK / Europe</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 | 2 days - 8 hrs/day | 9 am - 5 pm UK Time

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>The primary audience for this course are persons who are new to reporting with MicrosoftÂ© SQL ServerÂ© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. The secondary audience for this course are persons who are using Report Designer (SSRS). Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with MicrosoftÂ© SQL ServerÂ© Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience.</p>Overview<p>After completing this course, students will be able to: Create parameter reports. Create list reports. Format reports with complex expressions. Add images and subreports. Add drilldown and drillthrough functionality. Add sparklines, data bars, and indicators.</p><p>In this course, students will continue their learning on the foundations of report writing with MicrosoftÂ© SQL ServerÂ© Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data.</p></div><div id="course-pills-2"><h3>1 - Parameter Reports</h3> <ul> <li>Parameterized Reporting</li> <li>Create Report Parameters</li> <li>Modify Report Parameters</li> <li>Provide Default Parameter Values</li> <li>Provide Available Values for Parameters</li> <li>Lab: Creating Parameterized Reports</li> </ul> <h3>2 - List Data Regions</h3> <ul> <li>Introducing the List Data Region</li> <li>Create Reports Using List Data Regions</li> <li>Modify Reports Which Use List Data Regions</li> <li>Lab: Creating List Reports</li> </ul> <h3>3 - Enhancing Reports with Complex Expressions</h3> <ul> <li>Formatting Reports</li> <li>Top N Reports</li> <li>Running Values</li> <li>Lab: Enhancing Reports with Complex Expressions</li> </ul> <h3>4 - Enhance Reports with Images and Subreports</h3> <ul> <li>Add Images to Reports</li> <li>Retrieve Images from a Database</li> <li>Introducing SSRS (SQL Server Reporting Services) Report Server</li> <li>Add Subreports to Reports</li> <li>Lab: Working With Images and Subreports</li> </ul> <h3>5 - Drilldown and Drillthrough Reports</h3> <ul> <li>Add and Configure Drilldown Reporting</li> <li>Add and Configure Drillthrough Reporting</li> <li>Lab: Add Drilldown and Drillthrough Functionality to Reports</li> </ul> <h3>6 - Sparklines, Data Bars, and Indicators</h3> <ul> <li>Sparklines</li> <li>Data Bars</li> <li>Indicators</li> <li>Lab: Adding Sparklines, Data Bars, and Indicators to Reports</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55128 Writing Reports with Report Builder and SSRS Level 2 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 55128 Writing Reports with Report Builder and SSRS Level 2 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

SSRS

Service Design Courses (SDC)

Report Writing

Manager Training

Trainers Course

Teaching & Training

55128 Writing Reports with Report Builder and SSRS Level 2

<p id="isPasted" style="margin: 0cm; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin: 0cm;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 14px; font-family: Calibri, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 14px; font-family: Calibri, sans-serif; color: rgb(0, 0, 0);">Course Overview</span></strong></p><p id="isPasted" style="margin: 0cm; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin: 0cm;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" style="margin: 0cm; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin: 0cm;">Teaching
the theory and practise of suicide intervention skills that can be applied in
any professional or personal setting, captured in a one-day event accredited by
City and Guilds of London. We use only the most experienced suicide prevention
trainers to deliver this unique learning experience: for anyone who seeks
greater understanding and confidence to intervene with people at risk of
suicide. </p><p id="isPasted" 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;" fr-original-style="color: rgb(0, 0, 0);"> </span>













The
Suicide First Aid through Understanding Suicide Intervention (SFAUSI) course
gives learners the knowledge and tools to understand that suicide is one of the
most preventable deaths and some basic skills can help someone with thoughts of
suicide stay safe from their thoughts and stay alive.&nbsp;</p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 14px; color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;"><br fr-original-style="" style="box-sizing: border-box;"></span></strong></span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 14px; color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;">Course Content</span></strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">SFAUSI is comprised of 4 parts, each 90 minutes duration. The
programme teaches and practices the skills and knowledge needed to identify
someone who may be thinking about suicide and competently intervene to help
create suicide- safety as a first aid approach.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Part 1&nbsp;</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Introduction to: the day;
     programme; ourselves and suicide prevention </span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Stigma, Survivors of
     bereavement by suicide and the Hidden Toll</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Suicide thoughts and suicide
     behaviour</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Intention of behaviour Versus
     Outcome of behaviour</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Possible Causes of Suicidal
     thoughts</span></li></ul><div fr-original-style="" style="box-sizing: border-box;">Part 2</div><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Suicide &ndash; the Ripple Effect</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Population-based approach to
     suicide prevention </span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Partnership working</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Working with attitudes and
     values</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">&ldquo;I&rsquo;m so glad you told me&rdquo; -
     Audio visual</span>&nbsp;</li></ul><div fr-original-style="" style="box-sizing: border-box;">Part 3</div><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Meeting the needs of a person
     who is thinking about suicide</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Suicide-Safety Guide</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Step 1 &ndash; Recognising suicide
     and asking about suicide</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Step 2 &ndash; Understanding
     options </span><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt"><br fr-original-style="" style="box-sizing: border-box;"></span></li></ul><div id="isPasted" fr-original-style="" style="box-sizing: border-box;">Part 4</div><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="" fr-original-class="fr-close-ul" style="box-sizing: border-box;">&nbsp;<span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Step 3 &ndash; Safeguarding suicide</span></span></div></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Suicide-safety and self-care</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">The risk assessment approach</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Suicide and suicide gestures</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-family: Calibri; font-size: 12pt; box-sizing: border-box;" fr-original-style="font-family:Calibri;font-size:12.0pt">Future learning&nbsp;</span></li></ul><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-size: 14px; font-family: Calibri, sans-serif;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p id="isPasted" style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><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="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;">Format</span></strong></span></p><p id="isPasted" style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><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="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;"><br fr-original-style="" style="box-sizing: border-box;"></span></strong></span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'>






</p><p style="margin: 0in; font-family: Calibri; font-size: 12pt; color: black; box-sizing: border-box;" fr-original-style="margin:0in;font-family:Calibri;font-size:12.0pt;color:black">Taught
over 6 hours using tutor facilitated Socratic learning, tutor-led practise
session, mini lectures, group work and audio-visual presentations. This is a
highly interactive and emotionally engaging learning experience.&nbsp;</p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-size: 14px; font-family: Calibri, sans-serif;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><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="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;">Pre-training requirement</span></strong></span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><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="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;"><br fr-original-style="" style="box-sizing: border-box;"></span></strong></span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-size: 14px; font-family: Calibri, sans-serif;">No previous experience or training is necessary. Participants will be asked to self-reflect and empathise with a person having thoughts of suicide. There is no expectation on participants to share personal experiences.&nbsp;</span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-size: 14px; font-family: Calibri, sans-serif;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><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="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;">Who should attend?&nbsp;</span></strong></span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><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="font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Calibri, sans-serif;"><br fr-original-style="" style="box-sizing: border-box;"></span></strong></span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-size: 14px; font-family: Calibri, sans-serif;">Multi-sector managers and practitioners including health, housing, social care, education, criminal justice, call centre operators, private, voluntary and public sector workers and community groups or members.&nbsp;</span></p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'><span style="font-size: 14px; font-family: Calibri, sans-serif; box-sizing: border-box;" fr-original-style="font-size: 14px; font-family: Calibri, sans-serif;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p style="margin: 0in; font-family: Calibri; font-size: 12pt; color: black; box-sizing: border-box;" fr-original-style="margin:0in;font-family:Calibri;font-size:12.0pt;color:black"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Accreditation</strong>
</p><p style="margin: 0in; font-family: Calibri; font-size: 12pt; color: black; box-sizing: border-box;" fr-original-style="margin:0in;font-family:Calibri;font-size:12.0pt;color:black">&nbsp;</p><p style='font-size: medium; font-family: "Times New Roman", serif; margin: 0cm; color: rgb(0, 0, 0); box-sizing: border-box;' fr-original-style='margin-right:0cm;margin-left:0cm;font-size: medium;font-family:"Times New Roman",serif;margin:0cm;margin-top: 0cm;margin-bottom: 0cm;color: rgb(0, 0, 0);'>













</p><p style="margin: 0in; font-family: Calibri; font-size: 12pt; color: black; box-sizing: border-box;" fr-original-style="margin:0in;font-family:Calibri;font-size:12.0pt;color:black">Participants
can choose to register for the City and Guilds accredited unit of learning for
an additional fee of &pound;85 per person. This involves completion of a written
assignment. </p>

Course Overview


Teaching
the theory and practise of suicide intervention skills that can be applied in
any professional or personal setting, captured in a one-day event accredited by
City and Guilds of London. We use only the most experienced suicide prevention
trainers to deliver this unique learning experience: for anyone who seeks
greater understanding and confidence to intervene with people at risk of
suicide. 
   The
Suicide First Aid through Understanding Suicide Intervention (SFAUSI) course
gives learners the knowledge and tools to understand that suicide is one of the
most preventable deaths and some basic skills can help someone with thoughts of
suicide stay safe from their thoughts and stay alive. 


Course Content
SFAUSI is comprised of 4 parts, each 90 minutes duration. The
programme teaches and practices the skills and knowledge needed to identify
someone who may be thinking about suicide and competently intervene to help
create suicide- safety as a first aid approach. 
Part 1 
Introduction to: the day; programme; ourselves and suicide prevention
Stigma, Survivors of bereavement by suicide and the Hidden Toll
Suicide thoughts and suicide behaviour
Intention of behaviour Versus Outcome of behaviour
Possible Causes of Suicidal thoughts
Part 2
Suicide – the Ripple Effect
Population-based approach to suicide prevention
Partnership working
Working with attitudes and values
“I’m so glad you told me” - Audio visual
Part 3
Meeting the needs of a person who is thinking about suicide
Suicide-Safety Guide
Step 1 – Recognising suicide and asking about suicide
Step 2 – Understanding options
Part 4
Step 3 – Safeguarding suicide
Suicide-safety and self-care
The risk assessment approach
Suicide and suicide gestures
Future learning


Format


 
Taught
over 6 hours using tutor facilitated Socratic learning, tutor-led practise
session, mini lectures, group work and audio-visual presentations. This is a
highly interactive and emotionally engaging learning experience. 


Pre-training requirement


No previous experience or training is necessary. Participants will be asked to self-reflect and empathise with a person having thoughts of suicide. There is no expectation on participants to share personal experiences. 


Who should attend? 


Multi-sector managers and practitioners including health, housing, social care, education, criminal justice, call centre operators, private, voluntary and public sector workers and community groups or members. 


Accreditation

 
  
Participants
can choose to register for the City and Guilds accredited unit of learning for
an additional fee of £85 per person. This involves completion of a written
assignment. 

Changing Minds Training

Suicide First Aid

Public Suicide First Aid through Understanding Suicide Intervention (SFAUSI)

<article>
<div>
<h5>Java EVENINGS Course</h5>
</div>
<div></div>
<p>  						 
	</p><div>
	<ul>
		<p>
		<b>Python EVENINGS Course. </b>Basic Python syntax and principles of Object Orientated Programming. 
		<br />Most attendees are in-work IT Professional.
		<br />Private individuals are also very welcome. 
		<br />Evening courses also running.
		<br /><b>Our Style: </b>Hands-on, Practical  
		<br /><b>Location:  </b>Online, Instructor-led  
		<br /><b>Download:  </b>anaconda.com
		<br /><b>Duration:  </b>6 weeks, 1 evening per week, 6pm - 8pm
		<br /><b>Times: </b>arrange a time for your time zone
	    </p>
	</ul>	

<p></p>
</div></article>

<div>
	  <div>
		 <h5>Python Basics EVENINGS Course </h5>
	  </div>
	  <div></div>
	  <p> 
 
				This Python course London Evening covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom.
				This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language.
				These concepts are daily used by programmers and is your first step to working as a programmer.
				By the end, you'll be comfortable in programming Python code.
				You will have done small projects.
				This will serve for you as examples and samples that you can use to build larger projects.
				You can publish your code online to keep as a portfolio.

<br />
This Python Programming course is hands-on and practical, to give you in-depth, practical experience of the topics covered.

	  </p>
	<div>
	<h5>Week 1: Basics</h5>
	</div>
	<div></div>
	<div> 
					<p>  <strong>Python Data Types and Variables:</strong>  
					<br />  Primitive types; Characters &amp; Strings; Boolean; Working with variables and its scope; Conversion and casting types in Python.	 
					<br /> <strong>Operators and Expressions: </strong>   
					<br />  Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators.
					</p> 
			 
				<p><strong> Decision Making:</strong>
				<br />If statement; If - else statement; If- elif - else statement; Nested if - else.
				</p><p><strong>Using Loops:</strong>
				<br />The while, while-else.
				<br />For loop;
				<br />Jump statements: break, continue;
				<br />Nesting loops.				
				</p>
			</div>
	<div>
	<h5>Week 2: Data Structures</h5>
	</div> <div></div>
	<div> 
				<p> Lists.
					<br />Tuples.
					<br />Sets.
					<br />Dictionary. Nested Dictionary.
					<br />Json Files.
				</p>
			</div>
	<div>
	<h5>Week 3: Python built-in functions</h5>
	</div> <div></div>
	<div> 
				<p>  
				<br />Using Built-in modules and functions:
				<br />Strings Functions.
				<br />Pattern matching with Regex.
				<br />Maths Functions.
				<br />Random Functions.
				<br />Python Date functions.
				</p>
			</div>
	<div>
	<h5>Week 4: OOP: Using Modules, functions, classes</h5>
	</div> <div></div>
	<div>
				<p>  Creating and using custom Functions.
					<br />Creating functions;
					<br />Using parameters and return values;
					<br />
					<br />Introduction to Classes and Objects:
					<br />Creating a Class; 
					<br />Creating an Object; Using an Object; 
					<br />Adding Instance variables; Controlling accessibility; Naming conventions for class members. 
					<br /> Class Constructors; Parameterized Constructors.
					<br />Inheritance. Overload.
				</p>
			</div>

	<div>
	<h5>Week 5: Pandas DataBase Basics</h5>
	</div> <div></div>
	<div>	 
		<p> <b>Connection details:</b>
				Connect to a database using access codes. 
				<br /><b>Select Queries:</b>
				Retrieving records and iterating results sets, using variables and parameters in queries. 
				<br />Working with DDL comands:
				Create a database, drop a database.
				Create a table, alter tables, drop a table. 
				<br />Working with DML Commands:
				Insert, delete, update records.
		</p>
	</div>
	
	 
	<div>
	<h5>Week 6: Pandas Dataframe Basics</h5>
	</div> <div></div>
	<div>	 
		<p> Getting data into a dataframe:
			<br />Dict to Dataframe, Dataframe to Dict.
			<br />Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets.

			<br />Dataframe basics:
			<br />Slicing Dataframes,
			<br />Getting information about the dataframe,
			<br />Filter, sort and query a Dataframes,
			<br />Duplicate values,
			<br />Working with null-values,
			<br />Sampling,
			<br />Group by,
			<br />Join.

		</p>
	</div>
	  
</div>
 

<div>   

	   <div id="cincluded">
		  <div>
			 <h5>What is included</h5>
		  </div>

		  <article>
		  <div>
			 <ul>
				<li>PCWorkshops Course Certificate on completion  </li>
									   
				<li>Python Course Notes</li>
				<li>Python Code Examples</li>
				<li>Practical Python Course exercises and Code Samples</li>
				<li>After the course: 1-Hour personalised online revision session</li>
			 </ul>
		  </div>
		  </article>
	   </div>
				    
<div>
	                  <div>
	                     <h5 id="cincluded2">Book the Python  Course</h5>
	                  </div>
 
<div id="eventbrite-widget-container-60636103217"></div>




							 
</div>
				   <div id="caboutus">
	                  <div>
	                     <h5>About us</h5>
	                  </div> 
	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>
				   
				   
	        </div>

Python EVENINGS Course
Basic Python syntax and principles of object-oriented programming. 
Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 

Details:
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 4 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 
How to attend:  
Connection Link For the course: https://meet.goto.com/910697125
Once you have made the payment, use the above link on the date booked, to connect with the trainer. 
Python Basics EVENINGS Course
 This Python course London Evening covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom. This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language. These concepts are daily used by programmers and is your first step to working as a programmer. By the end, you'll be comfortable in programming Python code. You will have done small projects. This will serve for you as examples and samples that you can use to build larger projects. You can publish your code online to keep as a portfolio. 

This Python Programming course is hands-on and practical, to give you in-depth, practical experience of the topics covered. 
Week 1: Basics
 Python Data Types and Variables: 
Primitive Data types; Working with variables and its scope; Conversion and casting types in Python. 
 Operators and Expressions:  
 Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators. 
 Decision Making: 
If statement; If - else statement; If- elif - else statement; Nested if - else. 
Using Loops: 
The while, while-else. 
For loop; 
Jump statements: break, continue; 
Nesting loops. 
Week 2: Data Structures & Database
Lists.  
Tuples. 
Sets. 
Dictionary. Nested Dictionary. 
Json Files. 
Reading csv and text files
Connecting with a database and run SQL Queries. 
Week 3: Python built-in functions &  Pandas Dataframe Basics
 
Using built-in modules and functions: 
Strings Functions. 
Maths Functions. 
Random Functions. 
Data Frames; 
Getting data into a dataframe: 
Dict to Dataframe, Dataframe to Dict.  
Dataframe basics: 
Slicing Dataframes, 
Getting information about the dataframe, 
Filter and query a Dataframes, 
Working with null-values.
Week 4: OOP: Using Modules, functions, classes
 Creating and using custom Functions. 
Creating functions; 
Using parameters and return values; 
 
Introduction to Classes and Objects: 
Creating a Class; 
Creating an Object; Using an Object; 
Adding instance variables; controlling accessibility; and naming conventions for class members. 
 Class Constructors; Parameterized Constructors. 
Inheritance. Overload. 

What is included
PCWorkshops Course Certificate on completion
Python Course Notes
Python Code Examples
Practical Python Course exercises and Code Samples
After the course: 1-Hour personalised online revision session
  

PCWorkshops

Online Course Creation

Programming Fundamentals

Computer Programming

Professional Skills Course (PSC)

Instructor

Python

Basic Python syntax and principles of Object Orientated Programming. 
Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 6 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 

Python EVENINGS Course, Online Instructor-led

General admission

<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><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 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;">Course Summary:</strong>
</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This workshop aims to increase awareness of Safeguarding and Protecting Children, helping coaches to recognise signs of abuse and poor practice, and deal sensitively and effectively with issues that arise. It also prompts a review of coaching practice to ensure that sport provides a positive and enriching experience for children.</p><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 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;">The 2.5 hour workshop covers the following and learners will be able to:</strong>
</p><ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Identify and recognise good coaching practice and the implications for them.</li>
<li fr-original-style="" style="box-sizing: border-box;">Explore their values and feelings in relation to child abuse, and recognise how these may potentially impact on their response.</li>
<li fr-original-style="" style="box-sizing: border-box;">Recognise and respond to the signs and symptoms of child abuse and poor practice.</li>
<li fr-original-style="" style="box-sizing: border-box;">Take appropriate action if concerns about a child arise.</li></ul><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 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;">If you require a group booking for your staff/volunteers, please select group booking to request a private group session. This option will require a minimum of 10 delegates.</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p>






Course Summary:

This workshop aims to increase awareness of Safeguarding and Protecting Children, helping coaches to recognise signs of abuse and poor practice, and deal sensitively and effectively with issues that arise. It also prompts a review of coaching practice to ensure that sport provides a positive and enriching experience for children.



The 3 hour workshop covers the following and learners will be able to:

Identify and recognise good coaching practice and the implications for them.
Explore their values and feelings in relation to child abuse, and recognise how these may potentially impact on their response.
Recognise and respond to the signs and symptoms of child abuse and poor practice.
Take appropriate action if concerns about a child arise.



If you require a group booking for your staff/volunteers, please select group booking to request a private group session. This option will require a minimum of 8 delegates. If we do not have 8 delegates the course will be rearranged for a later date.
 

Active Lancashire

Health & Wellbeing

Safeguarding

Children First Aid

Safeguarding & Protecting Children

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

Azure PowerShell

Powershell

Microsoft AZ-104

Power Automate

Microsoft AZ-303

Microsoft Power Automate

AZ-040T00 Automating Administration with Powershell

<article>
<div>
<h5>Learn SQL Course, 1-Day</h5>
</div>
<div></div>
<p>  						 
	</p><div>
	<ul>
		<p>
		<b>SQL Queries Course, 1-Day. </b>Basic SQL syntax. 
		<br />Most attendees are in-work IT Professional.
		<br />Private individuals are also very welcome. 
		<br />Evening courses also running.
		<br /><b>Our Style: </b>Hands-on, Practical  
		<br /><b>Location:  </b>Online, Instructor-led  
		<br /><b>Download:  </b>anaconda.com
		<br /><b>Duration:  </b>6 weeks, 1 evening per week, 6pm - 8pm
		<br /><b>Times: </b>arrange a time for your time zone
	    </p>
	</ul>	

<p></p>
</div></article>

<div>
	  <div>
		 <h5>Learn SQL Course, 1-Day</h5>
	  </div>
	  <div></div>
	  <p> With SQL Queries, you could learn SQL in a day, and master the basics of SQL, get interesting, insightful and essential business intelligence from data by using SQL queries on this SQL Course London, UK. 
	  <br />Queries are made easy and simple, saving hours of online training.
 
		<br />This 1 Day course is packed with power query techniques.

<br /><br />This SQL Introduction Course is hands-on, practical with many excellent query examples.
<br /><br />This course is Platform Independent.
<br /><br />This SQL course is hands-on and practical, to give you in-depth, practical experience of the topics covered.
<br /><br />Ask your SQL questions in small, friendly classroom SQL Course. 
<br /><br />Online, Instructor-led, Interactive, full screen sharing.

	  </p>
	<div>
	<h5> Learn SQL Relational Database Concepts:</h5>
	</div>
	<div></div>
	<div> 
					<p>  <strong>Database:</strong>  
					<br />What is a Relational Database?
<br />Tables, Rows and Columns
<br />Indexes, Primary Keys and Foreign Keys
<br />Data Types  
					</p> 
			 
				 
			</div>
	<div>
	<h5>Learn SQL Essentials:</h5>
	</div> <div></div>
	<div> 
				<p> <strong>Basics.</strong>
					<br />SQL Language Essentials:
<br />The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values
<br />SQL Arithmetic Operations, Expression Queries
<br />SQL Column Aliases
<br />Limit/Top, Distinct

				 
				</p>
			</div>
	<div>
	<h5>Summarizing and Grouping Data:</h5>
	</div> <div></div>
	<div> 
				<p>  <strong>Group by</strong>
				<br />
Aggregate Functions (Sum, Avg, Count, Max, Min)
<br />The Group By Clause
<br />The Having Clause
				 
				</p>
			</div>
	<div>
	<h5>Querying Multiple Tables:</h5>
	</div> <div></div>
	<div>
				<p>   <strong>Joins</strong>
					<br />
Joining Tables
<br />Inner Joins, Outer Joins, Self Joins, Full Joins, 
<br />Cross Joins
<br />Alternative Join Syntax
				</p>
			</div>

	 
	
	 
	<div>
	<h5>Basic Subqueries</h5>
	</div> 
	<div></div>
	<div>	 
		<p> <strong>Sub-queries</strong>
			<br />Basics of CTE tables
			<br />SQL subqueries 
			<br />Using subqueries in the from clause
			<br />Using subqueries in the where clause
			<br />Using subqueries in the select clause
			<br />Using subqueries in the having clause 
			
		</p>
	</div>
	<div>
	<h5>Combine Queries</h5>
	</div> 
	<div></div>
	<div>	 
		<p> <strong>Combine Queries</strong>
			<br />The Union Operator
			<br /> Intersect and Minus Operators
			<br /> Simulating combine Intersect and Minus queries by using sub-queries
					   

			 

		</p>
	</div>
	  
</div>
 

<div>   

	   <div id="cincluded">
		  <div>
			 <h5>What is included</h5>
		  </div>

		  <article>
		  <div>
			 <ul>
				<li>PCWorkshops Course Certificate on completion  </li>
									   
				<li>SQL Course Notes</li>
				<li>SQL Code Examples</li>
				<li>Practical SQL Course exercises and Code Samples</li>
				<li>After the course: 1-Hour personalised online revision session</li>
			 </ul>
		  </div>
		  </article>
	   </div>
				    
<div>
	                  <div>
	                     <h5 id="cincluded2">Book the SQL Course</h5>
	                  </div>
 
	 
 <div id="eventbrite-widget-container-100389112538"></div>




									
					
					 
</div>
				   <div id="caboutus">
	                  <div>
	                     <h5>About us</h5>
	                  </div> 
	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
										<li>
										<div id="LTF_ST_m8v4lCcicRynaFxnT4tD2JOVCitkIkMwzh0sIQRc9Toth01PZo"></div>
										</li>	
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>
				   
				   
	        </div>

Learn SQL Course, 1-Day
This SQL course is platform independent.
SQL Queries Course, 1-Day. Basic SQL syntax.  This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 

Details
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 6 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 
Join us on your booked dates on https://meet.goto.com/910697125
Learn SQL Course, 1-Day Online Instructor-led
With SQL Queries, you could learn SQL in a day, and master the basics of SQL, and get interesting, insightful, and essential business intelligence from data by using SQL queries on this SQL Course in London, UK. 
Queries are made easy and simple, saving hours of online training. 
This 1 Day course is packed with power query techniques. 

This SQL Introduction Course is hands-on, practical with many excellent query examples.
This SQL course is hands-on and practical to give you in-depth, practical experience of the topics covered.
Ask your SQL questions in a small, friendly classroom SQL course. 

Learn SQL. Relational Database Concepts:
 Database: 
What is a Relational Database?

Tables, Rows and Columns

Indexes, Primary Keys and Foreign Keys

Data Types 
Learn SQL Essentials:
 Basics. 
SQL Language Essentials:

The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values

SQL Arithmetic Operations, Expression Queries

SQL Column Aliases

Limit/Top, Distinct 
Summarizing and Grouping Data:
 Group by 

Aggregate Functions (Sum, Avg, Count, Max, Min)

The Group By Clause

The Having Clause 
Querying Multiple Tables:
 Joins 

Joining Tables

Inner Joins, Outer Joins, Self Joins, Full Joins, 
Cross Joins

Alternative Join Syntax 
Basic Subqueries
 Sub-queries 
Basics of CTE tables 
SQL subqueries 
Using subqueries in the from clause 
Using subqueries in the where clause 
Using subqueries in the select clause 
Using subqueries in the having clause 
 
 Combine Queries 
The Union Operator 
 Intersect and Minus Operators 
 Simulating combined Intersect and Minus queries by using sub-queries 

What is included
PCWorkshops Course Certificate on completion
SQL Course Notes
SQL Code Examples
Practical SQL Course exercises and Code Samples
After the course: 1-Hour personalised online revision session
  



Database Programming

IT Skills

Data Skills

SQL Queries Course, 1-Day. Basic SQL syntax.  This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 

Learn SQL Basics, 1-day Course, Online Instructor-Led

Bournemouth

London Waterloo Academy

Flight Attendant

Stewardess

FLIGHT ATTENDANT VIRTUAL VIA ZOOM COURSE, EVENINGS

Registration Fee

Course Fee

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

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Microsoft Power Platform

Microsoft BI

Data Analyst

PL-300T00 Microsoft Power BI Data Analyst

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

101 Courses in Bristol

High Performing Teams (HPTs)

By Lapd Solutions Ltd

MySQL for developers

By Systems & Network Training

Querying Microsoft SQL Server

By Systems & Network Training

Scrum Master Workshop: In-House Training

By IIL Europe Ltd

Definitive Kamailio for engineers

By Systems & Network Training

Scrum Master Exam Prep: In-House Training

By IIL Europe Ltd

Leadership Identity Through Self-Discovery

By Puritas

Assessing the Water-Steam Chemistry Cycle in Thermal Power Plants

By EnergyEdge - Training for a Sustainable Energy Future

XML primer

By Systems & Network Training

Scrum Master Exam Prep: In-House Training

By IIL Europe Ltd

Search By Location