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

About This Course

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

Audience Profile

The primary audience for this course includes professionals who are moving into a database role or whose job duties now encompass database technologies.

At Course Completion

Upon completing this course, students will be able to:
• Describe key database concepts within the context of SQL Server 2016
• Identify and explain the database languages used in SQL Server 2016
• Apply data modeling techniques effectively
• Understand and implement normalization and denormalization techniques
• Recognize different relationship types and their impacts on database design
• Analyze how database design influences performance
• Utilize commonly employed database objects

This course is tailored to provide comprehensive training for government professionals seeking to enhance their database management skills.

About This Course

This is a three-day Instructor-Led Training (ILT) course designed to meet the needs of information technology (IT) professionals responsible for administering, configuring, troubleshooting, and operating Office 365 services. The course covers identities, dependencies, requirements, and supporting technologies essential for effective management. It focuses on the skills required to administer and troubleshoot Office 365 tenant and key services such as Exchange Online, SharePoint Online, and Teams, as well as security and compliance features.

Audience Profile

This course is intended for IT professionals and system administrators who are interested in learning administration and troubleshooting techniques for Office 365. Participants should have at least three years of experience in their respective fields, ideally in system administration, network administration, and messaging.

At Course Completion

Upon completing this course, students will be able to:

• Describe Office 365 services for government use.
• Administer Office 365 using the Microsoft 365 admin center and Office 365 services admin centers.
• Administer and troubleshoot directory synchronization and directory objects.
• Administer and troubleshoot Exchange Online.
• Administer and troubleshoot Teams.
• Administer and troubleshoot SharePoint Online.
• Plan and deploy Microsoft 365 Apps for enterprise environments.
• Administer and troubleshoot compliance and security in Office 365.

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.

This course equips IT professionals with the skills needed to manage their Azure subscriptions effectively, secure identities, administer infrastructure, configure virtual networking, connect Azure and 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 their solutions. Designed specifically for government Azure Administrators, this course covers the essential tasks of implementing, managing, and monitoring identity, governance, storage, compute, and virtual networks in a cloud environment. Azure Administrators will learn to provision, size, monitor, and adjust resources as needed to ensure optimal performance and compliance with public sector workflows, governance, and accountability standards.

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

The Dynamics 365 Finance and Operations applications, which include but are not limited to Dynamics 365 Finance, Dynamics 365 Supply Chain Management, and Dynamics 365 Supply Chain Management for Manufacturing, are designed to enhance various aspects of financial and operational management. Dynamics 365 Finance enables the automation and modernization of global financial operations, allowing real-time performance monitoring, predictive analytics, and data-driven decision-making to drive business growth. It supports strategic financial decisions through artificial intelligence (AI), unifies and automates financial processes, reduces operational expenses, and mitigates global financial complexity and risk. Dynamics 365 Supply Chain Management is aimed at transforming manufacturing and supply chain operations by leveraging AI and the Internet of Things (IoT) for planning, production, inventory, warehouse, and transportation management. It maximizes operational efficiency, product quality, and profitability through intelligent manufacturing operations, modernized warehouse management, optimized production performance, extended asset life, and streamlined supply chains. For more information, please refer to https://docs.microsoft.com/learn/paths/get-started-finance-operations/. In this module, we will focus on the core features and functionality of Dynamics 365 Finance applications that are most commonly used by end users and consultants for government.

Audience Profile

The target audience for this course is a Dynamics 365 for Finance and Operations Functional Consultant. This role involves performing discovery, capturing requirements, engaging subject matter experts and stakeholders, translating requirements, and configuring the solution and applications. The Functional Consultant implements solutions using out-of-the-box capabilities, codeless extensibility, and application and service integrations.

At Course Completion

Upon completion of this course, students will be able to:

• Navigate and efficiently use search, filtering, and queries
• Utilize operational workspaces effectively
• Manage business documents
• Work with record templates
• Integrate Power BI with Dynamics 365 Finance and Operations applications
• Personalize workspaces to meet individual needs
• Determine when to use the Power Platform in Dynamics 365 Finance and Operations applications
• Apply security roles to users
• Run and analyze security reports
• Create and manage workflows for approval processes
• Understand and work with organizational hierarchies
• Utilize personalization features effectively
• Use the Data Management workspace for data management tasks
• Create and use entity templates
• Copy configuration data between legal entities
• Import, export, and manage data using Office Integration
• Utilize the Regression Suite Automation Tool (RSAT)
• Create User Acceptance Tests (UAT) and test plans
• Create and work with Business Process Modeler (BPM)
• Use issue search to identify and resolve issues

About This Course

This training program is designed to equip developers with the skills necessary to implement and extend Microsoft Dynamics 365 Finance and Operations applications in support of organizational business requirements. Participants will learn to deliver comprehensive solutions by leveraging standardized coding practices, extensible system features, and external integration capabilities.

Audience Profile

The content is tailored for developers working with Microsoft Dynamics 365 Finance and Operations Apps who require specialized instruction to enhance their technical proficiency within government environments.

This is a five-day instructor-led training (ILT) course designed for IT professionals who are involved in evaluating, planning, deploying, and managing Microsoft Office 365 services. The course covers the essential skills needed to set up an Office 365 tenant, including integration with existing user identities, and to maintain an Office 365 tenant and its users. This course is intended for IT professionals responsible for planning, configuring, and managing an Office 365 environment. Participants should have a comprehensive understanding of on-premises technologies such as Domain Name System (DNS) and Active Directory Domain Services (AD DS). Additionally, they should possess a general knowledge of Microsoft Exchange Server, Microsoft Lync Server or Skype for Business Server, and Microsoft SharePoint Server. Upon completing this course, students will be able to: - Plan an Office 365 deployment, configure the Office 365 tenant, and plan a pilot deployment. - Manage Office 365 users, groups, and licenses, and configure delegated administration. - Plan and configure client connectivity to Office 365. - Plan and configure directory synchronization between Microsoft Azure AD and on-premises AD DS. - Plan and implement the Office 365 ProPlus deployment. - Plan and manage Microsoft Exchange Online recipients and permissions. - Plan and configure Exchange Online services. - Plan and configure Microsoft Teams. - Plan and configure Microsoft SharePoint Online. - Plan and configure an Office 365 collaboration solution. - Plan and configure the integration between Office 365 and Microsoft Azure Information Protection. - Monitor and review Office 365 services, and troubleshoot Office 365 issues. - Plan and implement identity federation between on-premises AD DS and Azure AD. This training is specifically tailored to meet the needs of IT professionals in the public sector, ensuring that they are well-equipped to support and manage Office 365 environments for government operations.

This course is tailored for individuals aiming to assume the Microsoft 365 Administrator role, who have successfully completed at least one of the Microsoft 365 role-based administrator certification paths. The curriculum is designed to align with the technical requirements and best practices for government agencies, ensuring that participants are well-prepared to manage and optimize Microsoft 365 environments in a public sector context.

About This Course

This course provides foundational knowledge on the considerations and benefits of adopting cloud services, with a specific focus on the Software as a Service (SaaS) model, particularly Microsoft 365 cloud service offerings. The curriculum begins with an overview of cloud computing fundamentals and introduces participants to Microsoft Azure. It then delves into the differences between Microsoft 365 and Office 365, followed by an in-depth review of Microsoft 365. This includes a comparison of on-premises services versus Microsoft 365 cloud services, an examination of enterprise mobility within Microsoft 365, and an analysis of collaboration capabilities. The course also covers security, compliance, privacy, and trust in Microsoft 365, concluding with a review of subscriptions, licenses, billing, and support options for government and other organizations.

Audience Profile

This course is designed for Business Decision Makers and IT Professionals who are interested in deploying cloud services within their organization or seeking foundational knowledge on cloud fundamentals. It covers the considerations and benefits of adopting cloud services, particularly the SaaS model, with a focus on Microsoft 365 cloud service offerings.

At Course Completion

Upon completing this course, students will be able to:

• Differentiate between various cloud service models.
• Identify the key differences between Microsoft 365 subscriptions.
• Plan for the migration to Microsoft 365 services.
• Recognize the distinctions between on-premises and Microsoft 365 cloud services.
• Understand how Microsoft 365 supports teamwork and collaboration.
• Describe identities, including cloud, on-premises, and hybrid identity solutions.
• Explain cloud device management and protection using Intune.
• Discuss data protection measures, including the use of Azure Information Protection.
• Outline general compliance requirements and the compliance features in Microsoft 365.
• Describe Microsoft 365 subscriptions, licensing, billing, and support options for government and other organizations.

This instructor-led, live training in US (online or onsite) is designed to assist participants in preparing for the Microsoft Azure Administrator Associate (AZ-104) certification exam. The course covers the essential skills required to manage Azure resources, including virtual machines, storage solutions, and network management, ensuring alignment with best practices for government operations.

This instructor-led, live training in US (online or onsite) is designed to assist participants in preparing for the Microsoft Azure Developer Associate (AZ-204) certification exam. The course covers essential concepts of developing Azure solutions, including Azure compute, storage, and security features. It offers a thorough introduction to Azure development, encompassing tools and services necessary for building, testing, and deploying applications for government use.

This instructor-led, live training (available online or onsite) is designed to assist participants in preparing for the Microsoft Azure Solutions Architect Expert (AZ-305) certification exam. The course delves into advanced cloud computing concepts and Azure services, providing a thorough introduction to Azure solutions architecture. It covers key principles, components, and services essential for government and private sector professionals. Participants will gain the skills necessary to design and deploy Azure solutions in accordance with best practices and industry standards, ensuring alignment with public sector workflows, governance, and accountability requirements for government projects.

This instructor-led, live training in US (online or onsite) is designed to assist participants in preparing for the Microsoft Azure DevOps Engineer certification exam (AZ-400). The course provides an overview of DevOps practices and their implementation on the Azure platform. Participants will gain hands-on experience using Azure DevOps to manage code repositories, configure build and release pipelines, and implement continuous integration and continuous delivery (CI/CD) practices for government projects.

This five-day instructor-led course is designed primarily for information technology (IT) professionals with some experience using Windows Server. It is tailored for those who will be responsible for managing identity, networking, storage, and compute resources using Windows Server 2019. The course covers the essential scenarios, requirements, and options relevant to Windows Server 2019, ensuring that IT professionals are equipped with the fundamental administration skills needed to deploy and support this operating system effectively in various organizational settings, including those for government.