Name: Duty of Care Approved Online Training
Price: 29 GBP
Availability: InStock

The National Food Hygiene Rating Scheme (NFHRS) is a pivotal framework for businesses in the food industry, aiming to provide transparency and encourage high standards of food hygiene. The scheme rates businesses on a scale from 0 to 5, with 5 indicating very good hygiene standards. Inspectors assess three key areas: food handling, the condition of the premises, and the management's food safety procedures, with each area contributing to the overall score. Should a business disagree with their rating, an appeals process is in place, allowing them to contest the decision within a stipulated timeframe. Integral to maintaining high standards is the Safer Food Better Business (SFBB) management system, which guides businesses in implementing effective food safety management procedures. Additionally, preventing contamination by pathogens such as E. coli is crucial; businesses must adhere to strict guidelines to control risks and ensure food safety. Ultimately, achieving a high rating not only reflects a commitment to hygiene and safety but also serves as a mark of trust for consumers. By understanding the scoring criteria, engaging with the SFBB system, and implementing robust measures against contaminants like E. coli, businesses can strive for excellence and potentially secure the highest rating possible.

Twig Services Ltd

Food Safety

Food & Hygiene

Hygiene

Online Safeguarding

HACCP

 Food Hygiene Rating (Level 5) Approved Online Training

General Admission

The course on lockdown procedures is designed to equip participants with the necessary knowledge and skills to effectively manage emergency situations in educational settings. It begins with an overview of the learning outcomes, detailing what participants will be able to understand and accomplish by the end of the course. The role of the lockdown officer is then defined, emphasizing the responsibilities and decision-making processes critical during a lockdown. The course will explore various scenarios that may necessitate a lockdown, providing insights into the indicators and threats that could trigger such a response. Participants will learn about the preparatory measures that can be implemented to ensure the safety and readiness of the school, including communication plans, safety drills, and security protocols. In the event of an actual lockdown, the course will guide through the actions that should be taken to safeguard all individuals on the premises, maintain order, and liaise with emergency services. The aim is to create a comprehensive understanding of the procedures and best practices to maintain a secure learning environment.

Child Exploitation Online Protection (CEOP)

School Nurse

Child Safeguarding

Safety Awareness

'Lockdown Procedure for Schools' Approved Online Training

Social care is a vital field that encompasses a range of services designed to support individuals who need assistance due to age, disability, or other factors affecting their ability to manage daily living activities independently. Choosing a career in social care is often driven by a desire to make a positive impact on the lives of others, providing support and enhancing well-being. The primary goals and objectives of social care are to promote independence, protect dignity, and ensure the safety of individuals in need of care. 

A comprehensive course on social care would delve into the various job roles within the sector, highlighting the importance of person-centred care, which tailors support to the individual's unique needs and preferences. Understanding the code of practices is crucial for maintaining professional standards and ethical conduct. Additionally, knowledge of government legislation is essential, as it governs the framework within which care must be delivered, ensuring rights and protections for both service users and providers.
Effective communication and conflict resolution are also key components of social care, enabling practitioners to navigate the complexities of interpersonal dynamics in the workplace. By addressing these topics, such a course prepares individuals for the rewarding, though sometimes challenging, career in social care.

Care Worker

Career Development

Health & Social Care

Support Worker

Social Care

Understanding Your Role Working Within the Care Sector

Safeguarding vulnerable children is a critical responsibility that involves understanding and mitigating the risks they may face. The term encompasses a wide range of actions and processes aimed at protecting children from abuse and neglect. It is essential for those involved in childcare to be aware of the various forms of abuse, which can be physical, emotional, sexual, or stem from neglect. Recognizing the signs of abuse is crucial for early intervention and prevention. Legislation plays a pivotal role in safeguarding, providing a framework for action and ensuring that measures are in place to protect the welfare of children. Training videos on this topic are invaluable resources that help raise awareness and educate individuals on how to identify and respond to potential risks, ensuring the safety and well-being of children in their care.

Safeguarding

Child Protection

Designated safeguarding lead (DSL)

Safeguarding Children Approved Online Training

Person-centred care is a holistic approach to healthcare that respects and values the uniqueness of the individual. The concept originated from the work of psychologists such as Carl Rogers and Abraham Maslow, who emphasized the importance of personal identity and autonomy in the healing process. This approach underlines the significance of tailoring care to meet the individual needs, preferences, and values of service users. It involves active participation and collaboration between caregivers and service users in designing and managing care. Essential components of person-centred care include the creation of detailed care plans, maintaining comprehensive daily reports, and ensuring informed consent is obtained for all interventions. By focusing on these elements, caregivers can ensure that each person receives care that not only addresses their health needs but also supports their overall well-being.

Autism Spectrum Counselling & Training (ASPECT)

Health Coach Training

Caregiver Skills Training (CST)

Dementia Training

Online Education

'Person-Centred Care' Approved Online Training

Display Screen Equipment (DSE) is essential in the modern workplace, and its correct usage is crucial for maintaining employee health and productivity. DSE encompasses a variety of devices including computers, laptops, tablets, and monitors. Incorrect setup and poor usage practices can lead to musculoskeletal problems, eye strain, and other health issues. Therefore, it is imperative for employees to receive comprehensive training on the proper use of DSE. This not only minimizes health risks but also ensures compliance with workplace safety regulations. Employers and employees must collaborate to create an ergonomic work environment that promotes safety and well-being.

Health & Safety Awareness

E Safety

Security Awareness

Information Security Awareness

Display Screen Equipment  (DSE) Awareness Approved Online Training

Employee Engagement

HR Management

Relationship Building

People Management

Workplace Communication

Nurturing 'Good Employee Relations' in the Workplace Approved Online Training 

End-of-life care is a critical and sensitive aspect of healthcare that focuses on providing comfort and support to individuals who are nearing the end of their lives, as well as their families. This course aims to equip participants with the necessary knowledge and skills to navigate the complex emotional landscape that accompanies this period. It covers understanding the common emotions experienced during this time, such as grief and anxiety, and offers strategies for managing them effectively. Additionally, the course provides guidance on collaborating with healthcare professionals, ensuring that the care provided is respectful, compassionate, and in line with the patient's wishes. By the end of this course, attendees should feel more prepared to handle the challenges of end-of-life care with empathy and professionalism.

Approved Training Organisation (ATO)

Medical Training

Palliative Care

End Of Life Care

End of Life Care Approved Online Training

The course on handling information in care settings is designed to equip participants with the essential knowledge and skills required to manage sensitive data responsibly. Understanding the principles of secure information handling is crucial in maintaining the privacy and trust of those in care. The course emphasizes the significance of confidentiality and educates on the legal and ethical obligations of care providers. By defining critical terms like 'need to know' and 'consent,' it ensures that all participants are on the same page regarding their responsibilities. Additionally, the course provides resources for support, ensuring that any uncertainties regarding information access can be promptly and effectively addressed. This foundational knowledge is vital for fostering a safe and trusting environment in any care setting.

Health Skills

Handling Information Specifically for Care Setting Environments Approved Online Training 

The concept of 'duty of care' is fundamental in health and social care sectors, emphasizing the moral and legal obligation of professionals to prioritize the well-being of those they serve. This principle ensures that service users receive the highest standard of care, safeguarding their rights and dignity. A comprehensive understanding of duty of care not only guides practitioners in delivering quality care but also equips them to handle complex situations ethically. Training courses on this topic typically explore the implications of duty of care in daily practice, strategies for resolving dilemmas, and resources for professional support, enhancing the caregiver's ability to make informed decisions that align with the core values of their profession.

Compliance & Safety

Teaching Online

Duty of Care Approved Online Training

Overview:
This 1-day Driver CPC Periodic Training course is dedicated to understanding and addressing the needs of Vulnerable Road Users (VRUs), such as pedestrians, cyclists, motorcyclists, and those with mobility challenges. Through a two-part approach, drivers will learn practical strategies for safe interactions with VRUs and develop an enhanced awareness of the road environment to promote safer roads for everyone.

Who Should Attend:
This course is ideal for all professional drivers who are required to undertake Driver CPC Periodic Training to maintain their Driver CPC Licence. It’s particularly beneficial for drivers working in urban or densely populated areas where VRU encounters are common.
Learning Objectives:
This course is designed to:
	•	Enhance Awareness: Equip drivers with an understanding of the specific challenges faced by vulnerable road users.
	•	Promote Safe Driving Practices: Provide techniques for anticipating VRU behavior and responding proactively.
	•	Reduce Risks: Educate drivers on best practices to minimise accidents and improve safety for all road users.

Course format: Online 


Total Compliance 

Driver CPC - 1 Day Periodic 7 Hour Course - Vulnerable Road Users 1 & 2

<div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course is for those who would like to start a business as a Colour Consultant. </p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course is designed for trainees worldwide and is delivered over five colour modules plus one marketing module, each lasting four hours. Including homework, the complete course will take up approximately 30 hours of your time.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">There are no prerequisites for signing up for this course, we will take you through all the theory and practical sessions, building your knowledge and confidence in the subjects.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our virtual approach to training means that you really do have the best seat in the house!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">All of the sessions are conducted &lsquo;live&rsquo; and online by your Colour Me Beautiful trainer. Classes are kept deliberately small to enhance your learning; maximum number 4.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Immediately after your virtual training you will have the flexibility to run your own&nbsp;Colour Me Beautiful&nbsp;business as a colour consultant, meaning you can start to earn money straight away.</p><div style="color: rgb(10, 10, 10); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(10, 10, 10);"><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">TOPICS</h5></div><div style="color: rgb(10, 10, 10); box-sizing: border-box;" fr-original-style=" color: rgb(10, 10, 10);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">The History of Colour Me Beautiful</li><li fr-original-style="" style="box-sizing: border-box;">The Colour Me Beautiful System</li><li fr-original-style="" style="box-sizing: border-box;">Dominant Colour Types</li><li fr-original-style="" style="box-sizing: border-box;">Understanding colour terms</li><li fr-original-style="" style="box-sizing: border-box;">Draping techniques for women &amp; men</li><li fr-original-style="" style="box-sizing: border-box;">Practise on volunteers</li><li fr-original-style="" style="box-sizing: border-box;">Cosmetic colour selection and application</li><li fr-original-style="" style="box-sizing: border-box;">Conducting a consultation</li><li fr-original-style="" style="box-sizing: border-box;">Setting up and marketing your business</li><li fr-original-style="" style="box-sizing: border-box;">How to conduct group presentations</li></ul><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);">As well as training in colour, we also include business and marketing, sales and presentation skills, along with ongoing training to enhance your skills.</span></div><div style="color: rgb(10, 10, 10); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(10, 10, 10);"><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">By the end of this course you will</h5></div><div style="color: rgb(10, 10, 10); box-sizing: border-box;" fr-original-style=" color: rgb(10, 10, 10);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Be confident in assessing the dominant colouring using the Colour Me Beautiful system</li><li fr-original-style="" style="box-sizing: border-box;">Be able to conduct a colour analysis using the dominant colours</li><li fr-original-style="" style="box-sizing: border-box;">Be confident in applying a simple make-up routine to your client</li><li fr-original-style="" style="box-sizing: border-box;">Have the required knowledge to market your business</li><li fr-original-style="" style="box-sizing: border-box;">Understand the Colour Me Beautiful back office procedures</li></ul><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">You will receive</strong></div><div style="color: rgb(10, 10, 10); box-sizing: border-box;" fr-original-style=" color: rgb(10, 10, 10);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">20 hours of live online colour tuition with your tutor</li><li fr-original-style="" style="box-sizing: border-box;">4 hours live online business &amp; marketing training</li><li fr-original-style="" style="box-sizing: border-box;">Starter Kit</li><li fr-original-style="" style="box-sizing: border-box;">Comprehensive training manual</li><li fr-original-style="" style="box-sizing: border-box;">Certificate upon completion</li><li fr-original-style="" style="box-sizing: border-box;">Trade account</li><li fr-original-style="" style="box-sizing: border-box;">Access to the consultant support forum</li><li fr-original-style="" style="box-sizing: border-box;">Access to consultant lounge</li><li fr-original-style="" style="box-sizing: border-box;">International directory listing</li><li fr-original-style="" style="box-sizing: border-box;">12 months Colour Me Beautiful licence upon course completion</li></ul></div></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></div>

This course is for those who would like to start a business as a Colour Consultant. 
The course is designed for trainees worldwide and is delivered over five colour modules plus one marketing module, each lasting four hours. Including homework, the complete course will take up approximately 30 hours of your time.
There are no prerequisites for signing up for this course, we will take you through all the theory and practical sessions, building your knowledge and confidence in the subjects.
Our virtual approach to training means that you really do have the best seat in the house!
All of the sessions are conducted ‘live’ and online by your Colour Me Beautiful trainer. Classes are kept deliberately small to enhance your learning; maximum number 4.
Immediately after your virtual training you will have the flexibility to run your own Colour Me Beautiful business as a colour consultant, meaning you can start to earn money straight away.
TOPICS
The History of Colour Me Beautiful
The Colour Me Beautiful System
Dominant Colour Types
Understanding colour terms
Draping techniques for women & men
Practise on volunteers
Cosmetic colour selection and application
Conducting a consultation
Setting up and marketing your business
How to conduct group presentations
As well as training in colour, we also include business and marketing, sales and presentation skills, along with ongoing training to enhance your skills.
By the end of this course you will
Be confident in assessing the dominant colouring using the Colour Me Beautiful system
Be able to conduct a colour analysis using the dominant colours
Be confident in applying a simple make-up routine to your client
Have the required knowledge to market your business
Understand the Colour Me Beautiful back office procedures
You will receive
20 hours of live online colour tuition with your tutor
4 hours live online business & marketing training
Starter Kit
Comprehensive training manual
Certificate upon completion
Trade account
Access to the consultant support forum
Access to consultant lounge
International directory listing
12 months Colour Me Beautiful licence upon course completion

Colour Me Beautiful

Beauty Specialist

Color Theory

Cosmetics

Beauty & Makeup

Beauty Therapy

Learn the foundation to colour analysis with this 5 day live and online, interactive course

Intermediate Colour Analysis

London

