Welcome to Central Library, SUST
Amazon cover image
Image from Amazon.com
Image from Google Jackets

SQL cookbook : query solutions and techniques for all SQL users / Anthony Molinaro and Robert de Graaf.

By: Contributor(s): Material type: TextTextPublisher: Sebastopol, CA : O'Reilly Media, 2020Copyright date: �2021Edition: Second editionDescription: xx, 547 pages ; 24 cmContent type:
  • text
Media type:
  • unmediated
Carrier type:
  • volume
ISBN:
  • 9789385889554
Subject(s): DDC classification:
  • 005.7585 23 MOS
Contents:
Retrieving records -- Sorting query results -- Working with multiple tables -- Inserting, updating, and deleting -- Metadata queries -- Working with strings -- Working with numbers -- Date arithmetic -- Date manipulation -- Working with ranges -- Advanced searching -- Reporting and reshaping -- Hierarchical queries -- Odds 'n' ends.
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. No other resource offers recipes in this unique format to help you tackle nagging day-to-day conundrums with SQL.
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 Call number Copy number Status Date due Barcode
Books Books Central Library, SUST General Stacks 005.7585 MOS (Browse shelf(Opens below)) 1 Available 0078787
Books Books Central Library, SUST General Stacks 005.7585 MOS (Browse shelf(Opens below)) 2 Available 0078788

Previous edition: 2006.

Includes index.

Retrieving records -- Sorting query results -- Working with multiple tables -- Inserting, updating, and deleting -- Metadata queries -- Working with strings -- Working with numbers -- Date arithmetic -- Date manipulation -- Working with ranges -- Advanced searching -- Reporting and reshaping -- Hierarchical queries -- Odds 'n' ends.

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. No other resource offers recipes in this unique format to help you tackle nagging day-to-day conundrums with SQL.

There are no comments on this title.

to post a comment.