PASS logo PASS Data Community Summit 2021
Host Redgate Premier sponsor Microsoft

November 8-12

Free online conference

Register

Learning pathways

Learning pathways are a curated, progressive series of sessions designed to help you master specific learning outcomes. Develop real skills you can implement in your career today.

Learning pathway

Become an Azure Data Engineer

As the need for Data Scientists continues to grow, so too does the demand for an evolving Data Engineer. Discover what an Azure Data Engineer is and what you need to learn to step into this critical role.

Join our Become an Azure Data Engineer learning pathway to understand what this role is and what you need to know, or already know, in topics such as Azure Data Factory, Data Lakes, and Azure Databricks. You will leave this learning pathway with everything you need to begin your journey in becoming an Azure Data Engineer.

  • Level 100

    What is an Azure Data Engineer?

    Darek Easterly & Dustin Vannoy

  • Level 100

    Azure Synapse Analytics Pipelines: a 360-degree view

    Carey Payette

  • Level 100

    Building Your First Data Pipeline in Apache Spark

    Kevin Feasel

  • Level 200

    Data Modeling for Analytics on Azure

    Ike Ellis

  • Level 200

    Synapse Analytics: The Azure data engineer's ultimate toolbox

    Joel Hulen

  • Level 200

    Stream Processing in Azure: A Data Engineer's Guide

    Alicia Moniz & Dustin Vannoy

Learning pathway

AI & ML

Artificial Intelligence (AI) and Machine Learning (ML) have revolutionized the technologies we use and the nature of our work, and leveraging these tools has become increasingly essential for the modern data professional.

Throughout our AI & ML Learning Pathway, you’ll start with the fundamentals of designing and deploying AI & ML systems, and progress through to how to optimize for performance and maintain your processes across Azure Machine Learning, Azure Synapse, Python, and much more.

  • Level 100

    Introduction to Machine Learning using Azure ML

    Jamey Johnston

  • Level 100

    Python in the Microsoft Data Platform

    Chris Hyde

  • Level 200

    Transitioning your T-SQL skills to Spark SQL

    John Miner

  • Level 200

    Getting Started with Machine Learning in Azure Synapse Analytics and Azure ML

    Ginger Grant

  • Level 200

    Keeping it Classy: Designing a Great Classifier

    Kevin Feasel

  • Level 100

    The Data Talks Back: Speech & Language AI for the Data Professional

    Matt Gordon

Learning pathway

Cloud Migrations

With more and more companies moving their data to the cloud it is increasingly important to understand how to do it right, and where to go. Every solution has pros and cons, but what are they? Which one makes the most sense for your environment? How do you build a solid cloud migration plan and set yourself up for success? While this can feel overwhelming, it doesn’t have to be.

Join our Cloud Migration learning pathway to hear from industry leading migration experts and some of the world’s foremost cloud providers. We will show you how to assess your environment, build your plan, pick your cloud solution, and then how to migrate. You will leave this pathway with the confidence to build your own plan, and migrate to the cloud.

  • Level 100

    Azure SQL & Our Toolbox To Manage It

    Jess Pomfret

  • Level 200

    Azure Arc for the Data Professional

    Ben Weissman

  • Level 100

    Control your Cloud Data Deployments - Deploy your Azure Data Solutions with Bicep and Azure DevOps

    Rob Sewell

  • Level 200

    What's new with Amazon RDS for SQL Server

    Carlos Robles

  • Level 200

    Architecting for High Availability in Azure SQL

    Anthony Nocentino

Learning pathway

Data Security & Governance

Data security & governance are among the most complex issues for a data professional when managing SQL Server, yet they’re also two of the most important, especially when sensitive data is on the line. But how can you counter security threats? How can you implement processes to better protect your customers’ data?

Join our Data Security & Governance learning pathway to learn how to design secure and compliant database applications and protect your SQL Server. You will leave this pathway knowing how to launch and audit a data governance program and how to monitor your SQL Server security at scale.

  • Level 200

    Hacking SQL Server Another Day

    André Melancia

  • Level 100

    Secure This!

    Ita Ryan

  • Level 100

    SQL Server Security Essentials

    Ben Debow

  • Level 200

    Applying a Security Mindset to Lock Down Azure SQL DB

    Surbhi Pokharna

  • Level 200

    Auditing your Data and Data Access

    Kenneth Fisher

  • Level 200

    Monitoring SQL Server Security at Scale

    Ed Leighton-Dick

  • Level 100

    How DBAs Can Launch a Data Governance Program

    Kevin Kline