<div>
	                  <h5>Oracle SQL Fundamentals Course Summary</h5>
	               </div>
	               <div></div>
	               <p> 
				   
				  At this Oracle SQL Fundamentals couse, we cover SQL  queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom funtions, table variables.		  
					<br />Course level is beginners to intermediate.
				   
					 
					 
					 
				  </p>
				   
				   
	               <div>
	                  <div>
	                     <h5>Oracle SQL Fundamentals Course Outline</h5>
	                  </div>
	                  <div></div>
	                   
	    <div>
			<strong>Session 1: Database Concepts Revision: </strong> 
			 <p>  What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,
	 
			</p>
		</div>
		<div>
			<strong>Session 2: </strong>  
			<p> 	
			</p><ul>
			<li>
			  The SQL SELECT statement:WHERE clause, Boolean operators (AND and OR) and SQL conditional operators (=,!=,smaller and bigger than ,IN, and BETWEEN).The ORDER BY clause, Column aliases, LIMIT  TOP, Distinct 
			</li>
			</ul> 
			<p></p>
		</div>	 
		<div>
			<strong>Session 3:</strong>  
			<p> 
			</p><li> Expression queries: Arithmetic expressions, Null functions ('IS NULL,' 'IS NOT NULL,' , 'Coalesce')

			</li>
			<p></p>
		</div>	
	 
		<div>
			<strong>Session 4: </strong>  
			<p></p><ul>
				<li>SQL AGGERGATE Functions: Sum, Average, Maximum, Minimum, Count, Group By, Having.
				</li> 
				</ul>
			<p></p>
		</div>	
	 
		<div>
			<strong>Session 5:</strong>  
			<p></p><ul> <li> Joins: SQL Cartesian products, 
			 </li><li>SQL Joins (Inner join, Left join, Right join, Full join
			 </li><li>Table aliases, Natural joins, Multi-table joins. 
			 </li><li>Union, Union All, Except, Intersect
			 </li></ul>
			<p></p>
		</div>	
		<div>
			<strong>Session 6:</strong>  
			<p></p><ul> <li>
			Sub-queries: SQL Subqueries, Nested Subqueries, 
			</li><li>'WITH AS',
			</li><li>			Correlated and uncorrelated subqueries.  
			 </li></ul>
			<p></p>
		</div>

		<div>
			<strong>Session 7:</strong>  
			<p></p><ul> <li>
			 Numeric Functions, 
			 </li><li>String Functions, 
			</li><li>			 Date Functions
			Date, time and timezone support,  
			</li><li>Conversion and 
			</li><li>Formatting
			 </li></ul>
			<p></p>
		</div>
		<div>
			<strong>Session 8:</strong>  
			<p></p><ul> <li>
			SQL Views: Create, alter and drop Views 
			 </li></ul>
			<p></p>
		</div>
		<div>
			<strong>Session 9:</strong>  
			<p></p><ul> <li>
			Inserting rows, 
			</li><li>Replacing rows, 
			</li><li>Updating rows, 
			</li><li>Deleting rows
			 </li></ul>
			<p></p>
		</div>
		<div>
			<strong>Session 10:</strong>  
			<p></p><ul> <li>
			Session 10: Managing indexes 
			 </li></ul>
			<p></p>
		</div>
		<div>
			<strong>Session 11:</strong>  
			<p></p><ul> <li>
			 Creating Databases and 
			 </li><li>Creating Tables (Create, alter and drop); </li><li>Constraints (Add, alter and drop)  
			 </li><li>Temp tables
			</li><li>Managing sequences and synonyms 
			 </li></ul>
			<p></p>
		</div>
		<div>
					<strong>Session 12:</strong>  
					<p></p><ul> <li>
					 Import data into SQL and Export from SQL
					
					 </li></ul>
					<p></p>
		</div>		
		 
		 
		 
 
 
 
 
	               </div>
	               <div id="cincluded">
	                  <div>
	                     <h5>What is included in the SQL Advanced Course:</h5>
	                  </div>
	                  <div>
	                     <ul>
	                        <li>SQL Advanced Course Certificate on completion  </li>
	                        <li>SQL Advanced Course notes</li>
	                        <li>Practical SQL Course exercises, SQL Code Sample</li>
	                         
	                        <li>After the course, 1 free session for questions online SQL Course via Gotomeeting.com.</li>
	                        <li>Max group size, online and in classroom, on this SQL Course is 4. </li>
	                     </ul>
	                  </div>
	               </div>

Oracle SQL Fundamentals Course 
 At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. 
Course level is beginners to intermediate. 
Oracle SQL Fundamentals Course Outline
Session 1: Database Concepts Revision:
 What is a database? Tables, rows and columns, Indexes, primary keys, foreign keys, 
Session 2:
 The SQL SELECT statement: WHERE clause, Boolean operators (AND and OR), and SQL conditional operators (=,!=, smaller and bigger than, IN, and BETWEEN).The ORDER BY clause, Column aliases, LIMIT TOP, Distinct

Session 3:
Expression queries: Arithmetic expressions, Null functions ('IS NULL,' 'IS NOT NULL,' , 'Coalesce')

Session 4:
SQL AGGERGATE Functions: Sum, Average, Maximum, Minimum, Count, Group By, Having.

Session 5:
Joins: SQL Cartesian products,
SQL Joins (Inner join, Left join, Right join, Full join)
Table aliases, Natural joins, Multi-table joins.
Union, Union All, Except, Intersect

Session 6:

Sub-queries: SQL Subqueries, Nested Subqueries,
'WITH AS',
Correlated and uncorrelated subqueries.

Session 7:

Numeric Functions,
String Functions,
Date Functions Date, time and timezone support,
Conversion and
Formatting

Session 8:

SQL Views: Create, alter and drop Views

Session 9:

Inserting rows,
Replacing rows,
Updating rows,
Deleting rows

Session 10:

Session 10: Managing indexes

Session 11:

Creating Databases and
Creating Tables (Create, alter and drop);
Constraints (Add, alter and drop)
Temp tables
Managing sequences and synonyms

Session 12:

Import data into SQL and Export from SQL

What is included in the Oracle SQL Course:
Oracle SQL Course Certificate on completion
Oracle SQL Course notes
Practical Oracle SQL Course exercises, Oracle SQL Code Sample
After the course, 1 free session for questions online Oracle SQL Course 
Max group size, online and in classroom, on this Oracle SQL Course is 4.

PCWorkshops

Database Design & Development

Oracle SQL

Database Programming

Database Administration

 At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. 
Course level is beginners to intermediate. 

Oracle SQL Fundamentals, 3 Days

General admission

<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
  



Online Course Creation

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

Chesterfield

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;">QA Level 2 Award In Principles Of Risk Assessment (RQF)</h2><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Face to Face: One-day course</li><li fr-original-style="" style="box-sizing: border-box;">Virtual Classroom: Spread over 3 sessions of 2&frac12; hr duration</li><li fr-original-style="" style="box-sizing: border-box;">Don&#39;t run risks with the safety of your people - it will cost you a lot more when things start to go wrong...</li><li fr-original-style="" style="box-sizing: border-box;">Risk Assessments are vital for Health and Safety, and vital for the whole process</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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Contents:</strong><ul id="isPasted" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Main causes of Work-related Fatalities, Injuries and ill health</li><li fr-original-style="" style="box-sizing: border-box;">Moral, Legal and Economic Reasons for Preventing Accidents and ill health at Work</li><li fr-original-style="" style="box-sizing: border-box;">Key Terms associated with Risk Assessments in Health and Safety at Work:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Accident</li><li fr-original-style="" style="box-sizing: border-box;">Near Miss</li><li fr-original-style="" style="box-sizing: border-box;">Accident Triangle</li><li fr-original-style="" style="box-sizing: border-box;">Hazard</li><li fr-original-style="" style="box-sizing: border-box;">Risk</li><li fr-original-style="" style="box-sizing: border-box;">Risk Assessment</li><li fr-original-style="" style="box-sizing: border-box;">Suitable and Sufficient</li><li fr-original-style="" style="box-sizing: border-box;">Competence</li></ul></li><li fr-original-style="" style="box-sizing: border-box;">The Role of Risk Assessments in Accident and ill Health Prevention</li><li fr-original-style="" style="box-sizing: border-box;">Legal Requirements for Risk Assessments</li><li fr-original-style="" style="box-sizing: border-box;">Importance of Personal hygiene</li><li fr-original-style="" style="box-sizing: border-box;">Basic Process for Undertaking a Risk Assessment</li><li fr-original-style="" style="box-sizing: border-box;">The Five Steps of a Risk Assessment</li></ul><h3 data-css="tve-u-1724b5d034d" id="isPasted" style="color: rgb(34, 34, 34) !important; box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34) !important;">Benefits of this course:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">In 2020/21, a whopping 1.7 million people suffered from a work-related illness</li><li fr-original-style="" style="box-sizing: border-box;">441,000 of those sustained an injury</li><li fr-original-style="" style="box-sizing: border-box;">142 People, plus 60 members of the public, lost their lives...</li><li fr-original-style="" style="box-sizing: border-box;">The estimated cost of injuries and ill health was &pound;15 billion</li><li fr-original-style="" style="box-sizing: border-box;">28.2 million working days, or 108,045 working years, were lost due to work-related illnesses and injuries</li><li fr-original-style="" style="box-sizing: border-box;">It is an employer&#39;s duty to protect the health, safety and welfare of their employees and other people who might be affected by their business. This includes providing sufficient information, instruction and training of employees, so they can work in a way that does not put themselves or others at risk</li><li fr-original-style="" style="box-sizing: border-box;">Our QA Level 2 Award in Principles of Risk Assessment (RQF) course is ideal for all employees, helping them to create a better understanding of health and safety issues and risk assessments</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;"><h3 fr-original-style="" style="box-sizing: border-box;">Accredited, Ofqual regulated qualification:</h3><div fr-original-style="" style="box-sizing: border-box;"><img src="https://images.cademy.co.uk/pochat-training/d4bd1328-0561-4a59-aef0-01af2e9666f7/original.png" style="width: 300px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left; cursor: pointer; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 300px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left;" fr-original-class="fr-draggable"><span id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">QA Level 2 Award in Principles of Risk Assessment (RQF) training course is a nationally recognised, Ofqual regulated qualification accredited by&nbsp;</span><a href="https://qualsafeawards.org/" style="color: rgb(34, 177, 77); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" target="_blank" fr-original-style=" color: rgb(34, 177, 77);">Qualsafe Awards</a><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">.</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">This means that you can be rest assured that your Principles of Risk Assessment certificate fulfils the legal requirements and is a very good way to make sure you and your employees are trained appropriately.</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">The&nbsp;</span><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Ofqual Register number</strong><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">&nbsp;for this course is&nbsp;</span><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">603/0857/9</strong></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>

