Worthing

<p fr-original-style=" color: rgb(var(--color_15));" id="isPasted" style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style=" color: rgb(0, 0, 0);" style="color: rgb(0, 0, 0); box-sizing: border-box;">Our Academy not only offers the complete help of our agency service throughout the whole process of gaining a US college scholarship, but will enable you to gain the best possible scholarship offer to the best possible university &amp; prepare you completely to maximise your US college experience.</span></p><p fr-original-style=" color: rgb(var(--color_15));" style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style=" color: rgb(0, 0, 0);" style="color: rgb(0, 0, 0); box-sizing: border-box;">As a member of our academy you will be a part of our Athletic and Academic preparatory programme where over the 12 month period before going to the US, you will train and learn with our professional team of coaches and tutors. Our programme will not only improve you as a player and a student, but prepare you completely for adapting to the US College culture, allowing you to hit the ground running as soon as you get to the US.</span></p>

Our Academy not only offers the complete help of our agency service throughout the whole process of gaining a US college scholarship, but will enable you to gain the best possible scholarship offer to the best possible university & prepare you completely to maximise your US college experience.
As a member of our academy you will be a part of our Athletic and Academic preparatory programme where over the 12 month period before going to the US, you will train and learn with our professional team of coaches and tutors. Our programme will not only improve you as a player and a student, but prepare you completely for adapting to the US College culture, allowing you to hit the ground running as soon as you get to the US.

Elite U.s. Academy

12 Month complete preparatory programme for the US College experience; includes an Academic, Athletic, and Footballing syllabus.

US College Soccer Preparatory Programme

Gloucester

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">A novice course is aimed at people with little or no previous experience. Course duration is from 3 to 5 days depending on the number of course members.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Call for more details 07968089829</p>

A novice course is aimed at people with little or no previous experience. Course duration is from 3 to 5 days depending on the number of course members.
Call for more details 07968089829

Gl Training Services

Novice Forklift Training
Counter Balance Training
Forklift Training
Crane Training
MEWP Training


On-Site Novice Forklift Course Gloucestershire

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Forklift refresher training is aimed at those who have been previously trained and their skills need updating or refreshing following an incident or accident whilst operating.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">A one day course is for up to 3 candidates per course</p>

Forklift refresher training is aimed at those who have been previously trained and their skills need updating or refreshing following an incident or accident whilst operating.
A one day course is for up to 3 candidates per course

Forklift Training Gloucestershire
Counter Balance Training
Crane Training
MEWP Training

One Day Forklift Refresher Course On-Site

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course is aimed at people who have had prior forklift experience but never received any formal training.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Call for more details 07968089829</p>

This course is aimed at people who have had prior forklift experience but never received any formal training.
Call for more details 07968089829

On-Site Experienced Operator Forklift Course Gloucestershire

Nottinghamshire

<p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);">This course will give candidates a thorough understanding of the relevant operational and safety requirements to those who are required to attach or work with machinery that require the operation of quick hitch systems.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">&nbsp;Candidates will be able to:</p><ul style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><li fr-original-style="" style="box-sizing: border-box;">Understand the industry, the dangers of working in the industry and their responsibilities as a plant operator</li><li fr-original-style="" style="box-sizing: border-box;">Understand the manufacturer&rsquo;s handbook for the particular Quick Hitch to be used</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify the major components of the Quick Hitch and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for Quick Hitch use</li><li fr-original-style="" style="box-sizing: border-box;">Explain the different types of Quick hitch devices</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the designated change over area</li><li fr-original-style="" style="box-sizing: border-box;">Fit and remove attachments safely and efficiently</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate and explain checks for attachment security</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and shut down procedures</li></ul><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry Requirements</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; Candidates must have achieved the relevant CITB Health, Safety &amp; Environment (HS&amp;E) touch-screen-test within 2 years.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Good understanding of spoken and written English.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course &ndash; 1 day</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests &ndash; 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Location</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Customer Site (Training &amp; Testing) &ndash; Site must adhere to NPORS specifications</p>

This course will give candidates a thorough understanding of the relevant operational and safety requirements to those who are required to attach or work with machinery that require the operation of quick hitch systems.
Course Content
 Candidates will be able to:
Understand the industry, the dangers of working in the industry and their responsibilities as a plant operator
Understand the manufacturer’s handbook for the particular Quick Hitch to be used
Locate and identify the major components of the Quick Hitch and explain their functions
Identify and maintain PPE appropriate for Quick Hitch use
Explain the different types of Quick hitch devices
Conduct all pre-operational checks in accordance with manufacturer’s and legislative requirements
Conduct all necessary safety checks at the designated change over area
Fit and remove attachments safely and efficiently
Demonstrate and explain checks for attachment security
Carry out all end of shift and shut down procedures
Entry Requirements
NPORS CSCS – Candidates must have achieved the relevant CITB Health, Safety & Environment (HS&E) touch-screen-test within 2 years.
Good understanding of spoken and written English.
Duration
Novice course – 1 day
Experienced worker tests – 1 day theory and practical assessment
Location
Customer Site (Training & Testing) – Site must adhere to NPORS specifications

Dynamic Training and Assessments Ltd

Construction

CSCS (Construction Skills Certification Scheme)

NPORS

NPORS Quick Hitch Awareness (N034)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">A 2 day Personal Development workshop to improve performance, relationships/teamworking, personal growth and change, Wellbeing and stress management.</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;">* Pre workshop personal diagnostic</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">* Diagnostic debrief.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">*Personal Communication and Behavioural Style - relationships with others.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">*Personal Adaptability, Vision, Drive, Self-esteem, Relationships and Process/Task Skills&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">*Personal Effectiveness - Achievements, Coping day to day, Relationships, growth and Change, Wellbeing.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">* Workshop format includes simulations, discussions and your real world issues.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">* Post workshop personal diagnostic re-,measure quantifies change and improvements.&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>

A 2 day Personal Development workshop to improve performance, relationships/teamworking, personal growth and change, Wellbeing and stress management.

* Pre workshop personal diagnostic
* Diagnostic debrief.
*Personal Communication and Behavioural Style - relationships with others.
*Personal Adaptability, Vision, Drive, Self-esteem, Relationships and Process/Task Skills 
*Personal Effectiveness - Achievements, Coping day to day, Relationships, growth and Change, Wellbeing.
* Workshop format includes simulations, discussions and your real world issues.
* Post workshop personal diagnostic re-,measure quantifies change and improvements. 



Verax International

Team Building

Stress Management

Personal Development

Wellbeing

Personal Productivity

Increase your personal productivity, wellbeing, relationships.

Personal Effectiveness and Productivity (PEP)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Workshop for leaders who want to improve their coaching capability. Includes&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">*Pre-workshop Coaching diagnostic</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">*Two day workshop includes diagnostic report debrief, The coaching Climate, Your coaching Style &amp; Empathy, Coaching Strategies, Coaching Tactics, Coaching Skills. Coaching simulations and your real world coaching relationships analysis, feedback and planning.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">* Impact of coaching on business performance</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">* Post workshop coaching diagnostic re-measure to quantify improvements, changes</p>

Workshop for leaders who want to improve their coaching capability. Includes 
*Pre-workshop Coaching diagnostic
*Two day workshop includes diagnostic report debrief, The coaching Climate, Your coaching Style & Empathy, Coaching Strategies, Coaching Tactics, Coaching Skills. Coaching simulations and your real world coaching relationships analysis, feedback and planning.
* Impact of coaching on business performance
* Post workshop coaching diagnostic re-measure to quantify improvements, changes

Leadership

Coaching Skills

Leadership Skills

Professional Agile Leadership (PAL)

Leadership Development

Coaching workshop for managers who want to use their coaching capabilities to improve the  business performance of their coachees.

Leader As Coach

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2 day Leadership workshop</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">* Pre workshop Leadership diagnostic analyses your current leadership behaviour and impact on business results</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">* Workshop format includes Diagnostic report debrief &amp; planning for change, Leadership Style, Creating and communicating Vision, Goal setting and commitment to achievement, Coaching &amp; Developing Staff, Performance Management, Rewards and Recognition, Teamwork and Motivation, via simulations, discussion and your current real-world issues.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">*Leadership diagnostic re-measure after 6 months to quantify improvement, change etc.</p>

2 day Leadership workshop
* Pre workshop Leadership diagnostic analyses your current leadership behaviour and impact on business results
* Workshop format includes Diagnostic report debrief & planning for change, Leadership Style, Creating and communicating Vision, Goal setting and commitment to achievement, Coaching & Developing Staff, Performance Management, Rewards and Recognition, Teamwork and Motivation, via simulations, discussion and your current real-world issues.
*Leadership diagnostic re-measure after 6 months to quantify improvement, change etc.

Global Leadership

Business Leadership

Project Leadership

Leading for Results

Cardiff

Eyesto Education

English as a Foreign Language (EFL)

English Language Teaching

English Speaking

English for Academic Purposes (EAP)

English as a Second Language

English

Business English

LEVEL UP YOUR ENGLISH SKILLS WITH US.

London

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Start your journey with one of the leading language centres 🏫&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Registration form 👇</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a data-fr-linked="true" href="https://macinter.co/registration-form/" id="isPasted" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">https://macinter.co/registration-form/</a></p>

Start your journey with one of the leading language centres 🏫 
Registration form 👇
https://macinter.co/registration-form/

Mac-International

General English

English courses for all levels are available through Mac International 

English language courses 

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The primary audience for this course is any IT, facilities or data centre professional who works in and around the data centre and has the responsibility to achieve and improve efficiency and environmental sustainability, whilst maintaining the availability and manageability of the data centre.</p>Overview<p>After completion of the course the participant will be able to:<br />Understand the impact of data centres on the environment<br />Describe the various environmental/energy management standards<br />Understand the purpose and goals of the legally binding international treaties on climate change<br />Implement various sustainable performance metrics and how to use them in the data centre environment<br />Manage data centre environmental sustainability using international standards<br />Set up the measurement, monitoring and reporting of energy usage<br />Use power efficiency indicators in a variety of data centre designs<br />Use best practices for energy savings in the electrical infrastructure and in the mechanical (cooling) infrastructure<br />Use best practices for energy savings for the ICT equipment and data storage<br />Understand the importance of water management and waste management<br />Understand the different ways to use sustainable energy in the data centre<br />Get practical tips and innovative ideas to make a data centre more sustainable</p><p>The CDESSÂ© course is aimed at providing knowledge of the standards and guidelines related to environmental sustainability, and how to move your data centre (existing or new) to a more environmentally sustainable design and operations.</p></div><div id="course-pills-2"><h4>Impact of Data Centres on the Environment</h4><ul><li>Predictions in 2010</li><li>Current situation</li><li>Outlook and commitments</li></ul><h4>What is Environmental Sustainability</h4><ul><li>The importance of sustainability</li><li>Senior management commitment</li><li>Environmental sustainability framework</li><li>Sustainability policies</li><li>Performance standards and metrics</li><li>Information policies</li><li>Transparency</li><li>Awareness</li><li>Service charging models</li></ul><h4>Environmental Management</h4><ul><li>Environmental sustainability framework (ISO 14001)</li><li>Standards and guidelines ? ISO 50001 / ISO 30134</li><li>Measurement and categories</li><li>Baselining</li><li>Trend analysis</li><li>Reporting</li></ul><h4>Power EffiÃ°ciency Indicators</h4><ul><li>Various eÃ°fficiency indicators</li><li>Power Usage Effectiveness (PUE)</li><li>PUE measurement levels</li><li>Factors affecting PUE</li><li>Measurement points and intervals</li><li>PUE in mixed source environments</li><li>Measuring PUE in a mixed-use building</li><li>PUE reporting</li><li>Impact of PUE after optimising IT load</li></ul><h4>Electrical Energy Savings (Electrical)</h4><ul><li>Identifying the starting point for saving energy</li><li>Sizing of power</li><li>DC power</li><li>Generators</li><li>UPS systems</li><li>Power Factor (PF)</li><li>Energy savings on lighting</li></ul><h4>Electrical Energy Savings (Mechanical)</h4><ul><li>Energy savings on the cooling infrastructure</li><li>Temperature and humidity setpoints</li><li>Various energy eÃ°cient cooling technologies</li><li>Energy savings on the airflow</li><li>Liquid cooling</li><li>Energy reusage</li><li>PUE, ERE/ERF and Control Volume</li></ul><h4>Electrical Energy Savings (ICT)</h4><ul><li>Procurement</li><li>IT equipment energy eÃ°fficiency</li><li>ITEEsv, SMPE, SMPO</li><li>IT equipment utilisation</li><li>Server virtualisation</li><li>Open compute project</li></ul><h4>Electrical Energy Savings (Data Storage)</h4><ul><li>Data management</li><li>Data storage management</li><li>Data storage equipment effiÃ°ciency</li></ul><h4>Water Management</h4><ul><li>Water Usage Effectiveness (WUE)</li><li>Improving WUE</li><li>Water usage at the power generation source</li><li>Energy Water Intensity Factor (EWIF)</li></ul><h4>Waste Management</h4><ul><li>Waste management policies</li><li>Life-cycle assessment (Cradle to the grave)</li><li>3 R?s for waste management</li><li>Reduce</li><li>Reuse</li><li>Second-hand market</li><li>Recycle</li></ul><h4>Sustainable Energy Usage</h4><ul><li>Sustainable energy sources</li><li>Power purchase agreements</li><li>Energy attribute certificates</li><li>Renewable Energy Factor (REF)</li><li>Matching renewable energy supply and demand</li><li>Sustainable energy storage</li><li>Carbon trading</li></ul><h4>Automated Environmental Management Systems</h4><ul><li>Use of AI and machine learning</li><li>Load migration</li><li>Data Centre Infrastructure Management (DCIM) solutions</li></ul></div>

