Reviews (4)

Just enough DB design without being complicated
This book is now next to my desk as a reference text. It does a good job at explaining the basics of relational database models and how they fit into a modern business architecture. The authors obviously have a methodology that works for them and the chapters seem to be organized according to their methodology. They start with UML, analyze the model in UML for potential problems, then move into SQL, normalization at the SQL stage, and end with an example. It's nicely written and concise.
Excellent introduction to data modeling
I also am a reviewer of the book and an interested colleague. I've used this book since its first edition as my main reference on basic data modeling, and I have been happy to comment on its newer editions. This 4th edition improves on earlier ones by including the Unified Modeling Language (UML), my own first choice for a design language for data modeling. The chapter on the UML includes everything you need, but it keeps it as simple and straightforward as possible, making the material very accessible. The real contribution of the book is in the normalization chapter and in the excellent description and examples of n-ary relationships and the consequences of their multiplicities, a very-hard-to-understand corner of the data modeling world. The inclusion in this edition of material on OLAP and data warehousing is also welcome, though very limited in scope. Finally, moving the physical design material into a separate book makes this book much more cohesive and useful as a reference for data modeling.

Excellent book for Data Modelers, etc.
For those in Data Modeling, Data Architecture, and similar disciplines, I highly recommend this book !An excellent discussion of database design and modeling, practices and techniques. ... Read more

Subjects:  1. Computer Books: Database    2. Computers    3. Computers - Data Base Management    4. Data Modeling & Design    5. Database Management - General    6. Database design    7. Information Storage & Retrieval    8. Relational databases    9. Computers / Database Management / General    10. Databases & data structures   

Reviews (7)

Good For Revision, But u need to Couple it with Another Reference

Average exam review
A good review book explains all the topics in a consise fasion this book does explain the topics that well is a bit disorganized and has topics missing. There are better review books out the for SQL 2K

Good but not enough
This book is a good, general introduction to the 70-229 exam concepts - but I had to couple it with the Transcender practice exam before I felt comfortable taking the exam.The exam topics are so broad that the book doesn't do enough to emphasize when to use what.It also skips some important topics (sp_cursoropen) and its practice tests include Full Text Searches which the book notes are unlikely to be on the exam.To the editors: A 'databases' index entry with three pages of sub-entries is redundant in a book about databases.I love the Exam Cram series, but this was the poorest book of the bunch. ... Read more

Subjects:  1. Certification Guides - General    2. Certification Guides - MCSE    3. Computer Books: Database    4. Computer Books: General    5. Computers    6. Computers - Languages / Programming    7. Database Engineering    8. Database Management - General    9. Programming Languages - SQL    10. Tests    11. Computers / Technical Skills    12. Databases & data structures    13. SQL    14. Study guides, home study & revision notes   

Reviews (3)

A very good book for SQL server self-learner
Excellent. It is a good reference for your SQL Server examination or self-learning. The examples are listed in details. If you follow them step by step, you can 100% learn the skills for your SQL server daily maintenance. I am not a professional in SQL Server, but after reading this book, I have much stronger confidence to use it.
Not enough T-SQL
Overall, I would say this book is well put together and is an excellent resource.I personally was hoping for a bit more meat on the programming of the T-SQL commands and methods, but the lack of that information is not the fault of the author, merely my selection of the wrong book.
Extensive coverage of what every SQL DBA should know
Packed with practical, real-world information for anyone involved with SQL Server Administration, "Beginning SQL Server 2000 DBA: From Novice to Professional" is one of the most complete administration books available.It is not without its problems but they are generally pretty minor and in fact somewhat humorous at times.For example, page 84 has a section titled "Upgrading to SQL Server 6.5" and page 90 a section titled "Upgrading to Earlier Versions of SQL Server".Obviously you don't upgrade to an earlier version nor do you upgrade from 2000 to 6.5.So, while there are errors, they are so obvious as to not be a big problem.When it comes to the technical details where accuracy is critical, I didn't find any obvious errors. Read more

