Microsoft SQL Server Database Development from Scratch is a road map to database management, implementation, and administration. Author Rob Hawthorne teaches readers how to create, maintain, and increase performance within the application. Concepts and techniques are reinforced as readers create a spy tracker database.
Book Description
Special Offers and Product Promotions
- Pre-order Price Guarantee! Order now and if the Amazon.com price decreases between your order time and the end of the day of the release date, you'll receive the lowest price. Here's how (restrictions apply)
Editorial Reviews
Amazon.com 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!!
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
18 of 18 people found the following review helpful:
4.0 out of 5 stars
No-nonsense SQL Server 2000 Database development essentials,
By Dr. Stan Shear (Cape Town, Cape South Africa) - See all my reviews
This review is from: Microsoft SQL Server 2000 Database Development From Scratch (Paperback)
As a university lecturer, I found this book the ideal text for students with limited time, who needed to rapidly master the essentials of SQL Server database development. The majority of text on the subject is very detailed, very technical, albeit very authoritative, however one has to wade through a mass of concepts before gaining a practical proficiency in the subject. Rob Hawthorne approaches his subject through the development of a single project - the Spynet application which deals with the allocation of secret agents to spying activities. A strange topic to introduce one to SQL Server 2000? Maybe. But you have to read the book and be introduced to the author's wry sense of humour to understand the merits of his approach, which is based on sound technical information presented in an inimitable style which wants you to read more. By the end of the book you WILL understand and be reasonably proficient in SQL Server 2000. What I particularly liked about the book is its analytical efficiency. The author does not simply present code and give a general description of the functions and operations. He analyses each line of code and explains in simple terms exactly what it does. I also like his approach to the data administration aspects, which most students would shy away from. However, as the author presents these aspects, one realizes that the information is actually necessary to be able to work proficiently in SQL Server, and it is not necessary to be a database administrator in order to have sufficient technical knowledge to manage your applications well. The book has a strong section on trouble-shooting and debugging applications and informative information on internet based applications using Active Server Pages and the client server environment.Altogether, a highly recommended book if you want to get into Microsoft SQL Server quickly, without being bogged down by all the technicalities.
4 of 4 people found the following review helpful:
5.0 out of 5 stars
Learn SQL Server 2K the fun way,
By somebody (Malaysia) - See all my reviews
This review is from: Microsoft SQL Server 2000 Database Development From Scratch (Paperback)
The author really knows how to make the book fun to read. It spares you from the boring, technical parts and concentrates on the more, interesting and useful applications of SQL Server 2K, though it does feel like a book for kids after a while. The author shows his sense of humour along the way, making you laugh every now and then, which is good! :)The book goes through most, but not all the functionalities of SQL Server and brings you through building a SpyNet database. It even has a chapter on building the frontend with ASP, though it doesn't teach you any ASP and assumes that you either know ASP already or can make sense out of the comments he wrote together with the ASP scripts. The book touches only the surface of SQL Server concepts and thus is great for beginners wanting to start doing something with SQL Server, but not so appropriate for professionals. Highly recommended for beginners.
2 of 2 people found the following review helpful:
5.0 out of 5 stars
DB Ops: Spy vs Spy,
By ARLAN W. DEAN "dean-communications.com" (BROOKLYN, NY United States) - See all my reviews (REAL NAME)
This review is from: Microsoft SQL Server 2000 Database Development From Scratch (Paperback)
Mr Hawthorne is well-versed not just in MS SQL Server, but its' main competitor as well. In another publication he describes Oracle's beginnings as a contractor for the CIA. Consequently it comes as no surprise that his excellent beginners' hands-on introduction to MS SQL Server uses a fictional spy vs spy theme.For SQL Server newbies such as myself, reading, learning and building the book's spy database project is a blast! Who said "Edutainment" is kidstuff? |
|
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
