Subjects:  1. Computer Books: General    2. Computers    3. Computers - Data Base Management    4. Database Management - General    5. Oracle (Computer file)    6. Programming Languages - SQL    7. Relational Databases    8. SQL (Computer program language    9. SQL (Computer program language)    10. Sql (Programming Language)    11. Computers / Database Management / General    12. Databases & data structures    13. Oracle   

Editorial Review

The author uses an interesting didactic innovation that every textbook writer should consider imitating:Instead of illustrating ideas with microprograms, which are good for almost nothing except illustrating theidea, Pratt develops two examples throughout the entire book. By the time you complete this thin butcomprehensive volume, you will have completed two real databases. The book also contains embeddedquestions so you can check whether or not you've grasped specific concepts before proceeding to the nextsection. Pratt's extended case studies show how SQL programs can be layered on one another other toslowly build up functionality. As such, it serves both as an SQL language manual as well as an example ofhow to create relatively large SQL codes. This book does not make specific reference to any particular SQLimplementation, so it can be used with any standard SQL engine. ... Read more

Reviews (5)

Not really bad, but not that good either
I didn't choose this book, it is required for an SQL class I am taking. In our class we are using Microsoft SQL Server 7, and the book tells you that the code will work on any flavors of SQL (or maybe I misread) but it actually focuses on Oracle. Some commands are really different for MSSQL,which uses Transact-SQL, and I have to do a lot of searching to find the equivalents in Microsoft's version. Database concepts given are very confusing.
The book "jumps" around a lot. Many concepts of the Database are not clear or confusing.I take a Database design class which requires this book, but I absolutely don't recommend it to anyone looking to get some knowledge in SQL.

Database concepts given are very confusing.
The book "jumps" around a lot. Many concepts of the Database are not clear or confusing.I take a Database design class which requires this book, but I absolutely don't recommend it to anyone looking to get some knowledge in SQL. ... Read more

Subjects:  1. Computer Books: General    2. Computers    3. Computers - General Information    4. Information Management    5. Information Technology    6. Management Information Systems    7. Computers / Information Technology    8. Computing and Information Technology   

Reviews (2)

Does a beginner need to know about performance tuning?
This is Wrox's book for those keen to learn SQL who have no experience of database programming at all. The good news is that it's not bad. Unfortunately it is two books rather crudely glued together.
As the Title Says, Good Beginning Book
This is a good general introduction to using SQL to build a database, put some data into it and then to get it back out when you need to use it for something. The author says that all of the SQL examples have been tested using MySQL, Microsoft SQL Server, IBM DB2, Microsoft Access, and Oracle 10g. That says that the SQL used in the examples has to be very general in nature and not take advantage of newer and more powerful commands that have come about since these programs were written (particularly Access which uses the Jet engine that's more or less compliant with SQL:89).
Read more

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

Reviews (14)

Not Good Enough
It is a decent book. I believe using this book alone you will not pass the test. Unless you have been working on oracle for a while. I used this book as supplement of the Sybex study guide. The practice exam questions were helpful. I passed my exam (1z0-001) on March 29, 2004 relying on the Sybex Study Guide. I would not recommend this book to someone new to oracle but I can recommend that as second reference. full of errors!
This book has so many errors! The exercises are vague. Some of them don't really make any sense. The author doesn't seem to have very clear knowledge. At least, this was my first impression.

Enough to Pass the Exam
There are errors in the book.But the material covered in the book is enough for passing the 1z0-001 Exam .I used only this book considering that it is from oracle press and have no prior oracle experience.Passed with 53/57.Read more

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

Reviews (24)

If I had to pick just one Sql book this would be it
This is by far the best book available on Microsoft's Sql Server. I found it much far more informative and much deeper than Kalen Delaney's book - the only other one that comes close. It is a book unlike any other that I have read on Sql Server in that it is extremely deep - deeper than just about any technical book I think I have ever read - and extremely broad. Most books are one or the other, but this one really is both. Every chapter is a treasure chest of useful info. Several could be books unto themselves. The discussion of DTS for example is actually better than whole books on the subject. The User Mode Scheduler chapter is so deep I had to read it twice. The list could go on and on.
A book of leftovers
Alas, this book was a VERY disappointing reading.
Not at all what I expected
500 pages of Win NT/2000 fundamentals in a SQL Server Architecture book. Come on, get real Ken Henderson.
Read more

Subjects:  1. Client/server computing    2. Computer Books: General    3. Computer programs    4. Computers    5. Computers - Data Base Management    6. Database Management - General    7. Database Management - SQL Server    8. Debugging in computer science    9. Relational Databases    10. SQL server    11. Computers / Database Management / General    12. Database software    13. SQL   

Reviews (5)

Transact-SQL Desk Reference
Just the kind of book a person needs in their reference library. Well indexed. A complete explanation of each SQL command with examples. 20 pages covering XML, 781 pages in all. It is also made of quality material so it can be handled frequently without falling apart.

Great reference
The back of this book claims that "This is the SQL reference you'll reach for first!" and I can personally support their claim.It is easily the best organized SQL reference that I have encountered.It contains alphabetical listings of all SQL data types and their related functions, in-depth instruction on data definition (create, alter, drop, etc.) and comprehensive descriptions and examples of all data manipulation methods (insert, update, delete, etc.).
Very Good Content - Not So Good Index
This book is exactly what it's title says, it's a reference book. If you need brief descriptions and syntax for T-SQL statements and functions, this is a great book to have on your book shelf. However, the index is very weak. It is essentially an alphabetical listing of functions, so you need to know the name of a function to find it. For example, if you wanted to add an INDEX to a table, you would probably look under "I" for "INDEX.". But, you wouldn't find what you were looking for. You would need to look under "C" because the function is "CREATE INDEX." But, if you know what you are looking for, you'll find it in this book. ... Read more

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

Subjects:  1. Computer - Internet    2. Computer Books: Internet General    3. Computers    4. Computers - Data Base Management    5. Database Management - Oracle    6. Internet - General    7. Computers / Internet / General   

Reviews (8)

Unprofessional style and lack of knowledge
The author definitely has an arrogant style of writing. The book just talks about one way of doing things without being open about other possible better ways of designing and implementing efficient techniques. Oracle features such as partitioning, materialized views, external tables are not done enough justice.
A Recipe for Success
Allow me to bestow some well-deserved praise upon Bert Scalzo's terrific "Oracle DBA Guide to Data Warehousing and Star Schemas".A true gem - I won't go on another Oracle project without it.
Loosely coupled - arrogant attitude
I am uninterested in the authors opinion on this and that. I do not need to be looked down upon because I made something that the author thinks is inappropriate or possibly ridiculous. What I am looking for in a profesional book is vision, possiblity, technique, option and positive experience.
Read more

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

Reviews (10)

A useful doorstop
As a DBA, Data Architect and C# developer,, I need clear, concise and pragmatic examples. My life is busy, I do not have the time to read someone else interpretation of MS ideology. Just give me the beef and let the CPU worry about the rest.
Mediocre at best
If you love XML and SQLCLR, this book is for you.For me, I do most of my work using .NET and T-SQL.This book left me wanting when learning about those topics.I love XML like the next person but having so much dedicated space to it is overkill for most people.Save your money if you're a mainstream SQL Server developer and buy a different book.

Good and Bad
This book has a good explanation of the many new features in SQL Server 2005.However, I can only give it three stars as it is chock full with grammar - and worse, syntactical errors.My binding has also fallen apart in a matter of a few days of reading. ... Read more

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

Reviews (15)

Good book
This is the only guide you need to pass the exam. It may not have the depth, but it covered the objectives well.
10g Certification
If you are planning on taking the Oracle 10g upgrade exam this is the book I used to take the test, and I passed.A few questions on the test on nowhere to be found in the book and that could be because they are new questions or something along those lines.The practice exams are ok and may be a bit easier than the questions on the exam.I looked at some other publishers for Oracle exams and I say Sybex are the ones I am most comfortable with.I purchased this book and scheduled the exam for 6 weeks out.If I would have failed I would have blamed the book :)
Typos, contradictions and poorly worded questions.
I just finished passing the test. I admit this guide helped me study for the test. The guide was well organized and covered the topics in enough depth. The writing was good. However, the typos, mispellings, contradictions, poorly worded questions and just plain bad sample questions and examples were annoying. The sample tests provided by the book were okay, but had typos and problems too. The end of chapter tests had several problems: some questions were poorly phrased or the answers contradicted the main text of the book.
Read more

Subjects:  1. Certification Guides - General    2. Computer Books: Database    3. Computers    4. Computers - Data Base Management    5. Database Management - General    6. Database Management - Oracle    7. Reference - General    8. Relational Databases    9. Tests    10. Computers / Database Management / General    11. Databases & data structures    12. Oracle   

Subjects:  1. Computer Books: General    2. Computers    3. Computers - Languages / Programming    4. Mathematical & Statistical Software    5. Miscellaneous Software    6. Programming Languages - General    7. Programming Languages - SQL   

Subjects:  1. Certification Guides - General    2. Computer Books: Database    3. Computers    4. Computers - Certification    5. Database Management - General    6. Database Management - Oracle    7. Relational Databases    8. Study Guides    9. Computers / Technical Skills    10. Oracle   

Reviews (2)

Not an introductory textbook
The book is intented to serve as an introductory textbook for undergraduate college students.I'll bet that half the class will drop the course before they finish Chapter Four, where the description of E-R diagrams is, at best, utterly confusing.In fact, the author consistently introduces terms and concepts that really have no place in an introductory course on database management. Not because they are not nice to learn, but because the neophyte will be unnecessarily intimidated. Great introductory textbooks make a subject seem less complicated than it actually is, not the other way around.If you already know something about the subject, buy the book because there is quite a bit of good stuff in it. If you are a novice, run the other way.

easy to understand book with lots of great info
I found this book incredibly helpful to understand databases. I think this book offeres a great way to learn a lot of great information about databases and web programming in an easy to understand fashion.After reading this book I can now build amazing web pages that are dynamically generated and integrated with databases. ... Read more

Subjects:  1. Application software    2. Computer Books: General    3. Computer Networks    4. Computers    5. Computers - Data Base Management    6. Database Engineering    7. Database Management - General    8. Database management    9. Development    10. Hardware - Personal Computers - General    11. Information Storage & Retrieval    12. Internet - Web Site Design    13. Web site development    14. Computers / Database Management / General    15. Databases & data structures    16. Internet   

Subjects:  1. Certification Guides - General    2. Computer Books: Database    3. Computers    4. Computers - Certification    5. Database Engineering    6. Database Management - General    7. Tests    8. Computers / Technical Skills    9. Database software    10. SQL   

Reviews (5)

Too much verbage, takes forever to get to the point
If you need to learn XQuery or XPath fast, this is not the book, or you need to skip the first 8 chapters.XQuery and XPath are hardly even mentioned until Chapter 9.The first 8 chapters discuss everything except what is in the title.XML is a pretty boring topic, and excess verbage doesn't help.

A balanced view of XQuery with several excellent use-cases
The authors are XQuery standardization committee members with long tenures at Oracle, thus possessing an unique grounding in that 'other' query language, SQL. As a result, the book is balanced with respect to what SQL/XML and XQuery can respectively do. A number of examples are provided, to illustrate where XQuery is useful and where other query mechanisms might work.

DTD, but little Schema
My only complaint with this book is that it emphasizes DTD over Schema a bit too much. For this and other reasons, I felt the treatment of XML seemed a little dated, and also a bit shallow. ... Read more

Subjects:  1. Computer Books: Database    2. Computers    3. Computers - Languages / Programming    4. Database Management - General    5. Programming Languages - XML    6. Computers / Database Management / General    7. XML   

Reviews (3)

It was written for me only, wasn't it ?
If you use Java and/or Oracle (Or if only you've planned to), this is THE book you miss ! Complete and easy to read, every concept comes with samples and scripts. Full of informations that I didn't find anywhere else, I've learned a lot. When it talks about something I already knows, it does it so well : "There is probably no better ways to explain things".

A complete book for today's developer
I have been working on different projects building enterprise level software involving many J2EE and Database technologies. One of the major frustration facing developers is how "practical information" related to these two worlds are completely isolated from one another, in fact, it is very common to see the majority of today's developers specializing in one of them and completely ignoring the other. The few who actually can keep following up with both can understand and achieve a lot more.
The Ultimate Reference
At first, it look like it will be just to thick a book to go through and get first hand information. It turnd out to be well structured and I have enjoyed picking up just one section at a time.
Read more

Subjects:  1. Computer Books: Languages    2. Computers    3. Computers - Data Base Management    4. Database Management - Oracle    5. Programming Languages - Java    6. Computers / Database Management / General    7. Oracle   

Reviews (10)

Feeling alone in the arene of ORM
I am a proud owner of Visio for Enterprise Architects, the only case tool I own, and I've have also purchased and used T.Halpins text regarding the use if this tool. In this text, Terry goes thru great efforts to promote the use of object role modeling, ORM, in conceptual designs. I am somewhat sceptical about why there no other book or author using ORM in their explanations of conceptual designs. I whish I had $5k to purchase a copy of ERwin so I could be in the main stream.
Don't be mislead
The book is like an ocean, poorly organised. No pictorial representations (which I think is very important when we discuss data modeling). I bought this book to refresh my data modeling knowledge-- disappointing. May be useful for some students to clear some papers, for pros - please find something else.
Award winning
The most in-depth explanation of ORM available today.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. General    8. Relational Databases    9. Computers / Information Storage & Retrieval    10. Databases & data structures    11. Systems management   

Reviews (6)

Easy to read, but ...
I've not decided to get this one before because i already had a couple of SQL books for the 70-228 (Unleashed, 70-228 for Dummies and SQL in 10 min from Ben Forta) book's reviews were not so good either. But ... i went to a major book store last night and i was able to hold the book on my own hands and read some chapters. My 1st impression, after read a few pages quickly, was a good one. Nice explanations...a lot of graphics (i love that, it helped me a lot when i'm studying)It's the kind of book you like to read and you enjoy the lecture at same time. But ... but ... it is not complete and it just gave a quick brief on most of topics.
DEFINITELY Incomplete Information
I bought this book because 1)I have absolutely ZERO experience with Microsoft SQL 2000 and 2)I have used Sybex books in the past to help me gain knowledge of Windows XP and Windows Server 2003, of which I have passed all exams.
Good Contents
Coming from Oracle background I am currently using this book to prepare for my MCDBA certification. I would not rate myself as beginner because I have dealt with MS SQL Server on many occasions but not heavily. I am pacing myself with one chapter a day. So far I read about 5 chapters and I would admit that the content is good. Like any other technical book, this one also has some mistakes. In my case I started seeing the mistake on pages 145 and 146. On those pages the authors stated that to see the file id you need to run in the SQL Analyzer the stored procedure sp_helpdb. That is not true at all it should be sp_helpfile. I caught that mistake quickly because I really understood the previous information given and related to file, and I also tested the stored procedures listed in the book. I did check the errata on sybex website nothing is listed concerning that mistake but there are some other corrected mistakes though on the website.
Read more

Subjects:  1. Certification Guides - General    2. Computer Books: General    3. Computers    4. Computers - Certification    5. Database Management - General    6. Programming Languages - SQL    7. Relational Databases    8. Sql (Programming Language)    9. Computers / Technical Skills    10. Database software    11. SQL   

Reviews (6)

A Great book for a SQL Server 7.0 DBA.
I wish all books were written this well. Good tips, but errors...
I found this book to be an OK reference.However, the author has mistakes in the treatment of RAID levels for DASD.Nice high level view of queuing theory and the basics of using histograms for analysis.

A few tips, but not worth buying
If you find yourself navigating the online bible (SQL Books Online) to figure something out then you are better off buying something else.I was dissapointed that no value was added beyond what you can get from theonline books. ... Read more

Subjects:  1. Computer Books: Database    2. Computers    3. Computers - General Information    4. Database Management - General    5. General    6. Programming Languages - SQL    7. Relational Databases    8. Sql (Programming Language)    9. Computers / General   

Subjects:  1. Computer Books: Database    2. Computers    3. Computers - Data Base Management    4. Database Engineering    5. Database Management - General    6. Database Management - SQL Server    7. Relational Databases    8. Computers / Database Management / General    9. Database software    10. SQL