Subjects:  1. Client/server computing    2. Computer Books: Database    3. Computers    4. Computers - Data Base Management    5. Database Management - General    6. Database Management - SQL Server    7. Database management    8. Networking - General    9. Relational databases    10. Computers / Database Management / General    11. Computers-Networking - General   

Reviews (16)

Quick,, Handy Reference for a former DB2 for z/OS DBA
If you are coming from mainframe DB2, this is the book for you. Phil Gunning does a great job of explaining the many parameters and settings that make up DB2 UDB. Explanations are clear and straight to the point. It helped me to understand the DB2 UDB architecture and to get up to speed quick.

Good Tips from A DB2 Veteran
This book has helped my get started on monitoring and tuning my databases. Coming from Sybase, I had no idea where to start. I picked up this book and it guided me through all the monitoring setups and provided a monitoring and tuning methodology -- along with recommendations. This stays on my desk and is very handy.

One of a Kind
This book is really well organized. The section on logical and physical design was a good review for me. It reminded me how important a good design is to a successful database implementation. The SQL Tuning, Buffer pool tuning, and DB and DBM CFG tuning chapters have helped me take care of my problem databases and suboptimal SQL. ... Read more

Subjects:  1. Certification    2. Computer Books: General    3. Computers    4. Computers - Data Base Management    5. Database Management - General    6. Database management    7. Electronic data processing per    8. Electronic data processing personnel    9. IBM Database 2    10. Microcomputer Operating Environments    11. Operating Systems - General    12. Operating Systems - UNIX    13. Operating Systems - Windows    14. Operating systems (Computers)    15. Relational Databases    16. Study guides    17. Computers / Database Management / General    18. Databases & data structures    19. Systems management   

Reviews (12)

Best overall for SQL Server Tuning
I am a SQL Server performance consultant to many large corporations and government agencies.I have read and re-read this book so many times I should know it by heart. Still, I carry it with me on consulting engagements everywhere I go.There is almost always someone at my client's site who wants to improve their performance tuning skills.I show them the book and tell them this is where you start.
Best book on performance tuning
This is the best book ever written on performance tuning.Excellent text and very well written too.Thanks a lot.

This book rocks!!
This book is like a SQL SERVER 2000 bible for me.It has the most wonderful information in it, clear and easy to understand.I needed to interview for a job and I looked to this book for clarity and knowledge and boy was I enlightened.A must read for a beginner DBA like myself!!!!! ... Read more

Subjects:  1. Client/server computing    2. Computer Books: Languages    3. Computers    4. Computers - Data Base Management    5. Database Management - General    6. Database Management - SQL Server    7. Programming - General    8. Programming Languages - SQL    9. Relational Databases    10. SQL server    11. Sql (Programming Language)    12. Computers / Database Management / General    13. Database software    14. Databases & data structures   

Reviews (12)

"A 1"
Comprehensive. A good resource to have in the collection of books.
If I had bought this book first I'd have save a lot of money
I have a lot of SQL server books. Everything from SQL Server 2000 for Dummies up to SQL Server 2000 Stored Procedure Programming. And many times none of these books had what I needed. Then I would turn to this book. I was using VB.Net, so I figured this book wouldn't apply, but I was wrong. Even if you are not using Access, this book explains SQL Server the right way. Chipman and Baron offer simple but thorough explanations and samples of the things you actually need to know as a developer. They don't spend a lot of time on the things a SQL Server DBA might need to know that a coder would not.
Appears to be an excellent book.
This answers a lot of programmer level questions about using MS-Access with SQL Server.It describes the limits and penalties when going the various routes.The book is quite clear in its descriptions.It would make a good addition to any Access programmer's collection. ... Read more

Subjects:  1. Computer Books: Operating Systems    2. Computers    3. Computers - Data Base Management    4. Database Management - General    5. Database Management - SQL Server    6. Database management    7. Desktop Applications - MS Access    8. Microcomputer Database Management Software    9. Microsoft Access    10. Programming Languages - SQL    11. SQL server    12. Sql (Programming Language)    13. Access    14. Computers / Database Management / General    15. SQL   

