The Teachers Training

Master Microsoft Office 2016 with our comprehensive course tailored for beginners. Learn essential skills in Word, Excel, PowerPoint, and more to boost your productivity and efficiency. Perfect for beginners looking to enhance their proficiency in office software. Enroll now and unlock the full potential of Microsoft Office!

Microsoft Office 2016 Complete Course For Beginners

General Admission

<p>Are you ready to take your photography skills to the next level? Our Mastering Digital Photography Diploma will equip you with the knowledge and techniques to excel in street photography. With modules covering everything from creating visual reports to using PowerQuery to restructure your data, this comprehensive course is perfect for anyone looking to upskill in this exciting field. Learn from industry experts and take your street photography to new heights with our Mastering Digital Photography Diploma.</p><p><strong>Learning outcomes:</strong></p><ul><li>Create compelling visual reports using PowerBI</li><li>Import and manipulate data from multiple sources</li><li>Utilize advanced visualization techniques such as map visuals and decomposition trees</li><li>Calculate percentages and create custom calculations</li><li>Use slicers to analyze and filter data</li><li>Organize data by year, quarter, or month for effective reporting</li></ul><ul><li>Getting Results with PowerBI</li><li>Module 01: Tour of the screen</li><li>Module 02: Pulling in your data from different sources</li><li>Module 03: Creating your first Visual</li><li>Module 04: Building a visual from 2 tables</li><li>Module 05: Slicers</li><li>Module 06: Making a Combo Chart Visual</li><li>Module 07: Using PowerQuery to restructure the data</li><li>Module 08: Creating Map Visuals</li><li>Module 09: Creating a report by Year, Qtr, or Month</li><li>Module 10: Calculating % of total</li><li>Module 11: Creating your own Calculation</li><li>Module 12: Decomposition Tree Visual</li><li>Module 13: Pulling it all together</li></ul><p><strong>How is the course assessed?</strong></p><p>Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%.</p><p><strong>Exam &amp; Retakes:</strong><br />It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.</p><p><strong>Certification</strong><br />Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        10 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>There are no formal entry requirements for the course, with enrollment open to anyone!</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Freelance Street Photographer (£20,000 - £50,000)</li><li>Photography Assistant (£16,000 - £24,000)</li><li>Social Media Content Creator (£18,000 - £35,000)</li><li>Digital Marketing Specialist (£25,000 - £40,000)</li><li>Graphic Designer (£20,000 - £35,000)</li><li>Photojournalist (£18,000 - £35,000)</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            £9
        </p>
            <div> <p>You can apply for a CPD Accredited PDF Certificate at the cost of £9.</p> </div>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            £15
        </p>
            <div> <p>Hard copy can be sent to you via post at the expense of £15.</p> </div>

                        </div>

One Education

Getting Results with PowerBI Course

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on </span><b><span>Self-publishing On Amazon with Canva Book Covers - For Beginners</span></b> will deepen your understanding on this topic.</p><p><span><span>After successful completion of this course you can acquire the required skills in this sector. This </span><b>Self-publishing On Amazon with Canva Book Covers - For Beginners</b> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</span></p><p><span><span>So enrol in this course today to fast track your career ladder.</span></span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>After successfully completing the course you will be able to order your certificate, these are included in the price.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this </span><b><span>Self-publishing On Amazon with Canva Book Covers - For Beginners</span></b>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our </span><b><span>Self-publishing On Amazon with Canva Book Covers - For Beginners</span></b> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p><span><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>8 sections • 31 lectures • 04:25:00 total length</p></div><div><div><div><div><div><div><div><p>•Self-publishing Process: 00:07:00</p></div><div><div><p>•Course Requirements: What is a Finished Manuscript: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Fundamentals of Book Cover Design: 00:09:00</p></div><div><div><p>•Addendum: Book Cover Design and Download JPG/PNG: 00:05:00</p></div><div><div><p>•Using Free Canva Themes and Pixabay Images to Create a Book Cover: 00:13:00</p></div><div><div><p>•Canva From a Blank Page Up: 00:08:00</p></div><div><div><p>•Canva Advanced Techniques: 00:12:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Self-publishing Options: 00:04:00</p></div><div><div><p>•Traditional Document Formatting Part 1: 00:11:00</p></div><div><div><p>•Traditional Document Formatting Part 2: 00:11:00</p></div><div><div><p>•Install the Kindle Create Microsoft Word Plugin: 00:04:00</p></div><div><div><p>•Format Your Manuscript Using Kindle Create: 00:11:00</p></div><div><div><p>•More Formatting, Table of Contents and Preview: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Publish Your Book in Kindle Format Using KDP: 00:15:00</p></div><div><div><p>•Copywrite Your Amazon Book Description: 00:09:00</p></div><div><div><p>•Publish Your Book in Print on Demand (POD) Paperback Format Using KDP: 00:04:00</p></div><div><div><p>•Book Review Process, Approval and Monitoring: 00:03:00</p></div><div><div><p>•Addendum: Creating a Paperback Book Cover in KDP: 00:12:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•10 Book Marketing Tips (Part 1): 00:12:00</p></div><div><div><p>•10 Book Marketing Tips (Part 2): 00:10:00</p></div><div><div><p>•Additional Book Marketing Tips: 00:07:00</p></div><div><div><p>•Websites, Mailing Lists, Amazon Bestseller Categories, Author Central, GoodReads: 00:14:00</p></div><div><div><p>•Update on KDP Select Free Promotions (7/20/2018): 00:06:00</p></div><div><div><p>•Update on KDP Select Free Promotions (8/24/2018): 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create a Free Book Cover Using the GIMP: 00:17:00</p></div><div><div><p>•Create a Free Book Cover Using PowerPoint: 00:12:00</p></div><div><div><p>•Create a Free Book Cover Using Canva: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create a Free Book Cover Using Canva/Pixabay: 00:14:00</p></div><div><div><p>•Format Your Manuscript (Traditional) Part 1: 00:01:00</p></div><div><div><p>•Format Your Manuscript (Traditional) Part 2: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Bonus Lecture: What's Next?: 00:03:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Apex Learning

Online Course Marketing

Online Course Creation

Self-Publishing

Book Marketing

Amazon Kindle Direct Publishing

Canva

Self-publishing On Amazon with Canva Book Covers - For Beginners

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on <b>Windows 10 Pro Complete Training</b> will deepen your understanding on this topic.</span></p><p><span>After successful completion of this course you can acquire the required skills in this sector. This <b>Windows 10 Pro Complete Training</b> comes with accredited certification, which will enhance your CV and make you worthy in the job market.</span></p><p><span>So enrol in this course today to fast track your career ladder.</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this <b>Windows 10 Pro Complete Training</b>. It is available to all students, of all academic backgrounds.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our <b>Windows 10 Pro Complete Training</b> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</span></p><p><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span lang="EN-GB">Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management, Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc.</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>11 sections • 43 lectures • 04:21:00 total length</p></div><div><div><div><div><div><div><div><p>•Course Overview: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Easily download ISO Images: 00:10:00</p></div><div><div><p>•Lab - Creating a Virtual Install of Windows 10 Pro Using VirtualBox: 00:16:00</p></div><div><div><p>•Lab - Create Virtual Install of Server 2016 Full GUI Using VirtualBox: 00:13:00</p></div><div><div><p>•Taking a Snapshot of Your Current configuration: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Perform a Windows 10 Upgrade for Free: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Preparing Your Network for Active Directory: 00:10:00</p></div><div><div><p>•Lab - Prepare Server 2016 for Promotion to a Domain Controller: 00:10:00</p></div><div><div><p>•Lab - Promote Server 2016 to a Domain Controller: 00:09:00</p></div><div><div><p>•Lab - Join a Windows 10 Workstation to a Microsoft Domain: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Installing WDS on a Windows Server Using VirtualBox: 00:18:00</p></div><div><div><p>•Deploy a Windows 10 Client Using WDS: 00:09:00</p></div><div><div><p>•lab - Create an Unattended Install of Windows 10 Pro: 00:17:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Turn the Windows 10 Firewall Off or On: 00:01:00</p></div><div><div><p>•Allow an app through the Windows 10 firewall: 00:05:00</p></div><div><div><p>•Add a rule or port to a Windows 10 firewall: 00:05:00</p></div><div><div><p>•Allow PING for Windows 10: 00:04:00</p></div><div><div><p>•Disable the UAC User Account Control in Windows 10: 00:02:00</p></div><div><div><p>•Using netsh to Manage the Windows Firewall: 00:05:00</p></div><div><div><p>•Using Powershell to Gather Firewall Information: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Change your IP address in Windows 10: 00:05:00</p></div><div><div><p>•Add a second IP address in Windows 10: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Enable System Restore on Windows 10: 00:03:00</p></div><div><div><p>•Create a System Restore point on Windows 10: 00:02:00</p></div><div><div><p>•Recover using System Restore on Windows 10: 00:04:00</p></div><div><div><p>•Fix TCPIP Corruption in Windows 10 Using Netsh: 00:02:00</p></div><div><div><p>•Repair Windows 10 with System File Checker (SFC): 00:03:00</p></div><div><div><p>•Repair Windows 10 System files offline Using SFC: 00:04:00</p></div><div><div><p>•Use ReadyBoost to Speed up Windows 10: 00:05:00</p></div><div><div><p>•Reset Your Network Adapter: 00:06:00</p></div><div><div><p>•Lab - Troubleshooting Internet Connectivity: 00:16:00</p></div><div><div><p>•NSLookup: 00:05:00</p></div><div><div><p>•Windows Reliability Monitor: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Disable the Lock Screen on Windows 10: 00:03:00</p></div><div><div><p>•Disable Superfetch via Windows Services: 00:03:00</p></div><div><div><p>•Disable Screen Saver in Windows 10 using REGEDIT: 00:02:00</p></div><div><div><p>•Disable Windows 10 Automatic Logoff For Inactivity: 00:02:00</p></div><div><div><p>•Overview of the Windows 10 Shutdown and Restart buttons: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Rename your Windows 10 computer: 00:01:00</p></div><div><div><p>•Change the date and time in Windows 10: 00:03:00</p></div><div><div><p>•Create a new local user in Windows 10: 00:04:00</p></div><div><div><p>•Rearm the 30-day evaluation Period for Windows 10 Pro: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - Windows 10 Pro Complete Training: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Microsoft Certification

Windows 10

IT Certifications

Computer Skills

Microsoft Certified Trainer (MCT)

Trainers Course

Windows 10 Pro Complete Training

<p>The Microsoft Office industry offers a wealth of exciting opportunities for individuals with proficiency in its suite of applications. As businesses increasingly rely on digital tools for productivity and communication, the demand for skilled Microsoft Office specialist (MOS) is soaring. Whether you are a recent graduate, a career changer, or a seasoned professional, mastering Excel, Word, Access, and PowerPoint opens doors to a diverse range of roles.</p><p>From administrative positions to data analysts and project managers to executive assistants, the applications' versatility caters to various job functions. Moreover, with the constant evolution of Microsoft Office, staying up-to-date with the latest features and functionalities ensures continued relevance and competitiveness in the job market. Enrol in our comprehensive Microsoft Office Specialist (MOS) course today, and seize the abundant opportunities waiting for you in the dynamic world of Microsoft Office. Step forward into a future of professional success and growth!</p><p><strong>Learning Outcomes:</strong></p><p>By completing the Microsoft Office Specialist (MOS) course, you will:</p><ul><li>Gain proficiency in Excel, Word, PowerPoint, and Access.</li><li>Perform complex calculations and data analysis in Excel.</li><li>Create professional documents with formatting and templates in Word.</li><li>Deliver dynamic presentations with visual impact using PowerPoint.</li><li>Manage data efficiently and build databases with Access.</li><li>Enhance productivity and increase career opportunities.</li></ul><p><strong>What will make you stand out?</strong></p><p>Upon completion of this online Microsoft Office Specialist (MOS) course, you will gain the following:</p><ul><li>CPD QS Accredited Microsoft Office Specialist (MOS) course.</li><li>After successfully completing the Microsoft Office Specialist (MOS) Course, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities.</li><li>Lifetime access to the whole collection of learning materials.</li><li>The online test with immediate results</li><li>You can study and complete the Microsoft Office Specialist (MOS) course at your own pace.</li><li>Study for the Microsoft Office Specialist (MOS) course using any internet-connected device, such as a computer, tablet, or mobile device.</li></ul><p>This comprehensive Microsoft Office Specialist (MOS) Training course provides an in-depth overview of the essential Microsoft Office applications - Excel, Word, Access, and PowerPoint. Learn the latest features, from performing calculations and formatting worksheets to creating captivating presentations and managing databases. With expert-led training and hands-on experience, you'll gain the proficiency needed to excel in the digital workplace. Stand out in the job market, boost productivity, and unlock opportunities with this indispensable Microsoft Office Specialist (MOS) training.</p><p><strong>Let's have a look at our Microsoft Office course curriculum:</strong></p><ul><li>Microsoft Excel 2019</li><li>Microsoft Excel 2019 New Features</li><li>Getting Started with Microsoft Excel</li><li>Performing Calculations</li><li>Modifying a Worksheet</li><li>Formatting a Worksheet</li><li>Printing Workbooks</li><li>Managing Workbooks</li><li>Microsoft Word 2019</li><li>Microsoft Word 2019 New Features</li><li>Getting Started with Word</li><li>Formatting Text and Paragraphs</li><li>Working More Efficiently</li><li>Managing Lists</li><li>Adding Tables</li><li>Inserting Graphic Objects</li><li>Controlling Page Appearance</li><li>Preparing to Publish a Document</li><li>Workbooks - Microsoft Word 2016 (Beginner)</li><li>Microsoft PowerPoint 2019</li><li>Microsoft PowerPoint 2019 New Features</li><li>PowerPoint Interface</li><li>Presentation Basics</li><li>Formatting</li><li>Inserting Options</li><li>Working with Objects</li><li>Table</li><li>Charts</li><li>Review and Presentation</li><li>Microsoft Access 2019</li><li>Microsoft Access 2019 New Features</li><li>Introduction to Access</li><li>Modify Data</li><li>Working with Queries</li><li>Access Forms</li><li>Working with Reports</li></ul><p>By completing the Microsoft Office Specialist (MOS) Bundle, you'll not only enhance your productivity but also become a sought-after professional in any industry. The Microsoft Office Specialist (MOS) Bundle is an investment in your future. It will help you improve your productivity, efficiency, and job skills. So what are you waiting for? Enroll today!</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        15 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>The Microsoft Office Specialists (MOS) course is suitable for the following:</p><ul><li>Professionals are seeking to enhance their Microsoft Office proficiency.</li><li>Students aim to develop essential academic skills.</li><li>Job seekers want to boost employability with Microsoft Office expertise.</li><li>Entrepreneurs and small business owners streamlining productivity.</li><li>Career changers are requiring Microsoft Office skills in new roles.</li><li>Individuals are looking to expand their digital literacy and stay ahead in today's world.</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>You can delightfully enrol in this Microsoft Office Specialist (MOS) course without any formal requirements.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>The Microsoft Office Specialist (MOS) course opens doors to various career paths, including:</p><ul><li>Administrative Assistant</li><li>Data Analyst</li><li>Marketing Specialist</li><li>Project Manager</li><li>Business Owner</li><li>Human Resources Manager</li><li>Researcher</li></ul>
                        </div>

NextGen Learning

Microsoft 365

Microsoft AZ-900

Microsoft Certified Solutions Associate (MCSA)

Microsoft Office

Microsoft AZ-104

Microsoft Office Specialist (MOS) - Microsoft Excel, Microsoft Word, Access & PowerPoint

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This course is intended for SQL Server administrators who work in a Windows network environment. At least one year of experience administering SQL Servers and using PowerShell is recommended.</p>Overview<p>After completing this course, students will be able to:<br />•Install and Configure SQL Server and all its components using PowerShell<br />•Manage day-to-day SQL Server Administration with PowerShell<br />•Maintain the SQL Server environment using PowerShell scripting and programming options</p><p>This course provides candidates with the knowledge and skills needed to use PowerShell for SQL Server administration. Students will learn how to manage day-to-day and scheduled maintenance tasks.<br /></p></div><div id="course-pills-2"><h4>Install and Configure SQL Server with PowerShell</h4><ul><li>Install SQL Server</li><li>Configure Database Settings</li><li>Configure SQL Server Settings</li><li>Configure SQL Server Policy-Based Management</li><li>Lab 1: Configuring SQL Server with PowerShell</li></ul><h4>Administering SQL Servers with PowerShell</h4><ul><li>Managing Users and Roles</li><li>Managing Database Performance</li><li>Managing Database Availability</li><li>Managing SQL Server Features </li><li>Lab 1: Administering SQL Servers with PowerShell</li></ul><h4>Maintaining SQL Server with PowerShell</h4><ul><li>Managing Backups and Restores</li><li>Maintaining Database Integrity and Performance</li><li>Monitoring and Auditing</li><li>Task Automation</li><li>Generating Reports</li><li>Lab 1: Maintaining SQL Servers with PowerShell</li></ul></div>

Nexus Human

Azure PowerShell

Powershell

SQL Server

Microsoft AZ-303

55069 PowerShell for SQL Server Administrators

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for an IT person wanting to learn about administrating SharePoint 2016.</p>Overview<p>After completing this course, you will be able to:<br />The Installation and configure a SharePoint 2016 Farm<br />How to manage a SharePoint 2016 Farm through the GUI and PowerShell<br />How to create site collections via GUI and PowerShell<br />How to create and configure the all the required service applications for SharePoint 2016<br />How to backup and restore in SharePoint 2016</p><p>This SharePoint 2016 Administrator course is design for Administrators who are new to SharePoint Server Administration or who are upgrading from previous versions of SharePoint.This course covers content that was in retired Microsoft Course 20339-1.</p></div><div id="course-pills-2"><h4>Module 1: Hardware, Installation and Patching</h4><ul><li>How to build a Min Role Farm</li><li>How to View ULS Logs</li><li>How to document and check IIS Settings for SharePoint 2016</li></ul><h4>Module 2: Farm Management</h4><ul><li>How to manage the SharePoint Farm Administors group</li><li>How to configure Outgoing Email</li><li>How to configure Incoming Email</li><li>How to Configure Diagnostic and Usage Log Options</li></ul><h4>Module 3: Web Applications</h4><ul><li>How to define a new Managed Account</li><li>How to add new IP Addresses to a SharePoint Server</li><li>How to create a claims based web application in SharePoint Central Administration</li><li>How to create a claims based web application in PowerShell</li><li>How to create a hosting web application in PowerShell</li></ul><h4>Module 4: Site Collections</h4><ul><li>How to create a managed path</li><li>How to create a site collection using SharePoint Central Administration</li><li>How to create a site collection using PowerShell</li><li>How to create a site collection in its own database using SharePoint Central Administration</li><li>How to create a site collection in its own database using PowerShell</li><li>How to create a host named site collection using PowerShell</li></ul><h4>Module 5: Service Applications</h4><ul><li>How to create a State Service Application</li><li>How to create a Search Service Application</li><li>How to create the Managed Metadate Service</li></ul><h4>Module 6: Application Management</h4><ul><li>How to add a new IP and Certificate to a SharePoint Web Application</li><li>How to configure DNS for SharePoint Web Application</li><li>How to Create a Subscription Settings Service Application</li><li>How to create the Application Management Application Service</li><li>How to configure the application URLs</li><li>How to create the App Catalog Site Colleciton</li><li>How to Add Apps to the catalog</li></ul><h4>Module 7: Managing the User Profile Service</h4><ul><li>How to create the My Site Web Application</li><li>How to create the User Profile Service Application</li><li>How to Configure the User Profile Synchronization Permissions</li><li>How to create the Active Directory Import Connection</li><li>How to assign permissions for the AD Group to create a My Site</li><li>How to create a My Site</li></ul><h4>Module 8: Search</h4><ul><li>How to view the currenty Search Topology</li><li>How to create an Enterprise Search Centre</li><li>How to configure a new search schema property</li><li>How to create a site collection-level result source</li><li>How to create a new content source</li></ul><h4>Module 9: Office Online Server</h4><ul><li>How to install the pre-requisites for Office Online Server</li><li>How to install the Office Online Server Binaries</li><li>How to create the Office Online Server SSL Certifcate</li><li>How to create the Office Online Server Farm</li><li>How to connect to the farm from SharePoint</li><li>How to test the connectivity</li></ul><h4>Module 10: Enterprise Content Management</h4><ul><li>How to create and Apply a site policy</li><li>How to create discovery sets</li><li>How to configure In Place records management</li><li>How to configure the records centre</li><li>How to configure DLP</li></ul><h4>Module 11: Web Content Management</h4><ul><li>How to configure cross-site publication</li><li>How to configure content deployment</li></ul><h4>Module 12: Workflow Server</h4><ul><li>How to install Workflow Manger server and Client Binaires</li><li>How to configure the workflow farm</li><li>How to patch the workflow farm manager and clients</li><li>How to register the workflow service in SharePoint</li><li>How to test Workflow creation</li></ul><h4>Module 13: Business Connectity Services and Secure Store</h4><ul><li>How to configure the secure store service</li><li>How to create the BCS service Application</li><li>How to setup the products database</li><li>How to import the BCS Definition</li><li>How to use the BDC file in a list web part</li></ul><h4>Module 14: Hybrid SharePoint</h4><ul><li>Shown and Demonstrated the Hybrid features of SharePoint 2016</li></ul><h4>Module 15: Backup and Restore</h4><ul><li>How to backup SharePoint 2016 Content</li><li>How to delete SharePoint 2016 Content</li><li>How to restore SharePoint 2016 Content via PowerShell</li><li>How to recover a unattached content database</li></ul><h4>Module 16: Upgrade</h4><ul><li>How to restore and attach a SharePoint 2013 Database</li><li>How to upgrade a SharePoint 2013 MMS Service Application</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55355 SharePoint 2016 Administration 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 55355 SharePoint 2016 Administration 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>

Microsoft Sharepoint

Microsoft Power Platform

SharePoint

55355 SharePoint 2016 Administration

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is intended for SharePoint administrators who work in a Windows network environment. At least one year of experience managing SharePoint servers and using PowerShell is recommended.</p>Overview<p>At Course Completion?Configure SharePoint Servers using PowerShell?Manage SharePoint Server Administration with PowerShell?Manage SharePoint Server Maintenance with PowerShell</p><p>This course provides students with the knowledge and skills needed to use PowerShell to administer SharePoint Servers. Students will learn how to manage day-to-day and automated tasks carried out by SharePoint Administrators.</p></div><div id="course-pills-2"><h4>Install and Configure SharePoint Servers with PowerShell</h4><ul><li>Overview</li><li>Preparing the Server</li><li>Configure Server Features</li><li>Configure Prerequisite Applications</li><li>Install SharePoint Software</li><li>Configure SharePoint Farm</li><li>Review</li><li>Lab 1: Configure SharePoint Servers with PowerShell</li></ul><h4>Administering SharePoint Servers with PowerShell</h4><ul><li>Overview</li><li>Administering Users and Groups</li><li>Administering the Farm</li><li>Administering Shared Services &amp; Features</li><li>Administering Sites</li><li>Administering Databases</li><li>Review</li><li>Lab 1: Administering SharePoint Servers with PowerShell</li></ul><h4>Maintaining SharePoint Servers with PowerShell</h4><ul><li>Overview</li><li>Managing Backups / Restores</li><li>Monitoring and Auditing</li><li>Managing Notifications</li><li>Scheduling Tasks</li><li>Review</li><li>Lab 1: Maintaining SharePoint Servers with PowerShell</li></ul></div>

55066 PowerShell for SharePoint Administrators

<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 experienced administrators with a background in either software development or system administration. Team leaders, lead developers, and other accidental Team Foundation Server administrators are also encouraged to take this course. This course will also help a student prepare for the relevant Microsoft certification exam.</p>Overview<p>At course completion, attendees will have had exposure to:<br />- TFS editions and components<br />- Supported topologies and environments<br />- Must-have TFS administration tools<br />- Hardware and software requirements<br />- Required service accounts and permissions<br />- Installing Team Foundation Server<br />- Configuring Team Foundation Server<br />- Managing relevant SQL Server components<br />- Managing relevant SharePoint components<br />- Installing and using Team Explorer<br />- Team project collections and team projects<br />- Using and customizing process templates<br />- TFS licensing and Client Access Licenses<br />- Connecting and using Microsoft Excel &amp; Project<br />- Installing and using Team Explorer Everywhere<br />- Integrating TFS and SharePoint<br />- Using the TFS web portal<br />- Git and TFVC version control systems<br />- Basic and advanced version control workflows<br />- Configuring and using code search<br />- Controlling access to version controlled items<br />- Command-line and third party tools<br />- Configuring automated builds<br />- Deploying and using Visual Studio agents<br />- Configuring agent pools and queues<br />- Creating and queuing automated builds<br />- Configuring Package Management<br />- Configuring Release Management<br />- Creating a release definition<br />- Creating and deploying a release<br />- Strategies for upgrading and migrating to TFS<br />- Integrating TFS with other systems and data<br />- High availability and scalability options<br />- Capacity planning and disaster recovery<br />- Backing up, restoring, and moving TFS data<br />- Managing the data warehouse<br />- Using PowerShell to manage TFS<br />- Customizing Team Foundation Server<br />- Extending Team Foundation Server</p><p>Provides students with the knowledge and skills to deploy, configure, and manage Microsoft Team Foundation Server 2019 and related software components.</p></div><div id="course-pills-2"><h4>Introduction to Team Foundation Server</h4><ul><li>Introduction to Team Foundation Server</li><li>Editions, components, and configurations</li><li>Visual Studio Team Services comparison</li><li>TFS' support of Application Lifecycle Management</li><li>TFS administrator responsibilities and tasks</li><li>?Must-have? tools of a TFS administrator</li></ul><h4>Planning and Deploying TFS</h4><ul><li>Planning the deployment</li><li>System requirements, software, and accounts</li><li>Installing and configuring TFS</li><li>Installing Team Explorer</li><li>Troubleshooting</li></ul><h4>Configuring TFS</h4><ul><li>Administrator roles and tools</li><li>Managing team project collections</li><li>Managing team projects</li><li>Managing process templates</li><li>Securing TFS, SharePoint, and SQL Server</li><li>Renaming and deleting a team project</li></ul><h4>Client Applications</h4><ul><li>TFS Client Access Licenses (CAL)</li><li>Team Explorer and the web portal</li><li>Microsoft Excel and Microsoft Project</li><li>SharePoint project portal</li><li>Team Explorer Everywhere</li><li>Command-line and 3rd party tools</li></ul><h4>Version Control</h4><ul><li>Overview of Git and TFVC version control systems</li><li>Integration with Visual Studio</li><li>Using TFVC and Git version control</li><li>Basic and advanced workflows</li><li>Controlling access to version control</li><li>Command-line tools and utilities</li><li>TFS Proxy, MSSCCI Provider, and TFS Sidekicks</li></ul><h4>Building and Releasing</h4><ul><li>Overview of the Visual Studio build system</li><li>Build agents, agent pools, agent queues</li><li>Creating and queuing a build</li><li>Monitoring, and managing a build</li><li>Securing the build process</li><li>Running tests as part of the build</li><li>Overview of Package Management</li><li>Overview of Release Management</li><li>Defining, creating, and deploying a release</li></ul><h4>Upgrading, Migrating, and Integrating</h4><ul><li>Upgrading Team Foundation Server</li><li>In-place vs. migration upgrade</li><li>Performing post-upgrade tasks</li><li>Migrating work items</li><li>Migrating items under version controlled</li><li>Integrating with Team Foundation Server</li><li>Custom and 3rd party solutions</li></ul><h4>Advanced Administration</h4><ul><li>Monitoring the health of Team Foundation Server</li><li>Web-based diagnostic tools</li><li>Options for scalability and high availability</li><li>Disaster recovery, backup, and restore</li><li>Moving Team Foundation Server</li><li>Managing the data warehouse</li><li>Using PowerShell to manage TFS</li></ul><h4>Customizing and Extending</h4><ul><li>Customizing vs. extending</li><li>Customizing a process template</li><li>Customizing a work item type</li><li>Creating default work items</li><li>Creating and using a global list</li><li>Using Witadmin.exe</li><li>Using work item templates</li><li>Creating a custom report</li><li>Using the REST API to extend Team Foundation Server</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Administering Team Foundation Server 2017 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 Administering Team Foundation Server 2017 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>

Microsoft Certified Technology Specialist (MCTS)

TOGAF 9 Foundation

SSSTS

Teaching & Training

Administering Team Foundation Server 2017

Harpenden

<p>This very practical workshop has a simple objective: to help you prepare, design and deliver memorable and high-quality presentations.</p>This programme will help you:<ul><li>Use a proven, structured tool-kit when designing and developing presentations</li><li>Benefit from short cuts and best practice when designing and using Powerpoint presentations</li><li>Select the right information, examples, exercises and activities - and use them well</li><li>Prepare and structure a presentation or session appropriate to the audience, and to best achieve your objectives</li><li>Maintain audience or group interest</li><li>Develop and practise presentation skills to improve your voice tone, speech power and body language</li><li>Use practical methods to control nerves and anxiety - develop higher levels of confidence and credibility</li><li>Command a room, hold attention and create a high impact</li></ul><section>
                    <h3>1 Introduction</h3><ul><li>Personal objectives</li><li>Key messages and learning objectives of the workshop</li></ul> <h3>2 Presentation skills</h3><ul><li>What does good look like?</li><li>Exercise: Characteristics of high/low impact presentations</li><li>Presenting yourself as a 'winner'</li><li>The energy / attitude model</li><li>Exercise: Being a winner</li></ul> <h3>3 Preparation skills - eight steps to preparing a great presentation, plus Powerpoint tips</h3>•The magic circle<br />• How to 'assume the role' when presenting<br />• The eight steps<br />• Step 1 - develop your objectives<br />- The five questions that you must answer before preparing your presentation<br />- Defining your objectives and outcomes<br />- Creating a first draft<br />- Step 1 exercise<br />• Step 2 - analyse your audience<br />- Doing your homework: audience, event, venue<br />- Developing a pre-event check-list<br />- Methods and means for researching your audience<br />- Step 2 exercise<br />• Steps 3 and 4 - structure the main body of your presentation and state the main ideas<br />- Ways to structure your presentation for maximum impact<br />- Balancing and managing content and topics<br />- Organising your information: 6 options and methods<br />- Your 'one main point' and creating a 30-second summary<br />- Steps 3 and 4 exercises<br />• Step 5 - decide on supporting information, using the toolkit<br />- Making your case convincing: ways to support your claims<br />- Selecting and using relevant and interesting examples<br />- Quotes, case studies and printed material<br />- Presenting statistics, tables and graphs<br />- Ways of maintaining visual interest<br />- Transitions and links, creating a 'golden thread'<br />- Step 5 exercise: Creating compelling stories and anecdotes<br />4<br />• Step 6 - create an effective 'opening'<br />- Claiming the stage and creating a good first impression<br />- The three most powerful ways of opening a presentation<br />- The five elements of a strong opening<br />- Step 6 exercise: Participants work individually to prepare an opening, focusing on<br />personal introduction, and then deliver to the group, with structured feedback<br />• Step 7 - develop transitions<br />- Step 7 exercise / examples<br />• Step 8 - create an effective close<br />- Signalling and sign-posting; the importance of, and how to do it effectively<br />- Five ways to close a presentation successfully<br />- Step 8 exercise / examples<br />• Presentation design and Powerpoint<br />- An interactive review of participants' own real-life past presentations and advanced tips<br />and techniques on using Powerpoint effectively <h3>4 Facilitation skills</h3><ul><li>The three main types of group activity - triads, teams and main group</li><li>How to select the right activity, define the objectives, set it up and run the debrief</li><li>Using energisers - with examples</li><li>Exercise: Dealing with 'difficult' behaviours</li><li>Exercise: Working in triads, design and deliver</li></ul> <h3>5 Tips and tricks: presentation and facilitation</h3><ul><li>10 reasons why facilitation fails</li><li>Five golden rules for success</li><li>Defining the session goals and the facilitation plan</li><li>Open and closed questions - why and when to use</li><li>Using a 'car park' to manage unresolved issues</li><li>Using AV aids - tips and tricks</li><li>Exercises: Including participants working in pairs to prepare a short section form of one of their own presentations</li></ul> <h3>6 Putting it all together</h3><ul><li>Summary of key learning points</li><li>Action plan</li></ul> 


                </section>

The In House Training Company

Executive Presentation

Coaching Skills

Meeting Skills

Facilitation Skills

Counselling Skills

Presentation Skills

Powerful presentation skills (In-House)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>This course is intended for IT Professionals who are already experienced in general Windows Server, Windows client, Azure, and Microsoft 365 administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of PowerShell or any scripting language is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Microsoft Exchange Server, Microsoft SharePoint Server, and Microsoft SQL Server.</p><p></p><p></p><p>This course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches.</p><p></p>Prerequisites<p>Before attending this course, students must have: </p><ul><li>-Experience with Windows networking technologies and implementation.</li> <li>- Experience with Windows Server administration, maintenance, and troubleshooting.</li></ul><p></p></div><div id="course-pills-2"><h3>1 - Review Windows PowerShell</h3> <ul> <li>Learn about Windows PowerShell</li> <li>Get familiar with Windows PowerShell applications</li> <li>Identify factors to install and use Windows PowerShell</li> <li>Configure the Windows PowerShell console</li> <li>Configure the Windows PowerShell Integrated Scripting Environment (ISE)</li> <li>Use Visual Studio Code with PowerShell</li> </ul> <h3>2 - Understand the command syntax in Windows PowerShell</h3> <ul> <li>Discover the structure of PowerShell cmdlets</li> <li>Discover the parameters for using PowerShell cmdlets</li> <li>Review the tab completion feature in PowerShell</li> <li>Display the About files content in PowerShell</li> </ul> <h3>3 - Find commands and Get-Help in Windows PowerShell</h3> <ul> <li>Define modules in PowerShell</li> <li>Find cmdlets in PowerShell</li> <li>Use command aliases in PowerShell</li> <li>Use Show-Command and Get-Help in PowerShell</li> <li>Interpret the help file contents and update the local help content in PowerShell</li> </ul> <h3>4 - Manage Active Directory Domain Services using PowerShell cmdlets</h3> <ul> <li>Manage user accounts in PowerShell</li> <li>Manage groups and group memberships in PowerShell</li> <li>Manage computer accounts in PowerShell</li> <li>Manage organizational units and Active Directory objects in PowerShell</li> </ul> <h3>5 - Manage network service settings for Windows devices using PowerShell cmdlets</h3> <ul> <li>Manage IP addresses in PowerShell</li> <li>Manage IP routing in PowerShell</li> <li>Manage DNS clients in PowerShell</li> <li>Manage Windows Firewall settings in PowerShell</li> </ul> <h3>6 - Manage Windows Server settings using PowerShell cmdlets</h3> <ul> <li>Automate management tasks using the Group Policy management cmdlets</li> <li>Manage server roles and services using PowerShell cmdlets</li> <li>Manage Hyper-V Virtual Machines using PowerShell cmdlets</li> <li>Manage Internet Information Services using PowerShell cmdlets</li> </ul> <h3>7 - Manage settings for a local Windows machine using PowerShell cmdlets</h3> <ul> <li>Manage Windows 10 using PowerShell</li> <li>Manage permissions with PowerShell</li> </ul> <h3>8 - Understand the Windows PowerShell pipeline</h3> <ul> <li>Review Windows PowerShell pipeline and its output</li> <li>Discover object members in PowerShell</li> <li>Control the formatting of pipeline output</li> </ul> <h3>9 - Select, sort, and measure objects using the pipeline</h3> <ul> <li>Sort and group objects by property in the pipeline</li> <li>Measure objects in the pipeline</li> <li>Select a set of objects in the pipeline</li> <li>Select object properties in the pipeline</li> <li>Create and format calculated properties in the pipeline</li> </ul> <h3>10 - Filter objects out of the pipeline</h3> <ul> <li>Learn about the comparison operators in PowerShell</li> <li>Review basic filter syntax in the pipeline</li> <li>Review advanced filter syntax in the pipeline</li> <li>Optimize the filter performance in the pipeline</li> </ul> <h3>11 - Enumerate objects in the pipeline</h3> <ul> <li>Learn about enumerations in the pipeline</li> <li>Review basic syntax to enumerate objects in the pipeline</li> <li>Review advanced syntax to enumerate objects in the pipeline</li> </ul> <h3>12 - Send and pass data as output from the pipeline</h3> <ul> <li>Write pipeline data to a file</li> <li>Convert pipeline objects to other forms of data representation in PowerShell</li> <li>Control additional output options in PowerShell</li> </ul> <h3>13 - Pass pipeline objects</h3> <ul> <li>Pipeline parameter binding</li> <li>Identify ByValue parameters</li> <li>Pass data by using ByValue</li> <li>Pass data by using ByPropertyName</li> <li>Identify ByPropertyName parameters</li> <li>Use manual parameters to override the pipeline</li> <li>Use parenthetical commands</li> <li>Expand property values</li> </ul> <h3>14 - Connect with data stores using PowerShell providers</h3> <ul> <li>Define Windows PowerShell providers</li> <li>Review the built-in providers in PowerShell</li> <li>Access provider help in PowerShell</li> </ul> <h3>15 - Use PowerShell drives in PowerShell</h3> <ul> <li>Explain PowerShell drives in PowerShell</li> <li>Use PowerShell drive cmdlets in PowerShell</li> <li>Manage the file system in PowerShell</li> <li>Manage the registry in PowerShell</li> <li>Work with certificates in PowerShell</li> <li>Work with other PowerShell drives in PowerShell</li> </ul> <h3>16 - Review CIM and WMI</h3> <ul> <li>Review architecture of CIM and WMI</li> <li>Review repositories in CIM and WMI</li> <li>Locate online class documentation by using CIM and WMI cmdlets</li> </ul> <h3>17 - Query configuration information by using CIM and WMI</h3> <ul> <li>List local repository namespaces and classes by using CIM and WMI</li> <li>Query instances by using commands and WMI Query Language</li> <li>Connect to remote computers by using CIM and WMI cmdlets</li> <li>Query repository classes from remote computers by using CIMSession objects</li> </ul> <h3>18 - Query and manipulate repository objects by using CIM and WMI methods</h3> <ul> <li>Discover methods of repository objects by using CIM and WMI</li> <li>Locate class methods and documentation by using CIM and WMI</li> <li>Invoke methods of repository objects by using CIM and WMI</li> </ul> <h3>19 - Manage variables in Windows PowerShell scripts</h3> <ul> <li>Define variables in Windows PowerShell scripts</li> <li>Create variable names in Windows PowerShell scripts</li> <li>Assign values and types to variables in Windows PowerShell scripts</li> <li>Identify the methods and properties of variables in Windows PowerShell scripts</li> <li>Use string variables and methods in Windows PowerShell scripts</li> <li>Use date variables and methods in Windows PowerShell scripts</li> </ul> <h3>20 - Work with arrays and hash tables in Windows PowerShell scripts</h3> <ul> <li>Define an array in Windows PowerShell scripts</li> <li>Work with array lists in Windows PowerShell scripts</li> <li>Define hash tables in Windows PowerShell Scripts</li> <li>Work with hash tables in Windows PowerShell scripts</li> </ul> <h3>21 - Create and run scripts by using Windows PowerShell</h3> <ul> <li>Review Windows PowerShell scripts</li> <li>Modify scripts in the PowerShell Gallery</li> <li>Create scripts using Windows PowerShell</li> <li>Review the PowerShellGet module in Windows PowerShell</li> <li>Run scripts and set the execution policy in Windows PowerShell</li> <li>Review Windows PowerShell and AppLocker</li> <li>Sign the scripts digitally in Windows PowerShell</li> </ul> <h3>22 - Work with scripting constructs in Windows PowerShell</h3> <ul> <li>Review and use the ForEach loop in Windows PowerShell scripts</li> <li>Review and use the If construct in Windows PowerShell scripts</li> <li>Review and use the Switch construct in Windows PowerShell scripts</li> <li>Review the For construct in Windows PowerShell scripts</li> <li>Review other loop constructs in Windows PowerShell scripts</li> <li>Review Break and Continue in Windows PowerShell scripts</li> </ul> <h3>23 - Import data in different formats for use in scripts by using Windows PowerShell cmdlets</h3> <ul> <li>Use the Get-Content command in Windows PowerShell scripts</li> <li>Use the Import-Csv cmdlet in Windows PowerShell scripts</li> <li>Use the Import-Clixml cmdlet in Windows PowerShell scripts</li> <li>Use the ConvertFrom-Json cmdlet in Windows PowerShell scripts</li> </ul> <h3>24 - Use methods to accept user inputs in Windows PowerShell scripts</h3> <ul> <li>Identify values that might change in Windows PowerShell scripts</li> <li>Use the Read-Host cmdlet in Windows PowerShell scripts</li> <li>Use the Get-Credential cmdlet in Windows PowerShell scripts</li> <li>Use the Out-GridView cmdlet in Windows PowerShell scripts</li> <li>Pass parameters to a Windows PowerShell script</li> </ul> <h3>25 - Troubleshoot scripts and handle errors in Windows PowerShell</h3> <ul> <li>Interpret error messages generated for Windows PowerShell commands</li> <li>Add output to Windows PowerShell scripts</li> <li>Use breakpoints in Windows PowerShell scripts</li> <li>Interpret error actions for Windows PowerShell commands</li> </ul> <h3>26 - Use functions and modules in Windows PowerShell scripts</h3> <ul> <li>Review functions in Windows PowerShell scripts</li> <li>Use variable scope in Windows PowerShell scripts</li> <li>Create modules in Windows PowerShell scripts</li> <li>Use the dot sourcing feature in Windows PowerShell</li> </ul> <h3>27 - Manage single and multiple computers by using Windows PowerShell remoting</h3> <ul> <li>Review the remoting feature of Windows PowerShell</li> <li>Compare remoting with remote connectivity</li> <li>Review the remoting security feature of Windows PowerShell</li> <li>Enable remoting by using Windows PowerShell</li> <li>Use one-to-one remoting by using Windows PowerShell</li> <li>Use one-to-many remoting by using Windows PowerShell</li> <li>Compare remoting output with local output</li> </ul> <h3>28 - Use advanced Windows PowerShell remoting techniques</h3> <ul> <li>Review common remoting techniques of Windows PowerShell</li> <li>Send parameters to remote computers in Windows PowerShell</li> <li>Set access protection to variables, aliases, and functions by using the scope modifier</li> <li>Enable multi-hop remoting in Windows PowerShell</li> </ul> <h3>29 - Manage persistent connections to remote computers by using Windows PowerShell sessions</h3> <ul> <li>Review persistent connections in Windows PowerShell</li> <li>Create and manage persistent PSSessions by using Windows PowerShell</li> <li>Disconnect PSSessions by using Windows PowerShell</li> <li>Review the feature of implicit remoting in Windows PowerShell</li> </ul> <h3>30 - Review Azure PowerShell module</h3> <ul> <li>Review Azure PowerShell</li> <li>Review the benefits of the Azure PowerShell module</li> <li>Install the Azure PowerShell module</li> <li>Migrate Azure PowerShell from AzureRM to Azure</li> <li>Review Microsoft Azure Active Directory module for Windows PowerShell and Azure Active Directory PowerShell for Graph modules</li> </ul> <h3>31 - Review the features and tools for Azure Cloud Shell</h3> <ul> <li>Review the characteristics of Azure Cloud Shell</li> <li>Review the features and tools of Azure Cloud Shell</li> <li>Configure and experiment with Azure Cloud Shell</li> </ul> <h3>32 - Manage Azure resources with Windows PowerShell</h3> <ul> <li>Create a new Azure virtual machine by using Windows PowerShell commands</li> <li>Manage Azure virtual machines by using Windows PowerShell commands</li> <li>Manage Azure related storage by using Azure PowerShell</li> <li>Manage Azure subscriptions by using Azure PowerShell</li> </ul> <h3>33 - Manage users, groups, and licenses in Microsoft Entra ID by using Windows PowerShell</h3> <ul> <li>Review benefits to manage Microsoft 365 services by using Windows PowerShell</li> <li>Connect to the Microsoft 365 tenant by using Windows PowerShell</li> <li>Manage users in Microsoft 365 by using Windows PowerShell</li> <li>Manage groups in Microsoft 365 by using Windows PowerShell</li> <li>Manage roles in Microsoft 365 by using Windows PowerShell</li> <li>Manage licenses in Microsoft 365 by using Windows PowerShell</li> </ul> <h3>34 - Manage Exchange Online by using Windows PowerShell</h3> <ul> <li>Connect to Exchange Online by using Windows PowerShell</li> <li>Manage mailboxes in Exchange Online by using Windows PowerShell</li> <li>Manage resources in Exchange Online by using Windows PowerShell</li> <li>Manage admin roles in Exchange Online by using Windows PowerShell</li> </ul> <h3>35 - Manage SharePoint Online by using Windows PowerShell</h3> <ul> <li>Install and connect to SharePoint Online Management Shell by using Windows PowerShell</li> <li>Manage SharePoint Online users and groups by using Windows PowerShell</li> <li>Manage SharePoint sites by using Windows PowerShell</li> <li>Manage SharePoint Online external user sharing by using Windows PowerShell</li> </ul> <h3>36 - Manage Microsoft Teams by using Windows PowerShell</h3> <ul> <li>Review Microsoft Teams PowerShell module</li> <li>Install the Microsoft Teams PowerShell module</li> <li>Manage teams with Microsoft Teams PowerShell module</li> </ul> <h3>37 - Create and manage background jobs using Windows PowerShell</h3> <ul> <li>Define the types of background jobs in Windows PowerShell</li> <li>Start remote jobs and CIM/WMI jobs in Windows PowerShell</li> <li>Monitor jobs in Windows PowerShell</li> <li>Retrieve results for running jobs in Windows PowerShell</li> </ul> <h3>38 - Create and manage scheduled jobs using Windows PowerShell</h3> <ul> <li>Create and run Windows PowerShell scripts as scheduled tasks</li> <li>Define scheduled jobs in Windows PowerShell</li> <li>Create job option and job trigger objects in Windows PowerShell</li> <li>Create and register a scheduled job in Windows PowerShell</li> <li>Retrieve the results from a scheduled job in Windows PowerShell</li> </ul></div>

