SQL Bible

( 4 )

Overview

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

See more details below
Other sellers (Paperback)
  • All (11) from $23.51   
  • New (5) from $36.12   
  • Used (6) from $23.52   
Sending request ...

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9780470229064
  • Publisher: Wiley
  • Publication date: 4/7/2008
  • Series: Bible Series , #742
  • Edition number: 2
  • Pages: 888
  • Sales rank: 1,345,775
  • Product dimensions: 9.34 (w) x 9.70 (h) x 1.82 (d)

Meet the Author

Alex Kriegel, PMP, MCSD/MCTS, works as a SystemsArchitect for the State of Oregon; prior to this he worked for Popeand Talbot, Inc., Psion Teklogix International, Inc., and forBelorussian Academy of Sciences. He received his MSc. in Physics ofMetals from Belarus State Polytechnic Institute in 1988, discoveredPC programming and relational databases in 1992, and has neverlooked back since. Alex is certified as a Project ManagementProfessional (PMP) by the Project Management Institute, and alsoholds various Microsoft certifications. He is also the author ofMicrosoft SQL Server 2000 Weekend Crash Course (Wiley,2001), SQL Functions (Wrox, 2005), and co-author ofIntroduction to Database Management (Wiley, 2007), and thefirst edition of this book.

Boris M. Trukhnov, OCP, has been working as SeniorTechnical Analyst/Oracle DBA for Pope & Talbot, Inc., inPortland, Oregon, since 1998. His previous job titles includeSenior Programmer Analyst, Senior Software Developer, and SeniorOperations Analyst. He has been working with SQL and relationaldatabases since 1994. Boris holds a B.S. in Computer Science fromthe University of Minnesota. He is a co-author of Introductionto Database Management (Wiley, 2007).

Read More Show Less

Table of Contents

Acknowledgements.

Introduction.

Part I SQL Basic Concepts and Principles.

Chapter 1: SQL and Relational Database Management Systems.

Chapter 2: Fundamental SQL Concepts and Principles.

Chapter 3: SQL Data Types.

Part II Creating and Modifying Database Objects.

Chapter 4: Creating RDBMS Objects.

Chapter 5: Altering and Destroying RDBMS Objects.

Part III Data Manipulation and Transaction Control.

Chapter 6: Data Manipulation Language (DML).

Chapter 7: Sessions, Transactions, and Locks.

Part IV Retrieving and Transferring Data.

Chapter 8: Understanding the SELECT Statement.

Chapter 9: Multitable Queries.

Chapter 10: SQL Functions.

Chapter 11: SQL Operators.

Part V Implementing Security Using the SystemCatalog.

Chapter 12: SQL and RDBMS Security.

Chapter 13: The System Catalog and INFORMATION SCHEMA.

Part VI Beyond SQL: Procedural Programming and DatabaseAccess Mechanisms.

Chapter 14: Stored Procedures, Triggers, and User-DefinedFunctions.

Chapter 15: SQL and XML.

Chapter 16: SQL and Procedural Programming.

Chapter 17: The Future of SQL.

Appendix A: Accompanying Website.

Appendix B: The ACME Sample Database.

Appendix C: Basics of Relational Database Design.

Appendix D: Installing RDBMS Software.

Appendix E: Accessing RDBMS.

Appendix F: Installing the ACME Database.

Appendix G: SQL Functions.

Appendix H: SQL Syntax Reference.

Appendix I: SQL-Reserved Keywords.

Appendix J: The Other RDBMSs.

Appendix K: A Brief Introduction to Number Systems, BooleanAlgebra, and Set Theory.

Index.

Read More Show Less

Customer Reviews

Average Rating 4
( 4 )
Rating Distribution

5 Star

(2)

4 Star

(0)

3 Star

(1)

2 Star

(1)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 4 Customer Reviews
  • Anonymous

    Posted April 24, 2003

    Not a moment too soon!

    I was hired to help migrate SQL Server based system to ORACLE (knowing very little about either of them; can't afford to be picky nowadays.) This book saved me time browsing through tons of vendors documentation, and ultimately - my bacon.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted May 21, 2009

    No text was provided for this review.

  • Anonymous

    Posted May 21, 2009

    No text was provided for this review.

  • Anonymous

    Posted August 3, 2010

    No text was provided for this review.

Sort by: Showing all of 4 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)