Understanding Relational Database Query Languages
For use as a dynamic supplementary text in introductory Database Systems courses in Computer Science programs. This book can be used to supplement any main text for the introductory database systems course.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 text is designed to help students grasp the essential concepts of relational database query languages.
- Paperback | 192 pages
- 172.7 x 231.1 x 12.7mm | 272.16g
- 26 Feb 2001
- Pearson Education (US)
- Upper Saddle River, NJ, United States
Back cover copy
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/BENEFITSHands-on ApproachWin 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 FoundationsIntroduces readers to the industry standard query language in terms of its mathematical foundations and the formal query languages on which SQL is based.Case StudiesEnable 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 PracticeExamines the query languages of the popular PC-based database product Microsoft(R) Access(TM), including Access QBE (Query By Example) and Access 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