Monday, January 02, 2012

SQL and Relational Theory, 2nd Edition by C.J. Date

What is SQL? Structured Query Language - It's used to interact with a relational database.
What is Relational model? The relational model for database management is a database model based on first-order predicate logic. The purpose of the relational model is to provide a declarative method for specifying data and queries.

If You work with database as either Database Administrator or Database Developer. You'd supposed to know about SQL and Relational model. If you interest and wish to learn about SQL and Relational Theory, I'd recommend SQL and Relational Theory, 2nd Edition How to Write Accurate SQL Code By C. J. Date

However, This book doesn't teach you about SQL statements.

In 2nd Edition, that includes new material on recursive queries, “missing information” without nulls, new update operators, and topics such as aggregate operators, grouping and ungrouping, and view updating. It also includes "A Tutorial D Grammar" in appendix.

1st Edition:
Appendix The Relational Model
Appendix Database Design Theory
Appendix Answers to Exercises
Appendix Suggestions for Further ReadingTRIBUTES / A NOTE ON RECURSION

2nd Edition:
Appendix The Relational Model
Appendix SQL Departures from the Relational Model
Appendix A Relational Approach to Missing Information
Appendix A Tutorial D Grammar
Appendix Summary of Recommendations
Appendix Answers to Exercises
Appendix Suggestions for Further Reading

If you are looking for Normal Forms. You should wait book - "Normal Forms and All That Jazz: A Database Professional's Guide to Database Theory".

This book is useful for SQL and Relation. It will help you for some questions. Example:
1. What exactly is first normal form?
2. What's the connection between relations and predicts?
3. What's semantic optimization?
4. What's an image relation?
5. Why is semidifference important?
6. Why doesn't deferred integrity checking make sense?
7. What's a relation variable?
8. What's prenex normal form?
9. Can a relation have an attribute whose values are relations?
10. Is SQL relationally complete?
11. Why is The Information Principle important?
12. How does XML fit with the relational model?

Before You get this book, you should know what you interest and what this book can help you. I'd recommend you check it link.

In this book, you will learn about Relational model; Types and Domains, Tuples and Relations, Rows and Tables, No Duplicates, No Nulls, Base Relvars, Base Tables, SQL and Relational Algebra + Constraints +Views ,... that's all many contents, ideas and examples. You will learn SQL and Relational theory from Professional. When you read each chapter finish, you will see "Exercise", that will help you memorize and understand more. It has well-formed paragraphs and many references; it's good for readers. I believe this book is useful for DBAs, students and someone who interests in SQL and Relational.

However, You can get VIDEO - C.J. Date's SQL and Relational Theory Master Class How to Write Accurate SQL Code

C.J. Date is is an independent author, lecturer, researcher, and consultant, specializing in relational database theory. Other books:
- An Introduction to Database Systems, ISBN 0-321-19784-4
- Databases, Types, and the Relational Model, The Third Manifesto (with Hugh Darwen), ISBN 0-321-39942-0
- Temporal Data & the Relational Model, ISBN 1-55860-855-9
- Database in Depth: Relational Theory for Practitioners, ISBN 0-596-10012-4
- Several editions of Relational Database Writings, ISBN 0-201-39814-1, ISBN 0-201-82459-0, ISBN 0-201-54303-6, ISBN 0-201-50881-8.
- What Not How: The Business Rules Approach to Application Development, ISBN 0-201-70850-7
- The Database Relational Model: A Retrospective Review and Analysis, ISBN 0-201-61294-1
- SQL and Relational Theory, 2nd Edition: How to Write Accurate SQL Code, ISBN 1-4493-1640-9

Related Post:
SQL and Relational Theory Master Class (How to Write Accurate SQL Code) by C.J. Date

No comments: