Name: Personal Care And Bathing
Price: 18 GBP
Availability: InStock

Consett

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Sensory impairment is an issue that can effect anyone, this course aims to give the learner the knowledge and skills to help their client maintain their independance as much as possible.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">*Causes of impairments</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">*Complications</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">*Carers Role</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">*Associated Risks</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">*Treatments&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>

Sensory impairment is an issue that can effect anyone, this course aims to give the learner the knowledge and skills to help their client maintain their independance as much as possible.
*Causes of impairments
*Complications
*Carers Role
*Associated Risks
*Treatments 



Magpie Training

Healthcare Assistant

Deaf Awareness

Healthcare

Sensory impairment is an issue that can effect anyone, this course aims to give the learner the knowledge and skills to help their client maintain their independance as much as possible.

Sensory Impairment

General Admission

Loughborough

<div>
		

		<div>
			
			<p>Regardless of your computer experience, this class will help you become more aware of technology-related risks and what you can do to protect yourself and your organization from them.</p>
			<div><i></i> 60 minutes</div>
			<div><i></i>  £30.00 incl. VAT</div>
			
			
		</div>
	</div>

	

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

	

    <div>

		
		 
		

		<div></div>

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

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

	
		<h3>Description</h3>
		<p></p><p>Regardless of your computer experience, this class will help you become more aware of technology-related risks and what you can do to protect yourself and your organization from them. This course will help you to:</p>
<p>• Understand security compliance needs and requirements.<br />• Recognize and avoid phishing and other social engineering.<br />• Recognize and avoid viruses, ransomware, and other malware.<br />• Help ensure data security on computers, mobile devices, networks, the Internet, and in the cloud.</p>
<p>In this course, you will use discussions, case studies, and the experiences of your instructor and fellow students to explore the hazards and pitfalls of technology and learn how to use that technology safely and securely.</p>
<p><strong>Objectives:</strong><br />In this course, you will identify many of the common risks involved in using conventional end-user technology, as well as ways to use it safely, to protect yourself from those risks.</p>
<p><strong>You will:</strong><br />• Identify the need for security.<br />• Secure devices like desktops, laptops, smartphones, and more.<br />• Use the Internet securely.</p>
<p></p>
	
		<h3>Modules/Lessons</h3>
		<p></p><h4><span><strong>Lesson 1:</strong> Identifying the Need for Security</span></h4>
<p>Topic A: Identify Security Compliance Requirements<br />Topic B: Recognize Social Engineering and Avoid Phishing and Other Attacks</p>
<h4><span><strong>Lesson 2:</strong> Securing Devices</span></h4>
<p>Topic A: Maintain Physical Security of Devices<br />Topic B: Use Passwords for Security</p>
<p></p>
	
		<h3>Prerequisites</h3>
		<p></p><p>To ensure your success in this course, you should have experience with the basic use of conventional end-user technology, including desktop, laptop, or tablet computers; mobile phones; and basic Internet functions, such as web browsing and email.</p>
<p></p>
	
		<h3>Target Student</h3>
		<p></p><p>This course is designed for you as a non-technical end user of computers, mobile devices, networks, and the Internet, to enable you to use technology more securely to minimize digital risks.</p>
<p>This course is also designed for you to prepare for the Certified CyberSAFE credential. You can obtain your Certified CyberSAFE certificate by completing the Certified CyberSAFE credential process on the CHOICE platform following the course presentation.</p>
<p></p>

Regardless of your computer experience, this class will help you become more aware of technology-related risks and what you can do to protect yourself and your organization from them.
60 minutes £30.00 incl. VAT
Want to run this event in-house? Enquire about running this event in-house 
Interested in attending? Have a suggestion about running this event near you?
Register your interest now
Description

Regardless of your computer experience, this class will help you become more aware of technology-related risks and what you can do to protect yourself and your organization from them. This course will help you to:
• Understand security compliance needs and requirements.
• Recognize and avoid phishing and other social engineering.
• Recognize and avoid viruses, ransomware, and other malware.
• Help ensure data security on computers, mobile devices, networks, the Internet, and in the cloud.
In this course, you will use discussions, case studies, and the experiences of your instructor and fellow students to explore the hazards and pitfalls of technology and learn how to use that technology safely and securely.
Objectives:
In this course, you will identify many of the common risks involved in using conventional end-user technology, as well as ways to use it safely, to protect yourself from those risks.
You will:
• Identify the need for security.
• Secure devices like desktops, laptops, smartphones, and more.
• Use the Internet securely.

Modules/Lessons

Lesson 1: Identifying the Need for Security
Topic A: Identify Security Compliance Requirements
Topic B: Recognize Social Engineering and Avoid Phishing and Other Attacks
Lesson 2: Securing Devices
Topic A: Maintain Physical Security of Devices
Topic B: Use Passwords for Security

Prerequisites

To ensure your success in this course, you should have experience with the basic use of conventional end-user technology, including desktop, laptop, or tablet computers; mobile phones; and basic Internet functions, such as web browsing and email.

Target Student

This course is designed for you as a non-technical end user of computers, mobile devices, networks, and the Internet, to enable you to use technology more securely to minimize digital risks.
This course is also designed for you to prepare for the Certified CyberSAFE credential. You can obtain your Certified CyberSAFE certificate by completing the Certified CyberSAFE credential process on the CHOICE platform following the course presentation.


Mpi Learning - Professional Learning And Development Provider

Regardless of your computer experience, this class will help you become more aware of technology-related risks and what you can do to protect yourself and your organization from them.

Cyber Safe

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);">By the end of the course, learners will have a comprehensive understanding of equality, diversity, and inclusion. The aim of the course is to celebrate diversity, challenge biases, and ensure equal opportunities for all.&nbsp;</span></p>

By the end of the course, learners will have a comprehensive understanding of equality, diversity, and inclusion. The aim of the course is to celebrate diversity, challenge biases, and ensure equal opportunities for all. 

