Name: Microsoft Server 2012 R2: Installation and Configuration - Part 2
Price: 25 GBP
Availability: InStock

<p>The Payroll Manager and HR Management course offers comprehensive training in using Sage 50 Payroll software for beginners and intermediate users. Covering payroll basics, company settings, pension schemes, employee records, statutory payments, and year-end procedures, participants will gain proficiency in payroll processing and HR management using Sage 50 Payroll.</p>
<h3><strong>Learning Outcomes:</strong></h3>
<ol>
<li>Understand payroll fundamentals, company settings, and legislative requirements.</li>
<li>Master pension scheme basics, pay elements, and processing employee payments.</li>
<li>Learn to handle employee records, generate reports, and navigate year-end procedures.</li>
<li>Gain proficiency in handling timesheets, department analysis, and holiday schemes.</li>
<li>Manage statutory sick pay, maternity pay, student loans, and workplace pensions.</li>
<li>Explore managing company cars, holiday funds, and roll-back procedures.</li>
<li>Understand password management, access rights, and linking payroll to accounts.</li>
<li>Develop intermediate-level skills in Sage 50 Payroll, including global changes and advanced features.</li>
</ol>
<h3><strong>Why buy this Payroll Manager and HR Management?</strong></h3>
<ol>
<li>Unlimited access to the course for forever</li>
<li><strong>Digital Certificate, Transcript, student ID</strong> all included in the price</li>
<li>Absolutely no hidden fees</li>
<li>Directly receive <strong>CPD </strong>accredited qualifications after course completion</li>
<li>Receive one to one assistance on every weekday from professionals</li>
<li>Immediately receive the PDF certificate after passing</li>
<li>Receive the original copies of your certificate and transcript on the next working day</li>
<li>Easily learn the skills and knowledge from the comfort of your home</li>
</ol>
<h3><strong>Certification</strong></h3>
<p>After studying the course materials of the <strong>Payroll Manager and HR Management</strong> you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60.</p>
<h3><strong>Who is this course for?</strong></h3>
<ul>
<li>Aspiring payroll managers and administrators looking to gain Sage 50 Payroll skills.</li>
<li>Human resource professionals aiming to enhance their payroll and HR management skills.</li>
<li>Small business owners and managers responsible for payroll and employee management.</li>
<li>Individuals seeking to enter the field of payroll processing and HR administration.</li>
</ul>
<h3><strong>Prerequisites</strong></h3>
<p>This <strong>Payroll Manager and HR Management </strong>was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.</p>
<h3><strong>Career path</strong></h3>
<div>
<div>
<div>
<div>
<div>
<div>
<ul>
<li>Payroll Manager: Oversee payroll processing, employee records, and statutory payments.</li>
<li>HR Manager: Manage HR operations, employee benefits, and compliance with payroll regulations.</li>
<li>Payroll Administrator: Handle day-to-day payroll tasks, including processing payments and reports.</li>
<li>Small Business Owner: Efficiently manage payroll and HR functions in a small business setting.</li>
<li>HR Coordinator: Assist in HR tasks, employee records, and payroll administration.</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div><div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Sage 50 Payroll for Beginners</td>
				</tr>
								<tr>
					<td colspan="4">Module 1: Payroll Basics</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Payroll Basics</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 2: Company Settings</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Company Settings</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 3: Legislation Settings</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Legislation Settings</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 4: Pension Scheme Basics</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Pension Scheme Basics</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 5: Pay Elements</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Pay Elements</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 6: The Processing Date</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>The Processing Date</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 7: Adding Existing Employees</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Adding Existing Employees</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 8: Adding New Employees</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Adding New Employees</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 9: Payroll Processing Basics</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Payroll Processing Basics</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 10: Entering Payments</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Entering Payments</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 11: Pre-Update Reports</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Pre-Update Reports</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 12: Updating Records</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Updating Records</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 13: e-Submissions Basics</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>e-Submissions Basics</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 14: Process Payroll (November)</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Process Payroll (November)</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 15: Employee Records and Reports</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Employee Records and Reports</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 16: Editing Employee Records</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Editing Employee Records</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 17: Process Payroll (December)</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Process Payroll (December)</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 18: Resetting Payments</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Resetting Payments</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 19: Quick SSP</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Quick SSP</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 20: An Employee Leaves</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>An Employee Leaves</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 21: Final Payroll Run</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Final Payroll Run</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 22: Reports and Historical Data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Reports and Historical Data</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 23: Year-End Procedures</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Year-End Procedures</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Sage 50 Payroll Intermediate Level</td>
				</tr>
								<tr>
					<td colspan="4">Module 1: The Outline View and Criteria</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 01: The Outline View and Criteria</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 2: Global Changes</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 02: Global Changes</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 3: Timesheets</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 03: Timesheets</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 4: Departments and Analysis</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 04: Departments and Analysis</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 5: Holiday Schemes</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 05: Holiday Schemes</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 6: Recording Holidays</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 06: Recording Holidays</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 7: Absence Reasons</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 07: Absence Reasons</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 8: Statutory Sick Pay</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 08: Statutory Sick Pay</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 9: Statutory Maternity Pay</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 09: Statutory Maternity Pay</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 10: Student Loans</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 10: Student Loans</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 11: Company Cars</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 11: Company Cars</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 12: Workplace Pensions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 12: Workplace Pensions</td>
					<td> </td>
					<td><span><i></i> 00:21:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 13: Holiday Funds</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 13: Holiday Funds</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 14: Roll Back</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 14: Process Payroll (November)</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 15: Passwords and Access Rights</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 15: Passwords and Access Rights</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 16: Options and Links</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 16: Options and Links</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 17: Linking Payroll to Accounts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 17: Linking Payroll to Accounts</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mock Exam - Payroll Manager and HR Management</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Final Exam - Payroll Manager and HR Management</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

Studyhub UK

SAP Human Capital Management

Certified Payroll Professional (CPP)

Professional payroll & pensions qualifications (CIPP)

Sage Payroll

Payroll

Employee Management

Payroll Manager and HR Management

General Admission

<p><span>Welcome to <strong>Microsoft sql server development for everyone</strong> Course. The world of data is a vast and complex one. But with the right tools, it can be yours to explore. </span><b>SQL Server</b><span> is one of those tools. It's a powerful database management system that can help you store, manage, and analyse data in ways that were never before possible.</span></p>
<p> </p>
<p><span>In this </span><b>Microsoft SQL Server Development for Everyone!</b><span> course, you'll learn the basics of </span><b>SQL Server development</b><span>. You'll learn how to create and manage databases, tables, and data. You'll also learn how to write </span><b>SQL queries to manipulate data</b><span>.</span></p>
<p> </p>
<p><span>Starting with a solid </span><b>Introduction to SQL</b><span>, you'll grasp core concepts and gain a strong foundation. We'll then dive into Manipulating Tables and Data, equipping you with effective skills for storing, retrieving, updating, and deleting information.</span></p>
<p> </p>
<p><span>But we won't stop there! Our in-depth exploration of Relationships and Foreign Keys will ensure you understand the importance of data integrity and how to </span><b>establish connections between tables</b><span>. You'll create robust and reliable databases with enforced referential integrity. Next, we'll empower you with the tools of Group By and Aggregate Functions, enabling efficient data analysis and summarisation. Extracting meaningful insights from vast amounts of information will become second nature to you.</span></p>
<p> </p>
<p><span>To become a well-rounded </span><b>SQL Server developer</b><span>, we'll conclude the course with</span><b> Advanced SQL Server Objects and Concepts</b><span>. You'll gain a deep understanding of essential elements like stored procedures, views, triggers, and indexes. This knowledge will optimise performance and streamline your development process.</span></p>
<p> </p>
<p><span>By the end of this </span><b>Microsoft SQL Server Development for Everyone!</b><span> course, you'll have a strong understanding of how to use SQL Server to manage and manipulate data. You'll be able to build powerful applications that make better decisions. </span><b>Become a sought-after SQL Server developer</b><span> and master the art of data management. Join us today and unlock your data-driven potential!</span></p>
<p> </p>
<p><b>Learning Outcomes:</b></p>
<p><span>Through this comprehensive course, you should be able to:</span></p>
<p> </p>
<ul>
<li><span>Understand core concepts and gain a strong foundation in SQL Server development.</span></li>
<li><span>Acquire skills to effectively manipulate tables and data.</span></li>
<li><span>Establish relationships and enforce data integrity using foreign keys.</span></li>
<li><span>Utilise group by and aggregate functions for efficient data analysis.</span></li>
<li><span>Explore advanced SQL Server objects and concepts like stored procedures and views.</span></li>
<li><span>Gain proficiency in implementing triggers and optimising database performance.</span></li>
<li><span>Develop the ability to create robust and reliable databases.</span></li>
</ul>
<p> </p>
<p><b>Who is this course for?</b></p>
<p><span>This Microsoft SQL Server Development for Everyone! course is perfect for:</span></p>
<p> </p>
<ul>
<li><span>Aspiring developers looking to enhance their programming skills.</span></li>
<li><span>Professionals seeking to expand their knowledge of SQL Server development.</span></li>
<li><span>Individuals interested in exploring the world of databases and data management.</span></li>
<li><span>Students or graduates pursuing a career in database administration or development.</span></li>
<li><span>Curious learners eager to harness the power of SQL Server.</span></li>
</ul>
<p> </p>
<p><b>Career Path</b></p>
<p><span>Our course will help you to pursue a range of careers, including:</span></p>
<p> </p>
<ul>
<li><span>Database Administrator: £25,000 - £60,000 per year.</span></li>
<li><span>SQL Developer: £30,000 - £65,000 per year.</span></li>
<li><span>Data Analyst: £25,000 - £55,000 per year.</span></li>
<li><span>Business Intelligence Developer: £35,000 - £70,000 per year.</span></li>
<li><span>Software Engineer: £30,000 - £70,000 per year.</span></li>
<li><span>Data Engineer: £40,000 - £80,000 per year.</span></li>
<li><span>Database Architect: £45,000 - £90,000 per year.</span></li>
</ul>
<h3><b>Certification</b></h3>
<p><span>After studying the course materials of the </span><b>Microsoft SQL Server Development for Everyone!</b><span> there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60.</span></p>
<h3><b>Prerequisites</b></h3>
<p><span>This </span><b>Microsoft SQL Server Development for Everyone!</b><span> does not require you to have any prior qualifications or experience. You can just enrol and start learning.This </span><b>Microsoft SQL Server Development for Everyone!</b><span> was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.</span></p>
<p> </p><div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4"> Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction to SQL Server and Databases</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Download and Install SQL Server Express</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Manipulating Tables and Data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Connect to Database Instance and Create a Database</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Drop or Remove Database</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What is a Database Table?</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create an SQL Database Table</td>
					<td> </td>
					<td><span><i></i> 00:32:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert Data into the Table with SQL Script</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert Data into the Table with Management Studio</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Select Data from the Table with SQL Script</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>More Advanced Select Queries Part 1</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Update Data in the Table</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Update Data in the Table with Management Studio GUI</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Delete Data from the Table with SQL Script</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Delete Data from the Table with Management Studio GUI</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Relationships and Foreign Keys</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What are Relationships, Foreign Keys and Normalization</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a Relationship in SQL Server</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert Records in Related Tables</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Run Queries on Related Tables</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Left, Right and Full Joins</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Group By and Aggregate Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Grouping Data using SQL GROUP BY Clause</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL AVG Aggregate Function</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL COUNT Aggregate Function</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL MAX and MIN Aggregate Functions</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL SUM Aggregate Function</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Advanced SQL Server Objects and Concepts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create and Manage Views</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Scalar Valued Functions</td>
					<td> </td>
					<td><span><i></i> 00:27:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Inline Table Valued Functions</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Multi Statement Table Valued Functions</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Stored Procedures</td>
					<td> </td>
					<td><span><i></i> 00:28:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Table Triggers</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Database Scripting, Backup and Restore</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Assignment</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Assignment - Microsoft SQL Server Development for Everyone!</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