Duration
5 Days
30 CPD hours
This course is intended for
The primary audience for this course is any IT, facilities or data centre professional who works in and around the data centre and has the responsibility to achieve and improve efficiency and environmental sustainability, whilst maintaining the availability and manageability of the data centre.
Overview
After completion of the course the participant will be able to:
Understand the impact of data centres on the environment
Describe the various environmental/energy management standards
Understand the purpose and goals of the legally binding international treaties on climate change
Implement various sustainable performance metrics and how to use them in the data centre environment
Manage data centre environmental sustainability using international standards
Set up the measurement, monitoring and reporting of energy usage
Use power efficiency indicators in a variety of data centre designs
Use best practices for energy savings in the electrical infrastructure and in the mechanical (cooling) infrastructure
Use best practices for energy savings for the ICT equipment and data storage
Understand the importance of water management and waste management
Understand the different ways to use sustainable energy in the data centre
Get practical tips and innovative ideas to make a data centre more sustainable
The CDESSÂ© course is aimed at providing knowledge of the standards and guidelines related to environmental sustainability, and how to move your data centre (existing or new) to a more environmentally sustainable design and operations.
Impact of Data Centres on the Environment
Predictions in 2010
Current situation
Outlook and commitments
What is Environmental Sustainability
The importance of sustainability
Senior management commitment
Environmental sustainability framework
Sustainability policies
Performance standards and metrics
Information policies
Transparency
Awareness
Service charging models
Environmental Management
Environmental sustainability framework (ISO 14001)
Standards and guidelines ? ISO 50001 / ISO 30134
Measurement and categories
Baselining
Trend analysis
Reporting
Power EffiÃ°ciency Indicators
Various eÃ°fficiency indicators
Power Usage Effectiveness (PUE)
PUE measurement levels
Factors affecting PUE
Measurement points and intervals
PUE in mixed source environments
Measuring PUE in a mixed-use building
PUE reporting
Impact of PUE after optimising IT load
Electrical Energy Savings (Electrical)
Identifying the starting point for saving energy
Sizing of power
DC power
Generators
UPS systems
Power Factor (PF)
Energy savings on lighting
Electrical Energy Savings (Mechanical)
Energy savings on the cooling infrastructure
Temperature and humidity setpoints
Various energy eÃ°cient cooling technologies
Energy savings on the airflow
Liquid cooling
Energy reusage
PUE, ERE/ERF and Control Volume
Electrical Energy Savings (ICT)
Procurement
IT equipment energy eÃ°fficiency
ITEEsv, SMPE, SMPO
IT equipment utilisation
Server virtualisation
Open compute project
Electrical Energy Savings (Data Storage)
Data management
Data storage management
Data storage equipment effiÃ°ciency
Water Management
Water Usage Effectiveness (WUE)
Improving WUE
Water usage at the power generation source
Energy Water Intensity Factor (EWIF)
Waste Management
Waste management policies
Life-cycle assessment (Cradle to the grave)
3 R?s for waste management
Reduce
Reuse
Second-hand market
Recycle
Sustainable Energy Usage
Sustainable energy sources
Power purchase agreements
Energy attribute certificates
Renewable Energy Factor (REF)
Matching renewable energy supply and demand
Sustainable energy storage
Carbon trading
Automated Environmental Management Systems
Use of AI and machine learning
Load migration
Data Centre Infrastructure Management (DCIM) solutions

Nexus Human

Environmental Management System

Leadership in Energy & Environmental Design (LEED)

Certified Energy Manager (CEM)

Service Design Courses (SDC)

Energy Management

Certified in Data Protection (CDP)

Certified Data Centre Environmental Sustainability Specialist (CDESS)

General Admission

<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

