𝔖 Scriptorium
✦   LIBER   ✦

📁

SQL Pocket Guide

✍ Scribed by Alice Zhao


Publisher
O'Reilly Media
Year
2021
Tongue
English
Leaves
420
Edition
4
Category
Library

⬇  Acquire This Volume

No coin nor oath required. For personal study only.

✦ Synopsis


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
  • NEW: Connect Python and R to a relational database
  • NEW: Look up frequently asked SQL questions in the "How Do I?" chapter

📜 SIMILAR VOLUMES


SQL Pocket Guide (Pocket Guides)
✍ Jonathan Gennick 📂 Library 📅 2010 🏛 O Reilly Media 🌐 English

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. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database

SQL Pocket Guide
✍ Jonathan Gennick 📂 Library 📅 2010 🏛 O'Reilly Media 🌐 English

<DIV><p>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. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle D

SQL Pocket Guide
✍ Jonathan Gennick 📂 Library 📅 2010 🏛 O'Reilly Media 🌐 English

<DIV><p>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. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle D

SQL Pocket Guide
✍ Jonathan Gennick 📂 Library 📅 2010 🏛 O'Reilly Media 🌐 English

<DIV><p>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. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle D

SQL Pocket Guide
✍ Gennick, Jonathan 📂 Library 📅 2011 🏛 O'Reilly Media 🌐 English

<p>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.

SQL. Pocket guide
✍ Элис Жао 📂 Library 📅 2024 🏛 Спринт Бук 🌐 Russian

Если вы аналитик или инженер по обработке данных и используете SQL, популярный карманный справочник станет для вас идеальным помощником. Найдите множество примеров, раскрывающих все сложности языка, а также ключевые аспекты SQL при его использовании в Microsoft SQL Server, MySQL, Oracle Database, Po