Power Automate

Microsoft Power Automate

AZ-040T00 Automating Administration with Powershell

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications.</p><p></p><p></p><p>This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.</p><p></p>Prerequisites<p>In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses:   </p><li>AZ-900T00 Microsoft Azure Fundamentals  </li><li>DP-900T00 Microsoft Azure Data Fundamentals<p></p></li></div><div id="course-pills-2"><h3>1 - Prepare to maintain SQL databases on Azure</h3> <ul> <li>Describe Microsoft Intelligent Data Platform roles</li> <li>Understand SQL Server in an Azure virtual machine</li> <li>Design Azure SQL Database for cloud-native applications</li> <li>Explore Azure SQL Database Managed Instance</li> </ul> <h3>2 - Deploy IaaS solutions with Azure SQL</h3> <ul> <li>Explain IaaS options to deploy SQL Server in Azure</li> <li>Understand hybrid scenarios</li> <li>Explore performance and security</li> <li>Explain high availability and disaster recovery options</li> </ul> <h3>3 - Deploy PaaS solutions with Azure SQL</h3> <ul> <li>Explain PaaS options for deploying SQL Server in Azure</li> <li>Explore single SQL database</li> <li>Deploy SQL database elastic pool</li> <li>Understand SQL database hyperscale</li> <li>Examine SQL managed instance</li> <li>Describe SQL Edge</li> </ul> <h3>4 - Evaluate strategies for migrating to Azure SQL</h3> <ul> <li>Understand compatibility level</li> <li>Understand Azure preview features</li> <li>Describe Azure database migration options</li> </ul> <h3>5 - Migrate SQL workloads to Azure SQL databases</h3> <ul> <li>Choose the right SQL Server Instance option in Azure</li> <li>Migrate SQL Server to Azure SQL Database offline</li> <li>Migrate SQL Server to Azure SQL Database online</li> <li>Load and move data to Azure SQL Database</li> </ul> <h3>6 - Migrate SQL workloads to Azure Managed Instances</h3> <ul> <li>Evaluate migration scenarios to SQL Database Managed Instance</li> <li>Migrate to SQL Database Managed Instance</li> <li>Load and Move data to SQL Database Managed Instance</li> </ul> <h3>7 - Configure database authentication and authorization</h3> <ul> <li>Describe Active Directory and Azure Active Directory</li> <li>Describe authentication and identities</li> <li>Describe Security Principals</li> <li>Describe database and object permissions</li> <li>Identify authentication and authorization failures</li> </ul> <h3>8 - Protect data in-transit and at rest</h3> <ul> <li>Explore Transparent Data Encryption</li> <li>Configure server and database firewall rules</li> <li>Explain object encryption and secure enclaves</li> <li>Enable encrypted connections</li> <li>Describe SQL injection</li> <li>Understand Azure Key Vault</li> </ul> <h3>9 - Implement compliance controls for sensitive data</h3> <ul> <li>Explore data classification</li> <li>Explore server and database audit</li> <li>Implement Dynamic Data Masking</li> <li>Implement Row Level security</li> <li>Understand Microsoft Defender for SQL</li> <li>Explore Azure SQL Database Ledger</li> <li>Implement Azure Purview</li> </ul> <h3>10 - Describe performance monitoring</h3> <ul> <li>Describe performance monitoring tools</li> <li>Describe critical performance metrics</li> <li>Establish baseline metrics</li> <li>Explore extended events</li> <li>Describe Azure SQL Insights</li> <li>Explore Query Performance Insight</li> </ul> <h3>11 - Configure SQL Server resources for optimal performance</h3> <ul> <li>Explain how to optimize Azure storage for SQL Server virtual machines</li> <li>Describe virtual machine resizing</li> <li>Optimize database storage</li> <li>Control SQL Server resources</li> </ul> <h3>12 - Configure databases for optimal performance</h3> <ul> <li>Explore database maintenance checks</li> <li>Describe database scoped configuration options</li> <li>Describe automatic tuning</li> <li>Describe intelligent query processing</li> </ul> <h3>13 - Explore query performance optimization</h3> <ul> <li>Understand query plans</li> <li>Explain estimated and actual query plans</li> <li>Describe dynamic management views and functions</li> <li>Explore Query Store</li> <li>Identify problematic query plans</li> <li>Describe blocking and locking</li> </ul> <h3>14 - Evaluate performance improvements</h3> <ul> <li>Describe wait statistics</li> <li>Tune and maintain indexes</li> <li>Understand query hints</li> </ul> <h3>15 - Explore performance-based design</h3> <ul> <li>Describe normalization</li> <li>Choose appropriate data types</li> <li>Design indexes</li> </ul> <h3>16 - Automate deployment of database resources</h3> <ul> <li>Describe deployment models in Azure</li> <li>Automate deployment by using Azure Resource Manager templates and Bicep</li> <li>Automate deployment by using PowerShell</li> <li>Automate deployment by using Azure CLI</li> </ul> <h3>17 - Create and manage SQL Agent jobs</h3> <ul> <li>Create a SQL Server maintenance plan</li> <li>Describe task status notifications</li> </ul> <h3>18 - Manage Azure PaaS tasks using automation</h3> <ul> <li>Explore Elastic jobs</li> <li>Understand Azure Automation</li> <li>Build an automation runbook</li> <li>Automate database workflows by using Logic Apps</li> <li>Monitor automated tasks</li> </ul> <h3>19 - Describe high availability and disaster recovery strategies</h3> <ul> <li>Describe recovery time objective and recovery point objective</li> <li>Explore high availability and disaster recovery options</li> <li>Describe Azure high availability and disaster recovery  features for Azure Virtual Machines</li> <li>Describe high availability and disaster recovery options for PaaS deployments</li> <li>Explore an IaaS high availability and disaster recovery solution</li> <li>Describe hybrid solutions</li> </ul> <h3>20 - Explore IaaS and PaaS solutions for high availability and disaster recovery</h3> <ul> <li>Describe failover clusters in Windows Server</li> <li>Configure Always-on availability groups</li> <li>Describe temporal tables in Azure SQL Database</li> <li>Describe active geo-replication for Azure SQL Database</li> <li>Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance</li> </ul> <h3>21 - Back up and restore databases</h3> <ul> <li>Back up and restore SQL Server running on Azure virtual machines</li> <li>Back up a SQL Server virtual machine</li> <li>Back up and restore a database using Azure SQL Database</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-300T00: Administering Microsoft Azure SQL Solutions 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-300T00: Administering Microsoft Azure SQL Solutions 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>

Azure SQL Database

Microsoft Azure

Microsoft AZ-700

DP-300T00 Administering Microsoft Azure SQL Solutions

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>This four-day course is intended for Windows Server Hybrid Administrators who have experience working with Windows Server and want to extend the capabilities of their on-premises environments by combining on-premises and hybrid technologies. Windows Server Hybrid Administrators implement and manage on-premises and hybrid solutions such as identity, management, compute, networking, and storage in a Windows Server hybrid environment.</p><p></p><p></p><p>This course teaches IT Professionals how to manage core Windows Server workloads and services using on-premises, hybrid, and cloud technologies. The course teaches IT Professionals how to implement and manage on-premises and hybrid solutions such as identity, management, compute, networking, and storage in a Windows Server hybrid environment.</p><p></p>Prerequisites<p></p><li>Experience with managing Windows Server operating system and Windows Server workloads in on-premises scenarios, including AD DS, DNS, DFS, Hyper-V, and File and Storage Services  </li><li>Experience with common Windows Server management tools (implied in the first prerequisite).  </li><li>Basic knowledge of core Microsoft compute, storage, networking, and virtualization technologies (implied in the first prerequisite).  </li><li>Experience and an understanding of core networking technologies such as IP addressing, name resolution, and Dynamic Host Configuration Protocol (DHCP)  </li><li>Experience working with and an understanding of Microsoft Hyper-V and basic server virtualization concepts  </li><li>Basic experience with implementing and managing IaaS services in Microsoft Azure  </li><li>Basic knowledge of Azure Active Directory  </li><li>Experience working hands-on with Windows client operating systems such as Windows 10 or Windows 11  </li><li>Basic experience with Windows PowerShell<p></p></li></div><div id="course-pills-2"><h3>1 - Introduction to AD DS</h3> <ul> <li>Define AD DS</li> <li>Define users, groups, and computers</li> <li>Define AD DS forests and domains</li> <li>Define OUs</li> <li>Manage objects and their properties in AD DS</li> </ul> <h3>2 - Manage AD DS domain controllers and FSMO roles</h3> <ul> <li>Deploy AD DS domain controllers</li> <li>Maintain AD DS domain controllers</li> <li>Manage the AD DS Global Catalog role</li> <li>Manage AD DS operations masters</li> <li>Manage AD DS schema</li> </ul> <h3>3 - Implement Group Policy Objects</h3> <ul> <li>Define GPOs</li> <li>Implement GPO scope and inheritance</li> <li>Define domain-based GPOs</li> <li>Create and configure a domain-based GPO</li> <li>Define GPO storage</li> <li>Define administrative templates</li> </ul> <h3>4 - Manage advanced features of AD DS</h3> <ul> <li>Create trust relationships</li> <li>Implement ESAE forests</li> <li>Monitor and troubleshoot AD DS</li> <li>Create custom AD DS partitions</li> </ul> <h3>5 - Implement hybrid identity with Windows Server</h3> <ul> <li>Select a Microsoft Entra integration model</li> <li>Plan for Microsoft Entra integration</li> <li>Prepare on-premises Active Directory for directory synchronization</li> <li>Install and configure directory synchronization with Microsoft Entra Connect</li> <li>Implement Seamless Single Sign-On</li> <li>Enable Microsoft Entra login in for Windows VM in Azure</li> <li>Describe Microsoft Entra Domain Services</li> <li>Implement and configure Microsoft Entra Domain Services</li> <li>Manage Windows Server 2019 in a Microsoft Entra Domain Services environment</li> <li>Create and configure a Microsoft Entra Domain Services instance</li> <li>Join a Windows Server VM to a managed domain</li> </ul> <h3>6 - Deploy and manage Azure IaaS Active Directory domain controllers in Azure</h3> <ul> <li>Select an option to implement directory and identity services using Active Directory Domain Services in Azure</li> <li>Deploy and configure Active Directory Domain Services domain controllers in Azure VMs</li> <li>Install a replica Active Directory domain controller in an Azure VM</li> <li>Install a new Active Directory forest on an Azure VNet</li> </ul> <h3>7 - Perform Windows Server secure administration</h3> <ul> <li>Define least privilege administration</li> <li>Implement delegated privileges</li> <li>Use privileged access workstations</li> <li>Use jump servers</li> </ul> <h3>8 - Describe Windows Server administration tools</h3> <ul> <li>Explore Windows Admin Center</li> <li>Use Server Manager</li> <li>List Remote Server Administration Tools</li> <li>Use Windows PowerShell</li> <li>Use Windows PowerShell to remotely administer a server</li> </ul> <h3>9 - Perform post-installation configuration of Windows Server</h3> <ul> <li>List the available post-installation configuration tools</li> <li>Configure Server Core using Sconfig</li> <li>Use DSC to configure Windows Server</li> <li>Perform post-installation configuration with Windows Admin Center</li> <li>Configure a server with answer files</li> </ul> <h3>10 - Just Enough Administration in Windows Server</h3> <ul> <li>Explain the concept of Just Enough Administration (JEA)</li> <li>Define role capabilities for a JEA endpoint</li> <li>Create a session configuration file to register a JEA endpoint</li> <li>Describe how JEA endpoints work to limit access to a PowerShell session</li> <li>Create and connect to a JEA endpoint</li> <li>Demonstration: Connect to a JEA endpoint</li> </ul> <h3>11 - Administer and manage Windows Server IaaS Virtual Machine remotely</h3> <ul> <li>Select the appropriate remote administration tool</li> <li>Manage Windows Virtual Machines with Azure Bastion</li> <li>Create an Azure Bastion host</li> <li>Configure just-in-time administration</li> </ul> <h3>12 - Manage hybrid workloads with Azure Arc</h3> <ul> <li>Describe Azure Arc</li> <li>Onboard Windows Server instances</li> <li>Connect hybrid machines to Azure from the Azure portal</li> <li>Use Azure Arc to manage Windows Server instances</li> <li>Restrict access with RBAC</li> </ul> <h3>13 - Configure and manage Hyper-V</h3> <ul> <li>Define Hyper-V</li> <li>Define Hyper-V Manager</li> <li>Configure Hyper-V hosts using best practices</li> <li>Configure Hyper-V networking</li> <li>Assess advanced Hyper-V networking features</li> <li>Define nested virtualization</li> </ul> <h3>14 - Configure and manage Hyper-V virtual machines</h3> <ul> <li>List the virtual machine configuration versions</li> <li>List the virtual machine generation versions</li> <li>List available VHD formats and types</li> <li>Create and configure VMs</li> <li>Determine storage options for VMs</li> <li>Define shared VHDs and VHD Sets</li> <li>Implement guest clusters using shared VHDX</li> </ul> <h3>15 - Secure Hyper-V workloads</h3> <ul> <li>Define guarded fabric</li> <li>Define the Host Guardian Service</li> <li>Explore TPM-trusted attestation</li> <li>Define KPS</li> <li>Determine key features of shielded VMs</li> <li>Compare encryption-supported and shielded VMs in a guarded fabric</li> <li>Implement a shielded VM</li> </ul> <h3>16 - Run containers on Windows Server</h3> <ul> <li>Define containers</li> <li>List the differences between containers and VMs</li> <li>Define Windows Server and Hyper-V containers and isolation modes</li> <li>Explore Docker</li> <li>Prepare a Windows Server 2019 host for container deployment</li> <li>Security, Storage, and Networking with Windows containers</li> </ul> <h3>17 - Orchestrate containers on Windows Server using Kubernetes</h3> <ul> <li>Define orchestration</li> <li>Define Kubernetes</li> <li>Deploy Kubernetes resources</li> <li>Create a Kubernetes cluster on Windows</li> <li>Define Azure Arc</li> <li>Connect an Azure Arc-enabled Kubernetes cluster to Azure Arc</li> </ul> <h3>18 - Plan and deploy Windows Server IaaS Virtual Machines</h3> <ul> <li>Describe Azure compute</li> <li>Describe Virtual Machine storage</li> <li>Deploy Azure Virtual Machines</li> <li>Create a windows Virtual Machine using the portal</li> <li>Create a windows Virtual Machine using Azure CLI</li> <li>Deploy Azure Virtual Machines using templates</li> <li>Describe additional management optimization options</li> </ul> <h3>19 - Customize Windows Server IaaS Virtual Machine images</h3> <ul> <li>Create a generalized image</li> <li>Create a new Virtual Machine from a managed image</li> <li>Create a managed image of a generalized virtual machine in Azure</li> <li>Create a Virtual Machine from a managed image</li> <li>Implement Azure Image Builder</li> <li>Create a windows Virtual Machine using Azure Image Builder template</li> <li>Create a Windows Virtual Machine with Azure Image Builder using PowerShell</li> </ul> <h3>20 - Automate the configuration of Windows Server IaaS Virtual Machines</h3> <ul> <li>Describe Azure Automation</li> <li>Implement Azure Automation with DSC</li> <li>Remediate noncompliant servers</li> <li>Describe Custom Script Extensions</li> <li>Configure a Virtual Machine by using DSC</li> </ul> <h3>21 - Deploy and manage DHCP</h3> <ul> <li>Use DHCP to simplify IP configuration</li> <li>Install and configure the DHCP role</li> <li>Configure DHCP options</li> <li>Configure DHCP scopes</li> <li>Select DHCP high availability options</li> <li>Implement DHCP Failover</li> </ul> <h3>22 - Implement Windows Server DNS</h3> <ul> <li>Explore the DNS architecture</li> <li>Work with DNS zones and records</li> <li>Install and configure the DNS role</li> <li>Implement DNS forwarding</li> </ul> <h3>23 - Implement IP Address Management</h3> <ul> <li>Define IP Address Management</li> <li>Deploy IP Address Management</li> <li>Administer IP Address Management</li> <li>Configure IP Address Management options</li> <li>Manage DNS zones with IP Address Management</li> <li>Manage DHCP servers with IP Address Management</li> <li>Use IP Address Management to manage IP addressing</li> </ul> <h3>24 - Implement remote access</h3> <ul> <li>Examine the remote access options in Windows Server</li> <li>Select and set up VPNs</li> <li>Use NPS to create and enforce network access policies</li> <li>Plan and implement NPS</li> <li>Deploy a PKI for remote access</li> <li>Use WAP as a reverse web proxy</li> </ul> <h3>25 - Implement hybrid network infrastructure</h3> <ul> <li>Describe Azure network topologies</li> <li>Implement Azure VPN options</li> <li>Create a route-based VPN gateway using the Azure portal</li> <li>Implement Azure ExpressRoute</li> <li>Configure Azure Virtual WAN</li> <li>Implement DNS in hybrid environments</li> </ul> <h3>26 - Implement DNS for Windows Server IaaS VMs</h3> <ul> <li>Understand Azure DNS</li> <li>Implement Azure DNS</li> <li>Create an Azure DNS zone and record using the Azure portal</li> <li>Implement DNS with Azure IaaS virtual machines</li> <li>Implement split-horizon DNS in Azure</li> <li>Troubleshoot DNS</li> </ul> <h3>27 - Implement Windows Server IaaS VM IP addressing and routing</h3> <ul> <li>Implement a virtual network</li> <li>Implement IaaS VM IP addressing</li> <li>Assign and manage IP addresses</li> <li>Configure a private IP address for a virtual machine using the Azure portal</li> <li>Create a virtual machine with a static public IP address using the Azure portal</li> <li>Implement IaaS virtual machine IP routing</li> <li>Implement IPv6 for Windows Server IaaS virtual machines</li> </ul> <h3>28 - Manage Windows Server file servers</h3> <ul> <li>Define the Windows Server file system</li> <li>List the benefits and uses of File Server Resource Manager</li> <li>Define SMB and its security considerations</li> <li>Configure SMB protocol</li> <li>Define Volume Shadow Copy Service</li> </ul> <h3>29 - Implement Storage Spaces and Storage Spaces Direct</h3> <ul> <li>Define the Storage Spaces architecture and its components</li> <li>List the functionalities, benefits, and use cases of Storage Spaces</li> <li>Implement Storage Spaces</li> <li>List the functionalities, components, benefits, and use cases of Storage Spaces Direct</li> <li>Implement Storage Spaces Direct</li> </ul> <h3>30 - Implement Windows Server Data Deduplication</h3> <ul> <li>Define the architecture, components, and functionality of Data Deduplication</li> <li>Define the use cases and interoperability of Data Deduplication</li> <li>Implement Data Deduplication</li> <li>Manage and maintain Data Deduplication</li> </ul> <h3>31 - Implement Windows Server iSCSI</h3> <ul> <li>List the functionalities, components, and use cases of iSCSI</li> <li>List the considerations for implementing iSCSI</li> <li>Implement iSCSI</li> <li>Configure high availability for iSCSI</li> </ul> <h3>32 - Implement Windows Server Storage Replica</h3> <ul> <li>List the functionalities and components of Storage Replica</li> <li>Examine the prerequisites for implementing Storage Replica</li> <li>Implement Storage Replica by using Windows Admin Center</li> <li>Implement Storage Replica by using Windows PowerShell</li> </ul> <h3>33 - Implement a hybrid file server infrastructure</h3> <ul> <li>Describe Azure File services</li> <li>Configure Azure Files</li> <li>Configure connectivity to Azure Files</li> <li>Describe Azure File Sync</li> <li>Implement Azure File Sync</li> <li>Deploy Azure File Sync</li> <li>Deploy Azure File Sync 2</li> <li>Manage cloud tiering</li> <li>Migrate from DFSR to Azure File Sync</li> </ul></div>

Windows Server

AZ-800T00 Administering Windows Server Hybrid Core Infrastructure

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Candidates for this course design, develop, secure, and troubleshoot Power Platform solutions. Candidates implement components of a solution that include application enhancements, custom user experience, system integrations, data conversions, custom process automation, and custom visualizations. Candidates will gain applied knowledge of Power Platform services, including in-depth understanding of capabilities, boundaries, and constraints.</p>Overview<p>After completing this course, students will be able to:<br />Create a technical design<br />Configure Common Data Service<br />Create and configure Power Apps<br />Configure business process automation<br />Extend the user experience<br />Extend the platform<br />Develop Integrations</p><p>The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes. In this course, students will learn how to build Power Apps, Automate Flows and extend the platform to complete business requirements and solve complex business problems.</p></div><div id="course-pills-2"><h4>Create a model-driven application in Power Apps</h4><ul><li>This module introduces you to creating a model-driven app in Power Apps that uses Common Data Service.</li></ul><h4>Get started using Common Data Service</h4><ul><li>This module will explain the concepts behind and benefits of Common Data Service. Creating an environment, entities, fields and options sets are also discussed.</li></ul><h4>Create a canvas app in Power Apps</h4><ul><li>This module introduces you to Power Apps, helps you create and customize an app, and then manage and distribute it. It will also show you how to provide the best app navigation, and build the best UI using themes, icons, images, personalization, different form factors, and controls.</li></ul><h4>Automate a business process using Power Automate</h4><ul><li>This module introduces you to Power Automate, teaches you how to build workflows, and how to administer flows.</li></ul><h4>Create a business process flow in Power Automate</h4><ul><li>This module introduces you to creating business process flows in Power Automate</li></ul><h4>Introduction to developing with Power Platform</h4><ul><li>This module is the first step in learning about platform, tools, and the ecosystem of the Power Platform</li></ul><h4>Extending the Power Platform user experience Model Driven apps</h4><ul><li>This module describes how to create client scripting, perform common actions with client script, and automate business process flow with client scrip. Learn about what client script can do, rules, and maintaining scripts. Discover when to use client script as well as when not to use client script.</li></ul><h4>Create components with Power Apps Component Framework</h4><ul><li>This module describes how to get started with Power Apps Component Framework with an introductory module on the core concepts and components. Then it shows you how to build a component and work with advanced Power Apps Component Framework features.</li></ul><h4>Extending the Power Platform Common Data Service</h4><ul><li>This module looks at the tools and resources needed for extending the Power Platform. We'll start with looking at the SDKs, the extensibility model, and event framework. This learning path also covers when to use plug-ins. Configuration of plug-ins as well as registering and deploying plug-ins.</li></ul><h4>Integrate with Power Platform and Common Data Service</h4><ul><li>This module describes how to integrate with Common Data Service using code by learning about Common Data Service API. Get an in-depth overview of options available with Common Data Service to integrate data and events to Azure.</li></ul><h4>Extend Power Apps portals</h4><ul><li>This module describes how to transform a content portal into a full web app interacting with Common Data Service. We will also cover the options available to customizers and developers to extend the portal functionality and integrate with Office 365, Power Platform, and Azure components.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-400T00 Microsoft Power Platform Developer 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-400T00 Microsoft Power Platform Developer 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>

Microsoft PL-900

Microsoft Power Apps

Power Apps

PL-400T00 Microsoft Power Platform Developer

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

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Microsoft BI

Data Analyst

PL-300T00 Microsoft Power BI Data Analyst

