SQL Bible

Alex Kriegel

ISBN 10: 0470229063 / ISBN 13: 9780470229064

Published by John Wiley and Sons Ltd, 2008

About this Item

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. Series: Bible. Num Pages: 888 pages, ill. BIC Classification: UMT; UNS. Category: (P) Professional & Vocational. Dimension: 235 x 188 x 46. Weight in Grams: 1570. . 2008. 2nd Edition. Paperback. . . . . Books ship from the US and Ireland.

Seller Inventory # V9780470229064

Bibliographic Details

• Title: SQL Bible
• Publisher: John Wiley and Sons Ltd
• Publication Date: 2008
• Language: English
• ISBN 10: 0470229063
• ISBN 13: 9780470229064
• Binding: Soft cover
• Edition: 2nd Edition
• Condition: New

About this title

Synopsis

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

Combining theory with everyday practicality, this definitive 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 and more at www.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).