Australasia's Biggest Online Store

Shop over a million Toys in our Huge New Range

SQL Bible (Bible)
By

Rating
Product Details

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 System Catalog. Chapter 12: SQL and RDBMS Security. Chapter 13: The System Catalog and INFORMATION SCHEMA. Part VI Beyond SQL: Procedural Programming and Database Access Mechanisms. Chapter 14: Stored Procedures, Triggers, and User-Defined Functions. 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, Boolean Algebra, and Set Theory. Index.

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

Ask a Question About this Product More...
Write your question below:
Look for similar items by category
How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling SQL Bible (Bible) on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Item ships from and is sold by Fishpond.com, Inc.
Back to top