Learning pathway

DBA Basics

The role of the DBA is complex and covers a wide spectrum of responsibilities including performance, compliance, and security of business databases.

Join our DBA Basics learning pathway to get started on the fundamental requirements of a DBA and take a deeper look at some of the technologies that will be essential in your role.

  • Level 100

    Database Administration: The First 30 Days

    Michael Walsh

  • Level 200

    Understanding SQL Server Backup and Restore

    Tim Radney

  • Level 100

    SQL Server Security Essentials

    Ben DeBow

  • Level 100

    DBA Basics: Getting Started with Performance Tuning

    John Sterrett

  • Level 100

    Virtual SQL Server Performance for the DBA

    David Klee

  • Level 100

    High Availability Basics for the DBA: What SQL Server Cannot Do For You

    Edwin M Sarmiento

  • Level 200

    Understanding Azure SQL

    Tim Radney

Learning pathway

Database DevOps

DevOps practices have been embraced by most successful organizations, but including databases in DevOps has its own challenges.

Join the Database DevOps learning pathway to learn about version control, automating deployments, unit testing, and more.

  • Level 100

    A Version Control Primer for Databases

    Steve Jones

  • Level 100

    DevOps 101 for Data Folks

    Alex Yates

  • Level 100

    Introduction to Unit Testing with tSQLt

    Sebastian Meine

  • Level 100

    DevOps for Power BI

    Jan Mulkens

  • Level 300

    A Complete DevOps Solution for Databases

    Hamish Watson

Learning pathway

Power BI

Power BI is the leading analytics tool from Microsoft with visualizations and insights for the entire organization.

Join this learning pathway to get started with Power BI, learn best practices, administer Power BI, and more.

  • Level 100

    Migrating from Azure Analysis Services to Premium Per User

    Gilbert Quevauvilliers

  • Level 100

    Power BI Building First report

    Heidi Hasting

  • Level 200

    Power BI Dataflows; Power Query Everywhere, Re-usable

    Reza Rad

  • Level 300

    Let’s Review AI and Analytics in Power BI

    Leila Etaati

  • Level 100

    Best Practices for Delivering and Sharing Content in the Power BI Service

    Melissa Coates

  • Level 100

    The Power BI Administrator and Governance

    Ásgeir Gunnarsson

Learning pathway

Query Basics

It doesn’t matter which role you have as a data professional, querying the database is an essential skill.

Join this learning pathway to learn T-SQL from the beginning including joining tables, updating data, and advanced features such as constraints.

  • Level 100

    Introduction to SQL | Getting Started

    Amanda Halverson & Carlos Chacon

  • Level 100

    Introduction to SQL | Expanding on Select *

    Mariano Kovo

  • Level 100

    Introduction to SQL | How to Change Existing Data

    Brian Combs

  • Level 100

    Introduction to SQL | More than Just Tables

    Carlos Chacon

  • Level 100

    Introduction to SQL | Level up with Advanced Features

    Eugene Meidinger

Learning pathway

Query Tuning

Inefficient queries can drain your database server resources and reduce overall performance. It is vital that you optimize queries individually and holistically to minimize impact on the performance of your data platform. But how to tackle these very complicated issues where something that works great one minute, is terrible the next? What techniques can you use to optimize queries so that they execute faster with the least impact to the rest of the system?

Join our Query Performance Tuning learning pathway to explore the tools and best practices for optimizing your SQL queries. Not only will you learn how to find and solve query performance issues, but you will also discover how to increase overall query performance and how to anticipate decreased performance in the future. Don’t wait to build efficient, beautiful queries that will run smoothly and be the game-changer in your applications!

  • Level 100

    Identify Poorly Performing Queries - Three Tools You Already Own

    Grant Fritchey

  • Level 200

    Here’s the Execution Plan … Now What?

    Hugo Kornelis

  • Level 200

    Indexing for Performance

    Kimberly Tripp

  • Level 200

    Demystifying Statistics in SQL Server

    Erin Stellato

  • Level 300

    Query Tuning Tips Concerning Table Expressions

    Itzik Ben-Gan

  • Level 200

    Tackling Monster Stored Procs - A Performance Case Study

    Allen White

Registration is now open

Get your free place for the PASS Data Community Summit 2021 today

Register now