Get our Bestselling Ethical Hacker Course V13 for Only $12.99

For a limited time, check out some of our most popular courses for free on Udemy.  View Free Courses.

Microsoft Server Technology Training Series

Course Level: Beginner
Duration: 119 Hrs 34 Min
Total Videos: 534 On-demand Videos

Master Windows Server administration skills for support roles and small business environments with practical, real-world training in Windows Server 2016.

Course Description

Microsoft® Server Technology Training Series is the course I would give you if your job is starting to lean on Windows Server and you need to stop guessing your way through the basics. I built this training around the practical tasks that show up first in real environments: getting a server installed correctly, understanding what Active Directory does for the business, managing storage without creating a mess, and troubleshooting the problems people usually wait too long to investigate. If you have to support a small domain, help maintain an existing Windows Server environment, or prepare for a fundamentals-level certification path, this course gives you the working knowledge you actually need.

This is on-demand training, so you can start immediately and work through it at your own pace. That matters more than people admit. Server concepts build on one another. If you rush past the basics of roles, storage, services, and network dependencies, everything that follows feels harder than it should. I designed this series so you can slow down where it counts and revisit the pieces that need repetition. That is the right way to learn server administration.

What this course teaches you

This series focuses on the core responsibilities of Windows Server administration using Windows Server 2016 as the teaching platform. You learn how the operating system is organized, how server management works, and how the major building blocks fit together in a business network. That includes identity and access concepts, disk and storage management, file and print services, core network services, monitoring tools, and basic troubleshooting techniques.

I want students to walk away with a mental map of the server environment. Not just “I know these terms,” but “I understand what happens when this service fails” and “I know where to look when users cannot reach a shared folder or authenticate to a domain.” That is the difference between memorizing a screen and being useful on the job.

The course also introduces the kinds of tasks that newer administrators are usually handed first:

  • Installing and preparing Windows Server for use in a small or mid-sized environment
  • Understanding server roles and features, and why role selection matters
  • Managing storage so that data is available, organized, and easier to recover
  • Using built-in monitoring and troubleshooting tools instead of reacting blindly
  • Supporting directory services, file shares, print resources, and network services

That mix is deliberate. A lot of training teaches isolated tools. Real support work is more connected than that. A DNS problem can look like an authentication issue. A permissions issue can look like a storage issue. A failed service can interrupt file sharing, printing, and application access all at once. You need to understand the relationships, not just the menu paths.

Who should take this course

This course fits you if you are new to server administration, moving into a help desk or desktop support role that touches infrastructure, or trying to formalize what you have already been doing on the job. It is also a smart choice if you are a student or career changer who needs a structured introduction to Windows Server before moving into more advanced administration or certification study.

I especially recommend it for:

  • Help desk technicians who need to understand what happens behind the login screen
  • Desktop support staff who are being asked to help with Active Directory, shares, and printers
  • Junior system administrators who need a stronger foundation in Windows Server concepts
  • IT students preparing for an entry-level Microsoft certification track
  • Small-business IT generalists who manage servers without a large infrastructure team

If you already know how to click through Windows tools but cannot explain why a domain controller matters, or why a server role exists, this is the right level. If you are already managing production servers daily, you may find parts of the course basic, but I still think the structure is valuable because it reinforces the parts that are easy to overlook under pressure.

My honest advice: do not skip fundamentals because they look simple. Most server outages are not caused by exotic failures. They are caused by basic misunderstandings about storage, identity, permissions, or name resolution. That is exactly what this course is meant to fix.

Windows Server 2016 fundamentals and administration basics

The first part of the course introduces Windows Server 2016 as an operating system and explains how server administration differs from working on a desktop. That distinction matters. Servers are built to provide services reliably, consistently, and often to multiple users at once. You are not just “using a computer.” You are managing a system that other people depend on for authentication, data access, and application availability.

You will learn the core ideas behind server roles, features, and management interfaces. That includes understanding the server desktop experience, where to find the tools administrators use, and how Windows Server is organized so that you can work efficiently. I always want students to get comfortable with the administrative workflow early: opening the right consoles, interpreting what they show you, and knowing when a problem belongs in a service, policy, network, or storage layer.

We also spend time on the administrative mindset. On a server, you care about change control, consistency, and predictable results. Small mistakes have larger consequences than they do on a workstation. One unnecessary configuration change can affect authentication, file access, or remote connectivity for many users. A good administrator learns to make deliberate changes and verify them.

By the end of this section, you should be able to explain what a Windows Server system is expected to do, how it is managed, and what kinds of tasks belong to the server administrator rather than the end user or the help desk.

Managing Windows Server 2016 in the real world

Administration is where theory meets daily work. In this portion of the course, you move from “what is a server?” to “how do I actually manage one?” That means understanding common management tools, basic server configuration, administrative access, and the operational habits that keep a server stable.

You will work through the essential management tasks that every administrator should know early. This includes handling the server environment, navigating administrative utilities, and understanding how changes are applied and monitored. The goal is not to turn you into a specialist in one tool. The goal is to make you comfortable managing Windows Server as a system.

There is also a strong emphasis on organizational structure. If you are going to work in Active Directory environments, you need to understand why organizational units, groups, and administrative boundaries matter. Poor structure creates confusion fast: permissions become hard to audit, administration becomes inconsistent, and support requests pile up because nobody knows where objects live or who controls them.

That is why this section matters to employers. They are not only looking for someone who can install software. They want someone who can keep the environment understandable. A good administrator reduces chaos. That starts with solid management habits.

Storage management, data organization, and why it matters

Storage is one of the most practical topics in the course because storage mistakes are expensive. If data cannot be written, found, protected, or recovered, the server has failed at its most important job. In this section, you learn the fundamentals of managing storage in Windows Server 2016, including the concepts you need to understand disks, volumes, and available storage options.

This is not just about formatting drives. It is about designing storage so that data is organized sensibly and the server remains usable as the workload changes. You need to know how storage choices affect performance, reliability, and maintenance. A well-planned storage layout can make backups simpler, reduce downtime during maintenance, and prevent unnecessary headaches when capacity grows.

In a real environment, storage problems show up in many forms. A user cannot save a file. A shared folder is full. A virtual machine is running out of room. A service stops because its data volume is unavailable. Once you understand how Windows Server handles storage, those problems become easier to diagnose and much less intimidating to fix.

This section also helps you think like an administrator when it comes to data protection. You may not be designing enterprise storage architectures in an entry-level role, but you should know enough to avoid risky decisions. I care more about students understanding why storage decisions matter than memorizing terms for the sake of a test.

Monitoring and troubleshooting servers without panic

Every server administrator eventually faces the same moment: something is not working, and users are waiting. This part of the course gives you the basic discipline for handling that situation without flailing around. You learn how to observe server behavior, identify likely causes, and use built-in tools to narrow problems down logically.

That troubleshooting mindset is one of the most valuable habits you can develop. I teach students to avoid random clicking. Start with the symptom, verify what is actually broken, and then trace the issue through the layers that matter: service status, connectivity, storage, permissions, configuration, and name resolution. The order matters because good troubleshooting is about eliminating possibilities efficiently.

Monitoring is equally important. You cannot fix what you are not watching. A healthy server environment depends on checking indicators before problems become incidents. Whether you are reviewing event information, watching performance behavior, or confirming service availability, the point is to build a routine that keeps you ahead of failures instead of always reacting after the fact.

Employers love this skill because it saves time. A technician who can isolate a problem quickly is worth far more than one who escalates everything immediately. This course gives you the foundation for that kind of confidence.

Essential services: identity, access, and core network functions

The essential services section ties the server into the rest of the network. This is where students begin to understand the services that make Windows environments function as shared systems rather than isolated machines. Identity services, network name services, and basic infrastructure functions all show up here in practical terms.

For most organizations, the ability to identify users and systems correctly is non-negotiable. If authentication is broken, people cannot work. If name resolution is wrong, systems cannot find each other properly. If a service is misconfigured, access can appear intermittent or inconsistent, which is often worse than a complete failure because it is harder to diagnose.

You will learn why these services matter, how they interact, and what can go wrong when one of them is missing or misconfigured. I like this section because it forces you to think beyond the individual server. A Windows Server environment is not one machine doing one job. It is a coordinated set of services that depend on one another.

That understanding is essential for anyone who wants to support user accounts, access control, or internal network services. Once you see how these pieces connect, a lot of common support issues stop looking random.

File and print services you can actually support

File and print is one of those areas that gets dismissed as “basic,” usually by people who have never had to clean up a broken share structure or explain permissions to frustrated users. In practice, it is one of the most common service areas an administrator supports. This course gives you the grounding you need to understand how file and print resources are published, accessed, and managed on a Windows Server network.

You will look at how shared data is exposed to users, why permissions must be planned carefully, and why print services still matter in many offices, even if the workflow is less glamorous than newer cloud-based tools. A lot of IT support work boils down to making sure people can reach the right file, at the right time, with the right access.

This section also reinforces a central lesson: permissions are not the same as visibility. Users may see a share but still not be able to use it correctly. Or they may be able to access a resource but not in the way the business intended. If you understand file and print services well, you reduce confusion and improve support quality.

That skill is useful in almost any organization with shared drives, departmental folders, or network printers. In other words, nearly every organization.

Windows network services and applications

The final technical area of the course pulls together networking and applications so you can see how Windows Server supports business operations beyond simple file sharing. This is where students start connecting server behavior to the services and applications users actually rely on.

Network services are critical because they let the server communicate in a predictable way with clients and other systems. If you misunderstand how network dependencies work, you will waste time chasing the wrong layer of the problem. This section gives you the vocabulary and framework to think more clearly about server-to-client communication, service delivery, and application support.

It also helps you prepare for more advanced server and networking study. Once you understand core Windows Server services, you are in a much better position to learn virtualization, advanced identity management, more complex storage options, and deeper network configuration later on. Foundations matter. I cannot stress that enough.

For students aiming at an IT support or junior administration role, this section is a bridge between basic server knowledge and the broader infrastructure world. It makes the rest of the path less intimidating.

Hands-on labs and practical skill building

Reading about servers is one thing. Building and configuring them is where the skill becomes real. The hands-on lab portion of this course is where you start translating concepts into actions. You work through a structured lab environment that introduces installation and setup tasks, virtual machine preparation, and basic administration inside Windows Server.

This is especially valuable because many students understand concepts better when they can see the system behave in front of them. Installing a domain controller, configuring server and client virtual machines, and working with the desktop experience gives you context that theory alone cannot provide. Once you have touched the system yourself, the terminology becomes much easier to remember and apply.

The lab work also supports repeatable practice. If you are new to server administration, repetition is your friend. The more often you work through setup and configuration tasks, the more natural they become. That matters when you move into a real job and have to perform under time pressure.

My rule for new administrators is simple: if you cannot build it in a lab, you do not really understand it yet. Lab work exposes the gaps fast, and that is a good thing.

The specific lab focus on virtual machines and Active Directory administration gives you a practical footing for real-world support work. You are not just memorizing concepts; you are practicing the tasks you are most likely to encounter early in your career.

Career value and certification preparation

This course supports students who want a stronger foundation for entry-level Windows Server work and for fundamentals-level certification preparation. Microsoft® server knowledge shows up in support roles across small businesses, internal IT departments, managed service providers, and help desk teams that support domain-based environments. If you can explain core server concepts clearly and handle basic administrative tasks, you become much more useful much faster.

Career-wise, this training is relevant to roles such as:

  • Help Desk Technician
  • Desktop Support Specialist
  • Junior Systems Administrator
  • IT Support Specialist
  • Technical Support Analyst

For salary context, the U.S. Bureau of Labor Statistics reports that computer support specialists and network and computer systems administrators earn solid middle-tier wages, with pay varying by region, experience, and employer size. That is exactly why foundational server skills matter. They move you from general support tasks into responsibilities that organizations depend on more directly.

If you are studying for an entry-level Microsoft certification path, this course gives you the conceptual backbone you need before you start drilling into test objectives. Certification study goes better when the material already makes sense. You are less likely to memorize answers and more likely to understand the system.

