Product Description
This tutorial describes the Structured Query Language (SQL) as it is implemented by Informix products. It shows how to create, manage, and use relational databases with Informix software tools. KEY TOPICS: Shows how to make simple and advanced queries to fetch and display database data; how to refine and optimize queries and use the query Optimizer; how to use statements to insert, delete, or update data; how to maintain data integrity and security; how to call the database server, retrieve rows, and embed data; how to build an efficient data model, step-by-step; and how to best set up a database to work over a network. MARKET: For those who use computers in their daily work, and who have access to an INFORMIX-OnLine or INFORMIX-SE data server and an Informix application development tool, such as INFORMIX-SQL, INFORMIX-4GL, or DB-Access.
From the Back Cover
1616E-3
Master the Informix implementation of SQL, start-to-finish-updated for the new Informix Dynamic Server.2000 and Informix Enterprise Decision Server!
The Informix Guide to SQL: Tutorial, Second Edition is the authoritative, complete tutorial for learning the Informix implementation of SQL-completely updated for Informix Dynamic Server.2000 and Informix Enterprise Decision Server. 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 includes all this, and more:
- 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
- Complex data types, including collection types, row types, and inheritance hierarchies
- Data manipulation language (DML) statements
- Creating stored procedures with the Stored Procedure Language (SPL)
- Using the CREATE TRIGGER statement to build triggers
Want to learn the Informix implementation of SQL fast-and learn it right? Get the Informix Guide to SQL: Tutorial, Second Edition.
0-13-016165-9
--This text refers to an out of print or unavailable edition of this title.