Introduction to SQL Mastering the Relational Database Language

Introduction to SQL Mastering the Relational Database Language:
This book is completely devoted to SQL. Every aspect of the language is discussed thoroughly and critically. These aspects, among others, include the following:

• Querying data (joins, functions, and subqueries)
• Updating data
• Creating tables and views
• Specifying primary and foreign keys and other integrity constraints
• Using indexes
• Considering data security
• Developing stored procedures and triggers
• Developing programs with embedded SQL and ODBC
• Working with transactions
• Optimizing statements
• Dealing with object relational concepts, such as subtables, references, sets, and user-defined data types
• Using the catalog

Download