YoVDO

Top 10 Transactional Database Mistakes and How to Avoid Them

Offered By: SQLBits via YouTube

Tags

Database Design Courses Data Integrity Courses Normalization Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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

Related Courses

Statistics for Genomic Data Science
Johns Hopkins University via Coursera
Fundamentals of database systems
Indian Institute of Technology Kanpur via Swayam
Database Systems Concepts and Design
Georgia Institute of Technology via edX
Introduction to Data Modeling
Microsoft via edX
Введение в базы данных
St. Petersburg State Polytechnic University via Stepik