SQL Bible [Paperback]

Alex Kriegel (Author), Boris M. Trukhnov (Author)

Book Description

Publication Date: April 7, 2008 | ISBN-10: 0470229063 | ISBN-13: 978-0470229064 | Edition: 2

Combining theory with everyday practicality, this definitive volume is packed with the up-to-date information, new features, and explanations you need to get the very most out of SQL and its latest standard. The book is unique in that every chapter highlights how the new SQL standard applies to the three major databases, Oracle 11g, IBM DB2 9.5, and Microsoft SQL Server 2008. The result is a comprehensive, useful, and real-world reference for all SQL users, from beginners to experienced developers.

Editorial Reviews

From the Back Cover

Harness SQL for Oracle 11g, IBM DB2, and Microsoft SQL Server 2008

Combining theory with everyday practicality, this deޮitive volume is packed with up-to-date information, new features, and explanations you need to get the very most out of SQL and its latest standard. The book is unique in that every chapter highlights how the new SQL standard applies to the three major databases, Oracle 11g, IBM DB2 9.5, and Microsoft SQL Server 2008. The result is a comprehensive, useful, and real-world reference for all SQL users, from beginners to experienced developers.

• Learn the basics of SQL and relational databases

• Explore tables, views, sequences, and other database objects

• Examine transactions and locking in multiuser environments

• Review functions mandated by the SQL standard and the three major vendors

• Access metadata information and implement database security

• Go beyond SQL to XML integration, OLAP business intelligence, and more

Companion Web Site
Find downloadable code examples, a full book description, and more at wiley.com/go/SQLBible2.

About the Author

Alex Kriegel, PMP, MCSD/MCTS, works as a Systems Architect for the State of Oregon; prior to this he worked for Pope and Talbot, Inc., Psion Teklogix International, Inc., and for Belorussian Academy of Sciences. He received his MSc. in Physics of Metals from Belarus State Polytechnic Institute in 1988, discovered PC programming and relational databases in 1992, and has never looked back since. Alex is certified as a Project Management Professional (PMP) by the Project Management Institute, and also holds various Microsoft certifications. He is also the author of Microsoft SQL Server 2000 Weekend Crash Course (Wiley, 2001), SQL Functions (Wrox, 2005), and co-author of Introduction to Database Management (Wiley, 2007), and the first edition of this book.

Boris M. Trukhnov, OCP, has been working as Senior Technical Analyst/Oracle DBA for Pope & Talbot, Inc., in Portland, Oregon, since 1998. His previous job titles include Senior Programmer Analyst, Senior Software Developer, and Senior Operations Analyst. He has been working with SQL and relational databases since 1994. Boris holds a B.S. in Computer Science from the University of Minnesota. He is a co-author of Introduction to Database Management (Wiley, 2007).

Product Details

• Paperback: 888 pages
• Publisher: Wiley; 2 edition (April 7, 2008)
• Language: English
• ISBN-10: 0470229063
• ISBN-13: 978-0470229064
• Product Dimensions: 9.3 x 7.3 x 1.9 inches
• Shipping Weight: 2.9 pounds (View shipping rates and policies)
• Average Customer Review: 4.2 out of 5 stars  See all reviews (20 customer reviews)
• Amazon Best Sellers Rank: #54,678 in Books (See Top 100 in Books)
  • #39 in Books > Computers & Technology > Databases > SQL

Customer Reviews

Most Helpful Customer Reviews

26 of 29 people found the following review helpful:

5.0 out of 5 stars Excellent book to learn SQL and RDBMS concepts, May 15, 2003

By A Customer

This review is from: SQL Bible (Paperback)

I was not interested in learning just SQL per se, I also wanted to get some RDBMS experience. This is what had drawn my attention to SQL Bible: it concentrates on three major RDBMS packages (with all due respect, I can't imagine making decent living with Open Source databases like MySQL : ) ), makes comparisons, explains THEIR implementations - just what I needed (do not believe anyone who tells you that ANSI SQL is all you need to know to work in the field!) I installed DB2 Personal Edition (included with the book), and the installation was a snap! All I had to do was to follow very detailed and clear instructions in Appendix D; again, following instructions I have created a database and installed all authors scripts. The scripts were in the place where the book says they should, and I have not encountered a single problem running them... I was pleasantly surprised because this is where the most books fail: missing files, confusing "best-case-scenario" instructions... Not here! It's a shame that Oracle 9i installation was not included; I had to download it separately following instructions in the book (p.638.) Oracle 9i takes over 1.5 GB of space - 3 (!) CDs. It took me awhile, even with my cable connection speed... The only glitch I found so far was that the CD claims to contain MS SQL Server, but has DB2 8.1 for Windows instead (just as it says on the book's back cover.)

14 of 15 people found the following review helpful:

5.0 out of 5 stars Starts from scratch, May 28, 2004

By 

Alois van Klinken (USA) - See all my reviews

This review is from: SQL Bible (Paperback)

An excellent, easy to follow text. While I had known SQL prior to this, it is not a necessity for anyone. The author is skilled at covering all the salient points of SQL, and gives plenty of clear examples.

I recommend it to anyone who needs a thorough education in SQL. It will take you some time to get thru it. Sheer size of the book. But well worth your time.

Alois

10 of 10 people found the following review helpful:

5.0 out of 5 stars Top SQL99 reference for DB2 8.1, Oracle9i, MS SQL 2000, November 12, 2003

By 

Suresh Chanmugam (Ontario Canada) - See all my reviews
(REAL NAME)   

This review is from: SQL Bible (Paperback)

The best reference for the SQL99 standard. Each SQL command is provided first by syntax followed by its variations for DB2 8.1, Oracle 9i and SQL server 2000 making the book a ONE STOP SHOP. An example in code form is included for the command being referred to. Whenever there is a custom feature of a command for a given RDBMS (say Oracle 9i) that does not exist in another (say SQL server 2000) the author will try to show you a work around in obtaining that unavailable feature if possible. The CD Rom included with the book comes with DB2 V8.1 (personal edition for windows) and most importunately the PDF version of the book as well. Thoughtfully organized into basic concepts, DDL, DML, Transactions and more. Good for Intermediate plus or a smart Junior programmer.