Get full access to Joe Celko's SQL for Smarties, 4th Edition and 60K+ other titles, with free 10-day trial of O'Reilly.
There's also live online events, interactive content, certification prep materials, and more.
About the Author
Introduction to the Fourth Edition
What Changed in Ten Years
New in This Edition
Corrections and Additions
1. Databases versus File Systems
1.1 Tables as Entities
1.2 Tables as Relationships
1.3 Rows versus Records
1.4 Columns versus Fields
1.5 Schema Objects
1.6 CREATE SCHEMA Statement
2. Transactions and Concurrency Control
2.2 Transactions and ACID
2.3 Concurrency Control
2.4 Pessimistic Concurrency Control
2.5 SNAPSHOT Isolation and Optimistic Concurrency
2.6 Logical Concurrency Control
2.7 Deadlock and Livelocks
3. Schema Level Objects
3.1 CREATE SCHEMA Statement
3.2 CREATE PROCEDURE, CREATE FUNCTION, and CREATE TRIGGER
3.3 CREATE DOMAIN Statement ...
Get Joe Celko's SQL for Smarties, 4th Edition now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.
Get Mark Richards’s Software Architecture Patterns ebook to better understand how to design components—and how they should interact.