Name: Conflict Management 1 Day Virtual Live Training in Bournemouth
Price: 695 GBP
Availability: InStock

York

<p data-key="1"><span data-key="2"><strong data-slate-leaf="true">Course Description:</strong></span></p>
<p>Communication Skills are the most highly valued skills in today&rsquo;s business environment. Successful professionals who add value to their companies communicate clearly, accurately and effectively. Poor communication skills, on the other hand, restrict even the most talented professionals from getting ahead in the business world.</p>
<p>Communication Skills intensive is a cutting edge training program designed to help today&rsquo;s business professionals take their communication skills and effectiveness to the next level. It immerses you into the most advanced and innovative communication techniques.</p>
<p>You will dive deep into all forms of verbal, non-verbal and written communication, and come out with a developed sense of personal communication style that will help you to connect with, communicate to, and inspire people around you. The ability to communicate information accurately, clearly and as intended, is a vital life skill and something that should not be overlooked. It&rsquo;s never too late to work on your communication skills and by doing so improve your quality of life.</p>
<p><strong>Target Audience:</strong></p>
<p>There is no Eligibility Criteria for this training, anyone can attend this training</p>
<p><strong>Learning Objectives:</strong></p>
<ul>
<li>Script yourself with clear, compelling and well-developed messages that reflect your thinking .</li>
<li>Speak with vision and a logical structure that drives home your points.</li>
<li>Answer questions confidently.</li>
<li>Develop professional relationships and networks.</li>
<li>Communicate with empathy and compassion .</li>
<li>Inspire people by appealing to their emotions.</li>
<li>Move from an informational to an inspirational and action oriented style when creating and delivering presentations.</li>
<li>Integrate effective slides into your presentations.</li>
<li>Become a more powerful leader and communicator by applying effective strategic planning and writing tactics for enhanced writing speed and fluency.</li>
</ul>
<p><strong>Prerequisites:</strong></p>
<p>There are no prerequisites for this course.</p>
<p><strong>Course Materials:</strong></p>
<p>Students will receive a course manual with presentation slides and reference materials.</p>
<p><strong>Examination:</strong></p>
<p>There is no exam.</p>
<p><strong>Technical Requirements:</strong></p>
<p>For eBooks:</p>
<p>Internet for downloading the eBook</p>
<p>Laptop, tablet, Smartphone, eReader (No Kindle)</p>
<p>Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)</p>
<p>eBook download and activation instructions</p>
<p><strong>Agenda:</strong></p>
<ul>
<li>The Science of Effective Human Communication</li>
<li>Frames of Business and Communication</li>
<li>Principles and Strategies for Effective Business Conversations</li>
<li>Art of Giving and Receiving Feedback</li>
<li>How to Listen Effectively and Accurately</li>
<li>Science of Body Language</li>
<li>How to look confident and charismatic</li>
<li>Business Presentation Skills and Strategies</li>
<li>Powerpoint Best Practices</li>
<li>Principles and Techniques for Effective Written Communication</li>
<li>How to write clear, concise and fast at the same time</li>
</ul>

Course Description:
Communication Skills are the most highly valued skills in today’s business environment. Successful professionals who add value to their companies communicate clearly, accurately and effectively. Poor communication skills, on the other hand, restrict even the most talented professionals from getting ahead in the business world.
Communication Skills intensive is a cutting edge training program designed to help today’s business professionals take their communication skills and effectiveness to the next level. It immerses you into the most advanced and innovative communication techniques.
You will dive deep into all forms of verbal, non-verbal and written communication, and come out with a developed sense of personal communication style that will help you to connect with, communicate to, and inspire people around you. The ability to communicate information accurately, clearly and as intended, is a vital life skill and something that should not be overlooked. It’s never too late to work on your communication skills and by doing so improve your quality of life.
Target Audience:
There is no Eligibility Criteria for this training, anyone can attend this training
Learning Objectives:
Script yourself with clear, compelling and well-developed messages that reflect your thinking .
Speak with vision and a logical structure that drives home your points.
Answer questions confidently.
Develop professional relationships and networks.
Communicate with empathy and compassion .
Inspire people by appealing to their emotions.
Move from an informational to an inspirational and action oriented style when creating and delivering presentations.
Integrate effective slides into your presentations.
Become a more powerful leader and communicator by applying effective strategic planning and writing tactics for enhanced writing speed and fluency.
Prerequisites:
There are no prerequisites for this course.
Course Materials:
Students will receive a course manual with presentation slides and reference materials.
Examination:
There is no exam.
Technical Requirements:
For eBooks:
Internet for downloading the eBook
Laptop, tablet, Smartphone, eReader (No Kindle)
Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)
eBook download and activation instructions
Agenda:
The Science of Effective Human Communication
Frames of Business and Communication
Principles and Strategies for Effective Business Conversations
Art of Giving and Receiving Feedback
How to Listen Effectively and Accurately
Science of Body Language
How to look confident and charismatic
Business Presentation Skills and Strategies
Powerpoint Best Practices
Principles and Techniques for Effective Written Communication
How to write clear, concise and fast at the same time

