SQL Cookbook, 2nd Edition

Query Solutions and Techniques for All SQL Users



Bookstore > Books > SQL Cookbook, 2nd Edition

Price$44.41 - $58.45
Rating
AuthorsAnthony Molinaro, Robert de Graaf
PublisherO'Reilly Media
Published2020
Pages572
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101492077445
ISBN-139781492077442
EBook Hardcover Paperback

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 2nd 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.




5 5 376

Similar Books


Visual Studio 2015 Cookbook, 2nd Edition

Visual Studio 2015 Cookbook, 2nd Edition

by Jeff Martin

Visual Studio 2015 is the premier tool for developers targeting the Microsoft platform. Learning how to effectively use this technology can enhance your productivity while simplifying your most common tasks, allowing you more time to focus on your project. Visual Studio 2015 is packed with improvements that increase productivity, and this...

Price:  $34.99  |  Publisher:  Packt Publishing  |  Release:  2016

Java Cookbook, 2nd Edition

Java Cookbook, 2nd Edition

by Ian F. Darwin

You have a choice: you can wade your way through lengthy Java tutorials and figure things out by trial and error, or you can pick up Java Cookbook, 2nd Edition and get to the heart of what you need to know when you need to know it.With the completely revised and thoroughly updated Java Cookbook, 2nd Edition, Java developers like you will ...

Price:  $3.89  |  Publisher:  O'Reilly Media  |  Release:  2004

Python Cookbook, 2nd Edition

Python Cookbook, 2nd Edition

by Alex Martelli, Anna Ravenscroft, David Ascher

Portable, powerful, and a breeze to use, Python is the popular open source object-oriented programming language used for both standalone programs and scripting applications. It is now being used by an increasing number of major organizations, including NASA and Google.Updated for Python 2.4, The Python Cookbook, 2nd Edition offers a wealt...

Price:  $7.17  |  Publisher:  O'Reilly Media  |  Release:  2005

Windows PowerShell Cookbook, 2nd Edition

Windows PowerShell Cookbook, 2nd Edition

by Lee Holmes

This introduction to the Windows PowerShell language and scripting environment provides more than 430 task-oriented recipes to help you solve the most complex and pressing problems, and includes more than 100 tried-and-tested scripts that intermediate to advanced system administrators can copy and use immediately. You'll find hands-o...

Price:  $6.58  |  Publisher:  O'Reilly Media  |  Release:  2010

Expert Performance Indexing in SQL Server, 2nd Edition

Expert Performance Indexing in SQL Server, 2nd Edition

by Grant Fritchey, Jason Strate

This book is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that ar...

Price:  $56.42  |  Publisher:  Apress  |  Release:  2015

Beginning SQL Queries, 2nd Edition

Beginning SQL Queries, 2nd Edition

by Clare Churcher

Get started on mastering the one language binding the entire database industry. That language is SQL, and how it works is must-have knowledge for anyone involved with relational databases, and surprisingly also for anyone involved with NoSQL databases. SQL is universally used in querying and reporting on large data sets in order to genera...

Price:  $23.95  |  Publisher:  Apress  |  Release:  2016

Linux Cookbook, 2nd Edition

Linux Cookbook, 2nd Edition

by Michael Stutz

The Linux Cookbook, 2nd Edition is your guide to getting the most out of Linux. Organized by general task (such as working with text, managing files, and manipulating graphics), each section contains a series of step-by-step recipes that help you to get your work done quickly and efficiently, most often from the command line. Nearly 50 pe...

Price:  $17.60  |  Publisher:  O'Reilly Media  |  Release:  2004

Linux Shell Scripting Cookbook, 2nd Edition

Linux Shell Scripting Cookbook, 2nd Edition

by Shantanu Tushar, Sarath Lakshman

The shell remains one of the most powerful tools on a computer system - yet a large number of users are unaware of how much one can accomplish with it. Using a combination of simple commands, we will see how to solve complex problems in day to day computer usage.Linux Shell Scripting Cookbook, 2nd Edition will take you through useful real...

Price:  $6.23  |  Publisher:  Packt Publishing  |  Release:  2013