Equality & Diversity

Diversity & Inclusion

The aim of the course is to celebrate diversity, challenge biases, and ensure equal opportunities for all. 

Equality And Diversity 

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course aims to give the learner the knowledge of how to provide a dignified environment, person centred care and how to challange others and lead by example.&nbsp;</p>

This course aims to give the learner the knowledge of how to provide a dignified environment, person centred care and how to challange others and lead by example. 

Privacy

Safeguarding

Dignity in Care 

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Mental health is often an invisible illness that can affect anyone! The aim of this course is to give the learner the knowledge of how to identify the signs, the effects, self help and where to access support.&nbsp;</p>

Mental health is often an invisible illness that can affect anyone! The aim of this course is to give the learner the knowledge of how to identify the signs, the effects, self help and where to access support. 

Mental Health Awareness

Health & Wellbeing

Emotional Wellbeing

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course aims to give the learner the knowledge needed to help prevent the spread of infection within care. Covering pathogens, chain of infection, hygiene and more.</p>

This course aims to give the learner the knowledge needed to help prevent the spread of infection within care. Covering pathogens, chain of infection, hygiene and more.

Health & Hygiene

Infection Prevention & Control

Hand Hygiene

Infection Control

Infection Prevention Control

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This health and safety course aims to give the learner the knowledege on legislation, safety of themselves and others including responsiblities of the worker and the employer regarding health and safety.</p>

This health and safety course aims to give the learner the knowledege on legislation, safety of themselves and others including responsiblities of the worker and the employer regarding health and safety.

Health & Safety

COSHH (Control of Substances Hazardous to Health)

Health and safety course covering legislation for safety within care 

Health and Safety at work 

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The aim of this course is to give the learner the knowledge regarding the purpose of the mental capacity act, who it effects, what the implications are of having a DOLS in place and the priciples of the MCA.</p>

The aim of this course is to give the learner the knowledge regarding the purpose of the mental capacity act, who it effects, what the implications are of having a DOLS in place and the priciples of the MCA.

Care Home Advocate

Mental Capacity

Care

Health & Social Care

Residential Care Homes

Mental capacity Act Dols training course 

Mental Capacity Act, DOLS/ LPS

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em style="color: rgb(95, 99, 104); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(95, 99, 104);">Dysphasia</em><span style="color: rgb(77, 81, 86); box-sizing: border-box;" fr-original-style="color: rgb(77, 81, 86);">&nbsp;is a language disorder. This course aims to cover causes, symptoms, treatments and risk factors.</span></p>

Dysphasia is a language disorder. This course aims to cover causes, symptoms, treatments and risk factors.

Dysphasia is a language disorder. This course aims to cover causes, symptoms, treatments and risk factors.

Dysphasia

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This is an indepth course covering all aspects of personal care, bathing and hygiene within health and social care.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>

This is an indepth course covering all aspects of personal care, bathing and hygiene within health and social care.



Health

Carer

Personal Care And Bathing

London

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

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

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

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

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

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

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

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

<div>   

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

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




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

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

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

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

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

PCWorkshops

Online Course Creation

Programming Fundamentals

Computer Programming

Professional Skills Course (PSC)

Instructor

Python

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

Python EVENINGS Course, Online Instructor-led

General admission

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 16px;">Who should attend?<br fr-original-style="" style="box-sizing: border-box;"></span></strong>All governing boards should designate a governor for mental health and wellbeing to provide strategic support and oversight for the school/colleges Designated Senior Mental Health Lead and the wider SLT. This masterclass is also valuable for all governors, not just the nominated Mental Health and Wellbeing Governor, as all governors have strategic leadership responsibility for ensuring effective whole school / college approaches are in place, as outlined in KCSIE.<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong><br fr-original-style="" style="box-sizing: border-box;"></span></p>

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This expert-led training course will provide you with a comprehensive understanding of the role of the designated governor for mental health and wellbeing. You will gain the skills and confidence n<span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">eeded to help your governing body to ensure that there is a consistent and effective whole-school approach to mental health and wellbeing in place in your school / college.</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;">Delivered live-online by one of our mental health experts, the course will allow you to learn in a live real-time environment, with a range of discussion points, activities, and Q&amp;A session to ensure that you are able to complete the training with a clear understanding of the role of governance as part of the whole school/college approach.</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;">It is based on the following statutory and non-statutory guidance documents:</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;">The DfE&rsquo;s Governance guidance (2024)</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Keeping Children Safe in Education (2024)</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Promoting Children and Young People&#39;s Mental Health and Wellbeing (2021)</li></ul><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Mental Health and Behaviour in Schools (2018)</span><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;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learning Objectives</strong><br fr-original-style="" style="box-sizing: border-box;"></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;">This course will enable you to:</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;">Understand the requirements of the role of the governor for mental health and wellbeing and the importance of prioritising the mental health and wellbeing of both pupils and staff in your setting.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Develop your knowledge of what an effective whole school/college approach to mental health and wellbeing looks like, which includes effective prevention.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understand the role of the Designated Senior Mental Health Lead, and how best to support, scrutinise and challenge them in the development of an effective whole school / college approach.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understand the importance of embedding a culture of wellbeing for staff as well as pupils</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understand the importance of developing an effective curriculum to promote good mental health and wellbeing.</span></li></ul><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><a href="https://www.brightcoreconsultancy.com/brightcore-testimonials" target="_blank" style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); font-weight: bold; text-decoration: none; border-radius: 5px; background-color: rgb(61, 86, 224); border-width: 12px 18px; border-style: solid; border-color: rgb(61, 86, 224); display: inline-block; user-select: auto; box-sizing: border-box; cursor: pointer;" rel="noopener noreferrer" fr-original-style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: #ffffff; font-weight: bold; text-decoration: none; border-radius: 5px; background-color: #3D56E0; border-top: 12px solid #3D56E0; border-bottom: 12px solid #3D56E0; border-right: 18px solid #3D56E0; border-left: 18px solid #3D56E0; display: inline-block;">View all testimonials </a></p>

