Laying the Groundwork -- Choosing a Troubleshooting Environment -- Using Best Practices -- Preparing Your Troubleshooting Environment -- Analyzing Problems -- Creating Databases -- Normalizing Tables -- Using Data Types -- Selecting Data -- Inserting Data -- Updating Data -- Deleting Data -- Grouping and Aggregating Data -- Using Joins -- Using Subqueries -- Using Views -- Solving Complex Problem -- Triggers, Stored Procedures, and Parameters -- Transactions -- Using Cursors and Exceptions -- Trees.