<div style="color: rgb(88, 89, 91); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(88, 89, 91);"><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Course Information</h2><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;">This course offers foundational guidance and practical support tailored for individuals operating within Good Manufacturing Practice (GMP) frameworks.</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Explore the fundamental prerequisites of a pharmaceutical quality system (PQS) and delve into the application of quality risk management (QRM) principles, aligning with current regulations and guidance. Gain insights into pivotal aspects such as requirements, roles, and responsibilities, encompassing change control, document management, and key documentation essential for effective implementation of GMP with a focus on regulatory inspections and common findings.</p><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Is this course for you?</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Ideal for professionals engaged in GMP across various sectors, including:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Research and Development (R&amp;D)</li><li fr-original-style="" style="box-sizing: border-box;">Contract Manufacturing Organisations</li><li fr-original-style="" style="box-sizing: border-box;">Manufacturing Units</li><li fr-original-style="" style="box-sizing: border-box;">Quality Control (QC) Laboratories</li><li fr-original-style="" style="box-sizing: border-box;">Auditing Roles.</li></ul><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">What will you learn?</h2><h3 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Event objectives - &nbsp;by the end of the course, delegates shall:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Have an awareness of the basic requirements of GMP</li><li fr-original-style="" style="box-sizing: border-box;">Be aware of UK and EU GMP Rules and Guidance and relevant publications</li><li fr-original-style="" style="box-sizing: border-box;">Understand the roles and responsibilities associated with GMP</li><li fr-original-style="" style="box-sizing: border-box;">Be able to contribute to and maintain quality documentation</li><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of product lifecycle and manufacturing</li><li fr-original-style="" style="box-sizing: border-box;">Understand the requirements of GMP in the QC laboratory context</li><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of risk management and mitigation principles</li><li fr-original-style="" style="box-sizing: border-box;">Understand the need for quality systems and quality assurance activities</li><li fr-original-style="" style="box-sizing: border-box;">Be aware of common regulatory findings.</li></ul><h3 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Learning outcomes: delegates will be able to:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Implement their role within GMP with confidence and knowledge of the principle requirements</li><li fr-original-style="" style="box-sizing: border-box;">Contribute effectively to the GMP quality system and their organisation&rsquo;s compliance</li><li fr-original-style="" style="box-sizing: border-box;">Comprehend where their organisation&rsquo;s activities sit within the larger GMP arena</li><li fr-original-style="" style="box-sizing: border-box;">Know where to seek further information within the published rules and guidance, UK Legislation, European Commission Directives, ICH Guidance and other relevant publications, as well as via the internet.</li></ul></div><div style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);"><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);"><br fr-original-style="" style="box-sizing: border-box;"></h2><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;"><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Tutors</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Tutors will be comprised of (click the photos for biographies):</p><img src="https://www.therqa.com/assets/tutors/17_eyd9QXJ.png" alt="Louise Handy" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"><h3 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Louise Handy</h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Director, Handy Consulting Ltd</p><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);"><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;"><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Programme</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Please note timings may be subject to alteration.</p><h3 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);"><br fr-original-style="" style="box-sizing: border-box;"></h3><h3 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Day 1</h3><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">09:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Introductions and Scope of the Course</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Understand the group requirements and the tutor&#39;s background and experience.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">09:45</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Background and Regulatory Environment</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Setting the scene, understanding the context, key legislation.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">10:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Principles of GMP</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Key points and requirements.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">11:15</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Break</h4><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">11:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Personnel and Responsibilities</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Management and staff, duties and accountabilities.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">12:00</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Overview of GMP Manufacturing</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Basics of the product life cycle.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">12:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Lunch</h4><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">13:15</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Risk Management Workshop</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Practical exploration of risk and mitigation activities.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">14:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">QC Laboratories</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Activities and practicalities.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">15:15</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Break</h4><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">15:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Compliance</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quality Assurance and Self Inspection.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">16:15</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Question Time</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">A chance for questions on the practicalities of GMP.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">16:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Close of Course</h4></div><div style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);"><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);"><br fr-original-style="" style="box-sizing: border-box;"></h2><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;"><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Extra Information</h2><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><ul data-tabs="op6z13-tabs" fr-original-style="" style="box-sizing: border-box;"></ul><div data-tabs-content="example-tabs" style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);"><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">Course Material</h3><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Please note this course will run in UK timezone.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">The advantages of this include:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Ability for delegates to keep material on a mobile device</li><li fr-original-style="" style="box-sizing: border-box;">Ability to review material at any time pre and post course</li><li fr-original-style="" style="box-sizing: border-box;">Environmental benefits &ndash; less paper being used per course Access to an online course group to enhance networking.</li></ul><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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">You will need a stable internet connection, a microphone and a webcam.</strong></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></div></div><div style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);"><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">CPD Points</h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">7 Points</p></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style="color: rgb(88, 89, 91);">&nbsp;</span></p><div style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);"><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">Development Level</h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Learn</p></div>

Course Information
This course offers foundational guidance and practical support tailored for individuals operating within Good Manufacturing Practice (GMP) frameworks.
Explore the fundamental prerequisites of a pharmaceutical quality system (PQS) and delve into the application of quality risk management (QRM) principles, aligning with current regulations and guidance. Gain insights into pivotal aspects such as requirements, roles, and responsibilities, encompassing change control, document management, and key documentation essential for effective implementation of GMP with a focus on regulatory inspections and common findings.
Is this course for you?
Ideal for professionals engaged in GMP across various sectors, including:
Research and Development (R&D)
Contract Manufacturing Organisations
Manufacturing Units
Quality Control (QC) Laboratories
Auditing Roles.
What will you learn?
Event objectives - by the end of the course, delegates shall:
Have an awareness of the basic requirements of GMP
Be aware of UK and EU GMP Rules and Guidance and relevant publications
Understand the roles and responsibilities associated with GMP
Be able to contribute to and maintain quality documentation
Have a basic understanding of product lifecycle and manufacturing
Understand the requirements of GMP in the QC laboratory context
Have a basic understanding of risk management and mitigation principles
Understand the need for quality systems and quality assurance activities
Be aware of common regulatory findings.
Learning outcomes: delegates will be able to:
Implement their role within GMP with confidence and knowledge of the principle requirements
Contribute effectively to the GMP quality system and their organisation’s compliance
Comprehend where their organisation’s activities sit within the larger GMP arena
Know where to seek further information within the published rules and guidance, UK Legislation, European Commission Directives, ICH Guidance and other relevant publications, as well as via the internet.





Tutors
Tutors will be comprised of (click the photos for biographies):

