Reviews (5)

Good Advanced Organizer
First, I'm not a DBA but I install, maintain, and use SQL Server 2005 in lab and workgroup settings.
First 3 chapters looks promising. After that it is useless
During reading the first 3 chapters. this book was very promising. Thethe author kept repeating himself "I will show you how to do this, to do that". But after the first 3 chapters, his writing becomes dull. Nothing useful to go on reading. Maybe He was rushing to publish this book or the style that he prepared to go into his writing just died out.Whatever reason, one thing I learned from this book is: What a SQL Server DBA is supposed to do on a daily, weekly, monthly basis. I read so many 5 stars books going into details about writing code to backup, restore, scheduling...etc. But those books forget one point: What a SQL Server DBA is supposed to do on a daily basis. Maybe it is not important for an experienced DBA but it may be important for other I.T guys who want to be DBA. That's why we read books for.
Careful
A pet peeve i have w/ Microsoft books is they just mirror the help files. This admin guide is not much more than regurgitated help files. I was hoping for some useful examples, closer to real life problems & solutions. Not there. Plz use the help files in Books Online to look up topics THEN examine the same topic in this book at a local bookstore BEFORE buying it. ... Read more

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

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

Reviews (10)

Outstanding Reference for Database Developers Moving to SQL 2005 From 2000
We have been heavy users (both as developers and administrators) of SQL Server 2000 since it came out in 2000.We were anxious to upgrade to SQL Server 2005 and did so in early 2006.For the first couple of months we largely utilized SQL 2005 in the same way that we had done with SQL 2000 (with the exception of using the new Management Studio) and did not really exploit the new features of SQL 2005.This book definitely opened our eyes to many of the new features of the SQL 2005 database and we are using many of those features in our current development efforts.
Not what I was looking for
If you're looking for a "what's new in SQL Server 2005" this book covers that.If you're looking for a reference book on the product, that goes into how to configure or upgrade from an earlier version--Keep Looking.
Excellent SQL 2005 Coverage
This book does an awesome job of hitting everything that is new in SQL 2005.There is a lot to cover so it doesn't go into deep depth, but it does give you a good overview and points you in the right direction to find more information out on a particular topic by making sure you have a great introduction. ... Read more

Subjects:  1. Client/server computing    2. Computer Books: Database    3. Computers    4. Computers - Languages / Programming    5. Database Management - General    6. Database Management - SQL Server    7. Database management    8. Information Storage & Retrieval    9. Programming Languages - General    10. Programming Languages - SQL   

Features

• Illustrated

Reviews (13)

grammar-based approach can't get off the ground
It seems like most of the people writing reviews for this book already know databases to some degree. I didn't, so I'd like to share my experience.
Wish all beginner books were like this
This book is easy to read, easy to follow and has practice problems at the end of every chapter with the answers in the back. What more could one ask for?
Very helpful, very simple, very direct
I bought "Learning SQL" in order to begin to prepare myself for the Microsoft Certification Exam for SQL Server 2005. I had some prior knowledge of SQL, but almost exclusively in writing SELECT statements. "Learning SQL" broadened my knowledge with its simple, easy to follow chapters. All of the important concepts are explained, and the examples given are very clear and intuitive.
Read more

Subjects:  1. Computer Books: Languages    2. Computers    3. Computers - General Information    4. Computers - Languages / Programming    5. General    6. Programming Languages - SQL    7. Relational databases    8. SQL (Computer program language)    9. Access    10. Computers / Languages / Programming    11. Computers / Programming Languages / SQL    12. SQL    13. sql, structured query language, sql schema,   

Reviews (33)

Best reference guide for designing your SQL Server database
This guide not only provides references on SQL Server syntax, but also contains a brief review of best practices with database design. Includes all normal forms with database normalization, indexing, and data integrity.

