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

By:

Molinaro, Anthony, database developer [author.]

Contributor(s):

De Graaf, Robert W [author.]

Material type: Text

text

Media type:

unmediated

Carrier type:

volume

ISBN:

9781492077442
1492077445

Subject(s):

DDC classification:

005.7585 MOL 2020 23

LOC classification:

QA76.73.S67 M65 2020

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.

Average rating: 0.0 (0 votes)

Holdings
Item type	Current library	Call number	Status	Date due	Barcode
Book	Symbiosis International University, Dubai	005.7585 MOL 2020 (Browse shelf(Opens below))	Available		SIU01381

Browsing Symbiosis International University, Dubai shelves Close shelf browser (Hides shelf browser)

Previous								Next
Previous	005.758 BEA 2020 Learning SQL : generate, manipulate, and retrieve data /	005.758 BEA 2020 Learning SQL : generate, manipulate, and retrieve data /	005.758 BEA 2020 Learning SQL : generate, manipulate, and retrieve data /	005.7585 MOL 2020 SQL cookbook : query solutions and techniques for all SQL users /	005.8 BOS 2020 Human dimensions of cybersecurity /	005.8 BOS 2020 Human dimensions of cybersecurity /	005.8 CHA 2020 Cybersecurity for information professionals : concepts and applications /	Next

Previous edition: 2006.

Includes index.

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.