DP-080T00: Querying Data with Microsoft Transact-SQL Training Course

About This Course

This course equips students with the skills they require to deploy and configure System Center 2012 R2 Operations Manager. Using hands-on labs, students learn the following:

• How to architect and implement a System Center 2012 R2 Operations Manager Management Group.

• How to upgrade and migrate from an existing Operations Manager 2007 R2 Management Group to System Center 2012 Operations Manager, System Center 2012 SP1 Operations Manager and System Center 2012 R2 Operations Manager.

• Understand the key elements of Management Packs including Object Discoveries, Rules, Monitors, Targeting and Run As Accounts and Run As Profiles. This includes authoring Management Packs.

• How to configure fabric and application monitoring in System Center 2012 R2 Operations Manager including both datacenter and cloud resources such as networking, storage and compute.

• How to configure monitoring of .NET and Java based applications using Application Performance Monitoring.

• How to configure end-to-end service monitoring including synthetic transactions and Distributed Application Diagrams.

• How to configure Dashboards, Service Level Tracking Reporting and the SharePoint Web Part to enable visualization of key performance and availability metrics.

• How to customize the Operations Manager Console to meet the needs of different application support teams.

• How to integrate Operations Manager with other System Center 2012 R2 components and extend monitoring to include key business processes and procedures.

• How to troubleshoot an Operations Manager Management Group and perform disaster recovery procedures such as database and management server recovery.

• How to use new features in System Center 2012 R2 including: Integration with System Center Advisor, Integration with Team Foundation Server, IntelliTrace, and Managing Windows Azure.

Audience Profile

The primary audience for this course is cloud and datacenter administrators who are new to System Center 2012 R2 Operations Manager and are responsible for deploying, configuring and operating it in their cloud or datacenter. The secondary audience for this course is cloud and datacenter administrators who are already familiar with Operations Manager and want to upgrade their skills to include the new features found in System Center 2012 Operations Manager, System Center 2012 SP1 Operations Manager and System Center 2012 R2 Operations Manager.

At Course Completion

After completing this course, students will be able to:

• Plan for the deployment of System Center 2012 R2 Operations Manager including:
  • Defining hardware and software requirements.
  • Describing security considerations.
  • Architect a highly available System Center and Microsoft SQL Server platform utilizing Microsoft SQL Server AlwaysOn.
  • Planning for migration and upgrade scenarios to System Center 2012 R2 Operations Manager.
• Customize the Operations Console with User Roles.
• Perform different methods of Agent deployment with System Center 2012 R2 Operations Manager.
• Implement key Management Pack concepts and elements including Management Packs Templates.
• Configure Notifications, Reporting, and Service Level Tracking in System Center 2012 R2 Operations Manager.
• Configure the following:
  • Audit Collection Services.
  • Agentless Exception Monitoring.
  • Operations Manager SharePoint Web Part in System Center 2012 R2 Operations Manager.
• Configure Application Performance Monitoring and Network Device monitoring in System Center 2012 R2 Operations Manager.
• Configure dashboards and widgets in System Center 2012 R2 Operations Manager.
• Describe how to use new cloud-based features including System Center Global Service Monitor and System Center Advisor.
• Configure integration between System Center 2012 R2 Operations Manager and other System Center 2012 R2 components.
• Troubleshoot an Operations Manager Management Group.
• Perform disaster recovery in System Center 2012 R2 Operations Manager.

About This Course

Over the course of five days, this programme equips you with the essential knowledge and skills required to plan and administer a Microsoft SharePoint 2016 environment. You will learn how to deploy, manage, and troubleshoot your SharePoint setup. The course also provides guidelines, best practices, and key considerations to help you optimise your SharePoint deployment.

This is the first of two courses designed for IT professionals, aligned with the SharePoint 2016 IT Pro certification path.

Audience Profile

This course is targeted at experienced IT professionals keen on learning how to install, configure, deploy, and manage SharePoint 2016 installations in either a data centre or cloud environment.

Typically, students have over one year of hands-on experience* in planning and maintaining SharePoint, alongside two years’ experience with other core technologies that SharePoint relies on. These include Windows Server 2012 R2 or later, Internet Information Services (IIS), Microsoft SQL Server 2014 or later, Active Directory Domain Services (AD DS), and networking infrastructure services.

A minimally qualified candidate typically:

• Is an IT professional responsible for planning, implementing, and maintaining a multi-server deployment of SharePoint 2016.
• Has a working knowledge of, and preferably hands-on experience with, SharePoint Online.
• Has broad familiarity with SharePoint workloads.
• Has experience with business continuity management, including data backup, restoration, and high availability.
• Has experience with authentication and security technologies.
• Has experience with Windows PowerShell.

* The hands-on or job experience should stem from a solutions-based role where the candidate has worked on multiple solutions within the SharePoint space, including document management, content management, and search.

At Course Completion

• Describe the key features of SharePoint 2016.
• Design an information architecture for a SharePoint 2016 deployment.
• Design a logical architecture for a SharePoint 2016 deployment.
• Design the physical architecture for a SharePoint 2016 deployment.
• Install and configure SharePoint 2016.
• Create and configure web applications and site collections.
• Plan and configure service applications for a SharePoint 2016 deployment.
• Manage users and permissions, and secure content in a SharePoint 2016 deployment.
• Configure authentication in a SharePoint 2016 deployment.
• Configure platform and farm-level security in a SharePoint 2016 deployment.
• Manage information taxonomy in SharePoint web applications and site collections.
• Configure and manage user profiles and audiences.
• Configure and manage the search experience in SharePoint 2016.
• Monitor, maintain, and troubleshoot a SharePoint 2016 deployment.

About This Course

This course equips experienced Exchange Server administrators with the expertise required to design and implement a robust Exchange Server messaging environment. Participants will learn to configure advanced deployment components, including site resilience, enhanced security protocols, compliance measures, archiving and discovery solutions, coexistence with other Exchange organisations or Exchange Online, and migration from prior Exchange Server versions. The curriculum also outlines guidelines, best practices, and critical considerations to optimise Exchange Server deployments.

Audience Profile

This course is tailored for IT professionals, including experienced messaging administrators, messaging architects, and consultants. It is ideal for enterprise personnel tasked with designing and deploying Exchange Server solutions, particularly those managing environments that include previous Exchange Server versions or Exchange Online. Students are expected to have prior experience with Exchange Server 2019 or earlier iterations.

At Course Completion

Upon completing this course, students will be able to:

• Plan for Exchange Server deployments.
• Plan and deploy Exchange Server hardware, virtualization, mailbox databases, and public folders.
• Plan message transport in Exchange Server.
• Plan and deploy Client Access services in Exchange Server.
• Design and implement a highly available Exchange Server environment.
• Maintain Exchange Server by using Managed Availability and Desired State Configuration (DSC).
• Plan for messaging security and design and implement Active Directory Rights Management Services (AD RMS) and Microsoft Azure RMS in Exchange Server.
• Design and implement message retention and archiving.
• Design and implement data loss prevention policies, In-Place Hold, and eDiscovery.
• Design and implement messaging coexistence among Exchange Server organisations.
• Plan and implement the upgrade from previous versions of Exchange Server to Exchange Server 2019.
• Plan a hybrid Exchange deployment.

About This Course

This five-day, hands-on training course is designed to teach you the breadth of Microsoft virtual desktop technology, and the course will compare and contrast the various technologies with use cases and best practices. This course builds your skills in Microsoft Application Virtualization (App-V) Service Pack 2 (SP2), Microsoft User Experience Virtualization (UE-V), and Virtual Desktop Infrastructure (VDI) as part of Windows Server 2012 R2. Throughout this course, you will learn how to manage, monitor, support, and troubleshoot various Windows-based desktop virtualization solutions.

Audience Profile

This course is intended for the IT administrators, and implementers, of large and midsized organizations who want to understand and get hands on experience with the latest Microsoft desktop and application virtualization technologies and how to plan, implement, and manage virtual infrastructure solutions based on these technologies.

At Course Completion

After completing this course, students will be able to:

• Describe desktop and application virtualization.
• Plan and implement user state virtualization.
• Plan and implement App-V.
• Plan and deploy App-V clients.
• Manage and administer application virtualization.
• Understand application sequencing.
• Configure client Hyper-V.
• Plan and deploy session-based desktops.
• Publish and configure RemoteApp programs.
• Plan pooled personal desktops.
• Plan and implement pooled and personal desktops.
• Implement Remote Access.
• Understand health monitoring of VDI infrastructure.

In this whiteboard design session, you will learn how to design a solution using a combination of Azure Resource Manager templates and Azure DevOps to enable continuous delivery across several Azure PaaS services.

Upon completing this workshop, you will be well-equipped to build templates that automate cloud infrastructure and minimise error-prone manual processes. Additionally, you will create an Azure Resource Manager (ARM) template to provision Azure resources, configure continuous delivery with Azure DevOps, integrate Application Insights into an application, and set up an Azure DevOps project along with a Git repository.

This course equips IT Professionals with the skills to manage Azure subscriptions, secure identities, administer infrastructure, configure virtual networking, connect Azure to on-premises sites, manage network traffic, implement storage solutions, create and scale virtual machines, deploy web apps and containers, back up and share data, and monitor solutions.

Designed for Azure Administrators, this training covers the management, implementation, and monitoring of identity, governance, storage, compute, and virtual networks within a cloud environment. Azure Administrators will learn to provision, size, monitor, and adjust resources as required.

