Introduction to SQL - Softcover

Rick F. Van Der Lans

Softcover

ISBN 10: 0201175215 ISBN 13: 9780201175219

Publisher: Addison Wesley, 1988

Synopsis

"A first class book. A thorough and well-written introduction to a complex subject. I wish this book had been available when I was learning SQL." -Ian Cargill, Database Consultant, Soliton Software Ltd

SQL was, is and always will be the database language for relational database systems such as Oracle, DB2, Sybase, Informix and Microsoft SQL Server. Introduction to SQL describes in depth the full capacity of SQL as it is implemented by the commercial databases, without neglecting the most recent changes to the standard, bringing the book up to date and fully compliant with SQL3. Unique in the extent of its coverage, this book takes you from the beginning to the end of SQL, the concepts to the practice, the apprentice to the master.

Learn how to: * Query data * Update data * Create tables and views * Specify primary and foreign keys * Use indexes * Secure your data * Develop stored procedures and triggers * Develop applications with embedded SQL and ODBC * Carry out transactions * Optimize statements * Deal with object-relational concepts such as subtables, references, sets and user-defined data types.

NEW section devoted to stored procedures and triggers NEW coverage of object-oriented concepts NEW information on application development with pre-programmed SQL NEW chapter on using SQL in combination with ODBC

The best way to learn a language is to work with it and the accompanying CD-Rom contains an SQL product called SOLID, chosen because it employs every aspect of SQL covered in the text. Experiment using the exercises in the book.

About this title

From the Back Cover

 

About the Author

Rick F. van der Lans is an independent consultant, author, and lecturer specializing in database technology, SQL, and data warehousing. He is managing director of R20/Consultancy. He has been a member of the Dutch ISO committee responsible for developing the SQL standard. For the past 20 years, he has taught SQL classes to thousands of attendees. His popular books, including Introduction to SQL and The SQL Guide to Oracle, have been translated into various languages and have sold more than 100,000 copies.

Rick is an internationally acclaimed lecturer. Throughout has career, he has lectured in many European countries, South America, USA, and Australia. You can contact Rick via email at sql@r20.nl.

Edition details

• Publisher: Addison Wesley
• Publication date: 1988
• ISBN 10: 0201175215
• ISBN 13: 9780201175219
• Binding: Paperback
• Language: English
• Number of pages: 348