SQL Cookbook:Query Solutions and Techniques for All SQL Users,2nd Edition


SQL Cookbook:Query Solutions and Techniques for All SQL Users
Authors:Anthony Molinaro
Robert de Graaf
Release Finelybook 出版日期:2020
Publisher Finelybook 出版社:O'Reilly Media
ISBN-13 书号:9781492077442
ISBN-10 书号:1492077445

Book Description
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 severalflavors of SQL,including Oracle,DB2,SQL Server,MySQL,andPostgreSQL.
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. No other resource offers recipes in this unique format to help you tackle nagging day-to-day conundrums with SQL.
The second edition includes:

Fully revised recipes that recognize the greater adoption of window functions in SQL implementations
Additional recipes that reflect the widespread adoption of common table expressions (CTEs) for more readable,easier-to-implement solutions
New recipes to make SQL more useful for people who aren’t database experts,including data scientists
Expanded solutions for working with numbers and strings
Up-to-date SQL recipes throughout the book to guide you through the basics
Table of Contents
Preface
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
Index
About the Authors

下载地址 Download隐藏内容需4积分,VIP免费,请先 !没有帐号? 注 册 一个!
觉得文章有用就打赏一下
未经允许不得转载:finelybook » SQL Cookbook:Query Solutions and Techniques for All SQL Users,2nd Edition

觉得文章有用就打赏一下

非常感谢你的打赏,我们将继续给力更多优质内容,让我们一起创建更加美好的网络世界!

支付宝扫一扫打赏

微信扫一扫打赏