Name: Communication Skills 1 Day Virtual Live Training in Windsor Town
Price: 695 GBP
Availability: InStock

York

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

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

Mangates

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

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

Communication Skills 1 Day Virtual Live Training in Portsmouth

Standard Fee

Early Bird Fee

Communication Skills 1 Day Virtual Live Training in Leicester

Communication Skills 1 Day Virtual Live Training in Southampton

Communication Skills 1 Day Virtual Live Training in Preston

Communication Skills 1 Day Virtual Live Training in Watford

Communication Skills 1 Day Virtual Live Training in Brighton

Communication Skills 1 Day Virtual Live Training in Liverpool

Communication Skills 1 Day Virtual Live Training in Milton Keynes

Communication Skills 1 Day Virtual Live Training in Guildford

Communication Skills 1 Day Virtual Live Training in Windsor Town

Reading

This course has been designed and approved by the ILM (Institute of Leadership and Management). The recognition from the ILM means delegates receive an ILM Recognised Certificate from the ILM upon successful completion of the course.All of our ILM Programmes are provided in partnership with&nbsp;<a href="https://www.thebcfgroup.co.uk/interpersonal/train-the-trainer.php" style="color: rgb(17, 86, 166); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(17, 86, 166);">The BCF Group</a>, which is the ILM Approved Centre we deliver under. <hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h3 style="color: rgb(17, 86, 166); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(17, 86, 166);">Venue Details</h3><h5 style="color: rgb(17, 86, 166); box-sizing: border-box;" fr-original-style=" color: rgb(17, 86, 166);">Nottingham</h5>The BCF Group Ltd, 5 Wheatcroft Business Park, Landmere Lane, Edwalton, Nottingham, NG12 4DG<img src="https://www.dicksontraining.com/images/wheelchair-icon.jpg" alt="" width="20" height="20" border="0" style="color: rgb(125, 125, 125); cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="color: rgb(125, 125, 125);" fr-original-class="fr-draggable">&nbsp;Suitable for Wheelchairs <img src="https://www.dicksontraining.com/images/venue-pics/nottingham.png" alt="" width="150" height="96" border="0" style="color: rgb(125, 125, 125); cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="color: rgb(125, 125, 125);" fr-original-class="fr-draggable">All Nottingham courses are held at the head office of The BCF Group. The comfortable training suites (which are situated on ground level, as well as the toilet facilities, making them wheelchair-friendly) are fully air conditioned with natural daylight. Plentiful on-site free car parking is also available.<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;"><article style="color: rgb(125, 125, 125); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(125, 125, 125);"><h3 style="color: rgb(17, 86, 166); box-sizing: border-box;" fr-original-style=" color: rgb(17, 86, 166);">In-House Courses</h3><section fr-original-style="" style="box-sizing: border-box;"><img src="https://www.dicksontraining.com/images/group1a.png" alt="In-House Training Courses" title="In-House Training Courses" width="327" height="219" border="0" 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">Our Train The Trainer course has been developed and refined over the many years we have been providing it to delegates from organisations in virtually every industry.The course syllabus is flexible and can be tailored to the specific requirements of your organisation and industry.If you would like to discuss how we can tailor this Train The Trainer course for you and/or run it at your premises, please contact us.</section></article> <a name="Coursedates" style="color: rgb(17, 86, 166); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(17, 86, 166);"></a><article style="color: rgb(125, 125, 125); box-sizing: border-box;" fr-original-style=" color: rgb(125, 125, 125);"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h3 style="color: rgb(17, 86, 166); box-sizing: border-box;" fr-original-style=" color: rgb(17, 86, 166);">Scheduled Courses</h3><section fr-original-style="" style="box-sizing: border-box;"><h5 style="color: rgb(17, 86, 166); box-sizing: border-box;" fr-original-style=" color: rgb(17, 86, 166);">Classroom Course - Nottingham (NG12 4DG)</h5>Classroom training courses enable you to benefit from having the tutor and other delegates right there in the room with you. Face-to-face training sessions are one of the best ways to learn, as it is easy to ask questions and have group discussions.Cost: &pound;895 + vat<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strike fr-original-style="" style="box-sizing: border-box;">16-17 April 2024</strike>&nbsp;- COURSE FULL</li><li fr-original-style="" style="box-sizing: border-box;">29-30 April 2024</li><li fr-original-style="" style="box-sizing: border-box;">18-19 June 2024</li><li fr-original-style="" style="box-sizing: border-box;">15-16 August 2024</li><li fr-original-style="" style="box-sizing: border-box;">14-15 October 2024</li><li fr-original-style="" style="box-sizing: border-box;">03-04 December 2024</li></ul><h5 style="color: rgb(17, 86, 166); box-sizing: border-box;" fr-original-style=" color: rgb(17, 86, 166);">Classroom Course - Reading (RG41 5QS)</h5>Classroom training courses enable you to benefit from having the tutor and other delegates right there in the room with you. Face-to-face training sessions are one of the best ways to learn, as it is easy to ask questions and have group discussions.Cost: &pound;895 + vat<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">05-06 March 2024</li><li fr-original-style="" style="box-sizing: border-box;">25-26 June 2024</li><li fr-original-style="" style="box-sizing: border-box;">26-27 September 2024</li><li fr-original-style="" style="box-sizing: border-box;">05-06 December 2024</li></ul><h5 style="color: rgb(17, 86, 166); box-sizing: border-box;" fr-original-style=" color: rgb(17, 86, 166);">Zoom&trade; Course</h5>Attending a course via Zoom videoconferencing gives you all of the benefits of classroom training without the need to leave your home or office. You still benefit from a real tutor facilitating the programme, and the content is exactly the same.Cost: &pound;795 + vat<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">March 2024&nbsp;- 25th March (morning), 25th March (afternoon), 26th March (morning), 26th March (afternoon)</li><li fr-original-style="" style="box-sizing: border-box;">May 2024&nbsp;- 21st May (morning), 21st May (afternoon), 22nd May (morning), 22nd May (afternoon)</li><li fr-original-style="" style="box-sizing: border-box;">July 2024&nbsp;- 18th July (morning), 18th July (afternoon), 19th July (morning), 19th July (afternoon)</li><li fr-original-style="" style="box-sizing: border-box;">September 2024&nbsp;- 18th September (morning), 18th September (afternoon), 19th September (morning), 19th September (afternoon)</li><li fr-original-style="" style="box-sizing: border-box;">November 2024&nbsp;- 13th November (morning), 13th November (afternoon), 14th November (morning), 14th November (afternoon)</li><li fr-original-style="" style="box-sizing: border-box;">January 2025&nbsp;- 21st January (morning), 21st January (afternoon), 22nd January (morning), 22nd January (afternoon)</li></ul></section></article><section style="color: rgb(125, 125, 125); box-sizing: border-box;" fr-original-style=" color: rgb(125, 125, 125);"><section style="color: rgb(125, 125, 125); box-sizing: border-box;" fr-original-style=" color: rgb(125, 125, 125);"><article style="color: rgb(125, 125, 125); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(125, 125, 125);"> </article></section></section>

