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

SQL Cookbook: Query Solutions and Techniques for All SQL Users, 2nd Edition
ePUB
  • eBook:
    SQL Cookbook: Query Solutions and Techniques for All SQL Users, 2nd Edition
  • Author:
    Anthony Molinaro, Robert de Graaf
  • Edition:
    2 edition
  • Categories:
  • Data:
    December 1, 2020
  • ISBN:
    1492077445
  • ISBN-13:
    9781492077442
  • Language:
    English
  • Pages:
    572 pages
  • Format:
    ePUB

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

Content

1. Retrieving Records
2. Sorting Query Results
3. Working with Multiple Tables
4. Inserting, Updating, and Deleting
5. Metadata Queries
6. Working with Strings
7. Working with Numbers
8. Date Arithmetic
9. Date Manipulation
10. Working with Ranges
11. Advanced Searching
12. Reporting and Reshaping
13. Hierarchical Queries
14. Odds ’n’ Ends

Download SQL Cookbook: Query Solutions and Techniques for All SQL Users, 2nd Edition PDF or ePUB format free


Free sample


Download in .ePUB format


Add comments
Прокомментировать
Введите код с картинки:*
Кликните на изображение чтобы обновить код, если он неразборчив
Copyright © 2019