SQL Pocket Guide

SQL Pocket Guide

Author: Alice Zhao

Publisher: O'Reilly Media

ISBN: 1492090409

Category:

Page: 250

View: 808

If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is the 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. The updated edition 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 NEW: Connect Python and R to a relational database NEW: Look up frequently asked SQL questions in the "How Do I?" chapter The book's example SQL statements execute against a set of tables, with data that you can quickly download.
SQL Pocket Guide
Language: en
Pages: 250

SQL Pocket Guide

Authors: Alice Zhao
Categories:
Type: BOOK - Published: 2022-01-18 - Publisher: O'Reilly Media

If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is the 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,
SQL Pocket Guide
Language: en
Pages: 356

SQL Pocket Guide

Authors: Alice Zhao
Categories:
Type: BOOK - Published: 2021-08-26 - Publisher: "O'Reilly Media, Inc."

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,
SQL Pocket Guide
Language: en
Pages: 164

SQL Pocket Guide

Authors: Jonathan Gennick
Categories: Computers
Type: BOOK - Published: 2004 - Publisher: "O'Reilly Media, Inc."

This pocket guide presents the most crucial information about SQL in a compact and easily accessible format, covering the four commonly used SQL variants--Oracle, IBM DB2, Microsoft SQL Server, and MySQL. Topics include: Data manipulation statements (SELECT, DELETE, INSERT, UPDATE, MERGE) and transaction control statements (START TRANSACTION, SAVEPOINT, COMMIT, ROLLBACK).
SQL Pocket Guide
Language: en
Pages: 192

SQL Pocket Guide

Authors: Jonathan Gennick
Categories: Computers
Type: BOOK - Published: 2006-04-17 - Publisher: "O'Reilly Media, Inc."

SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good
SQL Pocket Guide
Language: en
Pages: 27

SQL Pocket Guide

Authors: Jonathan Gennick
Categories: Computers
Type: BOOK - Published: - Publisher: Innocent Musanzikwa

Whether you are a college student learning about databases, an interview candidate for a job requiring SQL skills or a seasoned SQL developer wanting to have a go to guide for your syntax code, a quick reference guide surely comes in handy when you have the “uhmm, what’s the code