Assuming neither database nor programming background, Beginning SQL Server 2005 Express for Developers introduces all the fundamental database administration and SQL programming features of SQL Server 2005 Express Edition, the free relational database management system from Microsoft that provides a major subset of full SQL Server 2005 functionality.
This book is a comprehensive guide that covers installing and configuring SQL Server 2005 Express; creating, backing up, and restoring databases; creating tables, then querying and manipulating them with T-SQL; coding stored procedures and triggers, and using Reporting Services to deliver information to end users. Detailed, clear, and highly readable, this book will make you a competent and confident database administrator and programmer.
This is the clearest and most comprehensive introduction to SQL Server 2005 Express.
The book assumes no prior experience with databases, SQL, or programming.
Youll learn about both database administration and T-SQL programming.
The book covers SQL Server Management Studio and Reporting Services.
Customer Reviews
Average Rating:
Rating: - A good way to learn the inner workings of SQL Server
I have been querying SQL Server databases for six years using .Net. This book took me inside SQL Server and showed me how to manage tables, relations, stored proceedures, indexes and triggers.
The book achieves great mix of instruction and best practices. At times, I found myself wanting to know more but the book is already over 400 pages.
Rating: - A very good way to learn SQL Server 2005 Express
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 ... Read More
