SQL in a Nutshell: A Desktop Quick Reference

✍ Scribed by Kevin Kline

• Publisher: O'Reilly Media
• Year: 2000
• Tongue: English
• Leaves: 231
• Edition: 1
• Category: Library

✦ Synopsis

I'm not a DBA, and I don't pretend to be one. I'm a C++ programmer and the only time I care about SQL is when I'm trying to coerce some database to give up the information I need. As I don't develop on an internet connected machine, I'm constantly running to the Google Gods to answer my SQL questions. But no more! This book keeps me in front of my dev machine where I belong. It has just the right level of detail. I find it very akin to a man page level of detail, which is perfect for my needs. It also presents SQL statements for various implementations; the MySQL and Postgres inclusion is key! Overall, it makes an excellent reference. I don't think you'd be able to learn the language or discover advanced techniques from it though.

✦ Table of Contents

oreilly.com......Page 0
Safari | SQL in a Nutshell......Page 1
Safari | SQL in a Nutshell......Page 2
Safari | SQL in a Nutshell......Page 3
Safari | SQL in a Nutshell -> Preface......Page 4
Safari | SQL in a Nutshell -> How This Book Is Organized......Page 5
Safari | SQL in a Nutshell -> Conventions Used in This Book......Page 6
Safari | SQL in a Nutshell -> How to Contact Us......Page 7
Safari | SQL in a Nutshell -> Resources......Page 8
Safari | SQL in a Nutshell -> Acknowledgments......Page 9
Safari | SQL in a Nutshell -> 1. SQL, Vendor Implementations, and Some History......Page 10
Safari | SQL in a Nutshell -> 1.1 The Relational Database Model......Page 11
Safari | SQL in a Nutshell -> 1.2 The Databases Described in This Book......Page 12
Safari | SQL in a Nutshell -> 1.3 The SQL Standard......Page 14
Safari | SQL in a Nutshell -> 1.4 Dialects of SQL......Page 19
Safari | SQL in a Nutshell -> 1.5 Principles of Relational Databases......Page 21
Safari | SQL in a Nutshell -> 2. Foundational Concepts......Page 23
Safari | SQL in a Nutshell -> 2.1 Row Processing Versus Set Processing......Page 24
Safari | SQL in a Nutshell -> 2.2 The Relational Model......Page 25
Safari | SQL in a Nutshell -> 2.3 SQL99 and Vendor-Specific Datatypes......Page 28
Safari | SQL in a Nutshell -> 2.4 Processing NULLS......Page 35
Safari | SQL in a Nutshell -> 2.5 Categories of Syntax......Page 36
Safari | SQL in a Nutshell -> 2.6 Using SQL......Page 42
Safari | SQL in a Nutshell -> 2.7 Conclusion......Page 46
Safari | SQL in a Nutshell -> 3. SQL Statements Command Reference......Page 47
Safari | SQL in a Nutshell -> 3.1 Recommended Reading Approach......Page 48
Safari | SQL in a Nutshell -> 3.2 Quick SQL Command Reference......Page 49
Safari | SQL in a Nutshell -> 3.3 DROP Statements......Page 106
Safari | SQL in a Nutshell -> 3.4 Conclusion......Page 182
Safari | SQL in a Nutshell -> 4. SQL Functions......Page 183
Safari | SQL in a Nutshell -> 4.1 Deterministic and Nondeterministic Functions......Page 184
Safari | SQL in a Nutshell -> 4.2 Types of Functions......Page 185
Safari | SQL in a Nutshell -> 4.3 Vendor Extensions......Page 198
Safari | SQL in a Nutshell -> 5. Unimplemented SQL99 Commands......Page 221
Safari | SQL in a Nutshell -> A. SQL99 and Vendor-Specific Keywords......Page 224
Safari | SQL in a Nutshell -> Colophon......Page 231