Signed Edition Sweepstakes
 
 

Recently Viewed clear list


Original Essays | September 15, 2014

Lois Leveen: IMG Forsooth Me Not: Shakespeare, Juliet, Her Nurse, and a Novel



There's this writer, William Shakespeare. Perhaps you've heard of him. He wrote this play, Romeo and Juliet. Maybe you've heard of it as well. It's... Continue »

spacer
Qualifying orders ship free.
$3.98
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Local Warehouse Database- SQL

More copies of this ISBN

Microsoft SQL Server 2000 Bible With Cdrom

by

Microsoft SQL Server 2000 Bible With Cdrom Cover

 

Synopses & Reviews

Publisher Comments:

"Something for everyone . . . this book includes examples to demonstrate concepts along with little-known technical information about SQL Server."

-Melinda S. King, President of Best Technology Solutions, Inc.

* Master the bestselling client/server database platform

* Build high-performance, enterprise-class databases

* Analyze data with advanced SQL techniques

If Microsoft SQL Server 2000 can do it, you can do it too . . .

Here's everything you need to harness the power of SQL Server 2000, Microsoft's high-performance, Web-enabled client/server database and data analysis package. With a focus on performance and data integrity, database expert Paul Nielsen shows you how to design performance into your database from day one. From basic installation to working with XML, monitoring, and performance tuning - a topic so hot, it merits an entire section - Nielsen provides clear instructions, sound theory, and a special "Best Practice" icon that points to the most effective way to accomplish a given task. It's more than a guidebook; it's your total SQL Server 2000 toolkit.

Inside, you'll find complete coverage of SQL Server development

* Design database schemas for performance, adapt integrity, and agility

* Understand ACID and Transactional Integrity and build rock-solid databases

* Use relational algebra to write powerful queries

* Tune indexes as the bridge between data and query

* Analyze Query Execution plans for performance

* Create T-SQL stored procedures, triggers, and user-defined functions

* Share data using DTS, distributed queries, XML, and ADO.NET

* Analyze data with Analysis Services

* Add advanced scalability, availability, performance, and portability to your database

Bonus CD-ROM!

* Sample database applications and code examples from the book

* SQL Server utilities

* Links to Web sites, including the author's SQL Server Web site, www.IsNotNull.com

Synopsis:

Topics covered in this volume include: installing and configuring SQL Server; using SQL server's development tools; securing databases; retrieving data; SQL Server transactions; working with XML; understanding transact SQL language extensions; and developing stored procedures.

Synopsis:

The CD-ROM contains the sample database applications and code examples in the book; SQL Server utilities; and links to Web sites, including the author's own SQL Server Web site (www.IsNotNull.com).

Synopsis:

Includes bibliographical references (p. [835]-836) and index.

About the Author

Paul Nielsen (Hickory, North Carolina) has been a programmer, computer trainer, and consultant, focusing exclusively on database development. Currently, he is a SQL Server trainer at Learning Tree International and publishes "www.IsNotNull.com,"a free, weekly newsletter for SQL Server developers. Paul co-authored Inside the Norton Antivirus (Brady, 1993) with Peter Norton. He also served as the Technical Editor for "Access Advisor" Magazine and has written over 110 computer-related articles.

Table of Contents

Preface.

Acknowledgments.

Part I: Laying the Foundation.

Chapter 1: Introducing SQL Server.

Chapter 2: Modeling the Logical Database Schema.

Chapter 3: Installing and Configuring SQL Server.

Chapter 4: Using SQL Servers Developer Tools.

Part II: Developing SQL Server Databases.

Chapter 5: Implementing the Physical Database Schema.

Chapter 6: Retrieving Data with Select.

Chapter 7: Merging Data Using Relational Algebra.

Chapter 8: Searching Full-Text Indexes.

Chapter 9: Creating Views.

Chapter 10: Modifying Data.

Chapter 11: Transactional Integrity.

Chapter 12: Programming with Transact-SQL.

Chapter 13: Developing Stored Procedures.

Chapter 14: Building User-Defined Functions.

Chapter 15: Implementing Triggers.

Chapter 16: Advanced Server-Side Programming.

Part III: Data Connectivity.

Chapter 17: Transferring Databases.

Chapter 18: Working with Distributed Queries.

Chapter 19: Migrating Data with DTS.

Chapter 20: Replicating Databases.

Chapter 21: ADO and ADO.NET.

Chapter 22: XML and Web Publishing.

Part IV: Administering SQL Server.

Chapter 23: Configuring SQL Server.

Chapter 24: Maintaining the Database.

Chapter 25: Automating Database Maintenance with SQL Server Agent.

Chapter 26: Recovery Planning.

Chapter 27: Securing Databases.

Part V: Advanced Issues.

Chapter 28: Advanced Performance.

Chapter 29: Advanced Availability.

Chapter 30: Advanced Scalability.

Chapter 31: Analysis Services.

Chapter 32: Advanced Portability.

Appendix A: Resources.

Appendix B: Sample Databases.

Appendix C: SQL Server 2000 Specifications.

Appendix D: Whats on the CD?

Index.

End-User License Agreement.

Product Details

ISBN:
9780764549359
Author:
Nielsen, Paul
Publisher:
Wiley
Location:
New York, NY
Subject:
Database Management - General
Subject:
Database management
Subject:
Client-server computing
Subject:
Relational databases
Subject:
Database Management - SQL Server
Subject:
Sql server
Subject:
Client-Server Computing - General
Subject:
Server Computing
Subject:
Client/Server Technologies
Copyright:
Edition Description:
CD-ROM + On-line
Series:
Bible
Series Volume:
49
Publication Date:
20020901
Binding:
Electronic book text in proprietary or open standard format
Language:
English
Illustrations:
Yes
Pages:
936
Dimensions:
24 cm. +

Other books you might like

  1. Windows Server 2003 Network... New Trade Paper $49.95
  2. Securing Windows Server 2003 New Trade Paper $39.95

Related Subjects

Computers and Internet » Database » Client Server
Computers and Internet » Database » SQL

Microsoft SQL Server 2000 Bible With Cdrom Used Trade Paper
0 stars - 0 reviews
$3.98 In Stock
Product details 936 pages John Wiley & Sons - English 9780764549359 Reviews:
"Synopsis" by , Topics covered in this volume include: installing and configuring SQL Server; using SQL server's development tools; securing databases; retrieving data; SQL Server transactions; working with XML; understanding transact SQL language extensions; and developing stored procedures.
"Synopsis" by , The CD-ROM contains the sample database applications and code examples in the book; SQL Server utilities; and links to Web sites, including the author's own SQL Server Web site (www.IsNotNull.com).
"Synopsis" by , Includes bibliographical references (p. [835]-836) and index.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.