did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9780072134896

Troubleshooting SQL

by
  • ISBN13:

    9780072134896

  • ISBN10:

    0072134895

  • Format: Paperback
  • Copyright: 2001-09-01
  • Publisher: Lightning Source Inc
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
  • Write a Review Icon Write a Review
List Price: $39.99 Save up to $0.77
  • Buy New
    $39.22
    Add to Cart Free Shipping Icon Free Shipping

    USUALLY SHIPS IN 2-3 BUSINESS DAYS

Supplemental Materials

What is included with this book?

Summary

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.

Table of Contents

Part I Laying the Groundwork
Choosing a Troubleshooting Environment
3(18)
Using Best Practices
21(28)
Preparing Your Troubleshooting Environment
49(12)
Part II Analyzing Problems
Creating Databases
61(38)
Normalizing Tables
99(18)
Using Data Types
117(16)
Selecting Data
133(16)
Inserting Data
149(20)
Updating Data
169(22)
Deleting Data
191(12)
Grouping and Aggregating Data
203(14)
Using Joins
217(16)
Using Subqueries
233(16)
Using Views
249(20)
Part III Solving Complex Problems
Triggers, Stored Procedures, and Parameters
269(22)
Transactions
291(14)
Using Cursors and Exceptions
305(20)
Trees
325(14)
Index 339

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program