Reviews (16)

Fantastic Book!!
This book is perhaps the best and most useful technical book I've read in many years.I'm a seasoned developer with some good SQL experience but not much experience on the tuning side of the house (previously worked mostly with Oracle in large organizations where there was a DBA to perform the magic).Now I'm in a smaller organization where I have more exposure to the tuning aspects of SQL Server 2005.
Excellent SQL Server Resource - my favorite IT book to-date!
This is an excellent overview of database performance tuning and optimization best practices. Packed with useful information. Each topic is accompanied by examples and presented in a clear, easy-to-read style. The only thing I found missing somewhat was some more elaborate examples of index analysis and tuning. I found the presented examples on indexing a bit too simplistic.
A perfect book
This was recommended to me by a senior DBA and I have learnt a lot from it.The text is accurate and very nicely written.It is detailed and covers a lot of very fundamental aspects of SQL Server tuning. ... Read more

Subjects:  1. Computer Books: Database    2. Computers    3. Computers - Data Base Management    4. Database Management - General    5. Database Management - SQL Server    6. Computers / Programming / General   

Reviews (8)

Recommended if you are new to PL/SQL
The book is good and is recommended for someone new to PL/SQL. For someone who is already familiar to PL/SQL, you can save money by going through the Oracle Online Manual to read about the new features of PL/SQL in Oracle 9i. Since I already had a previous version (Oracle 8) of this book, I consider buying this book as waste of money. But if you are just getting into the world of oracle and you want to learn PL/SQL, this book is for you. One nice thing about the book is it comes with a CD that has some trial version of some development environments. Nice to explore those.
A very helpful book to pass the exam.
This is, indeed, a great book to pass this exam(1Z0-147). Actually, there is no prescribed book(as of now!!), for this exam. This book fairly covers most of the topics that are specified in the official exam syllabus. However, topics on Large objects are not covered in this book extensively. I suggest to search on google for LOBS(This is how i got some notes on LOBS). This book is good to study functions, procedures, packages, triggers, and some DBMS packages, but it doesn't cover LOBS, managing dependencies. Overall, I can give 4 stars to this book, as it helped me to pass the exam.