Microsoft Certification

Microsoft SQL Server

Microsoft SQL

Microsoft Certified Solutions Associate (MCSA)

SQL Server

Microsoft AZ-303

Microsoft SQL Server Development for Everyone!

<h3><b>Overview</b></h3>
<p><span>Dive into the dynamic world of computer science with our comprehensive 'Computer Science with Python Course'. Python, a versatile and widely used programming language, serves as the foundation for this course, offering learners a gateway into the intricate realm of computing. From installing Python and understanding its documentation to mastering advanced concepts like closures, classes, and data hiding, this course is meticulously designed to cater to beginners and those looking to deepen their knowledge. With a curriculum that's rich and varied, you'll be equipped with the skills to tackle real-world challenges, making you a sought-after asset in the ever-evolving tech industry. </span><span>The course curriculum is structured to ensure a smooth learning curve. Starting with foundational topics such as command line usage, variables, and simple Python syntax, learners will gradually progress to more advanced subjects. </span></p>
<p><span>In the digital age, proficiency in a programming language like Python is invaluable. Whether you're aiming to kickstart a career in tech, enhance your current skill set, or simply satiate your curiosity, this course promises a transformative learning experience. With a blend of theoretical knowledge and its practical application, you'll be poised to make significant strides in the world of computer science.</span></p>
<h4><strong><span>Learning Outcomes of Computer Science with Python Course:</span></strong></h4>
<ol>
<li><span>Understand Python's foundational concepts, including its installation, documentation, and basic syntax.</span></li>
<li><span>Gain proficiency in working with various Python data types such as strings, lists, dictionaries, and tuples.</span></li>
<li><span>Develop the ability to create and manipulate functions, including lambda functions, generators, and closures.</span></li>
<li><span>Acquire skills in object-oriented programming with a focus on classes, inheritance, and data hiding.</span></li>
<li><span>Implement advanced programming constructs and handle exceptions efficiently.</span></li>
</ol>
<p> </p>
<div>
<span>Video Player</span><div id="mep_0"><div><div>https://studyhub.org.uk/wp-content/uploads/2020/01/Computer-Science-with-Python-Course-Introduction-Video-1.mp4</div><div><div></div><div><div><span></span></div></div><div><div></div></div><div><div></div></div></div><div><div></div><div><span>00:00</span></div><div><span><span></span><span></span><span></span><span></span><span><span></span></span><span><span>00:00</span><span></span></span></span></div><div><span>00:00</span></div><div><span>Use Up/Down Arrow keys to increase or decrease volume.</span><div><div></div><div></div></div></div><div></div></div></div></div></div>
<h3></h3>
<h3><b>Why buy this Computer Science with Python Course?</b></h3>
<ol>
<li><b>Digital Certificate, Transcript, student ID</b> all included in the price</li>
<li>Absolutely no hidden fees</li>
<li>Directly receive <b>CPD </b>accredited qualifications after course completion</li>
<li>Receive one to one assistance on every weekday from professionals</li>
<li>Immediately receive the PDF certificate after passing</li>
<li>Receive the original copies of your certificate and transcript on the next working day</li>
<li>Easily learn the skills and knowledge from the comfort of your home</li>
</ol>
<h3><b>Certification</b></h3>
<p>After studying the course materials of the <b>Computer Science with Python Course</b> you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60.</p>
<h3><b>Who is this Computer Science with Python course for?</b></h3>
<ul>
<li><span>Beginners eager to delve into the realm of computer science and programming.</span></li>
<li><span>Individuals looking to add Python programming to their skill set.</span></li>
<li><span>Tech enthusiasts keen on understanding advanced Python concepts.</span></li>
<li><span>Students pursuing computer science and needing a comprehensive Python guide.</span></li>
<li><span>Professionals in tech roles aiming to enhance their coding capabilities.</span></li>
</ul>
<h3><b>Prerequisites</b></h3>
<div>This <b>Computer Science with Python Course </b>was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones.</div>
<div>
<h3><b>Career Path</b></h3>
<ul>
<li><strong><span>Python Developer: </span></strong><span>£45,000 - £70,000 Annually</span></li>
<li><strong><span>Data Scientist: </span></strong><span>£50,000 - £80,000 Annually</span></li>
<li><strong><span>Software Engineer: </span></strong><span>£40,000 - £75,000 Annually</span></li>
<li><strong><span>Backend Developer: </span></strong><span>£45,000 - £72,000 Annually</span></li>
<li><strong><span>Systems Analyst: </span></strong><span>£35,000 - £60,000 Annually</span></li>
<li><strong><span>DevOps Engineer:</span></strong><span> £50,000 - £85,000 Annually</span></li>
</ul>
</div><div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Module 01</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>A Installing Python</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Documentation</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Command Line</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Variables</td>
					<td> </td>
					<td><span><i></i> 00:29:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Simple Python Syntax</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Keywords</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Import Module</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 02</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Additional Topics</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>If Elif Else</td>
					<td> </td>
					<td><span><i></i> 00:31:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Iterable</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>For</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Loops</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Execute</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Exceptions</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 03</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Types</td>
					<td> </td>
					<td><span><i></i> 00:24:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Number Types</td>
					<td> </td>
					<td><span><i></i> 00:28:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>More Number Types</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Strings</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>More Strings</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Files</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lists</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Dictionaries</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Tuples</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Sets</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 04</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Comprehensions</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Definitions</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Functions</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Default Arguments</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Doc Strings</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Variadic Functions</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Factorial</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 05</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Function Objects</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lambda</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Generators</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Closures</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Classes</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Object Initialization</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Class Static Members</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Classic Inheritance</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Hiding</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mock Exam - Python Developer</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Final Exam - Python Developer</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

Online Course Creation

Computing Skills

Computer Science (CS)

Computer Programming

Computer Skills

Computer Science with Python Course

