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.