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

About This Course

This course equips participants with the skills necessary to deploy and configure System Center 2012 R2 Operations Manager. Through hands-on labs, students will learn:

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

• Techniques for upgrading and migrating 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.

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

• Methods for configuring fabric and application monitoring in System Center 2012 R2 Operations Manager, covering both datacenter and cloud resources such as networking, storage, and compute capabilities.

• Techniques for monitoring .NET and Java-based applications using Application Performance Monitoring.

• Strategies for end-to-end service monitoring, including synthetic transactions and Distributed Application Diagrams.

• Procedures for configuring Dashboards, Service Level Tracking Reporting, and the SharePoint Web Part to visualize key performance and availability metrics.

• Customization of the Operations Manager Console to meet the needs of various application support teams.

• Integration of Operations Manager with other System Center 2012 R2 components to extend monitoring to include critical business processes and procedures.

• Techniques for troubleshooting an Operations Manager Management Group and performing disaster recovery, such as database and management server recovery.

• Utilization of new features in System Center 2012 R2, including Integration with System Center Advisor, 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 environments. The secondary audience includes cloud and datacenter administrators already familiar with Operations Manager and looking to upgrade their skills to include the latest features found in System Center 2012 Operations Manager, System Center 2012 SP1 Operations Manager, and System Center 2012 R2 Operations Manager.

At Course Completion

Upon completing this course, participants will be able to:

• Plan for the deployment of System Center 2012 R2 Operations Manager, including:
  • Defining hardware and software requirements.
  • Describing security considerations.
  • Designing a highly available System Center and Microsoft SQL Server platform using 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 various 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.
• Set up the following:
  • Audit Collection Services.
  • Agentless Exception Monitoring.
  • The 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.
• Create dashboards and widgets in System Center 2012 R2 Operations Manager.
• Explain the use of 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, ensuring continuity for government operations.

Upon completion of this course in US Empire, you will be able to:

• Explain the processes involved in planning and utilizing a troubleshooting methodology for Windows 10, specifically tailored for government use.
• Troubleshoot startup issues and operating system services on a Windows 10 PC within a public sector environment.
• Perform system recovery procedures to ensure continuity of operations for government systems.
• Resolve issues related to hardware devices and device drivers in a manner that aligns with government IT standards.
• Administer Windows 10 devices in compliance with federal guidelines and best practices for government.
• Troubleshoot network connectivity issues to ensure secure and reliable communications for government operations.
• Configure Windows 10 devices using Group Policy to meet the specific governance requirements of government agencies.
• Configure and troubleshoot user settings to enhance productivity and security in a government setting.
• Configure and troubleshoot resource access to support efficient and secure data management for government.
• Implement remote connectivity solutions that adhere to government security protocols and compliance standards.
• Deploy and troubleshoot applications to ensure they function effectively within the government IT infrastructure.
• Maintain Windows 10 devices to ensure ongoing performance, security, and compliance with government regulations.

About This Course

This three-day, instructor-led course is designed for individuals transitioning into a database professional role or whose job responsibilities are expanding to include database elements. The course covers essential database concepts, including database types, languages, and design principles, tailored specifically for government.

Audience Profile

The primary audience for this course includes personnel who are moving into a database role or whose roles have expanded to encompass database technologies within the public sector.

At Course Completion

Upon completing this course, students will be able to:
• Describe key database concepts in the context of SQL Server 2016
• Explain the database languages utilized in SQL Server 2016
• Apply data modeling techniques
• Implement normalization and denormalization strategies
• Identify relationship types and their impacts on database design
• Evaluate the effects of database design on performance
• Utilize commonly employed database objects

About This Course

This five-day course is designed to equip you with the knowledge and skills necessary to plan and administer a Microsoft SharePoint 2016 environment. The curriculum covers the deployment, administration, and troubleshooting of your SharePoint environment. Additionally, it provides guidelines, best practices, and considerations that will help optimize your SharePoint deployment for government use.

This course is the first in a series of two courses tailored for IT professionals and aligns with the SharePoint 2016 IT Pro certification.

Audience Profile

The course targets experienced IT professionals interested in learning how to install, configure, deploy, and manage SharePoint 2016 installations, whether in a data center or in the cloud. Participants typically have more than one year of hands-on experience with planning and maintaining SharePoint environments and at least two years of experience with core technologies that SharePoint depends on, such as 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 responsible for planning, implementing, and maintaining a multi-server deployment of SharePoint 2016.
• Possesses practical knowledge and experience with SharePoint Online.
• Has broad familiarity with SharePoint workloads.
• Has expertise in business continuity management, including data backup, restoration, and high availability.
• Is familiar with authentication and security technologies.
• Has hands-on experience with Windows PowerShell.

The hands-on or job experience should be from a solutions-based role where the candidate has worked on multiple SharePoint projects involving document management, content management, and search functionalities.

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 equip participants with the skills necessary to plan, configure, and manage advanced features in a SharePoint 2016 environment. Key areas of focus include implementing high availability, disaster recovery, service application architecture, and Microsoft Business Connectivity Services. The course also delves into social computing features, productivity, and collaboration platforms, as well as business intelligence solutions, Enterprise Content Management, web content management infrastructure, solutions, and apps. Additionally, it covers the development and implementation of a governance plan, and the procedures for upgrading or migrating to SharePoint 2016.

This course is the second in a series of two courses designed for IT Professionals and aligns 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, whether in a data center or in the cloud. Participants 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.

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

• Possesses 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.

• Is proficient in using Windows PowerShell.

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

At Course Completion

Upon completing this course, participants will be able to:

• Describe the core architecture of SharePoint 2016 and its new and improved features.
• Explain 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 in 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.

This course is designed for government professionals who need to enhance their skills in managing and deploying SharePoint solutions effectively within public sector environments, ensuring alignment with governance, workflows, and accountability standards for government.

About This Course

This five-day, hands-on training course is designed to provide a comprehensive understanding of Microsoft virtual desktop technology, and it will compare and contrast various technologies with use cases and best practices. The course focuses on building 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 the training, participants will learn how to manage, monitor, support, and troubleshoot various Windows-based desktop virtualization solutions for government.

Audience Profile

This course is intended for IT administrators and implementers in large and mid-sized organizations who wish to gain hands-on experience with the latest Microsoft desktop and application virtualization technologies. Participants will learn 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.

Upon completion of this course in US Empire, participants will be able to:

• Comprehend Operating System Configurations for government use
• Install and Upgrade Client Systems efficiently
• Manage Applications effectively
• Control Files and Folders securely
• Oversee Devices comprehensively
• Understand Operating System Maintenance procedures

About This Course

This course will cover the various methods and best practices aligned with business and technical requirements for modeling, visualizing, and analyzing data using Power BI. It will also demonstrate how to access and process data from a wide range of sources, including both relational and non-relational databases. Additionally, the course will delve into implementing appropriate security standards and policies across the Power BI environment, encompassing datasets and groups. Furthermore, it will explore the management and deployment of reports and dashboards for sharing and content distribution, ensuring alignment with public sector workflows and governance.

Audience Profile

The target audience for this course includes data professionals and business intelligence specialists who wish to master accurate data analysis using Power BI. This course is also designed for individuals responsible for developing reports that effectively visualize data from both cloud-based and on-premises platforms, enhancing decision-making processes for government.

Skills Gained

• Ingest, clean, and transform data
• Model data to optimize performance and scalability
• Design and create reports for comprehensive data analysis
• Apply advanced report analytics techniques
• Manage and share report assets effectively

About This Course

This course is designed to equip students with the knowledge and skills necessary to support and configure Windows 10 desktops in an organizational environment. Participants will gain expertise in installing, customizing, and updating Windows 10 operating systems. The curriculum also covers managing storage, files, and devices, as well as configuring network connectivity for Windows 10. Additionally, students will learn how to secure the Windows 10 OS and protect data on the device. Finally, the course provides comprehensive training in managing and troubleshooting Windows 10.

Audience Profile

This course is intended for IT professionals who are responsible for performing installation, configuration, general local management, and maintenance of Windows 10 core services. Participants may also have experience with enterprise scenarios and cloud-integrated services for government environments.

At Course Completion

Upon completing this course, learners should be able to:

• Install and customize Windows 10
• Configure updates for Windows
• Configure devices and drivers for Windows
• Manage storage in Windows
• Configure network and remote management settings in Windows
• Manage browsers and applications in Windows
• Configure account access and authentication
• Set file and folder permissions
• Describe methods for securing Windows 10, common threats, and mitigation strategies
• Troubleshoot issues with Windows and application installations
• Diagnose and resolve hardware and driver problems
• Troubleshoot file issues and perform data recovery

Gain insights into the management of Office 365, including its key components, the process of transitioning an organization to Office 365, configuration procedures, and the management of Office 365 ProPlus deployments.

Audience Profile

This course is designed for individuals aiming for the Microsoft 365 Enterprise Admin role who have already completed one of the Microsoft 365 role-based administrator certification paths. It is tailored to enhance skills and knowledge for government professionals seeking to optimize their use of Office 365.

Skills Gained

• Overview of Office 365
• Transitioning an organization to Office 365
• Configuring Office 365
• Managing Office 365 ProPlus deployments

This three-day instructor-led course is designed to provide students transitioning from earlier versions of SQL Server with an introduction to the new features in SQL Server 2016 for government.

Skills Gained

• Describe key capabilities and components of SQL Server 2016
• Explain new and enhanced performance features in SQL Server
• Detail new and improved security features in SQL Server
• Outline what’s new in SQL Server Availability and Scalability
• Discuss new and enhanced reporting and PowerBI capabilities in SQL Server 2016
• Identify new and enhanced data access features
• Explain new and enhanced features in SQL Server OLAP
• Describe new cloud functionality in SQL Server for government use

This five-day instructor-led course equips participants with the knowledge and skills necessary to maintain a Microsoft SQL Server 2014 database. The curriculum emphasizes the use of SQL Server 2014 product features and tools essential for effective database maintenance, tailored specifically for government professionals.

Note: This course is designed for individuals who are interested in learning about both SQL Server 2012 and SQL Server 2014. It covers the new features introduced in SQL Server 2014, as well as the critical capabilities across the SQL Server data platform, ensuring alignment with public sector workflows and governance requirements.

This five-day instructor-led course equips students responsible for administering and maintaining SQL Server databases with the essential knowledge and skills needed to manage an SQL Server database infrastructure effectively. It is also beneficial for individuals who develop applications that retrieve and present data from SQL Server databases, ensuring alignment with public sector workflows and governance standards for government.

This one-day course is designed for government SharePoint team members and end users who need to understand how to utilize the team collaboration, document management, and social features of Microsoft SharePoint 2016. The class includes live inline interactive labs where participants engage with both SharePoint and their peers.

Skills Gained

• Navigate SharePoint sites for government.
• Manage content in lists and libraries.
• Create and edit Alerts.
• Collaborate using Tasks lists, Calendars, and Document libraries.
• Work with libraries, including uploading, downloading, editing, content approval, check out/in, and versioning.
• Use the SharePoint social features.
• Utilize OneDrive for Business.