PASS Data Community Summit Courses

The Function of Windowing Functions - DBA Fundamentals

1 review

Learn about windowing functions in SQL with Kevin Wilkie at PASS Data Community Summit. Master techniques like row numbering, aggregate functions, and more in 1-2 hours.

• YouTube
• 1 hour 3 minutes
• On-Demand
• Conference Talk

Delivering a Data Warehouse in the Cloud

Learn to transition from an on-premise data warehouse to the cloud with Azure SQL, covering provisioning, data loading, performance improvement, and security management. (PASS Data Community Summit)

• YouTube
• 1 hour 16 minutes
• On-Demand
• Conference Talk

Whacha Just Say? Talking Technology to Non Technical People

Learn to effectively communicate technical concepts to non-tech individuals in this interactive 1-2 hour session by PASS Data Community Summit.

• YouTube
• 1 hour 9 minutes
• On-Demand
• Conference Talk

Azure Data Studio - The New Frontier

Learn to manage your Data Platform fleet with Microsoft's Azure Data Studio in this demo-heavy session by PASS Data Community Summit. Expect tips, tricks, and a deep dive into features.

• YouTube
• 1 hour 13 minutes
• On-Demand
• Conference Talk

Relational Data Modeling Trends for Transactional Applications

Explore modern data modeling trends with Ike Ellis in this 1-2 hour session from PASS Data Community Summit. Learn to adapt traditional principles to today's fast-changing business environment.

• YouTube
• 1 hour 18 minutes
• On-Demand
• Conference Talk

Spatial Analysis with SQL Server, R and Power BI

Explore spatial analysis using SQL Server, R, and Power BI with PASS Data Community Summit. Learn to analyze and query spatial properties of data in a 1-2 hour session.

• YouTube
• 1 hour 17 minutes
• On-Demand
• Conference Talk

Eliminating Anti-Patterns and RBAR for Faster Performance

Improve SQL Server performance with minimal effort in this 1-2 hour session by PASS Data Community Summit. Learn to identify and fix common mistakes for faster, scalable results.

• YouTube
• 1 hour 19 minutes
• On-Demand
• Conference Talk

An Azure Data Engineer's ETL Toolkit

Learn to navigate Azure's data movement and transformation options with real-world examples, understand SSIS limitations, and master ETL patterns in Azure Data Factory. Offered by PASS Data Community Summit.

• YouTube
• 1 hour 11 minutes
• On-Demand
• Conference Talk

SQL Isn't for Analysis - Why Everyone Needs OLAP Data Models

Explore the power of a middle-tier modeling and calculation layer in data storage and visualization with Rob Collie at the PASS Data Community Summit. Duration: 1-2 hours.

• YouTube
• 1 hour 21 minutes
• On-Demand
• Conference Talk

Performance Tuning Azure SQL Databases

Learn to optimize Azure SQL Databases with PASS Data Community Summit's session. Master Automatic Tuning, Intelligent Insights, and Extended Events for peak performance.

• YouTube
• 1 hour 18 minutes
• On-Demand
• Conference Talk

Giving Feedback - How to Effectively Communicate to Your Employees

Improve your managerial communication skills with this 1-2 hour session by PASS Data Community Summit. Learn to give effective feedback, prepare for tough conversations, and handle confrontation tactfully.

• YouTube
• 1 hour 22 minutes
• On-Demand
• Conference Talk

Analytics Spotlight - The New Analyst

Explore the evolving world of business intelligence and analytics with Donald Farmer at the PASS Data Community Summit. Learn about data literacy, working with data science, and handling ambiguity.

• YouTube
• 1 hour 16 minutes
• On-Demand
• Conference Talk

Inside Kubernetes - An Architectural Deep Dive

Dive deep into Kubernetes architecture with Anthony Nocentino in this 1-2 hour session offered by PASS Data Community Summit. Learn about components, services, controllers, deployments, and high availability designs.

• YouTube
• 1 hour 14 minutes
• On-Demand
• Conference Talk

Designing Azure Data Disaster Recovery Strategies

Learn to protect your Azure Data footprint from outages with strategies for SQL Databases, virtual machines, and Managed Instances in a 1-2 hour session by PASS Data Community Summit.

• YouTube
• 1 hour 12 minutes
• On-Demand
• Conference Talk

Large-Scale Migration of On-Premise Big Data Workloads to Azure

Learn to migrate large-scale data from On-Premise to Azure with PASS Data Community Summit. Master Azure Data Lake Storage, Azure SQL Data Warehouse, and data movement offerings in 1-2 hours.

• YouTube
• 1 hour 17 minutes
• On-Demand
• Conference Talk