This course has been designed and approved by the ILM (Institute of Leadership and Management). The recognition from the ILM means delegates receive an ILM Recognised Certificate from the ILM upon successful completion of the course.
All of our ILM Programmes are provided in partnership with The BCF Group, which is the ILM Approved Centre we deliver under.





Venue Details
Nottingham
The BCF Group Ltd, 5 Wheatcroft Business Park, Landmere Lane, Edwalton, Nottingham, NG12 4DG

Suitable for Wheelchairs

All Nottingham courses are held at the head office of The BCF Group. The comfortable training suites (which are situated on ground level, as well as the toilet facilities, making them wheelchair-friendly) are fully air conditioned with natural daylight. Plentiful on-site free car parking is also available.



In-House Courses

Our Train The Trainer course has been developed and refined over the many years we have been providing it to delegates from organisations in virtually every industry.
The course syllabus is flexible and can be tailored to the specific requirements of your organisation and industry.
If you would like to discuss how we can tailor this Train The Trainer course for you and/or run it at your premises, please contact us.



Scheduled Courses
Classroom Course - Nottingham (NG12 4DG)
Classroom training courses enable you to benefit from having the tutor and other delegates right there in the room with you. Face-to-face training sessions are one of the best ways to learn, as it is easy to ask questions and have group discussions.
Cost: £895 + vat
16-17 April 2024 - COURSE FULL
29-30 April 2024
18-19 June 2024
15-16 August 2024
14-15 October 2024
03-04 December 2024
Classroom Course - Reading (RG41 5QS)
Classroom training courses enable you to benefit from having the tutor and other delegates right there in the room with you. Face-to-face training sessions are one of the best ways to learn, as it is easy to ask questions and have group discussions.
Cost: £895 + vat
05-06 March 2024
25-26 June 2024
26-27 September 2024
05-06 December 2024
Zoom™ Course
Attending a course via Zoom videoconferencing gives you all of the benefits of classroom training without the need to leave your home or office. You still benefit from a real tutor facilitating the programme, and the content is exactly the same.
Cost: £795 + vat
March 2024 - 25th March (morning), 25th March (afternoon), 26th March (morning), 26th March (afternoon)
May 2024 - 21st May (morning), 21st May (afternoon), 22nd May (morning), 22nd May (afternoon)
July 2024 - 18th July (morning), 18th July (afternoon), 19th July (morning), 19th July (afternoon)
September 2024 - 18th September (morning), 18th September (afternoon), 19th September (morning), 19th September (afternoon)
November 2024 - 13th November (morning), 13th November (afternoon), 14th November (morning), 14th November (afternoon)
January 2025 - 21st January (morning), 21st January (afternoon), 22nd January (morning), 22nd January (afternoon)

Dickson Training Ltd

Train The Trainer Course

Classroom Course

Online Course

Burnley

This course is the next step on your Reiki journey if you would like to be able to use Reiki at a higher level and work with clients/familyThis level 2 Reiki course is for you if you want to give Reiki healing at a more intense level or give healing treatments to others. Here you are introduced to the Reiki symbols for the first time<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Cho Ku Rei (power symbol)</li><li fr-original-style="" style="box-sizing: border-box;">Sei He Ki (emotional symbol)</li><li fr-original-style="" style="box-sizing: border-box;">Hon Sha Ze Sho Nen (distance healing symbol)</li></ul>What will I learn on this course:-<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">How to use the Reiki sacred symbols</li><li fr-original-style="" style="box-sizing: border-box;">What is Distance Healing and how to use the distance symbol so you can send Reiki healing to others.</li><li fr-original-style="" style="box-sizing: border-box;">Have increased level 2 Reiki energy</li><li fr-original-style="" style="box-sizing: border-box;">How to practice Self-Healing using the increased energy</li><li fr-original-style="" style="box-sizing: border-box;">Hand positions when healing others</li><li fr-original-style="" style="box-sizing: border-box;">The 21 day Cleansing Process explained</li><li fr-original-style="" style="box-sizing: border-box;">Professional Ethics</li><li fr-original-style="" style="box-sizing: border-box;">Question and answer session</li></ul>You will be initiated to the Reiki energy by a level 2 attunement and receive a full instruction manual and your course certificate will be awarded to you at the end of the course. I am a Reiki Master and teacher and I am one of the few traditionally trained Reiki Masters in the UK who have been trained by international best-selling Reiki author Penelope Quest. My teaching methods use traditional Reiki techniques perfected over many years and you can be assured of my support during and after your course.The course can be booked online here and you will receive instructions on how to access the course.I look forward to meeting you and sharing my knowledge and experience of Reiki with you.What this course offers you<ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Individual Support - During and after your course</li><li fr-original-style="" style="box-sizing: border-box;">Practical Experience - Step by step training is given so that you can gain valuable experience using Reiki</li><li fr-original-style="" style="box-sizing: border-box;">Energy Perception &ndash; You will be taught to develop skills of energy perception and learn how to interpret the Reiki by what you sense and feel</li><li fr-original-style="" style="box-sizing: border-box;">Personal Growth - You will discover for yourself the increased level of Reiki healing and be able to use its methods of healing on others and have paying clients if you wish&nbsp;</li></ul>Why a Level 2 Course?&nbsp;Reiki at Level 2 is the level of training which is needed to practise Reiki healing professionally and have paying clients. Often reflexologists, aromatherapists and other complementary therapists add reiki healing to their range of healing skills that they offer their clients.&nbsp;However it is not just for those who have clients it is also a powerful self-development technique for your own personal healing experience and to share with family/friends and give them the benefit of well-being.A certificate at Reiki Level One is needed for you to enrol on this course and I am happy to accept students who have trained elsewhere with another Reiki Master.The Reiki Two course is taught live on line using Zoom.Testimonials:- What other students who have attended my courses are saying&nbsp;Level Two Course&ldquo;She explains everything so well and makes it easy to understand and connect to the reiki. This is my 2nd course I&rsquo;ve done with Margaret&rdquo; (Louise B)."Thank you, I thoroughly enjoyed the course." (Beverley S)This is a very well organized and informative course! (Georgie P)

