Beginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice)
by Robin Dewson
List Price:
Our Price: $19.98
You Save: $30.01 (60%)
Availability: Usually ships in 1-2 business days
Buy Used: from $18.97 (click here)
Category: Book
See more book details and other editions
Book Summary Information
Author: Robin DewsonEdition: Paperback
Audio: English (Original Language); English (Unknown); English (Published)
Published: 2006-01-30
ISBN: 1590595882
Number of pages: 536
Publisher: Apress
Accessories:
- Beginning PHP and MySQL 5: From Novice to Professional, Second Edition (Beginning from Novice to Professional)
- Practical Ruby Gems
- Beginning Ruby: From Novice to Professional (Beginning from Novice to Professional)
Book Reviews of Beginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice)
Book Review: Terrible!
Summary: 1 Stars
This really is one of the worst computing books I've ever read: it's very badly structured, poorly written and not too hot on the facts either.
Reading this book is like being sat down with the bumbling office grunt who has just been told to give you an introduction to a piece of unfamiliar software: he sits there pointing at anything and everything he sees, as he sees it, telling you lots of inconsequential detail and saying that he'll tell you more later (or that he's not going to tell you anything at all because it's not a beginner's topic, even though he's just been pointing out all the buttons for it). As a result, you're on page 119 before he gets around to showing you how to define a table, and you have to wait until page 245 before he starts talking about how to insert data into it and perform select queries! If you already know something about databases, this approach is just frustrating and irritating; if you don't (i.e. you're one of the beginners this book is aimed at) it's confusing as well. There's no point being told the function of every button on a toolbar (he takes a hundred words to tell us about the Open, Save and Save As buttons) or every option in an Options dialog, before you've seen basic queries in action (e.g. he tells us that "Pressing this button brings up a dialog box to change the values in each of a template's parameters" well before he shows us queries, let alone code templates!). If you're going to set up a production database, then of course you need to know about security and administration tasks before you do so, but this is supposed to be a book for beginners (and beginner database developers, not administrators, for that matter): it's safe to assume that they'd read through quite a lot of stuff in a more logical order and experiment on a test installation before embarking on proper work!
And here's a sample of his convoluted writing about a pretty simple concept (deciding whether to enforce referential integrity on already existing data when adding a new relationship between tables): "By creating the relationship, you want the data within the relationship to work, therefore you would select No if you were going to go back and fix the data after the additions. What if you still miss rows? Would this be a problem? In preceding our scenario, there should be no transaction records without customer records. But you may still wish to add the relationship to stop further anomalies going forward." Here's some more linguistic spaghetti: "However, when including key column(s) from a clustered index in a nonclustered index, because the row pointer is actually the clustered index key, SQL is smart enough not to store the information twice in the nonclustered index, and you can explicitly define the order of the clustered index keys as they are used in the nonclustered index." If you already understand the concepts he's trying to explain, you can usually make sense of this stuff (unless he contradicts himself in the space of a few sentences, that is), but this is a book supposed to be aimed at beginners and should present the ideas clearly.
If you want to read something like this, i.e. with little or no thought about how to present the most important ideas simply, quickly and clearly without distracting detail, you might as well save your money and read the Microsoft help files (which are more accurate and better written!). If you're going to spend money, look elsewhere.
More Beginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice) reviews:
1 2 3
1 2 3
Summary of Beginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice)
?
Purchase this book and you'll get the free, fully searchable eBooka $25value! (Details are printed inside the book.)
?
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.
This book features practical steps to help you overcome issues youre likely to encounter. Youll learn to use SQL for querying, inserting, updating, and deleting data. Youll also learn how to back up and restore databases for basic administration in SQL Server. Further, youll cover how to build a complete database, from the fundamentals of relational database design to table and index creation.
Additionally, youll start to program in T-SQL, SQL Servers implementation (and extension) of the SQL programming language, and youll come away with effective programming techniques using stored procedures and triggers.
Client-Server Systems Books
Book Subjects
- Arts & Photography
- Audiobooks on Cassette
- Audiobooks on CD
- Biographies & Memoirs
- Business & Investing
- Children's Books
- Comics & Graphic Novels
- Computers & Internet
- Cooking, Food & Wine
- e-Books
- Engineering
- Entertainment
- Gay & Lesbian
- Health, Mind & Body
- History
- Home & Garden
- Horror
- Law
- Literature & Fiction
- Medicine
- Mystery & Thrillers
- Nonfiction
- Outdoors & Nature
- Parenting & Families
- Professional & Technical
- Reference
- Religion & Spirituality
- Romance
- Science
- Science Fiction & Fantasy
- Sports
- Teens
- Travel
Most talked about in Windows/SQL Server
MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)by Solid Quality Learning
Microsoft Press; Published: 2006-06-28; Hardcover; No Operating System; Book
Best price: $32.00
Price in other shops:
Expert SQL Server 2005 Development (Expert)by Adam Machanic, Hugo Kornelis, Lara Rubbelke
Apress; Published: 2007-05-21; Paperback; Book
Best price: $26.13
Price in other shops:
Pro SQL Server 2005 Replication (Definitive Guide)by Sujoy Paul
Apress; Published: 2006-12-15; Hardcover; Book
Best price: $58.60
Price in other shops:
Pro SQL Server 2005 High Availabilityby Allan Hirt
Apress; Published: 2007-07-17; Hardcover; Book
Best price: $44.34
Price in other shops:
Pro SQL Server 2005 Database Design and Optimization (Pro)by Louis Davidson, Kevin Kline, Kurt Windisch
Apress; Published: 2006-05-01; Paperback; Book
Best price: $42.00
Price in other shops:
Pro SQL Server 2005 (Pro)by Thomas Rizzo, Adam Machanic, Robin Dewson, Rob Walters, Joseph Sack, Julian Skinner, Louis Davidson
Apress; Published: 2005-11-02; Paperback; Book
Best price: $9.54
Price in other shops:
Beginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice)by Robin Dewson
Apress; Published: 2006-01-30; Paperback; Book
Best price: $27.76
Price in other shops:
MCTS (Exam 70-643): Configuring Windows Server 2008 Applications Infrastructure self paced training kitby J.C. Mackin, Anil Desai
Microsoft Press; Published: 2008-03-22; Hardcover; Book
Best price: $8.66
Price in other shops:
Windows Server 2008 Inside Outby William R. Stanek
Microsoft Press; Published: 2008-04-06; Paperback; Book
Best price: $32.48
Price in other shops:
Windows Server? 2008 Resource Kitby Microsoft Corporation
Microsoft Press; Published: 2008-04-06; Paperback; Book
Best price: $134.86
Price in other shops:
Similar Books and other products
ASP.NET 2.0 Website Programming: Problem - Design - Solution (Programmer to Programmer)by Marco Bellinaso
Wrox; Published: 2006-05-08; Paperback; Book
Best price: $20.00
Price in other shops:
Pro SQL Server 2005 Reporting Services (Pro)by Rodney Landrum, Walter J. Voytek II
Apress; Published: 2005-10-26; Paperback; Book
Best price: $10.95
Price in other shops:
Pro T-SQL 2005 Programmer's Guide (Expert's Voice)by Michael Coles
Apress; Published: 2007-04-23; Paperback; Book
Best price: $30.57
Price in other shops:
Inside Microsoft SQL Server(TM) 2005: The Storage Engine (Solid Quality Learning)by Kalen Delaney
Microsoft Press; Published: 2006-11-08; Paperback; Book
Best price: $12.34
Price in other shops:
Expert SQL Server 2005 Development (Expert)by Adam Machanic, Hugo Kornelis, Lara Rubbelke
Apress; Published: 2007-05-21; Paperback; Book
Best price: $18.32
Price in other shops:
Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka
Microsoft Press; Published: 2006-04-26; Paperback; Book
Best price: $22.99
Price in other shops:
SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach (A Problem - Solution Approach)by Joseph Sack
Apress; Published: 2005-12-06; Paperback; Book
Best price: $39.56
Price in other shops:
Pro SQL Server 2005 Database Design and Optimization (Pro)by Louis Davidson, Kevin Kline, Kurt Windisch
Apress; Published: 2006-05-01; Paperback; Book
Best price: $39.98
Price in other shops:
Pro SQL Server 2005 (Pro)by Thomas Rizzo, Adam Machanic, Robin Dewson, Rob Walters, Joseph Sack, Julian Skinner, Louis Davidson
Apress; Published: 2005-11-02; Paperback; Book
Best price: $17.90
Price in other shops:
Beginning SQL Server 2005 Programming (Programmer to Programmer)by Robert Vieira
Wrox; Published: 2006-02-27; Paperback; Book
Best price: $21.40
Price in other shops: