Troubleshooting SQL

Häftad, Engelska, 2001

486 kr

Beställningsvara. Skickas inom 5-8 vardagar. Fri frakt över 249 kr.

Beskrivning

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.

Produktinformation

Utgivningsdatum:2001-09-01
Mått:190 x 235 x 20 mm
Vikt:660 g
Format:Häftad
Språk:Engelska
Serie:Application Development S.
Antal sidor:400
Förlag:McGraw-Hill Education - Europe
Medarbetare:Forrest Houlette
ISBN:9780072134896

Utforska kategorier

Databaser inom Data och IT
Programmeringsböcker inom Data och IT

Mer om författaren

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.

Innehållsförteckning

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