๐”– Scriptorium
โœฆ   LIBER   โœฆ

๐Ÿ“

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

โœ Scribed by Robin Dewson


Publisher
Apress
Year
2006
Tongue
English
Leaves
538
Series
Expert's Voice
Edition
2nd ed.
Category
Library

โฌ‡  Acquire This Volume

No coin nor oath required. For personal study only.

โœฆ Synopsis


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.


๐Ÿ“œ SIMILAR VOLUMES


Beginning SQL Server 2005 for Developers
โœ Robin Dewson ๐Ÿ“‚ Library ๐Ÿ“… 2006 ๐Ÿ› Apress ๐ŸŒ English

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 softwar

Beginning SQL Server 2005 for Developers
โœ Robin Dewson ๐Ÿ“‚ Library ๐Ÿ“… 2006 ๐Ÿ› Apress ๐ŸŒ English

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 softwar

Beginning SQL Server 2005 Express for De
โœ Robin Dewson ๐Ÿ“‚ Library ๐Ÿ“… 2007 ๐Ÿ› Apress ๐ŸŒ English

<p><span>SQL Server 2005 Express Edition is a free relational database management system from Microsoft and provides a major subset of full SQL Server 2005 functionality. Many users learn on SQL Server 2005 Express Edition and then move on to SQL Server 2005. This book is a comprehensive, clear and

Beginning SQL Server 2008 for Developers
โœ Robin Dewson ๐Ÿ“‚ Library ๐Ÿ“… 2008 ๐ŸŒ English

Beginning SQL Server 2008 for Developers is the starting-point in the Apress roadmap of titles for developers who wish to base their projects upon Microsoft's flagship database management system. The book takes developers from the point of installing SQL Server 2008, through the process of storing,

Beginning SQL Server 2005 for Developers
โœ Robin Dewson ๐Ÿ“‚ Library ๐Ÿ“… 2006 ๐Ÿ› Apress ๐ŸŒ English

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 f