SQL Bible, 2nd Edition
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.
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).
|Sample Database||32.42 KB||Click to Download|
|Chapter Code||43.90 KB||Click to Download|
|Read Me||932 bytes||Click to Download|
Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.