Troubleshooting SQL
Published on 1. September 2001
Book
Paperback/Softback
384 pages
978-0-07-213489-6 (ISBN)
Description
This programmer's resource explains how to optimize SQL statements and procedures and create a customized SQL debugging environment for error-free applications. You'll get programming tips, best practices, plus coverage of Oracle SQL and PL/SQL and T-SQL for SQL Server.
More details
Series
Language
English
Place of publication
New York
United States
Publishing group
McGraw-Hill Education - Europe
Target group
Professional and scholarly
Product notice
Paperback (trade)
Illustrations
1
Dimensions
Height: 234 mm
Width: 188 mm
Thickness: 27 mm
Weight
780 gr
ISBN-13
978-0-07-213489-6 (9780072134896)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Person
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.
Content
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