| Ⅰ | 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 Pocket Guide is a valuable reference book for developers, administrators, and analysts who work with databases in their daily tasks. This compact and convenient guide provides a quick reference to the most commonly used SQL syntax and techniques, allowing users to quickly find the information they need to perform a variety of database tasks.
SQL Pocket Guide includes updated coverage of the latest SQL standards, as well as syntax and features from popular database management systems such as MySQL, PostgreSQL, Oracle, Microsoft SQL Server, and SQLite. The book is organized into short, easy-to-understand sections that cover all the major aspects of SQL, including data definition, data manipulation, and data querying.
In the data definition section, readers will find information on creating and altering tables, as well as on defining constraints, indexes, and views. The data manipulation section covers inserting, updating, and deleting data, as well as working with stored procedures and transactions. The data querying section includes comprehensive coverage of the SELECT statement, including subqueries, joins, aggregations, and sorting.
In addition, SQL Pocket Guide includes new chapters on window functions, recursive queries, and common table expressions. These features are increasingly being used in modern SQL development and the new edition of this book provides a thorough and easy-to-understand explanation of these concepts.
Overall, SQL Pocket Guide can be an indispensable guide for anyone who works with SQL databases. Especially, it is small enough to fit in a pocket or a bag, making it easy to take with you wherever you go. Whether you’re at your desk, on the road, or in a meeting, you’ll always have the SQL reference you need close at hand.
// Table Of Contents //
- Chapter 1. SQL Crash Course
- Chapter 2. Where Can I Write SQL Code?
- Chapter 3. The SQL Language
- Chapter 4. Querying Basics
- Chapter 5. Creating, Updating, and Deleting
- Chapter 6. Data Types
- Chapter 7. Operators and Functions
- Chapter 8. Advanced Querying Concepts
- Chapter 9. Working with Multiple Tables and Queries
- Chapter 10. How Do I…?
// Download URLs //
| Format | Download | Size |
| SQL Pocket Guide, 4th Edition | ||
 |
5.70 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. |