<p>Embark on a transformative journey into the heart of collaborative digital workplaces with our dynamic course, '<strong>Learn the Fundamentals of Microsoft SharePoint.</strong>' Unveil the power of SharePoint as you traverse through meticulously crafted lessons, each a key to unlocking the full potential of this versatile platform. From creating seamless team sites to integrating with Microsoft Teams, this course is your gateway to mastering SharePoint's intricacies. Dive into the world of web part customization, site management, and effective collaboration, ensuring that every minute spent in this course adds a valuable layer to your skill set. Whether you're a budding professional or a seasoned enthusiast, join us in demystifying SharePoint and reshaping the way you collaborate and manage content.</p>
<p><strong>Learning Outcomes</strong></p>
<ul>
<li>Gain a comprehensive understanding of SharePoint's core features and functionalities.</li>
<li>Master the art of creating and customizing team sites, fostering efficient collaboration.</li>
<li>Explore advanced concepts like web part addition, layout editing, and section customization.</li>
<li>Learn to seamlessly integrate Microsoft Teams with SharePoint for enhanced communication.</li>
<li>Acquire the skills to manage site access, create news posts, and utilize SharePoint as a communication hub.</li>
</ul>
<h3><b>Why choose this Learn the Fundamentals of Microsoft SharePoint<span> course</span>?</b></h3>
<ol>
<li>Unlimited access to the course for a lifetime.</li>
<li>Opportunity to earn a certificate accredited by the <b>CPD Quality Standards</b> and <b>CIQ </b>after completing this course.</li>
<li>Structured lesson planning in line with industry standards.</li>
<li>Immerse yourself in innovative and captivating course materials and activities.</li>
<li>Assessments designed to evaluate advanced cognitive abilities and skill proficiency.</li>
<li>Flexibility to complete the Course at your own pace, on your own schedule.</li>
<li>Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.</li>
<li>Unlock career resources for CV improvement, interview readiness, and job success.</li>
</ol>
<h3><b>Who is this Learn the Fundamentals of Microsoft SharePoint<span> </span></b><b><span>course </span></b><b>for?</b></h3>
<ul>
<li>Professionals aiming to enhance their digital collaboration skills.</li>
<li>Individuals seeking a comprehensive grasp of Microsoft SharePoint fundamentals.</li>
<li>Team leaders looking to optimize team sites and streamline content management.</li>
<li>Project managers wanting to leverage SharePoint for efficient project collaboration.</li>
<li>Anyone interested in harnessing the power of Microsoft Teams and SharePoint integration.</li>
</ul>
<h3><b>Career path</b></h3>
<ul>
<li><strong>SharePoint Administrator:</strong> £30,000 - £50,000</li>
<li><strong>Digital Collaboration Specialist:</strong> £35,000 - £55,000</li>
<li><strong>Project Manager (SharePoint):</strong> £40,000 - £60,000</li>
<li><strong>IT Support Specialist:</strong> £25,000 - £45,000</li>
<li><strong>Business Analyst (Collaboration Tools):</strong> £35,000 - £55,000</li>
<li><strong>Information Architect:</strong> £45,000 - £70,000</li>
</ul>
<h3><b>Prerequisites</b></h3>
<p><span>This </span><b>Learn the Fundamentals of Microsoft SharePoint</b><span> does not require you to have any prior qualifications or experience. You can just enrol and start learning.This </span><b>Learn the Fundamentals of Microsoft SharePoint</b><span> was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.</span></p>
<h3><b>Certification</b></h3>
<p><span>After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.</span></p><div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Learn The Fundamentals Of Microsoft PowerPoint</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 01: What is Sharepoint?</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 02: The SharePoint LookBook</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 03: Getting Sharepoint and home page overview</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 04: Create a new team site</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 05: Team site home page</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 06: Uploading files</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 07: Creating a New List</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 08: Adding web parts</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 09: Reorganising and customising web parts</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 10: Republish the team site</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 11: Add members to the team site</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 12: Microsoft Teams &amp; SharePoint integration</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 13: Create a new communication site</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 14: Add countdown timer web part</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 15: Edit web part layouts</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 16: Edit sections</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 17: Add Youtube web part</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 18: Change page look and edit top navigation</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 19: Create a News post</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Lesson 20: Manage Site Access</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

Learning & Development

Online Course Marketing

Microsoft Sharepoint

Professional Skills Course (PSC)

SharePoint

Learn the Fundamentals of Microsoft SharePoint

<h3><b>Overview</b></h3>
<p><b>Uplift Your Career &amp; Skill Up to Your Dream Job - Learning Simplified From Home!</b></p>
<p><span>Kickstart your career &amp; boost your employability by helping you discover your skills, talents and interests with our special </span><b>SharePoint Site Owner </b><span>Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces.</span></p>
<p><span>The </span><b>SharePoint Site Owner </b><span>Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This </span><b>SharePoint Site Owner </b><span>Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field.</span></p>
<p><span>This </span><b>SharePoint Site Owner </b><span>Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly.</span></p>
<p><span>At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support.</span></p>
<h3><b>Why buy this SharePoint Site Owner?</b></h3>
<ol>
<li><span>Unlimited access to the course for forever</span></li>
<li><b>Digital Certificate, Transcript, student ID</b><span> all included in the price</span></li>
<li><span>Absolutely no hidden fees</span></li>
<li><span>Directly receive </span><b>CPD </b><span>accredited qualifications after course completion</span></li>
<li><span>Receive one to one assistance on every weekday from professionals</span></li>
<li><span>Immediately receive the PDF certificate after passing</span></li>
<li><span>Receive the original copies of your certificate and transcript on the next working day</span></li>
<li><span>Easily learn the skills and knowledge from the comfort of your home</span></li>
</ol>
<h3><b>Certification</b></h3>
<p><span>After studying the course materials of the </span><b>SharePoint Site Owner</b><span> there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60.</span></p>
<h3><b>Who is this course for?</b></h3>
<p><span>This </span><b>SharePoint Site Owner</b><span> course is ideal for</span></p>
<ul>
<li><span>Students</span></li>
<li><span>Recent graduates</span></li>
<li><span>Job Seekers</span></li>
<li><span>Anyone interested in this topic</span></li>
<li><span>People already working in the relevant fields and want to polish their knowledge and skill.</span></li>
</ul>
<p> </p>
<h3><b>Prerequisites</b></h3>
<p><span>This </span><b>SharePoint Site Owner</b><span> does not require you to have any prior qualifications or experience. You can just enrol and start learning.This </span><b>SharePoint Site Owner</b><span> was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.</span></p>
<h3><b>Career path</b></h3>
<p><span>As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This </span><b>SharePoint Site Owner </b><span>is a great way for you to gain multiple skills from the comfort of your home.</span></p><div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">SharePoint Site Owner</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 01: Microsoft SharePoint overview</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 02: Screen tour</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 03: Adding logos and colours to your site</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 04: Adding users</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 05: Adding groups</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 06: Adding apps to your site</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 07: Setting up your links</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 08: Adding and changing pages</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 09: Setting up your document libraries</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 10: Uploading and downloading documents</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Assignment</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Assignment - SharePoint Site Owner</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

Trainers Course

John Academy

Microsoft MS-700

Microsoft Certified Technology Specialist (MCTS)

Windows Server

Microsoft AZ-700

70-646 - Windows Server 2008 Administration

<div>
	<h3><strong>Description:</strong></h3>
<p><span>Released by Microsoft, Microsoft Access 2016 is a data-based organization program created to help users analyze data and information. This application deals with managing related data being more efficient compared to other spreadsheet applications. It is impossible to become expert in using this application if you don't know how to use Access 2016 works which this </span><b>Microsoft Office 2016 Access Advanced - Complete Video Course</b><span> is all about.</span></p>
<p><span>Dealing with large amount of data can be stressful if you don't know how to use this Office application in the first place. Using data validation, macros, and implementing advanced form design are some of the features of Access 2016 so take the opportunity to take this course will help you utilize these and more.</span></p>
<h3><b>Assessment:</b></h3>
<ul>
<li><span>At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.</span></li>
<li><span>Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.</span></li>
</ul>
<h3><b>Certification:</b></h3>
<ul>
<li><span>After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.</span></li>
<li><span>Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.</span></li>
</ul>
<h3><b>Who is this Course for?</b></h3>
<p><b>Microsoft Office 2016 Access Advanced - Complete Video Course </b><span>is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.</span></p>
<p><span>As there is no experience and qualification required for this course, it is available for all students from any academic background.</span></p>
<h3><b>Requirements</b></h3>
<p><span>Our</span><b> Microsoft Office 2016 Access Advanced - Complete Video Course</b><span> is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.</span></p>
<h3><b>Career Path</b></h3>
<p><span>After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.</span></p>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Module 01</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Add Controls to Forms</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Enhance Navigation and Organization of Forms</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Conditional Formatting</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 02</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Import Data into Access</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Export Access Data</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Link Tables to External Data Sources</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a Mail Merge</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 03</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a Macro</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Restrict Records by Using a Condition</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Validate Data by Using a Macro</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Automate Data Entry by Using a Macro</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 04</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Manage a Database</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Determine Object Dependency</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 05</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Manage a Database</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Determine Object Dependency</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Document a Database</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 06</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Splitting a Database for Multiple User Access</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Implement Security</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Convert an Access Database to an ACCDE File</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Package a Database with a Digital Signature</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 07</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a Database Switchboard</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Modify a Database Switchboard</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Set Start up Options</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mock Exam- Microsoft Office 2016 Access Advanced - Complete Video Course</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Final Exam- Microsoft Office 2016 Access Advanced - Complete Video Course</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Order Your Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

Microsoft AZ-900

Microsoft Office

Microsoft Access

Microsoft Office 2016 Access Advanced - Complete Video Course

<div>
	<h3><strong>Description:</strong></h3>
