In this course, you’ll master the skills needed to write Transact-SQL SELECT statements accessing one or more tables. You’ll also learn the various techniques for combining data, filtering the results and how to control and format the statement output. You’ll gain a foundation understanding of a SQL Server database and use the tools available to … Continue reading SQL101v2: Introduction to Transact-SQL
Blog Archives
PL-7004: Implement AI Models with Microsoft Power Platform AI Builder
Microsoft AI Builder offers a wide array of AI capabilities. Through this course, you’ll discover how to leverage AI for your business enhancement, including text recognition, document processing automation, and incorporating AI Builder’s features into applications or workflows.
PL-7000: Creating Apps and Automated Workflows with Microsoft Power Platform
Transition from the retiring PL-100T00: Microsoft Power Platform App Maker to the new PL-7000 Bundle. This 4-day live instructor-led course combines three official Microsoft Applied Skills courses: PL-7001 (Create and Manage Canvas Apps with Power Apps), PL-7002 (Create and Manage Automated Processes using Power Automate), and PL-7003 (Create and Manage Model-driven Apps with Power Apps … Continue reading PL-7000: Creating Apps and Automated Workflows with Microsoft Power Platform
AZ-140T00: Configuring and Operating Microsoft Azure Virtual Desktop
This course teaches Azure administrators how to plan, deliver, and manage virtual desktop experiences and remote apps, for any device, on Azure. Students will learn through a mix of demonstrations and hands-on lab experiences deploying virtual desktop experiences and apps on Azure Virtual Desktop and optimizing them to run in multi-session virtual environments.
MS-102T00: Microsoft 365 Administrator Essentials
This course covers the following key elements of Microsoft 365 administration: Microsoft 365 tenant management, Microsoft 365 identity synchronization, and Microsoft 365 security and compliance. In Microsoft 365 tenant management, you learn how to configure your Microsoft 365 tenant, including your organizational profile, tenant subscription options, component services, user accounts and licenses, security groups, and … Continue reading MS-102T00: Microsoft 365 Administrator Essentials
DP-900T00: Microsoft Azure Data Fundamentals
This is an introductory course. Students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how … Continue reading DP-900T00: Microsoft Azure Data Fundamentals
AZ-040T00: Automating Administration with PowerShell
This course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating … Continue reading AZ-040T00: Automating Administration with PowerShell
BITLOCKER: Planning and Deploying BitLocker Drive Encryption
This 2-day instructor-led BitLocker training course teaches you everything you need to know about BitLocker. This course includes hands-on labs. These labs reinforce and expand on the instructor-led portion by having you actually deploy and operate BitLocker. You’ll practice techniques for setting up a BitLocker-enabled environment, implementing BitLocker on multiple system configurations, and recovering BitLocker … Continue reading BITLOCKER: Planning and Deploying BitLocker Drive Encryption
POWER400: Advanced PowerShell
This course is a continuation of MOC 10961 or AZ-040, Automating Administration with Windows PowerShell. We will be taking a deep dive into the development of PowerShell cmdlets and modules. Time will be spent on the theory of how to design your cmdlets as well as the proper structure of the programming code to facility … Continue reading POWER400: Advanced PowerShell
PL-400T00: Microsoft Power Platform Developer
The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes. In this course, students will learn how to build Power Apps, Automate Flows and extend the platform to complete business requirements and solve complex business problems.