Books for/about - sql


 

 
MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server(TM) 2005 Implementation and Maintenance (Pro-Certification (Hardcover))

Publisher: Microsoft Press
Authors: Solid Quality Learning Laura Sackerman

ISBN: 073562271X
List Price: $59.99
Amazon Price: $37.79
Usually ships in 24 hours

Buy this book 
from amazon.com

or from
amazon.co.uk

Avg Cusomer Rating: 4
Reviews:
Summary: Good book
Taking the test which this study guide is focus to is a very important step before give any content's feedback (i'm still preparing myself for the test) But i will give my 1st impression about the book anyway.

Pros:
Very well organized book. Chapters and content are divided in small chunks of information (lessons). For busy people (like me) or those which like to do self study at own pace this is a big aid.

I like the writing style also. Not boring, not too technical altought you should have a previous SQL 2000 background if you want to take full advantage of this book.

I did like chapter 11, the backup and restore processes. This is a must for every SQL admin. and it is well covered. The same for the Maintenance Plan and Job topics (Ch 14)

The 15% off in the test price is a good bonus. You should consider this if you're in a low budget.


Cons or critics:
The test engine is an added value but... i don't know ... after taking a few custom tests ... i am not pretty sure about their content's difficulty. I mean, IMO, questions seems too easy for me. I've took a lot of Microsoft tests before (i'm MCSA) and i've never seen easy questions like these in most of them. You must read a lot and think well before mark an answer and i don't feel that when i'm taking this book's test engine. Do not misunderstand what i'm saying, a free Test Engine is a nice bonus, i just want to give a non parcial review. I'm a customer too and we must rely in good study sources to avoid test failures.

Chapter 5: just a brief T-SQL review; use a Sybex SQL 2000 Design book for better preparation or buy the Ben Forta book instead (ISBN: 0672325675), you won't regret and it will help you a lot.

Chapter 12: hey! what happened with the pics here? ... too much words and just a few pics for this topic. Fragmentation concepts are easier to understand when you see how they works; here's when drawings and pics enter into action.

Final comment.
Currently, this is the only book for this test in the market. Sybex and the others are still in press, so there are not much choices either but overall, is a good election anyway; easy to read and very well organized. Find a good PC or laptop, VMWARE or Virtual PC and that's all you need for your study track (SQL 2005 evaluation version is included)

Need extra info? Try SQL 2005 Stanek pocket book ...

UPDATED 7/26/2006:
I already have the new Sybex book for this test. And 'till now, what i've read so far ... i've not found it better than Solid's book. Some Sybex chapters are just a re impression of their old 70-228 book. I keep you informed ...

Summary: 2-in-1 training kit
These 2 extras alone is worth more than the price of this book: First, there is the 15% discount on MCP exams. This translates to about $15. Then, there is the practice test software with 295 questions which is very similar to other commercial practice tests (cost at least $59). NOTE: I bought this book from other site because this book was already available there a week earlier than here at Amazon. The price of this book in Amazon is about $8 lower.

This is a hard bound book (I'm very impressed of the cover design). The papers are white and of high quality.

The contents are organized by exam objectives (there is also a card you can tear from the book that outlines the exam objectives and tells you what chapter and lesson you will find the objective discussed in the book). Every lesson has its summary and review questions. Reading some lessons and browsing through the pages of the book, I believe this is a comprehensive study guide for this exam and is, by itself, sufficient to prepare you to pass the exam.

Summary:


       search for sql at amazon.comamazon.co.ukgoogle.com

MySQL (3rd Edition) (Developer's Library)

Publisher: Sams
Authors: Paul DuBois

ISBN: 0672326736
List Price: $49.99
Amazon Price: $31.49
Usually ships in 24 hours

Buy this book 
from amazon.com

or from
amazon.co.uk

Avg Cusomer Rating: 4
Reviews:
Summary: Excellent reference book
This book is used at least once a day. Illustrations are clear, and examples concise. Covers all aspects of MySQL.

Only nag is that version 5.0 was obviously still evolving when this was written, so some of the new features such as triggers and views are not fleshed out well. But the author deals with that early on, and does give them some page time.

As with most open source programs, check the website -- there are some really nifty tools now available for MySQL that weren't available even a few months ago.

Worth the price -- don't wait for the fourth edition. If you do, you'll be missing out on what you can do with this amazing product.
Summary: Probably complete, but...
This book is full of interesting data - and is even probably complete. However when it comes to searching the information you need, this is a different story.

The biggest problem is the index. You need a refresh about the syntax of the command to dump/recover the database... don't look for "dump" or "recover" it's not in.
Even the simplest operations like "How do I extend the fields of my table?", there is neither "add" or "field" in the index (besides the FIELD() function).

Finally the information is hard to find within the chapters also. There are 13 head of chapters with non intuitive titles. The author had seemingly a hard time to manage all that information, and distributing it logically among chapters. Repetitions, omissions,... the book is not pleasant to search/follow/read.

I agree one must be glad to have a book about Mysql, this is why I gave 3 stars, but the book could be largely improved.
Summary: The most comprehensive reference to MySQL usage, administration, and programming currently available.
If someone approached me and asked `Mike, I want to learn MySQL ad I can only afford one book, which one would you recommend?', I would have to answer MySQL by Paul DuBois.

I actually owe my involvement with MySQL and my current employment to this book. When I was taking an Oracle course in University I found a copy of the first edition of this book in a bookstore at a discount and picked it up in the hopes that since it referred to SQL on the cover it might help me with my studies. While the book did teach me a good deal about SQL, it also taught me about MySQL, an RDBMS I would use exclusively as soon as the Oracle course was over with.

At more than 1200 pages, this is certainly the most comprehensive book on MySQL available to date. This book covers everything from installing MySQL to query optimization to PHP programming, along with everything in between. The book also provides enough reference information that it serves as a nice substitute for the MySQL documentation when you do not have internet access.

Part one of this book deals with the basics. MySQL is described, and a basic SQL tutorial is provided. Later chapters describe choosing data types and performing the various tasks that are involved in using MySQL. By the time you complete part one, you should be able to access data, create tables, join tables, and optimize your queries. For a typical user these first 300 pages should be all you need to become an advanced user (not an administrator mind you).

Part two occupies the next 250 pages and is a nice introducion to programming and instructs you in the use of the C, Perl,
and PHP APIs. While not as extensive a programming introduction as you will find in a dedicated PHP, Perl, or C book, the subject of database programming with these languages is well covered, and you should be able to write a basic database application after reading part two.

In part three, Paul DuBois descibes the administration of a MySQL database. Of particular interest should be the chapters on
administration and security. Additional subjects include file maintenance, server configuration, and replication. As with part one, part three is comprehensive and should provide solutions for anything you may encounter when administering a MySQL database.

The reference information in the appendices is quite extensive, and covers everything from installation to function and syntax references. The information should be current to MySQL 5, and is an excellent resource when you do not have access to the online reference manual
with its current information.

This is without a doubt one of the finest resources available on MySQL. This was my first MySQL book and my old first edition is well worn and has served me very well. If you need a good MySQL book that can take you from being an absolute beginner to a seasoned DBA, this is the book for you.
Summary:


       search for sql at amazon.comamazon.co.ukgoogle.com

PHP and MySQL Web Development (3rd Edition) (Developer's Library)

Publisher: Sams
Authors: Luke Welling Laura Thomson

ISBN: 0672326728
List Price: $49.99
Amazon Price: $31.49
Usually ships in 24 hours

Buy this book 
from amazon.com

or from
amazon.co.uk

Avg Cusomer Rating: 5
Reviews:
Summary: Peter Henrik Stæhr Albrekt
So far it has been an efficient learning tool. This book is clearly written by authors who deal with teaching and learning strategies. Details are thoroughly explained and you are carefully lead from one step to the next.

Summary: Good thorough intro to PHP and MySQL
Well done, maybe 5 stars. Has all the intro and intermediate info you need. Includes some best practices and programming concepts which I didn't want, so perhaps tries to include too much. But I'm being too picky. This book has everything one needs to get going with this technology and is thoughtfully presented. definitely recommended.
Summary: Love it! Highly recommended!
I bought the first edition of this book several years ago and it has been my bible ever since. It makes everything amazingly easy to learn. I didn't even have to sit down and do a read-through. I just skimmed it to start out, sat down in front of the 'puter, and flipped through the book to figure out how to code each part of my first PHP-MySQL site. It was almost too easy. I have created about a dozen database driven sites since, and I always pull the book out for a quick refresher before I start coding. I wish there were books this great for learning all web technologies.
Summary:


       search for sql at amazon.comamazon.co.ukgoogle.com

The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset

Publisher: Wiley
Authors: Joy Mundy Warren Thornthwaite Ralph Kimball

ISBN: 0471267155
List Price: $50.00
Amazon Price: $50.00
Usually ships in 24 hours

Buy this book 
from amazon.com

or from
amazon.co.uk

Avg Cusomer Rating: 5
Reviews:
Summary: Stellar performance
After attending a remarkable presentation by Joy at TechEd in Boston, I purchased this book, and I am glad I did. Working hand in hand with the Business Intelligence group throughout the course of writing really shows - technical accuracy is very high.

Of course, the same process quality you always expect from Kimball Group books is present too. I especially was interested in the SSIS advice. I found everything I needed, even skiping ahead to read those chapters first (which I don't recommend usually, but I was in a hurry).

Summary: Most Excellent
Let me say, this is an absolutely WONDERFUL book. I originally bought Teo Lachev's book. It is technically very good and I will keep it around, but The Microsoft Data Warehouse Toolkit is absolutely outstanding in the way it takes you by the hand and walks you step-by-step through all the initial stages of a DW/BI project -- an area in which Lachev's book is somewhat lacking. Since we are doing a new, first time DW/BI effort at my company, this book - and indeed several of the Kimball books - will be invaluable.
Summary: Outstanding, Practical, Honest -- A Must Have
The Microsoft Data Warehouse Toolkit is a comprehensive overview of this technology that will surely be ubiquitous. It is refreshingly honest about the wonders and warts, and chock full of practical guidance about how to really make a project succeed using Microsoft tools. This book is a worthy addition to the outstanding Kimball Toolkit series. It is essential reading for anyone evaluating or implementing Microsoft SQL Server 2005 for business intelligence applications.
Summary:


       search for sql at amazon.comamazon.co.ukgoogle.com

Professional SQL Server 2005 Integration Services (Programmer to Programmer)

Publisher: Wrox
Authors: Brian Knight Allan Mitchell Darren Green Douglas Hinson Kathi Kellenberger Andy Leonard Erik Veerman Jason Gerard Haidong Ji Mike Murphy

ISBN: 0764584359
List Price: $49.99
Amazon Price: $31.49
Usually ships in 24 hours

Buy this book 
from amazon.com

or from
amazon.co.uk

Avg Cusomer Rating: 2
Reviews:
Summary: Okay, but a little bit disappointing too
I bought this book and had a lot of expectations. 10 Writers were involved to write this book which covers a complete new software tool from Microsoft, introduced with the newly released SQL Server 2005 replacing the DTS Service of SQL Server 2000 and earlier Versions plus adding tons of new features to the enterprise Database Solution which were previously unavailable.

The fact that 10 people contributed to it can be felt throughout the book, because no or little efforts were made to keep the writing style consistent. That can be a bit confusing at times.

Also when it comes to the content, are a lot of things not covert at all or not very well. When I did seek the help from the book for the first time for a very specific problem I tried to solve with SSIS, did the book fail to provide the answers to me. It addressed the problem, but it only addressed the stuff I already figured out myself. To the item I had my problem with did only exist a side note which did not help me at all. That was already a bad start.

I am looking for better alternatives which I have not found yet. It is probably good for somebody who wants to get an overview or general idea of the new Service, but might be the wrong choice for somebody who has specific applications in mind and tries to find answers to problems in this book.
Summary: straight to the point
This book was just what I was looking for, straight to the point. 100% accurate information and practical examples that I could use.
Summary: A good starting Point
The book provides a good starting point to learn SSIS, especially if you never worked with DTS.
However the book does give you a feeling that it was hurried, and the case study really does not adress the challenges you will face in real projects.

But for the Novice, this is a great book to get started with Integration Services.
Summary:


       search for sql at amazon.comamazon.co.ukgoogle.com

Inside Microsoft SQL Server 2005: T-SQL Programming (Pro-Developer)

Publisher: Microsoft Press
Authors: Itzik Ben-gan Dejan Sarka Roger Wolter

ISBN: 0735621977
List Price: $44.99
Amazon Price: $28.34
Usually ships in 24 hours

Buy this book 
from amazon.com

or from
amazon.co.uk

Avg Cusomer Rating: 5
Reviews:
Summary: Serious SQL Programmers need this book
Firstly, this is not a book for beginners or those new to T-SQL, this is targetted more towards intermediate/advanced programmers. If you're new then look at T-SQL Querying.
The level of knowledge and detail that Itzik, Dejan and Roger have and portray in this book is awesome. Do you want to know how SQL Server 2005 internally stores date/time values and what the pitfalls are that you might run into when programming against date/time values (one of the most common problems facing SQL programmers), this book has the answer.
With chapters on Stores Procedures, Transactions, temporary tables, views, the service broker and more.
Each chapter has excellent advice and knowledge and filled with sample code (available online). The book is targetted specifically at SQL Server 2005 and the new ways it handles things, new functions and commands.
My only concern and a slight one at that is that with the amount of information the authors are trying to portray in 500 pages, sometimes the reading is heavy.
An invaluable book for SQL Server 2005 programmers.
Summary:


       search for sql at amazon.comamazon.co.ukgoogle.com

Proc SQL: Beyond the Basics Using SAS

Publisher: Books by Users Press
Authors: Kirk Paul Lafler

ISBN: 1590475348
List Price: $48.95
Amazon Price: $32.31
Usually ships in 24 hours

Buy this book 
from amazon.com

or from
amazon.co.uk

Avg Cusomer Rating: 4
Reviews:
Summary: Quick way to learn SQL
An experienced SAS programmer, I used the many helpful examples in this book to learn a lot about PROC SQL in just a few days. (I skipped the text.) I trust the few typos and obscure passages will be cleared up in a subsequent edition. I thought the sections on normalization and integrity constraints were skimpy. The book has also been favorably reviewed in The American Statistician 2005, vol. 59, no. 4, pp. 350

Summary: Complete, but the good stuff is at the back
It is well written and complete, but despite the title, spends too much time on the basics.
Summary:


       search for sql at amazon.comamazon.co.ukgoogle.com

Professional SQL Server 2005 Reporting Services

Publisher: Wrox
Authors: Paul Turley Todd Bryant James Counihan Dave DuVarney

ISBN: 0764584979
List Price: $39.99
Amazon Price: $25.19
Usually ships in 24 hours

Buy this book 
from amazon.com

or from
amazon.co.uk

Avg Cusomer Rating: 5
Reviews:
Summary: I just say it is excellent
This book is an excellent way to begin understanding this technology Microsoft released. Step by step explains the most important concepts about SSRS with tips and recomendations to do the things better. You can buy this book without any problem.
Summary: Deep dive into SRS 2005
I have read all the SRS2005 books out there so far. This is one of the best. Very well done.
Summary: Excellent Book
Till today I never found a good book in SQL Server Reporting Services. This book covers a lot of features, to get you ready to work on Complex Reports. Very good step by step instructions with working examples. It starts from a beginner level and proceeds with Advanced Report Design.The best part I liked was the explanation about Rendering reports using .NET code, .NET IO namespace classes, and URL rendering deployment strategies to handle hardware, software, and platform considerations, licensing issues, and scaling options.
I highly recomend this as a very important source to learn Reporting Services
Summary:


       search for sql at amazon.comamazon.co.ukgoogle.com


Computers and Electronics Books || Automotive Books || Misc Books






Computers and Electronics Books
| 3d | 3d animation | 3d graphics | 3d studio | 3ds max | Abap | Administrator | Adobe | adobe acrobat | adobe after effects | adobe audition | adobe bridge | adobe golive | adobe illustrator | adobe image ready | adobe indesign | adobe pagemaker | adobe photoshop | adobe premier | ADSL | amazon com books | apache | aplication server | Apple | asp | asp.net | autocad | avid | avid media composer | avid symphony | avid xpress | bind | BlueRay | C sharp | c++ | C++ Builder | Cambridge ICT Starters | certification | certification books | Cisco | Cisco BCMSN | Cisco BCRAN | Cisco BGP | Cisco BSCI | Cisco BSSC | Cisco CCDA | Cisco CCDP | Cisco CCIP | Cisco CCNA | Cisco CCNP | Cisco CCSP | Cisco CIT | Cisco CSIDS | Cisco CSPFA | Cisco CVOICE | Cisco DESGN | cisco firewall | Cisco INTRO | Cisco MPLS | Cisco QoS | Cisco SECUR | civilization | cobol | ColdFusion | combustion | Computer Associates | Computer Science | CORBA | css | db2 | deko | delphi | design patterns | dhtml | digital production | DirectX | DirectX9 | dll | dns | dns server | DVD | eBay | ECDL | ECDL Advanced | Final Cut | Final Cut Pro | flash 8 | Flash Studio 8 | fortran | game cube | Google | Graphic Design | graphics | graphics development | hacking | haking | Hardware | hardware hacking | html | Intel | internet | irix | isdn | J2EE | Jakob Nielsen | java | javascript | LDAP | linux | Linux Administrator | LSAT | mac | mac os | macintosh | Macromedia | macromedia actionscript | macromedia dreamweaver | macromedia flash | Macromedia Studio 8 | mail server | mail servers | max 3d | maya | Microsoft Application Developer | microsoft c# | Microsoft Certified | Microsoft Database Administrator | Microsoft Desktop Support Technician | microsoft exams | microsoft excell | microsoft frontpage | microsoft office | microsoft powerpoint | microsoft reader | Microsoft Solution Developer | microsoft sql server | Microsoft Systems Administrators | Microsoft Systems Engineer | microsoft visual basic | microsoft visual studio | microsoft windows 2000 | microsoft windows 2003 | microsoft windows server | microsoft windows xp | microsoft word | microsoft works | Mini DV | mysql | networking | ocx | Open Source | opengl | oracle | oracle 10g | oracle 9i | Oracle administration | oracle application server | Oracle programming | palm os | palm reader | pascal | pda | pdf | Photoshop CS2 | php | php5 | Pinnacle | Pinnacle Liquid | Pinnacle Studio | playstation | plc | pocket pc | PocketPC | postscript | powerbuilder | programming | samba | sap | SAP ABAP | SAS | sco | sco unix | search engines | smartphone | SOA | soap | solaris | sql | svg | sybase | tcp/ip | Telecommunications | telecoms | Unisys | User Interface Design | vb script | vbx | Video Games | Virus | Visual Studio 2005 | Visual Studio.NET | VoIP | web | Web Usability | webdesign | website development | websites | WebSphere | WiFi | Windows 2003 Server | Windows Administrator | Windows XP Pro | Windows XP Profesional | Windows XP Professional | wireless networking | x-box | xhtml | xml | xslt | Yahoo



| home |