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

About This Course

This five-day course will provide you with the knowledge and skills to plan and administer a Microsoft SharePoint 2016 environment. The course teaches you how to deploy, administer, and troubleshoot your SharePoint environment. This course also provides guidelines, best practices, and considerations that help you optimize your SharePoint deployment.

This is the first in a sequence of two courses for IT professionals and is aligned with the SharePoint 2016 IT Pro certification.

Audience Profile

The course is targeted at experienced IT professionals who are interested in learning how to install, configure, deploy, and manage SharePoint 2016 installations either in a data center or in the cloud.

Students typically have more than one year of hands-on experience* with planning and maintaining SharePoint and two years’ experience with other core technologies on which SharePoint depends, including 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.

The minimally qualified candidate typically:

• Is an IT professional who plans, implements, and maintains 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 experience or job experience should be from a solutions-based role where the candidate has worked on multiple solutions in the SharePoint space that includes 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 five-day course will teach you how to plan, configure, and manage the advanced features in a SharePoint 2016 environment. The special areas of focus for this course include implementing high availability, disaster recovery, service application architecture, and Microsoft Business Connectivity Services. This course also focuses on social computing features, productivity, and collaboration platforms and features. Students also will learn about business intelligence solutions, Enterprise Content Management, web content management infrastructure, solutions, and apps. This course also covers how to develop and implement a governance plan, and how to perform an upgrade or a migration to SharePoint 2016.

This is the second in a sequence of two courses for IT Professionals and is aligned with the SharePoint 2016 IT Pro certification.

Audience Profile

The course is targeted at experienced IT Professionals who are interested in learning how to install, configure, deploy, and manage SharePoint 2016 installations either in a data center or in the cloud.

Students typically should have more than four years of hands-on experience* planning and maintaining SharePoint Server and other core technologies upon which SharePoint depends, including Windows Server 2012 R2 or later, Internet Information Services (IIS), Microsoft SQL Server 2014 R2 or later, Active Directory Domain Services (AD DS), and networking infrastructure services.

Students should have completed Course 20339-1A: Planning and Administering Microsoft SharePoint 2016, or have gained equivalent knowledge and experience before taking this course.

The minimally qualified candidate typically:

• Has a working knowledge of, and preferably hands-on experience, with Microsoft SharePoint Online.

• Has broad familiarity with SharePoint Server 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 experience or job experience should be from a solutions-based role where the candidate has worked on multiple solutions in the SharePoint Server space that includes document management, content management, and search.

At Course Completion

After completing this course, students will be able to:

• Describe the core SharePoint 2016 architecture and its new and improved features.
• Describe the key hybrid features in SharePoint 2016.
• Plan and design a SharePoint 2016 environment to meet requirements for high availability and disaster recovery.
• Plan and implement Business Connectivity Services and Secure Store Service.
• Configure and manage productivity services for a SharePoint 2016 deployment.
• Manage solutions in a SharePoint 2016 deployment.
• Plan and configure social computing features.
• Plan and configure web content management for an Internet-facing environment.
• Plan and configure Enterprise Content Management in a SharePoint 2016 deployment.
• Plan and configure business intelligence solutions.
• Plan and configure work management, productivity, and collaboration platforms and features.
• Perform an upgrade or migration to SharePoint 2016.

Learn about Office 365 Management, including key components of Office 365, how to move an organization to Office 365, how to configure Office 365, and how to manage Office 365 ProPlus deployments.

Audience profile

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

Skills gained

• Office 365 overview
• Moving an organization to Office 365
• Configuring Office 365
• Managing Office 365 ProPlus deployments

This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.

Skills gained

• Describekey capabilities and components of SQL Server 2016
• Describe new and enhanced features in SQL Server performance
• Describes new and enhanced features in SQL Server security
• Describe what’s new inSQL Server Availability and Scalability
• Describe new and enhanced features in reporting and PowerBIin SQL Server 2016
• Describe new and enhanced data access features
• Describe new and enhanced features in SQL Server OLAP
• Describenew SQL Server cloud functionality

About This Course

In this course, students will learn how to support and configure Windows 10 desktops in an organizational environment. Students will develop skills that include learning how to install, customize, and update Windows 10 operating systems. Students will learn how to managing storage, files, and devices as well as how to configure network connectivity for Windows 10. Students will also learn how to secure the Windows 10 OS and protect the data on the device. Finally, students will learn how to manage and troubleshoot Windows 10.

Audience Profile

Candidates for this exam are IT professionals who perform installation, configuration, general local management and maintenance of Windows 10 core services. Candidates may also be familiar with enterprise scenarios and cloud-integrated services.

At Course Completion

After completing this course, learners should be able to:

• Install and customize Windows 10
• Configure Updates for Windows.
• Configure devices and drivers for Windows.
• Configure storage for Windows.
• Configure network and remote management settings in Windows.
• Configure and manage browsers and applications in Windows.
• Configure account access and authentication.
• Configure file and folder permissions.
• Describe methods for securing Windows 10, common threats and methods for mitigating against them.
• Troubleshoot Windows and application installations.
• Troubleshoot hardware and driver issues.
• Troubleshoot file issues and perform recoveries.

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

