In this course, you’ll establish a solid foundational understanding of database concepts and terminology. Then you’ll master the use of various Microsoft tools to submit queries to quickly and efficiently get the results you want. We teach students how to write a query the same way that SQL Server processes a SQL statement – following … Continue reading SQL250: Transact-SQL for Developers
Blog Archives
PL-300T00: Microsoft Power BI Data Analyst
This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss … Continue reading PL-300T00: Microsoft Power BI Data Analyst
AZ-801T00: Configuring Windows Server Hybrid Advanced Services
This course teaches IT Professionals to configure advanced Windows Server services using on-premises, hybrid, and cloud technologies. The course teaches IT Professionals how to leverage the hybrid capabilities of Azure, how to migrate virtual and physical server workloads to Azure IaaS, and how to secure Azure VMs running Windows Server. The course also teaches IT … Continue reading AZ-801T00: Configuring Windows Server Hybrid Advanced Services
PL-7008: Create & Extend Custom Copilots in Microsoft Copilot Studio
In this course you will learn how to create custom copilots with Copilot Studio. You will learn how to integrate your Copilots with the Dataverse and Power Automate. You will also learn how to deploy the Copilots to a sample web site and Microsoft Teams.
PL-900T00: Microsoft Power Platform Fundamentals
Learn the business value and product capabilities of Microsoft Power Platform. Create simple Power Apps, connect data with Dataverse, build a Power BI Dashboard, and automate processes with Power Automate.
AZ-305T00: Designing Microsoft Azure Infrastructure Solutions
This course teaches Azure Solution Architects how to design infrastructure solutions. Course topics cover governance, compute, application architecture, storage, data integration, authentication, networks, business continuity, and migrations. The course combines lecture with case studies to demonstrate basic architect design principles.
AI-102T00: Designing and Implementing a Microsoft Azure AI Solution
AI-102 Designing and Implementing an Azure AI Solution is intended for software developers wanting to build AI infused applications that leverage Azure AI Services, Azure AI Search, and Azure OpenAI. The course will use C# or Python as the programming language.
AZ-104T00: Microsoft Azure Administrator
This course teaches IT Professionals how to manage their Azure subscriptions, secure identities, administer the infrastructure, configure virtual networking, connect Azure and on-premises sites, manage network traffic, implement storage solutions, create and scale virtual machines, implement web apps and containers, back up and share data, and monitor your solution.
SQL101v2: Introduction to Transact-SQL
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
AI-900T00: Microsoft Azure AI Fundamentals
Artificial Intelligence (AI) will define the next generation of software solutions and unlocks the potential to create amazing applications. This course introduces fundamentals concepts related to artificial intelligence (AI), and the services in Microsoft Azure that can be used to create AI solutions. The course is not designed to teach students to become professional data … Continue reading AI-900T00: Microsoft Azure AI Fundamentals