Flylib.com
List of Figures
Previous page
Table of content
Next page
Chapter 1: SQL and Relational Database Management Systems (RDBMS)
Figure 1-1: Hierarchical structure
Figure 1-2: Hierarchical database example
Figure 1-3: Network database example
Figure 1-4: Multiple columns to resolve multiple addresses for CUSTOMER
Figure 1-5: Multiple records to resolve multiple addresses for CUSTOMER
Figure 1-6: Primary/Foreign Key relationship between tables
Figure 1-7: Resolving the multiple customer addresses problem within relational model
Chapter 3: SQL Data Types
Figure 3-1: Fixed-length character string storage
Figure 3-2: Varying-length character string storage
Figure 3-3: Fixed-length Unicode character storage
Figure 3-4: Varying-length Unicode character storage
Figure 3-5: Table with column declared as an object type
Figure 3-6: Nested tables in Oracle
Chapter 4: Creating RDBMS Objects
Figure 4-1: Mary's rows in the
TMP_CUSTOMER_ORDER_TOTALS
temporary table
Figure 4-2: Susan's rows in the
TMP_CUSTOMER_ORDER_TOTALS
temporary table
Figure 4-3: Kyle's rows in the
TMP_CUSTOMER_ORDER_TOTALS
temporary table
Figure 4-4: Index use
Figure 4-5: B-Tree example
Figure 4-6: Database organization in Oracle
Figure 4-7: Database organization in MS SQL Server
Figure 4-8: Relationship between tablespace and datafile (one-to-many).
Figure 4-9: Using sequence-generated numbers to populate primary keys in multiple tables
Chapter 6: Data Manipulation Language (DML)
Figure 6-1: Using data from other table as an assignment value
Figure 6-2: Updating multiple rows using correlated subquery
Figure 6-3: Deleting from table referenced by ON DELETE CASCADE constraints
Figure 6-4: Deleting from table referenced by ON DELETE SET NULL constraints
Chapter 9: Multitable Queries
Figure 9-1: Simple inner join
Figure 9-2: Primary/foreign key nonequijoin
Figure 9-3: The contents of DISCOUNT table
Figure 9-4: Self-join
Figure 9-5: Four tables join
Chapter 16: SQL API
Figure 16-1: Microsoft ODBC Driver Manager console
Figure 16-2: ODBC drivers selection
Figure 16-3: IBM DB2 UDB ODBC driver configuration
Figure 16-4: New user DSN entry IBM DB2 UDB
Figure 16-5: illustrates generic RDBMS access using JDBS drivers.
Figure 16-6: Accessing IBM DB2 UDB through CLI
Figure 16-7: Connecting to Microsoft SQL Server 2000 through OLEDB
Figure 16-8: Results of the database C# program
Appendix B: The ACME Sample Database
Figure B-1: ACME database schema
Appendix D: Installing RDBMS Software
Figure D-1: Oracle 9
i
Autorun window
Figure D-2: Oracle Welcome window
Figure D-3: Oracle File Locations window
Figure D-4: Oracle Database Identification window
Figure D-5: Oracle Database Character Set window
Figure D-6: Oracle Summary window
Figure D-7: Oracle Install window / Disk Location pop-up screen
Figure D-8: Oracle Configuration Tools and Database Configuration assistant windows
Figure D-9: Oracle Change passwords for system users on the Database Configuration assistant window
Figure D-10: Oracle Windows Services window
Figure D-11: Removing Oracle software with the Inventory window
Figure D-12: Oracle Administration Assistant for Windows NT
Figure D-13: DB2 UDB 8.1 Installation window
Figure D-14: DB2 UDB 8.1 Products selection screen
Figure D-15: DB2 UDB 8.1 Setup wizard screen
Figure D-16: DB2 UDB 8.1 Select installation folder screen
Figure D-17: DB2 UDB 8.1 Start copying files screen
Figure D-18: DB2 UDB 8.1 Creating database using Control Center window
Figure D-19: DB2 UDB 8.1 Creating ACME database in using Database Wizard
Figure D-20: This MS SQL 2000 installation window allows you to choose the destination computer name.
Figure D-21: MS SQL 2000 Installation Selection window
Figure D-22: MS SQL 2000 Installation Definition screen
Figure D-23: MS SQL 2000 Setup Type screen
Figure D-24: MS SQL 2000 Services Accounts screen
Figure D-25: MS SQL 2000 Authentication Mode screen
Figure D-26: MS SQL 2000 Server Service Manager
Appendix E: Accessing RDBMS
Figure E-1: SQL*Plus command-line interface started from MS-DOS
Figure E-2: Executing SQL commands from SQL*Plus
Figure E-3: SQL*Plus Worksheet window
Figure E-4: OSQL session window
Figure E-5: MS SQL Server Query Analyzer dialog box
Figure E-6: Executing SQL commands using Query Analyzer
Appendix L: A Brief Introduction to the Number Systems, Boolean Algebra, and Set Theory
Figure L-1: Set union
Figure L-2: Set intersection
Figure L-3: Set difference
Figure L-4: Cartesian product
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
SQL Tips & Techniques (Miscellaneous)
Working with Functions, Parameters, and Data Types
Writing External Applications to Query and Manipulate Database Data
Understanding Triggers
Exploiting MS-SQL Server Built-in Stored Procedures
Working with SQL Database Data Across the Internet
Image Processing with LabVIEW and IMAQ Vision
Charge-Coupled Devices
Color Images
Camera Interfaces and Protocols
Compression Techniques
Image Analysis
Cisco IOS Cookbook (Cookbooks (OReilly))
Defining Per Port Privileges
Authenticating Login IDs from a Central System
Changing Administrative Distances
Using Time-Based Access-Lists
Controlling Multicast Scope with Administratively Scoped Addressing
Microsoft WSH and VBScript Programming for the Absolute Beginner
Getting Started with the WSH and VBScript
Overview of the Windows Script Host
Conditional Logic
Processing Collections of Data
Handling Script Errors
Telecommunications Essentials, Second Edition: The Complete Global Source (2nd Edition)
The PSTN Versus the Internet
The Transport Network Infrastructure
The Evolution to IP Services
Wireless Impairments
3G: Moving Toward Broadband Wireless
Python Programming for the Absolute Beginner, 3rd Edition
PyToe: A Tic-Tac-Toe Game Widget
The PyMailCgi Web Site
Submitting PyErrata Reports
A Simple C Extension Module
Other Integration Topics
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