QA Level 2 Award In Principles Of Risk Assessment (RQF)
Face to Face: One-day course
Virtual Classroom: Spread over 3 sessions of 2½ hr duration
Don't run risks with the safety of your people - it will cost you a lot more when things start to go wrong...
Risk Assessments are vital for Health and Safety, and vital for the whole process



Course Contents:
Main causes of Work-related Fatalities, Injuries and ill health
Moral, Legal and Economic Reasons for Preventing Accidents and ill health at Work
Key Terms associated with Risk Assessments in Health and Safety at Work:AccidentNear MissAccident TriangleHazardRiskRisk AssessmentSuitable and SufficientCompetence
The Role of Risk Assessments in Accident and ill Health Prevention
Legal Requirements for Risk Assessments
Importance of Personal hygiene
Basic Process for Undertaking a Risk Assessment
The Five Steps of a Risk Assessment
Benefits of this course:
In 2020/21, a whopping 1.7 million people suffered from a work-related illness
441,000 of those sustained an injury
142 People, plus 60 members of the public, lost their lives...
The estimated cost of injuries and ill health was £15 billion
28.2 million working days, or 108,045 working years, were lost due to work-related illnesses and injuries
It is an employer's duty to protect the health, safety and welfare of their employees and other people who might be affected by their business. This includes providing sufficient information, instruction and training of employees, so they can work in a way that does not put themselves or others at risk
Our QA Level 2 Award in Principles of Risk Assessment (RQF) course is ideal for all employees, helping them to create a better understanding of health and safety issues and risk assessments



Accredited, Ofqual regulated qualification:

QA Level 2 Award in Principles of Risk Assessment (RQF) training course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your Principles of Risk Assessment certificate fulfils the legal requirements and is a very good way to make sure you and your employees are trained appropriately.The Ofqual Register number for this course is 603/0857/9



Pochat Training

Risk Assessment

Principles of Risk Assessment

<div style="color: rgb(36, 39, 41); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(36, 39, 41);">The theory assessment provides delegates with the essential knowledge to select, monitor, manage and plan the correct use of Harnesses and lanyards for use in a MEWP.</div><div style="color: rgb(36, 39, 41); box-sizing: border-box;" fr-original-style=" color: rgb(36, 39, 41);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(36, 39, 41); box-sizing: border-box;" fr-original-style=" color: rgb(36, 39, 41);">Delegates successfully completing the e-learning will:<br fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Have an awareness of how to correctly identify and select the appropriate form of personal<br fr-original-style="" style="box-sizing: border-box;">protection against falls from MEWPs.</li><li fr-original-style="" style="box-sizing: border-box;">Have a theoretical awareness only of how to check, use, maintain and store a harness and<br fr-original-style="" style="box-sizing: border-box;">lanyard with manufacturer&rsquo;s instructions.</li><li fr-original-style="" style="box-sizing: border-box;">Have a theoretical awareness of how harnesses and lanyards should be fitted and adjusted.</li></ul></div>

