Effective sql : 61 specific ways to write better sql / John L. Viescas, Douglas J. Steele, Ben G. Clothier.

By:

Viescas, John L

Material type: Text

TextLanguage: English Publication details: Boston Addison-Wesley, 2017Description: pages cmISBN:

9780134578897 (pbk. : alk. paper)

DDC classification:

23 005.756 VIE

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.

Tags from this library: No tags from this library for this title. Log in to add tags.

Average rating: 0.0 (0 votes)

Holdings
Item type	Current library	Collection	Call number	Status	Date due	Barcode
General Books	CUTN Central Library Generalia	Non-fiction	005.756 VIE (Browse shelf(Opens below))	Available		37326

Browsing CUTN Central Library shelves, Shelving location: Generalia, Collection: Non-fiction Close shelf browser (Hides shelf browser)

Previous								Next
Previous	005.75 KAH Introduction to database management systems	005.756 DAT A guide to the SQL standard :	005.756 MEL Advanced SQL, 1999 :	005.756 VIE Effective sql :	005.757 NAY Advance object oriented programming	005.758 KRI Internet & Java Programming	005.758 RAY Distributed database systems	Next

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.

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.

There are no comments on this title.

to post a comment.