Who should attend?
All governing boards should designate a governor for mental health and wellbeing to provide strategic support and oversight for the school/colleges Designated Senior Mental Health Lead and the wider SLT. This masterclass is also valuable for all governors, not just the nominated Mental Health and Wellbeing Governor, as all governors have strategic leadership responsibility for ensuring effective whole school / college approaches are in place, as outlined in KCSIE.

Overview

This expert-led training course will provide you with a comprehensive understanding of the role of the designated governor for mental health and wellbeing. You will gain the skills and confidence needed to help your governing body to ensure that there is a consistent and effective whole-school approach to mental health and wellbeing in place in your school / college.
Delivered live-online by one of our mental health experts, the course will allow you to learn in a live real-time environment, with a range of discussion points, activities, and Q&A session to ensure that you are able to complete the training with a clear understanding of the role of governance as part of the whole school/college approach.
It is based on the following statutory and non-statutory guidance documents:
The DfE’s Governance guidance (2024)
Keeping Children Safe in Education (2024)
Promoting Children and Young People's Mental Health and Wellbeing (2021)
Mental Health and Behaviour in Schools (2018)

Learning Objectives

This course will enable you to:
Understand the requirements of the role of the governor for mental health and wellbeing and the importance of prioritising the mental health and wellbeing of both pupils and staff in your setting.
Develop your knowledge of what an effective whole school/college approach to mental health and wellbeing looks like, which includes effective prevention.
Understand the role of the Designated Senior Mental Health Lead, and how best to support, scrutinise and challenge them in the development of an effective whole school / college approach.
Understand the importance of embedding a culture of wellbeing for staff as well as pupils
Understand the importance of developing an effective curriculum to promote good mental health and wellbeing.
View all testimonials

Brightcore Consultancy

Child Safeguarding

This expert-led training course will provide you with a comprehensive understanding of the role of the designated governor for mental health and wellbeing. 

Taking on the role of Mental Health and Wellbeing Governor

Bournemouth

This 18 weeks Virtual Airline Cabin Crew course delivered via Zoom. Lessons scheduled for once a week, evenings from 6:30pm to 9pm. 98% Employment rate after completion of the course.



Virtual Airline Cabin Crew which is also known as Air Hostess, Flight Attendant and Stewardess course – Join your lesson from wherever you are. 
This intensive 18 weeks Virtual Airline Cabin Crew course designed for candidates who wish to:

Travel the world and be paid for it

Work in a friendly, collaborative atmosphere, 5000 metres above the sea level

Build a global network
This glamourous and exciting job requires lots of training and energy. Behind the beautiful smile of each flight attendant, stands a highly trained and skilled person who can deal with unforeseen situations on board. 
98% Employment rate after completion of the course.


How will you learn?
Apart of our traditional class-based tuition, we also offer Virtual Learning courses.
On our Virtual (live stream via Zoom) lessons, we provide the same quality of tuition as in the classroom. You only need a laptop, PC or tablet with either built in (or external) camera and microphone. The virtual platform is very interactive with a sense of real classroom at the Academy. You will study from the comfort of your own home and communicate with your tutor and classmates via video chat (by using your phone or computer camera) and you will receive outstanding tuition, qualification, and certification.
We provide A-Z guidance starting from before and after the course. Your tutor will guide you through the online course to graduation which you will be welcome to attend. What a joy it would be to meet your tutor and classmates in real life!!
You will have:

According to the timetable- 1 lesson per week for 18 consecutive weeks.

Exams and final exam based on which the certificate will be issued.

On successful completion you will hold: Airline Cabin Crew certificate in Current Airline Training Standards and Equipment.

Individual support on the journey from the course to a job placement

Receive constant updates on recruitment and news from Aviation the world

We will enhance your CV

Full support on your job application process

Gain an insight into the airline selection process and final one-to-one interview
What is Flight Attendant?
Flight attendant/Airline Cabin Crew/Stewardess/Air Hostess are the most visible, glamorous jobs of all airline employees. A Flight Attendant is someone whose primary duty is to ensure the safety and comfort of passengers during a flight. They are members of an aircrew team , who operate a commercial, business or even military aircraft while travelling domestically or internationally. 
Flight Attendant benefits:
Getting paid for travelling the world
Lifestyle
Flexible Work Schedules
Meeting Interesting People
Free Food & Accommodation
Excellent Compensation
The uniforms
Working Environment
How to become successful Flight Attendant job candidate?Our Aviation Team understands each candidate who wish to become Airline Cabin Crew or start a career in Aviation.
Airline companies look for individuals who share their values and can act as ambassadors for the company’s brand. Cabin Crew are the face of the airline company which means they deliver a fantastic service that makes airline world famous.
Airline companies prefer candidates with knowledge of Cabin Crew role. Airline companies have selection day or online tests as a first stage of recruitment, after which, they will take a closer look at applicants CV, skills and experience. If you completed Airline Cabin Crew course, your application will stand out and you can get an offer from the first round. 
Student – Cabin Crew Flying Support Group
As a market leading Airline Cabin Crew Training Company with a wealth of experience in Aviation and recruitment, we constantly upgrading our course and going extra nautical mile to guide and support all our students to ensure they can reach their goals. Graduates who are already flying, offer their full support to us and new students. They share an insight of the airline they already fly with, and help new students through the process of joining them at that airline. It gives a flying start to a career to new learners. 

Why London Waterloo Academy?
Top Airline Cabin Crew course provider in London
98% Employment rate after completion of the course
With years of experience in Airline Cabin Crew industry, London Waterloo Academy has been recognised by major TV, radio channels who have invited our Aviation Team for expert advice or interview.
We are recognised by major airline companies in Europe and overseas who have approached London Waterloo Academy to deliver internal cabin crew training, corporate training and to recruit our graduates as a result of their high qualification standards and knowledge.
Our graduates are now flying with Etihad, Saudi Air, Hainan Airlines, Small Planet, British Airways, Qatar, EasyJet, Thomas Cook, Ryanair, Cubana de Aviación, Air France,Titan, Norwegian B737 Short Haul and many more.
The vast global experience of our instructors
This course has been developed in accordance with EASA PART-CC

