Description |
1 online resource (1 volume) : illustrations. |
Series |
Effective software development series |
|
Effective software development series.
|
Note |
Includes index. |
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. |
Summary |
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, MySQL, Oracle Database, and PostgreSQL. |
Subject |
SQL (Computer program language)
|
|
Databases.
|
|
SQL (Langage de programmation) |
|
Databases |
|
SQL (Computer program language) |
Added Author |
Steele, Douglas J., author.
|
|
Clothier, Ben, author.
|
Other Form: |
Print version: Viescas, John L., 1947- Effective SQL. ©2017 0134578899 9780134578897 (OCoLC)944156879 |
ISBN |
9780134579061 (electronic bk.) |
|
0134579062 (electronic bk.) |
|