Informix Guide to SQL : Tutorial
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.
- Paperback | 496 pages
- 175.26 x 228.6 x 17.78mm | 657.71g
- 18 Aug 1994
- Pearson Education (US)
- Prentice Hall
- Upper Saddle River, United States
Table of contents
Introduction. 1. Database Fundamentals. 2. Simple SELECT Statements. 3. Advanced SELECT Statements. 4. Optimizing Your Queries. 5. Statements that Modify Data. 6. SQL in Programs. 7. Programs that Modify Data. 8. Building a Data Model. 9. Implementing the Model. 10. Tuning the Model. 11. Security, Stored Procedures, and Views. 12. Networks and Distribution.