The theory assessment provides delegates with the essential knowledge to select, monitor, manage and plan the correct use of Harnesses and lanyards for use in a MEWP.
Delegates successfully completing the e-learning will:
Have an awareness of how to correctly identify and select the appropriate form of personal
protection against falls from MEWPs.
Have a theoretical awareness only of how to check, use, maintain and store a harness and
lanyard with manufacturer’s instructions.
Have a theoretical awareness of how harnesses and lanyards should be fitted and adjusted.

Kingfisher Access

The theory assessment provides delegates with the essential knowledge to select, monitor, manage and plan the correct use of Harnesses and lanyards for use in a MEWP.

Delegates successfully completing the e-learning will:
Have an awareness of how to correctly identify and select the appropriate form of personal
protection against falls from MEWPs.
Have a theoretical awareness only of how to check, use, maintain and store a harness and
lanyard with manufacturer’s instructions.
Have a theoretical awareness of how harnesses and lanyards should be fitted and adjusted.

IPAF - Harness Awareness 

<h3 fr-original-style="" style="box-sizing: border-box;">Data Protection (GDPR) Foundation Certificate</h3>
<div fr-original-style="" fr-original-class="lcb-body" style="box-sizing: border-box;">
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" fr-original-class="education-description-wrapper" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Data Protection (GDPR) Foundation Certificate is the course for people who need a formal qualification to demonstrate a clear, concise and generic understanding of the General Data Protection Regulation and Data Protection Act 2018, in support of the practical knowledge often acquired in the workplace. It is suitable for the public, private and third sectors and will teach participants essential GDPR skills and sufficient knowledge to assist their organisation toward their data protection implementation and GDPR accountability requirement.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This Foundation Certificate is an internationally recognised qualification, endorsed by TQUK, which is regulated by Ofqual, a UK Government department.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">As the course covers a lot of ground in a short time we recommend attendees who know nothing about data protection to attend our one-hour live, online Introduction to Data Protection and the GDPR.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Note: This course is delivered live, online, using the Zoom platform. &nbsp;It will be delivered 9.30 - 12.30 and 13.30 - 16.30</p>
</div>
</section>
</div>

Data Protection (GDPR) Foundation Certificate
The Data Protection (GDPR) Foundation Certificate is the course for people who need a formal qualification to demonstrate a clear, concise and generic understanding of the General Data Protection Regulation and Data Protection Act 2018, in support of the practical knowledge often acquired in the workplace. It is suitable for the public, private and third sectors and will teach participants essential GDPR skills and sufficient knowledge to assist their organisation toward their data protection implementation and GDPR accountability requirement.
This Foundation Certificate is an internationally recognised qualification, endorsed by TQUK, which is regulated by Ofqual, a UK Government department.
As the course covers a lot of ground in a short time we recommend attendees who know nothing about data protection to attend our one-hour live, online Introduction to Data Protection and the GDPR.
Note: This course is delivered live, online, using the Zoom platform. It will be delivered 9.30 - 12.30 and 13.30 - 16.30

Computer Law Training

Legal

Data Protection

Compliance

GDPR

This Foundation Certificate  is an internationally recognised qualification, endorsed by TQUK, which is regulated by Ofqual, a UK Government department.