Working together – Starting a new career isn’t easy and often it can seem like a lonely and impossible process. Our Aviation Department stays behind each learner, supporting every step of the way, we give you all the tools, skills and assistance you need to succeed. Our success, built on the success of our students and a long list of graduates with successful stories.
Course Entry Requirements:
English Language at B2 (CEFR) level or above.
There are no other special requirements for this Airline Cabin Crew course. We will teach you from scratch and support after the course when applying for the job. This course has been developed for all candidates, independent of their background, wishing to start a new career. 
Dates (choose one for your course):
14 March 2024 – 11 July 2024, Thursday classes
10 June 2024 – 7 October 2024, Monday classes
17 September 2024 – 14 January 2025, Tuesday classes
18 November 2024 – 17 March 2025, Monday classes
Course duration – 18 weeks
Classes – once a week 
Lesson Time – 6:30pm to 9pm – GMT (London time)
Course fee – £529 (we offer flexible payment plan and accept weekly instalments)
Registration fee – £300 (includes: examination, Airline Cabin Crew certificate in Current Airline Training Standards and Equipment)








London Waterloo Academy

Flight Attendant

Stewardess

FLIGHT ATTENDANT VIRTUAL VIA ZOOM COURSE, EVENINGS

Registration Fee

Course Fee

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">A standalone 10-week course - 2 hours per week online with daytime and evening options - that will introduce you to the materials, tools, and techniques used in quilling and to Craft4Smiles C.I.C and our tutors. &nbsp; At the end of each session you will have a lovely quilled item to show family and friends or to display on your shelf! You will be told about the other courses we offer so that you can make an informed choice about further learning. Participants in this course often move on to our Introduction to Paper Craft and Mixed Media Course that will introduce you to the basic materials, tools, equipment and techniques used. Experience has shown us that participants for whom English is not their first language, have found that quilling has helped them improve their understanding and spoken English as there is a lot of repetition of basic terms including numbers, colours and directions. Working with someon for whom English is their first language is also helpful.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Programme</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 1: Basic Shapes (1)</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 2: Basic Shapes and Use of a Quilling Comb (2)&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 3: Flower and Butterfly: Picture 8&rdquo; x 10&rdquo;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 4: Making a Shape to Hold Quilled Pieces: Capital Letter</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 6: Basket of Flowers</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 7: Cherry Blossom Box</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 8: 2 x 5&rdquo; x 7&rdquo; Pictures: Duck and Boat</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 11: Pot of Lavender (1)&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 10: Pot of Lavender (2)</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You will receive all the materials and items of equipment needed to complete the course. These are yours to keep:&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Materials and Equipment</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong>Quilling Kit:&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Paper Strips: 39 mm: a variety of colours</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Paper Strips: 39 mm: white</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Board</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Needlemaker&#39;s Wheel of Pins</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Formers x 2&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Comb</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1 Pair Tweezers</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Pokey Tool</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Tool: Short</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Tool: Long</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Scissors</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Glue Applicator</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Book Binders&rsquo; Glue 30 ml</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Black and white 300 gsm card for box and picture</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(65, 65, 65); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(65, 65, 65); font-size: 14px;">Craft4Smiles C.I.C. is crafting community that&nbsp;</span><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">provides accessible high quality creative papercraft and mixed media online programmes for adults. Our courses are social and interactive whether delivered online or in-person. Our aim is to introduce and build crafting skills and the basic skills needed for success in the workplace and at home, including self-confidence, problem solving, communicating in a group, basic maths and English. We teach over 45 different paper craft and mixed media techniques. Each course is carefully constructed to help you develop your crafting skills and knowledge. &nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Crafting and our courses are mindful, taking us away from the day-to-day. Participants have consistently reported improvements in their wellbeing. &nbsp;Anyone who wants to learn new skills can join our programmes. &nbsp;No previous experience of papercrafting or mixed media work is needed. We have delivered courses successfully in Cambridgeshire for 6 1/2 years and have worked with 280 Cambridges residents during this time. 86% of participants state that what we offer has helped to improve their wellbeing. 75% state that it has made a positive difference to their daily lives. &nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Please note that the Cademy calenda/description states that this course is over 13 weeks. This is because the 10 weeks of the course are delivered over 13 weeks, during 3 of which, Craft4Smiles is closed for holidays!&nbsp;</span><br fr-original-style="" style="box-sizing: border-box;"></span></p>

A standalone 10-week course - 2 hours per week online with daytime and evening options - that will introduce you to the materials, tools, and techniques used in quilling and to Craft4Smiles C.I.C and our tutors. At the end of each session you will have a lovely quilled item to show family and friends or to display on your shelf! You will be told about the other courses we offer so that you can make an informed choice about further learning. Participants in this course often move on to our Introduction to Paper Craft and Mixed Media Course that will introduce you to the basic materials, tools, equipment and techniques used. Experience has shown us that participants for whom English is not their first language, have found that quilling has helped them improve their understanding and spoken English as there is a lot of repetition of basic terms including numbers, colours and directions. Working with someon for whom English is their first language is also helpful. 
Programme
Week 1: Basic Shapes (1)
Week 2: Basic Shapes and Use of a Quilling Comb (2) 
Week 3: Flower and Butterfly: Picture 8” x 10”
Week 4: Making a Shape to Hold Quilled Pieces: Capital Letter
Week 6: Basket of Flowers
Week 7: Cherry Blossom Box
Week 8: 2 x 5” x 7” Pictures: Duck and Boat
Week 11: Pot of Lavender (1) 
Week 10: Pot of Lavender (2)
You will receive all the materials and items of equipment needed to complete the course. These are yours to keep: 
Materials and Equipment
 Quilling Kit: 
