SQL Pocket Guide, 4th Edition

A Guide to SQL Usage



Bookstore > Books > SQL Pocket Guide, 4th Edition

Price$28.14 - $29.99
Rating
AuthorAlice Zhao
PublisherO'Reilly Media
Published2021
Pages356
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101492090409
ISBN-139781492090403
EBook Hardcover Paperback

If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is your ideal on-the-job reference. You'll find many examples that address the language's complexities, along with key aspects of SQL used in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, and SQLite.

In this updated edition, author Alice Zhao describes how these database management systems implement SQL syntax for both querying and making changes to a database. You'll find details on data types and conversions, regular expression syntax, window functions, pivoting and unpivoting, and more.

Quickly look up how to perform specific tasks using SQL; Apply the book's syntax examples to your own queries; Update SQL queries to work in five different database management systems; Connect Python and R to a relational database; Look up frequently asked SQL questions in the "How Do I?" chapter.




5 5 8

Similar Books


SQL Pocket Guide, 3rd Edition

SQL Pocket Guide, 3rd Edition

by Jonathan Gennick

If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. It uses numerous examples to address the language's complexity, and covers key aspects of SQL used in Oracle, DB2, SQL Server, MySQL, and PostgreSQL. That includes the syntax for que...

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

SharePoint 2013 User's Guide, 4th Edition

SharePoint 2013 User's Guide, 4th Edition

by Anthony Smith

Microsoft SharePoint 2013 provides a collection of tools and services you can use to improve user and team productivity, make information sharing more effective, and facilitate business decision - making processes. In order to get the most out of SharePoint 2013, you need to understand how to best use the capabilities to support your info...

Price:  $49.99  |  Publisher:  Apress  |  Release:  2013

Pro T-SQL Programmer's Guide, 4th Edition

Pro T-SQL Programmer's Guide, 4th Edition

by Miguel Cebollero, Michael Coles, Jay Natarajan

Pro T-SQL Programmer's Guide is your guide to making the best use of the powerful, Transact-SQL programming language that is built into Microsoft SQL Server's database engine. This edition is updated to cover the new, in-memory features that are part of SQL Server 2014. Discussing new and existing features, the book takes you on...

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

HTML: A Beginner's Guide, 4th Edition

HTML: A Beginner's Guide, 4th Edition

by Wendy Willard

You will learn how to structure a page, place images, size text, create links, generate Web-safe colors, work with multimedia, and more. Hands-on exercises, notes, and ask-the-expert sections make it easy to learn the essential skills.HTML: A Beginner's Guide, 4th Edition book covers more efficient coding techniques using CSS; going ...

Publisher:  McGraw-Hill  |  Release:  2009

Digital Photography Pocket Guide, 3rd Edition

Digital Photography Pocket Guide, 3rd Edition

by Derrick Story

Who can resist the instant gratification of the digital camera? For everyone who owns or will own a digital camera, Derrick Story delivers Digital Photography Pocket Guide, 3rd Edition--the perfect on-the-go guide for taking top-notch digital photos. In full color, this third edition of the bestselling pocket guide covers everything from ...

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

Java Pocket Guide, 4th Edition

Java Pocket Guide, 4th Edition

by Robert Liguori, Patricia Liguori

Any time you need quick answers for developing or debugging Java programs, this pocket guide is the ideal reference to standard features of the Java programming language and its platform. You'll find helpful programming examples, tables, figures, and lists fast - including Java 9 features such as modular source code and the new JShel...

Price:  $10.07  |  Publisher:  O'Reilly Media  |  Release:  2017

Oracle PL/SQL Language Pocket Reference, 4th Edition

Oracle PL/SQL Language Pocket Reference, 4th Edition

by Steven Feuerstein, Bill Pribyl, Chip Dawes

The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. A companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming, this concise guide boils down the most vital PL/SQL inf...

Price:  $5.98  |  Publisher:  O'Reilly Media  |  Release:  2007

Mac OS X Snow Leopard Pocket Guide

Mac OS X Snow Leopard Pocket Guide

by Chris Seibold

Whether you're new to the Mac or a longtime user, this handy book is the quickest way to get up to speed on Snow Leopard. Packed with concise information in an easy-to-read format, Mac OS X Snow Leopard Pocket Guide covers what you need to know and is an ideal resource for problem-solving on the fly.This book goes right to the heart ...

Price:  $5.53  |  Publisher:  O'Reilly Media  |  Release:  2009