Name: Numeracy Skills for Work - Multiply Workshop
Availability: InStock

Lewes

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We offer every child two trial sessions with Lilley Lovett Theatre Group to give them time to settle and decide whether they would like to become a full Lilley Lovett member.&nbsp;</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Weekly sessions run during term time at the Laughton Parish Hall, East Sussex, BN8 6AH</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Monday 3.15pm &ndash; 4.15pm &lsquo;Little Lilley Lovetts&rsquo; for children in reception and year 1</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Monday 4.30pm &ndash; 6.30pm for school years 3 to 6</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Tuesday 3.15pm &ndash; 4.45pm for school year 2</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Saturday 10.00am &ndash; 1.00pm for school years 7+</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To check availability and book trial sessions for your child please visit our website <a data-fr-linked="true" href="https://lilley-lovett.org/contact/" id="isPasted" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">https://lilley-lovett.org/contact/</a></p>

We offer every child two trial sessions with Lilley Lovett Theatre Group to give them time to settle and decide whether they would like to become a full Lilley Lovett member. 
Weekly sessions run during term time at the Laughton Parish Hall, East Sussex, BN8 6AH
Monday 3.15pm – 4.15pm ‘Little Lilley Lovetts’ for children in reception and year 1
Monday 4.30pm – 6.30pm for school years 3 to 6
Tuesday 3.15pm – 4.45pm for school year 2
Saturday 10.00am – 1.00pm for school years 7+
To check availability and book trial sessions for your child please visit our website https://lilley-lovett.org/contact/

Lilley Lovett Theatre Group

Taster session with Lilley Lovett Theatre Group

General Admission

London

An opportunity for boys & girls aged 5- 17 years to expand their knowledge & study various topics of Islam with our qualified & experienced teachers residing in the UK. The goal is to showcase to our youth to strive to live and act by the Qur'an & Sunnah.

Ilmul Atfaal Online

Islamic Studies Classes

Hove

<p>This course leads to the Cambridge International English Level Testing System examination. IELTS is often required for those who wish to attend a course in tertiary education in Britain, Australia, New Zealand, the USA, Canada and some institutions in Singapore.</p>
<p>The course is for students with a higher level of English who are preparing for the academic IELTS examination.</p>
<p>The course consists of 15 hours of lessons a week. It is taught in the context of the four exam papers &ndash; Reading, Writing, Listening and Speaking.</p>
<p>Ideally students would be at Upper-intermediate level but, as IELTS is a multi-level exam, students can join if they are Intermediate level and are committed to working towards the exam.</p>
<h3>By the end of the IELTS &ndash; Exam preparation course you will be able to:</h3>
<ul>
<li>interpret and describe graphs in writing</li>
<li>write a discursive or opinion essay</li>
<li>read and interpret academic texts</li>
<li>answer comprehension questions on written texts as found in the IELTS examination</li>
<li>identify specific information and infer point of view in written texts</li>
<li>take part in discussions and practise the speaking skills required in the IELTS examination</li>
<li>perform with confidence in the oral component of the examination</li>
<li>take accurate notes from a spoken text or dialogue</li>
<li>listen to a variety of spoken text types of the kind used in IELTS examination.</li>
</ul>
<p>If you want to study at university in the UK, you will almost certainly need to take the IELTS exam in order to show that you have the necessary level of English, you may also need to take the exam to show your level of English if you intend to live permanently in an English speaking country.</p>
<p>On average our students achieve 6.5 in IELTS exams (mean 6.26)</p>

This course leads to the Cambridge International English Level Testing System examination. IELTS is often required for those who wish to attend a course in tertiary education in Britain, Australia, New Zealand, the USA, Canada and some institutions in Singapore.
The course is for students with a higher level of English who are preparing for the academic IELTS examination.
The course consists of 15 hours of lessons a week. It is taught in the context of the four exam papers – Reading, Writing, Listening and Speaking.
Ideally students would be at Upper-intermediate level but, as IELTS is a multi-level exam, students can join if they are Intermediate level and are committed to working towards the exam.
By the end of the IELTS – Exam preparation course you will be able to:
interpret and describe graphs in writing
write a discursive or opinion essay
read and interpret academic texts
answer comprehension questions on written texts as found in the IELTS examination
identify specific information and infer point of view in written texts
take part in discussions and practise the speaking skills required in the IELTS examination
perform with confidence in the oral component of the examination
take accurate notes from a spoken text or dialogue
listen to a variety of spoken text types of the kind used in IELTS examination.
If you want to study at university in the UK, you will almost certainly need to take the IELTS exam in order to show that you have the necessary level of English, you may also need to take the exam to show your level of English if you intend to live permanently in an English speaking country.
On average our students achieve 6.5 in IELTS exams (mean 6.26)