Louise Handy
Director, Handy Consulting Ltd



Programme
Please note timings may be subject to alteration.


Day 1
09:30
Introductions and Scope of the Course
Understand the group requirements and the tutor's background and experience.
09:45
Background and Regulatory Environment
Setting the scene, understanding the context, key legislation.
10:30
Principles of GMP
Key points and requirements.
11:15
Break
11:30
Personnel and Responsibilities
Management and staff, duties and accountabilities.
12:00
Overview of GMP Manufacturing
Basics of the product life cycle.
12:30
Lunch
13:15
Risk Management Workshop
Practical exploration of risk and mitigation activities.
14:30
QC Laboratories
Activities and practicalities.
15:15
Break
15:30
Compliance
Quality Assurance and Self Inspection.
16:15
Question Time
A chance for questions on the practicalities of GMP.
16:30
Close of Course





Extra Information


Course Material


This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event.
Please note this course will run in UK timezone.
The advantages of this include:
Ability for delegates to keep material on a mobile device
Ability to review material at any time pre and post course
Environmental benefits – less paper being used per course Access to an online course group to enhance networking.

You will need a stable internet connection, a microphone and a webcam.


CPD Points
7 Points
 
Development Level
Learn

Research Quality Association

Introduction to Good Manufacturing Practice

RQA Member

Non Member

<p id="isPasted" style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">LOOKING FOR:</strong> ADULT FICTION, NON-FICTION</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">Sian Ellis-Martin joined Blake Friedmann in 2018 and is building a list of fiction and non-fiction at the agency.&nbsp;</span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">With regards to fiction, Sian is looking for commercial, upmarket and accessible literary novels. She always wants to be completely absorbed by the world of the novel, to jump into the character&rsquo;s life and be swept into the narrative as if she&rsquo;s been there all along. She&rsquo;s drawn in by compelling characters and relationships, and loves stories with a mystery or question at the heart of them. She&rsquo;s open to these ideas being explored in a variety of ways, but at the moment, she&rsquo;d particularly like to find an epic love story, a fun, queer rom-com with an unusual setting or pitch, and/or a sweeping family saga. She leans more towards contemporary settings but does enjoy a historical backdrop too.</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: 16px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">In non-fiction, she&rsquo;s looking for narrative non-fiction, history from different perspectives and books that make complicated ideas around things like politics and literature more accessible. Her favourite type of non-fiction book is the one that makes you interested in something or someone you&rsquo;d never thought you would be. She&rsquo;d also love to find cookery and food books too, particularly cuisines that are less visible in the book world, or budget cooking.</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: 16px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">She&rsquo;s not currently taking on YA, children&rsquo;s, fantasy or science fiction projects.</span></p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">Sian would like you to submit a covering letter, 1 - 2 page synopsis and the first three chapters (or 5,000 words) of your manuscript in a single word document.&nbsp;</strong></p><p id="isPasted" style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">(<em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">In addition to the paid sessions, Sian is kindly offering one free session for low income/under-represented writers. Please email <a href="mailto:agent121@iaminprint.co.uk" style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto; font-size: var(--font-size);" fr-original-style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto;">agent121@iaminprint.co.uk</a> to apply, outlining your case for this option which is offered at the&nbsp;</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">discretion of&nbsp;</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Print)</em>.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By booking you understand you need to conduct an internet connection test with<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Pr</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">int</em> prior to the event. You also agree to email your material in one document to reach <em fr-original-style="" style="box-sizing: border-box;">I Am In Print</em> by the stated submission deadline 20and note that <em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Print</em> take no responsibility for the advice received during your agent meeting.</p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">Please prepare to submit your manuscript immediately you book as the submission deadline is now: Monday 8 July 2024</strong></p>

LOOKING FOR: PB, CHAPTER BOOKS, MG, GRAPHIC NOVELS, CHILDREN'S NON-FICTION
Millie van Grutten joined Caroline Sheldon Literary Agency in 2021 and as of early 2024 Caroline Sheldon Literary Agency was acquired by Rogers Coleridge & White. Millie is thrilled to be building the children’s illustrated division at RCW and is actively looking for authors and illustrators of picture books, chapter books, young fiction, graphic novels and is particularly interested in children’s non-fiction presented in any guise. 
Millie loves working collaboratively with authors and illustrators whether it’s brainstorming a title, building a portfolio, trying out new genres and age groups or simply chatting ideas through. She relishes the opportunity to champion the work of illustrators and authors alike and is open to anything from 0-9 whether texts, illustrations or both. She loves anything with strong and engaging characters at its heart, quirky stories, and books that make you laugh and/or books that can make you laugh while you learn…
Apart from the ever enduring and absolute classics like Quentin Blake’s Mrs Armitage, Millie has recently enjoyed Mariajo Ilustrajo’s Lost, Ed Vere’s The Artist, The Secret Beast Club (Robin Birch and Jobe Anderson), Dave Pigeon (Swapna Haddow and Sheena Dempsey), How to Be A Genius Kid (Jim Smith) and anything by Lauren Child.
Among many other talents, Millie represents Swapna Haddow, Zehra Hicks, Sandra Dieckmann, Jobe Anderson, Marilyn Esther Chi, Emma Clarke, Jim Smith, Gabriella Szendrey, Helen and Thomas Docherty.
Millie would like you to submit a covering letter, 1 page synopsis and the opening three chapters (max 5,000 words) of your novel. For picture books please send up to three texts split into 12 spreads each and a covering letter. For non-fiction please supply a cover letter and proposal with up to 5,000 words of your sample text.
Please send EITHER picture books OR another genre, not both in one submission.
(In addition to the paid sessions, Millie is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print). 
Submission Deadline: Wednesday 20 November 2024

I Am In Print

Fiction Writing

TWO SPACES LEFT! 27th November Millie van Grutten #Agent121. Looking for: PICTURE BOOKS / CHAPTER BOOKS / MG / CHILDREN'S NON-FICTION

<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 

Southend on Sea

Droitwich Spa

Portsmouth

Rotherham

Manchester

Leeds

Slough

Bingley

Newport

