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.
Reihe
Sprache
Verlagsort
Verlagsgruppe
McGraw-Hill Education - Europe
Zielgruppe
Produkt-Hinweis
Illustrationen
Maße
Höhe: 234 mm
Breite: 188 mm
Dicke: 27 mm
Gewicht
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 Klassifikation
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