I always tell students that certification is useful, but only if it reflects real competence. This course is designed to help you build both.

What you should know before you start

You do not need to arrive as a server expert. That is the point of the course. Still, a few things will help you get more out of it. You should be comfortable using Windows at the user level, understand basic computer concepts, and be willing to work through terminology carefully. If you know how to navigate folders, manage files, and recognize the difference between a local machine and a networked one, you are ready.

It also helps if you bring a patient mindset. Server administration is detail work. You will see names that look similar, services that sound similar, and configuration options that matter in ways that are not obvious at first glance. That is normal. The students who progress fastest are usually the ones who stay methodical and ask, “What is this doing?” instead of rushing to “How do I make it work right now?”

If your next step is formal IT work, this course gives you a clean starting point. If you are already employed, it helps you fill in the gaps that on-the-job learning often leaves behind. Either way, you end up with a better understanding of how Windows Server supports users, data, and business operations.

Why this course is worth your time

I built this course to be practical, not decorative. Too many server introductions spend time on definitions and skip the operational judgment that makes those definitions useful. This series does the opposite. It teaches you the concepts, yes, but it keeps bringing you back to the real questions: What does this do for the business? What breaks when this fails? Where should you look first? How do you avoid making the problem worse?

If you want a course that gives you a sturdy foundation in Windows Server 2016 administration, this is a strong place to start. You will come away with better instincts, better vocabulary, and a much clearer sense of how the server side of IT actually works. That is what employers notice. That is what helps you solve problems. And that is what makes this training worth taking seriously.

Microsoft® is a trademark of Microsoft Corporation. This content is for educational purposes.

Who Benefits From This Course

Frequently Asked Questions

What is the scope of the Microsoft Server Technology Training Series and what are the key topics covered?

The Microsoft Server Technology Training Series provides comprehensive coverage of Windows Server 2016, focusing on core administration tasks essential for supporting small to mid-sized environments. The course encompasses fundamental server concepts such as installation, roles, features, storage management, and network services. It emphasizes practical skills for managing identity, storage, file sharing, printing, and troubleshooting common issues encountered in real-world scenarios.

Key topics include managing server roles, understanding Active Directory, configuring storage solutions, monitoring server health, supporting core network services like DNS and DHCP, and supporting file and print resources. The course also introduces network applications and services, preparing students for entry-level support roles. Its structure ensures a focus on interconnected support tasks, highlighting how various services depend on each other, which is crucial for effective server management and troubleshooting.

How does this course prepare students for a Windows Server 2016 certification exam, and which certifications does it support?

This course offers a practical foundation aligned with the objectives of Microsoft certifications such as the Microsoft Certified: Windows Server 2016 Fundamentals and the MTA 98-365: Windows Server Administration Fundamentals exam. It covers essential topics like server installation, management, storage, Active Directory, and network services, which are critical domains in these exams. The hands-on labs and real-world scenarios reinforce understanding, making exam preparation more effective.

By understanding how server roles interact, troubleshooting common issues, and managing core services, students develop both conceptual knowledge and practical skills. This dual approach helps in passing certification exams and, more importantly, applying the knowledge in actual support environments. The training emphasizes understanding the “why” behind tasks, which enhances retention and confidence during testing and on-the-job support.

What are the career benefits of completing this Windows Server 2016 training course?

Completing this course equips students with the foundational skills necessary for roles such as Help Desk Technician, Desktop Support Specialist, Junior Systems Administrator, or IT Support Associate. It enhances employability by demonstrating a clear understanding of Windows Server environments, which are central to most organizational IT infrastructures. The course also helps candidates gain confidence in managing server roles, troubleshooting issues, and supporting network services.

Furthermore, the course provides a solid base for advancing into more specialized certifications and roles, such as network or systems administrator positions. Employers value candidates who understand the dependencies between services like Active Directory, DNS, and storage, as these are critical for maintaining operational continuity. Overall, the course helps learners move from basic support tasks to more responsible, system-critical functions, boosting career prospects and earning potential.

What preparation strategies are recommended for success in this course and subsequent certification exams?

