| Ⅰ | This article along with all titles and tags are the original content of AppNee. All rights reserved. To repost or reproduce, you must add an explicit footnote along with the URL to this article! |
| Ⅱ | Any manual or automated whole-website collecting/crawling behaviors are strictly prohibited. |
| Ⅲ | Any resources shared on AppNee are limited to personal study and research only, any form of commercial behaviors are strictly prohibited. Otherwise, you may receive a variety of copyright complaints and have to deal with them by yourself. |
| Ⅳ | Before using (especially downloading) any resources shared by AppNee, please first go to read our F.A.Q. page more or less. Otherwise, please bear all the consequences by yourself. |
| This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License. |
SQL is a database language used to build and maintain database objects, and is at the heart of many enterprise applications. If you’re involved in software development, you’re likely to use some level of SQL. When working with SQL, you need a good syntax reference. Although SQL is a standardized language, the implementation of SQL is not standardized, and there are many differences in software from one vendor to another.
SQL in a Nutshell serves as an indispensable resource for programmers, analysts, and database administrators. It provides a comprehensive reference for the SQL language used in today’s popular database products. It adheres to the latest ANSI/ISO standard and offers detailed documentation of SQL commands in Microsoft SQL Server, Oracle, MySQL, MariaDB, and PostgreSQL.
In addition to SQL commands, SQL in a Nutshell offers a concise overview of the relational database management system (RDBMS) model and explains foundational RDBMS concepts in a clear-cut manner. All of this valuable information is presented in a succinct, comprehensive, and user-friendly format.
SQL in a Nutshell is divided into sections that cover various aspects, including the background of the relational database model; current and previous SQL standards; fundamental concepts for understanding relational databases and SQL commands; an alphabetical command reference to SQL statements based on 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, and platform-specific functions unique to each implementation.
SQL in a Nutshell is a concise and valuable resource for anyone looking to quickly grasp the fundamentals of this essential programming language. It is not only a handy reference guide for experienced SQL programmers, analysts, and database administrators, but also an excellent resource for consultants and users who need to be familiar with the SQL language across multiple platforms.
// Table Of Contents //
- 1. SQL History and Implementations
- 2. Foundational Concepts
- 3. Structuring Your Data
- 4. Reading Your Data
- 5. Manipulating Your Data
- 6. Securing Your Data
- 7. SQL Built-in Functions
- 8. SQL Built-in Aggregate and Window Functions
- 9. Storing Logic in the Database
- 10. Flexible and Schemaless
- A. Shared and Platform-Specific Keywords
// Download URLs //
| Format | Download | Size |
| SQL in a Nutshell, 4th Edition | ||
 |
5.66 MB | |
(Homepage)
| If some download link is missing, and you do need it, just please send an email (along with post link and missing link) to remind us to reupload the missing file for you. And, give us some time to respond. | |
| If there is a password for an archive, it should be "appnee.com". | |
| Most of the reserved downloads (including the 32-bit version) can be requested to reupload via email. |