Op werkdagen voor 23:00 besteld, morgen in huis Gratis verzending vanaf €20
, ,

SQL - In a Nutshell

A Desktop Quick Reference

Paperback Engels 2022 9781492088868
Verkooppositie 4150Hoogste positie: 4150
Verwachte levertijd ongeveer 8 werkdagen

Samenvatting

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 14 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

Specificaties

ISBN13:9781492088868
Taal:Engels
Bindwijze:paperback
Aantal pagina's:650
Uitgever:O'Reilly
Druk:4
Verschijningsdatum:24-6-2022
Hoofdrubriek:IT-management / ICT
ISSN:

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Geef uw waardering

Zeer goed Goed Voldoende Matig Slecht

Over Regina Obe

Regina Obe is a co-principal of Paragon Corporation, a database consulting company based in Boston. She has over 15 years of professional experience in various programming languages and database systems, with special focus on spatial databases. She is a member of the PostGIS steering committee and the PostGIS core development team. Regina holds a BS degree in mechanical engineering from the Massachusetts Institute of Technology. She co-authored PostGIS in Action and PostgreSQL: Up and Running.

Andere boeken door Regina Obe

Over Leo Hsu

Leo Hsu is a co-principal of Paragon Corporation, a database consulting company based in Boston. He has over 20 years of professional experience developing and thinking about databases for organizations large and small. Leo holds an MS degree in engineering of economic systems from Stanford University and BS degrees in mechanical engineering and economics from the Massachusetts Institute of Technology. He co-authored PostGIS in Action and PostgreSQL: Up and Running.

Andere boeken door Leo Hsu

Inhoudsopgave

Preface
Why This Book?
Who Should Read This Book?
How This Book Is Organized
How to Use This Book
Resources
Changes in the Fourth Edition
Conventions Used in This Book
O’Reilly Online Learning
How to Contact Us
Acknowledgments
Kevin E. Kline’s Acknowledgments
Regina Obe and Leo Hsu’s Acknowledgments

1. SQL History and Implementations
The Relational Model and ANSI SQL
Codd’s Rules for Relational Database Systems
Codd’s Rules in Action: Simple SELECT Examples
History of the SQL Standard
Levels of Conformance
Parts of the SQL Standard
SQL Statement Classes
SQL Dialects
NoSQL

2. Foundational Concepts
Database Platforms Described in This Book
Categories of Syntax
Identifiers
Literals
Operators
Keywords and Reserved Words
SQL and Platform-Specific Data Types
MySQL Data Types
Oracle Data Types
PostgreSQL Data Types
SQL Server Data Types
Constraints
Scope
Syntax
PRIMARY KEY Constraints
FOREIGN KEY Constraints
UNIQUE Constraints
CHECK Constraints

3. Structuring Your Data
How to Use This Chapter
SQL Platform Support
SQL Command Reference
CREATE/ALTER DATABASE Statement
CREATE DOMAIN Statement
CREATE/ALTER INDEX Statement
CREATE/ALTER SCHEMA Statement
CREATE/ALTER TABLE Statement
CREATE/ALTER TYPE Statement
CREATE/ALTER VIEW Statement
DROP Statements

4. Reading Your Data
How to Use This Chapter
SQL Platform Support
SQL Command Reference
ALL/ANY/SOME Operators
BETWEEN Operator
EXCEPT Set Operator
EXISTS Operator
FILTER Clause
GROUP BY Clause
IN Operator
INTERSECT Set Operator
IS Operator
JOIN Subclause
LIKE Operator
ORDER BY Clause
OVER Clause
SELECT Statement
SUBQUERY Substatement
UNION Set Operator
VALUES Clause
WHERE Clause
WITH Clause
WITH ORDINALITY Clause

5. Manipulating Your Data
How to Use This Chapter
SQL Platform Support
SQL Command Reference
COMMIT Statement
DELETE Statement
INSERT Statement
MERGE Statement
RELEASE SAVEPOINT Statement
RETURNING Clause
ROLLBACK Statement
SAVEPOINT Statement
SET TRANSACTION Statement
START TRANSACTION Statement
TRUNCATE TABLE Statement
UPDATE Statement

6. Securing Your Data
How to Use This Chapter
SQL Platform Support
SQL Command Reference
CONNECT Statement
CREATE ROLE Statement
GRANT Statement
REVOKE Statement
SET CONNECTION Statement
SET CONSTRAINTS Statement
SET PATH Statement
SET ROLE Statement
SET SCHEMA Statement
SET SESSION AUTHORIZATION Statement
SET TIME ZONE Statement

7. SQL Built-in Functions
How to Use This Chapter
Types of Functions
Deterministic and Nondeterministic Functions
Aggregate Functions
Window Functions
SQL Functions
Variable Functions
General-Purpose Functions
Numeric Functions
String Functions and Operators
Collection Functions
Platform-Specific Extensions
MySQL-Supported Functions
Oracle-Supported Functions
PostgreSQL-Supported Functions
SQL Server–Supported Functions

8. SQL Built-in Aggregate and Window Functions
How to Use This Chapter
SQL Aggregate Functions
SQL Aggregate Syntax
ARRAY_AGG
AVG and SUM
COLLECT
CORR
COUNT
COVAR_POP
COVAR_SAMP
CUME_DIST
DENSE_RANK
EVERY
LISTAGG
MIN and MAX
PERCENT_RANK
PERCENTILE_CONT
PERCENTILE_DISC
RANK
The REGR Family of Functions
STDDEV_POP
STDDEV_SAMP
VAR_POP
VAR_SAMP
Complementary Functions
GROUPING
MATCH_RECOGNIZE
SQL Window Functions
SQL Standard Window Syntax
MySQL Window Syntax
Oracle Window Syntax
PostgreSQL Window Syntax
SQL Server Window Syntax
Partitioning
Ordering
Grouping or Windowing
List of Window Functions
Platform-Specific Extensions
MySQL-Supported Functions
Oracle-Supported Functions
PostgreSQL-Supported Functions
SQL Server–Supported Functions

9. Storing Logic in the Database
How to Use This Chapter
SQL Platform Support
SQL Command Reference
CALL Statement
CLOSE Statement (Cursors)
CREATE/ALTER AGGREGATE Statement
CREATE CAST Statement
CREATE/ALTER FUNCTION/PROCEDURE Statement
CREATE/ALTER METHOD Statement
CREATE/ALTER/DROP TRIGGER Statement
DECLARE CURSOR Statement
FETCH Statement (Cursors)
OPEN Statement (Cursors)
RETURN Statement
Platform-Specific Extensions

10. Flexible and Schemaless
Why JSON?
Exporting Relational Data as JSON
JSON Support
JSON Data Types
SQL/JSON Path
SQL Standard JSON Functions
JSON Platform-Specific Extensions
Why XML?
XML Data Types
XPath
SQL XML Functions
XML Platform-Specific Extensions
A. Shared and Platform-Specific Keywords
SQL Standard Keywords
Keywords Shared Across Multiple Platforms

Index
About the Authors

Managementboek Top 100

Rubrieken

Populaire producten

    Personen

      Trefwoorden

        SQL - In a Nutshell