To succeed, students should have a basic familiarity with Windows operating systems, especially folder navigation, file management, and network concepts. A patient, methodical approach to learning is essential, as the course involves detailed configuration and troubleshooting tasks. It is beneficial to actively participate in hands-on labs, repeating exercises to reinforce skills and build confidence.

Additionally, reviewing key concepts regularly, such as server roles, storage management, and network services, helps solidify understanding. Utilizing supplementary materials like practice exams, online tutorials, and Microsoft’s official documentation can prepare students for certification exams. Developing a troubleshooting mindset—focusing on symptoms, verifying issues, and methodically narrowing causes—is also crucial for both the course and real-world support work.

Who is the ideal audience for this Windows Server 2016 training course?

This course is ideal for IT support professionals such as help desk technicians, desktop support staff, and junior system administrators who are new to server management or need a structured understanding of Windows Server 2016. It is also suitable for students or career changers aiming to enter IT support roles or pursue entry-level Microsoft certifications. Additionally, small-business IT personnel managing servers without a dedicated infrastructure team will find this course valuable.

Even experienced support staff who understand how to navigate Windows tools but lack a conceptual framework will benefit from the course’s structured approach. It helps reinforce foundational knowledge, ensuring that support professionals can explain the purpose of server features and troubleshoot issues more effectively. Overall, the course targets those looking to build practical, real-world skills that translate directly into support roles and career advancement in Windows Server environments.

Included In This Course

Module 1 Introducing Windows Server 2016

  •    Module 1 Notes
  •    1. Windows Server 2016 Fundamentals Intro
  •    2. Mod 1 Introducing Windows Server 2016
  •    3. Mod 1a Introducing Windows Server 2016

Module 2 Managing Windows Server 2016

  •    Module 2 Notes
  •    4. Mod 2 Managing Windows Server 2016
  •    5. Mod 2a Managing Windows Server 2016

Module 3 Managing Storage

  •    Module 3 Notes
  •    6. Mod 3 Managing Storage
  •    7. Mod 3a Managing Storage

Module 4 Monitoring and Troubleshooting Servers

  •    Module 4 Notes
  •    8. Mod 4 Monitoring and Troubleshooting Servers
  •    9. Mod 4a Monitoring and Troubleshooting Servers

Module 5 Essential Services

  •    Module 5 Notes
  •    10. Mod 5 Essential Services
  •    11. Mod 5a Essential Services

Module 6 Understanding File and Print Services

  •    Module 6 Notes
  •    12. Mod 6 Understanding File and Print Services

Module 7 Windows Network Services and Applications

  •    Module 7 Notes
  •    13. Mod 7 Windows Network Services and Applications-
  •    14. Mod 7a Windows Network Services and Applications-

Mod 8 Key Takeaways

  •    Key Takeaway Notes
  •    15. Key takeaways Intro
  •    16. Key takeaways - Module 1 Introducing Windows Server 2016
  •    17. Key takeaways - Module 2 Managing Windows Server 2016
  •    18 Key takeaways - Module 3 Storing Data in Windows Server 2016
  •    19. Key takeaways - Module 4 Monitoring and Troubleshooting Servers
  •    20. Key takeaways - Module 5 Essential Services
  •    21. Key takeaways - Module 6 Understanding File and Print Services
  •    22. Key takeaways - Module 7 Windows Network Services and Applications

Mod 9 Terms to Know

  •    Terms to Know Notes
  •    23. Terms to Know Intro
  •    24. Terms to Know - Module 1 Introducing Windows Server 2016
  •    25. Terms to Know - Module 2 Managing Windows Server 2016
  •    26 Terms to Know - Module 3 Storing Data in Windows Server 2016
  •    27. Terms to Know - Module 4 Monitoring and Troubleshooting Servers
  •    28. Terms to Know - Module 5 Essential Services
  •    29. Terms to Know - Module 6 Understanding File and Print Services
  •    30. Terms to Know - Module 7 Windows Network Services and Applications

