Troubleshooting SQL
By: Forrest Houlette
Publisher: Osborne/McGraw-Hill
Published: 2001
Place of publication: Berkeley, Calif
Language: eng
Number of pages: 357
ISBN-13: 9780072134896
Subjects: Relational databases; SQL (Computer program language)
Notes: Includes index.
Table of contents: title: Pt. I.; title: Laying the Groundwork -- -- Ch. 1.; title: Choosing a Troubleshooting Environment -- -- Ch. 2.; title: Using Best Practices -- -- Ch. 3.; title: Preparing Your Troubleshooting Environment -- -- Pt. II.; title: Analyzing Problems -- -- Ch. 4.; title: Creating Databases -- -- Ch. 5.; title: Normalizing Tables -- -- Ch. 6.; title: Using Data Types -- -- Ch. 7.; title: Selecting Data -- -- Ch. 8.; title: Inserting Data -- -- Ch. 9.; title: Updating Data -- -- Ch. 10.; title: Deleting Data -- -- Ch. 11.; title: Grouping and Aggregating Data -- -- Ch. 12.; title: Using Joins -- -- Ch. 13.; title: Using Subqueries -- -- Ch. 14.; title: Using Views -- -- Pt. III.; title: Solving Complex Problem -- -- Ch. 15.; title: Triggers, Stored Procedures, and Parameters -- -- Ch. 16.; title: Transactions -- -- Ch. 17.; title: Using Cursors and Exceptions -- -- Ch. 18.; title: Trees.