SQL Pocket Guide, 4th Edition
A Guide to SQL Usage
Price | $28.14 - $29.99
|
Rating | |
Author | Alice Zhao |
Publisher | O'Reilly Media |
Published | 2021 |
Pages | 356 |
Language | English |
Format | Paper book / ebook (PDF) |
ISBN-10 | 1492090409 |
ISBN-13 | 9781492090403 |
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.
- Alice Zhao
5 5 8
Similar Books
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
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
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
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
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
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
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
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