Главная
Study mode:
on
1
Introduction
2
What are transactional databases
3
Normalisation
4
Identity
5
Hard delete
6
Columns
7
constraints
8
triggers
9
hierarchy IDs
10
indexes
11
curses
12
Dynamic SQL
13
Summary
Description:
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.

Top 10 Transactional Database Mistakes and How to Avoid Them

SQLBits
Add to list
0:00 / 0:00