Special Edition Using Microsoft SQL Server 6.5
by Wynkoop, StephenEdition: 2nd
Format: Paperback
Pub. Date: 1997-04-01
Publisher(s): Que Pub
Other versions by this Author
-
This Item Qualifies for Free Shipping!*
*Excludes marketplace orders.
List Price: $62.99
Rent Book
Select for Price
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
As the SQL Server user base continues to escalate and the need for adequate documentation on this database grows, there is a strong demand for this title. Using real-world examples and a hands-on approach, this reference explores administering, developing, and supporting a SQL Server application-from the design stage to the final product.
Table of Contents
| Introduction | p. 1 |
| Introducing Microsoft SQL Server | p. 11 |
| Understanding the Underlying Operating System, Windows NT | p. 33 |
| Installing and Setting Up the Server and Client Software | p. 59 |
| Data Modeling, Database Design, and the Client/Server Model | p. 73 |
| Creating Devices, Databases, and Transaction Logs | p. 91 |
| Creating Database Tables and Using Datatypes | p. 131 |
| Retrieving Data with Transact-SQL | p. 175 |
| Adding, Changing, and Deleting Information in Tables | p. 225 |
| Using Functions | p. 261 |
| Managing and Using Views | p. 291 |
| Managing and Using Indexes and Keys | p. 325 |
| Understanding Transactions and Locking | p. 355 |
| Managing and Using Rules, Constraints, and Defaults | p. 379 |
| Managing Stored Procedures and Using Flow-Control Statements | p. 403 |
| Creating and Managing Triggers | p. 447 |
| Understanding Server, Database, and Design Query Options | p. 463 |
| Setting Up and Managing Replication | p. 501 |
| Using the Distributed Transaction Coordinator | p. 533 |
| SQL Server Administration | p. 547 |
| SQL Server Security | p. 575 |
| Optimizing Performance | p. 593 |
| Developing Applications to Work with SQL Server | p. 613 |
| Understanding SQL Server and the Internet | p. 629 |
| Creating and Using Cursors | p. 677 |
| Accessing SQL Server Databases Through Front-End Products | p. 693 |
| Upsizing Microsoft Office 97 Applications to SQL Server | p. 709 |
| Mail-Enabling Your SQL Server | p. 729 |
| Understanding RAID | p. 731 |
| Understanding the SQL System Tables | p. 735 |
| Understanding SQL Trace | p. 741 |
| How to Become a Reality Check Site | p. 745 |
| Case Study: New York Metropolitan Museum of Art | p. 747 |
| Data Access Objects 3.5 API | p. 755 |
| What's On the CD? | p. 829 |
| Index | p. 833 |
| Table of Contents provided by Blackwell. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.