<p><span>Nowadays almost every job in the business world involves office products. Whether you're an administrative assistant, office manager, sales professional or business manager, utilizing all of the powerful features of Microsoft Office will make you more efficient and subsequently more marketable. The Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate &amp; Advanced is designed to provide you all the basics of relational database design and through the creation of database objects. You will learn how to use forms, query tables and reports to manage data. You will understand the interface, customization and creation editing of the many objects available within the Microsoft Access application. This course is divided into three separate levels being Basic Microsoft Access, Intermediate Microsoft Access and Advanced Microsoft Access.</span></p>
<h3><b>Assessment:</b></h3>
<ul>
<li><span>At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.</span></li>
<li><span>Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.</span></li>
</ul>
<h3><b>Certification:</b></h3>
<ul>
<li><span>After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.</span></li>
<li><span>Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.</span></li>
</ul>
<h3><b>Who is this Course for?</b></h3>
<p><b>Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate &amp; Advanced </b><span>is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.</span></p>
<p><span>As there is no experience and qualification required for this course, it is available for all students from any academic background.</span></p>
<h3><b>Requirements</b></h3>
<p><span>Our</span><b> Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate &amp; Advanced</b><span> is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.</span></p>
<h3><b>Career Path</b></h3>
<p><span>After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.</span></p>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Microsoft Access - Beginner</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Orientation to Microsoft Access</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:39:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a Simple Access Database</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Get Help and Configure Options in Microsoft Access</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Modify Table Data</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Sort and Filter Records</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Basic Queries</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Sort and Filter Data in a Query</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Perform Calculations in a Query</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Basic Access Forms</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Data on Access Forms</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a Report</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Add Controls to a Report</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Enhance the Appearance of a Report</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Prepare a Report for Print</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Organize Report Information</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Format Reports</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Access - Intermediate</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Relational Database Design</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a Table</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Table Relationships</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Query Joins</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Relate Data Within a Table.avi</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Subdatasheets from</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Field Validation</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Form and Record Validation</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Parameter Queries</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Summarize Data</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Subqueries</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Action Queries</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Unmatched and Duplicate Queries</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Normalization</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a Junction Table</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Improve Table Structure</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Include Control Formatting in a Report</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Add a Calculated Field to a Report</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Add a Subreport to an Existing Report</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Access - Advanced</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Add Controls to Forms</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Enhance Navigation and Organization of Forms</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Conditional Formatting</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Import Data into Access</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Export Access Data</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Link Tables to External Data Sources</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a Mail Merge</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a Macro</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Restrict Records by Using a Condition</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Validate Data by Using a Macro</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Automate Data Entry by Using a Macro</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Manage a Database</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Determine Object Dependency</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Manage a Database</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Determine Object Dependency</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Document a Database</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Splitting a Database for Multiple User Access</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Implement Security</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Convert an Access Database to an ACCDE File</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Package a Database with a Digital Signature</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a Database Switchboard</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Modify a Database Switchboard</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Set Start up Options</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mock Exam- Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate &amp; Advanced</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Final Exam- Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate &amp; Advanced</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

Microsoft AZ-104

Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced

<div>
	<h3><strong>Description:</strong></h3>
<p><span>The 70-640 - Configuring Windows Server 2008 R2 Active Directory course provides the required information that you should know about 70-640: Configuring Windows Server 2008 R2 Active Directory. The course will teach you how to install the Active Directory role, or how to work with Active Directory objects. In the course, you will also learn about the GPOs (Group Policy Adjectives), what Group Policy objects are, restricted Group Policies. You will know analysing security settings, using the Security Configuration Wizard, deploying software with Group Policy, understanding Group Policy Scope, how Group Policy settings are processed, verifying Group Policy settings, and enabling Auditing.</span></p>
<p><span>You will also be able to manage users and groups with the AD, working With Domain Controllers, adding DNS, securing the authentication process, monitoring and supporting AD, planning Active Directory deployment, IDA solutions, and Active Directory Certificate Services.</span></p>
<h3><b>Assessment:</b></h3>
<ul>
<li><span>At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.</span></li>
<li><span>Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.</span></li>
</ul>
<h3><b>Certification:</b></h3>
<ul>
<li><span>After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.</span></li>
<li><span>Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.</span></li>
</ul>
<h3><b>Who is this Course for?</b></h3>
<p><b>70-640 - Configuring Windows Server 2008 R2 Active Directory </b><span>is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.</span></p>
<p><span>As there is no experience and qualification required for this course, it is available for all students from any academic background.</span></p>
<h3><b>Requirements</b></h3>
<p><span>Our</span><b> 70-640 - Configuring Windows Server 2008 R2 Active Directory</b><span> is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.</span></p>
<h3><b>Career Path</b></h3>
<p><span>After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.</span></p>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Installing the Active Directory Role</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What is IDA?</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How to Install the AD DS Role</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating a Windows Server 2008 Forest</td>
					<td> </td>
					<td><span><i></i> 00:22:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>The New Windows 2008 Server Core</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Installing AD DS Server Core</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Domain Controller</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working With Active Directory Objects</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with the MMC</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Custom MMC</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with Objects in Active Directory</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How to Search Through Active Directory</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Active Directory</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Securing and Delegating AD Objects</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Delegation</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Adding Computer Accounts to AD</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Organizing AD with Container Objects</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Joining the Demo</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working With Computer Objects and Accounts</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Recycling the Computer Account</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Automating Computer Account Creation</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Automating Computer Creation</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Understanding GPOs</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Group Policy</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Are Group Policy Objects</td>
					<td> </td>
					<td><span><i></i> 00:21:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Group Policy</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Restricted Group Policies</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Restrcted Group</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Analyzing Security Settings</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using The Security Configuration Wizard</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SCW</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Deploying Software with Group Policy</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Software Deployment</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding Group Policy Scope</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How Group Policy Settings are Processed</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Group Policy Scope</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Verifying Group Policy Settings</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Verifying Group Policy</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Enabling Auditing</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Auditing</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Managing Users and Groups with AD</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Automating User Account Creation</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Automating User Accounts</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with User Attributes</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>User Account Administrative Tasks</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Supporting User Accounts</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using PowerShell to Create User Accounts</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Users with PowerShell</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creation and Management</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>The Basics of Groups</td>
					<td> </td>
					<td><span><i></i> 00:25:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Managing Group</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Best Practices for Using AD Groups</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Automating Group Creation</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Automating Creation of Groups</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Advanced Group Options</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Administering Groups</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working With Domain Controllers</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Installation Options</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How to Install a Domain Controller</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introducing the Operations Masters</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Designing Where to Deploy the Operation Masters</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>FSMO</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SYSVOL Replication with DFS</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Adding DNS</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>DNS Basics</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>DNS Definitions and Terms</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>DNS</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Setting up DNS for the Enterprise</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Global Names</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Securing the Authentication Process</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Password Security Policies</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Passwords</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introducing the Read-Only Domain Controller</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Installing the RODC</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Auditing Authentication Events</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Account Logging</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Monitoring and Supporting AD</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Preparing for Recovery</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Active Directory Tools</td>
					<td> </td>
					<td><span><i></i> 00:24:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Monitoring Active Directory Performance</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Performance Monitor</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Planning Active Directory Deployment</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Are Sites</td>
					<td> </td>
					<td><span><i></i> 00:27:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Deciding on Site Boundaries</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Sites and Subnets</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with Global Catalog Placement with AD Partitions</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Controlling Replication Between Sites</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Managing the Global Catalog</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Configuring AD Trust Relationships</td>
					<td> </td>
					<td><span><i></i> 00:32:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Trusts</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Choosing the Domain and Forest Functional Levels</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">IDA Solutions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding AD FS</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Installing AD FS</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Configuring and Using AD FS</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding AD RMS</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Installing AD RMS</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Configuring and Using AD RMS</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding AD LDS</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Installing AD LDS</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Installing AD LDS</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Configuring and Using AD LDS</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Security Review</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Active Directory Certificate Services</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding AD CS</td>
					<td> </td>
					<td><span><i></i> 00:29:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Installing AD CS</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Configuring and Using AD CS</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mock Exam- 70-640 - Configuring Windows Server 2008 R2 Active Directory</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Final Exam- 70-640 - Configuring Windows Server 2008 R2 Active Directory</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

Active Directory

70-640 - Configuring Windows Server 2008 R2 Active Directory

<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>

				</div>
				<div>
				<div>
					<div><p><span>Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This Microsoft Server 2012 R2: Installation and Configuration - Part 2</span><span> has been specially designed to help learners gain a good command of Microsoft Server 2012 R2: Installation and Configuration</span><span>, providing them with a solid foundation of knowledge to become a qualified professional.</span></p><p><span>Through this Microsoft Server 2012 R2: Installation and Configuration - Part 2</span><span>, you will gain both practical and theoretical understanding of Microsoft Server 2012 R2: Installation and Configuration</span><span> that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.</span></p><p><span>Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals.</span></p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
																					</div>
				</div>
				</div>
				<div>
				<h2>Learning outcome</h2>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Get a deep understanding of the Microsoft Server 2012 R2: Installation and Configuration - Part 2 just in hours not years</span>
									</li>
								<li>
											<span>
													</span>
										<span>Familiar yourself with the recent development and updates of the relevant industry</span>
									</li>
								<li>
											<span>
													</span>
										<span>Know how to use your theoretical and practical knowledge to adapt in any working environment</span>
									</li>
								<li>
											<span>
													</span>
										<span>Get help from our expert tutors anytime you need</span>
									</li>
								<li>
											<span>
													</span>
										<span> Access to course contents that are designed and prepared by industry professionals</span>
									</li>
								<li>
											<span>
													</span>
										<span>Study at your convenient time and from wherever you want </span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
						</div>
			</div>
		</div>
				<div>
			<div>
					<div>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
																					</div>
				</div>
				</div>
				<div>
				<h2>Requirements</h2>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>No formal qualifications required, anyone from any academic background can take this course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to any internet-enabled smart device.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<h2>Why should I take this course?</h2>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>8+ hours of on-demand video lectures and downloadable resources.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Affordable premium-quality E-learning content, you can learn at your own pace.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will receive a completion certificate upon completing the course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Internationally recognized Accredited Qualification will boost up your resume.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will learn the researched and proven approach adopted by successful salespeople to transform their careers.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will be able to incorporate various practical sales techniques successfully and understand your customers better.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>

Skill Up

Microsoft Certified Trainer (MCT)

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Microsoft Server 2012 R2: Installation and Configuration - Part 2

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

