Discovering SQL -- CONTENTS -- INTRODUCTION -- CHAPTER 1: DROWNING IN DATA, DYING OF THIRST FOR KNOWLEDGE -- Data Deluge and Informational Overload -- Database Management Systems (DBMSs) -- Storage Capacity -- Number of Users -- Security -- Performance -- Scalability -- Costs -- Recording Data -- Oral Records -- Pictures -- Written Records -- Printed Word -- All of the Above -- Analog versus Digital Data -- To Store or Not to Store? -- Relational Database Management Systems -- IBM DB2 LUW -- Oracle -- Microsoft SQL Server -- Microsoft Access -- PostgreSQL -- MySQL -- HSQLDB and OpenOffice BASE -- What Is SQL? -- The SQL Standard -- Dialects of SQL -- Not the Only Game in Town -- Let There Be Database! -- Creating a Table -- Getting the Data In: INSERT Statement -- Give Me the World: SELECT Statement -- Good Riddance: the DELETE Statement -- I Can Fix That: the UPDATE Statement -- Summary -- CHAPTER 2: BREAKING AND ENTERING: STRUCTURED INFORMATION -- A Really Brief Introduction to Data Modeling -- Conceptual Modeling -- Logical Modeling -- Physical Modeling -- Why Can't Everything Be Text? -- Character Data -- Fixed Length and Variable Strings -- Binary Strings -- Character versus Special Files -- Numeric Data -- Exact Numbers -- Approximate Numbers -- Literals for the Number -- Once Upon a Time: Date and Time Data Types -- Binary Data -- It's a Bird, It's a Plane, It's … a NULL! -- Much Ado About Nothing -- None of the Above: More Data Types -- BOOLEAN -- BIT -- XML Data Type -- DDL, DML, and DQL: Components of SQL -- Refactoring Database TABLE -- DROP TABLE -- CREATE TABLE -- ALTER TABLE -- Populating a Table with Different Data Types -- Implicit and Explicit Data Conversion -- SELECT Statement Revisited -- Selecting Literals, Functions, and Calculated Columns -- Setting Vertical Limits -- Alias: What's in a Name? -- Setting Horizontal Limits.

DISTINCT -- Get Organized: Marching Orders -- ORDER BY -- ASC and DESC -- TOP and LIMIT -- INSERT, UPDATE, and DELETE Revisited -- INSERT -- SELECT INTO -- UPDATE -- DELETE -- TRUNCATE That Table! -- SQL Operators: Agents of Change -- Arithmetic and String Concatenation Operators -- Comparison Operators -- Logical Operators -- ALL -- ANY

MAX() -- MIN() -- SUM() -- Eliminating Duplicate Data -- GROUP BY: Where Your Data Belongs -- GROUP BY with HAVING Clause -- ORDER BY Clause: Sorting Query Output -- Summary -- CHAPTER 6: WHEN ONE IS NOT ENOUGH: A QUERY WITHIN A QUERY -- What You Don't Know Might Help You -- Subquery in the WHERE Clause -- EXISTS Operator -- ANY Operator -- ALL Operator -- Subquery in the SELECT List -- Subquery in the FROM Clause -- Subquery in the HAVING Clause -- Subqueries with INSERT -- Subqueries with UPDATE -- Subqueries with DELETE -- Correlated Query -- How Deep the Rabbit Hole Goes: Nesting Subqueries -- A Subquery or a JOIN? -- Summary -- CHAPTER 7: YOU BROKE IT -- YOU FIX IT: COMBINING DATA SETS -- Joins Revisited -- INNER JOIN -- N-way INNER JOIN -- LEFT OUTER JOIN -- RIGHT OUTER JOIN -- FULL JOIN -- Self JOIN: Looking Inside for an Answer -- CROSS JOIN (aka Cartesian Product) -- State of the UNION -- A Point of VIEW -- CREATE VIEW -- ALTER VIEW -- DROP VIEW -- Updatable VIEW -- WITH CHECK OPTION -- Hierarchical Views -- Benefits and Drawbacks -- But Wait -- There's More! -- INTERSECT -- EXCEPT and MINUS -- Summary -- CHAPTER 8: WHAT ELSE IS THERE, AND WHY? -- An INDEX for All Seasons -- UNIQUE Index -- CLUSTERED Index -- An INDEX Destroyed -- TABLE Revisited -- VIEW Revisited -- By Any Other Name: Aliases and Synonyms -- Auto-Incremented Values -- Identity Columns -- Microsoft SQL Server -- IBM DB2 -- PostgreSQL -- MySQL -- Microsoft Access -- OpenOffice BASE with HSQLDB -- Who Am I: Finding One's IDENTITY -- Sequences -- Comparing Identity Columns and Sequences -- Triggers -- One Happy Family: Working in Heterogeneous Environments -- Summary -- CHAPTER 9: OPTIMIZING PERFORMANCE -- Database Performance -- Performance Benchmarks -- Order of Optimization -- Hardware Optimization -- Operating System Tune-up -- Optimizing RDBMSs.

