Name: Workplace Problem Solving Approved Online Training
Price: 29 GBP
Availability: InStock

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Understanding the fundamentals of fire safety is crucial, especially in care and residential home settings where the risk and consequences of fire can be severe. This specialized course offers a concise yet comprehensive overview of fire dynamics, preventive measures, and emergency responses tailored to the unique needs of care facilities. By participating in this training, employees will not only comply with legal requirements but also contribute to creating a secure environment for some of the most vulnerable members of society. The knowledge gained from this course empowers staff with the confidence to act decisively and effectively to protect lives and property in the event of a fire.</p>

Understanding the fundamentals of fire safety is crucial, especially in care and residential home settings where the risk and consequences of fire can be severe. This specialized course offers a concise yet comprehensive overview of fire dynamics, preventive measures, and emergency responses tailored to the unique needs of care facilities. By participating in this training, employees will not only comply with legal requirements but also contribute to creating a secure environment for some of the most vulnerable members of society. The knowledge gained from this course empowers staff with the confidence to act decisively and effectively to protect lives and property in the event of a fire.

Twig Services Ltd

Fire Safety

Fire Safety Awareness

Health & Safety Awareness

Fire Risk Assessment

Residential Care Homes

 Fire Safety Awareness for Care Homes (Basic Level)

General Admission

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Understanding the fundamentals of fire safety is crucial in any workplace setting. This course provides a concise overview of the common causes of fires and outlines essential preventive measures to minimize the risk of fire outbreaks. It also equips individuals with the necessary actions to undertake in the event of a fire, ensuring that they can respond effectively to protect themselves and others. Completing this course not only enhances personal safety skills but also contributes to creating a collective culture of safety and preparedness in the workplace. Such knowledge is invaluable, as it not only helps in preventing property damage and financial loss but, more importantly, in saving lives.</p>

Understanding the fundamentals of fire safety is crucial in any workplace setting. This course provides a concise overview of the common causes of fires and outlines essential preventive measures to minimize the risk of fire outbreaks. It also equips individuals with the necessary actions to undertake in the event of a fire, ensuring that they can respond effectively to protect themselves and others. Completing this course not only enhances personal safety skills but also contributes to creating a collective culture of safety and preparedness in the workplace. Such knowledge is invaluable, as it not only helps in preventing property damage and financial loss but, more importantly, in saving lives.

Firefighter Training

Fire Awareness

Safety Awareness

Fire Safety Awareness Approved Online Training (Basic Level)

<h5 style="color: var(--heading-color); box-sizing: border-box;" id="isPasted" fr-original-style=" color: var(--heading-color);">The Asbestos Awareness course tailored for designers and architects is an essential resource for professionals in the construction and design industry. It provides comprehensive knowledge on identifying asbestos, understanding its uses, and implementing measures to minimize associated risks. The course also delves into the legislative aspects of working with asbestos, ensuring that participants are well-versed in compliance and safety standards. This specialized training is crucial for architects and designers, as it equips them with the information needed to navigate the challenges posed by asbestos in building materials, particularly in older structures that are more likely to contain this hazardous substance.</h5>

The Asbestos Awareness course tailored for designers and architects is an essential resource for professionals in the construction and design industry. It provides comprehensive knowledge on identifying asbestos, understanding its uses, and implementing measures to minimize associated risks. The course also delves into the legislative aspects of working with asbestos, ensuring that participants are well-versed in compliance and safety standards. This specialized training is crucial for architects and designers, as it equips them with the information needed to navigate the challenges posed by asbestos in building materials, particularly in older structures that are more likely to contain this hazardous substance.

Asbestos Awareness

Construction Design & Management (CDM)

Architectural Design

Asbestos Awareness Approved Online Training for Architects

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Asbestos, once a common building material due to its durability and resistance to heat, poses significant health risks, making safety training essential. A comprehensive asbestos safety course not only covers the risks but also educates on recognizing asbestos-containing materials (ACMs), understanding where asbestos may be used, and implementing measures to minimize exposure. The course should also delve into the legal aspects of working with asbestos, ensuring compliance with safety regulations. It&#39;s crucial for workers to identify ACMs and understand proper handling procedures to prevent hazardous exposure. Additionally, such training typically includes information on the correct use of personal protective equipment, decontamination procedures, and safe disposal practices. This knowledge is vital for maintaining a safe working environment and protecting workers&#39; health when dealing with this hazardous substance.</p>