Nexus Human

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>This course is intended for Information Technology (IT) Professionals who have some experience working with Windows Server and are looking for a single five-day course that covers core administration components and technologies in Windows Server. This course also helps server administrators from previous Windows Server versions to update their knowledge and skills related to Windows Server. The course is also for individuals from a service desk role who wish to transition into server maintenance.</p><p>This five-day instructor-led course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing identity, networking, storage and compute by using Windows Server, and who need to understand the scenarios, requirements, and options that are available and applicable to Windows Server. The course teaches IT professionals the fundamental administration skills required to deploy and support Windows Server in most organizations.</p></div><div id="course-pills-2"><h3>Module 1: Windows Server Administration Overview </h3> <ul> <li>Introducing Windows Server</li> <li>Windows Server Core Overview</li> <li>Windows Server administration principles and tools overview</li> </ul> <h3>Module 2: Identity Services in Windows Server </h3> <ul> <li>AD DS Overview</li> <li>Deploying Windows Server domain controllers</li> <li>Azure AD overview</li> <li>Implementing Group Policy</li> <li>Active Directory Certificate Services overview</li> </ul> <h3>Module 3: Network Infrastructure services in Windows Server </h3> <ul> <li>Deploying and managing DHCP</li> <li>Deploying and managing DNS service</li> <li>Deploying and managing IPAM</li> <li>Remote Access Services in Windows Server</li> </ul> <h3>Module 4: File Servers and Storage management in Windows Server </h3> <ul> <li>Volumes and File Systems in Windows Server</li> <li>Implementing sharing in Windows Server</li> <li>Implementing Storage Spaces in Windows Server</li> <li>Implementing Data Deduplication</li> <li>Implementing iSCSI</li> <li>Deploying Distributed File System</li> </ul> <h3>Module 5: Hyper-V virtualization and containers in Windows Server </h3> <ul> <li>Hyper-V in Windows Server</li> <li>Configuring VMs</li> <li>Securing virtualization in Windows Server</li> <li>Containers in Windows Server</li> <li>Overview of Kubernetes</li> </ul> <h3>Module 6: High Availability in Windows Server</h3> <ul> <li>Planning for failover clustering implementation</li> <li>Creating and configuring failover cluster</li> <li>Overview of stretch clusters</li> <li>High availability and disaster recovery solutions with Hyper-V VMs</li> </ul> <h3>Module 7: Disaster recovery in Windows Server</h3> <ul> <li>Hyper-V Replica</li> <li>Backup and restore infrastructure in Windows Server</li> </ul> <h3>Module 8: Windows Server security</h3> <ul> <li>Credentials and privileged access protection</li> <li>Hardening Windows Server</li> <li>JEA in Windows Server</li> <li>Securing and analyzing SMB traffic</li> <li>Windows Server update management</li> </ul> <h3>Module 9: RDS in Windows Server</h3> <ul> <li>Overview of RDS</li> <li>Configuring a session-based desktop deployment</li> <li>Overview of personal and pooled virtual desktops</li> </ul> <h3>Module 10: Remote access and web services in Windows Server</h3> <ul> <li>Implementing VPNs</li> <li>Implementing Always On VPN</li> <li>Implementing NPS</li> <li>Implementing Web Server in Windows Server</li> </ul> <h3>Module 11: Server and performance monitoring in Windows Server </h3> <ul> <li>Overview of Windows Server monitoring tools</li> <li>Using Performance Monitor</li> <li>Monitoring event logs for troubleshooting</li> </ul> <h3>Module 12: Upgrade and migration in Windows Server</h3> <ul> <li>AD DS migration</li> <li>Storage Migration Service</li> <li>Windows Server migration tools</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55371 Windows Server 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 55371 Windows Server 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>

55371 Windows Server Administration

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The primary audience for this course is Enterprise Desktop Support Technicians (EDSTs). These technicians provide Tier 2 support to users with domain-joined computers running the Windows 11 OS, typically in medium to large enterprise organizations.</p>Overview<p>Important Windows 11 features    How these features are used in an Active Directory    How to troubleshoot these features</p><p>This is a 5-day ILT course that is designed to provide you with the knowledge and skills required to support and troubleshoot Windows 11 PCs and devices in an on-premises Windows Server Active Directory domain environment.</p></div><div id="course-pills-2"><h3>1: Introducing Windows 11</h3> <ul> <li> Overview of Windows 11</li>  <li> Recommendations for typical troubleshooting procedures</li>  <li>Troubleshooting installation and deployment</li>  <li> Introduction to management and troubleshooting tools</li> </ul>  <h3>2: Administering Windows 11 remotely</h3> <ul> <li> Using Windows Admin Center</li>  <li>Using Windows PowerShell</li>  <li> Implementing Remote Management</li> </ul>  <h3>3: Troubleshooting startup and performing system recovery</h3> <ul> <li> Recovering Windows 11</li>  <li> Configuring the Registry</li>  <li>Troubleshooting Windows 11 startup</li>  <li> Implementing and troubleshooting BitLocker</li>  <li> Troubleshooting OS service Issues</li> </ul>  <h3>4: Troubleshooting devices and device drivers</h3> <ul> <li> Overview of hardware troubleshooting</li>  <li>Troubleshooting device drivers</li> </ul>  <h3>5: Configuring and troubleshooting network connectivity</h3> <ul> <li> Configuring network connectivity</li>  <li> Troubleshooting network connectivity</li>  <li> Implementing and troubleshooting name resolution</li>  <li> Implementing and troubleshooting remote access</li> </ul>  <h3>6: Troubleshooting Group Policy</h3> <ul> <li>Overview of Group Policy</li>  <li> Resolve GPO application issues on client devices</li> </ul>  <h3>7: Configuring and Troubleshooting Security Settings</h3> <ul> <li> Implementing network security</li>  <li> Implementing Windows 11 security features</li>  <li> Configuring and troubleshooting user accounts</li> </ul>  <h3>8: Configuring and Troubleshooting User State</h3> <ul> <li> Implementing and troubleshooting user state</li>  <li> Implementing and troubleshooting Folder Redirection</li> </ul>  <h3>9: Configuring and Troubleshooting Resource Access</h3> <ul> <li> Configuring and troubleshooting file access.</li>  <li> Configuring and troubleshooting shared folders.</li>  <li> Implementing and troubleshooting Work Folders.</li>  <li>Managing and troubleshooting printers.</li>  <li>Recovering files.</li> </ul>  <h3>10: Troubleshooting apps</h3> <ul> <li> Troubleshooting desktop apps</li>  <li> Troubleshooting app compatibility</li>  <li> Managing UWP apps</li> </ul>  <h3>11: Monitoring and Maintaining Windows 11</h3> <ul> <li> Monitoring Windows 11</li>  <li>Optimizing Windows 11 performance</li>  <li> Managing Windows 11 updates</li> </ul></div>

IT Technician

IT Support

IT Certifications

Computer Maintenance

55342 Supporting and Troubleshooting Windows 11