Data Protection (GDPR) Foundation Certificate

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"></span></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The COLP role goes beyond just ensuring your firm follows the rules in the SRA Standards and Regulations, it also comes with a personal accountability factor that demands your attention.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Fear not! This 3 hour course will usher you through the intricacies of being a COLP, ensuring you not only meet but excel in your regulatory obligations. &nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">&nbsp;</span><span style="color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">The course will cover:</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><b fr-original-style="" style="box-sizing: border-box;">Navigating the Regulatory Landscape: Understanding the Framework for COLPs<br fr-original-style="" style="box-sizing: border-box;"></b>Dive into the intricate regulatory framework that Compliance Officers for Legal Practice (COLPs) operate under.</li><ol fr-original-style="" style="box-sizing: border-box;"></ol><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><b fr-original-style="" style="box-sizing: border-box;">Shouldering the Responsibility: Unpacking the Duties of a COLP<br fr-original-style="" style="box-sizing: border-box;"></b>Explore the multifaceted responsibilities that come with the role of a COLP.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><b fr-original-style="" style="box-sizing: border-box;">Choosing the Right Leader: Identifying the Ideal COLP Candidate<br fr-original-style="" style="box-sizing: border-box;"></b>Learn the criteria for selecting the most suitable individual to take on the crucial role of COLP.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><b fr-original-style="" style="box-sizing: border-box;">Cracking the Codes: Key Elements of Codes and SRA Principles<br fr-original-style="" style="box-sizing: border-box;"></b>Delve into the essential components of the Codes and SRA Principles that form the backbone of legal compliance.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><b fr-original-style="" style="box-sizing: border-box;">Building a Robust Foundation: Understanding Compliance Systems for All Firms<br fr-original-style="" style="box-sizing: border-box;"></b>Explore the concept of compliance systems, what they entail, and why every firm should have one in place.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><b fr-original-style="" style="box-sizing: border-box;">Reporting Matters: Recognising &#39;Serious&#39; Issues, SRA Enforcement Strategy, and Reporting Protocols<br fr-original-style="" style="box-sizing: border-box;"></b>Uncover the definition of &#39;serious&#39; matters, grasp the SRA Enforcement Strategy, and gain practical insights on making effective reports to the SRA.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><b fr-original-style="" style="box-sizing: border-box;">Paper Trails Matter: Effective Record Keeping, Including Non-material Breaches<br fr-original-style="" style="box-sizing: border-box;"></b>Master the art of comprehensive record-keeping, including strategies for recording non-material breaches, and understand why it&#39;s integral to compliance.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><b fr-original-style="" style="box-sizing: border-box;">Personal Liability: Understanding and Mitigating Risks<br fr-original-style="" style="box-sizing: border-box;"></b>Navigate the landscape of personal liability for COLPs and develop strategies to mitigate associated risks.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><b fr-original-style="" style="box-sizing: border-box;">Staying Ahead: Keeping Abreast of Regulatory Changes and Guidance<br fr-original-style="" style="box-sizing: border-box;"></b>Develop effective strategies for staying up to date with dynamic regulatory changes and evolving guidance.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><b fr-original-style="" style="box-sizing: border-box;">Planning for Compliance: Crafting a Robust Strategy, Assessing Risk, and File Reviewing<br fr-original-style="" style="box-sizing: border-box;"></b>Formulate a comprehensive plan for tackling compliance, including risk assessment, maintaining risk registers, and implementing effective file reviewing.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><b fr-original-style="" style="box-sizing: border-box;">Across the Board: Legal and Regulatory Compliance Areas Every COLP Must Master<br fr-original-style="" style="box-sizing: border-box;"></b>Gain a high-level overview of crucial legal and regulatory compliance areas, including AML, transparency rules, and other pivotal aspects that demand the attention of all COLPs.</li></ul><h2 fr-original-style="" style="box-sizing: border-box;">Target Audience</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This online course is suitable for those new to the COLP role, or those supporting the COLP and for those that would like a refresher of the role and their responsibilities.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"></p><h2 data-key="21" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Resources</h2><p data-key="28" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="29" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="29:0" fr-original-style="" style="box-sizing: border-box;">Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.</span></span></p><p data-key="30" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMkNvdXJzZSUyME5vdGVzJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQ29tcHJlaGVuc2l2ZSUyMGFuZCUyMHVwJTIwdG8lMjBkYXRlJTIwY291cnNlJTIwbm90ZXMlMjB3aWxsJTIwYmUlMjBwcm92aWRlZCUyMHRvJTIwYWxsJTIwZGVsZWdhdGVzJTIwd2hpY2glMjBtYXklMjBiZSUyMHVzZWZ1bCUyMGZvciUyMG9uZ29pbmclMjByZWZlcmVuY2UlMjBvciUyMGNhc2NhZGUlMjB0cmFpbmluZy4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJQbGVhc2UlMjBub3RlJTIwYSUyMHJlY29yZGluZyUyMG9mJTIwdGhlJTIwY291cnNlJTIwd2lsbCUyMCUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTJDJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJub3QlMjAlMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMm1hcmslMjIlMkMlMjJ0eXBlJTIyJTNBJTIyYm9sZCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlN0QlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMmJlJTIwbWFkZSUyMGF2YWlsYWJsZS4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="31" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="31:0" fr-original-style="" style="box-sizing: border-box;">Please note a recording of the course will&nbsp;</span><span data-offset-key="31:1" fr-original-style="" style="box-sizing: border-box;"><strong data-slate-leaf="true" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">not&nbsp;</strong></span><span data-offset-key="31:2" fr-original-style="" style="box-sizing: border-box;">be made available.</span></span></p><h2 data-key="35" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="36" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="36:0" fr-original-style="" style="box-sizing: border-box;">Speaker</span></span></h2><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><a href="https://dglegal.co.uk/the-team/helen-torresi/" 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(0, 180, 205); box-sizing: border-box;" fr-original-style="color: rgb(0, 180, 205);">Helen Torresi, Consultant, DG Legal</span></strong></a></h3><p style="color: rgb(89, 89, 91); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);"><span style="color: rgb(89, 89, 91); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);">Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services.</span></p><p style="color: rgb(89, 89, 91); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);"><span style="color: rgb(89, 89, 91); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);">Helen&rsquo;s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).</span></p>


The COLP role goes beyond just ensuring your firm follows the rules in the SRA Standards and Regulations, it also comes with a personal accountability factor that demands your attention.
Fear not! This 3 hour course will usher you through the intricacies of being a COLP, ensuring you not only meet but excel in your regulatory obligations. 
 The course will cover:
Navigating the Regulatory Landscape: Understanding the Framework for COLPs
Dive into the intricate regulatory framework that Compliance Officers for Legal Practice (COLPs) operate under.
Shouldering the Responsibility: Unpacking the Duties of a COLP
Explore the multifaceted responsibilities that come with the role of a COLP.
Choosing the Right Leader: Identifying the Ideal COLP Candidate
Learn the criteria for selecting the most suitable individual to take on the crucial role of COLP.
Cracking the Codes: Key Elements of Codes and SRA Principles
Delve into the essential components of the Codes and SRA Principles that form the backbone of legal compliance.
Building a Robust Foundation: Understanding Compliance Systems for All Firms
Explore the concept of compliance systems, what they entail, and why every firm should have one in place.
Reporting Matters: Recognising 'Serious' Issues, SRA Enforcement Strategy, and Reporting Protocols
Uncover the definition of 'serious' matters, grasp the SRA Enforcement Strategy, and gain practical insights on making effective reports to the SRA.
Paper Trails Matter: Effective Record Keeping, Including Non-material Breaches
Master the art of comprehensive record-keeping, including strategies for recording non-material breaches, and understand why it's integral to compliance.
Personal Liability: Understanding and Mitigating Risks
Navigate the landscape of personal liability for COLPs and develop strategies to mitigate associated risks.
Staying Ahead: Keeping Abreast of Regulatory Changes and Guidance
Develop effective strategies for staying up to date with dynamic regulatory changes and evolving guidance.
Planning for Compliance: Crafting a Robust Strategy, Assessing Risk, and File Reviewing
Formulate a comprehensive plan for tackling compliance, including risk assessment, maintaining risk registers, and implementing effective file reviewing.
Across the Board: Legal and Regulatory Compliance Areas Every COLP Must Master
Gain a high-level overview of crucial legal and regulatory compliance areas, including AML, transparency rules, and other pivotal aspects that demand the attention of all COLPs.
Target Audience
This online course is suitable for those new to the COLP role, or those supporting the COLP and for those that would like a refresher of the role and their responsibilities.