Optimizing Database/Schema -- Application Optimization -- SQL Optimization -- RDBMS-Specific Optimization -- Oracle 10/11g -- IBM DB2 LUW 9.7 -- Microsoft SQL Server 2008 -- PostgreSQL -- MySQL -- Desktop RDBMSs -- Microsoft Access -- OpenOffice BASE with HSQLDB Backend -- Your DBA Is Your Friend -- Summary -- CHAPTER 10: MULTIUSER ENVIRONMENT -- Sessions -- Orphaned Sessions -- Transactions -- Understanding Locks -- SQL Security -- Basic Security Mechanisms -- Defining a Database User -- Managing Security with Privileges -- Operating System Security Integration -- INFORMATION_SCHEMA and SQL System Catalogs -- Oracle Data Dictionary -- IBM DB2 LUW System Catalogs -- Microsoft SQL Server 2008 System Catalog -- Summary -- CHAPTER 11: WORKING WITH UNSTRUCTURED AND SEMISTRUCTURED DATA -- SQL and XML -- A Brief Introduction to XML -- Formatted XML -- DTD and Schema -- Document Type Definition (DTD) -- XML Schema Definition (XSD) -- Namespaces -- XML as a DataSource -- Accessing XML Documents in an Application -- XML Path Language: XPath -- XML Query Language: XQuery -- Encoding XML -- Presenting XML Documents -- XSL and XSLT -- XML and RDBMSs -- Implementation Details -- Oracle 11g XML DB -- IBM DB 9.7 pureXML -- Microsoft SQL Server -- PostgreSQL 9.0 -- MySQL 5.5 -- XML for RDBMS: Best Practices -- All Bits Considered -- What Would Google Do? -- Getting Binary Data In and Out of the RDBMS Table -- Best Practices for Binary Data -- SQL and Text Documents -- Summary -- CHAPTER 12: NOT BY SQL ALONE -- The Future Is Cloudy -- Key/Value Pair -- What in the World Is Hadoop? -- Google's BigTable, Base, and Fusion Tables -- Amazon SimpleDB -- MongoDB -- Microsoft SQL Azure -- SQL and Business Intelligence -- OLAP Rules -- ROLAP, MOLAP, and HOLAP -- Oracle 11g -- IBM DB2 -- Microsoft SQL Server -- XML for Analysis (XMLA) -- Elementary, My Dear Watson!.

Column-Oriented DBMS -- Object Databases -- Object-Oriented Programming (OOP) Paradigm -- Objects and Classes -- Object-Relational Mapping Frameworks -- Hibernate/NHibernate -- Microsoft LINQ and Entity Framework -- Summary -- APPENDIX A: INSTALLING THE LIBRARY DATABASE -- Oracle 10g XE -- Installing Library Sample Database with SQL*Plus -- Installing with Oracle Web Interface -- IBM DB2 9.7 Express-C -- IBM Command Editor -- IBM Command Window -- Microsoft SQL Server 2008 Express -- SQL Server Management Studio Express -- PostgreSQL 9.0 -- Installing with pgAdmin III -- MySQL 5.1 -- Installing with the MySQL CommandA-Line Utility -- Microsoft Access 2007/2010 -- OpenOffice BASE 3.2 -- APPENDIX B: INSTALLING RDBMSS SOFTWARE -- APPENDIX C: ACCESSING RDBMSS -- Oracle -- IBM DB2 -- Microsoft SQL Server 2008 -- MySQL -- PostgreSQL -- Microsoft Access 2007/2010 -- Open Office BASE with HSQLDB -- APPENDIX D: ACCESSING RDBMSS WITH THE SQUIRREL UNIVERSAL SQL CLIENT -- INDEX.