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 extend of its covarage, this book takes you from the beginning to the end of SQL, the concepts to the ptactice, the apprenbtice 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 staments
- Deal with object-relational concepts such as subtables, references, sets and user-defined data types.
1. Introduction
2. Querying and Updating Data
3. Creating Database Objects
4. Programming With SQL
5. Procedural database Objects
6. Object relational Concepts