Quilling Paper Strips: 39 mm: a variety of colours
Quilling Paper Strips: 39 mm: white
Quilling Board
Needlemaker's Wheel of Pins
Quilling Formers x 2 
Quilling Comb
1 Pair Tweezers
Pokey Tool
Quilling Tool: Short
Quilling Tool: Long
Scissors
Glue Applicator
Book Binders’ Glue 30 ml
Black and white 300 gsm card for box and picture
Craft4Smiles C.I.C. is crafting community that provides accessible high quality creative papercraft and mixed media online programmes for adults. Our courses are social and interactive whether delivered online or in-person. Our aim is to introduce and build crafting skills and the basic skills needed for success in the workplace and at home, including self-confidence, problem solving, communicating in a group, basic maths and English. We teach over 45 different paper craft and mixed media techniques. Each course is carefully constructed to help you develop your crafting skills and knowledge. 
Crafting and our courses are mindful, taking us away from the day-to-day. Participants have consistently reported improvements in their wellbeing. Anyone who wants to learn new skills can join our programmes. No previous experience of papercrafting or mixed media work is needed. We have delivered courses successfully in Cambridgeshire for 6 1/2 years and have worked with 280 Cambridges residents during this time. 86% of participants state that what we offer has helped to improve their wellbeing. 75% state that it has made a positive difference to their daily lives. 
Please note that the Cademy calenda/description states that this course is over 13 weeks. This is because the 10 weeks of the course are delivered over 13 weeks, during 3 of which, Craft4Smiles is closed for holidays! 


Craft4Smiles C.I.C. 

A standalone 10-week quilling course - 2 hours per week online with daytime and evening options - that will introduce you to the materials, tools, and techniques used in quilling and to Craft4Smiles C.I.C and our tutors.   At the end of each session you will have a lovely quilled item to show family and friends or to display on your shelf!  All materials and equipment needed will be supplied and are yours to keep. This course is helpful for those for whom English is not their native tongue as there is a lot of repetition of basic terms including numbers, colours and directions.  

Quilling

Craft4Smiles Cademy Launch

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

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

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

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

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

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

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

			 

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

<div>   

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

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




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

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

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

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

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

Tables, Rows and Columns

Indexes, Primary Keys and Foreign Keys

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

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

SQL Arithmetic Operations, Expression Queries

SQL Column Aliases

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

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

The Group By Clause

The Having Clause 
Querying Multiple Tables:
 Joins 

Joining Tables

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

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

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



Database Programming

IT Skills

Data Skills

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

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

This 1-day Driver CPC Periodic Training course focuses on critical areas of Emergency Aid and Security for professional drivers. Designed to meet Driver CPC requirements, this course equips drivers with essential skills for handling emergency situations and enhancing security awareness on the road.
Who Should Attend:
This course is ideal for all professional drivers required to complete Driver CPC Periodic Training to maintain their Driver CPC Licence. It’s tailored to both experienced drivers and those new to the field, providing relevant, up-to-date skills and knowledge.
Learning Objectives:
The aim of this course is to confirm and expand on each driver’s current knowledge and skills, ensuring they are informed about the latest legislation, best practices, and critical safety procedures. This training is designed to enhance drivers’ confidence and preparedness in managing emergencies and maintaining security awareness, helping them navigate the responsibilities of their role effectively.

Course Format: Online 

Join us to reinforce your skills, stay compliant, and improve your on-road safety practices!

Total Compliance 

Driver CPC - 1 Day Periodic 7 Hour Course - Security Training & Emergency Aid

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is intended for people who use PowerPoint for their business communication needs.</p>Overview<p>To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to open and close applications, navigate basic file structures, and manage files and folders.</p><p>This course is intended for those who wish to take advantage of the application for high quality business presentations and reports.</p></div><div id="course-pills-2"><h4>Presentations</h4><ul><li>Create Attractive Presentations from Existing PowerPoint Templates</li><li>Creating Presentations Quickly using Outline to build a Structure</li><li>Incorporating and reusing slides from other presentations into your own</li></ul><h4>Templates and Customization</h4><ul><li>Using Slide Layouts</li><li>Using the Slide Master</li><li>Creating Custom Slide Layout</li></ul><h4>Working with Charts and Tables</h4><ul><li>Create and Modify Tables</li><li>Create Charts and Graphs</li><li>Copying Charts into PowerPoint</li><li>Link Vs Embed</li></ul><h4>Add Visual Elements to a Presentation</h4><ul><li>Create and Modify Shapes </li><li>Add Images </li><li>Create SmartArt to Make Easily Modifiable graphics </li><li>Use SmartArt to Give Dull Text a More Visual Appeal</li></ul><h4>Working with Media and Animation</h4><ul><li>Add Audio to A Presentation</li><li>Add Video to A Presentation</li><li>Add and Customize Animations</li><li>Add and Customize Transitions</li></ul><h4>Preparing to Present</h4><ul><li>Add Notes to A Presentation</li><li>Presenter View And Slide Show Controls</li><li>Create A Custom Slide Show </li><li>Saving and Sharing the Presentation </li><li>Printing Options and Handouts</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Microsoft PowerPoint for the Business User training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Microsoft PowerPoint for the Business User course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Duration
1 Days
6 CPD hours
This course is intended for
This course is intended for people who use PowerPoint for their business communication needs.
Overview
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to open and close applications, navigate basic file structures, and manage files and folders.
This course is intended for those who wish to take advantage of the application for high quality business presentations and reports.
Presentations
Create Attractive Presentations from Existing PowerPoint Templates
Creating Presentations Quickly using Outline to build a Structure
Incorporating and reusing slides from other presentations into your own
Templates and Customization
Using Slide Layouts
Using the Slide Master
Creating Custom Slide Layout
Working with Charts and Tables
Create and Modify Tables
Create Charts and Graphs
Copying Charts into PowerPoint
Link Vs Embed
Add Visual Elements to a Presentation
Create and Modify Shapes
Add Images
Create SmartArt to Make Easily Modifiable graphics
Use SmartArt to Give Dull Text a More Visual Appeal
Working with Media and Animation
Add Audio to A Presentation
Add Video to A Presentation
Add and Customize Animations
Add and Customize Transitions
Preparing to Present
Add Notes to A Presentation
Presenter View And Slide Show Controls
Create A Custom Slide Show
Saving and Sharing the Presentation
Printing Options and Handouts
Additional course details:
Nexus Humans Microsoft PowerPoint for the Business User training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. 

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the Microsoft PowerPoint for the Business User course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.