Mod 10 Hands on Labs

  •    Hands on Labs Setup Notes
  •    01 MTA 98-365 Windows Server 2016 Administration Fundamentals Lab setup
  •    02 Step by Step Install VMware Player 15 in Windows 10 1
  •    03 Installing and Configuring DC1 Virtual Machine
  •    04 Installing and Configuring SRV-1 Virtual Machine
  •    05 Installing and Configuring Client 1 Virtual Machine
  •    06 Installing and Configuring the Router Virtual Machine
  •    07 Creating and Configuring SRV-2 Virtual Machine
  •    08 Working with Windows Server 2016 Desktop Experience
  •    09 Managing Organizational Units and Groups in AD DS

Module 1 Understanding Security Layers

  •    Module 1 Notes
  •    1.0 Security Fundamentals Instructor
  •    1.1 Security Fundamentals Intro
  •    1.2 Understanding Security Layers Part1
  •    1.3 Understanding Security Layers Part2

Module 2 Authentication, Authorization, and Accounting

  •    Module 2 Notes
  •    2.0 Authentication, Authorization & Accounting Part1
  •    2.1 Authentication, Authorization & Accounting Part2
  •    2.2 Authentication, Authorization & Accounting Demo

Module 3 Understanding Security Policies

  •    Module 3 Notes
  •    3.0 Understanding Security Policies

Module 4 Understanding Network Security

  •    Module 4 Notes
  •    4.0 Understanding Network Security Part1
  •    4.1 Understanding Network Security Part2

Module 5 Locking Down Server and Client

  •    Module 5 Notes
  •    5.0 Locking Down the Server and Client
  •    5.1 Locking Down the Server and Client Part2

Module 6 Key Takeaways

  •    Key Takeaway Notes
  •    6.0 Key Take Aways Intro
  •    6.1 Understanding Security Layers
  •    6.2 Authentication Authorization and Accounting
  •    6.3 Understanding Security Policies
  •    6.4 Understanding Network Security
  •    6.5 Security Fundamentals Part 2

Module 7 Terms to Know

  •    Terms to Know Notes
  •    7.0 Terms to Know Intro
  •    7.1 Understanding Security Layers Terms
  •    7.2 Authentication Authorization and Accounting Terms
  •    7.3 Understanding Security Policies Terms
  •    7.4 Understanding Network Security Terms
  •    7.5 Locking Down Server and Client Terms

Module 1 Understanding Local Area Networking

  •    Module 1 Notes
  •    1.0 Intro to Networking Fundamentals
  •    1.1 Exam Overview
  •    1.1 Examining Local Network Devices and Data Transfers 1a
  •    1.1 Examining Local Network Devices and Data Transfers 1b
  •    1.1 Examining Local Network Devices and Data Transfers 1c
  •    1.1 Examining Local Network Devices and Data Transfers 1d
  •    1.1 Examining Local Network Devices and Data Transfers 1e
  •    1.1 Examining Local Network Devices and Data Transfers 1f
  •    1.2 Examining Local Network Devices and Data Transfers Part 2a
  •    1.2 Examining Local Network Devices and Data Transfers Part 2b

Module 2 Defining Networks with the OSI Model

  •    Module 2 Notes
  •    2.1 Defining Networks with OSI Model Part 1a
  •    2.2 Defining Networks with OSI Model Part 1b
  •    2.3 Defining Networks with OSI Model Part 1c
  •    2.4 Defining Networks with OSI Model Part 1d
  •    2.5 Defining Networks with OSI Model Part 1e
  •    2.6 Defining Networks with OSI Model Part 1f
  •    2.7 Defining Networks with OSI Model Part 1g
  •    2.8 Defining Networks with OSI Model Part 1h

Module 3 Understanding Wired and Wireless Networks

  •    Module 3 Notes
  •    3.1 Understand Wired and Wireless Networks Part1
  •    3.2 Understand Wired and Wireless Networks Part2

Module 4 Understanding Internet Protocol

  •    Module 4 Notes
  •    4.1 Understanding Internet Protocol Part1
  •    4.2 Understanding Internet Protocol Part2

Module 5 Implementing TCP-IP in the command line

  •    Module 5 Notes
  •    5.1 Implementing TCPIP in the Command Line

