SQL pocket guide
(eBook)
Author
Published
Sebastopol, CA : O'Reilly, 2010, ©2011.
Format
eBook
Edition
3rd ed.
ISBN
1449394094, 9781449394097
Physical Desc
1 online resource (vii, 196 pages) : illustrations
Status
Description
Loading Description...
Also in this Series
Checking series information...
More Details
Language
English
Notes
Description
Annotation,
For programmers and database administrators who use SQL in their 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 querying, managing transactions, and making changes to data, as well as SQL functions, type conversion functions and formats, and regular expression syntax.
The third edition covers important database changes, including:
- Oracle's support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators
- Functions new to Oracle, such as LISTAGG, NTH_VALUE, and more
- PostgreSQL's support of recursive WITH and some window functions
- DB2 syntax and datatypes, some for compatibility with Oracle
- MySQL features such as the TIMESTAMP type and the TO_SECONDS function
Local note
O'Reilly,O'Reilly Online Learning: Academic/Public Library Edition
Reviews from GoodReads
Loading GoodReads Reviews.
Citations
APA Citation, 7th Edition (style guide)
Gennick, J. (20102011). SQL pocket guide (3rd ed.). O'Reilly.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Gennick, Jonathan. 20102011. SQL Pocket Guide. O'Reilly.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Gennick, Jonathan. SQL Pocket Guide O'Reilly, 20102011.
MLA Citation, 9th Edition (style guide)Gennick, Jonathan. SQL Pocket Guide 3rd ed., O'Reilly, 20102011.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.
Staff View
Grouped Work ID
f16fbe86-88ba-2988-678f-fd5010aba373-eng
Grouping Information
| Grouped Work ID | f16fbe86-88ba-2988-678f-fd5010aba373-eng |
|---|---|
| Full title | sql pocket guide |
| Author | gennick jonathan |
| Grouping Category | book |
| Last Update | 2024-04-16 12:23:35PM |
| Last Indexed | 2024-04-17 04:34:49AM |
Book Cover Information
| Image Source | syndetics |
|---|---|
| First Loaded | Jun 26, 2022 |
| Last Used | Apr 8, 2024 |
Marc Record
| First Detected | Nov 09, 2022 03:40:50 PM |
|---|---|
| Last File Modification Time | Apr 16, 2024 12:27:35 PM |
MARC Record
| LEADER | 03215cam a2200541 a 4500 | ||
|---|---|---|---|
| 001 | ocn740435585 | ||
| 003 | OCoLC | ||
| 005 | 20240405112445.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 110711t20102011caua o 001 0 eng d | ||
| 020 | |a 1449394094 | ||
| 020 | |a 9781449394097 | ||
| 020 | |z 9781449394097 | ||
| 029 | 1 | |a DEBSZ|b 368475395 | |
| 029 | 1 | |a AU@|b 000067113467 | |
| 035 | |a (OCoLC)740435585 | ||
| 037 | |a CL0500000095|b Safari Books Online | ||
| 040 | |a UMI|b eng|e pn|c UMI|d COO|d C6I|d OCLCQ|d DEBSZ|d OCLCF|d OCLCQ|d YDXCP|d OCLCQ|d CEF|d AU@|d WYU|d UAB|d OCLCQ|d VT2|d OCLCO|d OCLCQ|d INARC|d OCLCQ|d OCLCO|d OCLCQ | ||
| 049 | |a TKLA | ||
| 050 | 4 | |a QA76.73.S67|b G47 2011 | |
| 082 | 0 | 4 | |a 005.75/65|2 22 |
| 100 | 1 | |a Gennick, Jonathan.|0 http://id.loc.gov/authorities/names/n98015027 | |
| 245 | 1 | 0 | |a SQL pocket guide /|c Jonathan Gennick. |
| 250 | |a 3rd ed. | ||
| 260 | |a Sebastopol, CA :|b O'Reilly,|c 2010, ©2011. | ||
| 300 | |a 1 online resource (vii, 196 pages) :|b illustrations | ||
| 336 | |a text|b txt|2 rdacontent | ||
| 337 | |a computer|b c|2 rdamedia | ||
| 338 | |a online resource|b cr|2 rdacarrier | ||
| 520 | 8 | |a Annotation|b <p>For programmers and database administrators who use SQL in their 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 querying, managing transactions, and making changes to data, as well as SQL functions, type conversion functions and formats, and regular expression syntax.</p><p>The third edition covers important database changes, including:</p><ul><li>Oracle's support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators</li><li>Functions new to Oracle, such as LISTAGG, NTH_VALUE, and more</li><li>PostgreSQL's support of recursive WITH and some window functions</li><li>DB2 syntax and datatypes, some for compatibility with Oracle</li><li>MySQL features such as the TIMESTAMP type and the TO_SECONDS function</li></ul> | |
| 588 | 0 | |a Print version record. | |
| 590 | |a O'Reilly|b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 650 | 0 | |a SQL (Computer program language)|0 http://id.loc.gov/authorities/subjects/sh86006628 | |
| 650 | 0 | |a Relational databases.|0 http://id.loc.gov/authorities/subjects/sh86007768 | |
| 650 | 0 | |a Database management.|0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 6 | |a Bases de données relationnelles. | |
| 650 | 6 | |a Bases de données|x Gestion. | |
| 650 | 7 | |a Database management|2 fast | |
| 650 | 7 | |a Relational databases|2 fast | |
| 650 | 7 | |a SQL (Computer program language)|2 fast | |
| 776 | 0 | 8 | |i Print version:|a Gennick, Jonathan.|t SQL pocket guide.|b 3rd ed.|d Sebastopol, CA : O'Reilly, ©2011|z 1449394094|w (OCoLC)653086433 |
| 856 | 4 | 0 | |u https://ezproxy.knoxlib.org/login?url=https://learning.oreilly.com/library/view/~/9781449397586/?ar |
| 938 | |a Internet Archive|b INAR|n sqlpocketguide0000genn | ||
| 938 | |a YBP Library Services|b YANK|n 7489339 | ||
| 938 | |a YBP Library Services|b YANK|n 7408186 | ||
| 994 | |a 92|b TKL | ||