By Jonathan Gennick
If you are a programmer or database administrator who makes use of SQL on your day by day paintings, this well known pocket advisor is the suitable on-the-job reference. you will find many examples that tackle the language's complexity, besides key features of SQL utilized in IBM DB2 unlock 9.7, MySQL 5.1, Oracle Database 11g unlock 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 unencumber 2.
SQL Pocket Guide describes how those database platforms enforce SQL syntax for querying, dealing with transactions, and making alterations to information. It additionally indicates how the platforms use SQL services, ordinary expression syntax, and sort conversion services and formats.
All instance SQL statements during this e-book execute opposed to a suite of tables, with info that you should quick obtain. The 3rd version covers vital database alterations, including:
- Oracle's help of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators
- Functions new to Oracle, corresponding to LISTAGG, NTH_VALUE, and more
- PostgreSQL’s help of recursive WITH and a few window functions
- DB2 syntax and datatypes, a few suitable with Oracle
- MySQL positive aspects similar to the TIMESTAMP sort and the TO_SECONDS function
Read or Download SQL Pocket Guide PDF
Similar Sql books
Delivering info for database directors and alertness builders, this e-book is a step by step consultant to studying software improvement and method administration with SQL, writing effective SQL code, and fine-tuning server functionality. The CD-ROM comprises an review replica of SQL Server 7.
Write strong SQL statements and PL/SQL programsLearn to entry Oracle databases via SQL statements and build PL/SQL courses with tips from Oracle professional, Jason cost. released via Oracle Press, Oracle Database 11g SQL explains how one can retrieve and adjust database info, use SQL Plus and SQL Developer, paintings with database gadgets, write PL/SQL courses, and masses extra.
The former variation of this ebook proven itself because the so much whole and comprehensible therapy of the SQL commonplace usually to be had. Many alterations have happened within the SQL criteria global due to the fact that version used to be released, despite the fact that: a tremendous new part, the Call-Level Interface (SQL/CLI), was once extra in 1995.
The necessity to deal with more and more higher information volumes is one issue riding the adoption of a brand new category of nonrelational “NoSQL” databases. Advocates of NoSQL databases declare they are often used to construct structures which are extra performant, scale greater, and are more straightforward to software. NoSQL Distilled is a concise yet thorough advent to this speedily rising know-how.
Extra info for SQL Pocket Guide