Module 6 Working with Networking Services

  •    Module 6 Notes
  •    6.1 Working with Networking Services

Module 7 Understanding Wide Area Networks

  •    Module 7 Notes
  •    7.1 Understanding Wide Area Network Part1
  •    7.2 Understanding Wide Area Network Part2

Module 8 Defining Network Infrastructure and Security

  •    Module 8 Notes
  •    8.1 Defining Network Infrastructure & Network Security Part1
  •    8.2 Defining Network Infrastructure & Network Security Part2

Module 9 Key Takeaways

  •    Key Takeaway Notes
  •    1. Key Take Aways of Networking Fundamentals
  •    2. Key Take Aways Mod1
  •    3. Key Take Aways Mod2
  •    4. Key Take Aways Mod3
  •    5. Key Take Aways Mod4
  •    6. Key Take Aways Mod5
  •    7. Key Take Aways Mod6
  •    8. Key Take Aways Mod7

Module 10 Terms to Know

  •    Terms to Know Notes
  •    1. Terms to Know Networking Fundamentals
  •    2. Terms to Know Mod1
  •    3. Terms to Know Mod2
  •    4. Terms to Know Mod3
  •    5. Terms to Know Mod4
  •    6. Terms to Know Mod5
  •    7. Terms to Know Mod6
  •    8. Terms to Know Mod7
  •    9. Terms to Know Mod8

Module 1: Deploy a Microsoft Azure SQL Database

  •    Introduction
  •    Introducing the Azure SQL Database Part 1
  •    Introducing the Azure SQL Database Part 2
  •    Setting Up Azure Lab
  •    Chose a Service Tier Part 1
  •    Chose a Service Tier Part 2
  •    Create Servers and Databases Part 1
  •    Creating a Azure SQL Server and Database Lab
  •    Create Servers and Databases Part 2
  •    Create Servers and Databases Part 3
  •    Connecting SSMS to Azure SQL Lab Part 1
  •    Connecting SSMS to Azure SQL Lab Part 2
  •    Create a Sysadmin Account
  •    Creating Azure SQL Logins and Users Lab
  •    Congure Elastic Pools
  •    Creating and Conguring an Elastic Pool Lab

Module 2: Plan for SQL Server Installation

  •    Plan for an IaaS or On-Premises Deployment Part 1
  •    Plan for an IaaS or On-Premises Deployment Part 2
  •    Select the Appropriate Size for a Virtual Machine
  •    Plan Storage Pools Based on Performance Requirements Part 1
  •    Plan Storage Pools Based on Performance Requirements Part 2
  •    Evaluate Best Practices for Installation
  •    Design a Storage Layout for a SQL Server Virtual Machine

Module 3: Deploy SQL Server Instances

  •    Deploy a SQL Server Instance in IaaS and On-Premises
  •    Restoring AdventureWorks 2016 Database Lab
  •    Provision an Azure Virtual Machine to Host a SQL Server Instance
  •    Provisioning an Azure Virtual Machine to Host a SQL Server Lab
  •    Manually Install SQL Server on an Azure Virtual Machine
  •    Installing SQL 2016 Lab Part 1
  •    Installing SQL 2016 Lab Part 2
  •    Automate the Deployment of SQL Server Databases
  •    Exploring Azure SQL Database Automation Lab
  •    Deploy SQL Server by Using Templates
  •    Managing JSON Templates Lab

Module 4: Deploy SQL Server Databases to Azure Virtual Machines

  •    Migrate an On-Premises SQL Server Database to an Azure Virtual Machine
  •    Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 1
  •    Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 2
  •    Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 3
  •    Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 4
  •    Generate Benchmark Data for Performance Needs
  •    Generating Benchmark Data Lab Part 1
  •    Generating Benchmark Data Lab Part 2
  •    Perform Performance Tuning on Azure IaaS
  •    Perform Performance Tuning on Azure IaaS Lab Part 1
  •    Perform Performance Tuning on Azure IaaS Lab Part 2
  •    Support Availability Sets in Azure Part 1
  •    Support Availability Sets in Azure Part 2
  •    Manage High Availability Lab Part 1
  •    Manage High Availability Lab Part 2
  •    Manage High Availability Lab Part 3
  •    Manage High Availability Lab Part 4
  •    Manage High Availability Lab Part 5

