Microsoft Authorized Training in Columbus

This instructor-led, live training in [location] (online or onsite) is designed to assist participants in preparing for the Microsoft Azure Data Engineer certification exam (DP-203). The course provides an overview of Azure data services and their application in processing, storing, and managing data in the cloud. Participants will gain hands-on experience in creating data processing solutions using Azure Data Factory, Azure Stream Analytics, and Azure Databricks. Additionally, they will learn how to work with NoSQL databases through Azure Cosmos DB, ensuring alignment with best practices for government data management and governance.

This instructor-led, live training in Columbus (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 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 Columbus (online or onsite) is designed to assist participants in preparing for the Microsoft Azure Security Engineer Associate (AZ-500) certification exam. The course covers a range of security topics relevant to Azure, including identity and access management, platform protection, data and application protection, and operations management. This training is tailored to support professionals in enhancing their cybersecurity skills for government and private sector environments, ensuring alignment with best practices and industry standards.

This instructor-led, live training in Columbus (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 in Columbus (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 Columbus (online or onsite) is designed to assist participants in preparing for the Microsoft Azure Fundamentals (AZ-900) certification exam. The course offers a thorough introduction to cloud computing and Azure services, tailored for government professionals. It covers essential concepts of Azure, including its architecture, pricing models, support options, and an overview of the most frequently utilized Azure services. This training is specifically structured to align with public sector workflows, governance, and accountability requirements for government.

This course equips students with the essential knowledge and skills to utilize PowerShell for the administration and automation of Windows servers. Students will gain the ability to identify and construct the commands necessary to execute specific tasks. Additionally, they will learn to develop scripts to handle advanced tasks, such as automating repetitive processes and generating reports. The course provides foundational skills that support a wide range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. While the focus is not on any single product, Windows Server serves as the primary platform for demonstrating the techniques taught in this course, ensuring relevance and applicability for government IT professionals.

In this 5-day course, participants will gain foundational knowledge in computer programming using Microsoft Visual Studio 2013 and either the Visual C# or Visual Basic programming languages. The course is designed for those with no prior programming experience and covers essential concepts necessary to advance to intermediate programming courses, such as 20483B: Programming in C#. The curriculum focuses on core programming principles, including computer storage, data types, decision structures, and loops. It also introduces object-oriented programming, covering topics such as classes, encapsulation, inheritance, and polymorphism. Additional coverage includes exception handling, application security, performance optimization, and memory management, all tailored to meet the needs of government agencies. Upon completion of this course, participants will be able to: - Explain fundamental programming concepts such as computer storage and processing. - Understand and work with computer number systems like binary. - Create and utilize variables and constants in programs. - Develop and use functions within a program. - Implement decision structures in computer programs. - Utilize repetition (loops) effectively in programming. - Comprehend the role of pseudocode in programming. - Work with basic data structures such as arrays, lists, stacks, and queues. - Apply object-oriented programming principles. - Design and use classes in computer programs. - Implement encapsulation, inheritance, and polymorphism. - Describe the base class library (BCL) within the .NET Framework. - Understand application security concepts. - Perform simple input/output operations in a program. - Identify and address application errors through debugging techniques and error handling. - Consider performance factors for applications. This course is designed to equip participants with the skills needed to support effective software development practices for government agencies.

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.

About This Course

This course provides an introduction to HTML5, CSS3, and JavaScript, designed to help students gain foundational skills in these technologies. It serves as an entry point into both web application and Windows Store apps development paths. The curriculum emphasizes the use of HTML5/CSS3/JavaScript for implementing programming logic, defining and using variables, performing looping and branching, developing user interfaces, capturing and validating user input, storing data, and creating well-structured applications. The laboratory scenarios are carefully selected to support and demonstrate various application structures, focusing on the principles and coding components that establish an HTML5 software application. This course utilizes Visual Studio 2017 running on Windows 10.

Audience Profile

This course is intended for professional developers with 6-12 months of programming experience who are interested in developing applications using HTML5, JavaScript, and CSS3 (either Windows Store apps for Windows 10 or web applications).

At Course Completion

After completing this course, students will be able to:

• Explain how to use Visual Studio 2017 to create and run a web application.
• Describe the new features of HTML5 and create and style HTML5 pages.
• Add interactivity to an HTML5 page using JavaScript.
• Create HTML5 forms with various input types and validate user input using HTML5 attributes and JavaScript code.
• Send and receive data from a remote data source using XMLHTTPRequest objects and the Fetch API.
• Style HTML5 pages using CSS3.
• Create well-structured and maintainable JavaScript code.
• Write modern JavaScript code and use Babel to ensure compatibility across all browsers.
• Utilize common HTML5 APIs in interactive web applications.
• Create web applications that support offline operations.
• Develop responsive HTML5 web pages that adapt to different devices and form factors.
• Add advanced graphics to an HTML5 page using Canvas elements and Scalable Vector Graphics (SVG).
• Enhance the user experience by adding animations to an HTML5 page.
• Use Web Sockets to facilitate real-time data exchange between a web application and a server.
• Improve the responsiveness of a web application performing long-running operations using Web Worker processes.
• Package web applications for production using WebPack.

This course is tailored to meet the needs of professionals in the public sector, ensuring that they have the skills necessary for government IT projects.

About This Course

This training course equips developers with the programming skills necessary to create Windows applications using the Visual C# language. Over five days, participants will review the fundamentals of Visual C# program structure, language syntax, and implementation details. They will also consolidate their knowledge by building an application that incorporates various features of the .NET Framework 4.7.

Audience Profile

This course is designed for experienced developers who have prior programming experience in languages such as C, C++, JavaScript, Objective-C, Microsoft Visual Basic, or Java and are familiar with object-oriented programming concepts. It is not intended for individuals new to programming; rather, it targets professional developers with at least one month of experience in an object-oriented environment.

At Course Completion

Upon completing this course, students will be able to:

• Describe the core syntax and features of Visual C#.
• Create methods, handle exceptions, and understand the monitoring requirements for large-scale applications.
• Implement the basic structure and essential elements of a typical desktop application.
• Create classes, define and implement interfaces, and create and use generic collections.
• Use inheritance to create a class hierarchy and extend a .NET Framework class.
• Read and write data using file input/output and streams, and serialize and deserialize data in various formats.
• Create and utilize an entity data model for database access and use LINQ to query data.
• Access and query remote data using the types in the System.Net namespace and WCF Data Services.
• Build a graphical user interface using XAML.
• Enhance the throughput and response time of applications by employing tasks and asynchronous operations.
• Integrate unmanaged libraries and dynamic components into a Visual C# application.
• Examine the metadata of types using reflection, create and use custom attributes, generate code at runtime, and manage assembly versions.
• Encrypt and decrypt data using symmetric and asymmetric encryption techniques.

This course is tailored to enhance the skills of developers for government and other professional environments, ensuring they are well-prepared to develop robust and efficient applications.

About This Course

This three-day MTA Training course is designed to help participants prepare for the Microsoft Technology Associate Exam 98-373. It covers essential topics such as working with physical devices, using data with mobile services, utilizing a mobile application development environment, and developing mobile applications. The content of this course aligns with the materials provided in the Microsoft Official Academic Course (MOAC) for this exam.

Audience Profile

The Microsoft Technology Associate (MTA) certification is a new suite of technology exams offered by Microsoft that validate foundational knowledge necessary for individuals starting their careers in technology. This program serves as an appropriate entry point for those interested in pursuing a future in the tech industry and assumes some hands-on experience or training, though it does not require on-the-job experience.

At Course Completion

Upon completing this course, students will be able to:

• Work with physical devices effectively
• Utilize data with mobile services
• Operate a mobile application development environment
• Develop mobile applications

This course is tailored to support professional growth and aligns with the needs of individuals seeking to enhance their skills for government and private sector roles.

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.

The Solution Architect plays a crucial role in the successful design, implementation, deployment, and adoption of an overall solution for government projects. They ensure that the solution meets the current and future needs of the agency or department. In this course, participants will gain insights into the critical decisions a Solution Architect makes during implementation, including security measures, integration strategies, Power Apps architecture, Power Automate architecture, and more. This course is designed to provide an introduction to the responsibilities and best practices of the Solution Architect role for government agencies.

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.