Effective SQL 61 specific ways to write better SQL
Presents practical solutions and insights for solving complex problems with SQL and designing databases that simplify data management in the future. Brings together advanced best practices and realistic example code for all of these versions of SQL: IBM DB2, Microsoft Access, Microsoft SQL Server, M...
Main Authors: | , , |
---|---|
Format: | eBook |
Language: | English |
Published: |
Boston
Addison-Wesley
2017
|
Series: | Effective software development series
|
Subjects: | |
Online Access: | |
Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Data model design
- Programmability and index design
- When you can't change the design
- Filtering and finding data
- Aggregation
- Subqueries
- Getting and analyzing metadata
- Cartesian products
- Tally tables
- Modeling hierarchical data
- Appendix: Date and time types, operations, and functions