Używamy cookies, aby ułatwić korzystanie z Portalu. Możesz określić warunki przechowywania, dostępu do plików cookies w Twojej przeglądarce. Dowiedz się więcej.
strona główna Strona główna | Nowości | Promocje | Zapowiedzi Twoje konto | Zarejestruj | Schowek | Kontakt | Pomoc
mapa działów
Szukaj: szukanie zaawansowane
Koszyk
Książki \ Bazy danych \ SQL Server

SQL and Relational Theory, 3rd Edition Język: 2

978-1-4919-4117-1

Cena Brutto: 42.00

Cena netto: 40.00

Ilość:
Wersja: Drukowana
Autor C.J. Date
Liczba_stron 572
Wydawnictwo O'Reilly Media
Oprawa miękka
Data_Wydania 2015-12-06

SQL

and Relational Theory, 3rd Edition



SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put that theory into practice. In this book, Chris Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it to your use of SQL.


This third edition has been revised, extended, and improved throughout. Topics whose treatment has been expanded include data types and domains, table comparisons, image relations, aggregate operators and summarization, view updating, and subqueries. A special feature of this edition is a new appendix on NoSQL and relational theory.

  • Could you write an SQL query to find employees who have worked at least once in every programming department in the company? And be sure it’s correct?
  • Why is proper column naming so important?
  • Nulls in the database cause wrong answers. Why? What you can do about it?
  • How can image relations help you formulate complex SQL queries?
  • SQL supports 'quantified comparisons,' but they’re better avoided. Why? And how?

Database theory and practice have evolved considerably since Codd first defined the relational model, back in 1969. This book draws on decades of experience to present the most up to date treatment of the material available anywhere. Anyone with a modest to advanced background in SQL can benefit from the insights it contains. The book is product independent.





