Name: Microsoft Azure and 365 Bundle with 5 Exams (3 Certifications)
Price: 1395 GBP
Availability: InStock

York

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

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

Mangates

Communication Skills

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 Ipswich

Standard Fee

Early Bird Fee

Communication Skills 1 Day Virtual Live Training in Reading

Communication Skills 1 Day Virtual Live Training in Norwich

Communication Skills 1 Day Virtual Live Training in Newcastle

Communication Skills 1 Day Virtual Live Training in High Wycombe

Communication Skills 1 Day Virtual Live Training in Milton Keynes

Communication Skills 1 Day Virtual Live Training in Windsor Town

Communication Skills 1 Day Virtual Live Training in Kingston upon Hull

<p fr-original-style="" id="isPasted" style="font-size: 16px; color: var(--text); box-sizing: border-box;">The Microsoft Certified Fundamentals, Associate, and Expert is a new breed of Microsoft certification. It is referred to as a &lsquo;role-based certification&rsquo;. According to Microsoft, role-based certifications show that individuals that possess them are keeping pace with today&rsquo;s technical roles and requirements. They allow a learner to skill up and prove their expertise to employers and peers, plus get the recognition and opportunities they&rsquo;ve earned. </p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">One of three Microsoft certifications you can gain through this course bundle.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Microsoft role-based certifications cover three skill levels: 1. Fundamental, 2. Associate, and 3. Expert. Career paths include developer, administrator, devops, and solutions architect.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Microsoft claims that upon earning a certification, 23% of Microsoft certified technologists reported receiving up to a 20% salary increase. What&rsquo;s more, certified employees are often entrusted with supervising their peers, putting them on the fast track for a promotion.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Upon completion of this course, you&rsquo;ll receive one Microsoft Azure Fundamentals &lsquo;Acclaim&rsquo; badge, one Microsoft 365 Modern Desktop Administrator Associate &lsquo;Acclaim&rsquo; badge, and one Microsoft 365 Enterprise Administrator Expert &lsquo;Acclaim&rsquo; badge that you can add to your CV or social media profile for prospective employers and recruitment companies to see. You&rsquo;ll also receive three Microsoft certifications as shown above (1 x Microsoft Azure Fundamentals certification, 1 x Microsoft 365 Modern Desktop Associate certification, and 1 x Microsoft 365 Enterprise Administrator certification).</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What&rsquo;s included in this certification bundle?</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">This bundle contains three separate Microsoft certification courses, with the official Microsoft certification exams included &ndash; all of which are valid for 12 months from the time of enrolment. As part of this bundle, you will get access to a MeasureUP or Kaplan practice test for each certification course. This will help maximise your chances of passing the exams the first time.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Certification Courses Included:</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Certification 1: Microsoft Certified Azure Fundamentals</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">1. Azure Fundamentals (AZ-900)</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Certification 2: Microsoft 365 Certified Modern Desktop Administrator Associate</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">1. Windows 10 (MD-100)</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">2. Managing Modern Desktops (MD-101)</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Certification 3: Microsoft 365 Certified Enterprise Administrator Expert</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">1. Microsoft 365 Identity and Services (MS-100)</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">2. Microsoft 365 Mobility and Security (MS-101)</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Certification exams included:</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">AZ-900: Azure Fundamentals</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">MD-100: Windows 10</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">MD-101: Managing Modern Desktops</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">MS-100: Microsoft 365 Identity and Services</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">MS-101: Microsoft 365 Mobility and Security</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Live labs included:</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">AZ-900: Azure Fundamentals</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">MD-100: Windows 10</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">MD-101: Managing Modern Desktops</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Practice tests included:</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">AZ-900: Azure Fundamentals</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">MD-100: Windows 10 (includes live lab)</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">MD-101: Managing Modern Desktops</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">MS-100: Microsoft 365 Identity and Services</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">MS-101: Microsoft 365 Mobility and Security</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">How does this course bundle work?</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">This course bundle is made up of three main resources as shown below. Each certification course has as its own set of resources, i.e. 1 x course material, 1 x MeasureUP or Kaplan practice exam, 1 x official Microsoft exam. Each resource is designed to work in conjunction with each other to ensure the successful path to certification. You will complete one course and exam, then repeat the process for the remaining courses if you wish to gain the remaining certifications. Remember, this course bundle contains three separate Microsoft certifications. You only need to complete the exams in each certification course to gain that specific certification. Read below to learn more about the resources that make up this course.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;Video Learning</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Access to video based online learning material. Tutors use diagrams and illustrations to teach the classes, as well as giving demonstrations. Lessons are pre-recorded allowing you to &nbsp;fast-forward, rewind and pause at any time throughout the lessons. Videos can be viewed on different devices including a desktop computer, laptop, tablet, and smart phone.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;Live labs</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">The hands-on live labs allow you to experience practical application of course concepts in an authentic online environment 24/7, all from the comfort of your home or office. The lab environment allows you to test and apply your skills as you learn. These labs also come with tasks challenging what you have learnt. To learn more about practice labs, click here.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;MeasureUP Practice Exams</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">After working your way through each course, you should be ready to start revising for your official exams. To do this, we provide you with a MeasureUP or Kaplan practice test. MeasureUP are the official provider to Microsoft for practice tests. These are the closest experience to the actual exam you&rsquo;ll be taking. Scroll down to learn more about MeasureUP and the practice tests.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;Official Microsoft Exams</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Having confidently passed the practice tests, you will be ready to sit the official Microsoft exams &ndash; which we will book on your behalf. These are known as an &lsquo;online, web-proctored exams&rsquo;. This means they can be taken at home. One of the requirements of taking these exams is that you must have a web camera so a proctor can observe you during the exams. This is to ensure no cheating takes place.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">How long will it take me to complete each course?</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">This is dependent on several factors such as your level of experience of the subject matter, the amount of time you can dedicate to the course each week, and how quickly you absorb information. Learners can finish a single course from anywhere between 1-3 months. You will have full access to the resources for 12 months and must take your exams within this period.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What do I need?</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">This course is online and accessible 24/7. You can do it from any where in the world, any time of the day providing you have an internet connection. No apps are required to access the course resources. You simply do it from your browser. For the best user experience, we recommend Google Chrome.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">MeasureUP practice tests</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">As part of this course, you will get access to MeasureUP practice tests to help prepare you for the Microsoft exams as part of this bundle. MeasureUP practice tests are endorsed by Microsoft and used as the official practice tests of Microsoft certification exams.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Features of MeasureUP practice tests:</strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Questions are similar to exam questions, allowing you to test your knowledge of exam objectives</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Detailed explanations for both correct and distractor answers reinforce the material</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">&lsquo;Study Mode&rsquo; covers all objectives ensuring topics are covered</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">&lsquo;Certification Mode&rsquo; (timed) prepares students for exam taking conditions</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Instant, drill-down score reports tell you exactly the areas to focus on</p>

