Joe Celko's SQL for Smarties

More about the book

Joe Celko's SQL for Smarties: Advanced SQL Programming provides advanced programming tips and techniques across 39 chapters. It begins with a comparison of databases and file systems, then delves into transactions, currency control, schema-level objects, and the organization of data through base and auxiliary tables. The book explores procedural, semi-procedural, and declarative programming styles, as well as various normal forms in database normalization, including first through fifth normal forms, elementary key, domain-key, and Boyce-Codd normal forms, along with practical guidance for normalization and denormalization. It covers different data types—numeric, temporal, and character—alongside predicates and both simple and advanced SELECT statements. Virtual tables, data partitioning in queries, grouping operations, simple aggregate functions, and descriptive statistics, matrices, and graphs in SQL are also discussed. The concluding chapters focus on SQL optimization, making this resource invaluable for SQL programmers. Key features include expert advice from a recognized SQL authority and columnist, teaching numerous advanced techniques applicable in any SQL environment, whether SQL 92 or SQL 2008, while providing insights into overcoming real-world challenges and deficiencies.