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
CompTIA Project+ Study Guide: Exam PK0-003
Assessment Test
Project Initiation
Scope Planning
Project Execution
Appendix A Systems Development Life Cycle
Secure Programming Cookbook for C and C++: Recipes for Cryptography, Authentication, Input Validation & More
Installing Boost.Build
Using Exported Templates
Ensuring You Have Only One Instance of a Variable Across Multiple Source Files
Managing Data with Containers
Computing the Number of Elements in a Container
Mastering Delphi 7
Writing Delphi Components
Libraries and Packages
Client/Server with dbExpress
Web Programming with WebBroker and WebSnap
The Microsoft .NET Architecture from the Delphi Perspective
Java Concurrency in Practice
Atomicity
Guarding State with Locks
Part II: Structuring Concurrent Applications
JVM Shutdown
Reducing Context Switch Overhead
Quantitative Methods in Project Management
Project Value: The Source of all Quantitative Measures
Introduction to Probability and Statistics for Projects
Making Quantitative Decisions
Risk-Adjusted Financial Management
Quantitative Time Management
Quartz Job Scheduling Framework: Building Open Source Enterprise Applications
Job scheduling Versus Workflow
Using the JobStoreCMT
Using the FileScanListener
Working with the Scheduler
The Main Quartz Properties
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