Flylib.com
List of Tables
Previous page
Table of content
Next page
Chapter 1: SQL and Relational Database Management Systems (RDBMS)
Table 1-1: Maximum Name Length Restrictions for Some of Database Objects
Table 1-2: Flat File Records Keeping
Chapter 2: Fundamental SQL Concepts and Principles
Table 2-1: Key SQL99 Areas
Table 2-2: Four Basic SQL Statements
Chapter 3: SQL Data Types
Table 3-1: Major Vendor Implementations Character String Data Types
Table 3-2: Binary String Data Types
Table 3-3: Exact Numeric Data Types
Table 3-4: Approximate Numeric Data Types
Table 3-5: Date and Time Data Types
Table 3-6: Interval Literals in Oracle
Chapter 4: Creating RDBMS Objects
Table 4-1: Valid CREATE Statements Cross-Reference
Chapter 5: Altering and Destroying RDBMS Objects
Table 5-1: Valid ALTER Statements Cross-Reference
Table 5-2: Valid DROP Statements Cross-Reference
Chapter 7: Sessions, Transactions, and Locks
Table 7-1: SQL Standard SET Statements
Table 7-2: Microsoft SQL Server 2000 SQL-92 Settings
Table 7-3: Microsoft SQL Server 2000 SET Statements
Table 7-4: Vendor-Specific ROLLBACK Statements
Table 7-5: SQL99 Transaction Isolation Levels
Table 7-6: Oracle 9
i
Lock Modes
Table 7-7: Microsoft SQL Server 2000 Lock Modes
Table 7-8: Microsoft SQL Server 2000 Locking Hints
Chapter 10: SQL Functions
Table 10-1: Standard SQL2 Functions
Table 10-2: Numeric Functions
Table 10-3: String Functions
Table 10-4: Date and Time Functions
Table 10-5: Getting Current Date Out of RDBMS
Table 10-6: Valid Range of the Time-Zone Values for Oracle's NEW_TIME Function:
Table 10-7: Aggregate Functions
Table 10-8: Conversion Functions
Table 10-9: Formatting MS SQL Server CONVERT Function Output for Dates
Table 10-10: Selected Oracle Datetime Format Templates
Table 10-11: Selected Oracle Number Format Templates
Table 10-12: IBM DB2 UDB Date Strings Formats
Table 10-13: IBM DB2 UDB Time String Formats
Table 10-14: Miscellaneous Functions
Chapter 11: SQL Operators
Table 11-1: Arithmetic Operators
Table 11-2: SQL Logical Operators
Table 11-3: Wildcard Characters for use with Operator LIKE
Table 11-4: Operators Precedence
Table 11-5: Comparison Operators
Table 11-6: Bitwise Operators
Table 11-7: Data Type Compatibility for Bitwise Operands
Chapter 12: SQL and RDBMS Security
Table 12-1: Selected Microsoft SQL Server 2000 User Management
Table 12-2: GRANT Statement Options
Table 12-3: Common Oracle 9
i
System Privileges
Table 12-4: Oracle 9
i
SYSDBA and SYSOPER System Privileges
Table 12-5: Common IBM DB2 UDB System Privileges
Table 12-6: SQL Object-Level Privileges
Table 12-7: IBM DB2 UDB Object-Level Privileges
Table 12-8: Oracle 9
i
Predefined Roles
Table 12-9: IBM DB2 UDB System Authorities
Table 12-10: Microsoft SQL Server Fixed Server Roles
Table 12-11: Microsoft SQL Server Fixed Database Roles
Table 12-12: Selected Microsoft SQL Server 2000 Role Management System-Stored Procedures
Table 12-13: IBM DB2 UDB Encryption Functions
Table 12-14: Oracle 9
i
Audit Levels
Table 12-15: Oracle 9
i
AUDIT Level Options
Table 12-16: IBM DB2 UDB Events Categories Available for Audit
Table 12-17: Microsoft SQL Server 2000 Event Categories
Chapter 13: The System Catalog and INFORMATION_SCHEMA
Table 13-1: SQL Standard INFORMATION_SCHEMA Views
Table 13-2: Static View Prefixes
Table 13-3: Selected Oracle Data Dictionary views
Table 13-4: Oracle Data Dictionary Views Correspondence to SQL99 INFORMATION_SCHEMA.
Table 13-5: Selected IBM DB2 UDB INFORMATION_SCHEMA Views
Table 13-6: INFORMATION_SCHEMA Views Column Names
Table 13-7: Updateable IBM DB2 UDB INFORMATION_SCHEMA Views
Table 13-8: Microsoft SQL Server 2000 INFORMATION_SCHEMA Views
Table 13-9: Microsoft SQL Server 2000 System Stored Procedure Categories
Table 13-10: Result Set Returned by sp_tables System Stored Procedures
Chapter 15: Dynamic and Embedded SQL Overview
Table 15-1: Data type Correspondence
Table 15-2: Indicator Variable Values (Input)
Table 15-3: Indicator Variable Values (Output)
Table 15-4: Selected SQLSTATE Codes
Table 15-5: Useful Embedded SQL Statements
Table 15-6: ANSI/ISO SQL Data type Codes
Chapter 16: SQL API
Table 16-1: SQL/CLI and ODBC Functions
Table 16-2: JDBC 3.0 Features
Table 16-3: Selected JDBC Drivers Vendors
Table 16-4: DB2 CLI vs. DB2 ODBC Driver Comparison
Table 16-5: OCI Compatibility Between Different Versions of Server and Client Software
Table 16-6: Selected Oracle OCI Functions
Table 16-7: ADO.NET Top Level Namespaces
Chapter 17: New Developments—XML, OLAP, and Objects
Table 17-1: The RDBMS/OODBMS Standards Comparison
Table 17-2: Database Products Supporting Pure OO Technology
Appendix C: Basics of Relational Database Design
Table C-1: "One Table" Design
Table C-2: Table CUSTOMER after First Normal Form
Table C-3: New ORDER Table
Table C-4: Table CUSTOMER after Second Normal Form
Table C-5: New ORDER Table
Table C-6: New PRODUCT Table
Table C-7: Table CUSTOMER After First Normal Form
Table C-8: New REGION Table
Appendix D: Installing RDBMS Software
Table D-1: Installation of Oracle on Windows: Platforms Requirements
Table D-2: Installation of Oracle on Sun Solaris: Platforms Requirements
Table D-3: Unix Environment Variables Necessary for Oracle 9
i
Installation on Sun Solaris Platform
Table D-4: Installation of Oracle on Linux: Requirements Overview
Table D-5: Environment Variables Necessary for Oracle 9i Installation on Linux
Table D-6: Installation of DB2 UDB on Windows: Platforms Requirements
Table D-7: Requirements for MS SQL Server Installation on Windows 2000
Appendix E: Accessing RDBMS
Table E-1: Most Commonly Used SQL*Plus Commands
Table E-2: Common CLP Options
Table E-3: Common CLP commands
Table E-4: Basic OSQL Commands
Appendix F: Installing the ACME Database
Table F-1: Common Errors from Running Oracle Scripts
Table F-2: Common Errors from Running DB2 Scripts
Table F-3: Common Errors from Running MS SQL Server Scripts
Appendix G: SQL Functions
Table G-1: Oracle 9
i
SQL Number Functions
Table G-2: Oracle 9
i
SQL Character Functions
Table G-3: Oracle 9
i
SQL Datetime Functions
Table G-4: Oracle 9
i
SQL Conversion Functions
Table G-5: Oracle 9
i
SQL Miscellaneous Single-Row Functions
Table G-6: Oracle 9
i
SQL Aggregate Functions
Table G-7: Oracle 9
i
SQL Analytic Functions
Table G-8: Oracle 9
i
SQL Object Reference Functions
Table G-9: IBM DB2 UDB Built-in Scalar Functions
Table G-10: IBM DB2 UDB Built-in Column Functions
Table G-11: IBM DB2 UDB Built-in Table Functions
Table G-12: IBM DB2 UDB Built-in Procedures
Table G-13: Microsoft SQL Server 2000 Built-in String Functions
Table G-14: Microsoft SQL Server 2000 Built-in Mathematical Functions
Table G-15: Microsoft SQL Server 2000 Built-in Date and Time Functions
Table G-16: Microsoft SQL Server 2000 Built-in Aggregate Functions
Table G-17: Microsoft SQL Server 2000 Built-in Text and Image Functions
Table G-18: Microsoft SQL Server 2000 Built-in Cursor Functions
Table G-19: Microsoft SQL Server 2000 Built-in Metadata Functions
Table G-20: Microsoft SQL Server 2000 Built-in Configuration Functions
Table G-21: Microsoft SQL Server 2000 Built-in Security Functions
Table G-22: Microsoft SQL Server 2000 Built-in System Functions
Table G-23: Microsoft SQL Server 2000 Built-in System Statistical Functions
Table G-24: Microsoft SQL Server 2000 Built-in Rowset Functions
Appendix H: SQL Syntax Reference
Table H-1: Simplified BNF Notation
Table H-2: Predicates
Appendix J: SQL99 Major Features Compliance Across Different RDBMS
Table J-1: SQL99-Defined Features across RDBMS
Appendix K: The Other RDBMS
Table K-1: RDBMS Software Vendors
Appendix L: A Brief Introduction to the Number Systems, Boolean Algebra, and Set Theory
Table L-1: Number Systems
Table L-2: Binary Number Represented in Hexadecimal Groups
Table L-3: Binary to Decimal Conversion
Table L-4: Decimal to Binary Conversion
Table L-5: NOT Truth Table
Table L-6: AND Truth table
Table L-7: OR Truth table
Table L-8: XOR Truth table
Table L-9: NAND Truth table
Table L-10: NOR Truth table
Table L-11: Boolean Algebra Operator Precedence
Table L-12: Precedence Rules Illustration
Table L-13: Identities of Boolean Algebra
Table L-14: Identities of Set Algebra
Previous page
Table of content
Next page
Microsoft SQL Server 2008 Bible
ISBN: 0470257040
EAN: 2147483647
Year: 2005
Pages: 208
Authors:
Paul Nielsen
,
Uttam Parui
BUY ON AMAZON
Beginners Guide to DarkBASIC Game Programming (Premier Press Game Development)
Introduction to Computer Programming
Making Programs Think Branching Statements and Subroutines
Game Graphics Learning to Use Bitmaps
The Art of Using Animated Sprites for 2D Games
Fundamentals of 3D Graphics Programming
Visual C# 2005 How to Program (2nd Edition)
.NET Exception Hierarchy
Web Resources
Notes on Generics and Inheritance
Self-Review Exercises
J.12. Class Deposit
Practical Intrusion Analysis: Prevention and Detection for the Twenty-First Century: Prevention and Detection for the Twenty-First Century
Understanding Intrusion Detection
Tcpdump
Internet Security Systems RealSecure
Incident Response
Security Business Issues
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 210 Branch Circuits
Article 350 Liquidtight Flexible Metal Conduit Type LFMC
Article 374 Cellular Metal Floor Raceways
Article 410: Luminaires (Lighting Fixtures), Lampholders, and Lamps
Article 430: Motors, Motor Circuits, and Controllers
Wireless Hacks: Tips & Tools for Building, Extending, and Securing Your Network
Hack 2. Set Up Bluetooth on Windows XP
Hack 88. Primestar Dish with Biquad Feed
Hack 89. Cut a Cable Omni Antenna
Section A.10. 802.1x: Port Security for Network Communications
Section B.5. 802.11 Hardware Suppliers
User Interfaces in C#: Windows Forms and Custom Controls
Classic Controls
Forms
Custom Controls
MDI Interfaces and Workspaces
GDI+ Controls
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies