Troubleshooting SQL

Forrest Houlette is a computer writer and consultant and president of Write Environment, Inc., a consulting firm that specializes in Visual Basic software development, custom documentation, training, and software for both education and business. Forrest focuses on writing about computers and creating custom software. He is a former Learning Tree International instructor, for whom he taught courses Windows 95, Windows NT, Office 97, and Visual. He has authored or co-authored books for IDG, New Riders Publishing, Que, and Sybex. He is also a Microsoft Certified Product Specialist.

• Part I: Laying the Groundwork 1 Choosing a Troubleshooting Environment 2 Using Best Practices 3 Preparing Your Troubleshooting Environment Part II: Analyzing Problems 4 Creating Databases 5 Normalizing Tables 6 Using Data Types 7 Selecting Data 8 Inserting Data 9 Updating Data 10 Deleting Data 11 Grouping and Aggregating Data 12 Using Joins 13 Using Subqueries 14 Using Views Part III: Solving Complex Problems 15 Triggers, Stored Procedures, and Parameters 16 Transactions 17 Using Cursors and Exceptions 18 Trees