Bad Designs Have Consequences

Offered By: PASS Data Community Summit via YouTube

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Explore real-world examples of unusual and problematic database designs in this 52-minute conference talk from the PASS Data Community Summit. Discover the consequences of poor design choices through a series of anonymized case studies drawn from 15 years of SQL experience. Learn about entity value attributes, lookup table issues, string handling problems, many-to-many relationship challenges, bit filtering pitfalls, and data type misuse. Gain valuable insights into common design mistakes and their impact on database performance and functionality.

Syllabus

Intro
Introduction
Entity Value Attributes
Lookup Tables
No Lookup Tables
No Strings
Many to Many
Bit Filtering
Data Types

Taught by

PASS Data Community Summit

Related Courses

Doing More with Less - The Challenges Ahead for Every Data Professional
PASS Data Community Summit via YouTube Build a Modern Data Strategy and Put Your Data to Work
PASS Data Community Summit via YouTube Transform Your Data Estate
PASS Data Community Summit via YouTube Azure SQL and SQL Server 2022 - Intelligent Database Futures
PASS Data Community Summit via YouTube SQL Server in Azure Virtual Machines Reimagined
PASS Data Community Summit via YouTube