Interactive English

Certificate in Advanced English (CAE)

IELTS English Course, Face to face in Brighton and Hove.  B2-C1 level.

IELTS 

General admission

From

<p>This is for students who have a good knowledge of the English language. The courses focus on grammar, reading, speaking, writing and helping students to speak with more confidence.</p>
<p>These courses are for students whose English allows them to communicate with others quite well much of the time, but who still make frequent mistakes so that there are regular misunderstandings.</p>
<h3>By the end of the General English &ndash; Intermediate course, you will be able to:</h3>
<ul>
<li>talk easily with others in common social situations</li>
<li>speak clearly enough to be easily understood by others</li>
<li>exchange opinions with others and justify your point of view</li>
<li>read and understand the main points of authentic written material</li>
<li>summarise texts using English that is easily understood by others</li>
<li>write in simple correct English in a variety of formats</li>
<li>understand and use with confidence the vocabulary of daily social life.</li>
</ul>
<p>We would expect a student to take about 12 weeks to complete this level.</p>

This is for students who have a good knowledge of the English language. The courses focus on grammar, reading, speaking, writing and helping students to speak with more confidence.
These courses are for students whose English allows them to communicate with others quite well much of the time, but who still make frequent mistakes so that there are regular misunderstandings.
By the end of the General English – Intermediate course, you will be able to:
talk easily with others in common social situations
speak clearly enough to be easily understood by others
exchange opinions with others and justify your point of view
read and understand the main points of authentic written material
summarise texts using English that is easily understood by others
write in simple correct English in a variety of formats
understand and use with confidence the vocabulary of daily social life.
We would expect a student to take about 12 weeks to complete this level.

Intermediate English Course, Face to face in Brighton and Hove, B1 level.

Intermediate

<p>This course is for students who have a basic knowledge of the English language. The courses focus on grammar, reading, as well as speaking and writing about everyday topics.</p>
<p>These courses are for students who have some fluency in English, but who still have problems with basic grammar and little confidence in using English.</p>
<h3>By the end of the General English &ndash; Pre-Intermediate course, you will be able to:</h3>
<ul>
<li>understand and respond to questions about yourself and your life</li>
<li>understand and respond to the main points of general conversations</li>
<li>understand standard speech spoken at near normal speed</li>
<li>read and understand basic public notices</li>
<li>understand simple articles and messages about everyday life</li>
<li>speak clearly about yourself so that others usually understand you</li>
<li>show that you understand others or ask them for explanations</li>
<li>maintain a basic conversation with only a little difficulty</li>
<li>write basic messages to others with correct grammar.</li>
</ul>
<p>We would expect a student to take about 12 weeks to complete this level.</p>

This course is for students who have a basic knowledge of the English language. The courses focus on grammar, reading, as well as speaking and writing about everyday topics.
These courses are for students who have some fluency in English, but who still have problems with basic grammar and little confidence in using English.
By the end of the General English – Pre-Intermediate course, you will be able to:
understand and respond to questions about yourself and your life
understand and respond to the main points of general conversations
understand standard speech spoken at near normal speed
read and understand basic public notices
understand simple articles and messages about everyday life
speak clearly about yourself so that others usually understand you
show that you understand others or ask them for explanations
maintain a basic conversation with only a little difficulty
write basic messages to others with correct grammar.
We would expect a student to take about 12 weeks to complete this level.

Pre-Intermediate English course, face to face in Brighton, A2 level. 

Pre-Intermediate 

<p>This course is for students who have a very low, basic knowledge of the English language. The courses focus on grammar, reading, as well as speaking and writing about everyday topics.</p>
<p>These courses are for students who don&rsquo;t have fluency in English, problems with basic grammar and little or no confidence in using English.</p>
<h3>By the end of the General English &ndash; Elementary course, you will be able to:</h3>
<ul>
<li>Reading: Understand short texts in simple language and find specific information in timetables, menus and advertisements.</li>
<li>Writing: Fill in forms with personal details; write short notes and messages, holiday postcards and simple personal letters.</li>
<li>exchange opinions with others and justify your point of view</li>
<li>Listening: Understand basic personal information and information about the local area, e.g. shopping, travel and employment. To understand main points of clear simple messages and announcements.</li>
<li>Speaking: Ask and answer simple questions on familiar topics. To describe the place where you live, family members and people you know. To talk simply about education and jobs.</li>
</ul>
<p>We would expect a student to take about 12 weeks to complete this level.</p>