Peterborough

Milton Keynes 

Paisley

Derby

Birmingham

Luton

Hull

Northampton

Bedford

Liverpool 

Swansea

BASIC to ADVANCED COURSE PACKAGE

Complete 3 courses over 2 full days and receive three qualifications:

Introduction to Phlebotomy Certificate (Nationally Recognised Level 3, Ireland Level 5)
Days 1 and 2: 9.30am – 5.00pm

Advanced Phlebotomy Certificate (Nationally Recognised Level 4, Ireland Level 6)
Day 1: 5.30pm - 8.30pm

Geopace Certificate of Competency (Nationally Recognised Accredited, CPD Practical Skills)
Day 2: 5.30pm - 8.30pm

Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.






Key Facts & Summary:


COURSE 1: INTRODUCTION TO PHLEBOTOMY COURSE - NATIONALLY RECOGNISED AND ACCREDITED VENEPUCTURE COURSE
UK Level Three (Ireland Level Five)
DUALLY ACCREDITED - Open College Network (OCN) and The CPD Certification Service (21 CPD Points)

PART 1 (DAY 1) - 9.30am to 5.00pm
PART 2 (DAY 2) - 9.30am to 5.00pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

A TWO DAY venepuncture course at Level 3. Trains up to the point of live blood draws.

On completion awards a Nationally Recognised and Accredited Certificate in Phlebotomy.

DAY ONE (PART 1) - THEORY
Attend the course location of your choice – starts at 9.30am and finishes approx. 5.00pm

DAY TWO (PART 2) - CLASSROOM
Your classroom tutor will recap on the theory element (above) after which you will begin your practical sessions learning and developing the skills required up to the point of Live Blood Draws.

DOWNLOAD A COURSE ITINERARY HERE



COURSE 2: ADVANCED PHLEBOTOMY COURSE - NATIONALLY RECOGNISED AND ACCREDITED VENEPUCTURE COURSE
UK Level Four (Ireland Level 6)
DUALLY ACCREDITED - Open College Network (OCN) and The CPD Certification Service (14 CPD Points)

PART 1 - THEORY
Complete your theory training online in the comfort of your own home or at work.

PART 2 - CLASSROOM
Follow on from your Day One Theory training, in the evening, from 5.30pm - 8.30pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

Skills and Practical Development:
Covers advanced specialised phlebotomy techniques to give you the leading edge as a phlebotomist. Learn to use a wide range of non-routine equipment.

On completion awards a Nationally Recognised and Accredited Certificate in Advanced Phlebotomy.

DOWNLOAD A COURSE ITINERARY HERE



COURSE 3: ROUTE TO COMPETENCY MASTERCLASS
CPD ACCREDITED - The CPD Certification Service

CLASSROOM
Follow on from your Day Two practical training, in the evening, from 5.30pm - 8.30pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

GEOPACE LIVE BLOOD SESSIONS enabling you to draw human blood under 1-to-1 supervision of your tutor. You will follow a Competency Checklist, signed off by your tutor on completion.

On completion awards a Geopace Certificate of Competency - Nationally Recognised and Accredited Route to Competency - Live Blood Draws Certificate

DOWNLOAD A COURSE ITINERARY HERE




How do I attend?

EITHER -
CLASSROOM OPTION - Attend one of our scheduled classroom locations, completing your Introduction to Phlebotomy Course over 2 days. You will also complete your Advanced Training at the end of the first day and your Competency Training at the end of the second day.

Our Introduction to Phlebotomy and Advanced Phlebotomy Training Kits are supplied at no charge when booking our virtual classroom training option.
If you would like to add one or both of these kits to your classroom training option then these are available to add at time of booking. Our comprehensive training kits each mirror the same equipment and supplies used in the classroom and both include detailed video tutorials, allowing you to continue to practice and "hone" your skills after you have completed your practical training.

OR -

VIRTUAL CLASSROOM OPTION- Complete your theory training online at home or work, then join us for a one day Zoom session to complete your Introduction to Phlebotomy virtual classroom training, followed by your Advanced Training in the evening of the same day. You have the option to add a classroom-based competency session, awarding a CPD Accredited Geopace Certificate of Competency, at time of booking.

Our Virtual Classroom option includes two very comprehensive training kits - one for your introductory course and one for your advanced course. Kits are included at no charge (normally £79.95 each) and are yours to keep and to continue to practice with after you have finished your courses. The equipment and supplies included in your kits are the same as those used if you choose the classroom option.

How do I book?

Choose whether you would like to attend in a classroom or if you would like to complete your training by virtual classroom.
Click on the Classroom - Booking Options or Virtual Classroom - Booking Options buttons below to see all upcoming dates and locations.

Please note - Competency Training
Our Route to Competency Masterclass - Live Blood Sessions can only be completed in a classroom environment. This is included when you book a classroom option. When booking the virtual classroom option you can choose to add this at time of booking. You will receive a voucher code to enable you to book onto any upcoming dates or locations. For most of our two day course we run our competency training at the end of the second day and therefore you should be able to complete your full training programme with us over two days.

If you are completing your training by virtual classroom please see our list of competency training locations here.

If you would like to "mix and match" your training dates and/or locations then please call our admin team on 01525 713377 who will be more than happy to put a training package together for you on dates and / or locations that suit you.

All courses are accredited and are Skills for Health & WHO compliant.

Geopace Training

Allied Health

Allied Health Professions (AHP)

Blood Taking

Healthcare Workers

Venepuncture

Phlebotomist

Phlebotomy

Accredited Phlebotomy

Healthcare

THIS COURSE PACKAGE INCLUDES:
1: INTRODUCTION TO PHLEBOTOMY COURSE (GPT003) - Level 3 (Ireland Level 5)
2: ADVANCED PHLEBOTOMY COURSE (GPT005) - Level 4 (Ireland Level 6)
3: GEOPACE COMPETENCY CERTIFICATE - CPD Certified (optional with Virtual Classroom)

Learn how to take blood ... train as a Phlebotomist

FAST-TRACK YOUR PHLEBOTOMY TRAINING

WITH OUR