Asbestos, once a common building material due to its durability and resistance to heat, poses significant health risks, making safety training essential. A comprehensive asbestos safety course not only covers the risks but also educates on recognizing asbestos-containing materials (ACMs), understanding where asbestos may be used, and implementing measures to minimize exposure. The course should also delve into the legal aspects of working with asbestos, ensuring compliance with safety regulations. It's crucial for workers to identify ACMs and understand proper handling procedures to prevent hazardous exposure. Additionally, such training typically includes information on the correct use of personal protective equipment, decontamination procedures, and safe disposal practices. This knowledge is vital for maintaining a safe working environment and protecting workers' health when dealing with this hazardous substance.

Construction Safety

Workplace Health & Safety

Asbestos Awareness Approved Online Training

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Attention-Deficit/Hyperactivity Disorder (ADHD) is a neurodevelopmental disorder that affects both children and adults. It is characterized by a pattern of inattention, hyperactivity, and impulsivity that is more frequent and severe than typically observed in individuals at a comparable level of development. ADHD can present challenges in daily life, affecting school, work, and personal relationships. However, with proper diagnosis and a combination of treatments such as medication, psychotherapy, education or training, and support, individuals with ADHD can lead productive lives. Strategies for managing ADHD include organizational support, developing routines, and sometimes making lifestyle changes that can help reduce symptoms and improve functioning.</p>

Attention-Deficit/Hyperactivity Disorder (ADHD) is a neurodevelopmental disorder that affects both children and adults. It is characterized by a pattern of inattention, hyperactivity, and impulsivity that is more frequent and severe than typically observed in individuals at a comparable level of development. ADHD can present challenges in daily life, affecting school, work, and personal relationships. However, with proper diagnosis and a combination of treatments such as medication, psychotherapy, education or training, and support, individuals with ADHD can lead productive lives. Strategies for managing ADHD include organizational support, developing routines, and sometimes making lifestyle changes that can help reduce symptoms and improve functioning.

Mental Health Awareness

Neurodevelopmental Disabilities

Behaviour Management

ADHD Awareness Approved Online Training

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course on abrasive wheels is a critical resource for individuals who utilize or oversee the use of abrasive wheels in their professional activities. It delves into the various types of abrasive wheels, emphasizing the importance of selecting the appropriate wheel for specific tasks to ensure both efficiency and safety. The curriculum also highlights the significance of adhering to stringent safety protocols during the operation of abrasive wheels, which includes proper handling, storage, and maintenance. Understanding the markings and specifications on abrasive wheels is essential for compliance with safety standards and for preventing workplace accidents. Additionally, the course underscores the legal obligations of both employers and employees in maintaining a safe working environment. For those interested in such a course, options are available that provide comprehensive training along with accreditation, such as the CPD accredited course which offers a printable certificate upon completion.</p>

The course on abrasive wheels is a critical resource for individuals who utilize or oversee the use of abrasive wheels in their professional activities. It delves into the various types of abrasive wheels, emphasizing the importance of selecting the appropriate wheel for specific tasks to ensure both efficiency and safety. The curriculum also highlights the significance of adhering to stringent safety protocols during the operation of abrasive wheels, which includes proper handling, storage, and maintenance. Understanding the markings and specifications on abrasive wheels is essential for compliance with safety standards and for preventing workplace accidents. Additionally, the course underscores the legal obligations of both employers and employees in maintaining a safe working environment. For those interested in such a course, options are available that provide comprehensive training along with accreditation, such as the CPD accredited course which offers a printable certificate upon completion.

Online Course Creation

Compliance & Safety

Abrasive Wheel

Abrasive Wheels Approved Online Training

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Creating a positive mental health culture in the workplace is essential for fostering a supportive environment that can enhance employee well-being and productivity. This course will provide valuable insights into identifying stressors, implementing effective stress management strategies, and promoting mental health awareness among staff. Participants will learn how to recognize signs of mental health issues, support employees facing such challenges, and develop policies that prioritize mental health. By the end of the course, attendees will be equipped with the tools to build a more resilient and mentally healthy workforce.</p>

Creating a positive mental health culture in the workplace is essential for fostering a supportive environment that can enhance employee well-being and productivity. This course will provide valuable insights into identifying stressors, implementing effective stress management strategies, and promoting mental health awareness among staff. Participants will learn how to recognize signs of mental health issues, support employees facing such challenges, and develop policies that prioritize mental health. By the end of the course, attendees will be equipped with the tools to build a more resilient and mentally healthy workforce.

Clinical Supervision

Stress Management

Occupational Health & Wellbeing

Mental Health At Work