Mangates

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning.

For more queries, reach out to us: info@mangates.com

Communication Skills 1 Day Virtual Live Training in Portsmouth

Standard Fee

Early Bird Fee

Communication Skills 1 Day Virtual Live Training in Bristol

Northampton

Course Description:
Disagreements, differences of opinion and conflicting perspectives on key issues inevitably arise in any context where people are working together.
Research has shown that workplace conflicts can become highly destructive. Negative emotions may be stirred up, poisoning team morale, creating stress and destroying relationships.
Conflict may emerge between managers and their staff, between team members or departments.
Conflict may be expressed openly, but it may also be hidden, in the form of irritation, resentment, loss of morale and lack of commitment. Hidden conflict is easy to miss and therefore can be particularly damaging.
Ultimately, this is likely to have an adverse effect on team and company performance, costing time and money.
It is therefore vital to manage conflict constructively.
As an team member and leader, your ability to deal with and resolve conflicts defines your success in the longer term.
Our one day workshop in Conflict Management and Communication Skills immerses you in the most advanced conflict management tools, strategies and practices applicable today. You will gain hands on practice on proven frameworks, go through simulations and exercises that will train you to be highly effective professional and leader, starting day one.
Course Topics:
1) Science behind workplace conflicts
2) Understanding Human Behaviour
3) Different Personality Types
4) Conflict Management Styles
5) Conflict Management Strategies
6) Workplace Conflicts
7) Conflict Resolution Agreements
8) Working with difficult people
9) Relationship and reputation management
Learning Objectives:
Getting a handle on and gaining insights into your conflict management style through self-assessments (TKI®).
Role playing to practice techniques and new skills in a safe environment.
Proven best practices for approaching conflict management.
Practices for resolving conflict as a third party mediator.
Scientifically validated frameworks on effective communication in stressful situations.
Transferring your learning back to your work environment using job aids, templates and other resources.
How You Will Benefit:
Build trust and credibility with colleagues and team members
Leverage potential conflict situations as opportunities for critical conversations that enhance work relationships.
Gain confidence in holding difficult conversations calmly and assertively.
Manage difficult situations proactively.
Increase your effectiveness in managing conflict.
See growth in your overall performance
Certification:
Once after the training we will provide you the course completion certificate.

Conflict Management 1 Day Virtual Live Training in Leeds

Sutton in Ashfield

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Academy of Beauty Training has been established 15 years and designed to deliver outstanding high-quality training course.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Diode Laser 3-Wave SHR Hair Removal Course </strong>- Alexandrite 755nm &ndash; Diode &ndash; 808nm &amp; Laser Yag 1064nm Painless - Super-Fast Hair Removal - (For all skin Types). This course is designed to train candidates to provide expert &lsquo;Laser Treatments&rsquo; to the highest standards. This enables candidates to insure themselves to work in this industry. &nbsp;The Academy of Beauty Training has been designed to deliver outstanding high-quality Laser (LEVEL 4) training course. Our courses are recognised by leading Industry Insurance Companies. &nbsp;</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong id="isPasted" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">FREE INSURANCE ON ALL COURSES&nbsp;</strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">We also sell Systems which uses the latest technology with huge discounts for our learners.<br fr-original-style="" style="box-sizing: border-box;"></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="background-color: transparent; box-sizing: border-box;" fr-original-style="background-color: transparent;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Also,</strong></span><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;Free 5* Accommodation for learners travelling from afar.</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;">This Course includes the following:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><u fr-original-style="" style="box-sizing: border-box;">Part 1 - Clinical Consideration</u></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Core of Knowledge&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Health &amp; Safety Legislation including kore of knowledge.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Clinical hygiene&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">How do Lasers work</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Establishing a safe environment</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Patient consultation &amp; information</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Medical contra-indications&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Pre-treatment considerations</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Laser Treatment protocols</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Record keeping</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Aftercare procedures</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Effectiveness of treatment</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;"><u fr-original-style="" style="box-sizing: border-box;">Part 2 - Operation of the 3-Wave Diode System</u></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Characteristics of Laser&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Laser treatment parameters &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Wavelengths</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Energy density</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Selective Photothermolysis</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><u fr-original-style="" style="box-sizing: border-box;">Part 3 - Conditions to&nbsp;be&nbsp;treated.</u></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Diode 3 Wave Hair Removal &nbsp;</p>