This course is for students who have a very low, basic knowledge of the English language. The courses focus on grammar, reading, as well as speaking and writing about everyday topics.
These courses are for students who don’t have fluency in English, problems with basic grammar and little or no confidence in using English.
By the end of the General English – Elementary course, you will be able to:
Reading: Understand short texts in simple language and find specific information in timetables, menus and advertisements.
Writing: Fill in forms with personal details; write short notes and messages, holiday postcards and simple personal letters.
exchange opinions with others and justify your point of view
Listening: Understand basic personal information and information about the local area, e.g. shopping, travel and employment. To understand main points of clear simple messages and announcements.
Speaking: Ask and answer simple questions on familiar topics. To describe the place where you live, family members and people you know. To talk simply about education and jobs.
We would expect a student to take about 12 weeks to complete this level.

General English- Elementary

Worthing

Learn how to manage personal finances, such as bills and other outgoings, credit cards and loans. Understand credit scores and how to improve them. Learn to adapt your budget when your situation changes. Build your essential employability skills.

asphaleia

Maths

Employability Skills

Numeracy

A workshop for 19-29 years olds living in West Sussex who do not have their level 4 or higher maths GCSE (or equivalent). Learn how to calculate your pay and understand a payslip. Know what deductions you should pay and how to check your're on the right tax code.

Personal Finance and Employability Course - Multiply

Learn how to look for jobs in your chosen sector. Find out some top tips to create an eye-catching CV and make your job application standout to prospective employers.

A workshop for 19-29 years olds living in West Sussex who do not have their level 4 or higher maths GCSE (or equivalent). Learn how to look for jobs in your chosen sector. Find out some top tips to create an eye-catching CV and make your job application standout to prospective employers.

CVs and Job Applications - Multiply Workshop

Become more confident using maths to help with everyday spending, such as working out ‘best buys’ in supermarkets, calculating discounts, understanding the cost of borrowing or paying in instalments.

A workshop for 19-29 years olds living in West Sussex who do not have their level 4 or higher maths GCSE (or equivalent). Become more confident using maths to help with everyday spending.

Everyday Maths - Multiply Workshop

Build your confidence using numeracy skills common in all sorts of jobs, for example whether you need to measure, weigh, calculate or check numbers.

A workshop for 19-29 years olds living in West Sussex who do not have their level 4 or higher maths GCSE (or equivalent). Build your confidence using numeracy skills common in all sorts of jobs.

Numeracy Skills for Work - Multiply Workshop

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

<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

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

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





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

Louise Handy
Director, Handy Consulting Ltd



Programme
Please note timings may be subject to alteration.


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





Extra Information


Course Material


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

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


CPD Points
7 Points
 
Development Level
Learn

Research Quality Association

Introduction to Good Manufacturing Practice

RQA Member

Non Member

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

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

I Am In Print

Fiction Writing

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

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

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

Kingfisher Access

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

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

IPAF - Harness Awareness 

Southend on Sea

Droitwich Spa

Portsmouth

Rotherham

Manchester

Leeds

Slough

Bingley

Newport

Peterborough

Milton Keynes 

Paisley

Derby

Birmingham

Luton

Hull

Northampton

Bedford

Liverpool 

Swansea

BASIC to ADVANCED COURSE PACKAGE

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

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

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

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

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






Key Facts & Summary:


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

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

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

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

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

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

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

DOWNLOAD A COURSE ITINERARY HERE



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

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

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

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

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

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

DOWNLOAD A COURSE ITINERARY HERE



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

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

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

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

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

DOWNLOAD A COURSE ITINERARY HERE




How do I attend?

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

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

OR -

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

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

How do I book?

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

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

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

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

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

Geopace Training

Allied Health

Allied Health Professions (AHP)

Blood Taking

Healthcare Workers

Venepuncture

Phlebotomist

Phlebotomy

Accredited Phlebotomy

Healthcare

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

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

FAST-TRACK YOUR PHLEBOTOMY TRAINING

WITH OUR

COMPLETE TRAINING PACKAGE

20% off -  Multi-Course Discount

    Cover all stages from beginner through to Level 4

    Available as Classroom or Virtual Classroom

    Complete your beginner to advanced training in 2 days

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

    Both courses are dually accredited (OCN & CPD)

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

    Covers all steps up to live blood draw

    Learn advanced skills and techniques

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

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Phlebotomy Training - Beginner to Advanced PACKAGE

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





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