COMPLETE TRAINING PACKAGE

20% off -  Multi-Course Discount

    Cover all stages from beginner through to Level 4

    Available as Classroom or Virtual Classroom

    Complete your beginner to advanced training in 2 days

    Awards 2 accredited qualifications - Introduction to Phlebotomy and Advanced Phlebotomy qualifications

    Both courses are dually accredited (OCN & CPD)

    Geopace Certificate of Competency included with classroom attendance or available as an option when booking virtual classroom

    Covers all steps up to live blood draw

    Learn advanced skills and techniques

    Virtual Classroom options include comprehensive Practise@Home Training Kits (yours to keep)

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Phlebotomy Training - Beginner to Advanced PACKAGE

<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;"></span></p><p id="isPasted" 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><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;">The Real Estate Investor course primarily focuses on financial modelling and commercial considerations in the real estate industry across various sectors, geographies, and project types. This course is designed to provide participants with an in-depth understanding of development cash flow modelling, including the representation of risks associated with costs, methods of development financing, and considerations of investment assets.</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;">Apart from modelling office sectors, the course includes modelling of commercial residential development and retail investment assets. The course also expands the geographical investment universe to include modelling of real estate cash flows in a pan-European context, accounting for different indexation rules and methods.</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;">Overall, the Real Estate Investor course provides participants with advanced skills and knowledge required to successfully undertake real estate investment projects in a global context.</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;"><br fr-original-style="" style="box-sizing: border-box;"></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;">Pre-requisite:</strong></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;">Completion of the Real Estate Analyst Course</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you will&hellip;</strong></strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Revise operational models of real estate assets and stress for core income</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Apply modelling techniques to an expanded range of real estate sectors and geographies</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Consider both investment and development cash flows</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understand the sources and use of funds</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn about typical debt covenants and how to incorporate them</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn how to optimise debt structures</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate professionals at any level with exposure to real estate financial models</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, debt structures and return metrics</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Analysts and Modellers who are making the transition from corporate finance to real estate investment and development</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Analysts and Investors</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day One</strong></strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts/premiums to indexation, rent free periods, as well as how to deal with costs during vacancy</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Modelling sector variations in real estate income streams i.e. Office versus industrial, retail &amp; leisure</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Further senior debt covenants</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Advance Rent Function techniques to manage feature rich lease structures</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Two</strong></strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Introduction to development appraisals</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Residual models, site and profit calculations</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Development cash flows versus Investment cash flows</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Introduction to straight line versus S-curve costing</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Phased asset sales in development appraisals</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discounting development cash flows</li><li value="7" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Complimentary return metrics for development appraisals</li><li value="8" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Introduction to development finance</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Files</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><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;">For more information about the Real Estate Investor such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</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;">E - s.musgrave@bayfieldtraining.com</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;">T - 01223 517851</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;">W - </span><a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">www.bayfieldtraining.com</span></a></p>





The Real Estate Investor course primarily focuses on financial modelling and commercial considerations in the real estate industry across various sectors, geographies, and project types. This course is designed to provide participants with an in-depth understanding of development cash flow modelling, including the representation of risks associated with costs, methods of development financing, and considerations of investment assets.
Apart from modelling office sectors, the course includes modelling of commercial residential development and retail investment assets. The course also expands the geographical investment universe to include modelling of real estate cash flows in a pan-European context, accounting for different indexation rules and methods.
Overall, the Real Estate Investor course provides participants with advanced skills and knowledge required to successfully undertake real estate investment projects in a global context.


Pre-requisite:
Completion of the Real Estate Analyst Course


On this course you will…
Revise operational models of real estate assets and stress for core income
Apply modelling techniques to an expanded range of real estate sectors and geographies
Consider both investment and development cash flows
Understand the sources and use of funds
Learn about typical debt covenants and how to incorporate them
Learn how to optimise debt structures


Who will benefit from this course?
Real Estate professionals at any level with exposure to real estate financial models
Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, debt structures and return metrics
Analysts and Modellers who are making the transition from corporate finance to real estate investment and development
Real Estate Analysts and Investors


Course Outline
Day One
Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts/premiums to indexation, rent free periods, as well as how to deal with costs during vacancy
Modelling sector variations in real estate income streams i.e. Office versus industrial, retail & leisure
Further senior debt covenants
Advance Rent Function techniques to manage feature rich lease structures


Day Two
Introduction to development appraisals
Residual models, site and profit calculations
Development cash flows versus Investment cash flows
Introduction to straight line versus S-curve costing
Phased asset sales in development appraisals
Discounting development cash flows
Complimentary return metrics for development appraisals
Introduction to development finance


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Investor such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Bayfield Training

Real Estate Finance

Financial Modelling

Financial Analysis

Microsoft Excel

Financial Risk Management

Professional Development

Continuous Professional Development (CPD)

The Real Estate Investor course primarily focuses on financial modelling and commercial considerations in the real estate industry across various sectors, geographies, and project types.

Real Estate Investor (Advanced Development Cash Flow Modelling in Excel)

<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>Headteachers, DSLs, DSMHLs and SLTs<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;">During this live-online masterclass we will focus on understanding recent developments in the mental health and wellbeing of children in the UK, including looking at the impact of cultural and technological changes over recent years and the impact this is having in schools. We will explore the overlap between the roles of the DSL and the Senior Mental Health Lead in responding to, and preventing incidents, as well as the need for the wider Senior Team involvement in embedding an effective whole-school/school approach.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Delivered 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 current developments and best practice in relation to effective whole school/college approaches to mental health and wellbeing.</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;"><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;">This Masterclass will enable you to:</p>

<ul fr-original-style="" style="box-sizing: border-box;">
<li id="isPasted" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Examine current research and evidence to explore recent developments relating to mental health in schools &amp; colleges; both in relation to pupils/students and to staff.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">To look at the overlap and links between Mental Health and Safeguarding and therefore the work of the DSL and DSMHL and how to ensure effective cooperation and collaboration in the best interests of our pupils and students.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Examine best practice examples to ensure the whole school/college approach to mental health is effective.</li><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">To look at the risk factors for poor mental health relating to your most vulnerable pupils/students, including those with SEND and to understand how these are considered as part of a preventative whole-school/college approach.</span><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div></span><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><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></span></ul>

