SQLBits Courses

Shift-Left: A DevOps and Database Story for Performance Tuning

Discover how to catch database performance issues during development, preventing production problems and improving efficiency with SQL Sentry.

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

Advancing the DBA's Role in the Cloud - Azure SQL Managed Instance

Explore the evolving DBA role from on-premises to Azure SQL, learn shared responsibilities, and discover skill development opportunities for becoming an Azure SQL DBA superstar.

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

Power BI Culture: Governance as a Gateway to Adoption, Not a Barrier

Discover strategies for creating a Power BI culture, accelerating ROI through effective governance principles and pillars of adoption and engagement.

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

Return Ticket from SQL Managed Instance to SQL Server - One-Click Reverse Migration and DR

Explore hybrid link setup, reverse migration, and disaster recovery between SQL Managed Instance and SQL Server 2022. Learn integrated hybrid capabilities for optimal database management.

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

Navigating the Skies of Open AI - Perfecting Grounding for Large Language Models

Explore ChatGPT's impact on knowledge consumption, learn about LLM grounding and vector databases, and understand OpenAI's technology for efficient data retrieval and scalability.

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

JSON as a First-Class Citizen in Azure SQL Database

Explore new T-SQL features in Azure SQL Database, focusing on JSON as a first-class data type. Learn to query and manipulate JSON data, enhancing data management capabilities.

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

SQL Horror Stories - Cautionary Tales and Coding Tips

Explore hilarious and cringe-worthy SQL coding mishaps with Kevin Kline, learning valuable tips and tricks from these cautionary tales.

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

Web Scraping Puppy Data with Microsoft Fabric - 2nd Leg

Learn web scraping techniques using CSS Selectors in Power Query, m code, and PySpark within Microsoft Fabric to extract puppy data from websites.

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

Let End Users Drive - Empowering User Control in Power BI Reports

Empower users with interactive Power BI experiences. Learn visual personalization, Field Parameters, and Disconnected Tables to create truly user-driven reports with customizable data and refined interactivity.

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

Dealing with Very Large Tables in SQL Server

Explore challenges and solutions for managing terabyte-sized tables in SQL Server, including indexing, statistics, updates, and query optimization techniques.

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

End-to-End Data Validation Strategies in Microsoft Fabric

Explore strategic data validation in Microsoft Fabric's medallion architecture, enhancing end-user satisfaction through comprehensive WHY, WHEN, and HOW insights.

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

The Critical Role of Creativity in Technical Professions

Discover practical tools to enhance creativity in technical roles, fostering innovation and driving progress by combining creative thinking with technical expertise.

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

Extendable by Design - Building Generative AI Apps with PostgreSQL, Vector Storage, and Azure AI

Harness PostgreSQL's extensibility to build AI-enabled apps using pgvector and Azure OpenAI. Gain hands-on experience through live demonstrations and practical insights.

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

Data Linkage Options: MDM vs Splink in PySpark

Explore data linkage solutions, comparing MDM and Splink (PySpark) for effective data integration and management.

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

Models in Flight: Elevating Semantic Modelling with Spaceparts Co and Tabular Editor 3

Elevate semantic modelling skills with Tabular Editor 3's latest updates, integrations, and enhanced data analysis tools. Explore Tabular Editor Learn for comprehensive training.

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