SQL Pocket Guide, 4th Edition

A Guide to SQL Usage



Bookstore > Books > SQL Pocket Guide, 4th Edition

Price$25.99 - $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.





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

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

Linux Pocket Guide, 2nd Edition

Linux Pocket Guide, 2nd Edition

by Daniel J. Barrett

If you use Linux in your day-to-day work, this popular pocket guide is the perfect on-the-job reference. The second edition has expanded from Fedora-only coverage to distro-neutral, with practical information on a wider range of commands requested by readers.Linux Pocket Guide provides an organized learning path for Linux use, rather than...

Price:  $12.36  |  Publisher:  O'Reilly Media  |  Release:  2012

CSS Pocket Reference, 4th Edition

CSS Pocket Reference, 4th Edition

by Eric A. Meyer

When you're working with CSS and need a quick answer, CSS Pocket Reference delivers. This handy, concise book provides all of the essential information you need to implement CSS on the fly. Ideal for intermediate to advanced web designers and developers, the 4th edition is revised and updated for CSS3, the latest version of the Casca...

Price:  $2.20  |  Publisher:  O'Reilly Media  |  Release:  2011