Introduction to SQL: Mastering the Structured Query Language - Softcover

Van Der Lans, Rick

 
9780201596182: Introduction to SQL: Mastering the Structured Query Language

Inhaltsangabe

This book provides a technical introduction to the features of SQL. Aimed at those new to SQL, but not new to programming, it gives the reader the essential skills required to start programming with this language.

Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.

Über die Autorin bzw. den Autor

Rick van der Lans is an independent database consultant with many years' experience developing applications with SQL. He lectures frequently in the USA and Europe and is the author of several books on SQL, also published by Addison-Wesley, including The SQL Guide for Oracle and An SQL Guide for dBase IV.

Von der hinteren Coverseite

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.

„Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.