Resources
Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.
Please note a recording of the course will not be made available.
Speaker
Helen Torresi, Consultant, DG Legal
Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services.
Helen’s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).

DG Legal

Compliance Officer For Legal Practice (COLP) Masterclass Course

General Delegate

A discount is available for delegates attending from firms with a current retainer contract with DG Legal (please contact us by email to admin@dglegal.co.uk for confirmation of eligibility).   If you choose this option and are not eligible, you are still bound to pay the full rate and will be invoiced accordingly.

Retainer Delegate

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyT25lJTIwaG91ciUyMHdlYmluYXIlMjBmb3IlMjBjby1kcml2ZXJzJTIwbG9va2luZyUyMHRvJTIwdGFrZSUyMHRoZSUyMHN0ZXAlMjB1cCUyMGZyb20lMjBzaW5nbGUlMjB2ZW51ZSUyMHN0YWdlJTIwcmFsbGllcyUyMG9yJTIwcm9hZCUyMHJhbGx5aW5nJTIwdG8lMjBtdWx0aS12ZW51ZSUyMHN0YWdlJTIwcmFsbGllcy4lMjBMZWFybiUyMGFib3V0JTIwcm9hZGJvb2tzJTJDJTIwdGltZWNhcmRzJTJDJTIwdGltaW5nJTIwYW5kJTIwcGVuYWx0aWVzJTJDJTIwcGx1cyUyMHJvdXRlJTIwbm90ZXMlMjBhbmQlMjBwYWNlJTIwbm90ZXMlMjBhbmQlMjBtYW55JTIwbW9yZSUyMGhpbnRzJTIwYW5kJTIwdGlwcyUyMHRvJTIwYmVjb21lJTIwYSUyMHN1Y2Nlc3NmdWwlMjBzdGFnZSUyMGNvLWRyaXZlci4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" id="isPasted" fr-original-style="" style="box-sizing: border-box;">One hour webinar for co-drivers looking to take the step up from single venue stage rallies or road rallying to multi-venue stage rallies. Learn about roadbooks, timecards, timing and penalties, plus route notes and pace notes and many more hints and tips to become a successful stage co-driver.</span>


</p>

One hour webinar for co-drivers looking to take the step up from single venue stage rallies or road rallying to multi-venue stage rallies. Learn about roadbooks, timecards, timing and penalties, plus route notes and pace notes and many more hints and tips to become a successful stage co-driver. 

Rally Navigation Training Services

Sports & Fitness

Rally training webinar for co-drivers looking to take the step up from single venue stage rallies or road rallying to multi-venue stage rallies.

Multi Venue Stage Rally Co-Driving

<div>
							  <h5>1-Hour Training </h5>
						   </div>
						   <div></div>
						   
						   <p> This BigQuery Conversion course is for users of SQL. 
						   <br /> We cover the interface and lincencing differences, and additional capabilities. Highlights of BigQuery.
						   <br /> We will cover the general SQL topics ( see our intermediate outline ) and point out where the differences are. 
						   <br /> You would be able to move to this platform easily.
									 
									</p>
								 
								<p></p>
								
							<div>
							  <h5>Topics Covered</h5>
						    </div>
						    <div></div>
							   <ul> 
										<li>Data Types</li>
										<li>Where clauses</li>
										<li>Expressions</li>
										<li>Aggregate, Group by, Having</li>
										<li>Joins, Combine queries</li>
										<li>Date Functions</li>
										<li>CTE Tables, Subqueries, Correlated Subqueries</li>
										<li>Stored Procedures and User defined Functions</li>
								</ul>

SQL For Google Big Query, 1-Hour Training
 This BigQuery Conversion course is for users of SQL. 
We cover the interface and licensing differences and additional capabilities. Highlights of BigQuery. 
 We will cover the general SQL topics ( see our intermediate outline ) and point out where the differences are. 
 You would be able to move to this platform easily. 

SQL For Google BigQuery, Topics Covered
Data Types
Where clauses
Expressions
Aggregate, Group by, Having
Joins, Combine queries
Date Functions
CTE Tables, Subqueries, Correlated Subqueries
Stored Procedures and User defined Functions

Data Engineering

Data Warehouse

 This BigQuery Conversion course is for users of SQL. 
We cover the interface and licensing differences and additional capabilities. 
Highlights of BigQuery. 
 We will cover the general SQL topics ( see our intermediate outline ) and point out where the differences are. 
 You would be able to move to this platform easily. 

58751 Courses

Food Hygiene Rating (Level 5) Approved Online Training

By Twig Services Ltd

'Lockdown Procedure for Schools' Approved Online Training

By Twig Services Ltd

Understanding Your Role Working Within the Care Sector

By Twig Services Ltd

Safeguarding Children Approved Online Training

By Twig Services Ltd

'Person-Centred Care' Approved Online Training

By Twig Services Ltd

Display Screen Equipment (DSE) Awareness Approved Online Training

By Twig Services Ltd

Nurturing 'Good Employee Relations' in the Workplace Approved Online Training

By Twig Services Ltd

End of Life Care Approved Online Training

By Twig Services Ltd

Handling Information Specifically for Care Setting Environments Approved Online Training

By Twig Services Ltd

Duty of Care Approved Online Training

By Twig Services Ltd

Search By Location