000 01971nam a2200253Ia 4500
003 NULRC
005 20250308111703.0
008 241022s9999 xx 000 0 und d
020 _a9781492077442
040 _cNULRC
100 _aMolinaro, Anthony
_eauthor
245 0 _aSQL Cookbook /
_cAnthony Molinaro and Robert de Graaf
260 _a[Place of publication not identified] :
_bO'Reilly Media,
_c2021
365 _bUSD51.00
500 _a1 user
504 _aIncludes index.
505 _aChapter 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.
520 _aYou 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.
650 _aDATABASE MANAGEMENT
650 _aSQL (COMPUTER PROGRAM LANGUAGE)
700 _ade Graaf, Robert
_eco-author
856 _uhttps://research.ebsco.com/c/nahjoz/search/details/k3jgbobfnj?db=nlebk&db=nlabk
942 _2lcc
_cEL
999 _c660
_d660