The Microsoft Certified Fundamentals, Associate, and Expert is a new breed of Microsoft certification. It is referred to as a ‘role-based certification’. According to Microsoft, role-based certifications show that individuals that possess them are keeping pace with today’s technical roles and requirements. They allow a learner to skill up and prove their expertise to employers and peers, plus get the recognition and opportunities they’ve earned. 
One of three Microsoft certifications you can gain through this course bundle.
Microsoft role-based certifications cover three skill levels: 1. Fundamental, 2. Associate, and 3. Expert. Career paths include developer, administrator, devops, and solutions architect.
Microsoft claims that upon earning a certification, 23% of Microsoft certified technologists reported receiving up to a 20% salary increase. What’s more, certified employees are often entrusted with supervising their peers, putting them on the fast track for a promotion.
 
Upon completion of this course, you’ll receive one Microsoft Azure Fundamentals ‘Acclaim’ badge, one Microsoft 365 Modern Desktop Administrator Associate ‘Acclaim’ badge, and one Microsoft 365 Enterprise Administrator Expert ‘Acclaim’ badge that you can add to your CV or social media profile for prospective employers and recruitment companies to see. You’ll also receive three Microsoft certifications as shown above (1 x Microsoft Azure Fundamentals certification, 1 x Microsoft 365 Modern Desktop Associate certification, and 1 x Microsoft 365 Enterprise Administrator certification).
What’s included in this certification bundle?
This bundle contains three separate Microsoft certification courses, with the official Microsoft certification exams included – all of which are valid for 12 months from the time of enrolment. As part of this bundle, you will get access to a MeasureUP or Kaplan practice test for each certification course. This will help maximise your chances of passing the exams the first time.
 
Certification Courses Included:
Certification 1: Microsoft Certified Azure Fundamentals
1. Azure Fundamentals (AZ-900)
Certification 2: Microsoft 365 Certified Modern Desktop Administrator Associate
1. Windows 10 (MD-100)
2. Managing Modern Desktops (MD-101)
Certification 3: Microsoft 365 Certified Enterprise Administrator Expert
1. Microsoft 365 Identity and Services (MS-100)
2. Microsoft 365 Mobility and Security (MS-101)


Certification exams included:
AZ-900: Azure Fundamentals
MD-100: Windows 10
MD-101: Managing Modern Desktops
MS-100: Microsoft 365 Identity and Services
MS-101: Microsoft 365 Mobility and Security
 
Live labs included:
AZ-900: Azure Fundamentals
MD-100: Windows 10
MD-101: Managing Modern Desktops
 
Practice tests included:
AZ-900: Azure Fundamentals
MD-100: Windows 10 (includes live lab)
MD-101: Managing Modern Desktops
MS-100: Microsoft 365 Identity and Services
MS-101: Microsoft 365 Mobility and Security
 
How does this course bundle work?
 
This course bundle is made up of three main resources as shown below. Each certification course has as its own set of resources, i.e. 1 x course material, 1 x MeasureUP or Kaplan practice exam, 1 x official Microsoft exam. Each resource is designed to work in conjunction with each other to ensure the successful path to certification. You will complete one course and exam, then repeat the process for the remaining courses if you wish to gain the remaining certifications. Remember, this course bundle contains three separate Microsoft certifications. You only need to complete the exams in each certification course to gain that specific certification. Read below to learn more about the resources that make up this course.
 
 Video Learning
 
Access to video based online learning material. Tutors use diagrams and illustrations to teach the classes, as well as giving demonstrations. Lessons are pre-recorded allowing you to fast-forward, rewind and pause at any time throughout the lessons. Videos can be viewed on different devices including a desktop computer, laptop, tablet, and smart phone.
 
 Live labs
The hands-on live labs allow you to experience practical application of course concepts in an authentic online environment 24/7, all from the comfort of your home or office. The lab environment allows you to test and apply your skills as you learn. These labs also come with tasks challenging what you have learnt. To learn more about practice labs, click here.
 
 MeasureUP Practice Exams
 
After working your way through each course, you should be ready to start revising for your official exams. To do this, we provide you with a MeasureUP or Kaplan practice test. MeasureUP are the official provider to Microsoft for practice tests. These are the closest experience to the actual exam you’ll be taking. Scroll down to learn more about MeasureUP and the practice tests.
 
 Official Microsoft Exams
 
Having confidently passed the practice tests, you will be ready to sit the official Microsoft exams – which we will book on your behalf. These are known as an ‘online, web-proctored exams’. This means they can be taken at home. One of the requirements of taking these exams is that you must have a web camera so a proctor can observe you during the exams. This is to ensure no cheating takes place.


How long will it take me to complete each course?


This is dependent on several factors such as your level of experience of the subject matter, the amount of time you can dedicate to the course each week, and how quickly you absorb information. Learners can finish a single course from anywhere between 1-3 months. You will have full access to the resources for 12 months and must take your exams within this period.


 
What do I need?
 
This course is online and accessible 24/7. You can do it from any where in the world, any time of the day providing you have an internet connection. No apps are required to access the course resources. You simply do it from your browser. For the best user experience, we recommend Google Chrome.


MeasureUP practice tests
 
As part of this course, you will get access to MeasureUP practice tests to help prepare you for the Microsoft exams as part of this bundle. MeasureUP practice tests are endorsed by Microsoft and used as the official practice tests of Microsoft certification exams.
 
Features of MeasureUP practice tests:


Questions are similar to exam questions, allowing you to test your knowledge of exam objectives
Detailed explanations for both correct and distractor answers reinforce the material
‘Study Mode’ covers all objectives ensuring topics are covered
‘Certification Mode’ (timed) prepares students for exam taking conditions
Instant, drill-down score reports tell you exactly the areas to focus on

Hudson

Microsoft

The Microsoft Certified Fundamentals, Associate, and Expert is a new breed of Microsoft certification. It is referred to as a ‘role-based certification’. According to Microsoft, role-based certifications show that individuals that possess them are keeping pace with today’s technical roles and requirements. They allow a learner to skill up and prove their expertise to employers and peers, plus get the recognition and opportunities they’ve earned

Microsoft Azure and 365 Bundle with 5 Exams (3 Certifications)

General admission

Mastering Compliance and Safety on the Road
This essential 7 hours course is designed to equip professional drivers with the knowledge and skills necessary to comply with complex driving regulations and ensure safe loading practices.
Key areas covered include:
Drivers’ Hours and Working Time Regulations: Gain a comprehensive understanding of driving and rest periods, breaks, and exemptions to avoid penalties and ensure driver well-being.
Tachograph Regulations: Learn how to correctly use and interpret analog and digital tachographs to accurately record driving activities and comply with legal requirements.
Course format: Online. 
Invest in your professional development and become a safer, more compliant driver.


Total Compliance 

Driver CPC - 1 Day Periodic 7 Hour Course - Driver Hours / Tachograph 

General Admission

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Real Estate Financial Modelling School (5 days)</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The school combines three of our courses:</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate 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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">All of the courses are interlinked to give you a full understanding of the subject using Excel.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you will&hellip;</strong></strong></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this school?</strong></strong></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day One</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Analyst I</em></em></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.</em></em></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Two</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Analyst II</em></em></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.</em></em></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Three</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Investor I</em></em></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Four</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Investor II</em></em></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Five</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Modelling Masterclass</em></em></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <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></p>



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

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 16px;">Who should attend?<br fr-original-style="" style="box-sizing: border-box;"></span></strong>DSLs, DDSLs, Headteachers, Pastoral Leads, Safeguarding Governors.<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong><br fr-original-style="" style="box-sizing: border-box;"></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Join us for an insightful masterclass that delves into the profound effects of neglect on a child&#39;s life. This session is meticulously designed for professionals working closely with children in various educational settings, providing essential knowledge and practical tools to identify, manage, and seek support for neglected children.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learning Objectives</strong><br fr-original-style="" style="box-sizing: border-box;"></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This Masterclass will enable you to:</p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understand the Lifelong Impact: Gain insights into the long-term consequences of neglect on a child&#39;s development.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Spot the Signs: Learn to recognise the subtle signs and symptoms, including the often overlooked affluent neglect.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Explore Affluent Neglect: Uncover the impactful nature of affluent neglect and its effects on a child&#39;s life.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Combat Disguised Compliance: Grasp the harmful nature of disguised compliance and its implications for a child&#39;s wellbeing.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Apply Knowledge: Equip yourself with practical skills through realistic scenarios and learn how to respond effectively.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Access Support Systems: Discover the use of neglect toolkits to inform your practice and decision-making.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Seek Support for the Child: Learn where and how to access support when dealing with neglect cases.</li></ul><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><a href="https://www.brightcoreconsultancy.com/brightcore-testimonials" target="_blank" style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); font-weight: bold; text-decoration: none; border-radius: 5px; background-color: rgb(61, 86, 224); border-width: 12px 18px; border-style: solid; border-color: rgb(61, 86, 224); display: inline-block; user-select: auto; box-sizing: border-box; cursor: pointer;" rel="noopener noreferrer" fr-original-style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: #ffffff; font-weight: bold; text-decoration: none; border-radius: 5px; background-color: #3D56E0; border-top: 12px solid #3D56E0; border-bottom: 12px solid #3D56E0; border-right: 18px solid #3D56E0; border-left: 18px solid #3D56E0; display: inline-block;">View all testimonials </a></p>

Who should attend?
DSLs, DDSLs, Headteachers, Pastoral Leads, Safeguarding Governors.

Overview

Join us for an insightful masterclass that delves into the profound effects of neglect on a child's life. This session is meticulously designed for professionals working closely with children in various educational settings, providing essential knowledge and practical tools to identify, manage, and seek support for neglected children.

Learning Objectives

This Masterclass will enable you to:
Understand the Lifelong Impact: Gain insights into the long-term consequences of neglect on a child's development.
Spot the Signs: Learn to recognise the subtle signs and symptoms, including the often overlooked affluent neglect.
Explore Affluent Neglect: Uncover the impactful nature of affluent neglect and its effects on a child's life.
Combat Disguised Compliance: Grasp the harmful nature of disguised compliance and its implications for a child's wellbeing.
Apply Knowledge: Equip yourself with practical skills through realistic scenarios and learn how to respond effectively.
Access Support Systems: Discover the use of neglect toolkits to inform your practice and decision-making.
Seek Support for the Child: Learn where and how to access support when dealing with neglect cases.
View all testimonials

Brightcore Consultancy

Child Safeguarding

Safeguarding

Join us for an insightful masterclass that delves into the profound effects of neglect on a child's life. This session is meticulously designed for professionals working closely with children in various educational settings, providing essential knowledge and practical tools to identify, manage, and seek support for neglected children.

Neglect: Recognising and Responding to the Impact on Children

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is designed for Administrators who need to setup, configure and manage SharePoint Online as part of their Office 365 Administration.</p>Overview<p>After completing this course, students will gain the skills to:  - Understand the architecture of SharePoint Online  - Have knowledge of all the components in SharePoint Online  - Have on hands on experience configuring the components of SharePoint Online  - Have hands on experience configuring the options  - Work with Site Collections and storage options  - Manage user profiles and social profiling  - Understand and configure data connectivity in SharePoint Online  - Build a taxonomy structure   - Understand and configure Search in SharePoint Online  - Configure and deploy apps  - Understand and define Enterprise content management and data loss prevention.  - Configure additional options and features in SharePoint Online such as Information Rights Management</p><p>This course will introduce the audience to SharePoint Online Administration in Office 365 and explain and demonstrate the configuration options for SharePoint Online. The course is appropriate for existing SharePoint on-premises administrators and new administrators to Office 365 who need to understand how to correctly setup SharePoint Online for their company. The course will also help SharePoint on-premise administrators understand the differences between SharePoint on-premises and SharePoint Online.</p></div><div id="course-pills-2"><h3>1 - INTRODUCTION TO OFFICE 365 AND SHAREPOINT ONLINE</h3> <ul> <li>Introduction to the Office 365 Administration Center</li> <li>Configure Reporting</li> <li>Accessing SharePoint management tools</li> <li>Accessing security and compliancy</li> <li>Managing Office 365 and SharePoint Online with PowerShell</li> <li>Comparing On Premises SharePoint with SharePoint Online</li> <li>User identity in Office 365 and SharePoint Online</li> <li>Manging user domains</li> <li>Building Hybrid scenarios</li> <li>OneDrive and Sites redirection</li> <li>Yammer redirection</li> <li>Understand hybrid search</li> <li>Hybrid business data connectivity</li> <li>Hybrid taxonomy</li> </ul> <h3>2 - WORKING WITH SITE COLLECTIONS</h3> <ul> <li>Introduction to classic and modern admin centers</li> <li>Creating Site Collections</li> <li>Defining ownership and security for site collections</li> <li>Configuring Storage</li> <li>Configure External Access to site collections</li> <li>Recovering site collections</li> <li>Configure external sharing</li> <li>Managing site collections with PowerShell</li> </ul> <h3>3 - MANAGING USER PROFILES</h3> <ul> <li>Overview of the profile service</li> <li>Defining profile properties</li> <li>Map profile properties to a term store</li> <li>Creating custom profile properties</li> <li>Managing audiences</li> <li>Creating audiences</li> <li>Managing user profile policies</li> <li>Configure trusted my site host locations</li> <li>Configure preferred search center locations</li> <li>Defining read access permission levels</li> <li>Configuring newsfeed options</li> <li>Setup email notifications</li> <li>Configure my site cleanup</li> </ul> <h3>4 - WORKING WITH DATA CONNECTIONS</h3> <ul> <li>Introduction to Data Connections</li> <li>Overview of PowerApps, Flow and PowerBi</li> <li>Overview of the business connectivity service</li> <li>Introduction to BDC definition files</li> <li>Creating BDC definition files</li> <li>Introduction to the secure store service</li> <li>Configuring the secure store service</li> <li>Creating secure store target application settings</li> <li>Configure connections to cloud services</li> <li>Configure connections to on-premises services</li> <li>Tools to build data connections</li> <li>Creating external content types</li> <li>Building external lists using external data</li> </ul> <h3>5 - MANAGING THE TERM STORE</h3> <ul> <li>Overview of the term store</li> <li>Understanding terms and life cycle management</li> <li>Creating term groups</li> <li>Creating the term store</li> <li>Creating Term Sets in the UI</li> <li>Creating Term Sets via importing via a CSV</li> <li>Creating terms in the UI</li> <li>Creating terms via PowerShell and CSOM</li> <li>Manage terms with synonyms and pinning</li> <li>Configure delegated administration</li> </ul> <h3>6 - CONFIGURING SEARCH</h3> <ul> <li>An Introduction to the search service</li> <li>Classic versus Modern search experience</li> <li>Understanding Managed Properties</li> <li>Create Managed Properties</li> <li>Manage Authoritative pages</li> <li>Understand Result sources</li> <li>Create and configure result sources</li> <li>Understand Query rules</li> <li>Promoting results through query rules</li> <li>Remove search results from the index</li> <li>Exporting search configurations</li> <li>Importing search configurations</li> </ul> <h3>7 - CONFIGURING APPS</h3> <ul> <li>An Introduction to Apps</li> <li>Understanding the App Catalog</li> <li>Building the App catalog</li> <li>Adding Apps to the catalog</li> <li>Add Apps to your SharePoint sites</li> <li>Adding Apps via the marketplace store</li> <li>Manage App licensing</li> <li>Configure store access settings</li> <li>Monitoring app usage</li> </ul> <h3>8 - ENTERPRISE CONTENT MANAGEMENT IN SHAREPOINT ONLINE</h3> <ul> <li>An Introduction to ECM in SharePoint Online</li> <li>Components of ECM</li> <li>Office 365 versus classic compliancy</li> <li>Understanding In-Place records management</li> <li>Configure In-Place records management</li> <li>Understanding the records center</li> <li>Build and configure a records center</li> <li>Understanding the compliancy policy center</li> <li>Build a compliancy policy center and configure policies</li> <li>Discover the security and compliancy center</li> <li>Configure an eDiscovery center</li> <li>Build an eDiscovery case</li> <li>Understand data loss prevention</li> <li>Build a data loss prevention policy and query</li> <li>Working with classification and data governance</li> </ul> <h3>9 - MANAGE OPTIONS FOR SHAREPOINT ONLINE</h3> <ul> <li>Configure OneDrive features</li> <li>Configure use of Yammer or Newsfeeds</li> <li>Understand Information Rights Management</li> <li>Configure Information Rights Management</li> <li>Define site classification options</li> <li>Understand early release options for Office 365</li> <li>Configure Early release options for your Office 365 tenant</li> <li>Manage Access Control</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55238 SharePoint Online for Administrators training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the 55238 SharePoint Online for Administrators course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Duration
3 Days
18 CPD hours
This course is intended for
This course is designed for Administrators who need to setup, configure and manage SharePoint Online as part of their Office 365 Administration.
Overview
After completing this course, students will gain the skills to: - Understand the architecture of SharePoint Online - Have knowledge of all the components in SharePoint Online - Have on hands on experience configuring the components of SharePoint Online - Have hands on experience configuring the options - Work with Site Collections and storage options - Manage user profiles and social profiling - Understand and configure data connectivity in SharePoint Online - Build a taxonomy structure - Understand and configure Search in SharePoint Online - Configure and deploy apps - Understand and define Enterprise content management and data loss prevention. - Configure additional options and features in SharePoint Online such as Information Rights Management
This course will introduce the audience to SharePoint Online Administration in Office 365 and explain and demonstrate the configuration options for SharePoint Online. The course is appropriate for existing SharePoint on-premises administrators and new administrators to Office 365 who need to understand how to correctly setup SharePoint Online for their company. The course will also help SharePoint on-premise administrators understand the differences between SharePoint on-premises and SharePoint Online.
1 - INTRODUCTION TO OFFICE 365 AND SHAREPOINT ONLINE
Introduction to the Office 365 Administration Center
Configure Reporting
Accessing SharePoint management tools
Accessing security and compliancy
Managing Office 365 and SharePoint Online with PowerShell
Comparing On Premises SharePoint with SharePoint Online
User identity in Office 365 and SharePoint Online
Manging user domains
Building Hybrid scenarios
OneDrive and Sites redirection
Yammer redirection
Understand hybrid search
Hybrid business data connectivity
Hybrid taxonomy
2 - WORKING WITH SITE COLLECTIONS
Introduction to classic and modern admin centers
Creating Site Collections
Defining ownership and security for site collections
Configuring Storage
Configure External Access to site collections
Recovering site collections
Configure external sharing
Managing site collections with PowerShell
3 - MANAGING USER PROFILES
Overview of the profile service
Defining profile properties
Map profile properties to a term store
Creating custom profile properties
Managing audiences
Creating audiences
Managing user profile policies
Configure trusted my site host locations
Configure preferred search center locations
Defining read access permission levels
Configuring newsfeed options
Setup email notifications
Configure my site cleanup
4 - WORKING WITH DATA CONNECTIONS
Introduction to Data Connections
Overview of PowerApps, Flow and PowerBi
Overview of the business connectivity service
Introduction to BDC definition files
Creating BDC definition files
Introduction to the secure store service
Configuring the secure store service
Creating secure store target application settings
Configure connections to cloud services
Configure connections to on-premises services
Tools to build data connections
Creating external content types
Building external lists using external data
5 - MANAGING THE TERM STORE
Overview of the term store
Understanding terms and life cycle management
Creating term groups
Creating the term store
Creating Term Sets in the UI
Creating Term Sets via importing via a CSV
Creating terms in the UI
Creating terms via PowerShell and CSOM
Manage terms with synonyms and pinning
Configure delegated administration
6 - CONFIGURING SEARCH
An Introduction to the search service
Classic versus Modern search experience
Understanding Managed Properties
Create Managed Properties
Manage Authoritative pages
Understand Result sources
Create and configure result sources
Understand Query rules
Promoting results through query rules
Remove search results from the index
Exporting search configurations
Importing search configurations
7 - CONFIGURING APPS
An Introduction to Apps
Understanding the App Catalog
Building the App catalog
Adding Apps to the catalog
Add Apps to your SharePoint sites
Adding Apps via the marketplace store
Manage App licensing
Configure store access settings
Monitoring app usage
8 - ENTERPRISE CONTENT MANAGEMENT IN SHAREPOINT ONLINE
An Introduction to ECM in SharePoint Online
Components of ECM
Office 365 versus classic compliancy
Understanding In-Place records management
Configure In-Place records management
Understanding the records center
Build and configure a records center
Understanding the compliancy policy center
Build a compliancy policy center and configure policies
Discover the security and compliancy center
Configure an eDiscovery center
Build an eDiscovery case
Understand data loss prevention
Build a data loss prevention policy and query
Working with classification and data governance
9 - MANAGE OPTIONS FOR SHAREPOINT ONLINE
Configure OneDrive features
Configure use of Yammer or Newsfeeds
Understand Information Rights Management
Configure Information Rights Management
Define site classification options
Understand early release options for Office 365
Configure Early release options for your Office 365 tenant
Manage Access Control
Additional course details:
Nexus Humans 55238 SharePoint Online for Administrators 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 55238 SharePoint Online for Administrators course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

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