<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

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>Successful students have experience and knowledge in IT operations, including networking, virtualization, identity, security, business continuity, disaster recovery, data platforms, and governance. Students also have experience designing and architecting solutions.</p> <p>Before attending this course, students must have previous experience deploying or administering Azure resources and strong conceptual knowledge of:</p> <ul> <li><p>Azure compute technologies such as VMs, containers and serverless solutions</p> </li> <li><p>Azure virtual networking to include load balancers</p> </li> <li><p>Azure Storage technologies (unstructured and databases)</p> </li> <li><p>General application design concepts such as messaging and high availability</p> </li> </ul><p></p><p></p><p>This course teaches Azure Solution Architects how to design infrastructure solutions. Course topics cover governance, compute, application architecture, storage, data integration, authentication, networks, business continuity, and migrations. The course combines lecture with case studies to demonstrate basic architect design principles.</p><p></p>Prerequisites<p>Before attending this course, students must have previous experience deploying or administering Azure resources and conceptual knowledge of:  </p><li>Azure Active Directory</li>  <li>Azure compute technologies such as VMs, containers and serverless solutions</li>  <li>Azure virtual networking to include load balancers</li>  <li>Azure Storage technologies (unstructured and databases)</li>  <li>General application design concepts such as messaging and high availability</li>  <li>AZ-104T00 - Microsoft Azure Administrator<p></p></li></div><div id="course-pills-2"><h3>1 - Design governance</h3> <ul> <li>Design for governance</li> <li>Design for management groups</li> <li>Design for subscriptions</li> <li>Design for resource groups</li> <li>Design for resource tags</li> <li>Design for Azure Policy</li> <li>Design for role-based access control (RBAC)</li> <li>Design for Azure landing zones</li> </ul> <h3>2 - Design an Azure compute solution</h3> <ul> <li>Choose an Azure compute service</li> <li>Design for Azure Virtual Machines solutions</li> <li>Design for Azure Batch solutions</li> <li>Design for Azure App Service solutions</li> <li>Design for Azure Container Instances solutions</li> <li>Design for Azure Kubernetes Service solutions</li> <li>Design for Azure Functions solutions</li> <li>Design for Azure Logic Apps solutions</li> </ul> <h3>3 - Design a data storage solution for non-relational data</h3> <ul> <li>Design for data storage</li> <li>Design for Azure storage accounts</li> <li>Design for data redundancy</li> <li>Design for Azure Blob Storage</li> <li>Design for Azure Files</li> <li>Design for Azure managed disks</li> <li>Design for storage security</li> </ul> <h3>4 - Design a data storage solution for relational data</h3> <ul> <li>Design for Azure SQL Database</li> <li>Design for Azure SQL Managed Instance</li> <li>Design for SQL Server on Azure Virtual Machines</li> <li>Recommend a solution for database scalability</li> <li>Recommend a solution for database availability</li> <li>Design security for data at rest, data in motion, and data in use</li> <li>Design for Azure SQL Edge</li> <li>Design for Azure Cosmos DB and Table Storage</li> </ul> <h3>5 - Design data integration</h3> <ul> <li>Design a data integration solution with Azure Data Factory</li> <li>Design a data integration solution with Azure Data Lake</li> <li>Design a data integration and analytic solution with Azure Databricks</li> <li>Design a data integration and analytic solution with Azure Synapse Analytics</li> <li>Design strategies for hot, warm, and cold data paths</li> <li>Design an Azure Stream Analytics solution for data analysis</li> </ul> <h3>6 - Design an application architecture</h3> <ul> <li>Describe message and event scenarios</li> <li>Design a messaging solution</li> <li>Design an Azure Event Hubs messaging solution</li> <li>Design an event-driven solution</li> <li>Design a caching solution</li> <li>Design API integration</li> <li>Design an automated app deployment solution</li> <li>Design an app configuration management solution</li> </ul> <h3>7 - Design authentication and authorization solutions</h3> <ul> <li>Design for identity and access management (IAM)</li> <li>Design for Microsoft Entra ID</li> <li>Design for Microsoft Entra business-to-business (B2B)</li> <li>Design for Azure Active Directory B2C (business-to-customer)</li> <li>Design for conditional access</li> <li>Design for identity protection</li> <li>Design for access reviews</li> <li>Design service principals for applications</li> <li>Design managed identities</li> <li>Design for Azure Key Vault</li> </ul> <h3>8 - Design a solution to log and monitor Azure resources</h3> <ul> <li>Design for Azure Monitor data sources</li> <li>Design for Azure Monitor Logs (Log Analytics) workspaces</li> <li>Design for Azure Workbooks and Azure insights</li> <li>Design for Azure Data Explorer</li> </ul> <h3>9 - Design network solutions</h3> <ul> <li>Recommend a network architecture solution based on workload requirements</li> <li>Design patterns for Azure network connectivity services</li> <li>Design outbound connectivity and routing</li> <li>Design for on-premises connectivity to Azure Virtual Network</li> <li>Choose an application delivery service</li> <li>Design for application delivery services</li> <li>Design for application protection services</li> </ul> <h3>10 - Design a solution for backup and disaster recovery</h3> <ul> <li>Design for backup and recovery</li> <li>Design for Azure Backup</li> <li>Design for Azure blob backup and recovery</li> <li>Design for Azure files backup and recovery</li> <li>Design for Azure virtual machine backup and recovery</li> <li>Design for Azure SQL backup and recovery</li> <li>Design for Azure Site Recovery</li> </ul> <h3>11 - Design migrations</h3> <ul> <li>Evaluate migration with the Cloud Adoption Framework</li> <li>Describe the Azure migration framework</li> <li>Assess your on-premises workloads</li> <li>Select a migration tool</li> <li>Migrate your structured data in databases</li> <li>Select an online storage migration tool for unstructured data</li> <li>Migrate offline data</li> </ul> <h3>12 - Introduction to the Microsoft Azure Well-Architected Framework</h3> <ul> <li>Azure Well-Architected Framework pillars</li> <li>Cost optimization</li> <li>Operational excellence</li> <li>Performance efficiency</li> <li>Reliability</li> <li>Security</li> </ul> <h3>13 - Microsoft Azure Well-Architected Framework - Cost Optimization</h3> <ul> <li>Develop cost-management discipline</li> <li>Design with a cost-efficiency mindset</li> <li>Design for usage optimization</li> <li>Design for rate optimization</li> <li>Monitor and optimize over time</li> </ul> <h3>14 - Microsoft Azure Well-Architected Framework - Operational excellence</h3> <ul> <li>Embrace DevOps culture</li> <li>Establish development standards</li> <li>Evolve operations with observability</li> <li>Deploy with confidence</li> <li>Automate for efficiency</li> <li>Adopt safe deployment practices</li> </ul> <h3>15 - Microsoft Azure Well-Architected Framework - Performance efficiency</h3> <ul> <li>Negotiate realistic performance targets</li> <li>Design to meet capacity requirements</li> <li>Achieve and sustain performance</li> <li>Improve efficiency through optimization</li> </ul> <h3>16 - Microsoft Azure Well-Architected Framework - Reliability</h3> <ul> <li>Design for business requirements</li> <li>Design for resilience</li> <li>Design for recovery</li> <li>Design for operations</li> <li>Keep it simple</li> </ul> <h3>17 - Microsoft Azure Well-Architected Framework - Security</h3> <ul> <li>Plan your security readiness</li> <li>Design to protect confidentiality</li> <li>Design to protect integrity</li> <li>Design to protect availability</li> <li>Sustain and evolve your security posture</li> </ul> <h3>18 - Getting started with the Microsoft Cloud Adoption Framework for Azure</h3> <ul> <li>Customer narrative</li> <li>Common blockers</li> </ul> <h3>19 - Prepare for successful cloud adoption with a well-defined strategy</h3> <ul> <li>Customer narrative</li> <li>Capture strategic motivation</li> <li>Define objectives and key results</li> <li>Evaluate financial considerations</li> <li>Understand technical considerations</li> <li>Create a business case</li> </ul> <h3>20 - Prepare for cloud adoption with a data-driven plan</h3> <ul> <li>Customer narrative</li> </ul> <h3>21 - Choose the best Azure landing zone to support your requirements for cloud operations</h3> <ul> <li>Customer narrative</li> <li>Common operating models</li> <li>Design areas for Azure landing zones</li> <li>Design principles for Azure landing zones</li> <li>Journey to the target architecture</li> <li>Choose an Azure landing zone option</li> <li>Deploy the Azure landing zone accelerator</li> <li>Enhance your landing zone</li> </ul> <h3>22 - Migrate to Azure through repeatable processes and common tools</h3> <ul> <li>Customer narrative</li> <li>Migration process</li> <li>Migration tools</li> <li>Common tech platforms</li> </ul> <h3>23 - Address tangible risks with the Govern methodology of the Cloud Adoption Framework for Azure</h3> <ul> <li>Customer narrative</li> <li>Govern methodology</li> <li>Corporate policies</li> <li>Governance disciplines</li> <li>Deploy a cloud governance foundation</li> <li>The Cost Management discipline</li> </ul> <h3>24 - Ensure stable operations and optimization across all supported workloads deployed to the cloud</h3> <ul> <li>Establish business commitments</li> <li>Deploy an operations baseline</li> <li>Protect and recover</li> <li>Enhance an operations baseline</li> <li>Manage platform and workload specialization</li> </ul> <h3>25 - Innovate applications by using Azure cloud technologies</h3> <ul> <li>Follow the innovation lifecycle</li> <li>Azure technologies for the build process</li> <li>Infuse your applications with AI</li> <li>Azure technologies for measuring business impact</li> <li>Azure technologies for the learn process</li> </ul> <h3>26 - Prepare for cloud security by using the Microsoft Cloud Adoption Framework for Azure</h3> <ul> <li>Customer narrative</li> <li>Methodology</li> <li>Security roles and responsibilities</li> <li>Simplify compliance and security</li> <li>Simplify security implementation</li> <li>Security tools and policies</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans AZ-305T00: Designing Microsoft Azure Infrastructure 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 AZ-305T00: Designing Microsoft Azure Infrastructure 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>

AWS Certified Solutions Architect

AZ-305T00 Designing Microsoft Azure Infrastructure Solutions

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

Azure PowerShell

Powershell

Power Automate

Microsoft Power Automate

AZ-040T00 Automating Administration with Powershell

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material.</p>Overview<p>After completing this course, you will be able to:<br />Describe key database concepts in the context of SQL Server<br />Describe database languages used in SQL Server<br />Describe data modelling techniques<br />Describe normalization and denormalization techniques<br />Describe relationship types and effects in database design<br />Describe the effects of database design on performance<br />Describe commonly used database objects</p><p>This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance.<br />This material updates and replaces course Microsoft course 10985 which was previously published under the same title.</p></div><div id="course-pills-2"><h4>Module 1: Introduction to databases</h4><ul><li>Introduction to Relational Databases</li><li>Other Databases and Storage</li><li>Data Analysis</li><li>SQL Server Database Languages</li></ul><h4>Module 2: Data Modeling</h4><ul><li>Data Modelling</li><li>Designing a Database</li><li>Relationship Modeling</li></ul><h4>Module 3: Normalization</h4><ul><li>Fundamentals of Normalization</li><li>Normal Form</li><li>Denormalization</li></ul><h4>Module 4: Relationships</h4><ul><li>Introduction to Relationships</li><li>Planning Referential Integrity</li></ul><h4>Module 5: Performance</h4><ul><li>Indexing</li><li>Query Performance</li><li>Concurrency</li></ul><h4>Module 6: Database Objects</h4><ul><li>Tables</li><li>Views</li><li>Stored Procedures, Triggers and Functions</li></ul></div>

AWS Certified Database

Database Administration

