Items related to Microsoft SQL Server 2000 Database Development From...
Synopsis
Designed for those who have some programming and database experience (though it claims this is not necessary), this book uses extensive screen shots, illustrations and tables to show how to create, manage, administer and maintain a database from scratch. It also provides knowledge necessary for building a foundation on which to further develop skills in the application. The included CD-ROM contains Microsoft's SQL Server 2000 120-Day Enterprise Evaluation Version. Annotation c. Book News, Inc., Portland, OR (booknews.com)
"synopsis" may belong to another edition of this title.
Review
Lots of tutorial books use examples, and some build on them in successive chapters as new concepts are introduced. Rob Hawthorne takes that approach to great effect in Microsoft SQL Server 2000 Database Development from Scratch. He documents all the SQL Server 2000 features an administrator would need to know about, and does a pretty complete job of describing features that are of primary interest to database and database-application designers.
The book walks you through the development of an application that uses lots of the features SQL Server 2000 supports. The example application, SpyNet, employs a reasonably complex suite of interrelated tables, some stored procedures and triggers for them, and both Windows and Web-based user interfaces. SpyNet also draws on SQL Server 2000's security features (users and privileges), and the database application is used as a platform for demonstrating how to perform various routine and special-purpose administrative procedures. It's an effective approach, well-suited to readers who haven't built SQL Server solutions before. The book deals with design issues more fully than most environment-centric books, but you might want to supplement it with Database Design if you anticipate setting up a complicated arrangement of tables. That book is platform-independent. --David Wall
Topics covered:
- Introduction to Microsoft SQL Server 2000
- Schema design
- Data normalization
- Queries in Transact-SQL
- Data Definition Language (DDL)
- Data Transformation Services (DTS)
- Security, backup, and disaster recovery
From the Author
This book has been specifically written to get you up and running in SQL Server 2000 quickly. However there are no shortcuts! Right from the start we get into development of our very own Spy tracking database. By the time you have finished the book, you will not only know how to build and maintain our database, but you will have also created an ASP based front-end! One of the great things about this title is you do not need any extra software to complete the tasks, as it comes with it's very own trial version of SQL Server 2000. Thanks Microsoft! Enjoy your reading!!
"About this title" may belong to another edition of this title.
- PublisherQue Pub
- Publication date2001
- ISBN 10 0789724472
- ISBN 13 9780789724472
- BindingPaperback
- LanguageEnglish
- Number of pages496
(No Available Copies)
Search Books: Create a WantCan't find the book you're looking for? We'll keep searching for you. If one of our booksellers adds it to AbeBooks, we'll let you know!
Create a Want