PASS Data Community Summit Courses

10 Cool Things You Can Do With Azure Databricks

Discover 10 practical Azure Databricks applications through live demos, including VS Code integration, streaming with Event Hub, and Delta time travel, enhancing your data engineering skills.

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

Privacy and Security by Design in a Cloud Environment

Learn security and privacy design principles for cloud architectures, with practical implementation examples and best practices for integrating these crucial aspects into your solutions.

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

Azure SQL Database - Maximizing Cloud Performance and Availability

Optimize Azure SQL Database performance and availability for mission-critical applications. Learn best practices, configuration tips, and troubleshooting techniques to maximize cloud resources and achieve 99.995% uptime.

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

Improving Database Code Quality with Unit Tests

Learn to implement unit testing for T-SQL code, enhancing database quality. Discover tools and techniques for automated testing, test-driven design, and integrating tests into your development workflow.

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

Design Strategies and Advanced Data Visualization

Advanced techniques for effective data visualization, including accessibility design, data storytelling, and creating impactful reports and dashboards for diverse audiences.

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

Data Modeling and Prototyping in Power BI Desktop

Explore rapid data modeling and prototyping using Power BI Desktop. Learn to connect, cleanse, and model data from various sources, creating quick reports for project approval without licensing costs.

• YouTube
• 1 hour 1 minute
• Self-Paced
• Conference Talk

Bringing Source Control to BI World

Discover how to implement source control in Business Intelligence environments, improving version management, tracking changes, and facilitating parallel development for databases, cubes, and reports.

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

Choosing Database Hardware for SQL Server 2019

Optimize SQL Server 2019 hardware selection for performance and cost-efficiency. Learn to evaluate workloads, choose processors, and navigate licensing changes to maximize database server capabilities.

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

Should I Move My Production SQL Server Workloads to Containers

Explore the pros and cons of containerizing SQL Server workloads, examining architectural differences, advantages, and challenges to help decide if containers are right for your production environment.

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

Two Truths That's A Lie - Data Visualization Ethics

Explore data visualization ethics, examining how color and chart choices influence storytelling. Learn to create truthful, impactful visualizations while protecting your company's reputation.

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

Innovative Data Modeling for Cool Data Warehouses

Explore agile data warehouse modeling techniques beyond traditional norms. Learn to build flexible, auditable solutions adaptable to various industries, leveraging MDM and Azure for enhanced performance and data integration.

• YouTube
• 2 hours 24 minutes
• Self-Paced
• Conference Talk

Data Classification - Taking Your First Step on the Road to Agile Data Governance

Learn to build and maintain an evergreen catalog of your SQL Server estate, enabling agile data governance. Discover best practices for data classification, protecting sensitive information, and ensuring compliance with privacy regulations.

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

CosmosDB - Designing and Troubleshooting Lessons

Learn to design, query, and troubleshoot high-performance Cosmos DB solutions through hands-on labs covering partition design, SQL API querying, and request optimization techniques.

• YouTube
• 2 hours 32 minutes
• Self-Paced
• Conference Talk

Accelerate Migrations of Legacy SQL Server and SSIS with Azure Data Factory

Streamline SQL Server and SSIS migration to Azure using ADF. Learn to provision SSIS-IR, run SSIS packages in ADF pipelines, and leverage DMA and DMS for efficient batch migrations.

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

Modern Excel - The Supercomputer Hiding on Everyone’s Desktop

Discover game-changing Excel tools for data-driven decisions. Learn multi-source import, rapid data shaping, portable formulas, and insightful reporting techniques to supercharge your spreadsheet skills.

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