This course is the next step on your Reiki journey if you would like to be able to use Reiki at a higher level and work with clients/family
This level 2 Reiki course is for you if you want to give Reiki healing at a more intense level or give healing treatments to others. Here you are introduced to the Reiki symbols for the first time
Cho Ku Rei (power symbol)
Sei He Ki (emotional symbol)
Hon Sha Ze Sho Nen (distance healing symbol)
What will I learn on this course:-
How to use the Reiki sacred symbols
What is Distance Healing and how to use the distance symbol so you can send Reiki healing to others.
Have increased level 2 Reiki energy
How to practice Self-Healing using the increased energy
Hand positions when healing others
The 21 day Cleansing Process explained
Professional Ethics
Question and answer session
You will be initiated to the Reiki energy by a level 2 attunement and receive a full instruction manual and your course certificate will be awarded to you at the end of the course. 
I am a Reiki Master and teacher and I am one of the few traditionally trained Reiki Masters in the UK who have been trained by international best-selling Reiki author Penelope Quest. My teaching methods use traditional Reiki techniques perfected over many years and you can be assured of my support during and after your course.
The course can be booked online here and you will receive instructions on how to access the course.
I look forward to meeting you and sharing my knowledge and experience of Reiki with you.
What this course offers you
Individual Support - During and after your course
Practical Experience - Step by step training is given so that you can gain valuable experience using Reiki
Energy Perception – You will be taught to develop skills of energy perception and learn how to interpret the Reiki by what you sense and feel
Personal Growth - You will discover for yourself the increased level of Reiki healing and be able to use its methods of healing on others and have paying clients if you wish
Why a Level 2 Course? Reiki at Level 2 is the level of training which is needed to practise Reiki healing professionally and have paying clients. Often reflexologists, aromatherapists and other complementary therapists add reiki healing to their range of healing skills that they offer their clients. 
However it is not just for those who have clients it is also a powerful self-development technique for your own personal healing experience and to share with family/friends and give them the benefit of well-being.
A certificate at Reiki Level One is needed for you to enrol on this course and I am happy to accept students who have trained elsewhere with another Reiki Master.
The Reiki Two course is taught live on line using Zoom.
Testimonials:- What other students who have attended my courses are saying 
Level Two Course
“She explains everything so well and makes it easy to understand and connect to the reiki. This is my 2nd course I’ve done with Margaret” (Louise B).
"Thank you, I thoroughly enjoyed the course." (Beverley S)
This is a very well organized and informative course! (Georgie P)

Margaret Cook - Learn More About Reiki

Energy Healing

Reiki

Reiki Healer

I am a Reiki Teacher in Manchester and one of the few traditionally trained Reiki Masters in the UK who have been trained by international best-selling Reiki author Penelope Quest. My teaching methods use traditional Reiki techniques perfected over many years and you can be assured of my support during and after your course. I teach all three levels of Reiki courses, level 1 reiki. level 2 reiki and reiki master level 3

Reiki Level 2 Practitioner Online Course

General Admission

Real Estate Financial Modelling School (5 days)The Real Estate Financial Modelling School is an intensive week meticulously designed to teach the best practices to create flexible and robust cash flows in Excel.This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance &amp; Risk.The school combines three of our courses:<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 Analyst</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Investor</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Modelling Masterclass</li></ul> All of the courses are interlinked to give you a full understanding of the subject using Excel. On this course you will&hellip;<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Implement cash flows in excel throughout the whole week.</li><li value="2" fr-original-style="" style="box-sizing: border-box;">In the first two days you will learn how to develop rent functions and net operating income. We will show you how to value and appraise property investments and analyse the results.</li><li value="3" fr-original-style="" style="box-sizing: border-box;">On the third and fourth day you will learn how to model and analyse development projects using both residuals and cash flow methods. It will show you how to interrogate and compare alternative return metrics such as profit-equity multiples, profit and cost, net present value, worth and internal rate of return. Additionally you will cover how to model cash flow from different sector office, retail and leisure.</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Finally on the fifth day debt structures will be covered as well as joint ventures and partnership financing. You will also learn how to implement the full spectrum of the risk analysis from sensitivity to Monte Carlo.</li></ul> Who will benefit from this school?<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Property industry modellers who would like to be fully proficient in building complex financial models</li></ul> Course OutlineDay OneReal Estate Analyst IKnow how to build a property asset cash flow, analyse geared, and un-geared IRRs.<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Term &amp; Reversion and Layer Method Valuation (Intro to Excel)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Equivalent Yield (Solver, Scenario and Goal Seek functions)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Single-Let Discounted Cash Flow</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analysis and use of date series</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Internal Rate of Return (IRR) and Net Present Value (NPV)</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Comparing Value, Price and Worth</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Adding borrowing and analysing geared returns</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Introducing Rent Reviews and other &lsquo;events&rsquo; into cash flows</li><li value="10" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; concept and Logic functions (IF,OR,AND)</li><li value="11" fr-original-style="" style="box-sizing: border-box;">Sensitivity analysis</li></ul> Day TwoReal Estate Analyst IIKnow how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; and Multi-let cash flows</li><li value="2" fr-original-style="" style="box-sizing: border-box;">The &lsquo;date problem&rsquo; and assumptions in property asset cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Reducing the rent function, intermediate calculations and modelling theory</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling lease expiries, break clauses, voids, and upward only covenants</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Incorporating time-varying rental growth rates</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Analysing multi-let cash flows to see if the leases are sufficiently diversified</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Further IRR analysis (XIRR, MIRR)</li></ul> Day ThreeReal Estate Investor I<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">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" fr-original-style="" style="box-sizing: border-box;">Modelling sector variations in real estate income streams i.e. Office versus industrial, retail &amp; leisure</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Further senior debt covenants</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advance Rent Function techniques to manage feature rich lease structures</li></ul> Day FourReal Estate Investor II<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Introduction to development appraisals</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Residual models, site and profit calculations</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Development cash flows versus Investment cash flows</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Introduction to straight line versus S-curve costing</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Phased asset sales in development appraisals</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Discounting development cash flows</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Complimentary return metrics for development appraisals</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Introduction to development finance</li></ul> Day FiveReal Estate Modelling Masterclass<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Mezzanine debt modelling</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Joint Venture structures between developers and lender/equity partners</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Promote and profit share structure calculations</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advance project cash flows with mezzanine debts</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Key Real Estate and investment risks, risk adjustment of exit yields</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Sensitivity and Scenario Analysis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Monte Carlo Analysis</li></ul> Included in the Course<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">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" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul> For more information about the Real Estate Financial Modelling School such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <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;">www.bayfieldtraining.com</a>



Real Estate Financial Modelling School (5 days)
The Real Estate Financial Modelling School is an intensive week meticulously designed to teach the best practices to create flexible and robust cash flows in Excel.
This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.
The school combines three of our courses:
Real Estate Analyst
Real Estate Investor
Real Estate Modelling Masterclass


All of the courses are interlinked to give you a full understanding of the subject using Excel.


