PASS Data Community Summit Courses

Data Governance for Beginners

1 rating

Learn data governance basics for Microsoft Data Platform, including master data management and data stewardship. Discover practical steps for implementation and documentation to enhance organizational data value.

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

Build Your Brand with Technical Writing

1 rating

Discover how technical writing can boost your career, enhance your brand, and make a global impact. Learn about the publishing process and strategies to kickstart your writing journey.

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

The Function of Windowing Functions - DBA Fundamentals

1 rating

Explore windowing functions in SQL for efficient data analysis, including row numbering, aggregation, lag/lead, and distribution functions. Learn practical applications and advanced techniques.

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

Building Resilient Environments - Incorporating Security and Compliance into Database Monitoring

Discover essential strategies for database security and compliance monitoring, from vulnerability detection to access control implementation and audit processes for maintaining industry standards.

• YouTube
• 59 minutes
• Self-Paced
• Free Video

SQL Server Best Practices for SharePoint

Descubra as melhores práticas de configuração do SQL Server para otimizar o desempenho do SharePoint, maximizando a eficiência e o rendimento do seu ambiente de colaboração.

• YouTube
• 58 minutes
• Self-Paced
• Free Video

Troubleshooting SQL Server Like a Microsoft Engineer Using Public Tools

Master SQL Server troubleshooting techniques using free public tools, learn data capture methods, and discover customization approaches for performance analysis from Microsoft engineers.

• YouTube
• 56 minutes
• Self-Paced
• Free Video

Indexing for Beginners

Master the fundamentals of SQL Server indexing, including clustered and non-clustered indexes, index maintenance, and optimization strategies for improved database performance.

• YouTube
• 58 minutes
• Self-Paced
• Free Video

In-Memory OLTP in SQL Server - Overview and Architecture

Dive into SQL Server's In-Memory OLTP architecture, exploring memory optimization, native compilation, and lock-free concurrency control for enhanced database performance.

• YouTube
• 57 minutes
• Self-Paced
• Free Video

In-Memory OLTP for Database Developers in SQL Server 2014

Dive into SQL Server 2014's in-memory OLTP optimization, exploring memory-optimized tables, hash indexes, and natively compiled stored procedures for enhanced database performance and lock-free transactions.

• YouTube
• 59 minutes
• Self-Paced
• Free Video

Performance Tuning SQL Server Integration Services (SSIS)

Master advanced SSIS performance tuning techniques, from optimizing data flow to resource management, while exploring efficient features in SQL Server 2008 and 2012 for better ETL processes.

• YouTube
• 1 hour 1 minute
• Self-Paced
• Free Video

Private and Hybrid Cloud Features in SQL Server 2014

Discover new private and hybrid cloud capabilities in SQL Server 2014 through hands-on demonstrations and practical implementation strategies for cloud-based database management.

• YouTube
• 1 hour
• Self-Paced
• Free Video

MongoDB for the SQL Server Professional

Discover how MongoDB's architecture and functionality compares to SQL Server, exploring key differences in data modeling, querying, and administration for database professionals.

• YouTube
• 56 minutes
• Self-Paced
• Free Video

PowerBI e o Futuro da Análise de Dados - Soluções de Self Service BI

Explore o PowerBI da Microsoft e suas funcionalidades para implementar soluções eficientes de Self Service BI na nuvem, transformando dados em insights valiosos para sua organização.

• YouTube
• 1 hour 13 minutes
• Self-Paced
• Free Video

Managing On-Premises and Azure Databases with PowerShell

Master PowerShell cmdlets to efficiently manage and control both on-premises and Azure SQL databases through unified administration techniques and consistent management practices.

• YouTube
• 45 minutes
• Self-Paced
• Free Video

Spatial Data Analytics: Looking Beyond Traditional Mapping

Discover powerful applications of spatial data in SQL Server beyond traditional mapping, exploring advanced analytics and innovative visualization techniques for location-based insights.

• YouTube
• 54 minutes
• Self-Paced
• Free Video