One of the better IT books that I have seen
This is a well written, fast reading book that provides the reader with the information needed but not with the fluff that we do not need.I used this book to pass the Oracle Certification Exan 1Z0-147 : Oracle9i: Program with PL/SQL.If you own this book and 'Oracle PL/SQL' by Steven Feuerstein and Bill Pribyl (published by O'reily), you probably have what you need (for understanding PL/SQL) ... enjoy ... Read more

Subjects:  1. Certification Guides - General    2. Computer Books And Software    3. Computers    4. Computers - Languages / Programming    5. Database Management - General    6. Database Management - Oracle    7. Oracle (Computer file)    8. PL/SQL (Computer program langu    9. PL/SQL (Computer program language)    10. Programming Languages - General    11. Programming Languages - SQL    12. Relational Databases    13. Sql (Programming Language)    14. Computers / Technical Skills    15. Oracle   

Subjects:  1. Client/server computing    2. Computer Books: Languages    3. Computers    4. Computers - Languages / Programming    5. Database Management - SQL Server    6. Programming Languages - SQL    7. SQL server    8. Computers / Programming / Software Development    9. SQL   

Reviews (3)

If you want to pass the 1Z0-001 exam, look no further!!
This book set me on the right path!Having had no experience with Oracle, I had study only this book, went through its practice questions and lab exercises, and in 1-1/2 month's time, I passed my first exam with flying colors!If anyone is interested in becoming a OCP for Oracle9i and want to also validate your skills in PL/SQL, this book will definitely help you pass your first test.There are some example and question errors in this books, but most are not essential, or are at least noticeable.In any case, it delivers the results and I have nothing but high regards for it.

Outstanding Resource
This book is an outstanding resource for both the 8i and 9i exams.

A good book for fully understanding of PL/SQL
I have Sybex and this one. I like this one because it has a lot of exercises. After I pass the examination, I can have confidence to handle the job which is given by my boss. ... Read more

Subjects:  1. Certification    2. Certification Guides - General    3. Computer Books: General    4. Computers    5. Computers - Certification    6. Database Management - General    7. Database Management - Oracle    8. Database management    9. Electronic data processing per    10. Electronic data processing personnel    11. Examinations    12. Professional - General    13. Programming Languages - SQL    14. Relational Databases    15. SQL (Computer program language)    16. Sql (Programming Language)    17. Study guides    18. Computers / Technical Skills    19. Oracle   

Reviews (4)

You Need this Book
If you are considering using XML in SQL Server 2005, this book will pay for itself quickly.The clear examples of creating XML Schema collections, altering them, etc. are very helpful.
Clear, complete and well done book
The web was designed for people to read what was stored at a computer somewhere else. After the web was set up, it wasn't long before people wanted to extract information from one system to incorporate into their own web page.
excellent book
This was a very good book.It went indepth about xml and how to use it with the new sql server 2005 datatypes.He covers all aspects of xml in sql and how to best use them.Other major new features like using the clr in sql are also covered.I also liked the real world full examples the author provides. ... Read more

Subjects:  1. Client/server computing    2. Computer Books: Database    3. Computers    4. Computers - Data Base Management    5. Computers - Languages / Programming    6. Database Management - General    7. Database Management - SQL Server    8. Programming Languages - XML    9. XML (Document markup language)    10. Computers / Database Management / General    11. SQL   

Reviews (10)

100%
This book is great. It's loaded with recommendations that I have not seen in other SQL books and I've read at least a dozen of them. Even the backup modules cover more information than anything I've seen. Every DBA should read this and stop complaining about this or that not being covered. If you looking for replication than find a replication book. It's impossible to cover everything about availability in one shot and this one comes close. Disappointing
I got this one to help me with setting up a HA replication arch.To be nice about it the repl info in the book is anemic.Next to nothing about it.I'm not sure how I will use the book and Im pretty disappointed iwth it.

New High Availability Wizard for SQL Server 2000
I had to say something here. Everyone got so used to everything being easy in windows, they don't want to hear about also having to know what their doing. Do you think running big available db's is a step-by-step process that Bill left out of the books online? One book can't teach you a college degree worth of information. Read more

Subjects:  1. Client/server computing    2. Computer Books: Database    3. Computers    4. Computers - Data Base Management    5. Database Management - General    6. Database Management - SQL Server    7. Programming Languages - SQL    8. Relational Databases    9. SQL server    10. Sql (Programming Language)    11. Computers / General   

Reviews (17)

The gate for the beginner
SQL Server, this is the topic that I think it is very hard for me to learn. But after I have try this book, it is really make really funny to learn SQL server. I learn a lot of basic things such as table, query, rule, user define function... from this book and now I could SQL Server to manage my own database. There are two advantage that I found in this book:
Don't waste your money
When I first started to read this book, I wanted to learn more about SQL, but this book failed.As the title says, it's pretty much just a bunch of step-by-step exercises and screen shots, but doesn't really get into too much detail, or give any reasons or explanation.
Worthless
If you want 600 pages of screen shots with virtually no explanation of the underlying concepts being presented, then this book is for you.I cannot believe this book would be useful to anyone trying to learn SQL programming.A complete waste of money and time. ... Read more

Subjects:  1. Client/server computing    2. Computer Books And Software    3. Computers    4. Computers - Data Base Management    5. Database Management - General    6. Database Management - SQL Server    7. Databases    8. Programming - General    9. Programming Languages - General    10. Programming Languages - SQL    11. Relational Databases    12. SQL server    13. Sql (Programming Language)    14. Computers / General    15. Database software    16. SQL   

Reviews (8)

Excellent and fascinating read for aspiring Oracle gurus
As an Oracle and SQL Server DBA for the last seven years I found this book an excellent and very refreshing change from technical manuals and books on Oracle database design and administration. The first few chapters are priceless from Oracle history to the useful read on Oracle tuning using Wait events. I really enjoyed learning how the product evolved from inception to the new version of 10g. All in all money well spent and nice to know that even such gurus as the Oak Table guys are human and have shared tough DBA experiences. Someday I want to meet and work with these guys!

I want more books like this one!
I really don't know where I should begin writing this review to give the book a proper credit that it deserves. Hmm...FUN - I think that this word best describes this collection of essays (eleven prominent authors instead of more usual one or two, certainly helped a lot).
A Painful, Funny Journey
I have 14 years of Oracle Experience with some of the busiest and largest transaction systems in the world. This book really hit home for me and brought back a lot of memories of painful times as well as gave me new insights. I have re-read this book twice since getting it amonth ago. It is that good.
Read more

Subjects:  1. Computer Books: Database    2. Computers    3. Computers - Data Base Management    4. Database Management - General    5. Database Management - Oracle    6. Database management    7. Oracle (Computer file)    8. Relational databases    9. Computers / Programming Languages / General    10. Databases & data structures   

Reviews (15)

Worthless
Very disappointed with the book, returned it within a week. Written in a rambling and scatter-brained manner, gives no clear details of database creation or errors regarding db2X commands. May be useful for advanced users but Oracle DBA's wanting a quick insight into DB2 database creation and administration, stay away. Goes into other aspects of DB2 very well, but pointless if you are not taught how to create/troubleshoot the damned database in the first place.

Excellent book for Beginners
I bought this book when I started out in DB2.It's interesting, humorous style made for easy-reading and I covered most of the book within 2 weeks.This book is not a reference text or a thorough description of the more advanced areas of DB2, but covers the entry level to intermediate levels brilliantly.

Good rewrite of basics, advanced stuff not complete
As an experienced DBA and DB developer in just about every major DB product except DB2, I was disappointed that there is no book on the market explaining "in DB2, feature A works like this; feature B goes like that; feature C is entirely unique, etc. etc."Read more

Subjects:  1. Computer Books: Database    2. Computers    3. Computers - Data Base Management    4. Database Management - General    5. General    6. IBM Database 2    7. Information Storage & Retrieval    8. Relational Databases    9. Computers / Information Storage & Retrieval    10. Database software    11. Databases & data structures   

Reviews (15)

Not for Mainframe DB2
I should have done my homework before i bought this book. If you are using db2 on the mainframe im not sure you will find this book too helpful as it caters to windows and linux users. Im very new to db2 and did not find this book that helpful as far as laying down the basics.

DB2 Simplified
I found this book extremely comprehensive.The use of screen captures in partnership with textual descriptions are so much better.Bravo to those who took the time to create a fantastic learning and reference tool!

The book lives up to its name
This book has something for every level of DB2 expertise from beginner to intermediate to expert.The books name implied there would be lots of visual images and the books was loaded with charts, pictures and screenshots.These make learning about DB2 much easier and more fun, than reading plain text. Read more

Subjects:  1. Computer Bks - Data Base Management    2. Computer Books: Database    3. Computers    4. Computers - Data Base Management    5. Database Management - General    6. IBM Database 2    7. Relational Databases    8. Computers / Database Management / General    9. dBase   

Reviews (40)

Great, practical book on basic DB internals
A few years back, I created a special-purpose, custom-built, high-speed relational DBMS using just this book and general computer science knowledge. Darn thing blew the socks off more general purpose solutions and was very stable even after a crash. The book covers access methods, indexing, logging, crash recovery and other basics.
Very Good Book
It's tough finding really good database books that provide a broad range of coverage of database related topics, including the internals of how (relational) database systems work.This is one of the best database books (database theory, concepts, internals, and state-of-the-art database topics) that has come along in 20-25 years.Please note that this is a university textbook.You won't learn MS Access programming or Oracle database administration from this book;if this is why you bought the book, you will probably be disappointed.You will, however, learn a lot about database concepts and internals.There are some small errors in the book, but that happens everywhere.The examples are pretty easy to follow, and the sidebars about DB2, Oracle, SQL Server, etc. are really nice.
Lousy Book, Extremely Difficult to Read
This book is very frustrating to read. The author has a problem explaining the concepts.
Read more

Subjects:  1. Computer Bks - Data Base Management    2. Computer Books: Database    3. Computers    4. Computers - Data Base Management    5. Database Management - General    6. Internet - General    7. Databases & data structures   

Editorial Review

A lot of corporate databases are what's behind the Internet revolution.Read more

Reviews (31)

Very Good Book for DTS
This book clearly explains what DTS Package is ,about Datawarehousing and some conceopts about SQL Server Security...I liked this book very much and helped me a lot for my project

Forget about this.
Expect to see "foobar","Hello world", "The time is blah blah blah"and all that useless examples.This book is entitled "Professional" SQL Server 2000 DTS but you will end up getting (chicken) scratch on the surface:it tells you little about everything.Good only if you are a in the management, it will make you sound like you know what you are talking about.if you are a developer, better off find something else.

Not worth it
You'd think an 880-page tome from Wrox on something as specialised as DTS would pretty much have you covered anytime you need a reliable DTS reference to get you through your Data Transformation tasks. I have found myself looking to this book for guidance on many occasions during development, only to be consistently disappointed. For a start, the Index is downright useless, since I was never able to find words I would expected to, such as delimiter, lineage, disconnected edit, parameterised query, identity insert, but it has an entry for DNS?? (which, btw refers to a 3-line explanation of URLs when using Internet Explorer!) The book is so large mainly because every other page is a GUI snapshot, most of which are unnecessary. I don't need a whole page dedicated to the "Syntax check was successful" message box.Read more

Subjects:  1. Computer Books: General    2. Computers    3. Computers - Data Base Management    4. Data transmission systems    5. Database Management - General    6. Database Management - SQL Server    7. Database management    8. Programming Languages - General    9. Programming Languages - SQL    10. SQL server    11. Computers / Programming Languages / SQL    12. Database software   

Reviews (6)

Great SQL Style Reference
This is a great reference for how to write clear, concise, and efficient SQL. If you are looking for good ideas for SQL coding standards, you will find them here.
I really enjoyed this book
Wading through badly written SQL is a nightmare on the best of days.Proper--and consistent--attention to capitalization, indentation, and other formatting standards makes SQL much more readable and therefore maintainable.The standards outlined in this book are for the most part very well thought-out, and a great starting point for creating a set of enterprise SQL development standards.If more SQL developers would read this book, I would have many less headaches in my day-to-day work, so I believe this is a valuable purchase.
Excellent book in excellent style
Too many database books are written by developers whose expertise is OOP and not SQL.While I don't agree with Mr. Celko on every point, keep in mind that he was on the SQL Standards Committee for 10 years.Even if you don't agree with him on every point, his level of expertise is undeniable - unless, perhaps, the questioner can provide evidence of greater knowledge and expertise.
Read more

Subjects:  1. Computer Books: Database    2. Computers    3. Computers - Languages / Programming    4. Database Management - General    5. Programming Languages - General    6. Programming Languages - SQL    7. SQL (Computer program language    8. SQL (Computer program language)    9. Computer Programming    10. Computers / Database Management / General   

Reviews (10)

good book for beginners
good book for html db beginner developers. many GUI and detail instructions you can follow to develop your own application. very easy to read and play on your own.

Great Book
This is a great book, I know this becuase I've read it.I've also passed it along to other developers within my group, three, to be exact and they like it as well.I'm finding it to be much more useful then the online documentation.
My Review
I bought Oracle HTML DB Handbook, because I needed to write an application in HTML DB and I didn't know the language. With this book and google I was able to create an application with forms, tables, collections, email with links,and the ability to upload and download files.