On this course you will…
Implement cash flows in excel throughout the whole week.
In the first two days you will learn how to develop rent functions and net operating income. We will show you how to value and appraise property investments and analyse the results.
On the third and fourth day you will learn how to model and analyse development projects using both residuals and cash flow methods. It will show you how to interrogate and compare alternative return metrics such as profit-equity multiples, profit and cost, net present value, worth and internal rate of return. Additionally you will cover how to model cash flow from different sector office, retail and leisure.
Finally on the fifth day debt structures will be covered as well as joint ventures and partnership financing. You will also learn how to implement the full spectrum of the risk analysis from sensitivity to Monte Carlo.


Who will benefit from this school?
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Mid-level to senior Real Estate Analysts
Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail
Property industry modellers who would like to be fully proficient in building complex financial models


Course Outline
Day One
Real Estate Analyst I
Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.
Term & Reversion and Layer Method Valuation (Intro to Excel)
Equivalent Yield (Solver, Scenario and Goal Seek functions)
Single-Let Discounted Cash Flow
Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)
Analysis and use of date series
Internal Rate of Return (IRR) and Net Present Value (NPV)
Comparing Value, Price and Worth
Adding borrowing and analysing geared returns
Introducing Rent Reviews and other ‘events’ into cash flows
The ‘Rent Function’ concept and Logic functions (IF,OR,AND)
Sensitivity analysis


Day Two
Real Estate Analyst II
Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.
The ‘Rent Function’ and Multi-let cash flows
The ‘date problem’ and assumptions in property asset cash flows
Reducing the rent function, intermediate calculations and modelling theory
Modelling lease expiries, break clauses, voids, and upward only covenants
Incorporating time-varying rental growth rates
Analysing multi-let cash flows to see if the leases are sufficiently diversified
Further IRR analysis (XIRR, MIRR)


Day Three
Real Estate Investor I
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 Four
Real Estate Investor II
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


Day Five
Real Estate Modelling Masterclass
Mezzanine debt modelling
Joint Venture structures between developers and lender/equity partners
Promote and profit share structure calculations
Advance project cash flows with mezzanine debts
Key Real Estate and investment risks, risk adjustment of exit yields
Sensitivity and Scenario Analysis
Monte Carlo Analysis


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 Financial Modelling School 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

Microsoft Excel

Professional Development

Continuous Professional Development (CPD)

This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.

Real Estate Financial Modelling School

Real Estate AnalystThe Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results. On this course, you will&hellip;<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Learn how to structure an investment cash flow from first principles and how to value and appraise property investments</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Build annual and quarterly discounted cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Build OPEX and CAPEX into your cash flow</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analyse risk using sensitivity tables and charts</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Employ best practice and find solutions to common modelling problems</li></ul> Who will benefit from this course?<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Surveyors</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Portfolio Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Investment Managers</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Asset Managers</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="9" fr-original-style="" style="box-sizing: border-box;">APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.</li></ul> Day OneKnow how to build a property asset cash flow, analyse geared, and un-geared IRRs.<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Term &amp; Reversion and Layer Method Valuation (Intro to Excel)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Equivalent Yield (Solver, Scenario and Goal Seek functions)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Single-Let Discounted Cash Flow</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analysis and use of date series</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Internal Rate of Return (IRR) and Net Present Value (NPV)</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Comparing Value, Price and Worth</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Adding borrowing and analysing geared returns</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Introducing Rent Reviews and other &lsquo;events&rsquo; into cash flows</li><li value="10" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; concept and Logic functions (IF,OR,AND)</li><li value="11" fr-original-style="" style="box-sizing: border-box;">Sensitivity analysis</li></ul> Day TwoKnow how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; and Multi-let cash flows</li><li value="2" fr-original-style="" style="box-sizing: border-box;">The &lsquo;date problem&rsquo; and assumptions in property asset cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Reducing the rent function, intermediate calculations and modelling theory</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling lease expiries, break clauses, voids, and upward only covenants</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Incorporating time-varying rental growth rates</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Analysing multi-let cash flows to see if the leases are sufficiently diversified</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Further IRR analysis (XIRR, MIRR)</li></ul> Included in the Course<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">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" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul> For more information about the Real Estate Analyst such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <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;">www.bayfieldtraining.com</a>



Real Estate Analyst
The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.
Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results.


On this course, you will…
Learn how to structure an investment cash flow from first principles and how to value and appraise property investments
Build annual and quarterly discounted cash flows
Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry
Build OPEX and CAPEX into your cash flow
Analyse risk using sensitivity tables and charts
Employ best practice and find solutions to common modelling problems


Who will benefit from this course?
Real Estate Investors
Surveyors
Portfolio Analysts
Investment Managers
Asset Managers
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.


Day One
Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.
Term & Reversion and Layer Method Valuation (Intro to Excel)
Equivalent Yield (Solver, Scenario and Goal Seek functions)
Single-Let Discounted Cash Flow
Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)
Analysis and use of date series
Internal Rate of Return (IRR) and Net Present Value (NPV)
Comparing Value, Price and Worth
Adding borrowing and analysing geared returns
Introducing Rent Reviews and other ‘events’ into cash flows
The ‘Rent Function’ concept and Logic functions (IF,OR,AND)
Sensitivity analysis


Day Two
Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.
The ‘Rent Function’ and Multi-let cash flows
The ‘date problem’ and assumptions in property asset cash flows
Reducing the rent function, intermediate calculations and modelling theory
Modelling lease expiries, break clauses, voids, and upward only covenants
Incorporating time-varying rental growth rates
Analysing multi-let cash flows to see if the leases are sufficiently diversified
Further IRR analysis (XIRR, MIRR)


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

Financial Modelling & Analysis

Financial Modelling

Property & Real Estate Photography

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

<div id="course-pills-1">Duration3 Days18 CPD hoursThis course is intended forThis course is designed for anyone who needs an understanding of IT Service Management to help deliver better value to customers. It is appropriate for all IT staff and management, as well as customers who work closely with IT to support business requirements. This course is also designed for students who are seeking the ITILÂ© 4 Foundation certification and who want to prepare for ITILÂ© 4 Foundation exam.OverviewBy the completion of this course, you will have a deep understanding of the 7 Guiding Principles, 4 Dimensions of Service Management, 34 ITILÂ© Practices, and the new Service Value Chain that incorporate the core of ITILÂ© version 4.ITILÂ© is the world?s leading best practice framework for implementing IT Service Management. ITIL version 4 introduces IT Service Management through the lens of a Service Value System (SVS), which provides a holistic end-to-end view of how to successfully contribute to business value, and also how to leverage concepts from models such as Lean IT, Agile, DevOps and Organizational Change Management. This foundational course immerses you in the guiding principles, dimensions, and practices of ITILÂ© 4. This course will earn you 21 PDUs. This class includes an exam voucher. </div><div id="course-pills-2"><h3>1 - ITIL 4 OVERVIEW</h3> <ul> <li>Introduction to ITIL</li> <li>Key Concepts of ITIL</li> </ul> <h3>2 - The ITIL Framework</h3> <ul> <li>The Four Dimensions of Service Management</li> <li>The ITIL Service Value System</li> </ul> <h3>3 - The ITIL Guiding Principles</h3> <ul> <li>Focus on Value</li> <li>Start Where You Are</li> <li>Progress Iteratively with Feedback</li> <li>Collaborate and Promote Visibility</li> <li>Think and Work Holistically</li> <li>Keep It Simple and Practical</li> <li>Optimize and Automate</li> </ul> <h3>4 - THE ITIL SERVICE VALUE SYSTEM (SVS)</h3> <ul> <li>Governance</li> <li>The Service Value Chain</li> <li>Continual Improvement</li> </ul> <h3>5 - Key ITIL Practices</h3> <ul> <li>Continual Improvement</li> <li>Service Level Management</li> <li>Change Control</li> <li>Incident Management</li> <li>Service Request Management</li> <li>Service Desk</li> <li>Problem Management</li> </ul> <h3>6 - Other ITIL Practices</h3> <ul> <li>General Management Practices</li> <li>Service Management Practices</li> <li>Technical Management Practices</li> </ul></div>

