Start speaking a new language. It’s just 3 weeks away.
Become an AI & ML Engineer with Cal Poly EPaCE — IBM-Certified Training
Overview
Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
Explore the top 10 mistakes that plague transactional databases in this 17-minute conference talk from SQLBits. Learn how these errors impact security, maintenance, and optimization while discovering easy-to-implement solutions. Join speakers Aaron Felton and Rae Ellingham as they humorously dissect common pitfalls and provide valuable insights. Delve into topics such as normalization, identity, hard deletes, columns, constraints, triggers, hierarchy IDs, indexes, curses, and dynamic SQL. Gain practical knowledge to enhance database management skills and avoid costly errors in transactional database design and implementation.
Syllabus
Introduction
What are transactional databases
Normalisation
Identity
Hard delete
Columns
constraints
triggers
hierarchy IDs
indexes
curses
Dynamic SQL
Summary
Taught by
SQLBits