Mental Health Supervision at Work Approved Online Training

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Understanding sexual harassment is crucial in creating a safe and respectful workplace. This course aims to provide a comprehensive overview, beginning with a definition of sexual harassment and an explanation of the protections afforded by employment and criminal law. It will delve into workplace statistics to illustrate the prevalence and gravity of the issue, highlighting the often inadequate management responses to reported concerns. The course will also cover the appropriate handling of allegations, emphasizing the necessity of clear and robust policies, and the critical role that line managers play in addressing and resolving such situations. By educating on these key aspects, the course seeks to empower individuals to foster a work environment that is free from harassment and conducive to productivity and well-being.</p>

Understanding sexual harassment is crucial in creating a safe and respectful workplace. This course aims to provide a comprehensive overview, beginning with a definition of sexual harassment and an explanation of the protections afforded by employment and criminal law. It will delve into workplace statistics to illustrate the prevalence and gravity of the issue, highlighting the often inadequate management responses to reported concerns. The course will also cover the appropriate handling of allegations, emphasizing the necessity of clear and robust policies, and the critical role that line managers play in addressing and resolving such situations. By educating on these key aspects, the course seeks to empower individuals to foster a work environment that is free from harassment and conducive to productivity and well-being.

Complaint Handling

Sexual Harassment

HR (Human Resources)

Employment Law

Workplace Communication

Sexual Harassment in the Workplace Environment Approved Online Training

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Project management is a critical skill set that is applicable in nearly every industry. A course on this topic typically begins with the fundamentals, such as understanding the project lifecycle, from initiation and planning to execution and closure. It also delves into various methodologies like Agile, Scrum, and Waterfall, each with its own set of tools and techniques. For instance, Gantt charts and Kanban boards are popular for tracking progress, while risk management frameworks help anticipate and mitigate potential issues. Effective communication strategies, stakeholder analysis, and resource allocation are also key components that can enhance your ability to lead projects successfully. By mastering these concepts, you can significantly improve your project management skills and increase the chances of your project&#39;s success.</p>

Project management is a critical skill set that is applicable in nearly every industry. A course on this topic typically begins with the fundamentals, such as understanding the project lifecycle, from initiation and planning to execution and closure. It also delves into various methodologies like Agile, Scrum, and Waterfall, each with its own set of tools and techniques. For instance, Gantt charts and Kanban boards are popular for tracking progress, while risk management frameworks help anticipate and mitigate potential issues. Effective communication strategies, stakeholder analysis, and resource allocation are also key components that can enhance your ability to lead projects successfully. By mastering these concepts, you can significantly improve your project management skills and increase the chances of your project's success.

Stakeholder Management

Project Management

Project Management Approved Online Training

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Workplace challenges are a common occurrence, and addressing them effectively is crucial for maintaining a productive and positive work environment. This course is designed to equip individuals with the skills to identify various workplace issues, ranging from communication breakdowns and team conflicts to inefficiency and compliance concerns. By understanding the root causes of these problems, participants can learn strategies for managing and resolving them. The course also emphasizes the importance of proactive measures to prevent issues from arising, ensuring that the workplace remains a dynamic and supportive setting for all employees.</p>

Workplace challenges are a common occurrence, and addressing them effectively is crucial for maintaining a productive and positive work environment. This course is designed to equip individuals with the skills to identify various workplace issues, ranging from communication breakdowns and team conflicts to inefficiency and compliance concerns. By understanding the root causes of these problems, participants can learn strategies for managing and resolving them. The course also emphasizes the importance of proactive measures to prevent issues from arising, ensuring that the workplace remains a dynamic and supportive setting for all employees.

Conflict Resolution

Team Building

Problem Solving

Workplace Problem Solving 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
  



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. 

58750 Courses

Fire Safety Awareness for Care Homes (Basic Level)

By Twig Services Ltd

Fire Safety Awareness Approved Online Training (Basic Level)

By Twig Services Ltd

Asbestos Awareness Approved Online Training for Architects

By Twig Services Ltd

Asbestos Awareness Approved Online Training

By Twig Services Ltd

ADHD Awareness Approved Online Training

By Twig Services Ltd

Abrasive Wheels Approved Online Training

By Twig Services Ltd

Mental Health Supervision at Work Approved Online Training

By Twig Services Ltd

Sexual Harassment in the Workplace Environment Approved Online Training

By Twig Services Ltd

Project Management Approved Online Training

By Twig Services Ltd

Workplace Problem Solving Approved Online Training

By Twig Services Ltd

Search By Location