SQL Pocket Guide. 3rd Edition - Jonathan Gennick
- Dodał: administrator
- Data: 21:16 23-11-2018
- Kategoria: Informatyka i matematyka
If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2.SQL Pocket Guide describes how these database systems implement SQL syntax for querying, managing transactions, and making changes to data. It also shows how the systems use SQL functions, regular expression syntax, and type conversion functions and formats.All example SQL statements in this book execute against a set of tables, with data that you can quickly download. The third edition covers important database changes, including:Oracle's support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operatorsFunctions new to Oracle, such as LISTAGG, NTH_VALUE, and morePostgreSQL...s support of recursive WITH and some window functionsDB2 syntax and datatypes, some compatible with OracleMySQL features such as the TIMESTAMP type and the TO_SECONDS function źródło opisu: Helion źródło okładki: Helion
| ISBN | 9781449396664 | ||
| język | polski | ||
| data wydania | 10 listopada 2010 | ||
| kategoria | informatyka i matematyka |
Rejestracja jest za darmo i jest bardzo szybka! Kliknij tutaj aby założyć konto. Trwa to tylko 15 sekund!.
Podobne wpisy do SQL Pocket Guide. 3rd Edition - Jonathan Gennick
The Fairy-Faith in Celtic Countries - Walter Yeeling Evans-Wentz
Pixies, elves, brownies, dwarfs, leprechauns, and the other enchanted little people: where do they come from? Folklorists consider them the byproduct of ancient religious beliefs, occultists term them nature spirits, and the peasantry call them falle...
GuRu - RuPaul
We All Need a Guru to Guide Our Way . . . Who Better than RuPaul to Be Your Personal GuRu? From the moment he applied his first false eyelashes, RuPaul has been making a statement—with his bold approach to drag, his fearlessness in music, film, and t...
Races of Eberron
Dauntless adventurers arise from amongst the spirited races of the warforged, shifters, changelings, and kalashtar. These bold explorers hurl themselves into the most dangerous quests with an unquenchable thirst for fortune and glory. This supplement...
C# 2008 Programmer’s Reference (Wrox Programmer to Programmer) - Lee Wei-Meng
Have access to all aspects of the C# programming language at hand with the C# 2008 Programmer’s Reference, the only comprehensive reference guide for C# programmers. Regardless of your experience with C#, you will appreciate the detailed code samples...
Information technology project management - Witold Chmielarz
The structure of the book consists of the three main parts: -the first part concerns the directions for the development of IT systems, management under dynamically changing theoretical and practical conditions, which break some of the patterns of tho...
Turkey and Europe. Challenges and Opportunities - Adam Szymański
The enlargement of the European Union is among the major processes of European integration, and the Republic of Turkey is at the root of the most heated controversies among all candidate countries—one reason being that its candidacy brings into focus...