Nexus Human

Microsoft Certification

Microsoft Sharepoint

Microsoft 365

Microsoft AZ-104

SharePoint

Microsoft AZ-303

55238 SharePoint Online for Administrators

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p><p>This three-day instructor-led course is aimed at modern device management professionals looking to manage their enterprise devices using Microsoft Intune. This course will cover Enrolment, Application Management, Endpoint Security and Windows Autopilot as well as Azure Active Directory Conditional Access and Identity Protection. The delegates will learn how to enroll devices, deploy applications and manage them to maximize user productivity and device security.</p></div><div id="course-pills-2"><h3>1: Introduction to Microsoft Intune</h3> <ul> <li> Mobile Device Management</li> <li>Microsoft Intune</li> <li> Azure Active Directory</li> <li>AAD Identity Protection</li> <li> AAD Conditional Access</li></ul>  <h3>2: Microsoft Intune Device Management</h3><ul> <li>Enrolling Devices</li> <li> Device Compliance</li> <li> Device Profiles</li> <li>Device Updates</li></ul>  <h3>3: Microsoft Intune Application Management</h3><ul> <li> Application Management</li> <li> Deploying Applications</li> <li> Application Configuration</li> <li> Managing Applications</li> <li> Policy Sets and Guided Scenarios</li></ul>  <h3>4: Microsoft Intune Endpoint Security</h3><ul> <li> Security Baselines and tasks</li> <li> Antivirus</li> <li>Disk Encryption</li> <li>Firewall</li> <li>Atack Surface reduction</li> <li> Endpoint detection and response</li> <li> Account Protection</li></ul>  <h3>5: Deploying Windows with Windows Autopilot</h3><ul> <li> Windows Autopilot overview</li> <li> Preparing for Windows Autopilot deployment</li> <li>Deploying Windows 11 using Windows Autopilot</li></ul>  <h3>6: Microsoft Intune Additional and Premium Features</h3><ul> <li> Remote Help</li> <li> Tunnel for Mobile Application Management</li> <li>Endpoint Privilege Management</li> <li> Advanced Endpoint Analytics</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55399 Implementing and Managing Microsoft Intune training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the 55399 Implementing and Managing Microsoft Intune course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Duration
3 Days
18 CPD hours
This three-day instructor-led course is aimed at modern device management professionals looking to manage their enterprise devices using Microsoft Intune. This course will cover Enrolment, Application Management, Endpoint Security and Windows Autopilot as well as Azure Active Directory Conditional Access and Identity Protection. The delegates will learn how to enroll devices, deploy applications and manage them to maximize user productivity and device security.
1: Introduction to Microsoft Intune
Mobile Device Management
Microsoft Intune
Azure Active Directory
AAD Identity Protection
AAD Conditional Access
2: Microsoft Intune Device Management
Enrolling Devices
Device Compliance
Device Profiles
Device Updates
3: Microsoft Intune Application Management
Application Management
Deploying Applications
Application Configuration
Managing Applications
Policy Sets and Guided Scenarios
4: Microsoft Intune Endpoint Security
Security Baselines and tasks
Antivirus
Disk Encryption
Firewall
Atack Surface reduction
Endpoint detection and response
Account Protection
5: Deploying Windows with Windows Autopilot
Windows Autopilot overview
Preparing for Windows Autopilot deployment
Deploying Windows 11 using Windows Autopilot
6: Microsoft Intune Additional and Premium Features
Remote Help
Tunnel for Mobile Application Management
Endpoint Privilege Management
Advanced Endpoint Analytics
Additional course details:
Nexus Humans 55399 Implementing and Managing Microsoft Intune 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 55399 Implementing and Managing Microsoft Intune 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.


