SQL Pocket Guide
A Guide to SQL Usage. Oracle, DB2, SQL Server, MySQL & PostgreSQL
(Sprache: Englisch)
SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business...
Leider schon ausverkauft
versandkostenfrei
Buch
12.00 €
Produktdetails
Produktinformationen zu „SQL Pocket Guide “
SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two.
Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including:
* Oracle Database 10g, Release 2 (including
the free Oracle Database 10g Express Edition (XE))
* Microsoft SQL Server 2005
* MySQL 5
* IBM DB2 8.2
* PostreSQL 8.1 database
Klappentext zu „SQL Pocket Guide “
SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two.Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variantsincluding: Oracle Database 10g, Release 2 (includingthe free Oracle Database 10g Express Edition (XE)) MicrosoftSQL Server 2005 MySQL 5 IBM DB2 8.2 PostreSQL 8.1 database
This pocket guide presents the most crucial information about SQL in a compact and easily accessible format, covering the four commonly used SQL variants Oracle, IBM DB2, Microsoft SQL Server, and MySQL. Topics include:
- Data manipulation statements (SELECT, DELETE, INSERT, UPDATE, MERGE) and transaction control statements (START TRANSACTION, SAVEPOINT, COMMIT, ROLLBACK).
- Common SQL functions (date, numeric, math, trigonometric, string, conversion, aggregate)
- Such topics as literals, NULLs, CASE expressions, datatype conversion, regular expressions, grouping and summarizing data, joining tables, and writing queries (hierarchical, recursive, union, flashback) and subqueries.
- Instead of presenting complex and confusing syntax diagrams, the book teaches by example, showing the SQL statements and options that readers are most like to use. All example data is available on the O'Reilly web site.
"If you need fast, accurate SQL information, with examples for multiple database engines, be sure to check out this book." -Chris Kempster, Senior DBA and author of SQL Server 2000 for the Oracle DBA, www.chriskempster.com
- Data manipulation statements (SELECT, DELETE, INSERT, UPDATE, MERGE) and transaction control statements (START TRANSACTION, SAVEPOINT, COMMIT, ROLLBACK).
- Common SQL functions (date, numeric, math, trigonometric, string, conversion, aggregate)
- Such topics as literals, NULLs, CASE expressions, datatype conversion, regular expressions, grouping and summarizing data, joining tables, and writing queries (hierarchical, recursive, union, flashback) and subqueries.
- Instead of presenting complex and confusing syntax diagrams, the book teaches by example, showing the SQL statements and options that readers are most like to use. All example data is available on the O'Reilly web site.
"If you need fast, accurate SQL information, with examples for multiple database engines, be sure to check out this book." -Chris Kempster, Senior DBA and author of SQL Server 2000 for the Oracle DBA, www.chriskempster.com
Autoren-Porträt von Jonathan Gennick
Jonathan Gennick war er mehr als zehn Jahre als Programmierer von relationalen Datenbanken tätig. Mit Oracle arbeitet er seit 1994.
Bibliographische Angaben
- Autor: Jonathan Gennick
- 2006, 2nd ed., 184 Seiten, Maße: 10,9 x 17,8 cm, Kartoniert (TB), Englisch
- Verlag: O'Reilly Associates
- ISBN-10: 0596526881
- ISBN-13: 9780596526887
Sprache:
Englisch
Rezension zu „SQL Pocket Guide “
"Das Vokabelheft deckt Oracle, DB2, den SQL Server und MySQL ab und eignet sich vor allem fürs Nachschlagen im Urlaub :-)." - iX, Ausgabe 2/2006
Kommentar zu "SQL Pocket Guide"
0 Gebrauchte Artikel zu „SQL Pocket Guide“
Zustand | Preis | Porto | Zahlung | Verkäufer | Rating |
---|
Schreiben Sie einen Kommentar zu "SQL Pocket Guide".
Kommentar verfassen