- Paperback: 192 pages
- Publisher: Prentice Hall; 1 edition (26 Feb 2001)
- Language English
- ISBN-10: 0130286524
- ISBN-13: 978-0130286529
- Product Dimensions: 27.9 x 12.6 x 1.1 cm
- Amazon Bestsellers Rank: 1,737,627 in Books (See Top 100 in Books)
- See Complete Table of Contents
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Product details |
More About the Author
Product Description
Product Description
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.
From the Back Cover
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.
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Reviews
There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
2 reviews
4 of 4 people found the following review helpful
Uncovers the mystery of SQL's behavior
10 Aug 2001
Format:Paperback
I like this book. I was looking for a book that gave the "why" behind SQL. I graduated years ago with a Computer Science degree and didn't have the opportunity to take a database class. I found myself having to learn SQL on the job. This book uncovers the mystery of SQL's behavior. It has a lot of examples that are supported by the software described in the appendix. It also describes how to use the query languages of Microsoft Access.
Don't let the term "theory" scare you. After the first couple of pages of required definitions, the tone of the book quickly changed to a very readable presentation. Overall, I like the writing style - it's precise and to the point - not too wordy. Definitely worth the money!
1 of 1 people found the following review helpful
overwhelmed by any SQL syntax? Then read this book!
4 Feb 2005
Format:Paperback
This is a pretty good book. It's strength lies in it's limited scope: you learn relational database query languages, and get a short primer on Access (Microsoft) and WinRDBI (by author). It doesn't give you the various SQL dialects that exist (Oracle, MySQL, etc.), because that would make it a whole lot thicker book.
If you are overwhelmed by the vast syntax of any particular SQL flavor, than this is the book for you. Here is tersely presented what a minimal language needs, and why it is convenient to have a bigger language (ie. larger syntax).
The book teaches 4 relational "languages", each with it's own chapter: relational algebra, domain relational calculus (DRC), tuple relational calculus (TRC), and SQL. The preface states that relational algebra is considered crucial to understanding SQL. DRC is treated because it is often used for data mining techniques and artificial intelligence applications. TRC is treated because it's very similar to SQL. And SQL is the very reason that I picked up this book.
Each of these four chapters first introduces the basics of the language at hand.And then the language is further explained with example queries. For these examples a data model for an "employee training enterprise" is used; this data model was introduced in chapter 1. Chapter 1 also introduces entity relationship diagrams that are used to explain the data model.
Having the same data model and queries reappear in these different languages, makes that the reader picks up each language easily.
From the chapter on relational algebra you learn what the minimum set of operators is, that you need to express most queries that you might think of. And that it is convenient to have more operators, for common combinations of the basic operators.
In the following chapters on DRC, TRC, and SQL, this is the leading theme. In addition you learn of alternative queries to obtain a particular result, and how to choose between these alternatives.
In chapter 6 three case studies are presented, in all 4 languages. Chapter 7 is on Access, and appendix A on WinRDBI. WinRDBI can handle queries in all 4 presented languages.
The chapter on SQL is longer than the others. It explains such items as:
Safety : making sure that your query produces a finite result.
Query optimization : writing queries that execute quickly.
Sorting, grouping.
Defining tables.
What is given (almost) no mention is why/how to add indices to attributes.
If you are overwhelmed by the vast syntax of any particular SQL flavor, than this is the book for you. Here is tersely presented what a minimal language needs, and why it is convenient to have a bigger language (ie. larger syntax).
The book teaches 4 relational "languages", each with it's own chapter: relational algebra, domain relational calculus (DRC), tuple relational calculus (TRC), and SQL. The preface states that relational algebra is considered crucial to understanding SQL. DRC is treated because it is often used for data mining techniques and artificial intelligence applications. TRC is treated because it's very similar to SQL. And SQL is the very reason that I picked up this book.
Each of these four chapters first introduces the basics of the language at hand.And then the language is further explained with example queries. For these examples a data model for an "employee training enterprise" is used; this data model was introduced in chapter 1. Chapter 1 also introduces entity relationship diagrams that are used to explain the data model.
Having the same data model and queries reappear in these different languages, makes that the reader picks up each language easily.
From the chapter on relational algebra you learn what the minimum set of operators is, that you need to express most queries that you might think of. And that it is convenient to have more operators, for common combinations of the basic operators.
In the following chapters on DRC, TRC, and SQL, this is the leading theme. In addition you learn of alternative queries to obtain a particular result, and how to choose between these alternatives.
In chapter 6 three case studies are presented, in all 4 languages. Chapter 7 is on Access, and appendix A on WinRDBI. WinRDBI can handle queries in all 4 presented languages.
The chapter on SQL is longer than the others. It explains such items as:
Safety : making sure that your query produces a finite result.
Query optimization : writing queries that execute quickly.
Sorting, grouping.
Defining tables.
What is given (almost) no mention is why/how to add indices to attributes.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > SQL
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Design & Theory
- Books > Science & Nature > Mathematics > Education > Higher Education
- Books > Science & Nature > Popular Science > Maths
- Books > Scientific, Technical & Medical > Mathematics
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