Duration
3 Days
18 CPD hours
This course is intended for
This course is designed for anyone who needs an understanding of IT Service Management to help deliver better value to customers. It is appropriate for all IT staff and management, as well as customers who work closely with IT to support business requirements. This course is also designed for students who are seeking the ITILÂ© 4 Foundation certification and who want to prepare for ITILÂ© 4 Foundation exam.
Overview
By the completion of this course, you will have a deep understanding of the 7 Guiding Principles, 4 Dimensions of Service Management, 34 ITILÂ© Practices, and the new Service Value Chain that incorporate the core of ITILÂ© version 4.
ITILÂ© is the world?s leading best practice framework for implementing IT Service Management. ITIL version 4 introduces IT Service Management through the lens of a Service Value System (SVS), which provides a holistic end-to-end view of how to successfully contribute to business value, and also how to leverage concepts from models such as Lean IT, Agile, DevOps and Organizational Change Management. This foundational course immerses you in the guiding principles, dimensions, and practices of ITILÂ© 4. This course will earn you 21 PDUs. 

 This class includes an exam voucher. 
1 - ITIL 4 OVERVIEW
Introduction to ITIL
Key Concepts of ITIL
2 - The ITIL Framework
The Four Dimensions of Service Management
The ITIL Service Value System
3 - The ITIL Guiding Principles
Focus on Value
Start Where You Are
Progress Iteratively with Feedback
Collaborate and Promote Visibility
Think and Work Holistically
Keep It Simple and Practical
Optimize and Automate
4 - THE ITIL SERVICE VALUE SYSTEM (SVS)
Governance
The Service Value Chain
Continual Improvement
5 - Key ITIL Practices
Continual Improvement
Service Level Management
Change Control
Incident Management
Service Request Management
Service Desk
Problem Management
6 - Other ITIL Practices
General Management Practices
Service Management Practices
Technical Management Practices

Nexus Human

IT Service Management

ITIL

IT Certifications

IT (Information Technology)

International Trauma Life Support (ITLS)

Institute of Leadership & Management (ILM)

ITILÂ© 4 Foundation

<div id="course-pills-1">Duration2 Days12 CPD hoursThis course is intended forThis course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users.OverviewAt course completion, you should be able to describe DAX syntax, data types, and errors use DAX to create calculated columns, measures, and tables explain how DAX calculations are evaluated, along with the differences between row context and filter context configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc. create calculated columns and measures that use data from multiple tables in the data model write measures that handle error conditions gracefully use DAX to enhance the Power BI user experience use DAX Studio to connect to a Power BI data model and execute simple queriesWelcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code.</div><div id="course-pills-2"><h4>MODULE 1: GETTING STARTED WITH DAX </h4><ul><li>INTRODUCTION TODAX </li><li>CREATING OBJECTS WITHDAX </li><li>CONTEXT AND RULES OF EVALUATION</li><li>VARIABLES,COMMENTS,AND TESTING</li></ul><h4>MODULE 2: PERFORMING BASIC CALCULATIONS</h4><ul><li>GETTING STARTED</li><li>IMPLICIT MEASURES </li><li>ADDING QUICK MEASURES </li><li>WORKING WITH DAX DATA TYPES .</li><li>DOING BASIC MATH </li><li>USING LOGIC IN YOUR CALCULATIONS </li><li>USING THE IF() FUNCTION </li><li>NESTED IF()</li><li>USING THE SWITCH() FUNCTION </li><li>ADVANCED SWITCH()</li><li>LOGICAL OPERATORS &amp; FUNCTIONS: ||, OR(), &amp;&amp;, AND(), NOT()</li><li>AGGREGATING AND SUMMARIZING DATA </li><li>THE SUM() FUNCTION</li></ul><h4>MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL </h4><ul><li>CONTEXT DEFINED </li><li>DATA MODELING BASICS </li><li>INTRODUCTION TO DIMENSIONAL MODELING </li><li>RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT </li><li>GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE</li><li>LOOKING UP DATA WITHOUT USING RELATIONSHIPS </li><li>MODIFYING THE CONTEXT USING CALCULATE()</li></ul><h4>MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS </h4><ul><li>THE DAX ITERATOR FUNCTIONS </li><li>USING TABLE MANIPULATION FUNCTIONS</li></ul><h4>MODULE 5: WORKING WITH TIME</h4><ul><li>PERFORMING DATE CALCULATIONS </li><li>WORKING WITH DATE TABLES </li><li>GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION </li><li>DEFINING CUSTOM OPERATING PERIODS </li><li>YTD, QTD, AND MTD CALCULATIONS </li><li>CUSTOM TO-DATE CALCULATIONS </li><li>FINDING YEAR-OVER-YEAR CHANGE </li><li>FINDING MOVING AVERAGES </li></ul><h4>MODULE 6: ENHANCING THE USER EXPERIENCE</h4><ul><li>CONTROLLING VISIBILITYOF YOUR MEASURES</li><li>USING WHAT-IF PARAMETERS </li><li>ADDING BANDING </li><li>USING DAX TO PROVIDE ROW-LEVEL SECURITY </li></ul></div>

