PASS Data Community Summit Courses

CosmosDB

Aprenda a transferir conhecimentos de SQL Server para CosmosDB, explorando semelhanças e diferenças entre as bases, com foco em projeto e modelagem específicos do CosmosDB. Demonstrações práticas incluídas.

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

Batch Execution Mode on the Rowstore

Descubra como o Modo de Execução em Lote acelera o processamento de grandes volumes de dados em índices Rowstore no SQL Server 2019 e Azure SQL DB, suas vantagens e desafios.

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

SQL Server Security Basics - Security

Learn SQL Server database security essentials, including permissions, principals, and best practices. Gain practical knowledge to protect your company's valuable data and manage security effectively.

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

Complex Event Processing - CEP 10,000 Foot View

Explore Complex Event Processing from a high-level perspective, understanding its concepts, applications, and impact on data analysis and decision-making in real-time systems.

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

Install & Configure SQL Server with PowerShell DSC

Implement infrastructure as code for SQL Server using PowerShell Desired State Configuration (DSC). Learn to prepare a new Windows Server and explore the advantages of this approach.

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

What Else Can Indexes Do

Explore advanced indexing techniques to optimize query performance, improve memory usage, and reduce locking issues. Learn practical strategies beyond fragmentation for solving real database problems.

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

What's New in SQL Server 2019

Explore SQL Server 2019's enhancements in performance, security, Linux support, and Big Data Clusters. Learn about new features and improvements across the SQL Engine and Availability groups.

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

Azure Basics for the DBA - Cloud

Explore Azure fundamentals for DBAs, covering key concepts, terminology, and hands-on demos. Learn to set up virtual machines and SQL databases, enhancing your cloud skills for career growth.

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

Introduction to Azure AI - The Art of the Possible

Explore Azure AI's potential to transform businesses using data science and machine learning. Learn how to leverage this suite for client solutions through practical demonstrations and real-world examples.

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

Introduction to Azure Data Bricks - Cloud

Explore Azure Databricks for big data processing, advanced analytics, and real-time insights. Learn platform basics, architecture, and integration with Azure components for data-driven solutions.

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

Azure Data Factory Ingestion Framework - Cloud

Explore a framework for Azure Data Factory ingestion, covering data strategy, metadata database design, and automated pipeline development for efficient data lake management.

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

Introduction to Azure Cognitive Services - Cloud

Explore Azure Cognitive Services APIs for developing intelligent applications. Learn about various categories, including Computer Vision, Speech, Language, and Search, with practical demos and use cases.

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

AI with Power BI - Business Intelligence

Learn to create and use machine learning models in Power BI, leveraging Azure's capabilities for data-driven insights. Hands-on demos showcase AI integration for enhanced business intelligence.

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

Using Azure Databricks to Develop Scalable Data Solutions

Develop scalable data solutions using Azure Databricks for efficient processing, collaborative development, and seamless integration with Azure services and Power BI visualization.

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

High Availability - Disaster Recovery 101 - Data Architecture

Explore SQL Server 2017 HA/DR technologies, design strategies, and policies to meet specific RTO and RPO service levels. Learn to combine solutions for optimal infrastructure planning.

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