Beginning SQL Server 2005 Express for Developers: From Novice to...

Features

• Cover Type: Paperback with 464 pages
• Published by: Apress February 19, 2007
• Written in: English
• ISBN 10 Number: 1590597206
• ISBN 13 Number: 978-1590597200
• Book Dimensions: 9.1 x 7 x 1.1 inches
• Weighs: 1.4 pounds

Reader Reviews
This is an excellent book for learning SQL Server 2005 Express. I started learning MS Access in 2003 when my wife asked me to develop a database for her to use at work. At the time I knew only the words "relational database". Over 99% of what I needed to know to develop that contact and resource management database to its fully featured capability came from multiple books. The expectations have changed over time and now I need to use SQL Server 2005 Express as a back end with Access as the front end for that database. Knowing nothing about SQL Server 2005, I needed a very good book to help bring me up to speed. I found that in Robin Dewson's "Beginning SQL Server 2005 Express." From the installation of SQL Server 2005 Express through an explanation of Triggers and Reporting Services, there is a clear and concise explanation of each aspect with the opportunity to Try It Out. I needed to know all of what he presents and I was especially interested in Installation, Security, and Database Backup, Recovery, and Maintenance. The Installation chapter explains very carefully and clearly authentication mode, service accounts, user instances, etc. The Security chapter clearly explains logins, server roles, database roles, and schemas. The Database Backup, Recovery, and Maintenance chapter is also clear and carefully written with information on types of backups, detaching and attaching a database, and transaction logs. The Chapter headings are: 1. SQL Server 2005 Express Overview and Installation 2. SQL Server Management Studio Express 3. Database Design and Creation 4. Security 5. Defining Tables 6. Creating Indexes and Database Diagramming 7. Database Backup, Recovery, and Maintenance 8. Working with the Data 9. Building a View 10. Stored Procedures 11. T-SQL Essentials 12. Advanced T-SQL 13. Triggers 14. Reporting Services Robin Dewson is a very good teacher with the gift of knowing how to present a concept and then build concept on concept. He also provides helpful tips on things to do and not to do. Comment (1) | | (Report this)