The SQL Guide to Ingres - first edition

Scheduled EventsEvent outlinesBooksWhitepapersWebinarsArticlesContact UsRick F van der Lans



Support independent publishing: buy this book on Lulu.



[Home][Books][The SQL Guide to Ingres]



The Most Complete and Practical SQL Guide to Ingres Database 9.2

For more than twenty years, van der Lans's Introduction to SQL, has been one of the most popular books on SQL. Thousands and thousands of IT professionals have learned SQL programming from his book. The SQL Guide for Ingres is his latest book. All the typical Ingres SQL features are being discussed in detail. So, it is not a generic SQL book, it is a book on the Ingres open source database server, including descriptions of all the new features.

With hundreds of examples, plus a proven approach and structure, the book teaches you how to use Ingres efficiently and effectively. It contains a complete description of the SQL dialect as implemented in Ingres Database 9.2. The book can be seen as a tutorial and a reference book.

Learn how to:

  • Query and update data
  • Create and restructure tables, views, and indexes
  • Specify keys and check constraints,
  • Secure your data
  • Develop stored procedures and rules
  • Carry out transactions
  • Audit access of your tables and databases

Target audience: This book is intended for all developers and database administrators using the Ingres database server. From developers of small organizations responsible for developing websites using Ingres, up to developers working for a large corporation. Everyone will learn from this book. Young developers will learn how certain features work, and experienced developers will get a better and more thorough understanding of all those features. In short, if you use Ingres, this book is for you!

Downloading The Appendixes

The following two appendices be downloaded here for free:

Downloading the SQL Statements

All the SQL statements of the examples and exercises can be downloaded here. Instead of having a separate file for each chapter (as described in the book), we have created one file that contains the statements for all the chapters. This makes downloading easier.


Downloading SQL code for Restoring the Original Sample Database

If you want to restore the sample database to its original structure, download this file, and execute the SQL statements. The tables you have already created will be dropped, and new tables will be created.


Copyright (c) 2017 R20/Consultancy B.V.. All rights reserved.