Synopses & Reviews
This text functions as a dynamic supplementary text in Introductory Database Systems courses as well as a stand-alone reference for professionals. This invaluable learning tool provides an understanding of the industry-standard query language SQL. Using an appropriate mix of underlying theory, concepts, and hands-on activities with numerous examples, this text is designed to help students or professionals understand how relational database query languages work.
FEATURES/BENEFITS
- Hands-on Approach
- Win RDBI software available on the author's web site allows readers to interactively experiment with Relational Algebra, Domain Relational Calculus, Tuple Relational Calculus, and Structured Query Language expressions appearing in the book.
- SQL Foundations
- Introduces readers to the industry standard query language in terms of its mathematical foundations and the formal query languages on which SQL is based.
- Case Studies
- Enable students and professionals to examine realistic examples from a requirement description to conceptual design and implementation. Provides a side-by-side comparison of the four query languages.
- Relates Theory to Practice
- Examines the query languages of the popular PC-based database product Microsoft® Access, including Access QBE (Query By Example) and Access SQL.
Synopsis
This invaluable learning tool provides an understanding of the industry-standard query language SQL. Using an appropriate mix of underlying mathematical formalism and hands-on activities with numerous examples, the book is designed to help users grasp the essential concepts of relational database query languages. The book provides a complete presentation of the relational data model, relational algebra, domain and tuple relational calculus and SQL, with case studies and Microsoft assess. For individuals in computer science, information services and industrial engineering interested in gaining an understanding of the foundations of industry SQL.
Synopsis
This invaluable learning tool provides an understanding of the industry-standard query language SQL. Using an appropriate mix of underlying mathematical formalism and hands-on activities with numerous examples, the book is designed to help users grasp the essential concepts of relational database query languages. The book provides a complete presentation of the relational data model, relational algebra, domain and tuple relational calculus and SQL, with case studies and Microsoft assess. For individuals in computer science, information services and industrial engineering interested in gaining an understanding of the foundations of industry SQL.
Table of Contents
1. The Relational Data Model.
2. Relational Algebra.
3. Domain Relational Calculus.
4. Tuple Relational Calculus.
5. SQL.
6. Case Studies.
7. Microsoft Access.
Appendix: WinRDBI