Nexus Human

Executive Presentation

Office Skills & Productivity

Microsoft Power Platform

Microsoft Powerpoint

Presentation Skills

Microsoft PowerPoint for the Business User

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This 4 week online Course is suitable for complete beginners and improvers who would like to learn to paint in Watercolour.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">Each session is 40 minutes live on Tuesday evening and start at 7.00-7.40pm Via Zoom<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">On this Course you will:<br fr-original-style="" style="box-sizing: border-box;">* learn to prepare your water colour paints and mix colours.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* learn a variety of watercolour techniques including, washes, wet in wet, graded, dry brush Flat Wash, Loose watercolour see photos, we will cover a variety of subjects.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* will be taught live by your tutor online via zoom with step- by -step demonstrations and clear explanations of the various stages.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* Learners will then carry the various tasks alongside the tutor who will be at hand for any questions that you may have.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">This is a 4 week course offered live online via zoom this course rolls on and new dates will be added.</p>
<h2 fr-original-style="" style="box-sizing: border-box;">What&#39;s included in the price?</h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Online Tuition<br fr-original-style="" style="box-sizing: border-box;">Step by step Demonstrations via Zoom in the live class<br fr-original-style="" style="box-sizing: border-box;">Clear explanation from your Tutor<br fr-original-style="" style="box-sizing: border-box;">reference handouts sent via email</p>
<h2 fr-original-style="" style="box-sizing: border-box;">What you will need</h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Starter Kit Available from Tutor - Please email for details<br fr-original-style="" style="box-sizing: border-box;">Watercolour paints - tubes or pans<br fr-original-style="" style="box-sizing: border-box;">Watercolour paper ( Cold Pressed 300 gsm 140lb)<br fr-original-style="" style="box-sizing: border-box;">Round watercolour brushes- size 4 and 6 ( or similar)<br fr-original-style="" style="box-sizing: border-box;">HB graphite pencil to draw image<br fr-original-style="" style="box-sizing: border-box;">Eraser<br fr-original-style="" style="box-sizing: border-box;">Mixing Palette<br fr-original-style="" style="box-sizing: border-box;">2 x jars of clean water<br fr-original-style="" style="box-sizing: border-box;">Kitchen paper<br fr-original-style="" style="box-sizing: border-box;">Hairdryer<br fr-original-style="" style="box-sizing: border-box;">Sketchbook<br fr-original-style="" style="box-sizing: border-box;">Tracing paper</p>
<h2 fr-original-style="" style="box-sizing: border-box;">Suitable for</h2>
<ul fr-original-style="" fr-original-class="fa-ul course-checklists" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Adults</li>
<li fr-original-style="" style="box-sizing: border-box;">Engagement, birthdays &amp; anniversaries</li>
<li fr-original-style="" style="box-sizing: border-box;">Intermediate level</li>
<li fr-original-style="" style="box-sizing: border-box;">Seniors</li>
<li fr-original-style="" style="box-sizing: border-box;">Suitable for beginners</li>
<li fr-original-style="" style="box-sizing: border-box;">Teenagers</li>
<li fr-original-style="" style="box-sizing: border-box;">Wheelchair users</li>
</ul>

This 4 week online Course is suitable for complete beginners and improvers who would like to learn to paint in Watercolour.

Each session is 40 minutes live on Tuesday evening and start at 7.00-7.40pm Via Zoom

On this Course you will:
* learn to prepare your water colour paints and mix colours.

* learn a variety of watercolour techniques including, washes, wet in wet, graded, dry brush Flat Wash, Loose watercolour see photos, we will cover a variety of subjects.

* will be taught live by your tutor online via zoom with step- by -step demonstrations and clear explanations of the various stages.

* Learners will then carry the various tasks alongside the tutor who will be at hand for any questions that you may have.

This is a 4 week course offered live online via zoom this course rolls on and new dates will be added.
What's included in the price?
Online Tuition
Step by step Demonstrations via Zoom in the live class
Clear explanation from your Tutor
reference handouts sent via email
What you will need
Starter Kit Available from Tutor - Please email for details
Watercolour paints - tubes or pans
Watercolour paper ( Cold Pressed 300 gsm 140lb)
Round watercolour brushes- size 4 and 6 ( or similar)
HB graphite pencil to draw image
Eraser
Mixing Palette
2 x jars of clean water
Kitchen paper
Hairdryer
Sketchbook
Tracing paper
Suitable for
Adults
Engagement, birthdays & anniversaries
Intermediate level
Seniors
Suitable for beginners
Teenagers
Wheelchair users

Art By Purnima

Watercolour Painting

Watercolour Techniques for All - 4 week Online Course Tuesday Evenings Via Zoom

Broxburn

