Joe Celko (Independent Consultant, Austin, Texas)
Joe Celko's SQL for Smarties
Advanced SQL Programming
Joe Celko (Independent Consultant, Austin, Texas)
Joe Celko's SQL for Smarties
Advanced SQL Programming
- Broschiertes Buch
- Merkliste
- Auf die Merkliste
- Bewerten Bewerten
- Teilen
- Produkt teilen
- Produkterinnerung
- Produkterinnerung
5th edition.
Andere Kunden interessierten sich auch für
- Marco RussoTabular Modeling in Microsoft SQL Server Analysis Services50,99 €
- Thomas NieldGetting Started with SQL30,99 €
- Itzik Ben-GanT-SQL Window Functions32,99 €
- Randolph WestSQL Server 2022 Administration Inside Out50,99 €
- Paul S. GanneyIntroduction to Bioinformatics and Clinical Scientific Computing103,99 €
- Alice ZhaoSQL Pocket Guide35,99 €
- Jiawei Han (Department of Computer ScienceUniversity of ProfessorData Mining91,99 €
Produktdetails
- Produktdetails
- The Morgan Kaufmann Series in Data Management Systems
- Verlag: Elsevier Science & Technology
- 5 ed
- Seitenzahl: 852
- Erscheinungstermin: 2. Dezember 2014
- Englisch
- Abmessung: 236mm x 192mm x 48mm
- Gewicht: 1708g
- ISBN-13: 9780128007617
- ISBN-10: 0128007613
- Artikelnr.: 41657241
- The Morgan Kaufmann Series in Data Management Systems
- Verlag: Elsevier Science & Technology
- 5 ed
- Seitenzahl: 852
- Erscheinungstermin: 2. Dezember 2014
- Englisch
- Abmessung: 236mm x 192mm x 48mm
- Gewicht: 1708g
- ISBN-13: 9780128007617
- ISBN-10: 0128007613
- Artikelnr.: 41657241
Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas. He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.
PART I : Data Declaration Features1. Databases versus File Systems2.
Transactions and Concurrency Control3. Tables4. Keys, Exposed Physical
Locators and Generated Values5. Normalization6. VIEWs and CTEs7. Auxiliary
Tables and Views8. Other Schema Objects9. DDL Flaws to Avoid
PART II : Data Types10. Numeric Data in SQL11. Character Data Types in
SQL12. Temporal Data Types in SQL13. Multiple Column Data Elements14. NULLs
and 3-Valued Logic in SQL15. Table Administration Operations16. Set
Operators
PART III Row and Column Level Features17. Comparison or Theta Operators18.
Quantified Subquery Predicates19. BETWEEN and OVERLAPS Predicates20. CASE
Expression Family21. LIKE and SIMILAR TO Predicates22. Simple One Table
SELECT Statements23. Intermediate Aggregate Functions24. Descriptive
Statistic Aggregate Functions25. OLAP Aggregate Functions26. JOINs
PART IV: Data Structures in SQL27. Graphs in SQL28. Trees and Hierarchies
in SQL29. Queues and Lists30. Matrices in SQL
PART V: Typical Queries31. Coverings and Partitions32. Runs, Gaps, and
Islands Rewrite or Expansion33. Inventory and Auction Models34. Relational
Division35. Temporal Queries and Operations
PART VI: Implementation and Coding Issues36. Access Methods37. Basic
Optimization Principles38. Overview of SQL/PSM
Transactions and Concurrency Control3. Tables4. Keys, Exposed Physical
Locators and Generated Values5. Normalization6. VIEWs and CTEs7. Auxiliary
Tables and Views8. Other Schema Objects9. DDL Flaws to Avoid
PART II : Data Types10. Numeric Data in SQL11. Character Data Types in
SQL12. Temporal Data Types in SQL13. Multiple Column Data Elements14. NULLs
and 3-Valued Logic in SQL15. Table Administration Operations16. Set
Operators
PART III Row and Column Level Features17. Comparison or Theta Operators18.
Quantified Subquery Predicates19. BETWEEN and OVERLAPS Predicates20. CASE
Expression Family21. LIKE and SIMILAR TO Predicates22. Simple One Table
SELECT Statements23. Intermediate Aggregate Functions24. Descriptive
Statistic Aggregate Functions25. OLAP Aggregate Functions26. JOINs
PART IV: Data Structures in SQL27. Graphs in SQL28. Trees and Hierarchies
in SQL29. Queues and Lists30. Matrices in SQL
PART V: Typical Queries31. Coverings and Partitions32. Runs, Gaps, and
Islands Rewrite or Expansion33. Inventory and Auction Models34. Relational
Division35. Temporal Queries and Operations
PART VI: Implementation and Coding Issues36. Access Methods37. Basic
Optimization Principles38. Overview of SQL/PSM
PART I : Data Declaration Features1. Databases versus File Systems2.
Transactions and Concurrency Control3. Tables4. Keys, Exposed Physical
Locators and Generated Values5. Normalization6. VIEWs and CTEs7. Auxiliary
Tables and Views8. Other Schema Objects9. DDL Flaws to Avoid
PART II : Data Types10. Numeric Data in SQL11. Character Data Types in
SQL12. Temporal Data Types in SQL13. Multiple Column Data Elements14. NULLs
and 3-Valued Logic in SQL15. Table Administration Operations16. Set
Operators
PART III Row and Column Level Features17. Comparison or Theta Operators18.
Quantified Subquery Predicates19. BETWEEN and OVERLAPS Predicates20. CASE
Expression Family21. LIKE and SIMILAR TO Predicates22. Simple One Table
SELECT Statements23. Intermediate Aggregate Functions24. Descriptive
Statistic Aggregate Functions25. OLAP Aggregate Functions26. JOINs
PART IV: Data Structures in SQL27. Graphs in SQL28. Trees and Hierarchies
in SQL29. Queues and Lists30. Matrices in SQL
PART V: Typical Queries31. Coverings and Partitions32. Runs, Gaps, and
Islands Rewrite or Expansion33. Inventory and Auction Models34. Relational
Division35. Temporal Queries and Operations
PART VI: Implementation and Coding Issues36. Access Methods37. Basic
Optimization Principles38. Overview of SQL/PSM
Transactions and Concurrency Control3. Tables4. Keys, Exposed Physical
Locators and Generated Values5. Normalization6. VIEWs and CTEs7. Auxiliary
Tables and Views8. Other Schema Objects9. DDL Flaws to Avoid
PART II : Data Types10. Numeric Data in SQL11. Character Data Types in
SQL12. Temporal Data Types in SQL13. Multiple Column Data Elements14. NULLs
and 3-Valued Logic in SQL15. Table Administration Operations16. Set
Operators
PART III Row and Column Level Features17. Comparison or Theta Operators18.
Quantified Subquery Predicates19. BETWEEN and OVERLAPS Predicates20. CASE
Expression Family21. LIKE and SIMILAR TO Predicates22. Simple One Table
SELECT Statements23. Intermediate Aggregate Functions24. Descriptive
Statistic Aggregate Functions25. OLAP Aggregate Functions26. JOINs
PART IV: Data Structures in SQL27. Graphs in SQL28. Trees and Hierarchies
in SQL29. Queues and Lists30. Matrices in SQL
PART V: Typical Queries31. Coverings and Partitions32. Runs, Gaps, and
Islands Rewrite or Expansion33. Inventory and Auction Models34. Relational
Division35. Temporal Queries and Operations
PART VI: Implementation and Coding Issues36. Access Methods37. Basic
Optimization Principles38. Overview of SQL/PSM