Amazon cover image
Image from Amazon.com

SQL Cookbook / Anthony Molinaro and Robert de Graaf

By: Contributor(s): Material type: TextTextPublication details: [Place of publication not identified] : O'Reilly Media, 2021ISBN:
  • 9781492077442
Subject(s): Online resources:
Contents:
Chapter 1. Retrieving Records -- Chapter 2. Sorting Query Results -- Chapter 3. Working with Multiple Tables -- Chapter 4. Inserting, Updating, and Deleting -- Chapter 5. Metadata Queries -- Chapter 6. Working with Strings -- Chapter 7. Working with Numbers -- Chapter 8. Date Arithmetic -- Chapter 9. Date Manipulation -- Chapter 10. Working with Ranges -- Chapter 11. Advanced Searching -- Chapter 12. Reporting and Reshaping -- Chapter 13. Hierarchical Queries -- Chapter 14. Odds 'n' Ends -- Appendix A. Window Function Refresher -- Appendix B. Common Table Expressions.
Summary: You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated cookbook provides a framework to help you construct solutions and executable examples in several flavors of SQL, including Oracle, DB2, SQL Server, MySQL, and PostgreSQL.SQL programmers, analysts, data scientists, database administrators, and even relatively casual SQL users will find SQL Cookbook to be a valuable problem-solving guide for everyday issues.
Item type: Electronic Resources
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Home library Collection Call number Copy number Status Date due Barcode
Electronic Resources Electronic Resources National University - Manila LRC - Main Electronic Books Multimedia Arts and Animation c.1 Available EBK000000007

1 user

Includes index.

Chapter 1. Retrieving Records -- Chapter 2. Sorting Query Results -- Chapter 3. Working with Multiple Tables -- Chapter 4. Inserting, Updating, and Deleting -- Chapter 5. Metadata Queries -- Chapter 6. Working with Strings -- Chapter 7. Working with Numbers -- Chapter 8. Date Arithmetic -- Chapter 9. Date Manipulation -- Chapter 10. Working with Ranges -- Chapter 11. Advanced Searching -- Chapter 12. Reporting and Reshaping -- Chapter 13. Hierarchical Queries -- Chapter 14. Odds 'n' Ends -- Appendix A. Window Function Refresher -- Appendix B. Common Table Expressions.

You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated cookbook provides a framework to help you construct solutions and executable examples in several flavors of SQL, including Oracle, DB2, SQL Server, MySQL, and PostgreSQL.SQL programmers, analysts, data scientists, database administrators, and even relatively casual SQL users will find SQL Cookbook to be a valuable problem-solving guide for everyday issues.

There are no comments on this title.

to post a comment.