Troubleshooting SQL

Häftad, Engelska, 2001

629 kr

Beställningsvara. Skickas inom 5-8 vardagar

Fri frakt för medlemmar vid köp för minst 249 kr.

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

Utgivningsdatum2001-09-01
Mått190 x 235 x 20 mm
Vikt660 g
FormatHäftad
SpråkEngelska
SerieApplication Development S.
Antal sidor400
FörlagMcGraw-Hill Education - Europe
MedarbetareHoulette,Forrest
ISBN9780072134896

Tillhör följande kategorier

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