Share E-Book
Scan to open this page

Scan with your phone to open this page

Author: Kevin Kline, Regina O. Obe, Leo S. Hsu

Rating 4.0 AI initial rating

For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL language used in today's most popular database products. This new fourth edition clearly documents SQL commands according to the latest ANSI/ISO standard and details how those commands are implemented in Microsoft SQL Server 2019 and Oracle 19c, as well as in the MySQL 8, MariaDB 10.5, and PostgreSQL 13 open source database products. You'll also get a concise overview of the relational database management system (RDBMS) model and a clear-cut explanation of foundational RDBMS concepts--all packed into a succinct, comprehensive, and easy-to-use format. Sections include: Background on the relational database model, including current and previous SQL standards Fundamental concepts necessary for understanding relational databases and SQL commands An alphabetical command reference to SQL statements, according to the SQL:2016 ANSI standard The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server An alphabetical reference of the ANSI SQL:2016 functions and constructs as well as the vendor implementations Platform-specific functions unique to each implementation

AI Reading Assistant

Whole-book reading guide from stratified index samples; jump to passages in the text

Brief outline
【One-Line Pitch】 For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL la… 【Book Arc】 - **Opening (~0%–12%)**: 书名: SQL in a Nutshell A Desktop Quick Reference, 4th Edition (Kevin Kline, Regina O.; They were our guiding angels, but devilish when necessary. - **Early (~12%–35%)**: CHAR pads with blank spaces when it stores values but trims spaces upon retrieval, just as the SQL standard VARCHAR does.; INT for IDENTITY property rules that also apply to DECIMAL. - **Middle (~35%–65%)**: Local temporary tables are accessible only to the session that cre‐ ated them and are automatically dropped when that session terminates.; of acceptable data types and vendor variations. - **Late (~65%–88%)**: le associated with an external table and reclaim its space.; For example, the following statement drops the active_employees view in the hr schema: DROP VIEW hr.active_employees; - **Ending (~88%–100%)**: r it may be a specific list of literal values.; ITH but does not allow the RECURSIVE keyword; 【Key Takeaways】 - **书名: SQL in a Nutshell…** (Opening): 书名: SQL in a Nutshell A Desktop Quick Reference, 4th Edition (Kevin Kline, Regina O. - **They were our guiding angels** (Opening): They were our guiding angels, but devilish when necessary. - **The various other plat…** (Opening): The various other platforms also offer their own unique methods for performing arithmetic operations on date values. - **CHAR pads with blank s…** (Early): CHAR pads with blank spaces when it stores values but trims spaces upon retrieval, just as the SQL standard VARCHAR does. - **INT for IDENTITY prope…** (Early): INT for IDENTITY property rules that also apply to DECIMAL. - **REUSE tells Oracle to…** (Early): REUSE tells Oracle to overwrite an existing block change tracking file of the same name as 'file'. 【Reading Tips】 - Use Passage locations below to jump into the text and set reading anchors - Chinese and English guides are each generated once, then served from local cache without calling the model again 【Coverage Limits】 Compressed outline without the model (~32 index chunks). Full structured guide needs AI available.
Page 15
velopment editors: Gary O’Brien, who carried us through the worst of the pandemic, and Rita Fernando, for having brought our manuscript to completion. They w...
View in text
Excerpt 2
. It cannot be used in a CREATE TABLE statement. The CURSOR data type is always nullable. DATE (SQL standard data type: DATE) Holds a date in the range of Ja...
View in text
Excerpt 3
pub_name column and the first 10 characters of the country column: CREATE UNIQUE INDEX unq_pub_id ON publishers(pub_name(25), country(10)); As a general rule...
View in text
Excerpt 4
th ADD COLUMN, CHANGE COLUMN, and MODIFY COLUMN operations. For example, the following transaction creates a heap table with three columns, column_a, column_...
View in text
Excerpt 5
(argument)] [WITH CONTEXT] [PARAMETERS (parameter[, ...])] This clause allows you to define the C UDT body without resorting to the CREATE TYPE BODY statemen...
View in text
Excerpt 6
Your Data 2020 2 77 2020 3 91 2020 4 125 2021 NULL 268 -- total for year 2021 2021 1 139 2021 2 119 2021 3 10 The GROUP BY GROUPING SETS clause lets you aggr...
View in text
Excerpt 7
r it may be a specific list of literal values. LIKE pattern Allows you to insert dimension values into a pattern. Use a percent-sign to mark the location at...
View in text
Excerpt 8
zed views, nested subqueries, partitioned views, and tables. Its DELETE syntax is as follows: DELETE [FROM] {table_name | ONLY (table_name)} [alias] [{PARTIT...
View in text
Tags
AI categories
SQL
ISBN: 1492088862
Publisher: O'Reilly Media
Publish Year: 2022
Language: English
Pages: 841
File Format: PDF
File Size: 5.7 MB
Text Preview (First 20 pages)
Registered users can read the full content for free

Register as a Gaohf Library member to read the complete e-book online for free and enjoy a better reading experience.

Generating text preview…