Microsoft SQL Server 2000 Programming by Example

Overview

SQL Server 2000 Programming by Example provides clear and concise examples of basic programming techniques used in SQL Server 2000 primarily using Transact-SQL. Even if you're a complete novice to SQL Server 2000 programming, you will benefit by reading through the book's logical process. SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. If you are already familiar with SQL Server 2000 programming, you ...

See more details below
Multimedia Set (BK&CD-ROM)
$53.99
BN.com price
(Save 10%)$59.99 List Price
Other sellers (Multimedia Set)
  • All (18) from $1.99   
  • New (5) from $32.97   
  • Used (13) from $1.99   
Sending request ...

Overview

SQL Server 2000 Programming by Example provides clear and concise examples of basic programming techniques used in SQL Server 2000 primarily using Transact-SQL. Even if you're a complete novice to SQL Server 2000 programming, you will benefit by reading through the book's logical process. SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. If you are already familiar with SQL Server 2000 programming, you may use the book as a quick reference guide that provides plenty of pertinent examples.

Read More Show Less

Product Details

  • ISBN-13: 9780789724496
  • Publisher: Que
  • Publication date: 4/16/2001
  • Series: By Example Series
  • Edition description: BK&CD-ROM
  • Pages: 792
  • Product dimensions: 7.20 (w) x 9.10 (h) x 1.60 (d)

Meet the Author

Carlos E. Rojas is the Database Administrator at Planeta Networks, in Miami, Florida. Prior to this DBA role, he was a consultant and trainer with Manapro in Caracas, Venezuela. He has participated as a speaker in various technet conferences in Venezuela.

Carlos has experience in developing Internet (n-tier) applications using Microsoft technologies, and implementing and administering SQL Server databases.

He is a Most Valuable Professional (MVP), Microsoft Certified Systems Engineer + Internet (MCSE+I), Microsoft Certified Database Administrator (MCDBA), and Microsoft Certified Sales Specialist (MCSS). He is also a voting member and volunteer of PASS, the professional association for SQL Server.

Fernando G. Guerrero is a Principal Technologist and SQL Server Product Consultant for QA Group Ltd., U.K. His main role involves IT training, course development, and internal mentoring. Fernando writes for SQL Server Magazine.

He has also presented a session on SQL Server 2000 at TechEd 2000 Europe, and has been accepted to speak at PASS, VBUG, Technology Week, VSLive, and SQL2THEMAX conferences during the year 2001.

He holds seven Microsoft Professional Certifications including MCSE+Internet, MCSD, MCDBA, and MCT, and has been awarded with the MVP (Most Valuable Professional) status on SQL Server.

Read More Show Less

Table of Contents

Introduction.

1. Relational Database Management Systems and SQL Server.

Database Models. A Brief History of SQL Server. Basics of SQL Server Architecture. Client/Server Applications Design.

2. Elements of Transact-SQL.

Data Definition Language (DDL). Data Manipulation Language (DML). Data Control Language (DCL). Data Types. Additional Elements. Programming Scripts and Batches.

3. Working with Tables and Views.

Creating and Altering Tables. Creating and Altering Views.

4. Querying and Modifying Data.

Querying Data. Modifying Data.

5. Querying Multiple Tables: JOINs.

ANSI SQL-92 Syntax. INNER JOIN. OUTER JOINs. CROSS JOINs. Self Joins. The UNION Operator.

6. Optimizing Access to Data: Indexes.

Introduction to Indexes. Benefits of Indexes. How to Create Indexes. How SQL Server 2000 Stores Data. How SQL Server 2000 Modifies Data. Index Enhancements in SQL Server 2000. Accessing Data Without Indexes: Table Scan. Types of Indexes. Covered Queries and Index Intersection. Index Maintenance. Indexes on Computed Columns. Indexed Views. Index Tuning Wizard. Summary.

7. Enforcing Data Integrity.

Types of Data Integrity. Enforcing Integrity: Constraints (Declarative Data Integrity).

8. Implementing Business Logic: Programming Stored Procedures.

Benefits of Using Stored Procedures. Types of Stored Procedures. Creating and Dropping Stored Procedures. Using Parameters. Altering Stored Procedure Definitions. The RETURN Statement. Executing Stored Procedures. Stored Procedure Recompilation. Handling Errors. Nesting Stored Procedures. Application Security Using Stored Procedures.

9. Implementing Complex Processing Logic: Programming Triggers.

Benefits of Triggers. Trigger Enhancements in SQL Server 2000. Inserted and Deleted Tables. Types of Triggers According to Their Order. Creating and Dropping Triggers. Altering Trigger Definitions. Disabling Triggers. Nesting Triggers. Recursive Triggers. Security Implications of Using Triggers. Enforcing Business Rules: Choosing Among INSTEAD OF Triggers,. Constraints, and AFTER Triggers.

10. Enhancing Business Logic: User-Defined Functions (UDF)

Benefits of User-Defined Functions. Built-In User-Defined Functions. Types of User-Defined Functions According to Their Return Value. Dropping User-Defined Functions. Preventing the Alteration of Dependent Objects: The SCHEMABINDING Option. Deterministic and Nondeterministic Functions. Altering User-Defined Functions Definition. Security Implications of Using User-Defined Functions. Applying User-Defined Functions.

11. Using Complex Queries and Statements.

Subqueries. Correlated Subqueries. Derived Tables. The CASE Function. The COMPUTE Clause. The CUBE and ROLLUP Operators. Using Hints.

12. Row-Oriented Processing: Using Cursors.

Row-by-Row Versus Set-Oriented Processing. Types of Cursors. Steps to Use Cursors. Scope of Cursors. Using Cursors to Solve Multirow Actions in Triggers. Application Cursors.

13. Maintaining Data Consistency: Transactions and Locks.

Characteristics of Transactions (ACID). Using Transactions. Concurrency Problems. Isolation Levels. Types of Locks. A Serious Problem to Avoid: Deadlocks.

14. Transferring Data to and from SQL Server.

The Need for Transferring Data. Tools for Transferring Data Using SQL Server 2000. The BULK INSERT Statement and bcp. Using Data Transformation Services. The Copy Database Wizard.

15. Working with Heterogeneous Environments: Setting Up Linked Servers.

Distributed Queries. Distributed Transactions.

Appendix A. Using SQL Server Instances.

Installing SQL Server Instances. Connecting to Instances. System Functions Used in Multi-Instance Installations. Current Limitations.

Appendix B. Using SQL Query Analyzer.

Installing SQL Query Analyzer. The Query Analyzer Workplace. Managing User and Connection Options. Defining and Using Templates for Query Analyzer. Analyzing Queries. Working with the Transact-SQL Debugger. Summary.

Index.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)