Pre-requisite:
Completion of the Real Estate Analyst Course


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


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


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


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


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


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

Bayfield Training

Real Estate Finance

Financial Modelling

Financial Analysis

Microsoft Excel

Financial Risk Management

Professional Development

Continuous Professional Development (CPD)

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

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

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 16px;">Who should attend?<br fr-original-style="" style="box-sizing: border-box;"></span></strong>Headteachers, DSLs, DSMHLs and SLTs<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></span></p>

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong><br fr-original-style="" style="box-sizing: border-box;"></span></p>

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">During this live-online masterclass we will focus on understanding recent developments in the mental health and wellbeing of children in the UK, including looking at the impact of cultural and technological changes over recent years and the impact this is having in schools. We will explore the overlap between the roles of the DSL and the Senior Mental Health Lead in responding to, and preventing incidents, as well as the need for the wider Senior Team involvement in embedding an effective whole-school/school approach.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Delivered by one of our mental health experts, the course will allow you to learn in a live real-time environment, with a range of discussion points, activities, and Q&amp;A session to ensure that you are able to complete the training with a clear understanding of current developments and best practice in relation to effective whole school/college approaches to mental health and wellbeing.</p>

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learning Objectives</strong><br fr-original-style="" style="box-sizing: border-box;"></span></p>

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This Masterclass will enable you to:</p>

<ul fr-original-style="" style="box-sizing: border-box;">
<li id="isPasted" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Examine current research and evidence to explore recent developments relating to mental health in schools &amp; colleges; both in relation to pupils/students and to staff.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">To look at the overlap and links between Mental Health and Safeguarding and therefore the work of the DSL and DSMHL and how to ensure effective cooperation and collaboration in the best interests of our pupils and students.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Examine best practice examples to ensure the whole school/college approach to mental health is effective.</li><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">To look at the risk factors for poor mental health relating to your most vulnerable pupils/students, including those with SEND and to understand how these are considered as part of a preventative whole-school/college approach.</span><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div></span><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><a href="https://www.brightcoreconsultancy.com/brightcore-testimonials" target="_blank" style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); font-weight: bold; text-decoration: none; border-radius: 5px; background-color: rgb(61, 86, 224); border-width: 12px 18px; border-style: solid; border-color: rgb(61, 86, 224); display: inline-block; user-select: auto; box-sizing: border-box; cursor: pointer;" rel="noopener noreferrer" fr-original-style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: #ffffff; font-weight: bold; text-decoration: none; border-radius: 5px; background-color: #3D56E0; border-top: 12px solid #3D56E0; border-bottom: 12px solid #3D56E0; border-right: 18px solid #3D56E0; border-left: 18px solid #3D56E0; display: inline-block;">View all testimonials </a></p></span></ul>

Who should attend?
Headteachers, DSLs, DSMHLs and SLTs

Overview

During this live-online masterclass we will focus on understanding recent developments in the mental health and wellbeing of children in the UK, including looking at the impact of cultural and technological changes over recent years and the impact this is having in schools. We will explore the overlap between the roles of the DSL and the Senior Mental Health Lead in responding to, and preventing incidents, as well as the need for the wider Senior Team involvement in embedding an effective whole-school/school approach.
Delivered by one of our mental health experts, the course will allow you to learn in a live real-time environment, with a range of discussion points, activities, and Q&A session to ensure that you are able to complete the training with a clear understanding of current developments and best practice in relation to effective whole school/college approaches to mental health and wellbeing.

Learning Objectives

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

Brightcore Consultancy

Child Safeguarding

Mental Health

Children's Mental Health

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

Mental Health in Education Update

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

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

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

FAQs

Mindmaps Wellbeing

Mental Health Awareness

Mental Health First Aid

Approved Training Organisation (ATO)

Health & Wellbeing

Occupational Health & Wellbeing

Accredited Mental Health First Aid

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.

2512 Courses in Brighton

Taster session with Lilley Lovett Theatre Group

By Lilley Lovett Theatre Group

Islamic Studies Classes

By Ilmul Atfaal Online

IELTS

By Interactive English

Intermediate

By Interactive English

Pre-Intermediate

By Interactive English

General English- Elementary

By Interactive English

Personal Finance and Employability Course - Multiply

By asphaleia

CVs and Job Applications - Multiply Workshop

By asphaleia

Everyday Maths - Multiply Workshop

By asphaleia

Numeracy Skills for Work - Multiply Workshop

By asphaleia

Search By Location