Designed as a companion volume to the INFORMIX Guide to SQL: Tutorial, this comprehensive reference covers the Structured Query Language (SQL) as it is implemented in Informix products. KEY TOPICS: Outlines the structure and contents of the demonstration database (stores5) and explains the 21 Informix system catalog tables that describe that structure; defines the column data types supported by Informix products and explains data type conversion techniques; describes the various environment variables that can or should be set to properly use Informix products; explains error handling, the system descriptor area and the SQL Descriptor Area (sqlda); details the workings of all the SQL statements supported by Informix products with step-by-step diagrams explaining every clause of each SQL statement; and shows how to create and use stored procedures. MARKET: A reference to SQL for those who already know how to use computers and who rely on them in their daily work.
Describes the Structured Query Language (SQL) as it is implemented by Informix products. This tutorial shows how to create, manage, and use relational databases with Informix software tools. It also shows how to make simple and advanced queries to fetch and display database data, and how to refine and optimize queries and use the query Optimizer.
In this book, a world-class Informix expert guides both novices and power users through the complex suite of Informix products, helping them master the development and administration skills they need most. Informix Basics is chock-full of exercises, practical examples and real-world tips - all honed through Glenn Miller's 14 years "in the trenches" teaching, building, and administering Informix databases. It shows not just what to do, but how and why to do it, and which tools to use. It covers virtually every key issue Informix developers and DBAs are likely to face, including: designing databases for maximum efficiency and power; working with SQL; using advanced SQL techniques such as stored procedures and triggers; 4GL programming and user interface development, and more. Coverage also includes data migration, interfacing with 3GLs, and the basics of Informix database administration. Informix Basics is ideal for new Informix users; power users seeking to learn application development; and database professionals migrating from other environments.
IBM® Informix® is a low-administration, easy-to-use, and embeddable database that is ideal for application development. It supports a wide range of development platforms, such as JavaTM, .NET, PHP, and web services, enabling developers to build database applications in the language of their choice. Informix is designed to handle RDBMS data and XML without modification and can be extended easily to handle new data sets. This IBM Redbooks® publication provides fundamentals of Informix application development. It covers the Informix Client installation and configuration for application development environments. It discusses the skills and techniques for building Informix applications with Java, ESQL/C, OLE DB, .NET, PHP, Ruby on Rails, DataBlade®, and Hibernate. The book uses code examples to demonstrate how to develop an Informix application with various drivers, APIs, and interfaces. It also provides application development troubleshooting and considerations for performance. This book is intended for developers who use IBM Informix for application development. Although some of the topics that we discuss are highly technical, the information in the book might also be helpful for managers or database administrators who are looking to better understand their Informix development environment.
SQL in a Nutshell applies the eminently useful "Nutshell" format to Structured Query Language (SQL), the elegant--but complex--descriptive language that is used to create and manipulate large stores of data. For SQL programmers, analysts, and database administrators, the new second edition of SQL in a Nutshell is the essential date language reference for the world's top SQL database products. SQL in a Nutshell is a lean, focused, and thoroughly comprehensive reference for those who live in a deadline-driven world.This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL). It describes every command and reference and includes the command syntax (by vendor, if the syntax differs across implementations), a clear description, and practical examples that illustrate important concepts and uses. And it also explains how the leading commercial and open sources database product implement SQL. This wealth of information is packed into a succinct, comprehensive, and extraordinarily easy-to-use format that covers the SQL syntax of no less than 4 different databases.When you need fast, accurate, detailed, and up-to-date SQL information, SQL in a Nutshell, Second Edition will be the quick reference you'll reach for every time. SQL in a Nutshell is small enough to keep by your keyboard, and concise (as well as clearly organized) enough that you can look up the syntax you need quickly without having to wade through a lot of useless fluff. You won't want to work on a project involving SQL without it.
In just 24 lessons of one hour or less, you will learn professional techniques to design and build efficient databases and query them to extract useful information. Using a straightforward, step-by-step approach, each lesson builds on the previous one, allowing you to learn the essentials of ANSI SQL from the ground up. Example code demonstrates the authors’ professional techniques, while exercises written for MySQL offer the reader hands-on learning with an open-source database. Included are advanced techniques for using views, managing transactions, database administration, and extending SQL. Step-by-step instructions carefully walk you through the most common SQL tasks. Q&As, Quizzes, and Exercises at the end of each chapter help you test your knowledge. Notes and Tips point out shortcuts and solutions. New terms are clearly defined and explained. Learn how to... Use SQL-2003, the latest standard for the Structured Query Language Design and deploy efficient, secure databases Build advanced queries for information retrieval Sort, group, and summarize information for best presentation Tune databases and queries for maximum performance Understand database administration and security techniques For more than ten years the authors have studied, applied, and documented the SQL standard and its application to critical database systems. Ryan Stephens and Ron Plew are entrepreneurs, speakers, and cofounders of Perpetual Technologies, Inc. (PTI), a fast-growing IT management and consulting firm which specializes in database technologies. They taught database courses for Indiana University–Purdue University in Indianapolis for five years and have authored more than a dozen books on Oracle, SQL, database design, and the high availability of critical systems. Arie D. Jones is Senior SQL Server database administrator and analyst for PTI. He is a regular speaker at technical events and has authored several books and articles. Category: Database Covers: ANSI SQL User Level: Beginning–Intermediate Register your book at informit.com/title/9780672330186 for convenient access to updates and corrections as they become available.
A very practical guide to making databases run faster and better. A poorly performing database application can cost each user time, and have an impact on other applications running on the same computer or the same network. This book will help DBAUs and programmers improve the performance of their databases.