DP-080T00: Querying Data with Microsoft Transact-SQL - Plan Szkolenia

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.

About This Course

This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

Audience Profile

The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.

Skills gained

• Ingest, clean, and transform data
• Model data for performance and scalability
• Design and create reports for data analysis
• Apply and perform advanced report analytics
• Manage and share report assets

About This Course

This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.

Audience Profile

The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.

At Course Completion

After completing this course, students will be able to:
• Describe key database concepts in the context of SQL Server 2016
• Describe database languages used in SQL Server 2016
• Describe data modelling techniques
• Describe normalization and denormalization techniques
• Describe relationship types and effects in database design
• Describe the effects of database design on performance
• Describe commonly used database objects

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer an SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.

Skills gained

• Describe key database concepts in the context of SQL Server 2016
• Describe database languages used in SQL Server 2016
• Describe data modelling techniques
• Describe normalization and denormalization techniques
• Describe relationship types and effects in database design
• Describe the effects of database design on performance
• Describe commonly used database objects

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.