55315: Introduction to SQL Databases

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>The Microsoft 365 Endpoint Administrator is responsible for deploying, configuring, securing, managing, and monitoring devices and client applications in a corporate setting. Their duties include managing identity, access, policies, updates, and apps. They work alongside the M365 Enterprise Administrator to develop and execute a device strategy that aligns with the requirements of a modern organization. Microsoft 365 Endpoint Administrators should be well-versed in M365 workloads and possess extensive skills and experience in deploying, configuring, and maintaining Windows 11 and later, as well as non-Windows devices. Their role emphasizes cloud services over on-premises management technologies.</p><p></p><p></p><p>In this course, students will learn to plan and execute an endpoint deployment strategy using contemporary deployment techniques and implementing update strategies. The course introduces essential elements of modern management, co-management approaches, and Microsoft Intune integration. It covers app deployment, management of browser-based applications, and key security concepts such as authentication, identities, access, and compliance policies. Technologies like Microsoft Entra ID, Azure Information Protection, and Microsoft Defender for Endpoint are explored to protect devices and data.</p><p></p>Prerequisites<p>The Modern Desktop Administrator must be familiar with M365 workloads and must have strong skills and experience of deploying, configuring, and maintaining Windows 11 and later, and non-Windows devices.</p></div><div id="course-pills-2"><h3>1 - Explore the Enterprise Desktop</h3> <ul> <li>Examine benefits of modern management</li> <li>Examine the enterprise desktop life-cycle model</li> <li>Examine planning and purchasing</li> <li>Examine desktop deployment</li> <li>Plan an application deployment</li> <li>Plan for upgrades and retirement</li> </ul> <h3>2 - Explore Windows Editions</h3> <ul> <li>Examine Windows client editions and capabilities</li> <li>Select client edition</li> <li>Examine hardware requirements</li> </ul> <h3>3 - Understand Microsoft Entra ID</h3> <ul> <li>Examine Microsoft Entra ID</li> <li>Compare Microsoft Entra ID and Active Directory Domain Services</li> <li>Examine Microsoft Entra ID as a directory service for cloud apps</li> <li>Compare Microsoft Entra ID P1 and P2 plans</li> <li>Examine Microsoft Entra Domain Services</li> </ul> <h3>4 - Manage Microsoft Entra identities</h3> <ul> <li>Examine RBAC and user roles in Microsoft Entra ID</li> <li>Create and manage users in Microsoft Entra ID</li> <li>Create and manage groups in Microsoft Entra ID</li> <li>Manage Microsoft Entra objects with PowerShell</li> <li>Synchronize objects from AD DS to Microsoft Entra ID</li> </ul> <h3>5 - Manage device authentication</h3> <ul> <li>Describe Microsoft Entra join </li> <li>Examine Microsoft Entra join prerequisites limitations and benefits</li> <li>Join devices to Microsoft Entra ID</li> <li>Manage devices joined to Microsoft Entra ID</li> </ul> <h3>6 - Enroll devices using Microsoft Configuration Manager</h3> <ul> <li>Deploy the Microsoft Configuration Manager client</li> <li>Monitor the Microsoft Configuration Manager client</li> <li>Manage the Microsoft Configuration Manager client</li> </ul> <h3>7 - Enroll devices using Microsoft Intune</h3> <ul> <li>Manage mobile devices with Intune</li> <li>Enable mobile device management</li> <li>Explain considerations for device enrollment</li> <li>Manage corporate enrollment policy</li> <li>Enroll Windows devices in Intune</li> <li>Enroll Android devices in Intune</li> <li>Enroll iOS devices in Intune</li> <li>Explore device enrollment manager</li> <li>Monitor device enrollment</li> <li>Manage devices remotely</li> </ul> <h3>8 - Execute device profiles</h3> <ul> <li>Explore Intune device profiles</li> <li>Create device profiles</li> <li>Create a custom device profile</li> </ul> <h3>9 - Oversee device profiles</h3> <ul> <li>Monitor device profiles in Intune</li> <li>Manage device sync in Intune</li> <li>Manage devices in Intune using scripts</li> </ul> <h3>10 - Maintain user profiles</h3> <ul> <li>Examine user profile</li> <li>Explore user profile types</li> <li>Examine options for minimizing user profile size</li> <li>Deploy and configure folder redirection</li> <li>Sync user state with Enterprise State Roaming</li> <li>Configure Enterprise State Roaming in Azure</li> </ul> <h3>11 - Execute mobile application management</h3> <ul> <li>Examine mobile application management</li> <li>Examine considerations for mobile application management</li> <li>Prepare line-of-business apps for app protection policies</li> <li>Implement mobile application management policies in Intune</li> <li>Manage mobile application management policies in Intune</li> </ul> <h3>12 - Deploy and update applications</h3> <ul> <li>Deploy applications with Intune</li> <li>Add apps to Intune</li> <li>Manage Win32 apps with Intune</li> <li>Deploy applications with Configuration Manager</li> <li>Deploying applications with Group Policy</li> <li>Assign and publish software</li> <li>Explore Microsoft Store for Business</li> <li>Implement Microsoft Store Apps</li> <li>Update Microsoft Store Apps with Intune</li> <li>Assign apps to company employees</li> </ul> <h3>13 - Administer endpoint applications</h3> <ul> <li>Manage apps with Intune</li> <li>Manage Apps on non-enrolled devices</li> <li>Deploy Microsoft 365 Apps with Intune</li> <li>Additional Microsoft 365 Apps Deployment Tools</li> <li>Configure Microsoft Edge Internet Explorer mode</li> <li>App Inventory Review</li> </ul> <h3>14 - Protect identities in Microsoft Entra ID</h3> <ul> <li>Explore Windows Hello for Business</li> <li>Deploy Windows Hello</li> <li>Manage Windows Hello for Business</li> <li>Explore Microsoft Entra ID Protection</li> <li>Manage self-service password reset in Microsoft Entra ID</li> <li>Implement multi-factor authentication</li> </ul> <h3>15 - Enable organizational access</h3> <ul> <li>Enable access to organization resources</li> <li>Explore VPN types and configuration</li> <li>Explore Always On VPN</li> <li>Deploy Always On VPN</li> </ul> <h3>16 - Implement device compliance</h3> <ul> <li>Protect access to resources using Intune</li> <li>Explore device compliance policy</li> <li>Deploy a device compliance policy</li> <li>Explore conditional access</li> <li>Create conditional access policies</li> </ul> <h3>17 - Generate inventory and compliance reports</h3> <ul> <li>Report enrolled devices inventory in Intune</li> <li>Monitor and report device compliance</li> <li>Build custom Intune inventory reports</li> <li>Access Intune using Microsoft Graph API</li> </ul> <h3>18 - Deploy device data protection</h3> <ul> <li>Explore Windows Information Protection</li> <li>Plan Windows Information Protection</li> <li>Implement and use Windows Information Protection</li> <li>Explore Encrypting File System in Windows client</li> <li>Explore BitLocker</li> </ul> <h3>19 - Manage Microsoft Defender for Endpoint</h3> <ul> <li>Explore Microsoft Defender for Endpoint</li> <li>Examine key capabilities of Microsoft Defender for Endpoint</li> <li>Explore Windows Defender Application Control and Device Guard</li> <li>Explore Microsoft Defender Application Guard</li> <li>Examine Windows Defender Exploit Guard</li> <li>Explore Windows Defender System Guard</li> </ul> <h3>20 - Manage Microsoft Defender in Windows client</h3> <ul> <li>Explore Windows Security Center</li> <li>Explore Windows Defender Credential Guard</li> <li>Manage Microsoft Defender Antivirus</li> <li>Manage Windows Defender Firewall</li> <li>Explore Windows Defender Firewall with Advanced Security</li> </ul> <h3>21 - Manage Microsoft Defender for Cloud Apps</h3> <ul> <li>Explore Microsoft Defender for Cloud Apps</li> <li>Planning Microsoft Defender for Cloud Apps</li> <li>Implement Microsoft Defender for Cloud Apps</li> </ul> <h3>22 - Assess deployment readiness</h3> <ul> <li>Examine deployment guidelines</li> <li>Explore readiness tools</li> <li>Assess application compatibility</li> <li>Explore tools for application compatibility mitigation</li> <li>Prepare network and directory for deployment</li> <li>Plan a pilot</li> </ul> <h3>23 - Deploy using the Microsoft Deployment Toolkit</h3> <ul> <li>Evaluate traditional deployment methods</li> <li>Set up the Microsoft Deployment Toolkit for client deployment</li> <li>Manage and deploy images using the Microsoft Deployment Toolkit</li> </ul> <h3>24 - Deploy using Microsoft Configuration Manager</h3> <ul> <li>Explore client deployment using Configuration Manager</li> <li>Examine deployment components of Configuration Manager</li> <li>Manage client deployment using Configuration Manager</li> <li>Plan in-place upgrades using Configuration Manager</li> </ul> <h3>25 - Deploy Devices using Windows Autopilot</h3> <ul> <li>Use Autopilot for modern deployment</li> <li>Examine requirements for Windows Autopilot</li> <li>Prepare device IDs for Autopilot</li> <li>Implement device registration and out-of-the-box customization</li> <li>Examine Autopilot scenarios</li> <li>Troubleshoot Windows Autopilot</li> </ul> <h3>26 - Implement dynamic deployment methods</h3> <ul> <li>Examine subscription activation</li> <li>Deploy using provisioning packages</li> <li>Use Windows Configuration Designer</li> <li>Use Microsoft Entra join with automatic MDM enrollment</li> </ul> <h3>27 - Plan a transition to modern endpoint management</h3> <ul> <li>Explore using co-management to transition to modern endpoint management</li> <li>Examine prerequisites for co-management</li> <li>Evaluate modern management considerations</li> <li>Evaluate upgrades and migrations in modern transitioning</li> <li>Migrate data when modern transitioning</li> <li>Migrate workloads when modern transitioning</li> </ul> <h3>28 - Manage Windows 365</h3> <ul> <li>Explore Windows 365</li> <li>Configure Windows 365</li> <li>Administer Windows 365</li> </ul> <h3>29 - Manage Azure Virtual Desktop</h3> <ul> <li>Examine Azure Virtual Desktop</li> <li>Explore Azure Virtual Desktop</li> <li>Configure Azure Virtual Desktop</li> <li>Administer Azure Virtual Desktop</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans MD-102T00 : Microsoft 365 Endpoint Administrator 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 MD-102T00 : Microsoft 365 Endpoint Administrator 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 365