Microsoft AZ-900

Microsoft Certified Trainer (MCT)

Manager Training

Trainers Course

Microsoft AZ-700

55399 Implementing and Managing Microsoft Intune

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p></p><p>The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.</p><p></p><p></p><p>This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.</p><p></p>Prerequisites<p></p><li>Understanding core data concepts.</li>  <li>Knowledge of working with relational data in the cloud.</li>  <li>Knowledge of working with non-relational data in the cloud.</li>   <li>Knowledge of data analysis and visualization concepts.</li>   <li>DP-900T00 Microsoft Azure Data Fundamentals is recommended<p></p></li></div><div id="course-pills-2"><h3>1 - Discover data analysis</h3> <ul> <li>Overview of data analysis</li> <li>Roles in data</li> <li>Tasks of a data analyst</li> </ul> <h3>2 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>3 - Get data in Power BI</h3> <ul> <li>Get data from files</li> <li>Get data from relational data sources</li> <li>Create dynamic reports with parameters</li> <li>Get data from a NoSQL database</li> <li>Get data from online services</li> <li>Select a storage mode</li> <li>Get data from Azure Analysis Services</li> <li>Fix performance issues</li> <li>Resolve data import errors</li> </ul> <h3>4 - Clean, transform, and load data in Power BI</h3> <ul> <li>Shape the initial data</li> <li>Simplify the data structure</li> <li>Evaluate and change column data types</li> <li>Combine multiple tables into a single table</li> <li>Profile data in Power BI</li> <li>Use Advanced Editor to modify M code</li> </ul> <h3>5 - Design a semantic model in Power BI</h3> <ul> <li>Work with tables</li> <li>Create a date table</li> <li>Work with dimensions</li> <li>Define data granularity</li> <li>Work with relationships and cardinality</li> <li>Resolve modeling challenges</li> </ul> <h3>6 - Add measures to Power BI Desktop models</h3> <ul> <li>Create simple measures</li> <li>Create compound measures</li> <li>Create quick measures</li> <li>Compare calculated columns with measures</li> </ul> <h3>7 - Add calculated tables and columns to Power BI Desktop models</h3> <ul> <li>Create calculated columns</li> <li>Learn about row context</li> <li>Choose a technique to add a column</li> </ul> <h3>8 - Use DAX time intelligence functions in Power BI Desktop models</h3> <ul> <li>Use DAX time intelligence functions</li> <li>Additional time intelligence calculations</li> </ul> <h3>9 - Optimize a model for performance in Power BI</h3> <ul> <li>Review performance of measures, relationships, and visuals</li> <li>Use variables to improve performance and troubleshooting</li> <li>Reduce cardinality</li> <li>Optimize DirectQuery models with table level storage</li> <li>Create and manage aggregations</li> </ul> <h3>10 - Design Power BI reports</h3> <ul> <li>Design the analytical report layout</li> <li>Design visually appealing reports</li> <li>Report objects</li> <li>Select report visuals</li> <li>Select report visuals to suit the report layout</li> <li>Format and configure visualizations</li> <li>Work with key performance indicators</li> </ul> <h3>11 - Configure Power BI report filters</h3> <ul> <li>Apply filters to the report structure</li> <li>Apply filters with slicers</li> <li>Design reports with advanced filtering techniques</li> <li>Consumption-time filtering</li> <li>Select report filter techniques</li> <li>Case study - Configure report filters based on feedback</li> </ul> <h3>12 - Enhance Power BI report designs for the user experience</h3> <ul> <li>Design reports to show details</li> <li>Design reports to highlight values</li> <li>Design reports that behave like apps</li> <li>Work with bookmarks</li> <li>Design reports for navigation</li> <li>Work with visual headers</li> <li>Design reports with built-in assistance</li> <li>Tune report performance</li> <li>Optimize reports for mobile use</li> </ul> <h3>13 - Perform analytics in Power BI</h3> <ul> <li>Explore statistical summary</li> <li>Identify outliers with Power BI visuals</li> <li>Group and bin data for analysis</li> <li>Apply clustering techniques</li> <li>Conduct time series analysis</li> <li>Use the Analyze feature</li> <li>Create what-if parameters</li> <li>Use specialized visuals</li> </ul> <h3>14 - Create and manage workspaces in Power BI</h3> <ul> <li>Distribute a report or dashboard</li> <li>Monitor usage and performance</li> <li>Recommend a development life cycle strategy</li> <li>Troubleshoot data by viewing its lineage</li> <li>Configure data protection</li> </ul> <h3>15 - Manage semantic models in Power BI</h3> <ul> <li>Use a Power BI gateway to connect to on-premises data sources</li> <li>Configure a semantic model scheduled refresh</li> <li>Configure incremental refresh settings</li> <li>Manage and promote semantic models</li> <li>Troubleshoot service connectivity</li> <li>Boost performance with query caching (Premium)</li> </ul> <h3>16 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>17 - Implement row-level security</h3> <ul> <li>Configure row-level security with the static method</li> <li>Configure row-level security with the dynamic method</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-300T00: Microsoft Power BI Data Analyst training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the PL-300T00: Microsoft Power BI Data Analyst course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Duration
3 Days
18 CPD hours
This course is intended for

The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.


This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

Prerequisites

Understanding core data concepts.
Knowledge of working with relational data in the cloud.
Knowledge of working with non-relational data in the cloud.
Knowledge of data analysis and visualization concepts.
DP-900T00 Microsoft Azure Data Fundamentals is recommended
1 - Discover data analysis
Overview of data analysis
Roles in data
Tasks of a data analyst
2 - Get started building with Power BI
Use Power BI
Building blocks of Power BI
Tour and use the Power BI service
3 - Get data in Power BI
Get data from files
Get data from relational data sources
Create dynamic reports with parameters
Get data from a NoSQL database
Get data from online services
Select a storage mode
Get data from Azure Analysis Services
Fix performance issues
Resolve data import errors
4 - Clean, transform, and load data in Power BI
Shape the initial data
Simplify the data structure
Evaluate and change column data types
Combine multiple tables into a single table
Profile data in Power BI
Use Advanced Editor to modify M code
5 - Design a semantic model in Power BI
Work with tables
Create a date table
Work with dimensions
Define data granularity
Work with relationships and cardinality
Resolve modeling challenges
6 - Add measures to Power BI Desktop models
Create simple measures
Create compound measures
Create quick measures
Compare calculated columns with measures
7 - Add calculated tables and columns to Power BI Desktop models
Create calculated columns
Learn about row context
Choose a technique to add a column
8 - Use DAX time intelligence functions in Power BI Desktop models
Use DAX time intelligence functions
Additional time intelligence calculations
9 - Optimize a model for performance in Power BI
Review performance of measures, relationships, and visuals
Use variables to improve performance and troubleshooting
Reduce cardinality
Optimize DirectQuery models with table level storage
Create and manage aggregations
10 - Design Power BI reports
Design the analytical report layout
Design visually appealing reports
Report objects
Select report visuals
Select report visuals to suit the report layout
Format and configure visualizations
Work with key performance indicators
11 - Configure Power BI report filters
Apply filters to the report structure
Apply filters with slicers
Design reports with advanced filtering techniques
Consumption-time filtering
Select report filter techniques
Case study - Configure report filters based on feedback
12 - Enhance Power BI report designs for the user experience
Design reports to show details
Design reports to highlight values
Design reports that behave like apps
Work with bookmarks
Design reports for navigation
Work with visual headers
Design reports with built-in assistance
Tune report performance
Optimize reports for mobile use
13 - Perform analytics in Power BI
Explore statistical summary
Identify outliers with Power BI visuals
Group and bin data for analysis
Apply clustering techniques
Conduct time series analysis
Use the Analyze feature
Create what-if parameters
Use specialized visuals
14 - Create and manage workspaces in Power BI
Distribute a report or dashboard
Monitor usage and performance
Recommend a development life cycle strategy
Troubleshoot data by viewing its lineage
Configure data protection
15 - Manage semantic models in Power BI
Use a Power BI gateway to connect to on-premises data sources
Configure a semantic model scheduled refresh
Configure incremental refresh settings
Manage and promote semantic models
Troubleshoot service connectivity
Boost performance with query caching (Premium)
16 - Create dashboards in Power BI
Configure data alerts
Explore data by asking questions
Review Quick insights
Add a dashboard theme
Pin a live report page to a dashboard
Configure a real-time dashboard
Set mobile view
17 - Implement row-level security
Configure row-level security with the static method
Configure row-level security with the dynamic method
Additional course details:
Nexus Humans PL-300T00: Microsoft Power BI Data Analyst 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 PL-300T00: Microsoft Power BI Data Analyst 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.


Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Microsoft Power Platform

Microsoft BI

Data Analyst

PL-300T00 Microsoft Power BI Data Analyst

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>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.</p>Overview<p>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.</p><p>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.</p>Prerequisites<p></p><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.<p></p></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

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">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>The CompTIA Cloud Essentials+ Specialty certification is relevant to IT specialists, IT technical services specialists, IT relationship managers, IT architects, consultants, business and IT management, business process owners, and analysts.</p>Overview<p>Upon successful completion of this course, students will be able to:  Learn the fundamental concepts of cloud computing.  Learn the business aspects and impact of cloud computing.  Differentiate the types of cloud solutions and the adoption measures needed for each.  Identify the technical challenges and the mitigation measures involved in cloud computing.  Identify the steps to successfully adopt cloud services.  Identify the basic concepts of ITIL and describe how the ITIL framework is useful in the implementation of cloud computing in an organization.  Identify the possible risks involved in cloud computing and the risk mitigation measures, and you will also identify the potential cost considerations for the implementation of cloud and its strategic benefits.</p><p>Students will weigh the pros and cons of cloud computing to make effective decisions and meet IT challenges.</p></div><div id="course-pills-2"><h3>1 - Understanding Cloud Computing Concepts</h3> <ul> <li>Topic A: Understand Basic Cloud Concepts and Terms</li> <li>Topic B: Identify Cloud Network and Cloud Storage Technologies</li> <li>Topic C: Recognize Cloud Design Aspects</li> </ul> <h3>2 - Applying Cloud Business Principles</h3> <ul> <li>Topic A: Relate Cloud Concepts to Business Principles</li> <li>Topic B: Establish Cloud Vendor Relations</li> <li>Topic C: Distinguish the Financial Aspects of Engaging a Cloud Service Provider</li> <li>Topic D: Report Financial Expenditures</li> </ul> <h3>3 - Advising a Cloud Design and Migration</h3> <ul> <li>Topic A: Relate Cloud Concepts to Cloud Design and Migration</li> <li>Topic B: Use Cloud Assessments</li> <li>Topic C: Manage Cloud Design</li> <li>Topic D: Compare Cloud Migration Approaches</li> <li>Topic E: Identify Benefits and Solutions of Cloud Services</li> </ul> <h3>4 - Operating in the Cloud</h3> <ul> <li>Topic A: Relate Cloud Concepts to Technical Operations</li> <li>Topic B: Identify the Technical Aspects of Cloud Operations</li> <li>Topic C: Understand DevOps in the Cloud</li> <li>Topic D: Explain Cloud Security Concerns, Measures, and Concepts</li> </ul> <h3>5 - Managing Cloud Governance</h3> <ul> <li>Topic A: Relate Cloud Concepts to Governance</li> <li>Topic B: Apply Risk Management Concepts</li> <li>Topic C: Understand Compliance and the Cloud</li> <li>Topic D: Manage Policies and Procedures for Cloud Services</li> </ul> <h3>6 - Appendix A: Mapping Course Content to the CompTIA Cloud Essentials+ (Exam CLO-002)</h3> <h3>7 - Appendix B: CompTIA Cloud Essentials+ (Exam CLO-002) Acronyms</h3> <h3>8 - Glossary</h3> <h3>9 - Index</h3></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CompTIA Cloud Essentials Plus Certification (Exam CLO-002) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the CompTIA Cloud Essentials Plus Certification (Exam CLO-002) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Duration
3 Days
18 CPD hours
This course is intended for
The CompTIA Cloud Essentials+ Specialty certification is relevant to IT specialists, IT technical services specialists, IT relationship managers, IT architects, consultants, business and IT management, business process owners, and analysts.
Overview
Upon successful completion of this course, students will be able to: Learn the fundamental concepts of cloud computing. Learn the business aspects and impact of cloud computing. Differentiate the types of cloud solutions and the adoption measures needed for each. Identify the technical challenges and the mitigation measures involved in cloud computing. Identify the steps to successfully adopt cloud services. Identify the basic concepts of ITIL and describe how the ITIL framework is useful in the implementation of cloud computing in an organization. Identify the possible risks involved in cloud computing and the risk mitigation measures, and you will also identify the potential cost considerations for the implementation of cloud and its strategic benefits.
Students will weigh the pros and cons of cloud computing to make effective decisions and meet IT challenges.
1 - Understanding Cloud Computing Concepts
Topic A: Understand Basic Cloud Concepts and Terms
Topic B: Identify Cloud Network and Cloud Storage Technologies
Topic C: Recognize Cloud Design Aspects
2 - Applying Cloud Business Principles
Topic A: Relate Cloud Concepts to Business Principles
Topic B: Establish Cloud Vendor Relations
Topic C: Distinguish the Financial Aspects of Engaging a Cloud Service Provider
Topic D: Report Financial Expenditures
3 - Advising a Cloud Design and Migration
Topic A: Relate Cloud Concepts to Cloud Design and Migration
Topic B: Use Cloud Assessments
Topic C: Manage Cloud Design
Topic D: Compare Cloud Migration Approaches
Topic E: Identify Benefits and Solutions of Cloud Services
4 - Operating in the Cloud
Topic A: Relate Cloud Concepts to Technical Operations
Topic B: Identify the Technical Aspects of Cloud Operations
Topic C: Understand DevOps in the Cloud
Topic D: Explain Cloud Security Concerns, Measures, and Concepts
5 - Managing Cloud Governance
Topic A: Relate Cloud Concepts to Governance
Topic B: Apply Risk Management Concepts
Topic C: Understand Compliance and the Cloud
Topic D: Manage Policies and Procedures for Cloud Services
6 - Appendix A: Mapping Course Content to the CompTIA Cloud Essentials+ (Exam CLO-002)
7 - Appendix B: CompTIA Cloud Essentials+ (Exam CLO-002) Acronyms
8 - Glossary
9 - Index
Additional course details:
Nexus Humans CompTIA Cloud Essentials Plus Certification (Exam CLO-002) 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 CompTIA Cloud Essentials Plus Certification (Exam CLO-002) 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.