Duration
2 Days
12 CPD hours
This course is intended for
This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users.
Overview
At course completion, you should be able to
describe DAX syntax, data types, and errors
use DAX to create calculated columns, measures, and tables
explain how DAX calculations are evaluated, along with the differences between row context and filter context
configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc.
create calculated columns and measures that use data from multiple tables in the data model
write measures that handle error conditions gracefully
use DAX to enhance the Power BI user experience
use DAX Studio to connect to a Power BI data model and execute simple queries
Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code.
MODULE 1: GETTING STARTED WITH DAX
INTRODUCTION TODAX
CREATING OBJECTS WITHDAX
CONTEXT AND RULES OF EVALUATION
VARIABLES,COMMENTS,AND TESTING
MODULE 2: PERFORMING BASIC CALCULATIONS
GETTING STARTED
IMPLICIT MEASURES
ADDING QUICK MEASURES
WORKING WITH DAX DATA TYPES .
DOING BASIC MATH
USING LOGIC IN YOUR CALCULATIONS
USING THE IF() FUNCTION
NESTED IF()
USING THE SWITCH() FUNCTION
ADVANCED SWITCH()
LOGICAL OPERATORS & FUNCTIONS: ||, OR(), &&, AND(), NOT()
AGGREGATING AND SUMMARIZING DATA
THE SUM() FUNCTION
MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL
CONTEXT DEFINED
DATA MODELING BASICS
INTRODUCTION TO DIMENSIONAL MODELING
RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT
GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE
LOOKING UP DATA WITHOUT USING RELATIONSHIPS
MODIFYING THE CONTEXT USING CALCULATE()
MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS
THE DAX ITERATOR FUNCTIONS
USING TABLE MANIPULATION FUNCTIONS
MODULE 5: WORKING WITH TIME
PERFORMING DATE CALCULATIONS
WORKING WITH DATE TABLES
GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION
DEFINING CUSTOM OPERATING PERIODS
YTD, QTD, AND MTD CALCULATIONS
CUSTOM TO-DATE CALCULATIONS
FINDING YEAR-OVER-YEAR CHANGE
FINDING MOVING AVERAGES
MODULE 6: ENHANCING THE USER EXPERIENCE
CONTROLLING VISIBILITYOF YOUR MEASURES
USING WHAT-IF PARAMETERS
ADDING BANDING
USING DAX TO PROVIDE ROW-LEVEL SECURITY

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Excel Analytics

Data Analysis Expressions

Data Skills

Introduction to DAX for Power BI

Nottingham

London

This masterclass is designed to provide a practical application of the content that is covered within The DEI Playbook including:<ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">A deep dive into the six steps of the DEI framework&nbsp;<ol style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">DEI Strategy</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">Leadership commitment</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">Recruitment and hiring of diverse talent</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">inclusive performance management</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">equitable and inclusive organisational culture</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">marketplace and community impact</li></ol></li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">Measuring DEI using a scorecard</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">ISO audit - how to prepare for and conduct it</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">The success factors of inclusive culture change&nbsp;</li><li id="isPasted" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">Project management techniques and best practice</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">A change communications toolkit</li></ul>Who is this learning for?<ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Diversity and inclusion leads and practitioners</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">HR professionals tasked with diversity and inclusion within their remit</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Managers and leaders looking to develop an inclusive culture</li></ul>What type of learning is this?<ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Small group learning allows lots of time to focus on the &#39;doing&#39; as well as on learning</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Global cohorts so there is a greater opportunity to learn in a cross-cultural context</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Action learning so you can ask questions, engage with others and get feedback in the moment</li><li id="isPasted" style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Facilitated as an in-person event but also available as a virtual offer</li></ul>What will this do for you?You won&rsquo;t have to continue to rely on hope and luck as a strategy to achieve success. We will work on all the aspects that are introduced in The DEI Playbook to:<ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Give you the tools to help you make the most effective decisions</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Show how you can implement changes that are long-lasting</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Provide practical guidance and support x1 individual support and implementation session (more sessions can be added for a bonus fee after the main event)</li></ul>This solution&nbsp;is developed by licensed and accredited practitioners with practical business experience.

On completion, a certificate of attendance will be issued to all participants towards CPD (Continuous Professional Development).

This masterclass is designed to provide a practical application of the content that is covered within The DEI Playbook including:
A deep dive into the six steps of the DEI framework 
DEI Strategy
Leadership commitment
Recruitment and hiring of diverse talent
Inclusive performance management
Equitable and inclusive organisational culture
Marketplace and community impact
Measuring DEI using a scorecard
ISO audit - how to prepare for and conduct it
The success factors of inclusive culture change
A change communications toolkit
Project management techniques and best practice
Who is this learning for?
Diversity and inclusion leads and practitioners
HR professionals tasked with diversity and inclusion within their remit
Managers and leaders looking to develop an inclusive culture
What type of learning is this?
Small group learning allows lots of time to focus on the 'doing' as well as on learning
Global cohorts so there is a greater opportunity to learn in a cross-cultural context
Action learning so you can ask questions, engage with others and get feedback in the moment
Facilitated as an in-person event but also available as a virtual offer
What will this do for you?
You won’t have to continue to rely on hope and luck as a strategy to achieve success. We will work on all the aspects that are introduced in The DEI Playbook to:
Give you the tools to help you make the most effective decisions
Show how you can implement long-lasting changes
Provide practical guidance and support x1 individual support and implementation session (more sessions can be added for a bonus fee after the main event)
This solution is developed by licensed and accredited practitioners with practical business experience.
On completion, a certificate of attendance will be issued to all participants towards CPD (Continuous Professional Development).

Starling

Equity & Diversity

Leadership

Leadership Development

Organizational Development

Diversity & Inclusion

This one day masterclass is designed to provide a practical application of the content that is covered within The DEI Playbook and is aimed at anyone tasked with launching and implementing diversity and inclusion within their organisation. 

DEI Masterclass - Bringing The DEI Playbook To Life!

DEI Masterclass ticket