<p id="isPasted" style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">C20M03 - Access Control Principles</strong></p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course content<br fr-original-style="" style="box-sizing: border-box;"></strong></p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);">Learners will be introduced to the design, installation, commissioning, and maintenance of Access Control systems. This CPD provides a foundation knowledge of Access Control in relation to the requirements of NCP 109 (NSI) and SS2002 (SSAIB) Third Party Certification Bodies codes of practice, associated standards, and the various legal frameworks within the UK.</p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who should attend?</strong></p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);">All those involved in the specifying, design, installation, commissioning, and maintenance of Access Control Systems including specifiers, property managers, consultants, FM providers, security consultants, security installers.</p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course content</strong></p><ul style="color: rgb(63, 77, 90); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Enquiry</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Risk Assessment<ul style="font-size: initial; box-sizing: border-box;" fr-original-style="font-size: initial;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Operational Requirements</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Initial Design</li></ul></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Quote</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Order</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">System Design Specification</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Installation</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Commissioning</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Handover</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Maintenance</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Assessment</li></ul><p id="isPasted" style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><img src="https://images.cademy.co.uk/88d338d8-7dc4-4054-bf9e-401495774eee/5293624b-3258-4be0-b61f-1d0469f76c49/original.png" style="width: 300px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 300px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto;" fr-original-class="fr-draggable"></p>

C20M03 - Access Control Principles
Course content

Learners will be introduced to the design, installation, commissioning, and maintenance of Access Control systems. This CPD provides a foundation knowledge of Access Control in relation to the requirements of NCP 109 (NSI) and SS2002 (SSAIB) Third-Party Certification Bodies codes of practice, associated standards, and the various legal frameworks within the UK.
Who should attend?
All those involved in the specifying, design, installation, commissioning, and maintenance of Access Control Systems including specifiers, property managers, consultants, FM providers, security consultants, and security installers.
Course content
Enquiry
Risk Assessment
Operational Requirements
Initial Design
Quote
Order
System Design Specification
Installation
Commissioning
Handover
Maintenance
Assessment



Ember Compliance

Professional Development

Engineer

Continuous Professional Development (CPD)

Learners will be introduced to the design, installation, commissioning, and maintenance of Access Control systems. 

C20M03 - Access control systems - Principles (online)

<article id="cincluded">
					<div>
						<h5>SQL Advanced Course Summary.</h5>
					</div>
					<div></div>
					<p>
						
						<br />Practical SQL Advanced Intensive Course
						, exploring the advanced and less commonly used SQL Statements and techniques.
						<br />We also learn Data Definition Language and Data Manipulation Language statements, 
						<br />as well as course automation of queries using T-SQL.
						<br />Hands-on, Practical SQL Advanced Course. 
						<br />PCWorkshops SQL Advanced Course Certificate.
						<br />Max 4 people per course, we keep it personalised. 
						
				  	</p>
	    		</article>

<div id="#">
							<div>
								<h5>Where is the SQL Advanced Course?</h5>
							</div>
							<article>
								<div>
								<ul>  
									 <li><b>Online: </b>Instructor-led.</li>
									 <li><b>Classroom: </b>Request per email.</li> 
								</ul>
								</div>
							</article>
						</div>
						
					   	<div id="#">
							<div>
								<h5>SQL Advanced Course Materials</h5>
							</div>
							<article>
								<div>
								<ul>  
									 <li><b>SQL Coding Examples </b>   </li>
									 <li><b>Manuals and Notes: </b>In-depth reference materials </li>
									 <li><b>Exercises:</b> Practical exercises  </li> 
								</ul>
								</div>
							</article>
						</div>
						 
						
						<div id="#">
							<div>
								<h5>Payment for SQL Course Advanced </h5>
							</div>
							<article>
								<div>
								<ul>
									<li>→  £600, Follow the booking link </li>	 
									<li>Arrange for installments</li>
								</ul>
								</div>
							</article>
						</div>
						
						<div id="#">
							<div>
								<h5>Included with SQL Advanced Course:</h5>
							</div>
							<article>
								<div>
								<ul>
									<li>SQL Advanced Course Certificate on completion.
									</li><li>SQL Advanced Course Manual.
									</li><li>Practical SQL Advanced Course exercises
									</li><li>SQL Code Samples.
									</li><li>After the course, 1 free session for questions.
									</li><li>Max group size, online and in classroom, on this SQL Advanced Course is 4.</li>
								</ul>
								</div>
							</article>
						</div>
						

			   	<div id="cdetails">
					<div>
						<h5>SQL Course Advanced Topics</h5>
					</div>
					<article>
						<div>
							<h5>SQL ADVANCED COURSE TOPICS</h5>
						</div>
						<div></div>
						<div>
					 	<ul>
					    	<li>Database Concepts Revision:
								<br />What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,

								</li><li>SQL Sub-queries:

								<br />·Sub-queries in the WHERE, SELECT, From or Having clauses
								<br />·Using SOME, ALL, ANY and IN clauses in the Where Clause <br />·Self-contained sub-queries
								<br />·Correlated sub-queries
								<br />·Sub-queries with the EXISTS predicate

								</li><li>Derived Tables and CTEs:
								<br />·Using SQL derived tables
								<br />·SQL Common Table Expressions (CTEs)
								<br />·Recursive CTEs

								</li><li>Views:
								<br />Create, alter and drop Views, Indexes

								</li><li>SQL Stored Procedure Basics:
								<br />·Stored Procedure Principles
								<br />·Creating stored procedures
								<br />·Executing stored procedures
								<br />·System stored procedures

								</li><li>Variables:
								<br />·Declaring variables
								<br />·SET versus SELECT
								<br />Parameters and Return Values
								<br />·Passing parameters
								<br />·Default values and WHERE clauses
								<br />·Output parameters
								<br />·Using RETURN
								<br />·Testing Conditions
								<br />·The IF/ELSE statement
								<br />·CASE
								<br />·CHOOSE

								</li><li>Looping:
								<br />·Syntax of SQL WHILE
								<br />·Breaking out of a loop
								<br />·Basic transactions
								<br />·Beginning a transaction
								<br />·Committing/rolling back
								<br />·Deleting and updating
								<br />·Using DELETE and UPDATE
								<br />·Sys.Objects
								<br />·Dropping objects

								</li><li>User defined Functions:
								<br />Table Valued Functions
								<br />·In-line table-valued functions
								<br />·Multi- Statement table-valued functions
								<br />·Limitations of user-defined functions
								<br />Scalar Functions
								<br />·What are scalar functions?
								<br />·Some examples
								<br />·Disadvantages of scalar functions
								<br />·Three advantages

								</li><li>Cursors:
								<br />·Syntax of fetching rows
								<br />·When to use (and when not to)

								</li><li>Triggers:
								<br />·Create or replace triggers

								</li><li>Creating Tables in SQL:

								<br />·Create, alter and drop Tables
								<br />·Inserting values, single rows and multiple rows using queries
								</li><li>Constraints:
								<br />·Not Null, Unique,Default,Check,Primary Key,Foreign Key,Identity / Auto-increments

								</li><li>Sequencing
								</li><li>Indexes

								</li><li>SQL Temporary Tables and Table Variables:
								<br />·Create and use SQL temporary tables
								<br />·Create and use SQL table variables
								<br />·SQL Tables vs. Table Variables

								</li><li>Error-Handling:
								<br />·SQL TRY/CATCH
								<br />·SQL System error functions
								<br />·Customizing SQL error messages
								<br />·@@ error function

								</li><li>Debugging:
								<br />·The SQL Server debugger, Debugging (breakpoints, etc.)
							
							 
							
							</li>
						</ul>
						</div>
					</article>
				</div>

		<div> 
						 

						
				     
	                  <div></div>
 		</div>
	                
				     
				   <div id="booking">
	                  <div>
	                     <h5>BOOK THE SQL Course Advanced COURSE</h5> 
	                  </div>
							 
							 <div id="eventbrite-widget-container-48063008753"></div>




					 
	               </div>
				   <div id="#">
	                  <div>
	                     <h5>About SQL Course Advanced</h5>
	                  </div>



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

