Skip to Main Content
SQL All-in-One For Dummies, 4th Edition
book

SQL All-in-One For Dummies, 4th Edition

by Allen G. Taylor, Richard Blum
April 2024
Intermediate to advanced content levelIntermediate to advanced
800 pages
18h 34m
English
For Dummies
Content preview from SQL All-in-One For Dummies, 4th Edition

Chapter 2

Protecting Against User Errors and Conflicts

IN THIS CHAPTER

Bullet Dealing with human errors: More trouble in paradise

Bullet Resolving operational errors

Bullet Taking the ACID test

Bullet Preventing mix-ups with transactions

Bullet Understanding lock types

Bullet Getting locks and the recovery system in tune

Bullet Using timestamps

After you have done everything you can do to minimize the possibility of problems due to hardware faults and Internet threats (which I discuss in Book 4, Chapter 1), you still have to worry about yet other things that can damage the data in your database or degrade performance.

Several additional potential sources of error exist. Here are a few of the most important:

  • The database design could be faulty, leading to modification anomalies or poor performance.
  • The database application written ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL All-In-One For Dummies, 3rd Edition

SQL All-In-One For Dummies, 3rd Edition

Allen G. Taylor
SQL Essentials For Dummies

SQL Essentials For Dummies

Richard Blum, Allen G. Taylor
SQL in a Nutshell, 4th Edition

SQL in a Nutshell, 4th Edition

Kevin Kline, Regina O. Obe, Leo S. Hsu

Publisher Resources

ISBN: 9781394242290Purchase Link