MD-102T00 Microsoft 365 Endpoint Administrator

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>This course is for Azure Security Engineers who are planning to take the associated certification exam, or who are performing security tasks in their day-to-day job. This course would also be helpful to an engineer that wants to specialize in providing security for Azure-based digital platforms and play an integral role in protecting an organization's data.</p><p></p><p></p><p>This course provides IT Security Professionals with the knowledge and skills needed to implement security controls, maintain an organization?s security posture, and identify and remediate security vulnerabilities. This course includes security for identity and access, platform protection, data and applications, and security operations.</p><p></p>Prerequisites<p></p><li>AZ-104T00 - Microsoft Azure Administrator</li>  <li>Security best practices and industry security requirements such as defense in depth, least privileged access, role-based access control, multi-factor authentication, shared responsibility, and zero trust model.</li>  <li>Be familiar with security protocols such as Virtual Private Networks (VPN), Internet Security Protocol (IPSec), Secure Socket Layer (SSL), disk and data encryption methods.</li>  <li>Have some experience deploying Azure workloads. This course does not cover the basics of Azure administration, instead the course content builds on that knowledge by adding security specific information.</li>  <li>Have experience with Windows and Linux operating systems and scripting languages. Course labs may use PowerShell and the CLI.</li><p></p></div><div id="course-pills-2"><h3>1 - Manage identities in Microsoft Entra ID</h3> <ul> <li>Secure users in Microsoft Entra ID</li> <li>Secure groups in Microsoft Entra ID</li> <li>Recommend when to use external identities</li> <li>Secure external identities</li> <li>Implement Microsoft Entra Identity protection</li> </ul> <h3>2 - Manage authentication by using Microsoft Entra ID</h3> <ul> <li>Configure Microsoft Entra Verified ID</li> <li>Implement multifactor authentication (MFA)</li> <li>Implement passwordless authentication</li> <li>Implement password protection</li> <li>Implement single sign-on (SSO)</li> <li>Integrate single sign-on (SSO) and identity providers</li> <li>Recommend and enforce modern authentication protocols </li> </ul> <h3>3 - Manage authorization by using Microsoft Entra ID</h3> <ul> <li>Configure Azure role permissions for management groups, subscriptions, resource groups, and resources</li> <li>Assign built-in roles in Microsoft Entra ID</li> <li>Assign built-in roles in Azure</li> <li>Create and assign a custom role in Microsoft Entra ID</li> <li>Implement and manage Microsoft Entra Permissions Management</li> <li>Configure Microsoft Entra Privileged Identity Management </li> <li>Configure role management and access reviews by using Microsoft Entra Identity Governance</li> <li>Implement Conditional Access policies</li> </ul> <h3>4 - Manage application access in Microsoft Entra ID</h3> <ul> <li>Manage access to enterprise applications in Microsoft Entra ID, including OAuth permission grants</li> <li>Manage app registrations in Microsoft Entra ID</li> <li>Configure app registration permission scopes</li> <li>Manage app registration permission consent</li> <li>Manage and use service principals</li> <li>Manage managed identities for Azure resources</li> <li>Recommend when to use and configure a Microsoft Entra Application Proxy, including authentication</li> </ul> <h3>5 - Plan and implement security for virtual networks</h3> <ul> <li>Plan and implement Network Security Groups (NSGs) and Application Security Groups (ASGs)</li> <li>Plan and implement User-Defined Routes (UDRs)</li> <li>Plan and implement Virtual Network peering or gateway</li> <li>Plan and implement Virtual Wide Area Network, including secured virtual hub</li> <li>Secure VPN connectivity, including point-to-site and site-to-site</li> <li>Implement encryption over ExpressRoute</li> <li>Configure firewall settings on PaaS resources</li> <li>Monitor network security by using Network Watcher, including NSG flow logging</li> </ul> <h3>6 - Plan and implement security for private access to Azure resources</h3> <ul> <li>Plan and implement virtual network Service Endpoints</li> <li>Plan and implement Private Endpoints</li> <li>Plan and implement Private Link services</li> <li>Plan and implement network integration for Azure App Service and Azure Functions</li> <li>Plan and implement network security configurations for an App Service Environment (ASE)</li> <li>Plan and implement network security configurations for an Azure SQL Managed Instance</li> </ul> <h3>7 - Plan and implement security for public access to Azure resources</h3> <ul> <li>Plan and implement Transport Layer Security (TLS) to applications, including Azure App Service and API Management</li> <li>Plan, implement, and manage an Azure Firewall, Azure Firewall Manager and firewall policies</li> <li>Plan and implement an Azure Application Gateway</li> <li>Plan and implement an Azure Front Door, including Content Delivery Network (CDN)</li> <li>Plan and implement a Web Application Firewall (WAF)</li> <li>Recommend when to use Azure DDoS Protection Standard</li> </ul> <h3>8 - Plan and implement advanced security for compute</h3> <ul> <li>Plan and implement remote access to public endpoints, Azure Bastion and just-in-time (JIT) virtual machine (VM) access</li> <li>Configure network isolation for Azure Kubernetes Service (AKS)</li> <li>Secure and monitor AKS</li> <li>Configure authentication for AKS</li> <li>Configure security for Azure Container Instances (ACIs)</li> <li>Configure security for Azure Container Apps (ACAs)</li> <li>Manage access to Azure Container Registry (ACR)</li> <li>Configure disk encryption, Azure Disk Encryption (ADE), encryption as host, and confidential disk encryption</li> <li>Recommend security configurations for Azure API Management</li> </ul> <h3>9 - Plan and implement security for storage</h3> <ul> <li>Configure access control for storage accounts</li> <li>Manage life cycle for storage account access keys</li> <li>Select and configure an appropriate method for access to Azure Files</li> <li>Select and configure an appropriate method for access to Azure Blob Storage</li> <li>Select and configure an appropriate method for access to Azure Tables</li> <li>Select and configure an appropriate method for access to Azure Queues</li> <li>Select and configure appropriate methods for protecting against data security threats, including soft delete, backups, versioning, and immutable storage</li> <li>Configure Bring your own key (BYOK)</li> <li>Enable double encryption at the Azure Storage infrastructure level</li> </ul> <h3>10 - Plan and implement security for Azure SQL Database and Azure SQL Managed Instance</h3> <ul> <li>Enable database authentication by using Microsoft Entra ID</li> <li>Enable and monitor database audit</li> <li>Identify use cases for the Microsoft Purview governance portal</li> <li>Implement data classification of sensitive information by using the Microsoft Purview governance portal</li> <li>Plan and implement dynamic mask</li> <li>Implement transparent data encryption?</li> <li>Recommend when to use Azure SQL Database Always Encrypted</li> </ul> <h3>11 - Plan, implement, and manage governance for security</h3> <ul> <li>Create, assign, and interpret security policies and initiatives in Azure Policy</li> <li>Configure security settings by using Azure Blueprint</li> <li>Deploy secure infrastructures by using a landing zone</li> <li>Create and configure an Azure Key Vault</li> <li>Recommend when to use a dedicated Hardware Security Module (HSM)</li> <li>Configure access to Key Vault, including vault access policies and Azure Role Based Access Control</li> <li>Manage certificates, secrets, and keys</li> <li>Configure key rotation</li> <li>Configure backup and recovery of certificates, secrets, and keys</li> </ul> <h3>12 - Manage security posture by using Microsoft Defender for Cloud</h3> <ul> <li>Implement Microsoft Defender for Cloud</li> <li>Identify and remediate security risks by using the Microsoft Defender for Cloud Secure Score and Inventory</li> <li>Assess compliance against security frameworks and Microsoft Defender for Cloud</li> <li>Add industry and regulatory standards to Microsoft Defender for Cloud</li> <li>Add custom initiatives to Microsoft Defender for Cloud</li> <li>Connect hybrid cloud and multicloud environments to Microsoft Defender for Cloud</li> <li>Identify and monitor external assets by using Microsoft Defender External Attack Surface Management</li> </ul> <h3>13 - Configure and manage threat protection by using Microsoft Defender for Cloud</h3> <ul> <li>Enable workload protection services in Microsoft Defender for Cloud, including Microsoft Defender for Storage, Databases, Containers, App Service, Key Vault, Resource Manager, and DNS</li> <li>Configure Microsoft Defender for Servers</li> <li>Configure Microsoft Defender for Azure SQL Database</li> <li>Manage and respond to security alerts in Microsoft Defender for Cloud</li> <li>Configure workflow automation by using Microsoft Defender for Cloud</li> <li>Evaluate vulnerability scans from Microsoft Defender for Server</li> </ul> <h3>14 - Configure and manage security monitoring and automation solutions</h3> <ul> <li>Monitor security events by using Azure Monitor</li> <li>Configure data connectors in Microsoft Sentinel</li> <li>Create and customize analytics rules in Microsoft Sentinel</li> <li>Configure automation in Microsoft Sentinel</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans AZ-500T00 Microsoft Azure Security Technologies 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 AZ-500T00 Microsoft Azure Security Technologies 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>

CompTIA Security+

AZ-500T00 Microsoft Azure Security Technologies

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

3376 Courses delivered Online

Payroll Manager and HR Management

By Studyhub UK

Microsoft SQL Server Development for Everyone!

By Studyhub UK

Computer Science with Python Course

By Studyhub UK

Learn the Fundamentals of Microsoft SharePoint

By Studyhub UK

SharePoint Site Owner

By Studyhub UK

70-646 - Windows Server 2008 Administration

By John Academy

Microsoft Office 2016 Access Advanced - Complete Video Course

By John Academy

Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced

By John Academy

70-640 - Configuring Windows Server 2008 R2 Active Directory

By John Academy

Microsoft Server 2012 R2: Installation and Configuration - Part 2

By Skill Up