Pragniemy Państwa zapewnić, iż dokładamy wszelkich możliwych starań, by opisy książek i podręczników, zawarte na naszych stronach internetowych, zawierały bieżące i wiarygodne materiały. Może jednak, mimo naszych wysiłków, w opisy książek wkraść się przekłamanie z naszej strony niezamierzone. Nie może to stanowić powodu do roszczeń. O ile macie Państwo jakiekolwiek pytania lub wątpliwości - prosimy o kontakt z naszym ekspertem lub działem handlowym. Postaramy  się odpowiedzieć na wszystkie Państwa pytania zanim podejmiecie Państwo decyzje o złożeniu zamówienia.
#

  1. Chapter 1Setting the Scene

    1. The relational model is much misunderstood

    2. Some remarks on terminology

    3. Principles not products

    4. A review of the original model

    5. Model vs. implementation

    6. Properties of relations

    7. Base vs. derived relations

    8. Relations vs. relvars

    9. Values vs. variables

    10. Concluding remarks

    11. Exercises

    12. Answers

  2. Chapter 2Types and Domains

    1. Types and relations

    2. Equality comparisons

    3. Data value atomicity

    4. What’s a type?

    5. Scalar vs. nonscalar types

    6. Scalar types in SQL

    7. Type checking and coercion in SQL

    8. Collations in SQL

    9. Row and table types in SQL

    10. Concluding remarks

    11. Exercises

    12. Answers

  3. Chapter 3Tuples and Relations, Rows and Tables

    1. What’s a tuple?

    2. Rows in SQL

    3. What’s a relation?

    4. Relations and their bodies

    5. Relations are n-dimensional

    6. Relational comparisons

    7. TABLE_DUM and TABLE_DEE

    8. Tables in SQL

    9. Column naming in SQL

    10. Concluding remarks

    11. Exercises

    12. Answers

  4. Chapter 4No Duplicates, No Nulls

    1. What’s wrong with duplicates?

    2. Duplicates: further issues

    3. Avoiding duplicates in SQL

    4. What’s wrong with nulls?

    5. Avoiding nulls in SQL

    6. A remark on outer join

    7. Concluding remarks

    8. Exercises

    9. Answers

  5. Chapter 5Base Relvars, Base Tables

    1. Updating is set level

    2. Relational assignment

    3. More on candidate keys

    4. More on foreign keys

    5. Relvars and predicates

    6. Relations vs. types

    7. Exercises

    8. Answers

  6. Chapter 6SQL and Relational Algebra I: The Original Operators

    1. Some preliminaries

    2. More on closure

    3. Restriction

    4. Projection

    5. Join

    6. Union, intersection, and difference

    7. Which operators are primitive?

    8. Formulating expressions one step at a time

    9. What do relational expressions mean?

    10. Evaluating SQL table expressions

    11. Expression transformation

    12. The reliance on attribute names

    13. Exercises

    14. Answers

  7. Chapter 7SQL and Relational Algebra II: Additional Operators

    1. Exclusive union

    2. Semijoin and semidifference

    3. Extend

    4. Image relations

    5. Divide

    6. Aggregate operators

    7. Image relations revisited

    8. Summarization

    9. Summarization revisited

    10. Group, ungroup, and relation valued attributes

    11. “What if” queries

    12. A note on recursion

    13. What about ORDER BY?

    14. Exercises

    15. Answers

  8. Chapter 8SQL and Constraints

    1. Type constraints

    2. Type constraints in SQL

    3. Database constraints

    4. Database constraints in SQL

    5. Transactions

    6. Why database constraint checking must be immediate

    7. But doesn’t some checking have to be deferred?

    8. Constraints and predicates

    9. Miscellaneous issues

    10. Exercises

    11. Answers

  9. Chapter 9SQL and Views

    1. Views are relvars

    2. Views and predicates

    3. Retrieval operations

    4. Views and constraints

    5. Update operations

    6. What are views for?

    7. Views and snapshots

    8. Exercises

    9. Answers

  10. Chapter 10SQL and Logic

    1. Why do we need logic?

    2. Simple and compound propositions

    3. Simple and compound predicates

    4. Quantification

    5. Relational calculus

    6. More on quantification

    7. Some equivalences

    8. Concluding remarks

    9. Exercises

    10. Answers

  11. Chapter 11Using Logic to Formulate SQL Expressions

    1. Some transformation laws

    2. Example 1: Logical implication

    3. Example 2: Universal quantification

    4. Example 3: Implication and universal quantification

    5. Example 4: Correlated subqueries

    6. Example 5: Naming subexpressions

    7. Example 6: More on naming subexpressions

    8. Example 7: Dealing with ambiguity

    9. Example 8: Using COUNT

    10. Example 9: Another variation

    11. Example 10: UNIQUE quantification

    12. Example 11: ALL or ANY comparisons

    13. Example 12: GROUP BY and HAVING

    14. Exercises

    15. Answers

  12. Chapter 12Miscellaneous SQL Topics

    1. SELECT *

    2. Explicit tables

    3. Dot qualification

    4. Range variables

    5. Subqueries

    6. “Possibly nondeterministic” expressions

    7. Empty sets

    8. A simplified BNF grammar

    9. Exercises

    10. Answers

  13. Appendix The Relational Model

    1. The relational model vs. others

    2. The significance of theory

    3. The relational model defined

    4. Database variables

    5. Objectives of the relational model

    6. Some database principles

    7. What remains to be done?

  14. Appendix SQL Departures from the Relational Model

  15. Appendix A Relational Approach to Missing Information

    1. Vertical decomposition

    2. Horizontal decomposition

    3. What do the shaded entries mean?

    4. Constraints

    5. Queries

    6. More on predicates

    7. Exercises

    8. Answers

  16. Appendix A Tutorial D Grammar

  17. Appendix Summary of Recommendations

  18. Appendix NoSQL and Relational Theory

    1. Functional segmentation

    2. Sharding

    3. Eventual consistency

    4. The Fernandez interview

  19. Appendix Suggestions for Further Reading

powrót
 
Produkty Podobne
Kompletny przewodnik po DAX, wyd. 2 rozszerzone. Analiza biznesowa przy użyciu Microsoft Power BI, SQL Server Analysis Services i Excel
Definitive Guide to DAX, The: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel, 2nd Edition
SQL Server 2017 Administration Inside Out
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition
Exam Ref 70-765 Provisioning SQL Databases
Mistrzowski SQL. 61 technik pisania wydajnego kodu SQL
Exam Ref 70-764 Administering a SQL Database Infrastructure
SQL Server i T-SQL w mgnieniu oka. Wydanie II
SQL Server 2016 High Availability Unleashed (includes Content Update Program)
Microsoft SQL Server 2016 Analysis Services: Modelowanie tabelaryczne
Więcej produktów