BestIT Book I Ever Read
This book is an amazingly clear and concise book, especially for the "non-gurus" among us.The explanations of general topics like normalization, the history of markup languages (in the XML section) are so well written you could give them to management and even they would understand what you are doing (maybe that's not such a good idea).Full of tidbits like why transaction logs grow so much faster than data files.Nielson writes about SQL Server 2000 as used in the real world, not just as an interesting piece of technology.Bravo!I would give it 10 stars if I could.I leave nitpicking to the gurus.

Great for reading and as a reference guide
Very complete and illustrating. I am happy to have it on my desktop. ... Read more

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

Reviews (226)

If you work heavily with T-SQL...
Buy, borrow, or STEAL THIS BOOK!
A must read for anyone who wants to be an expert using TSql
This textbook on TSQL covers not only the basics such as DML, DDL and basic data types, but also talks about advanced topics such as Transactions,Stored procs, Triggers and Performance tuning in very good detail. If you are ever thinking of writing a SQL Server sproc or an app layer on top of it, read this book first.

Not for beginners or for a review of SQL
This book has no coherent structure, but is a conglomeration of tips.Many of the coding examples use fairly complex SQL without explaining it.The join section is laughably short.It is probably most useful for someone already experienced in SQL who can read through it to pull out "tips".I have been away from SQL for a few years and wanted to brush up and this absolutely was not the book to buy.What a waste of money. ... Read more

Subjects:  1. Client-Server Computing - General    2. Computer Books: Database    3. Computers    4. Computers - Languages / Programming    5. Database Engineering    6. Database Management - General    7. Programming - General    8. Programming Languages - SQL    9. SQL (Computer language)    10. SQL (Computer program language    11. SQL (Computer program language)    12. Sql (Programming Language)    13. Computers / Client-Server Computing    14. Database software    15. Databases & data structures    16. SQL   

Editorial Review

When it comes to selecting computer books, deciding which book to buy can sometimes be even more confusing than the software it is written about. However, if you are looking for a book to instruct you on the use of SQL Server 2000, Read more

Reviews (75)

Not bad not good
In general the book is ok. The author needed to make more research in some areas and not made use only of his own experience.
Tiny font
Excellent book, but the font is VERY small which makes reading difficult even though I do not have vision problems.

One of the best!!
I have this book and I can say it is the best SQL Server book I have ever read. It may even be the best Development/Computer book I have. Every chapter is easy to read, detailed and concise. The coverage is phenomenal. I use this for reference quite a bit. The only thing that is missing is more detail on DTS... but that is a book in itself. ... Read more

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

Reviews (6)

The best book for learning and understanding Oracle10g JDeveloper
This latest edition for Oracle10g JDeveloper builds on the success of the previous 9i version. As with the previous version, each chapter is well organized with thorough and accurate examples. Well thought-out attention has been given to explaining Oracle's Application Development Framework (ADF). The authors also go into great depth in explaining how to use the newly improved modeling capabilities of 10g JDeveloper (both their strengths and weaknesses).
oracle jdeveloper 10g handbook
it is wath i was looking for. Complete, simple and perfectly explaned; in one word perfect.

Solid coverage of Oracle backend technologies.
This book was exactly what I needed.I had been struggling for a couple of months to learn all of the pieces needed to build a business application using JDeveloper.I have some Java experience but not a strong J2EE background.There are plenty of resources around that cover XML, Java, JSP/Servlets and non-Oracle frameworks like Struts, Spring and JavaServer Faces (JSF).Don't expect to learn about those things here.But if you are trying to wrap your head around Oracle's Application Development Framework (ADF), this is the place for you.It's the best single source I've seen for that topic.There is a lot of information on the Oracle Technology Network (OTN), but it's scattered and isn't wrapped in a sequential story the way this book's presentation is.Most of ADF Business Component structure has been stable for a couple of years, so the fact that this book is a bit dated doesn't get in the way.
Read more

Subjects:  1. Application software    2. Certification Guides - General    3. Computer Books: Database    4. Computers    5. Computers - Data Base Management    6. Database Management - General    7. Development    8. Java (Computer language)    9. Java (Computer program language)    10. Programming - General    11. Computers / Database Management / General    12. Databases & data structures   

Reviews (10)

Not detailed enough- lacks implementation coverage
I agree with one other poster that this book attempts to cover all major HA features in Oracle in one small book. It is ok for a very high level overview hence the 1 star but falls flat for major details on the individual HA features. Instead my advice is to get The Oracle 9i RAC book from Rampant Press, Oracle Streams book and Oracle Data Guard book all from Rampant Press and read the Oracle concepts manuals for these HA features.

Good book for intermediate DBA's
It is one of the few good books available in the market which covers RAC, DataGuard and Flashback features all in one.
Just overview of Oracle HA technology
The writers like to subsitute the Oracle manual in OTN but make no difference . eg, I wanted to setup the Dataguard through EM10g Grid Control. In fact , the creation standby database wizard was filled of bugs and user can't make use of it till patching and huge manual works. It's no doubt that writers never tried on this features. The book is rather splotchy and winding. ... Read more

Subjects:  1. Computer Books: Database    2. Computers    3. Computers - Data Base Management    4. Database Management - General    5. Database Management - Oracle    6. Oracle (Computer file)    7. Relational Databases    8. Computers / Database Management / General    9. Oracle   

Features

• Illustrated

Reviews (11)

Exceptional SQL Performance Book
'The Art of SQL' by Stephane Faroult is an outstanding book for any and all database developers that want to learn how to write better SQL code and make their database efficiency go UP UP UP!!Encompassing 300+ pages, this well-written and advanced book goes way past the basics of writing SELECT and INSERT statements, taking things to the next level and then some!!
Most Unusual Technical Book
Imagine a cookbook with no recipes but after you read it it helps to become abetter cook.This book does not specifically tells what to do.It does not have codes or technical jargon. It gives you an understanding.The book reads well, it is not full of technical references but it is not to say this book is for someone who does not know the workings of a DBMS.The author draws a relevant parallel between designing a database and waging a war.I enjoyed the quotes thoughtfully peppered in the book.Do me a favor and do not get it...in case we are going after the same job

This is your graduate level course in SQL - how and why
Probably most database solution developers and DBAs have picked up their knowledge of the subject as they have needed it, rather than in a formal and structured (so to speak) method. And even those that have had a structured education probably learned a lot more while in the field. And so there are always gaps. Gaps in technique, but also gaps in the why of many things that I, for example, took for granted about large DBMS's and SQL.
Read more

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

Reviews (5)

The Standard!
I used this book to deploy Oracle Application Server 10g infrastructure on Linux and UNIX. I felt that it was a good book and overall I have little ill to say about it. The examples are well written and do a good job of reinforcing what you read in the handbook. You read a little then do an example, then read some more, then add to the example and so on. You don't need any Administrative experience to use this book just a decent understanding of application design. The only criticism I could offer is that the editor should have used arrows when content is being continued on a new line for reasons of page space so that readers will know and understand (beginners can have trouble with this). It's a good book for learning Oracle Application Server 10g as a whole from the ground up and for this reason it's worth the money. It's not an overnight crash course (if that is what you are looking for).

Very Nice Job
I have taken the iAS 10 Admin I course from Oracle, and wish that I read this book prior to the class.I found it very valuable especially if you are deploying iAS 10g (9.0.4) on Linux.I highly recommend the book to iAS administrators/DBA's.

Summary of the White Papers
As an administrator/implementor of these systems, there are many aspects to administering the 10gAS system. Although the authors do make reference the book intends to simplify the rather large amount of documentation, it falls short of a complete guide.
Read more

Subjects:  1. Application software    2. Certification Guides - General    3. Computer Books: Database    4. Computers    5. Computers - Data Base Management    6. Database Management - General    7. Database Management - Oracle    8. Database management    9. Development    10. Oracle (Computer file)    11. Web servers    12. Computer Communications & Networking    13. Computers / Database Management / General    14. Databases & data structures    15. Oracle   

Reviews (3)

Good coverage of Oracle SQL
The content look deceptively simple. However upon further reading one finds that it covers many aspects or ORACLE SQL plus differences between ORACLE and ANSI standard.
Comprehensive on basics but weak on advanced features
The book improves with each edition. The brief data modeling section is adequate but uses Information Engineering data models and should be updated to use UML. The treatment describing joins fails to adequately explain why you chose one over the other.
This book is Awesome!!
This book by Alice Rischert is one of the greatest Oracle SQL books ever written.I purchased the 1st edition of this book back in the day and it helped me pass the Oracle 8i OCP SQL exam.After reading the 1st edition, I was very much compelled to purchase the 3rd edition.The 3rd edition of the book is much better with all the errors from the previous versions corrected.This is the book they use for the students at Columbia University in New York.After you read this book and do all the exercises and test your thinking projects, you become a master of the subject.If you want to learn Oracle SQL, there is no greater learning tool than this book.Indeed, there is much time, effort, and loads of quality and research put into this book.The format of the book is reading and then hands-on labs which reinforce the topics you just read.After you read this book you should purchase the Oracle PL/SQL by Example third edition.It goes hand-in-hand with this book.AFterward, you'll know enough to go take the Oracle SQL and PL/SQL exam. ... Read more

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

Features

• Illustrated

Reviews (25)

A real page turner
This book is so interesting that on a couple occasions I've fallen asleep reading it, because I want to "find out what happens next" -- not because it is boring.Even the chapter on queueing theory that has a lot of math in it is understandable and interesting, even though I have a mild aversion to math.
Superb book
I like the wait approach very much.DIS buk prezNts a scientific approach 2 prob diagnosis & performance optimization. DIS aLowz optimization F4tz 2 b consistent & repeatable. DIS buk tAkz Oracle prob diagnosis & tuning out of d realm of bn a BWO art.
Excellent performance book
I purchased this book and did not open it for about 4 months.After reading the first 25 pages or so I became motivated to read more and finish it.It took me about 2 weeks to read through the entire book. The author does a really good job of detailing how to use Oracle tracing to troubleshoot performance related issues.With no shortage of Oracle performance tuning books this is definitely one of the better ones.This book must be one of the best performance related books because you can read it cover to cover.The book is packed with detail so you will reread several pages a few times, kind of like being in college and spending a couple of hours reviewing a couple of pages out of Calculus book.
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. Programming Languages - General    9. Relational databases    10. SQL (Computer program language    11. SQL (Computer program language)    12. Computers / Data Base Management    13. Computers / Database Management / General    14. Computers/Programming Languages - General    15. Oracle   

Reviews (15)

I am yet to receive this book
The tentative date of receipt is 27th Jan 2006 but to i haven't received the book as of today.
Excellent Oracle reference tool
I was part of the Oracle implementation team at our company, and I have found this book to be a useful tool for myself in the year since implementation as we continue to explore new functionalities. It is also a useful tool for the application users to learn how Oracle works.In fact, I not only purchased this book for myself, but I have purchased copies for several other people in the company.I refer to it all the time.

Good Book for the beginners
This book is very useful for the beginners as well those who want to brush up their knowledge on oracle applications release 11i.
Read more

Subjects:  1. Business logistics    2. CAD-CAM - General    3. Certification Guides - General    4. Computer Books: Database    5. Computers    6. Computers - Data Base Management    7. Data processing    8. Database Management - General    9. Database Management - Oracle    10. Database design    11. Manufacturing    12. Manufacturing processes    13. Oracle (Computer file)    14. Production Engineering    15. Relational Databases    16. Computers / Technical Skills    17. Distribution & warehousing management    18. Oracle    19. Production & quality control management   

Reviews (3)

Excellent, Excellent book
I own about 30 books about Access (all versions). This book tops all of them. If you are using Access 2000 or 2002(XP) and you like to know about SQL Server (2000), trust me this is it. Try to read it from begining to the end. It's written in english language (not technical slang) and it shows you some cool tricks even for those Access 97 users. Hope to see more books from these guys. Thanks

Exellent Resource for SQL Server and Access
This book is well written and easy to follow.The explanations are written in clear language and instructions are written out step by step.The book is well organized which means it's easy to use it more as a reference book.But, it is such a pleasure to read, you want want to skip a single page.This book covers both very elemental aspects of SQL, but also has much to offer the more experienced user.

Simply the best - is #1 in my top 3 books to "use".
I read a lot of books covering topics from Access, SQL Server, to VBA.This book covers all of the "required" Access topics.It covers them better than any other book I have ever seen.It then goes on to cover topics I have not seen in other books or classes.While reading the book you will catch yourself saying why have I never seen this before, or hey I can use this! It uses Jet, Transact & VBA. Do you want to build better applications, do you want to know more than the competition, do you want to be a better developer?If so, this book is a definite purchase.Read more

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

Reviews (2)

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
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. ... Read more

Subjects:  1. Computer Books: General    2. Computers    3. Computers - Languages / Programming    4. Computers / Programming / Software Development    5. Hardware - Personal Computers - General    6. Programming - General    7. Programming Languages - General    8. Programming Languages - SQL    9. Programming - Software Development   

Reviews (10)

Very good book
This book is very good. I've had the book for a month now, and use it every day. It is good because it covers both SQL and PL/SQL, as well as all the latest Oracle 10g database features.
Even better than the last edition
Like the previous version, this is even better written. For starters to PL/SQL I recommend PL/SQL 101 and this.
Only SQL and PL/SQL book I actually use
I have three SQL and PL/SQL books, but this one is the only one I actually _use_ on a daily basis. It's a great book because it acts as both a training guide and reference book.Read more

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

Editorial Review

Tom Kyte is of a rare breed. To begin, he's technically expertin his subject (administration of and development of applications forOracle database management systems). What's more (and whatdistinguishes him from the ranks of the super-competent), he is bothable and willing to share his considerable store of wisdom with Oracleusers via books like Read more

Reviews (77)

Best $12 I ever spent!!!
I bought this book on cheap clearance after the original publisher went out of business -- the best $12 I ever invested.Remembering even 10% of this book makes you better than 90% of Oracle developers, modelers and architects.Mr. Kyte's real world experience and reliance on solid examples instead of folklore makes this light-years ahead of any other Oracle book; it's the only Oracle book I re-read regularly.If you can afford only one Oracle book, this is it.And you may not need any other.

Fantasic
A true masterpiece, and a great way to learn Oracle concepts.No more to say.

Detailed and well explained
Thick Oracle book which is intended for developers who might need to understand the Oracle internals and administration parts besides writing SQL. It's useful for them working in other database also as the general database concept is simlar. Developers can now have more DBA knowledges after reading before on-going performing some DBA task. ... Read more

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

Reviews (2)

If you want to learn DB2/SQL this is a MUST HAVE
Buy this book!!! ... I wanted All You Need To Learn DB2
This is an excellent resource for all those baffled programmers who need to learn DB2 fast. Thos book provides clear-cut examples, syntax, and the results of the various SQL commands that are most likely to be needed byany programmer. All the basics from simple SELECT statements are coveredall the way up to ORDER BY clauses, joins and so on. A special chapter onusing SPUFI was also a big help. The emphasis here is on the COBOL languageand mainframe computers, but it is an excellent learning tool for anyone.The book teaches by example and can be finished easily within a week (Theexample programs are what make it look so big). A must-read for anyoneinterested in relationall databases. ... Read more

Subjects:  1. COBOL (Computer program langua    2. COBOL (Computer program language)    3. Computer Books: Web Programming    4. Computers    5. Computers - Languages / Programming    6. Database Management - General    7. Database management    8. IBM Database    9. Programming - General    10. Programming Languages - COBOL    11. Programming Languages - SQL    12. SQL (Computer program language    13. SQL (Computer program language)    14. Sql (Programming Language)    15. Cobol    16. Database software    17. SQL   

Editorial Review

Aiming for developer-level OCP status? The Read more

Reviews (68)

A very bad book
This book doesn't cost its money.

This book worked for me
I used this book, and one other, to take and pass the Oracle Certified Professional exam (OCP).The other book I used was Oracle Press' PL/SQL Program Units Exam Guide, which focuses just on the second exam.This book covers all of the exams, but the second exam is especially difficult, and a friend recommended that one for that exam specifically. Too basic
Good book for a beginner (this is an excellent intro to SQL and PL/SQL), but not enough depth for the exams.It covers all the necessary areas, but barely skims the surface on numerous important topics.I recommend the Sybex book (even though it's a little dry).For each test, I'd start with this book and then move on to another text; that should be all you need to pass the exams.Be sure to PRACTICE; that's by far the most important element of success. ... Read more

Subjects:  1. Certification    2. Certification Guides - General    3. Computer Books: General    4. Computers    5. Computers - Certification    6. Database Engineering    7. Database Management - Data Warehousing    8. Database Management - General    9. Database Management - Oracle    10. Database management    11. Electronic data processing per    12. Electronic data processing personnel    13. Examinations    14. Microcomputer Application Software    15. Oracle (Computer file)    16. Study guides