CompTIA Network+

IT Certifications

AWS Certified Cloud Practitioner

Cisco Certified Entry Networking Technician (CCENT)

CompTIA A+

CompTIA Security+

CompTIA Cloud Essentials+

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>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.</p><p></p><p></p><p>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.</p><p></p></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><br /><p>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. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the 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.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

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

Data Skills

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

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

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

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This expert-led training course will provide you with a comprehensive understanding of the role of the designated governor for mental health and wellbeing. You will gain the skills and confidence n<span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">eeded to help your governing body to ensure that there is a consistent and effective whole-school approach to mental health and wellbeing in place in your school / college.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Delivered live-online by one of our mental health experts, the course will allow you to learn in a live real-time environment, with a range of discussion points, activities, and Q&amp;A session to ensure that you are able to complete the training with a clear understanding of the role of governance as part of the whole school/college approach.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">It is based on the following statutory and non-statutory guidance documents:</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The DfE&rsquo;s Governance guidance (2024)</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Keeping Children Safe in Education (2024)</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Promoting Children and Young People&#39;s Mental Health and Wellbeing (2021)</li></ul><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Mental Health and Behaviour in Schools (2018)</span><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learning Objectives</strong><br fr-original-style="" style="box-sizing: border-box;"></span></p>

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">This course will enable you to:</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understand the requirements of the role of the governor for mental health and wellbeing and the importance of prioritising the mental health and wellbeing of both pupils and staff in your setting.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Develop your knowledge of what an effective whole school/college approach to mental health and wellbeing looks like, which includes effective prevention.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understand the role of the Designated Senior Mental Health Lead, and how best to support, scrutinise and challenge them in the development of an effective whole school / college approach.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understand the importance of embedding a culture of wellbeing for staff as well as pupils</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understand the importance of developing an effective curriculum to promote good mental health and wellbeing.</span></li></ul><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><a href="https://www.brightcoreconsultancy.com/brightcore-testimonials" target="_blank" style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); font-weight: bold; text-decoration: none; border-radius: 5px; background-color: rgb(61, 86, 224); border-width: 12px 18px; border-style: solid; border-color: rgb(61, 86, 224); display: inline-block; user-select: auto; box-sizing: border-box; cursor: pointer;" rel="noopener noreferrer" fr-original-style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: #ffffff; font-weight: bold; text-decoration: none; border-radius: 5px; background-color: #3D56E0; border-top: 12px solid #3D56E0; border-bottom: 12px solid #3D56E0; border-right: 18px solid #3D56E0; border-left: 18px solid #3D56E0; display: inline-block;">View all testimonials </a></p>

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

Overview

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

Learning Objectives

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

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

42555 Courses delivered Online

Communication Skills 1 Day Virtual Live Training in Ipswich

By Mangates

Communication Skills 1 Day Virtual Live Training in Reading

By Mangates

Communication Skills 1 Day Virtual Live Training in Norwich

By Mangates

Communication Skills 1 Day Virtual Live Training in Newcastle

By Mangates

Communication Skills 1 Day Virtual Live Training in High Wycombe

By Mangates

Communication Skills 1 Day Virtual Live Training in Milton Keynes

By Mangates

Communication Skills 1 Day Virtual Live Training in Windsor Town

By Mangates

Communication Skills 1 Day Virtual Live Training in Windsor Town

By Mangates

Communication Skills 1 Day Virtual Live Training in Kingston upon Hull

By Mangates

Microsoft Azure and 365 Bundle with 5 Exams (3 Certifications)

By Hudson