| MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server(TM) 2005 Implementation and Maintenance (Pro-Certification (Hardcover))
Publisher: Microsoft Press |
|
| ISBN: 073562271X List Price: $59.99 Amazon Price: $37.79 Usually ships in 24 hours |
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: |
| MySQL (3rd Edition) (Developer's Library)
Publisher: Sams |
|
| ISBN: 0672326736 List Price: $49.99 Amazon Price: $31.49 Usually ships in 24 hours |
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: |
| PHP and MySQL Web Development (3rd Edition) (Developer's Library)
Publisher: Sams |
||
| ISBN: 0672326728 List Price: $49.99 Amazon Price: $31.49 Usually ships in 24 hours |
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: |
| The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset
Publisher: Wiley |
|
| ISBN: 0471267155 List Price: $50.00 Amazon Price: $50.00 Usually ships in 24 hours |
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: |
| Professional SQL Server 2005 Integration Services (Programmer to Programmer)
Publisher: Wrox |
|
| ISBN: 0764584359 List Price: $49.99 Amazon Price: $31.49 Usually ships in 24 hours |
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: |
| Inside Microsoft SQL Server 2005: T-SQL Programming (Pro-Developer)
Publisher: Microsoft Press |
||
| ISBN: 0735621977 List Price: $44.99 Amazon Price: $28.34 Usually ships in 24 hours |
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: |
| Proc SQL: Beyond the Basics Using SAS
Publisher: Books by Users Press |
|
| ISBN: 1590475348 List Price: $48.95 Amazon Price: $32.31 Usually ships in 24 hours |
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: |
| Professional SQL Server 2005 Reporting Services
Publisher: Wrox |
|
| ISBN: 0764584979 List Price: $39.99 Amazon Price: $25.19 Usually ships in 24 hours |
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: |
| home |