<div id="course-pills-1">Duration3 Days18 CPD hoursThis course is intended forThis course is intended for IT professionals who need to manage the day-to-day environment of an SCCM 2012 SP1 or newer environment. Knowledge of the workings of a standalone primary SCCM site and basic PowerShell experience is recommended.OverviewCreate additional site system roles on existing or new servers. Modify high level site settings. Create and modify Discovery Methods, Boundaries and Boundary Groups. Create Collections using any of the membership rules available. Delegate authority through Roles and Scopes. Install the Configuration Manager client, modify client settings and restrict access to site systems. Deploy software to clients. Deploy software updates to clients. Configure compliance settings targeted against collections. Modify settings that govern monitoring functions such as Alerts and Status Settings. Work with Task Sequences for Operating System Deployment. Write basic PowerShell scripts using cmdlets learned and scripting constructs to accomplish configuration tasks.This course provides students with the knowledge and skills needed to use PowerShell for System Center Configuration Manager (SCCM) administration. In this course, students learn how to access the PowerShell cmdlets included with SCCM 2012 R2 and use them to perform configuration tasks for a primary site. Individual cmdlets will be used in working with objects such as Boundaries, Boundary Groups, Collections, Software Deployment, Patching, Compliance Settings, OSD Task Sequences, and many others. Basic scripting will also be covered so that students can learn how to put PowerShell to use when working with large sets of objects.Prerequisites<li>Basic Windows and Active Directory knowledge. </li><li>Conceptual knowledge of Configuration Manager objects and how they interact. </li><li>Basic experience performing configuration tasks in ECM using the graphical console. </li><li>Experience working from a command prompt. </li><li>Basic knowledge of the fundamentals of Windows PowerShell.</li></div><div id="course-pills-2"><h3>1 - REVIEW OF SYSTEM CENTER CONFIGURATION MANAGER CONCEPTS</h3> <ul> <li>Architecture of an System Center 2012 Configuration Manager Installation</li> <li>Managing Assets</li> <li>Content Delivery and Management</li> <li>Security, Monitoring, and Remote Management</li> </ul> <h3>2 - MANAGING RESOURCES</h3> <ul> <li>Implementing Discovery</li> <li>Organizing Resources with Collections</li> <li>Working with Boundaries</li> </ul> <h3>3 - WORKING WITH CLIENTS</h3> <ul> <li>Installing the Configuration Manager Client</li> <li>Managing Client Settings</li> <li>Managing Client Operations</li> <li>Monitoring Client Status</li> </ul> <h3>4 - DISTRIBUTING SOFTWARE</h3> <ul> <li>Configure the Software Distribution Components</li> <li>Working with Distribution Points</li> <li>Creating Content for Distribution</li> <li>Deploying Software Applications</li> </ul> <h3>5 - UPDATING SYSTEMS WITH WSUS AND SCCM</h3> <ul> <li>Integrating Configuration Manager and WSUS</li> <li>Managing Updates through Software Update Groups</li> <li>Creating and Deploying Update Packages</li> <li>Working with Automatic Deployment Rules</li> </ul> <h3>6 - HOW POWERSHELL CAN MANAGE COMPLIANCE SETTINGS</h3> <ul> <li>Creating Compliance Settings Objects</li> <li>Deploying and Monitor the Baseline</li> </ul> <h3>7 - CONFIGURING OPERATING SYSTEM DEPLOYMENT OBJECTS</h3> <ul> <li>Preparing the OSD Environment</li> <li>Working with Task Sequences</li> </ul> <h3>8 - WORKING AT THE SITE LEVEL</h3> <ul> <li>Modify the Site</li> <li>Adding Site System Roles</li> <li>Adding a Secondary Site</li> </ul> <h3>9 - SECURITY AND MONITORING</h3> <ul> <li>Configuring Role Based Administration</li> <li>Implementing Endpoint Protection</li> <li>Configuring Monitoring Options</li> </ul> <h3>10 - USING POWERSHELL SCRIPTING TO AUTOMATE SCCM TASKS</h3> <ul> <li>Review of Scripting Constructs</li> <li>Introduction to the Configuration Manager WMI Classes</li> </ul></div>

Duration
3 Days
18 CPD hours
This course is intended for
This course is intended for IT professionals who need to manage the day-to-day environment of an SCCM 2012 SP1 or newer environment. Knowledge of the workings of a standalone primary SCCM site and basic PowerShell experience is recommended.
Overview
Create additional site system roles on existing or new servers. Modify high level site settings. Create and modify Discovery Methods, Boundaries and Boundary Groups. Create Collections using any of the membership rules available. Delegate authority through Roles and Scopes. Install the Configuration Manager client, modify client settings and restrict access to site systems. Deploy software to clients. Deploy software updates to clients. Configure compliance settings targeted against collections. Modify settings that govern monitoring functions such as Alerts and Status Settings. Work with Task Sequences for Operating System Deployment. Write basic PowerShell scripts using cmdlets learned and scripting constructs to accomplish configuration tasks.
This course provides students with the knowledge and skills needed to use PowerShell for System Center Configuration Manager (SCCM) administration. In this course, students learn how to access the PowerShell cmdlets included with SCCM 2012 R2 and use them to perform configuration tasks for a primary site. Individual cmdlets will be used in working with objects such as Boundaries, Boundary Groups, Collections, Software Deployment, Patching, Compliance Settings, OSD Task Sequences, and many others. Basic scripting will also be covered so that students can learn how to put PowerShell to use when working with large sets of objects.
Prerequisites

Basic Windows and Active Directory knowledge.
Conceptual knowledge of Configuration Manager objects and how they interact.
Basic experience performing configuration tasks in ECM using the graphical console.
Experience working from a command prompt.
Basic knowledge of the fundamentals of Windows PowerShell.
1 - REVIEW OF SYSTEM CENTER CONFIGURATION MANAGER CONCEPTS
Architecture of an System Center 2012 Configuration Manager Installation
Managing Assets
Content Delivery and Management
Security, Monitoring, and Remote Management
2 - MANAGING RESOURCES
Implementing Discovery
Organizing Resources with Collections
Working with Boundaries
3 - WORKING WITH CLIENTS
Installing the Configuration Manager Client
Managing Client Settings
Managing Client Operations
Monitoring Client Status
4 - DISTRIBUTING SOFTWARE
Configure the Software Distribution Components
Working with Distribution Points
Creating Content for Distribution
Deploying Software Applications
5 - UPDATING SYSTEMS WITH WSUS AND SCCM
Integrating Configuration Manager and WSUS
Managing Updates through Software Update Groups
Creating and Deploying Update Packages
Working with Automatic Deployment Rules
6 - HOW POWERSHELL CAN MANAGE COMPLIANCE SETTINGS
Creating Compliance Settings Objects
Deploying and Monitor the Baseline
7 - CONFIGURING OPERATING SYSTEM DEPLOYMENT OBJECTS
Preparing the OSD Environment
Working with Task Sequences
8 - WORKING AT THE SITE LEVEL
Modify the Site
Adding Site System Roles
Adding a Secondary Site
9 - SECURITY AND MONITORING
Configuring Role Based Administration
Implementing Endpoint Protection
Configuring Monitoring Options
10 - USING POWERSHELL SCRIPTING TO AUTOMATE SCCM TASKS
Review of Scripting Constructs
Introduction to the Configuration Manager WMI Classes

Microsoft Certification

Sccm

Microsoft Certified Technology Specialist (MCTS)

Microsoft SC-100

Commercial & Contract Management Certification Program (CCM)

Microsoft SC-200

55133 PowerShell for System Center Configuration Manager Administrators

<div id="course-pills-1">Duration2 Days12 CPD hoursThis course is intended forThis course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4> Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.</div>

Duration
2 Days
12 CPD hours
This course is intended for

This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.


This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

1 - Introduction to Transact-SQL
Work with schemas
Explore the structure of SQL statements
Examine the SELECT statement
Work with data types
Handle NULLs
2 - Sort and filter results in T-SQL
Sort your results
Limit the sorted results
Page results
Remove duplicates
Filter data with predicates
3 - Combine multiple tables with JOINs in T-SQL
Understand joins concepts and syntax
Use inner joins
Use outer joins
Use cross joins
Use self joins
4 - Write Subqueries in T-SQL
Understand subqueries
Use scalar or multi-valued subqueries
Use self-contained or correlated subqueries
5 - Use built-in functions and GROUP BY in Transact-SQL
Categorize built-in functions
Use scalar functions
Use ranking and rowset functions
Use aggregate functions
Summarize data with GROUP BY
Filter groups with HAVING
6 - Modify data with T-SQL
Insert data
Generate automatic values
Update data
Delete data
Merge data based on multiple tables
Additional course details:
Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. 

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

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

While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

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


Learning & Development

Design & Technology Courses (DT)

Trainers Course

Microsoft AZ-303

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

When it comes to designing our dream future, there are a few &nbsp;aspects to be considered...Firstly, amongst the chaos, how often do we actually create space to think about what we genuinely want for ourselves?And then when we do, are they our own desires, or someone else&#39;s?Vision boards help you to gain clarity&nbsp;on what you truly want from lifeI will teach you to&nbsp;connect&nbsp;back in with your&nbsp;core values,&nbsp;an overview behind&nbsp;manifestation&nbsp;and how our early life experiences may have impacted us now (positively and negatively).<ul style="color: rgb(37, 46, 57); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><li fr-original-style="" style="box-sizing: border-box;">Experience a short meditation to clear and open the mind</li><li fr-original-style="" style="box-sizing: border-box;">Identify your big dreams and goals, your values and how this aligns with your identity and purpose.</li><li fr-original-style="" style="box-sizing: border-box;">Create your unique vision board from scratch.</li></ul>The Workshop will be a hybrid of meditation, fun and networking helping you to connect back in with who you truly are, your centre of creativity, and visualise your dream life.This is for you if you say yes to one or more of the following:<ul style="color: rgb(37, 46, 57); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><li fr-original-style="" style="box-sizing: border-box;">you are ready to explore what you want from life</li><li fr-original-style="" style="box-sizing: border-box;">you feel stuck and uninspired</li><li fr-original-style="" style="box-sizing: border-box;">you have a vision, but you want to have a daily reminder of your dreams and goals</li><li fr-original-style="" style="box-sizing: border-box;">you want to manifest your vision or dream life quicker</li><li fr-original-style="" style="box-sizing: border-box;">you would like to passionately connect with your goals and dreams</li><li fr-original-style="" style="box-sizing: border-box;">you would like to connect with your sacral chakra and instil some creativity into your energy</li></ul>Are you ready to create the life that lights you up? Resources required:&nbsp;Everyone: Notepad + pen, quiet space for reflection.&nbsp;If you know you definitely want to create your Vision Board on your Computer, then please come ready with access to Microsoft word or Canva. &nbsp;Otherwise (and this is my favourite way to start a vision board experience), you will also need;Access to images that you can cut out. &nbsp;Here are some ideas on building your portfolio of images:<ul style="color: rgb(37, 46, 57); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><li fr-original-style="" style="box-sizing: border-box;">buy your favourite magazine/ ask around your friends/ family if you can have it rather than being thrown away</li><li fr-original-style="" style="box-sizing: border-box;">local supermarkets that offer their free magazine</li><li fr-original-style="" style="box-sizing: border-box;">travel agents&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">keep hold of local magazines/ newspapers/ flyers dropped through the door</li><li fr-original-style="" style="box-sizing: border-box;">photos that you don&#39;t mind cutting up</li><li fr-original-style="" style="box-sizing: border-box;">celebratory cards</li></ul>Please also have access to A3 card (you can buy these from craft stores) ; scissors, glue.You can go super creative here as much as you would like; feathers, sparkle. you could even connect with the outdoors if you know how to preseve your items.&nbsp;

When it comes to designing our dream future, there are a few aspects to be considered...
Firstly, amongst the chaos, how often do we actually create space to think about what we genuinely want for ourselves?
And then when we do, are they our own desires, or someone else's?
Vision boards help you to gain clarity on what you truly want from life
I will teach you to connect back in with your core values, an overview behind manifestation and how our early life experiences may have impacted us now (positively and negatively).
Experience a short meditation to clear and open the mind
Identify your big dreams and goals, your values and how this aligns with your identity and purpose.
Create your unique vision board from scratch.
The Workshop will be a hybrid of meditation, fun and networking helping you to connect back in with who you truly are, your centre of creativity, and visualise your dream life.
This is for you if you say yes to one or more of the following:
you are ready to explore what you want from life
you feel stuck and uninspired
you have a vision, but you want to have a daily reminder of your dreams and goals
you want to manifest your vision or dream life quicker
you would like to passionately connect with your goals and dreams
you would like to connect with your sacral chakra and instil some creativity into your energy
Are you ready to create the life that lights you up?


Resources required: 
Everyone: Notepad + pen, quiet space for reflection. 

If you know you definitely want to create your Vision Board on your Computer, then please come ready with access to Microsoft word or Canva. 

Otherwise (and this is my favourite way to start a vision board experience), you will also need;

Access to images that you can cut out. Here are some ideas on building your portfolio of images:
buy your favourite magazine/ ask around your friends/ family if you can have it rather than being thrown away
local supermarkets that offer their free magazine
travel agents
keep hold of local magazines/ newspapers/ flyers dropped through the door
photos that you don't mind cutting up
celebratory cards

Please also have access to A3 card (you can buy these from craft stores) ; scissors, glue.

You can go super creative here as much as you would like; feathers, sparkle. you could even connect with the outdoors if you know how to preseve your items. 

Sinéad Robertson

Personal Development

Mindfulness

Life Coaching

Manifestation & Law of Attraction

Meditation

Creative Therapy

𝐃𝐢𝐝 𝐘𝐨𝐮 𝐤𝐧𝐨𝐰?
😍Vision Boards improves your chance of success! 
Here's just a few benefits from the process of vision boarding ⤵️
🔸 Helps you to connect with what you truly want from life;
🔸 Shift your mindset;
🔸 Provides a tool to align and focus your goals
And are a great opportunity to meet new and like minded people!
I'm looking forward to hosting this vision board workshop with you.  
🙏🏻Give me a shout if you have any questions.

16835 Other courses delivered Online

Communication Skills 1 Day Virtual Live Training in Portsmouth

By Mangates

Communication Skills 1 Day Virtual Live Training in Leicester

By Mangates

Communication Skills 1 Day Virtual Live Training in Southampton

By Mangates

Communication Skills 1 Day Virtual Live Training in Preston

By Mangates

Communication Skills 1 Day Virtual Live Training in Watford

By Mangates

Communication Skills 1 Day Virtual Live Training in Brighton

By Mangates

Communication Skills 1 Day Virtual Live Training in Liverpool

By Mangates

Communication Skills 1 Day Virtual Live Training in Milton Keynes

By Mangates

Communication Skills 1 Day Virtual Live Training in Guildford

By Mangates

Communication Skills 1 Day Virtual Live Training in Windsor Town

By Mangates