About This Course

In this course, learners will gain an understanding of database principles within a cloud setting, acquire fundamental skills in cloud data services, and establish a solid foundation in Microsoft Azure cloud data solutions. Participants will identify and describe essential data concepts, including relational, non-relational, big data, and analytics, while examining how these technologies are applied using Microsoft Azure. They will investigate the roles, tasks, and responsibilities associated with the data industry. Students will delve into relational data offerings, learning how to provision and deploy relational databases, as well as query relational data through Azure cloud solutions. The curriculum also covers non-relational data offerings, including the provisioning and deployment of non-relational databases and data stores on Azure. Learners will explore processing options for developing data analytics solutions in Azure, focusing on Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Additionally, students will understand what Power BI is, its core components, and how these elements function together.

Audience Profile

This course is designed for individuals seeking to learn the fundamentals of database concepts in a cloud environment, develop basic skills in cloud data services, and build foundational knowledge of cloud data services within Microsoft Azure.

At Course Completion

Upon completing this course, students will be able to:

• Describe core data concepts in Azure
• Explain concepts of relational data in Azure
• Explain concepts of non-relational data in Azure
• Identify components of a modern data warehouse in Azure

About This Course

This course provides a comprehensive review of the marketing application configuration required to stimulate business growth. It delves into essential areas such as lead management, the creation of marketing forms and pages, audience segmentation, and email marketing campaigns. These components are interconnected through interactive customer journey design, which also encompasses the configuration of events and surveys.

Audience Profile

This course is tailored for IT and marketing professionals seeking to understand how to effectively leverage Dynamics 365 Marketing to benefit their organisations.

At Course Completion

Upon successfully completing this course, participants will be capable of:

• Configuring advanced system settings
• Managing marketing content, templates, and integrations
• Creating and managing leads
• Designing and establishing marketing forms and web pages
• Creating and managing audience segments
• Setting up and executing customer journeys
• Creating and managing events
• Distributing and analysing survey data

Content is the most critical digital asset for every organisation. In this course, you will learn how to plan, configure, and manage SharePoint Sites and OneDrive to enable modern content services that transform the content lifecycle. Specifically, this course discusses the modern SharePoint site structure, such as SharePoint hub sites. It provides best practices for the adoption and deployment of OneDrive within your organisation. It also covers sharing, security, and monitoring in SharePoint and OneDrive in Microsoft 365. Additionally, you will learn how to manage user profiles and apps with proper permission settings. We will also discuss how to plan and configure Managed Metadata, Business Connectivity Services, and search allowing content to be found, consumed, and governed across Microsoft 365.

After completing this course, students will be able to:

• Configure SharePoint Sites.
• Manage sites storage limits.
• Deploy OneDrive sync client.
• Use Group Policy to control OneDrive sync client settings.
• Manage external sharing for data in Microsoft SharePoint and OneDrive.
• Configure user profile properties.
• Manage audiences.
• Use the App Catalog to manage custom apps.
• Create and manage term groups, term sets, and terms.
• Describe the difference between modern and classic search experiences.

About This Course

This course explores three core pillars of Microsoft 365 enterprise administration: Microsoft 365 tenant and service management, Office 365 management, and Microsoft 365 identity management. In the section on tenant and service management, you will investigate the critical components required when designing your Microsoft 365 tenant. Following the planning phase, you will acquire the skills to configure your tenant, covering your organisational profile, subscription options, component services, user accounts and licenses, and security groups. Furthermore, you will learn how to manage your tenant, which involves configuring tenant roles and monitoring tenant health and services. With your Microsoft 365 tenant established, the course moves to the key components of Office 365 management. This starts with an overview of Office 365 product functionality, including Exchange Online, SharePoint Online, Microsoft Teams, the Microsoft Power Platform, additional product resources, and device management. You will then proceed to configure Office 365, with a primary emphasis on Office client connectivity. Subsequently, you will examine how to manage Microsoft 365 Apps for enterprise (formerly Office 365 ProPlus) deployments, ranging from user-driven installations to centralised deployments. You will conclude this segment by learning to configure Office Telemetry and Microsoft Analytics. The course finishes with a detailed examination of Microsoft 365 identity synchronisation, focusing on Azure Active Directory Connect. You will learn to plan and implement Azure AD Connect, manage synchronised identities, and implement password management in Microsoft 365 using multi-factor authentication and self-service password management. This final section wraps up with a comprehensive look at implementing application and external access. You will learn to add and manage applications in Azure Active Directory, including configuring multi-tenant applications. You will then examine how to configure Azure AD Application Proxy, including installing and registering a connector and publishing an on-premises app for remote access. Finally, you will explore how to design and manage solutions for external access. This includes licensing guidance for Azure AD B2B collaboration, creating a collaborative user, and troubleshooting B2B collaboration.

Audience Profile

This course is designed for individuals aspiring to the Microsoft 365 Enterprise Admin role who have completed one of the Microsoft 365 role-based administrator certification paths.

At Course Completion

By actively participating in this course, you will learn about the following:

• Designing, configuring, and managing your Microsoft 365 tenant
• Office 365 product functionality
• Configuring Office 365
• Managing Office 365 ProPlus deployments
• Planning and implementing identity synchronisation
• Implementing application and external access

Gain insight into Office 365 Management, covering the essential components of Office 365, strategies for transitioning an organisation to Office 365, configuration techniques, and methods for overseeing Office 365 ProPlus deployments.

Audience profile

This course is tailored for individuals aspiring to the Microsoft 365 Enterprise Admin role who have completed one of the Microsoft 365 role-based administrator certification pathways.

Skills gained

• Office 365 overview
• Transitioning an organisation to Office 365
• Configuring Office 365
• Managing Office 365 ProPlus deployments

This course is tailored for individuals aspiring to the Microsoft 365 Administrator role who have completed at least one of the Microsoft 365 role-based administrator certification paths.

About This Course

This course explores the essential components of Microsoft 365 messaging administration, covering message transport and mail flow, messaging security, hygiene, compliance, infrastructure, and hybrid messaging solutions. It is tailored for IT professionals who are responsible for deploying and managing the messaging infrastructure for Microsoft 365 within their organisations.

Audience Profile

As a Messaging Administrator, you will deploy, configure, manage, and troubleshoot recipients, permissions, mail protection, mail flow, and public folders in both on-premises and cloud enterprise environments. Your duties involve managing message hygiene, the messaging infrastructure, and hybrid configuration and migration processes. To establish a secure hybrid topology that aligns with the business requirements of a modern organisation, the Messaging Administrator must work closely with the Security Administrator and the Microsoft 365 Enterprise Administrator. A foundational understanding of authentication types, licensing, and integration with Microsoft 365 applications is essential for this role.

At Course Completion

Upon finishing this course, students will be capable of:

• Configuring and managing the transport pipeline
• Managing and troubleshooting mail flow and transport issues
• Handling message hygiene and compliance
• Managing authentication for messaging
• Configuring organisational settings and sharing policies
• Managing mobile devices
• Handling role-based permissions
• Creating and managing recipient objects and resources
• Planning, implementing, and troubleshooting public folders
• Planning a hybrid environment
• Executing mailbox migrations
• Deploying and troubleshooting a hybrid environment

About This Course

In this course, you will learn how to manage Microsoft Teams in your organisations. The course covers Microsoft Teams overview, implementing governance, security and compliance for Microsoft Teams, preparing the environment for a Microsoft Teams deployment, deploying teams, and managing collaboration and communication in Microsoft Teams. You will learn about Teams architecture. Specifically, you will learn about the integration between Microsoft Teams and various workloads and services in Microsoft 365. You will learn about security and compliance features for Teams, including conditional access, MFA, Threat, alerts, DLP policies, eDiscovery, and information barrier policies. You will also learn about preparing the environment for a Microsoft Teams deployment, including upgrading from Skype for Business to Microsoft Teams, network settings, and managing Microsoft Teams endpoints. Lastly, you will learn about how to create and manage teams, manage membership, including internal and external users. You will further learn about different settings and policies to manage collaboration and communication experiences in Microsoft Teams.

Audience Profile

This course is designed for persons who are aspiring to the Microsoft 365 Teams Admin role and are interested in in passing the Microsoft Teams Administrator Associate certification exam. The Microsoft Teams Administrator configures, deploys, and manages Office 365 workloads for Microsoft Teams that focus on efficient and effective collaboration and communication in an enterprise environment. The Teams Administrator collaborates with Telephony engineers to integrate advanced voice features into Microsoft Teams. This role is not responsible for configuring direct routing, configuring call routing, or integrating telephony.

At Course Completion

By actively participating in this course, you will learn about the following:

• What is Microsoft Teams and how the components work together
• How to implement Governance, Security and Compliance for Microsoft Teams
• How to prepare an organisations environment for a Microsoft Teams deployment
• How to deploy and manage teams
• Ways of managing collaboration in Microsoft Teams
• Techniques to manage and troubleshoot communication in Microsoft Teams

This five-day instructor-led programme is tailored for IT professionals who already possess some experience with Windows Server. It targets professionals responsible for managing identity, networking, storage, and compute resources using Windows Server 2019, and who need to understand the applicable scenarios, requirements, and options available for Windows Server 2019. The course equips IT professionals with the fundamental administration skills necessary to deploy and support Windows Server 2019 within most organisations.