Virtual Live MCTS Training Classes and Remote Seminars

In this course you will learn how to secure user access to your organization’s resources. The course covers user password protection, multi-factor authentication, how to enable Azure Identity Protection, how to setup and use Azure AD Connect, and introduces you to conditional access in Microsoft 365. You will learn about threat protection technologies that help protect your Microsoft 365 environment. Specifically, you will learn about threat vectors and Microsoft’s security solutions to mitigate threats. You will also learn about Secure Score, Exchange Online protection, Azure Advanced Threat Protection, Windows Defender Advanced Threat Protection, and threat management. In the course you will learn about information protection technologies that help secure your Microsoft 365 environment. The course discusses information rights managed content, message encryption, as well as labels, policies and rules that support data loss prevention and information protection. Lastly, you will learn about archiving and retention in Microsoft 365 as well as data governance and how to conduct content searches and investigations. This course also covers data retention policies and tags, in-place records management for SharePoint, email retention, and how to conduct content searches that support eDiscovery investigations.In this course you will learn how to secure user access to your organization’s resources, threat protection technologies that help protect your Microsoft 365 environment, information protection technologies that help secure your Microsoft 365 environment, archiving and retention in Microsoft 365 as well as data governance and how to conduct content searches and investigations....

This course is designed for customers who are interested in learning Microsoft Dynamics GP 2018. It covers not only features in Dynamics GP 2018, but also the important capabilities of Dynamics GP in general. This one-day course explores the basic elements of Microsoft Dynamics GP. Topics covered during this session include system and company setup procedures, how to use reports and inquiries, how to use SmartList to expand inquiry and analysis capabilities and tips for the user to personalize Microsoft Dynamics GP to streamline business practices....

This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling....

This two-day course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers....

This course provides you with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. You will learn the skills to identify and build the command they require to perform a specific task. In addition, you will learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches....

This course explores the processes required to manage cash receipts, cash disbursements, and other transactions that affect checkbook balances. It also shows you how to perform the checkbook reconciliation process in the Bank Reconciliation module, ensuring accuracy of your financial data and its relation to your financial institution statements....

In this course, you will gain foundational knowledge of core data concepts and related Microsoft Azure data services. You will learn about core data concepts such as relational, non-relational, big data, and analytics, and build your foundational knowledge of cloud data services within Microsoft Azure. You will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB. You will learn about modern data warehousing, real-time analytics, and data visualization. This course will prepare you for the following exam: DP-900: Azure Data Fundamentals...

Learn the business value and product capabilities of Microsoft Power Automate and Power Automate for desktop....

This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases. This course includes the following exam: DP-300: Azure Database Administrator Associate Exam Pass Guarantee - Prepare for your exam using the practice software that we provide. Once you have achieved an 85% or above score, contact us and we will provide you with an exam voucher. Didn't pass the first time? Not a problem--you will get a second voucher with our Exam-Pass Guarantee....

This five-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions. The primary audience for this course is database professionals who need to fulfill a BI developer role to create reports. Primary responsibilities will include implementing reports and mobile reports.  The secondary audiences for this course are power information workers....