This is a 5-day ILT course that is designed to provide students with the knowledge and skills required to support and troubleshoot Windows 10 PCs and devices in a Windows Server domain environment. These skills include understanding of Windows 10 features, how they can be used in an Active Directory environment and how to troubleshoot them.

Audience Profile

The primary audience for this course is the Enterprise Desktop Support Technician (EDST), who provides Tier 2 support to users running Windows 10 personal computers (PCs) and devices in medium to large enterprise organizations, within a Windows domain environment. EDSTs focus on a broad range of technical issues for Windows operating systems (OSs), devices, cloud services, applications, networking, and hardware support. In the overarching scenario, if an enterprise offers the service, the EDST is asked to support it. The key responsibilities include resolving technical issues pertaining to Windows 10 installation and migration, activation, performance, profiles, settings; and device synchronization. Some other key responsibilities include local and remote network access; access to applications, access to data and printers; authentication, Endpoint security and policy; OS and data recovery. The secondary audience for this course are IT professionals who administer and support Windows 10 desktops, devices, users, and associated network and security resources. Students who seek certification in the following exams will also benefit from this course: 70-697, Configuring Windows Devices 70-698, Installing and Configuring Windows 10

At Course Completion

After completing this course, you will be able to:

• Describe the processes involved in planning and using a troubleshooting methodology for Windows 10.
• Troubleshoot startup issues and operating system services on a Windows 10 PC.
• Perform system recovery.
• Resolve issues related to hardware devices and device drivers.
• Administer Windows 10 devices.
• Troubleshoot issues related to network connectivity.
• Configure Windows 10 devices by using Group Policy.
• Configure and troubleshoot user settings.
• Configure and troubleshoot resource access.
• Implement remote connectivity.
• Deploy and troubleshoot applications.
• Maintain Windows 10 devices.

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.

About This Course

This Microsoft Partner Applied Workshop introduces IT Professionals to the new features and capabilities of Windows 10. The workshop combines video, and uses the Enterprise Edition of Windows 10 to cover what’s new in Windows 10 for IT Professionals, as well as the key Windows 10 ecosystem consisting of Windows Assessment and Deployment Kit(ADK) for Windows 10, Microsoft Deployment Toolkit 2013 Update 1 Preview, System Center 2012 R2 Configuration Manager Technical Preview, and MDT 2013 Update 1.

This workshop is designed to enhance and extend the learning from the selected video content hosted for IT Pros on Microsoft Virtual Academy (MVA).  In this workshop, students will explore  the new user interface features of Windows 10, the deployment and management tools listed above, and a deep dive into Device Guard for Windows 10.

Audience Profile

This workshop is intended for IT professionals who are interested in learning about the new features and functionality in Windows 10. In general, adopters of new technology or people looking to gain early insight into functionality of Windows 10, and related support services, and tools will benefit from attending this workshop. People who are key technical influencers and technology decision-makers in an IT organization also may attend this clinic, as they can benefit from gaining early insight into some of the latest features and technologies that Windows 10 includes

At Course Completion

After completing this workshop, students will be able to:

• Understand what is new when deploying Windows 10

  • Using MDT

  • Using System Center Configuration Manager

• List and explain the new features of Windows 10 UI across multiple devices

• Use and customize the new user interface in Windows 10

• Use the new Windows Imaging and Configuration Designer (ICD).

• Use Device Guard for Windows 10

This five-day 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 storage and compute by using Windows Server 2016, and who need to understand the scenarios, requirements, and storage and compute options that are available and applicable to Windows Server 2016.

This 5-day classroom-based course provides the fundamental networking skills required to deploy and support Windows Server 2016 in most organizations. It covers IP fundamentals, remote access technologies, and more advanced content including Software Defined Networking.

This five-day instructor-led course teaches IT professionals how to deploy and configure Active Directory Domain Services (AD DS) in a distributed environment, how to implement Group Policy, how to perform backup and restore, and how to monitor and troubleshoot Active Directory - related issues with Windows Server 2016. Additionally, this course teaches students how to deploy other Active Directory server roles, such as Active Directory Federation Services (AD FS) and Active Directory Certificate Services (AD CS).

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 2019, and who need to understand the scenarios, requirements, and options that are available and applicable to Windows Server 2019. The course teaches IT professionals the fundamental administration skills required to deploy and support Windows Server 2019 in most organizations.

About This Course

This course will review the marketing application configuration needed to drive business growth. It will also dive into lead management, marketing forms and pages, segmentation, and email marketing messages. All these pieces are tied together through interactive customer journey design, including event and survey configuration.

Audience Profile

This course is designed for IT or marketing professionals who want to learn how to leverage Dynamics 365 Marketing for businesses.

At Course Completion

After completing this course, you will be able to:

• Configure advanced settings
• Manage marketing content, templates and integrations
• Create and manage leads
• Design and create marketing forms and pages
• Create and manage segments
• Set up and launch customer journeys
• Create and manage events
• Distribute and analyze surveys

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

This course is for Azure Administrators. The Azure Administrator implements manages and monitors identity, governance, storage, compute, and virtual networks in a cloud environment. The Azure Administrator will provision, size, monitor, and adjust resources as appropriate.