MS-102T00 Microsoft 365 Administrator Essentials

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for IT professionals who are responsible for planning, configuring, and managing an Office 365 environment. Students who attend this course are expected to have a fairly broad understanding of several on-premises technologies such as Domain Name System (DNS) and Active Directory Domain Services (AD DS). In addition, they should have a general understanding of Microsoft Exchange Server, Microsoft Teams, and Microsoft SharePoint.</p>Overview<p>Plan and provision Office 365 Manage Users and Groups in Office 365 Deploy and Configure Tools and Applications for Office 365 Plan and Manage Exchange Online Plan and Manage SharePoint Online Plan and Manage Microsoft Teams Plan and Manage other Office 365 Services Implement Security and Compliance in Office 365 Report, Monitor and Troubleshoot Office 365</p><p>This five-day course describes how to set up, configure and manage an Office 365 tenant including identities, and the core services of Microsoft 365. In this five-day course, you will learn how to plan the configuration of an Office 365 tenant including integration with existing user identities; plan, configure and manage core services; and report on key metrics. <br /><br /> Although this course and the associated labs are written for Office 365 with Windows 11, the skills taught will also be backwards compatible with Windows 10. This course is based on the features available in the Office 365 E3 license as these are the core features in Office 365 and Microsoft 365 plans.</p></div><div id="course-pills-2"><h3>1 - Planning and Provisioning Office 365</h3> <ul> <li>Overview of Office 365</li> <li>Core Services of Office 365</li> <li>Requirements for an Office 365 Tenant</li> <li>Planning a Pilot and Deployment</li> <li>Creating an Office 365 Tenant</li> <li>Adding Custom Domains and Managing DNS Settings</li> <li>Lab: Provisioning Office 365</li> </ul> <h3>2 - Managing Users and Groups in Office 365</h3> <ul> <li>Managing User Accounts and Licences</li> <li>Managing Passwords and Authentication</li> <li>Create and Managing the Different Types of Groups in Office 365</li> <li>Managing Users and Groups with PowerShell</li> <li>Managing Users and Groups in the Azure AD Admin Center</li> <li>Role Based Access and Administrative Roles</li> <li>Planning and Configuring Directory Synchronization</li> <li>Lab: Managing Users and Groups in Office 365</li> <li>Lab: Planning and Configuring Directory Synchronisation</li> </ul> <h3>3 - Deploying and Configuring Tools and Applications for Office 365</h3> <ul> <li>Planning Network Configuration for Office 365 Tools and Applications</li> <li>Using the Office Configuration Tool</li> <li>Click to Run Installation Use and Control</li> <li>Managing Centralized Deployment of Tools, Applications and Add-ins</li> <li>Reporting</li> <li>Lab: Deploying and Configuring Tools and Applications for Office 365</li> </ul> <h3>4 - Planning and Managing Exchange Online</h3> <ul> <li>What is Exchange Online</li> <li>Managing Exchange Online Mailboxes</li> <li>Managing Office 365 Groups in Exchange Online</li> <li>Configuring Exchange Online Permissions</li> <li>Managing Exchange Online using PowerShell</li> <li>Plan and Configure Mail Flow</li> <li>Plan and Configure Email Protection</li> <li>Lab: Planning and Managing Exchange Online</li> </ul> <h3>5 - Planning and Managing SharePoint Online</h3> <ul> <li>What is SharePoint Online</li> <li>Understanding the relationship between SharePoint, OneDrive, Teams, and Office 365 Groups</li> <li>SharePoint Online Architecture</li> <li>Configure SharePoint Online</li> <li>Configure and Control External Sharing</li> <li>Managing SharePoint Online Site Collections</li> <li>Managing SharePoint Online using PowerShell</li> <li>Lab: Planning and Managing SharePoint Online</li> </ul> <h3>6 - Planning and Managing Microsoft Teams</h3> <ul> <li>What is Microsoft Teams</li> <li>How Microsoft Teams integrates with other Office 365 Services</li> <li>Create and Manage Organization Wide Settings</li> <li>Create, Manage and Assign Microsoft Teams Policies</li> <li>Plan and Configure External and Guest Access</li> <li>Managing Microsoft Teams using PowerShell</li> <li>Lab: Planning and Managing Microsoft Teams</li> </ul> <h3>7 - Planning and Managing Other Office 365 Services</h3> <ul> <li>Yammer</li> <li>Planner</li> <li>Visio</li> <li>Bookings</li> <li>Delve</li> <li>Forms</li> <li>Power Platform</li> <li>Stream</li> <li>Sway</li> <li>Viva</li> <li>Scheduler</li> <li>Add-ins, including Find Time and Junk Reporter</li> <li>Lab: Planning and Managing Office 365 Services</li> </ul> <h3>8 - Security and Compliance in Office 365</h3> <ul> <li>Overview of Security and Compliance Features in Office 365</li> <li>Extending Security and compliance Features with Additional Licences</li> <li>Using the Microsoft Defender Portal and Secure Score</li> <li>Using the Office 365 Compliance Portal and Compliance Score</li> <li>Plan and Configure Retention Labels and Policies</li> <li>Plan and Configure Data Loss Prevention Policies</li> <li>Create and Assign Sensitivity Labels</li> <li>Configure Safe Attachments and Safe Links Policies</li> <li>Plan and Configure Multi Factor Authentication</li> <li>Lab: Configure Security and Compliance in Office 365</li> </ul> <h3>9 - Reporting, Monitoring and Troubleshooting Office 365</h3> <ul> <li>Monitoring Office 365 Service Health</li> <li>Troubleshooting Administrative Access in Office 365</li> <li>Troubleshoot Directory Synchronization</li> <li>Troubleshooting Exchange Online</li> <li>Troubleshooting SharePoint Online</li> <li>Troubleshooting Microsoft Teams</li> <li>Troubleshooting Office 365 Security and Compliance</li> <li>Lab: Reporting, Monitoring and Troubleshooting in Office 365</li> </ul></div>

55354 Administering Office 365

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

Excel Analytics

Data Analysis Expressions

Data Skills

Introduction to DAX for Power BI

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>The intended audience for this course would be those who have been using Office 365 for some time and are now looking at optimizing their existing business processes and designing new ones.</p>Overview<p>#NAME?</p><p>This course delivers an instructor-led product showcase for Microsoft Power Automate from start to finish in an engaging and practical way. Power Automate is a diverse product, turning business processes into automated, consistent and visual workPower Automates. Power Automate is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workPower Automate logic for your business workPower Automates.</p></div><div id="course-pills-2"><h3>1 - An Introduction to Power Automate</h3> <ul> <li>What is Microsoft Power Automate?</li> <li>The benefits of automation</li> <li>How to get to Power Automate</li> <li>Lab 1: Setup your tenant</li> <li>Setup Office 365</li> <li>Download Course Files</li> <li>Customise your App Launcher</li> <li>Create accounts for colleagues</li> <li>After completing this module, students will be able to:</li> <li>Know what Microsoft Power Automate is</li> <li>The Benefits of using Power Automate to automate processes</li> <li>How to access a Power Automate</li> </ul> <h3>2 - Getting Started with Power Automate</h3> <ul> <li>Using Power Automate templates</li> <li>Navigating in Power Automate</li> <li>Editing a Power Automate</li> <li>Publish and trigger a Power Automate</li> <li>Turn off or delete a Power Automate</li> <li>Lab 1: Building processes in Office 365</li> <li>Create a Team with a channel</li> <li>Build an absence business process</li> <li>Testing the absence process</li> <li>Optional: Create Feedback Form</li> <li>Optional: Power Automate to Notify of Bad Ratings</li> <li>Optional: Test your Form and Power Automate</li> <li>After completing this module, students will be able to:</li> <li>How to use Power Automate tempaltes</li> <li>How to navigate around Power Automate</li> <li>How to edit Power Automates</li> <li>How to publish and trigger Power Automates</li> <li>How to turn off or delete Power Automates</li> </ul> <h3>3 - Power Automate Logic</h3> <ul> <li>Adding conditions</li> <li>Designing switches</li> <li>Using apply to each</li> <li>Configuring do until logic</li> <li>Adding a scope</li> <li>Lab 1: Scheduling documentation reviews</li> <li>Setup a policy library in SharePoint</li> <li>Design a policy review schedule</li> <li>Testing the policy review process</li> <li>Optional: Notify if a file nears review</li> <li>After completing this module, students will be able to:</li> <li>How to add condtions in a Power Automate</li> <li>How to design switches for a Power Automate</li> <li>How to use apply to each</li> <li>How to configure do until logic</li> <li>How to add a scope</li> </ul> <h3>4 - Integration</h3> <ul> <li>Standard and premium connectors</li> <li>Connecting to web services</li> <li>Using Power Automate with on-premises data</li> <li>Lab 1: Using Power Automate and SQL to Review Sales</li> <li>Create a new orders list</li> <li>Designing the price check process</li> <li>Testing the price check process</li> <li>Optional: Update with managers</li> <li>After completing this module, students will be able to:</li> <li>How to use Standard and Premium connectors</li> <li>How to connect to web services</li> <li>How to using Power Automate with on-premises data</li> </ul> <h3>5 - The Mobile App</h3> <ul> <li>Downloading the mobile app</li> <li>Signing in and account management</li> <li>Building and managing Power Automates</li> <li>Creating buttons</li> <li>Feeds and approvals</li> <li>Lab 1: Optional: Using the Power Automate mobile app</li> <li>Setting up the Power Automate mobile app</li> <li>Create a new Power Automate in the mobile app</li> <li>Using Power Automate buttons in the app</li> <li>Uninstall the Power Automate mobile app</li> <li>After completing this module, students will be able to:</li> <li>How to download the mobile app</li> <li>How to sign into the mobile app</li> <li>How to build and manage Power Automates in the mobile app</li> <li>How to create buttons in the mobile app</li> <li>How to feed and use approvals in the mobile app</li> </ul> <h3>6 - Administration and Maintenance</h3> <ul> <li>Maintaining a Power Automate</li> <li>View history and analytics</li> <li>Sharing a Power Automate</li> <li>Export and import Power Automates</li> <li>Office 365 administration for Power Automate</li> <li>Environments</li> <li>Data policies</li> <li>Data integration</li> <li>Lab 1: Maintaining your Power Automates</li> <li>Share a Power Automate with a colleague</li> <li>Disabling an active Power Automate</li> <li>Deleting a Power Automate</li> <li>After completing this module, students will be able to:</li> <li>How to maintain a Power Automate</li> <li>How to view history and analytics for a Power Automate</li> <li>How to share a Power Automate</li> <li>How to export and import Power Automates</li> <li>How to administrate a Power Automate in Office 365</li> <li>How to use data policies in a Power Automate</li> <li>How to use data integration in a Power Automate</li> </ul></div>

55268 Microsoft Power Automate for End Users

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong id="isPasted" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Managers and leaders use power every day, many feel reluctant to use it or even to admit that it is part of their job. However, using power effectively is an important skill and by developing influencing techniques can lead to increased effectiveness in a team. This course describes the sources of power and strategies and assesses your abilities in line with these. Power should contribute to organisational goals, respect human rights and conform to standards of equality and justice.&nbsp;</strong></p>

Managers and leaders use power every day, many feel reluctant to use it or even to admit that it is part of their job. However, using power effectively is an important skill and by developing influencing techniques can lead to increased effectiveness in a team. This course describes the sources of power and strategies and assesses your abilities in line with these. Power should contribute to organisational goals, respect human rights and conform to standards of equality and justice. 

Skillogy International

Soft Skills

Influencing Skills

Managers and leaders use power every day, many feel reluctant to use it or even to admit that it is part of their job. However, using power effectively is an important skill and by developing influencing techniques can lead to increased effectiveness in a team. This course describes the sources of power and strategies and assesses your abilities in line with these. Power should contribute to organisational goals, respect human rights and conform to standards of equality and justice. 

Power and Influence

Course

Complete 5 courses to gain a Certificate from the Chartered Management Institute

149 Courses

Microsoft Office 2016 Complete Course For Beginners

By The Teachers Training

Getting Results with PowerBI Course

By One Education

Self-publishing On Amazon with Canva Book Covers - For Beginners

By Apex Learning

Windows 10 Pro Complete Training

By Apex Learning

Microsoft Office Specialist (MOS) - Microsoft Excel, Microsoft Word, Access & PowerPoint

By NextGen Learning

55069 PowerShell for SQL Server Administrators

By Nexus Human

55355 SharePoint 2016 Administration

By Nexus Human

55066 PowerShell for SharePoint Administrators

By Nexus Human

Administering Team Foundation Server 2017

By Nexus Human

Powerful presentation skills (In-House)

By The In House Training Company

Search By Location