PASS Data Community Summit Courses

The Battle of Cloud Data Warehouses - Snowflake, Synapse, and More

A comparison of how MPP data warehousing services fit into cloud data warehouses, from Snowflake and Synapse to Redshift and BigQuery.

• YouTube
• 51 minutes
• Self-Paced
• Conference Talk

Machine Learning with SQL Server - From the Edge to the Cloud

Compares SQL-family machine-learning patterns for training, scoring, and deployment from edge devices through on-premises systems and the cloud.

• YouTube
• 56 minutes
• Self-Paced
• Conference Talk

The ABCs of BDCs - Big Data Clusters for Beginners

See how SQL Server Big Data Clusters combine relational and nonrelational data with HDFS and Spark, and what deployments and use cases suit them.

• YouTube
• 49 minutes
• Self-Paced
• Conference Talk

So, You Want to Be an Azure Data Engineer When You Grow Up?

Azure data engineering requires skills beyond traditional database administration, modeling, and query tuning, including storage, security, DevOps, and automation.

• YouTube
• 56 minutes
• Self-Paced
• Conference Talk

Checking in with Power Apps, Flow, and Power BI

Build a location check-in app that sends user and location data through an automated flow into a Power BI map report.

• YouTube
• 1 hour 2 minutes
• Self-Paced
• Conference Talk

Maximize Performance for Less Cost Using Azure SQL Database Serverless

See how Azure SQL Database serverless scales compute with demand to balance price and performance and simplify management for intermittent or unpredictable workloads.

• YouTube
• 1 hour 5 minutes
• Self-Paced
• Conference Talk

DAX Studio

Live demos show how DAX Studio’s Server Timings, Query Builder, Query Benchmarking, View Metrics, and parameter support help profile and diagnose query and model performance.

• YouTube
• 55 minutes
• Self-Paced
• Conference Talk

Migrating SQL Servers to AWS

Explore ways to move Microsoft SQL Server workloads to AWS with minimal downtime, using native migration methods and cloud migration tools.

• YouTube
• 56 minutes
• Self-Paced
• Conference Talk

SQL Migration to Azure - Best Practices, Accelerators, and Production Case Studies

A practical look at planning SQL workload migrations to Azure, using assessment tools and customer case studies to inform migration choices.

• YouTube
• 1 hour 13 minutes
• Self-Paced
• Conference Talk

Cosmos DB Develop Locally Deploy Globally

Set up Cosmos DB locally, load JSON data, build a Power BI visualization, then switch it to the cloud with a couple of commands.

• YouTube
• 1 hour 18 minutes
• Self-Paced
• Conference Talk

Comparing Predictive Models from R, Python, SSAS, and Azure ML

Learn how to evaluate predictive models and compare results across R, Python, SSAS, and Azure ML, using tools such as SSIS and Excel.

• YouTube
• 1 hour 13 minutes
• Self-Paced
• Conference Talk

Back Up and Restore a SQL Server Database If You're Not a DBA

Learn how to restore an inherited SQL Server database, including choosing a recovery model and automating restore tasks.

• YouTube
• 1 hour 13 minutes
• Self-Paced
• Conference Talk

SQL Server Migration - The Last Mile

A post-upgrade process for checking data accuracy and completeness and addressing workload regressions with Query Store, Automatic Tuning, and QTA.

• YouTube
• 1 hour 23 minutes
• Self-Paced
• Conference Talk

AI for the DBA

A DBA’s guide to supporting AI teams, from understanding the ecosystem to putting data scientists’ models into production with Azure ML Server.

• YouTube
• 1 hour 13 minutes
• Self-Paced
• Conference Talk

Code Like a Snake Charmer - Introduction to Python

An introduction to Python fundamentals through data access, package management, variables, control flow, and a simple machine learning deployment across Microsoft data tools.

• YouTube
• 1 hour 15 minutes
• Self-Paced
• Conference Talk