Beginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice) (Paperback)

by Robin Dewson (Author)
Key Phrases: database diagram tool, encrypted views, customer transaction records, Query Editor, Server Management Studio, Cancel Figure (more...)

Editorial Reviews

Product Description
<p>SQL Server 2005 will increase your programming options, productivity, analysis, and database management. If you have some basic knowledge of relational databases and want to start a career as a developer using SQL Server, then this book is your ideal first step. It explains the core jobs and roles for developing a database in both SQL Server 2000 and 2005.</p>

<p>This book features practical steps to help you overcome issues you're likely to encounter. You'll learn to use SQL for querying, inserting, updating, and deleting data. You'll also learn how to back up and restore databases for basic administration in SQL Server. Further, you'll cover how to build a complete database, from the fundamentals of relational database design to table and index creation.</p>

<p>Additionally, you'll start to program in T-SQL, SQL Server's implementation (and extension) of the SQL programming language, and you'll come away with effective programming techniques using stored procedures and triggers. The book also includes a CD that contains an evaluation edition of SQL Server 2005 so you can start building database applications right away.</p>

About the Author
Robin Dewson has been hooked on programming ever since he bought his first computer in 1980, a Sinclair ZX80. His first main application of his own was a Visual FoxPro application that could be used to run a Fantasy League system. It was at this point he met up with a great help in his PC development life, Jon Silver at Step One Technologies, where in return for training, he helped Jon with some other Visual FoxPro applications. From there, realizing that the marketplace for Visual FoxPro was limited, he decided to learn Visual Basic and SQL Server. <p> Starting out with SQL Server 6.5, Robin soon moved to SQL Server 7 and Visual Basic 5, and became involved in developing several applications for clients both in the UK and in the United States. From there, he moved to SQL Server 2000 and Visual Basic 6. Robin currently is consulting at Lehman Brothers in London, where he has been for nearly 5 years, using Visual Basic 6 and Sybase on a trading system called Kojak. Robin is also the author of <i>Beginning SQL Server 2000 Programming</i>.

Product Details

• Paperback: 536 pages
• Publisher: Apress; 1 edition (January 30, 2006)
• Language: English
• ISBN-10: 1590595882
• ISBN-13: 978-1590595886
• Product Dimensions: 9.2 x 7 x 1.2 inches
• Shipping Weight: 1.8 pounds (View shipping rates and policies)
• Average Customer Review: 3.7 out of 5 stars See all reviews (12 customer reviews)
• Amazon.com Sales Rank: #389,909 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #95 in

  Books > Computers & Internet > Databases > Beginning & Introductory

Customer Reviews

Most Helpful Customer Reviews

13 of 13 people found the following review helpful:

4.0 out of 5 stars Quality book & up-to-date, well worth reading, March 8, 2006

By	Mr. Henry Williams "digitalhen" (Jersey City, NJ USA) - See all my reviews (REAL NAME)

I've been looking around for a book that covers the full & released version of SQL Server 2005 and this is the only one I've found so far. All of the other books appear to be based on beta versions. Something to keep in mind.

The author tackles the subject of the book in a detailed yet concise manner and this makes for an interesting read. I would definitely recommend this to people migrating to SQL Server, people new to the system, and people upgrading to the latest version.

As with any book, there are the odd few flaws in the book and some of the code can be hard to understand, but these are only small issues and certainly wouldn't devalue the book in my opinion.

8 of 8 people found the following review helpful:

5.0 out of 5 stars Great introduction to SQL Server 2005!, June 17, 2006

By	David E. Patrick (Jarrettsville, MD) - See all my reviews (REAL NAME)

This book is great for beginners to databases and to SQL Server 2005. It does a great job of introducing not only the main features of SQL Server 2005, but also the main concepts of database development and design.

The book includes information on all of the things a beginner needs to get start creating and using their own databases, including system requirements, installation tips, database design concepts and how to actually implement them using the tools found in SQL Server 2005.

Once a beginner has gotten over the install and set up of a database, this book also has great info on how to use the database. It's got good coverage of all the essentials, T-SQL, stored procedures, back up and restore, indexes, views, and it even has a section on Advanced T-SQL. There's even a chapter on Reporting Services that's nice, too. The only thing that may be considered missing is more information in SQL Server Integration Services, but then that could be considered an "advanced" topic.

Overall, this book does a great job of introducing SQL Server 2005 to its intended audience.

7 of 7 people found the following review helpful:

5.0 out of 5 stars Book not to miss to explore SQL Server 2005, August 4, 2006

By	Mohamed Benothmane "Book Addict" (San Diego, CA United States) - See all my reviews (REAL NAME)

With the first chapter, you will learn details and techniques how to install and configure SQL Server 2005 for different editions. The second chapter inroduces the new client tools to interact with SQL Server 2005.
To understand the concept and techniques of databases, the author walk you through a real world example to apply these concepts. This is a perfect way to relate what you lean to a practical complete project.
The book ends with the advanced features that were added to SQL Server 2005 compared to SQL 2000. There is also a detailed chapters about security configuration for the installation and post installation phases.
I will recommend this book for beginners and professional users as well.