SQL Advanced Course 
 
Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. 
We also learn Data Definition Language and Data Manipulation Language statements, 
as well as course automation of queries using T-SQL. 
Hands-on, Practical SQL Advanced Course. 
PCWorkshops SQL Advanced Course Certificate. 
Max 4 people per course; we keep it personalised. 
Where is the SQL Advanced Course?
Online: Instructor-led.
Classroom: Request per email.
SQL Advanced Course Materials
SQL Coding Examples
Manuals and Notes: In-depth reference materials
Exercises: Practical exercises
 
Included with SQL Advanced Course:
SQL Advanced Course Certificate on completion.
SQL Advanced Course Manual.
Practical SQL Advanced Course exercises
SQL Code Samples.
After the course, 1 free session for questions.
Max group size, online and in classroom, on this SQL Advanced Course is 4.
SQL Course Advanced Topics
SQL ADVANCED COURSE TOPICS
Database Concepts Revision: 
What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,
SQL Sub-queries: 
·Sub-queries in the WHERE, SELECT, From or Having clauses 
·Using SOME, ALL, ANY and IN clauses in the Where Clause 
·Self-contained sub-queries 
·Correlated sub-queries 
·Sub-queries with the EXISTS predicate
Derived Tables and CTEs: 
·Using SQL derived tables 
·SQL Common Table Expressions (CTEs) 
·Recursive CTEs
Views: 
Create, alter and drop Views, Indexes
SQL Stored Procedure Basics: 
·Stored Procedure Principles 
·Creating stored procedures 
·Executing stored procedures 
·System stored procedures
Variables: 
·Declaring variables 
·SET versus SELECT 
Parameters and Return Values 
·Passing parameters 
·Default values and WHERE clauses 
·Output parameters 
·Using RETURN 
·Testing Conditions 
·The IF/ELSE statement 
·CASE 
·CHOOSE
Looping: 
·Syntax of SQL WHILE 
·Breaking out of a loop 
·Basic transactions 
·Beginning a transaction 
·Committing/rolling back 
·Deleting and updating 
·Using DELETE and UPDATE 
·Sys.Objects 
·Dropping objects
User defined Functions: 
Table Valued Functions 
·In-line table-valued functions 
·Multi- Statement table-valued functions 
·Limitations of user-defined functions 
Scalar Functions 
·What are scalar functions? 
·Some examples 
·Disadvantages of scalar functions 
·Three advantages
Cursors: 
·Syntax of fetching rows 
·When to use (and when not to)
Triggers: 
·Create or replace triggers
Creating tables in SQL: 
·Create, alter and drop Tables 
·Inserting values, single rows and multiple rows using queries
Constraints: 
·Not Null, Unique,Default, Check,Primary Key,Foreign Key,Identity / Auto-increments
Sequencing
Indexes
SQL Temporary Tables and Table Variables 
·Create and use SQL temporary tables 
·Create and use SQL table variables 
·SQL Tables vs. Table Variables
Error-Handling: 
·SQL TRY/CATCH 
·SQL System error functions 
·Customizing SQL error messages 
·@@ error function
Debugging: 
·The SQL Server debugger, Debugging (breakpoints, etc.)

About SQL Course Advanced
Our experienced trainers are award winners.
More about us
FAQ's
Client Comments

Microsoft SQL Server

SQL Server

Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. 
We also learn Data Definition Language and Data Manipulation Language statements. 
as well as course automation of queries using T-SQL. 
Hands-on, Practical SQL Advanced Course. 
PCWorkshops SQL Advanced Course Certificate. 
Max 4 people per course; we keep it personalised. 

1886 Courses in Birmingham

Sensory Impairment

By Magpie Training

Cyber Safe

By Mpi Learning - Professional Learning And Development Provider

Equality And Diversity

By Magpie Training

Dignity in Care

By Magpie Training

Mental Health Awareness

By Magpie Training

Infection Prevention Control

By Magpie Training

Health and Safety at work

By Magpie Training

Mental Capacity Act, DOLS/ LPS

By Magpie Training

Dysphasia

By Magpie Training

Personal Care And Bathing

By Magpie Training

Search By Location