The Academy of Beauty Training has been established 15 years and designed to deliver outstanding high-quality training course.
Diode Laser 3-Wave SHR Hair Removal Course - Alexandrite 755nm – Diode – 808nm & Laser Yag 1064nm Painless - Super-Fast Hair Removal - (For all skin Types). This course is designed to train candidates to provide expert ‘Laser Treatments’ to the highest standards. This enables candidates to insure themselves to work in this industry. The Academy of Beauty Training has been designed to deliver outstanding high-quality Laser (LEVEL 4) training course. Our courses are recognised by leading Industry Insurance Companies. 
FREE INSURANCE ON ALL COURSES 
We also sell Systems which uses the latest technology with huge discounts for our learners.

Also, Free 5* Accommodation for learners travelling from afar.
This Course includes the following:
 Part 1 - Clinical Consideration
Core of Knowledge 
Health & Safety Legislation including kore of knowledge. 
Clinical hygiene 
How do Lasers work
Establishing a safe environment
Patient consultation & information
Medical contra-indications 
Pre-treatment considerations
Laser Treatment protocols
Record keeping
Aftercare procedures
Effectiveness of treatment
Part 2 - Operation of the 3-Wave Diode System
Characteristics of Laser 
Laser treatment parameters 
Wavelengths
Energy density
Selective Photothermolysis
 Part 3 - Conditions to be treated.
Diode 3 Wave Hair Removal 

Academy Of Beauty Training

Laser Technician

Laser Tattoo Removal

Hair Removal

Laser Hair Removal

Beauty Therapist

Laser Therapy

Diode Laser 3-Wave Painless SHR Hair Removal Course

Diode Laser 3-Wave SHR Super-Fast Hair Removal Course



General Admission

Conflict Management

Conflict Management 1 Day Virtual Live Training in Sheffield

Conflict Management 1 Day Virtual Live Training in Peterborough

Conflict Management 1 Day Virtual Live Training in Plymouth

Conflict Management 1 Day Virtual Live Training in Oxford

Conflict Management 1 Day Virtual Live Training in Maidstone

Conflict Management 1 Day Virtual Live Training in Bournemouth

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

London

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

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

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

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

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

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

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

Session 6:

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

Session 7:

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

Session 8:

SQL Views: Create, alter and drop Views

Session 9:

Inserting rows,
Replacing rows,
Updating rows,
Deleting rows

Session 10:

Session 10: Managing indexes

Session 11:

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

Session 12:

Import data into SQL and Export from SQL

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

PCWorkshops

Database Design & Development

Oracle SQL

Database Programming

Database Administration

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

Oracle SQL Fundamentals, 3 Days

General admission

<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

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

Wellbeing

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.

59580 Courses

Communication Skills 1 Day Virtual Live Training in Portsmouth

By Mangates

Communication Skills 1 Day Virtual Live Training in Bristol

By Mangates

Conflict Management 1 Day Virtual Live Training in Leeds

By Mangates

Diode Laser 3-Wave SHR Super-Fast Hair Removal Course

By Academy Of Beauty Training

Conflict Management 1 Day Virtual Live Training in Sheffield

By Mangates

Conflict Management 1 Day Virtual Live Training in Peterborough

By Mangates

Conflict Management 1 Day Virtual Live Training in Plymouth

By Mangates

Conflict Management 1 Day Virtual Live Training in Oxford

By Mangates

Conflict Management 1 Day Virtual Live Training in Maidstone

By Mangates

Conflict Management 1 Day Virtual Live Training in Bournemouth

By Mangates

Search By Location