eTutorials.org

Tutorial: Sql bible

Please select a chapter from the "Contents" menu at the very bottom of the page.

Sql bible

BackCover SQL Bible Preface How This Book Is Organized Conventions Used in This Book Acknowledgments Part I: SQL Basic Concepts and Principles Chapter 1: SQL and Relational Database Management Systems (RDBMS) Selecting Your Database Software Everything in Details: DBMS Implementations Real-Life Database Examples Database Legacy Relational Databases Object Database and Object-Relational Database Models Brief History of SQL and SQL Standards Summary Chapter 2: Fundamental SQL Concepts and Principles SQL: The First Look Any Platform, Any Time Summary Chapter 3: SQL Data Types No Strings Attached In Numbers Strength Once Upon a Time: Date and Time Data Types Object and User-Defined Data Types Other Data Types NULL Summary Part II: Creating and Modifying Database Objects Chapter 4: Creating RDBMS Objects Tables Views Aliases and Synonyms Schemas Other SQL99 and Implementation-Specific Objects CREATE Statement Cross-Reference Summary Chapter 5: Altering and Destroying RDBMS Objects Tables Views Aliases and Synonyms Schemas Other Implementation-Specific Objects ALTER and DROP Statements Cross-Reference Summary Part III: Data Manipulation and Transaction Control Chapter 6: Data Manipulation Language (DML) INSERT: Populating Tables with Data UPDATE: Modifying Table Data DELETE: Removing Data from Table Other SQL Statements to Manipulate Data Summary Chapter 7: Sessions, Transactions, and Locks Sessions Transactions Understanding Locks Summary Part IV: Retrieving and Transforming Data Chapter 8: Understanding SELECT Statement Single Table SELECT Statement Syntax SELECT Clause: What Do We Select? FROM Clause: Select from What? WHERE Clause: Setting Horizontal Limits GROUP BY and HAVING Clauses: Summarizing Results ORDER BY Clause: Sorting Query Output Combining the Results of Multiple Queries Summary Chapter 9: Multitable Queries Inner Joins Outer Joins: Joining Tables on Columns Containing NULL Values Joins Involving Inline Views Multitable Joins with Correlated Queries Improving Efficiency of Multitable Queries Summary Chapter 10: SQL Functions Summary Chapter 11: SQL Operators Arithmetic Operators Logical Operators Operator Precedence Assignment Operator Comparison Operators Bitwise Operators User-defined Operators Summary Part V: Implementing Security Using System Catalogs Chapter 12: SQL and RDBMS Security Defining a Database User Managing Security with Privileges Managing Security with Roles Using Views for Security Using Constraints for Security Using Stored Procedures and Triggers for Security Database Auditing Security Standards Summary Chapter 13: The System Catalog and INFORMATION_SCHEMA Oracle 9i Data Dictionary IBM DB2 UDB 8.1 System Catalogs Microsoft SQL Server 2000 System Catalog Summary Part VI: Beyond SQL--Procedural Programming and Database Access Mechanisms Chapter 14: Stored Procedures, Triggers, and User-Defined Functions Procedural Extension Uses and Benefits Key Elements of a SQL Procedural Language Stored procedures User-Defined Functions Triggers Summary Chapter 15: Dynamic and Embedded SQL Overview SQL Statement Processing Steps Embedded (Static) SQL Dynamic SQL Techniques The Future of Embedded SQL Summary Chapter 16: SQL API Microsoft Open Database Connectivity (ODBC) Java Database Connectivity (JDBC) IBM DB2 UDB Call-Level Interface (CLI) Oracle Call Interface (OCI) Oracle Objects for OLE (OO4O) Microsoft Data Access Interfaces Summary Chapter 17: New Developments--XML, OLAP, and Objects XML OLAP and Business Intelligence Objects Summary Part VII: Appendix Appendix A: What's on the CD-ROM Using the CD with Windows What's on the CD Troubleshooting Appendix B: The ACME Sample Database General Information and Business Rules Naming Conventions Relationships Between Tables Column Constraints and Defaults SQL Scripts to Create ACME Database Objects Appendix C: Basics of Relational Database Design Identifying Entities and Attributes Normalization Specifying Constraints Pitfalls of Relational Database Design Appendix D: Installing RDBMS Software Installing IBM DB2 UDB 8.1 Personal Edition Installing Microsoft SQL Server 2000 Appendix E: Accessing RDBMS Using IBM DB2 UDB 8.1 Command-Line Processor (CLP) Using Microsoft SQL Server Utilities to Access Database Appendix F: Installing the ACME Database Installing the ACME Database on Oracle 9i (Unix/Linux) Using SQL*Plus Installing the ACME Database on DB2 UDB 8.1 (Windows) Using CLP Installing ACME Database on Microsoft SQL Server 2000 Using OSQL Utility Appendix G: SQL Functions Appendix H: SQL Syntax Reference DDL Statements DCL Statements DML Statements DQL Statements Transactional Control Statements Predicates Appendix I: SQL-Reserved Keywords Future Keywords ODBC Reserved Keywords Appendix J: SQL99 Major Features Compliance Across Different RDBMS Appendix K: The Other RDBMS Appendix L: A Brief Introduction to the Number Systems, Boolean Algebra, and Set Theory The Number Systems Logic Elements of Boolean Algebra Set Theory List of Figures List of Tables List of Code Examples List of Sidebars CD Content