Jurusan Manajemen E-books

Databases

Download E-books SQL kurz und gut PDF

By Jonathan Gennick

Der Bestseller in stark erweiterter und aktualisierter Neuauflage: Gewohnt knapp und präzise deckt SQL – kurz & intestine die wichtigsten Funktionen und Themen zur effektiven Arbeit mit SQL ab. Dabei behandelt die Taschenreferenz neben Oracle Database 10g unlock 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, replace, MERGE) und zur Transaktionsverwaltung (START TRANSAKTION, SAVEPOINT, dedicate, 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.

Show description

Read or Download SQL kurz und gut PDF

Best Databases books

Microsoft Office Access 2007: The Complete Reference (Complete Reference Series)

The last word Microsoft place of work entry 2007 ResourceBuild a hugely responsive a database so that you can tune, document, and percentage details and make extra expert judgements. This entire source indicates you the way to layout and advance customized entry 2007 databases--even when you've got very little programming adventure.

DB2 Developer's Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS (6th Edition) (IBM Press)

DB2 Developer's consultant is the field's no 1 go-to resource for on-the-job details on programming and administering DB2 on IBM z/OS mainframes. Now, three-time IBM details Champion Craig S. Mullins has completely up to date this vintage for DB2 v9 and v10. Mullins totally covers new DB2 ideas together with temporal database aid; hashing; common tablespaces; pureXML; functionality, safeguard and governance advancements; new facts forms, and lots more and plenty extra.

Oracle Programming: A Primer, Version 7.0

This concise creation to Oracle SQL is perfect for college kids in a database direction that calls for programming SQL or execs drawn to getting up and working on utilizing the main popular database administration platforms. This booklet covers the fundamentals of Oracle and contains more recent subject matters linked to internet server programming.

Abstraction and Specification in Program Development (MIT Electrical Engineering and Computer Science)

Abstraction and Specification in software improvement deals pros in application layout and software program engineering a technique that would permit them to build courses which are trustworthy and fairly effortless to appreciate, alter, and retain. strong programming comprises the systematic mastery of complexity, and this ebook presents the 1st unified therapy of the options of abstraction and specification, which, the authors argue, are the linchpin of any powerful method of programming.

Additional resources for SQL kurz und gut

Show sample text content

Rated 4.95 of 5 – based on 38 votes