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
Tip the Site
Support this siteYour recognition and a small knowledge-service contribution help keep this technical work open source.Scan the WeChat Pay or Alipay code below. Logged-in and guest visitors can both tip.
WeChat Pay
Alipay
Open WeChat or Alipay and scan. No login required.
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...
. 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...
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...
th ADD COLUMN, CHANGE COLUMN, and MODIFY COLUMN operations. For example, the following transaction creates a heap table with three columns, column_a, column_...
(argument)] [WITH CONTEXT] [PARAMETERS (parameter[, ...])] This clause allows you to define the C UDT body without resorting to the CREATE TYPE BODY statemen...
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...
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...
zed views, nested subqueries, partitioned views, and tables. Its DELETE syntax is as follows: DELETE [FROM] {table_name | ONLY (table_name)} [alias] [{PARTIT...
Support this siteYour recognition and a small knowledge-service contribution help keep this technical work open source.
Scan the WeChat Pay or Alipay code below. Logged-in and guest visitors can both tip.
WeChat PayAlipay
Open WeChat or Alipay and scan. No login required.
Add Tag
Enter tag name (max 50 characters)
Share E-Book
SQL in a Nutshell A Desktop Quick Reference, 4th Edition (Kevin Kline, Regina O. Obe, Leo S. Hsu)(Z-Library)
Scan QR code with your phone to access
Copy the link or scan the QR code to access this e-book on your phone
Share to WeChat Moments
SQL in a Nutshell A Desktop Quick Reference, 4th Edition (Kevin Kline, Regina O. Obe, Leo S. Hsu)(Z-Library)
Scan the QR code with WeChat to open this book
Tap the ··· menu in the top-right corner
Choose Share to Moments
You are already in WeChat. Tap ··· in the top-right corner and choose Share to Moments.
Share E-Book via Email
Please enter email address
Donation Statistics
¥.00
Total Donations
0
Donation Count
SQL in a Nutshell A Desktop Quick Reference, 4th Edition (Kevin Kline, Regina O. Obe, Leo S. Hsu)(Z-Library)
Find Your Favorite Books
Only registered users can comment after logging in. Comments need to be reviewed by administrators before being displayed
Loading comments...
Reply to Comment
Edit Comment