Who should attend?
Headteachers, DSLs, DSMHLs and SLTs

Overview

During this live-online masterclass we will focus on understanding recent developments in the mental health and wellbeing of children in the UK, including looking at the impact of cultural and technological changes over recent years and the impact this is having in schools. We will explore the overlap between the roles of the DSL and the Senior Mental Health Lead in responding to, and preventing incidents, as well as the need for the wider Senior Team involvement in embedding an effective whole-school/school approach.
Delivered 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 current developments and best practice in relation to effective whole school/college approaches to mental health and wellbeing.

Learning Objectives

This Masterclass will enable you to:
Examine current research and evidence to explore recent developments relating to mental health in schools & colleges; both in relation to pupils/students and to staff.
To look at the overlap and links between Mental Health and Safeguarding and therefore the work of the DSL and DSMHL and how to ensure effective cooperation and collaboration in the best interests of our pupils and students.
Examine best practice examples to ensure the whole school/college approach to mental health is effective.
To look at the risk factors for poor mental health relating to your most vulnerable pupils/students, including those with SEND and to understand how these are considered as part of a preventative whole-school/college approach.
View all testimonials

Brightcore Consultancy

Child Safeguarding

Mental Health

Children's Mental Health

During this live-online masterclass we will focus on understanding recent developments in the mental health and wellbeing of children in the UK, including looking at the impact of cultural and technological changes over recent years and the impact this is having in schools. 

Mental Health in Education Update

<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;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">Mental Health First Aid Refresher 4-hour training sessions</span></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;">Can you remember ALGEE?&nbsp;</strong>Mental Health Action Plan.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Empower Mental Health First Aiders and Champions to maintain their skills with regular Refresher training. Just like physical first aid, we recommend that you refresh your skills every two to three years. (Certificate expires after 3 years). &nbsp;If it&#39;s time to update your skills, book onto an MHFA Refresher course now and feel confident that you are performing your vital role safely.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Revisit the key areas from the full course. Keep up to date with the latest statistics and information.</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">If you are a Mental Health First Aider or MHFA Champion you have skills for life that support you and the people around you. &nbsp;Mental Health First Aid training can be kept up to date through this four hour MHFA Refresher course, which will empower you to: &nbsp;Update your knowledge of mental health and what influences it Update your awareness of current mental health supports available Practise applying the Mental Health First Aid Action Plan. Learning takes place through a mix of presentations, group discussions and workshop activities. We limit numbers to 20 people per course so that the instructor can keep people safe and supported, to get the most from their learning experience with us.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course is for those that have completed the MHFA England Mental Health First Aid or Champion course.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><u fr-original-style="" style="box-sizing: border-box;"><a href="https://www.mindmapswellbeing.com/faq-s/" 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;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">FAQs</span></a></u></p>

Mental Health First Aid Refresher 
4-hour training 
Can you remember ALGEE? Mental Health Action Plan.
Empower Mental Health First Aiders and Champions to maintain their skills with regular Refresher training. Just like physical first aid, we recommend that you refresh your skills every two to three years. (Certificate expires after 3 years). If it's time to update your skills, book onto an MHFA Refresher course now and feel confident that you are performing your vital role safely.
 The MHFA Refresher course takes four hours to complete and will enable learners to: 
Keep their knowledge, awareness, and skills of mental health support current
Update their knowledge of mental health and what influences it
Practice applying the Mental Health First Aid action plan
Once you have completed your MHFA Refresher course, you will be certified for three years. You will also be invited to become or stay a member of MHFA England's Association of Mental Health First Aiders, making sure you have everything you need to feel confident when supporting others. 
I have an existing Level 3 mental health qualification; can I refresh with you? 
As part of the MHFA vision to improve the mental health of the nation, we are now able to accept other Level 3 qualifications from other providers as entry points for this course.

This includes:
FutureQuals Level 3 Award in Mental Health: Workplace First Aider
FAA Level 3 Award in Supervising First Aid for Mental Health (RQF)
For more information on the qualifications, we accept, please contact t info@mindmapswellbeing.com 

FAQs

Mindmaps Wellbeing

Mental Health Awareness

Mental Health First Aid

Approved Training Organisation (ATO)

Health & Wellbeing

Occupational Health & Wellbeing

Accredited Mental Health First Aid

Mental Resilience

Mental Health At Work

Mental Health Nurse

Empower Mental Health First Aiders and Champions to maintain their skills with regular Refresher training. Just like physical first aid, we recommend that you refresh your skills every two to three years. (Certificate expires after 3 years).  If it's time to update your skills, book onto an MHFA Refresher course now and feel confident that you are performing your vital role safely.

MHFA England Refresher 

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Ninety minute webinar on Rally Navigation covering maps and plotting route instructions on to the map. Ideal for competitors on events such as HRCR Clubmans Championship, 12 Cars or Rally of the Tests</p>

Ninety minute webinar on Rally Navigation covering maps and plotting route instructions on to the map. Ideal for competitors on events such as HRCR Clubmans Championship, 12 Cars or Rally of the Tests

Rally Navigation Training Services

Sports & Fitness

Rally Navigation Training Webinar on Maps and Route Plotting, cover common techniques and lots of hints and tips.

2432 Courses in Folkestone

US College Soccer Preparatory Programme

By Elite U.s. Academy

On-Site Novice Forklift Course Gloucestershire

By Gl Training Services

One Day Forklift Refresher Course On-Site

By Gl Training Services

On-Site Experienced Operator Forklift Course Gloucestershire

By Gl Training Services

NPORS Quick Hitch Awareness (N034)

By Dynamic Training and Assessments Ltd

Personal Effectiveness and Productivity (PEP)

By Verax International

Leader As Coach

By Verax International

Leading for Results

By Verax International

LEVEL UP YOUR ENGLISH SKILLS WITH US.

By Eyesto Education

English language courses

By Mac-International

Search By Location