Module 5: Configure Secure Access to Microsoft Azure SQL Databases

  •    Configure Firewall Rules
  •    Creating Firewall Rules Lab
  •    Configure Always Encrypted for Azure SQL Database
  •    Implementing Always Encrypted Lab
  •    Configure Cell-Level Encryption
  •    Cell-Level Encryption Lab
  •    Configure Dynamic Data Masking
  •    Dynamic Data Masking Lab
  •    Configure Transparent Data Encryption (TDE)
  •    Transparent Data Encryption (TDE) Lab

Module 6: Configure SQL Server performance settings

  •    Configure SQL Performance Settings
  •    Configuring SQL Performance Settings Lab
  •    Configure Max Server Memory
  •    Configuring SQL Memory Lab
  •    Configure Database Performance Settings
  •    Configure Database Performance Settings Lab
  •    Configure Operators and Alerts
  •    Configure alerts in Azure and On-Premise SQL Server Lab

Module 7: Manage SQL Server instances

  •    Create Databases
  •    Creating Databases Lab
  •    Manage Files and File Groups
  •    Managing Files and File Groups Lab
  •    Manage System Database Files
  •    Manage System Database Files Lab
  •    Configure tempdb
  •    Configure tempdb Lab

Module 8: Manage SQL Storage

  •    Manage SMB File Shares
  •    Manage SMB File Shares Lab
  •    Manage Stretch Databases
  •    Configure Azure Storage
  •    Change Service Tiers
  •    Change Service Tiers Lab Part 1
  •    Review Wait Statistics
  •    Manage Storage Pools
  •    Recover from Failed Storage
  •    Managing Storage Lab Part 1
  •    Managing Storage Lab Part 2

Module 9: Perform Database Maintenance

  •    Monitoring Tools
  •    Using Monitoring Tools Lab Part 1
  •    Using Monitoring Tools Lab Part 2
  •    Azure Performance Tuning
  •    Automate Maintenance Tasks
  •    Update Statistics and Indexes
  •    Update Statistics and Indexes Lab Part 1
  •    Update Statistics and Indexes Lab Part 2
  •    Verify Database Integrity
  •    Verify Database Integrity Lab
  •    Recover from Database Corruption
  •    Recover from Database Corruption Lab
  •    Conclusion

Module 1: Configure Encryption

Module 2: Configure Data Access and Permissions

Module 3: Configure Auditing

Module 4: Develop a Backup Strategy

Module 5: Restore Databases

Module 6: Manage Database Integrity

Module 7: Monitor Database Activity

Module 8: Monitor Queries

Module 9: Manage Indexes

Module 10: Monitor SQL Server Instances

Module 11: Implement Log Shipping

Module 12: Implement Failover Cluster Instances

Module 13: Implement Always On Availability Groups

Module 1: Installing and Configuring Domain Controllers

Module 2: Managing AD DS Objects

Module 3: Securing Active Directory Domain Services

Module 4: Working with Complex AD Infrastructures

Module 5: Implementing Group Policy

Module 6: Understanding Microsoft Azure AD and Directory Synchronization

Module 7: Monitoring and Recovering AD DS

Module 8: Implementing Active Directory Certificate Services

Module 9: Implementing Active Directory Federation Services

Module 10: Implementing Active Directory Rights Management Services

Module 1: Plan and Implement IPv4 and IPv6 Networks

Module 2: Installing and Configuring DHCP

Module 3: Installing and Configuring DNS

Module 4: Implementing and Managing IP Address Management

Module 5: Implementing Remote Access

Module 8: Securing the Network Infrastructure

Module 1: Installing Windows Server 2016 in Host and Compute Environments

Module 2: Configuring Active Directory Networks for Host and Compute Environments

Module 3: Implementing Local and Enterprise Storage Solutions

Module 4: Implementing Hyper-V Virtualization and Containers

Module 5: Implementing High Availability

Module 6: Maintaining and Monitoring Windows Server 2016