Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
SQL and Relational Theory: How to Write Accurate SQL Code

Buy
Understanding SQL's underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. On the other hand, if you're not well versed in the theory, you can fall into several traps. In SQL and Relational Theory, author C.J. Date demonstrates how you can apply relational theory directly to your use of SQL. With numerous examples and clear explanations of the reasoning behind them, you'll learn how to deal with common SQL dilemmas, such as:
  • Should database access granted be through views instead of base tables?
  • Nulls in your database are causing you to get wrong answers. Why? What can you do about it?
  • Could you write an SQL query to find employees who have never been in the same department for more than six months at a time?
  • SQL supports "quantified comparisons," but they're better avoided. Why? How do you avoid them?
  • Constraints are crucially important, but most SQL products don't support them properly. What can you do to resolve this situation?

Database theory and practice have evolved since Edgar Codd originally defined the relational model back in 1969. Independent of any SQL products, SQL and Relational Theory draws on decades of research to present the most up-to-date treatment of the material available anywhere. Anyone with a modest to advanced background in SQL will benefit from the many insights in this book.

About the Author

C.J. Date has a stature that is unique within the database industry. C.J. is a prolific writer, and is well-known for his best-selling textbook: An Introduction to Database Systems (Addison Wesley). C.J. is an exceptionally clear-thinking writer who can lay out principles and theory in a way easily understood by his audience.

(HTML tags aren't allowed.)

GWT in Action
GWT in Action
Since the first edition of this book, the Google Web Toolkit (GWT) has grown, transformed, and emerged from a promising toolkit for web applications into a toolkit that truly supports 1) developers and managers in delivering web applications that can push the boundaries of the possible and 2) the application of...
The Algorithms and Principles of Non-photorealistic Graphics: Artistic Rendering and Cartoon Animation
The Algorithms and Principles of Non-photorealistic Graphics: Artistic Rendering and Cartoon Animation

Non-photorealistic computer graphics is a multidisciplinary field in the research community, involving computer arts, computer graphics, computer vision, digital image/video processing and visual cognitive psychology. It aims at the computer generation of images and animations that are made in part “by hand” in appearance,...

CEA-CompTIA DHTI+ Digital Home Technology Integrator All-In-One Exam Guide, Second Edition
CEA-CompTIA DHTI+ Digital Home Technology Integrator All-In-One Exam Guide, Second Edition
A CEA-CompTIA DHTI+ Exam Guide and Desktop Reference--All in One!.

Get complete coverage of all the material included on the CEA-CompTIA DHTI+ Digital Home Technology Integrator exam inside this comprehensive resource. Written by industry experts, this definitive exam guide features learning objectives at the beginning of each...


Digital Rights Management: Protecting and Monetizing Content (NAB Executive Technology Briefings)
Digital Rights Management: Protecting and Monetizing Content (NAB Executive Technology Briefings)
"The author, who specialises in digital and interactive media, sets out the arguments with a view to readers being able to make informed decisions on the issues before them." -Book Shelf

Digital rights management (DRM) is a type of server software developed to enable secure distribution - and perhaps more
...
Excel VBA 24-Hour Trainer
Excel VBA 24-Hour Trainer

Master VBA automation quickly and easily to get more out of Excel

Excel VBA 24-Hour Trainer, 2nd Edition is the quick-start guide to getting more out of Excel, using Visual Basic for Applications. This unique book/video package has been updated with fifteen new advanced video lessons, providing a total of...

COM and .NET Interoperability
COM and .NET Interoperability

COM and .NET Interoperability provides a complete overview on the process of building .NET applications which interact (interoperate) with existing COM code. Before digging into that critical topic, Andrew offers a concise overview of the COM architecture, and provides examples using various COM frameworks (C++, ATL, and VB 6.0)....

©2020 LearnIT (support@pdfchm.net) - Privacy Policy