SQL in a Nutshell. 4th Edition
- Autorzy:
- Kevin Kline, Regina O. Obe, Leo S. Hsu
- Ocena:
- Bądź pierwszym, który oceni tę książkę
- Stron:
- 840
- Dostępne formaty:
-
ePubMobi
Opis ebooka: SQL in a Nutshell. 4th Edition
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
Wybrane bestsellery
-
SQL in a Nutshell applies the eminently useful "Nutshell" format to Structured Query Language (SQL), the elegant--but complex--descriptive language that is used to create and manipulate large stores of data. For SQL programmers, analysts, and database administrators, the new second edition of SQL...(112.80 zł najniższa cena z 30 dni)
112.60 zł
149.00 zł(-24%) -
Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.5 to 10, you’ll also discover that PostgeSQL is more than a database system—...(103.65 zł najniższa cena z 30 dni)
103.45 zł
139.00 zł(-26%) -
W świecie przepełnionym informacjami doskonała baza danych, która pozwala na ich zbieranie, organizowanie i zarządzanie nimi, to podstawa sprawnego funkcjonowania każdego przedsiębiorstwa. W tej branży od lat prym wiedzie relacyjna baza danych Oracle. Jednak aby efektywnie korzystać z jej dobrodz...(39.59 zł najniższa cena z 30 dni)
69.30 zł
99.00 zł(-30%) -
Jeśli myślisz o karierze analityka danych albo starasz się o pracę na stanowisku, na którym będziesz analizować dane, ten kurs jest specjalnie dla Ciebie. Opanujesz dzięki niemu między innymi niezbędne podstawy języka SQL i dowiesz się, jak funkcjonuje i do czego może Ci posłużyć system zarządzan...(99.59 zł najniższa cena z 30 dni)
174.30 zł
249.00 zł(-30%) -
Ludzkość od zarania dziejów miała potrzebę zapisywania i porządkowania danych – pierwsze tabliczki gliniane z zapisanymi informacjami handlowymi pochodzą z 3500 roku p.n.e. Na przestrzeni wieków pojawiło się wiele technik gromadzenia danych, jednak dopiero wraz z rozwojem technologii komput...(41.65 zł najniższa cena z 30 dni)
71.40 zł
119.00 zł(-40%) -
Firmy z branży IT prześcigają się w tworzeniu rozwiązań zwiększających wydajność pracy, jak również podnoszących poziom specjalizacji pracowników w określonych dziedzinach. Od kilku już lat pozycja full stack developera, który wykonywał wszystkie prace programistyczne, jest wielką rzadkością. Obe...(63.60 zł najniższa cena z 30 dni)
55.65 zł
159.00 zł(-65%) -
With the shift from data warehouses to data lakes, data now lands in repositories before it's been transformed, enabling engineers to model raw data into clean, well-defined datasets. dbt (data build tool) helps you take data further. This practical book shows data analysts, data engineers, BI de...(188.08 zł najniższa cena z 30 dni)
188.03 zł
239.00 zł(-21%) -
If you were handed two different but related sets of data, what tools would you use to find the matches? What if all you had was SQL SELECT access to a database? In this practical book, author Jim Lehmer provides best practices, techniques, and tricks to help you import, clean, match, score, and ...(160.99 zł najniższa cena z 30 dni)
160.49 zł
209.00 zł(-23%) -
To help you on the path to becoming a Snowflake pro, this concise yet comprehensive guide reviews fundamentals and best practices for Snowflake's SQL and Scripting languages. Developers and data professionals will learn how to generate, modify, and query data in the Snowflake relational database ...(231.09 zł najniższa cena z 30 dni)
230.88 zł
279.00 zł(-17%)
Ebooka "SQL in a Nutshell. 4th Edition" przeczytasz na:
-
czytnikach Inkbook, Kindle, Pocketbook, Onyx Boox i innych
-
systemach Windows, MacOS i innych
-
systemach Windows, Android, iOS, HarmonyOS
-
na dowolnych urządzeniach i aplikacjach obsługujących formaty: PDF, EPub, Mobi
Masz pytania? Zajrzyj do zakładki Pomoc »
Audiobooka "SQL in a Nutshell. 4th Edition" posłuchasz:
-
w aplikacji Ebookpoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych
-
na dowolnych urządzeniach i aplikacjach obsługujących format MP3 (pliki spakowane w ZIP)
Masz pytania? Zajrzyj do zakładki Pomoc »
Kurs Video "SQL in a Nutshell. 4th Edition" zobaczysz:
-
w aplikacjach Ebookpoint i Videopoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych z dostępem do najnowszej wersji Twojej przeglądarki internetowej
Szczegóły ebooka
- ISBN Ebooka:
- 978-14-920-8881-3, 9781492088813
- Data wydania ebooka:
- 2022-06-14 Data wydania ebooka często jest dniem wprowadzenia tytułu do sprzedaży i może nie być równoznaczna z datą wydania książki papierowej. Dodatkowe informacje możesz znaleźć w darmowym fragmencie. Jeśli masz wątpliwości skontaktuj się z nami sklep@ebookpoint.pl.
- Język publikacji:
- angielski
- Rozmiar pliku ePub:
- 3.0MB
- Rozmiar pliku Mobi:
- 8.4MB
Spis treści ebooka
- 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
- OReilly Online Learning
- How to Contact Us
- Acknowledgments
- Kevin E. Klines Acknowledgments
- Regina Obe and Leo Hsus Acknowledgments
- 1. SQL History and Implementations
- The Relational Model and ANSI SQL
- Codds Rules for Relational Database Systems
- Data structures (rules 1, 2, 8, and 9)
- NULLs (rule 3)
- Metadata (rules 4 and 10)
- The Language (Rules 5 and 11)
- Views (rule 6)
- Set operations (rules 7 and 12)
- Codds Rules for Relational Database Systems
- Codds Rules in Action: Simple SELECT Examples
- The Relational Model and ANSI SQL
- 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
- Naming conventions
- Identifier rules
- Identifiers
- Literals
- Operators
- Arithmetic operators
- Assignment operators
- Bitwise operators
- Comparison operators
- Logical operators
- Set operators
- Unary operators
- Operator precedence
- System delimiters and 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
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- See also
- CREATE/ALTER DATABASE Statement
- CREATE DOMAIN Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- PostgreSQL
- See also
- CREATE/ALTER INDEX Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL and MariaDB
- Oracle
- PostgreSQL
- Operator classes
- SQL Server
- Columnstore indexes
- XML indexes
- Spatial indexes
- See also
- CREATE/ALTER SCHEMA Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- CREATE/ALTER TABLE Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL and MariaDB
- Partitioned tables
- Oracle
- The Oracle physical_attributes_clause
- The Oracle storage_clause and LOBs
- Oracle nested tables
- Oracle compressed tables
- Oracle partitioned and subpartitioned tables
- Altering partitioned and subpartitioned tables
- Organized tables: Heaps, IOTs, and external tables
- Oracle XMLType and object-type tables
- Oracle ALTER TABLE
- PostgreSQL
- PostgreSQL tables as types
- PostgreSQL typed tables
- PostgreSQL partitioned tables
- PostgreSQL foreign tables
- SQL Server
- See also
- CREATE/ALTER TYPE Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- CREATE/ALTER VIEW Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- DROP Statements
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL / MariaDB
- Oracle
- PostgreSQL
- SQL Server
- See also
- 4. Reading Your Data
- How to Use This Chapter
- SQL Platform Support
- SQL Command Reference
- ALL/ANY/SOME Operators
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- ALL/ANY/SOME Operators
- BETWEEN Operator
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- See also
- EXCEPT Set Operator
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- See also
- EXISTS Operator
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- See also
- FILTER Clause
- SQL standard syntax
- Keywords
- Rules at a glance
- See also
- GROUP BY Clause
- SQL standard syntax
- Keywords
- Rules at a glance
- The GROUP BY clause
- The HAVING clause
- IN Operator
- SQL standard syntax
- Keywords
- Rules at a glance
- See also
- INTERSECT Set Operator
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- See also
- IS Operator
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- See also
- JOIN Subclause
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- LIKE Operator
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- ORDER BY Clause
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- OVER Clause
- SQL standard syntax
- Keywords
- Rules at a glance
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- SELECT Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Aliases and WHERE clause joins
- The JOIN clause
- The WHERE clause
- The ORDER BY clause
- Programming tips and gotchas
- MySQL
- Oracle
- Partitioned outer joins
- Flashback queries
- The MODEL clause
- PostgreSQL
- SQL Server
- See also
- SUBQUERY Substatement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- Examples
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- UNION Set Operator
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- VALUES Clause
- SQL standard syntax
- Keywords
- Rules at a glance
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- See also
- WHERE Clause
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- See also
- WITH Clause
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- See also
- WITH ORDINALITY Clause
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- See also
- 5. Manipulating Your Data
- How to Use This Chapter
- SQL Platform Support
- SQL Command Reference
- COMMIT Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- COMMIT Statement
- DELETE Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- See also
- INSERT Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- See also
- MERGE Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- RELEASE SAVEPOINT Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- RETURNING Clause
- SQL standard syntax
- Keywords
- Rules at a glance
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- See also
- ROLLBACK Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- SAVEPOINT Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- SET TRANSACTION Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- START TRANSACTION Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- TRUNCATE TABLE Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- See also
- UPDATE Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- See also
- 6. Securing Your Data
- How to Use This Chapter
- SQL Platform Support
- SQL Command Reference
- CONNECT Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- CONNECT Statement
- CREATE ROLE Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- GRANT Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- See also
- REVOKE Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- SET CONNECTION Statement
- SQL standard syntax
- Keywords
- Description
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- SET CONSTRAINTS Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- SET PATH Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- See also
- SET ROLE Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- SET SCHEMA Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- SET SESSION AUTHORIZATION Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- SET TIME ZONE Statement
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- 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
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- Variable Functions
- General-Purpose Functions
- CASE
- SQL standard syntax
- Examples
- CASE
- CAST
- SQL standard syntax
- PostgreSQL
- SQL Server
- Examples
- COALESCE
- SQL standard syntax
- Examples
- NULLIF
- SQL standard syntax
- Examples
- Numeric Functions
- ABS
- SQL standard syntax
- Examples
- ABS
- BIT_LENGTH, CHAR_LENGTH, and OCTET_LENGTH
- SQL standard syntax
- MySQL
- PostgreSQL
- Oracle
- SQL Server
- Examples
- CARDINALITY
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- CEIL, CEILING
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- EXP
- SQL standard syntax
- Example
- EXTRACT
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- FLOOR
- SQL standard syntax
- Examples
- LN, LOG, and LOG10
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- MOD
- SQL standard syntax
- Example
- POSITION
- SQL standard syntax
- MariaDB and MySQL and MariaDB
- PostgreSQL
- Oracle
- SQL Server
- Examples
- POSITION_REGEX
- SQL standard syntax
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- Examples
- POWER
- SQL standard syntax
- Examples
- SQRT
- SQL standard syntax
- Example
- WIDTH_BUCKET
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- Trigonometric functions
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- String Functions and Operators
- Concatenation operator
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- Concatenation operator
- CONVERT and TRANSLATE
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- LOWER and UPPER
- SQL standard syntax
- MySQL
- Example
- OVERLAY
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- SUBSTRING
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- TRIM
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- Collection Functions
- TABLE
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- TABLE
- UNNEST
- SQL standard syntax
- MySQL
- PostgreSQL
- Oracle
- SQL Server
- Examples
- Platform-Specific Extensions
- MySQL-Supported Functions
- Oracle-Supported Functions
- PostgreSQL-Supported Functions
- SQL ServerSupported Functions
- 8. SQL Built-in Aggregate and Window Functions
- How to Use This Chapter
- SQL Aggregate Functions
- SQL Aggregate Syntax
- MySQL aggregate syntax
- Oracle aggregate syntax
- PostgreSQL aggregate syntax
- SQL Server aggregate syntax
- Examples
- See also
- SQL Aggregate Syntax
- ARRAY_AGG
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- See also
- AVG and SUM
- SQL standard syntax
- Examples
- COLLECT
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- See also
- CORR
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- COUNT
- SQL standard syntax
- Examples
- COVAR_POP
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- COVAR_SAMP
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- CUME_DIST
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- DENSE_RANK
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- EVERY
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- LISTAGG
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- MIN and MAX
- SQL standard syntax
- Examples
- PERCENT_RANK
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- PERCENTILE_CONT
- SQL standard syntax
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- Examples
- PERCENTILE_DISC
- SQL standard syntax
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- Examples
- RANK
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- The REGR Family of Functions
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- STDDEV_POP
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- STDDEV_SAMP
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- VAR_POP
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- VAR_SAMP
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- Complementary Functions
- GROUPING
- SQL standard syntax
- Examples
- GROUPING
- MATCH_RECOGNIZE
- SQL standard syntax
- Example
- 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
- CUME_DIST
- SQL standard syntax
- Example
- CUME_DIST
- DENSE_RANK
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- FIRST_VALUE and LAST_VALUE
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- LAG and LEAD
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- NTILE
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- NTH_VALUE
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- PERCENT_RANK
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- RANK
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- ROW_NUMBER
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- Platform-Specific Extensions
- MySQL-Supported Functions
- Oracle-Supported Functions
- PostgreSQL-Supported Functions
- SQL ServerSupported Functions
- 9. Storing Logic in the Database
- How to Use This Chapter
- SQL Platform Support
- SQL Command Reference
- CALL Statement
- SQL syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- CALL Statement
- CLOSE Statement (Cursors)
- SQL syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- CREATE/ALTER AGGREGATE Statement
- Rules at a glance
- Programming tips and gotchas
- MySQL/MariaDB
- Oracle
- PostgreSQL
- SQL Server
- See also
- CREATE CAST Statement
- SQL syntax
- Keywords
- Rules at a glance
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- CREATE/ALTER FUNCTION/PROCEDURE Statement
- SQL syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- See also
- CREATE/ALTER METHOD Statement
- SQL syntax
- Keywords
- See also
- CREATE/ALTER/DROP TRIGGER Statement
- SQL syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- DML triggers
- DDL triggers
- Oracle
- DML triggers
- DDL triggers
- PostgreSQL
- DML triggers
- DDL triggers
- SQL Server
- DML triggers
- DDL triggers
- See also
- DECLARE CURSOR Statement
- SQL syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- See also
- FETCH Statement (Cursors)
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- OPEN Statement (Cursors)
- SQL standard syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- RETURN Statement
- SQL syntax
- Keywords
- Rules at a glance
- Programming tips and gotchas
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- See also
- Platform-Specific Extensions
- MySQL and MariaDB
- SQL_MODE
- MariaDB packages
- MySQL and MariaDB
- Oracle
- SQL macros
- Packages
- Pipelined table functions
- PostgreSQL
- Dollar quoting
- Inline functions
- Extensions
- DO
- SQL Server
- Inline functions
- Assemblies
- See also
- 10. Flexible and Schemaless
- Why JSON?
- Exporting Relational Data as JSON
- Why JSON?
- JSON Support
- JSON Data Types
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- JSON Data Types
- SQL/JSON Path
- SQL/JSON Path key elements
- SQL/JSON Path literals
- SQL/JSON Path functions
- SQL/JSON Path modes
- See also
- SQL Standard JSON Functions
- JSON_ARRAY
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- JSON_ARRAY
- JSON_ARRAYAGG
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- JSON_EXISTS
- SQL standard syntax
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- Examples
- JSON_OBJECT
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- JSON_OBJECTAGG
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- JSON_QUERY
- SQL standard syntax
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- Examples
- JSON_TABLE
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- JSON_VALUE
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- JSON Platform-Specific Extensions
- MySQL JSON functions
- Oracle JSON functions
- PostgreSQL JSON functions and operators
- Operators
- Functions
- SQL Server JSON functions and keywords
- Keywords
- Functions
- Why XML?
- XML Data Types
- MySQL and MariaDB
- Oracle
- PostgreSQL
- SQL Server
- Examples
- XML Data Types
- XPath
- SQL XML Functions
- XMLAGG
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- XMLAGG
- XMLEXISTS
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- XMLFOREST
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Example
- XMLTABLE
- SQL standard syntax
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Examples
- XML Platform-Specific Extensions
- MySQL XML functions
- Oracle XML functions
- PostgreSQL XML functions
- SQL Server XML keywords, functions, procedures, and methods
- Keywords
- Functions and procedures
- XML methods
- A. Shared and Platform-Specific Keywords
- SQL Standard Keywords
- A
- B
- C
- D
- E
- F
- GH
- I
- J
- KL
- M
- N
- O
- PQ
- R
- S
- T
- U
- VZ
- SQL Standard Keywords
- Keywords Shared Across Multiple Platforms
- Index
O'Reilly Media - inne książki
-
This concise yet comprehensive guide explains how to adopt a data lakehouse architecture to implement modern data platforms. It reviews the design considerations, challenges, and best practices for implementing a lakehouse and provides key insights into the ways that using a lakehouse can impact ...(193.69 zł najniższa cena z 30 dni)
193.19 zł
249.00 zł(-22%) -
In today's fast-paced world, more and more organizations require rapid application development with reduced development costs and increased productivity. This practical guide shows application developers how to use PowerApps, Microsoft's no-code/low-code application framework that helps developer...(162.47 zł najniższa cena z 30 dni)
162.27 zł
209.00 zł(-22%) -
Welcome to the systems age, where software professionals are no longer building software&emdash;we're building systems of software. Change is continuously deployed across software ecosystems coordinated by responsive infrastructure. In this world of increasing relational complexity, we need t...(152.21 zł najniższa cena z 30 dni)
152.01 zł
209.00 zł(-27%) -
This book provides an ideal guide for Python developers who want to learn how to build applications with large language models. Authors Olivier Caelen and Marie-Alice Blete cover the main features and benefits of GPT-4 and GPT-3.5 models and explain how they work. You'll also get a step-by-step g...(155.41 zł najniższa cena z 30 dni)
155.36 zł
209.00 zł(-26%) -
In today's cloud native world, where we automate as much as possible, everything is code. With this practical guide, you'll learn how Policy as Code (PaC) provides the means to manage the policies, related data, and responses to events that occur within the systems we maintain—Kubernetes, c...(212.59 zł najniższa cena z 30 dni)
212.39 zł
279.00 zł(-24%) -
Geared to intermediate- to advanced-level DBAs and IT professionals looking to enhance their MySQL skills, this guide provides a comprehensive overview on how to manage and optimize MySQL databases. You'll learn how to create databases and implement backup and recovery, security configurations, h...(221.43 zł najniższa cena z 30 dni)
221.33 zł
279.00 zł(-21%) -
Get the details, examples, and best practices you need to build generative AI applications, services, and solutions using the power of Azure OpenAI Service. With this comprehensive guide, Microsoft AI specialist Adrián González Sánchez examines the integration and utilization of Az...(162.23 zł najniższa cena z 30 dni)
162.18 zł
209.00 zł(-22%) -
Despite the increase of high-profile hacks, record-breaking data leaks, and ransomware attacks, many organizations don't have the budget for an information security (InfoSec) program. If you're forced to protect yourself by improvising on the job, this pragmatic guide provides a security-101 hand...(214.77 zł najniższa cena z 30 dni)
214.57 zł
239.00 zł(-10%) -
Keeping up with the Python ecosystem can be daunting. Its developer tooling doesn't provide the out-of-the-box experience native to languages like Rust and Go. When it comes to long-term project maintenance or collaborating with others, every Python project faces the same problem: how to build re...(189.29 zł najniższa cena z 30 dni)
188.79 zł
239.00 zł(-21%) -
Bringing a deep-learning project into production at scale is quite challenging. To successfully scale your project, a foundational understanding of full stack deep learning, including the knowledge that lies at the intersection of hardware, software, data, and algorithms, is required.This book il...(227.19 zł najniższa cena z 30 dni)
227.14 zł
279.00 zł(-19%)
Dzieki opcji "Druk na żądanie" do sprzedaży wracają tytuły Grupy Helion, które cieszyły sie dużym zainteresowaniem, a których nakład został wyprzedany.
Dla naszych Czytelników wydrukowaliśmy dodatkową pulę egzemplarzy w technice druku cyfrowego.
Co powinieneś wiedzieć o usłudze "Druk na żądanie":
- usługa obejmuje tylko widoczną poniżej listę tytułów, którą na bieżąco aktualizujemy;
- cena książki może być wyższa od początkowej ceny detalicznej, co jest spowodowane kosztami druku cyfrowego (wyższymi niż koszty tradycyjnego druku offsetowego). Obowiązująca cena jest zawsze podawana na stronie WWW książki;
- zawartość książki wraz z dodatkami (płyta CD, DVD) odpowiada jej pierwotnemu wydaniu i jest w pełni komplementarna;
- usługa nie obejmuje książek w kolorze.
Masz pytanie o konkretny tytuł? Napisz do nas: sklep[at]helion.pl.
Książka, którą chcesz zamówić pochodzi z końcówki nakładu. Oznacza to, że mogą się pojawić drobne defekty (otarcia, rysy, zagięcia).
Co powinieneś wiedzieć o usłudze "Końcówka nakładu":
- usługa obejmuje tylko książki oznaczone tagiem "Końcówka nakładu";
- wady o których mowa powyżej nie podlegają reklamacji;
Masz pytanie o konkretny tytuł? Napisz do nas: sklep[at]helion.pl.
Książka drukowana
Oceny i opinie klientów: SQL in a Nutshell. 4th Edition Kevin Kline, Regina O. Obe, Leo S. Hsu (0) Weryfikacja opinii następuję na podstawie historii zamówień na koncie Użytkownika umieszczającego opinię. Użytkownik mógł otrzymać punkty za opublikowanie opinii uprawniające do uzyskania rabatu w ramach Programu Punktowego.