SQL - kurz & gut: Behandelt Oracle, DB2, SQL Server, MySQL & PostgreSQL (O'Reillys Taschenbibliothek)

Gennick, Jonathan:

ISBN 10: 3897215225 / ISBN 13: 9783897215221

Editore: O'Reilly 11.2006., 2006

Riguardo questo articolo

208 Seiten In durchsichtige Folie eingeschlagen. Mit altersbedingten Lager- und Gebrauchsspuren. E-K73 Sprache: Deutsch Gewicht in Gramm: 198.

Codice articolo 159146

Dati bibliografici

• Titolo: SQL - kurz & gut: Behandelt Oracle, DB2, SQL Server, MySQL & PostgreSQL (O'Reillys Taschenbibliothek)
• Editore: O'Reilly 11.2006.
• Data di pubblicazione: 2006
• Lingua: Tedesco
• ISBN 10: 3897215225
• ISBN 13: 9783897215221
• Rilegatura: paperback
• Edizione: Auflage: 2.
• Condizione: Sehr gut
• Peso: 198 grammi
• Cataloghi dei venditori:
  • Informatik

Descrizione articolo

Riassunto

Der Bestseller in stark erweiterter und aktualisierter Neuauflage: Gewohnt knapp und präzise deckt SQL – kurz & gut die wichtigsten Funktionen und Themen zur effektiven Arbeit mit SQL ab. Dabei behandelt die Taschenreferenz neben Oracle Database 10g Release 2, IBM DB2 8.2, Microsoft SQL Server 2005 und MySQL 5.0 nun auch PostgreSQL 8.1. Aus dem Inhalt: * Anweisungen zur Datenmanipulation (SELECT, DELETE, INSERT, UPDATE, MERGE) und zur Transaktionsverwaltung (START TRANSAKTION, SAVEPOINT, COMMIT, ROLLBACK) * Gebräuchliche SQL-Funktionen (Datums-, String-, Umwandlungs-, Aggregat- und Window-Funktionen sowie numerische, mathematische und trigonometrische Funktionen) * Literale, NULL-Werte, CASE-Ausdrücke, Datentyp-Umwandlungen, reguläre Ausdrücke, Gruppieren und Zusammenfassen von Daten, Tabellen-Joins und das Schreiben von Abfragen und Unterabfragen Anhand konkreter Beispiele werden diejenigen SQL-Anweisungen und -Optionen vorgestellt, die Sie im Arbeitsalltag am häufigsten benötigen – kompakt, übersichtlich und auf den Punkt gebracht.

L'autore

Jonathan Gennick is an O'Reilly & Associates editor specializing in database and programming titles. Prior to joining O'Reilly, Jonathan amassed some 17 years of programming and database management experience. During the latter part of his career he specialized in relational database programming, and more recently in database management. Jonathan got his start with relational database systems in 1990, first working with Ingres, and later with Digital's Rdb software. During that period he developed a fondness for SQL, and for the challenge of applying SQL creatively in ways that leveraged it's set-oriented capabilities. In 1994 Jonathan made the leap to Oracle, and is now often found writing about it. Recent projects include Oracle SQLLoader (O'Reilly & Associates, 2001); Oracle SQLPlus Pocket Reference (O'Reilly & Associates, 2000); Oracle SQL*Plus: The Definitive Guide (O'Reilly & Associates, 1999); More recently, Jonathan has made forays into other database products, coauthoring Transact-SQL Cookbook (O'Reilly & Associates, 2002) and editing Practical PostgreSQL (O'Reilly & Associates, 2002). Jonathan is certified as an Oracle DBA and is a member of MENSA and the Oracle Technology Network. He holds a Bachelor of Arts degree in Information and Computer Science, with a Business Administration minor, from Andrews University in Berrien Springs, Michigan. Jonathan currently resides in Munising, Michigan with his wife Donna and their two children: Jenny and Jeff. Jonathan may be contacted by email at jonathan@gennick.com, and you can learn more about him personally by visiting his website at http://gennick.com.