Informix SQL Reference Library

by Informix Software

1704B-3 *The comprehensive, authoritative resource for Informix database design and implementation! *Completely updated for Informix Dynamic Server.2000 and Informix Enterprise Decision Server *Three great books, one great price! InformixA (R) Guide to Reference and Syntax, Second the complete guide and syntax reference for the Informix implementation of SQL InformixA (R) Guide to Tutorial, Second the start-to-finish SQL tutorial for development on Informix platforms InformixA (R) Guide to Designing Databases and Data the insider's guide to real-world database design - detailed data models, proven step-by-step techniques, and more The total resource for Informix developers & 3 authoritative books, direct from Informix! (1)InformixA (R) Guide to Reference and Syntax, Second Edition The indispensable reference to the Informix implementation of SQL! Informix Guide to Reference and Syntax, Second Edition contains comprehensive descriptions of every SQL and Stored Procedure Language (SPL) statement, plus extensive SQL syntax coverage not included in the first edition.Detailed syntax diagrams walk you through every clause of each SQL statement, and syntax tables explain the input parameters for each clause. Coverage *Building object-relational and data warehouse solutions with the Informix implementation of SQL *Essential techniques for designing and using ANSI-compliant databases System catalog tables, structure, statistics, information schema views, and more *Environment variables defining terminal identification, software location, and other parameters *Detailed information on the structure and contents of the stores_demo, sales_demo, and superstores_demo demonstration databases (2)InformixA (R) Guide to Tutorial, Second Edition Master the Informix implementation of SQL, start-to-finish! Informix Guide to Tutorial, Second Edition is the authoritative, complete tutorial for learning the Informix implementation of SQL. Starting with the simplest SELECT statements, this complete course walks you through everything you need to know to succeed with SQL. Learn how to build and optimize queries, both simple and advanced. Use SQL statements to insert, delete, or update data, while you maintain data integrity and security.Learn how to call the database server, retrieve rows, embed data, and create and implement efficient data models, step-by-step. Coverage *Fundamental relational and object-relational database concepts *User access and security through GRANT, REVOKE, CREATE VIEW and other SQL statements *SQL programming techniques, including dynamic SQL and embedded data definition statements *Data manipulation language (DML) statements *Creating stored procedures with the Stored Procedure Language (SPL) (3)InformixA (R) Guide to Designing Databases and Data Warehouses The Informix insider's guide to database and data warehouse design! Informix Guide to Designing Databases and Data Warehousesis the most complete, authoritative guide to database and data warehouse design, implementation, and administration with Informix Dynamic Server.2000 and Informix Enterprise Decision Server. You'll start by walking through the construction of data models that illustrate each key approach to database design. Compare ANSI and non-ANSI compliant databases, learn the fundamentals of entity-relationship modeling, and choose appropriate data types.Next, you'll learn how to use the Informix implementation of SQL to implement and manage your databases. Coverage *Implementing relational data models with the CREATE DATABASE and CREATE TABLE statements, synonyms, synonym chains, and command scripts *Applying fragmentation strategies for maximizing database and data warehouse performance *Implementing dimensional data models-including solutions to common problems *Applying indexing techniques for data warehousing environments 0-13-017042-9

1200 pages, Paperback

Published December 27, 1999