Explore digital courses

Introduction to Transact-SQL

Units in this learning path:

• Introduction
• Work with Schemas
• Explore Structure SQL Statements
• Examine Select Statement
• Work with Data Types
• Handle Nulls
• Exercise Work with Select Statements
• Knowledge Check
• Summary

Products: Azure SQL Database, SQL Server, Azure SQL Managed Instance, Azure Sqlserver Vm, Azure SQL Virtual Machines, Fabric

Roles: Data Analyst, Data Engineer, Data Scientist, Database Administrator, Developer, Solution Architect, Student, Technology Manager

Level: Beginner

Subjects: Data Analytics, Databases, Backend Development

Duration: 61 minutes

This module describes how Microsoft Azure provides a comprehensive platform for data engineering.

Units in this learning path:

• Introduction
• What Data Engineering
• Common Patterns Azure Data Engineering
• Common Tooling Azure Data Engineering
• Knowledge Check
• Summary

Products: Azure

Roles: Data Engineer

Level: Intermediate

Subjects: Data Engineering

Duration: 26 minutes

Discover how Microsoft Fabric can meet your enterprise's analytics needs in one platform. Discover the capabilities Fabric has to offer, understand how it works, and identify how you can use Fabric for your analytics needs.

Units in this learning path:

• Introduction
• Explore Analytics Fabric
• Data Team
• Use Fabric
• Knowledge Check
• Summary

Products: Fabric

Roles: Business Analyst, Data Analyst, Data Engineer, Data Scientist

Level: Beginner

Subjects: Data Analytics

Duration: 22 minutes

Module on the use of Azure Cosmos DB as part of a migration solution.

Units in this learning path:

• Introduction
• Cosmos Db Overview
• Cosmos Db Apis
• Considerations Migrating Nosql Cosmos Db
• Provisioning Cosmos Db Throughput
• Cosmos Db Partitioning Best Practices
• Knowlege Check
• Summary

Products: Azure, Azure Cosmos Db

Roles: Data Engineer

Level: Intermediate

Subjects: Databases

Duration: 40 minutes

Do you want to know how to start creating reports for Business Central? If so, this module will explain the different components that a typical report consists of.

Units in this learning path:

• 1 Introduction
• 2 Learn Overview Report Description
• 3 Report Properties Triggers
• 4 Data Items Columns
• 5 Request Page
• 6 Work Report Labels
• 7 Report Layouts
• 8 Check
• 9 Summary

Products: Dynamics 365, Dynamics Business Central

Roles: Developer

Level: Intermediate

Subjects: Data Management

Duration: 37 minutes

This course introduces the cloud and describes what it means for your healthcare practice and to you as a clinician. The cloud can reduce the burden of technology on clinicians. They can then focus on delivering care, identifying healthcare needs,…

Large-Scale Data Processing with Azure Data Lake Storage Gen2

Modules in this learning path:

• Introduction to Azure Data Lake Storage
• Upload Data to Azure Data Lake Storage
• Secure Azure Storage Account

Products: Azure, Azure Portal, Azure Storage, Azure Virtual Machines

Roles: Data Engineer

Level: Beginner

Subjects: Data Storage

Duration: 110 minutes

Are you aware of the data and file structure for Business Central? This learning path provides insight into the data management foundation for Business Central. It also introduces XMLports and queries.

Modules in this learning path:

• Introduction Basics File Management
• Work with Xmlports
• Work with Queries

Products: Dynamics 365, Dynamics Business Central

Roles: Developer

Level: Intermediate

Subjects: Data Management

Duration: 205 minutes

Learn how to load data into a Microsoft Fabric warehouse using data pipelines, T-SQL, and Dataflow Gen2.

Units in this learning path:

• Introduction
• Explore Data Load Strategies
• Load Data Using Data Pipeline
• Load Data Using Tsql
• Load Data Using Dataflow
• Exercise Load Data Into Warehouse
• Knowledge Check
• Summary

Products: Fabric

Roles: Data Analyst, Data Engineer

Level: Beginner

Subjects: Data Management, Machine Learning

Duration: 61 minutes

This course was developed by members of AWS Technical Field Communities (TFC), an AWS community of technical experts. The content is intended to complement our standard training curriculum and augment your AWS learning journey. We are aware some…

This earner completed all learning activities included in this online learning experience related to advanced topics core to the data science profession including: Data Modeling techniques; Machine Learning; Deep Learning algorithms; Data Science Automation; demonstration of advanced skills application in the field of Data Science by role-playing critical roles in a data science team using latest AI tools for analytics/automation to address real problems insurance co's face in fraud claims data.

This module explores file system fragmentation and the tools that you can use to reduce fragmentation. Students will learn how Windows can compress files to take up less space on the hard disk.

Units in this learning path:

• Introduction
• Monitor Storage Usage
• Understand Disk Optimization
• Explore File Folder Compression
• Knowledge Check
• Summary

Products: Windows

Roles: Administrator

Level: Beginner

Subjects: Data Management, Device Management, Storage

Duration: 18 minutes