SQL pocket guide / Jonathan Gennick.

Format:

Book

Author/Creator:

Gennick, Jonathan.

Contributor:

Gennick, Jonathan.

Language:

English

Subjects (All):

Database management.

Relational databases.

SQL (Computer program language).

Physical Description:

1 online resource (192 p.)

Edition:

2nd ed.

Place of Publication:

Sebastopol, Califiornia : O'Reilly, 2006.

Language Note:

English

System Details:

text file

Summary:

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 administrator

Contents:

SQL Pocket Guide, 2nd Edition; 1. SQL Pocket Guide; 1.1.2. Feedback Needed!; 1.1.3. Conventions; 1.1.4. Acknowledgments; 1.1.5. Example Data; 1.2. Analytic Functions; 1.3. CASE Expressions; 1.3.2. Searched CASE Expressions; 1.4. Datatypes; 1.4.2. Decimal Types; 1.4.3. Binary Integer Types; 1.4.4. Datetime Types; 1.4.4.2. DB2; 1.4.4.3. SQL Server; 1.4.4.4. MySQL; 1.4.4.5. PostgreSQL; 1.5. Dataype Conversion; 1.5.2. Standard EXTRACT Function; 1.5.3. Datetime Conversions (Oracle); 1.5.4. Numeric Conversions (Oracle); 1.5.5. Datetime Conversions (DB2); 1.5.6. Numeric Conversions (DB2)

1.5.7. Datetime Conversions (SQL Server)1.5.7.2. CONVERT (SQL Server); 1.5.7.3. DATENAME and DATEPART (SQL Server); 1.5.7.4. DAY, MONTH, and YEAR (SQL Server); 1.5.8. Numeric Conversions (SQL Server); 1.5.9. Datetime Conversions (MySQL); 1.5.9.2. TO_DAYS and FROM_DAYS (MySQL); 1.5.9.3. Unix timestamp support (MySQL); 1.5.9.4. Seconds in the day (MySQL); 1.5.9.5. DATE_FORMAT and TIME_FORMAT (MySQL); 1.5.10. Numeric Conversions (MySQL); 1.5.11. Datetime Conversions (PostgreSQL); 1.5.12. Numeric Conversions (PostgreSQL); 1.6. Deleting Data; 1.6.2. Deleting All Rows

1.6.3. Deleting from Views and Subqueries1.6.4. Returning Deleted Data (Oracle, DB2); 1.6.5. Double-FROM (SQL Server); 1.7. Functions; 1.7.1.2. Rounding and truncating DATEs in Oracle; 1.7.1.3. Other useful Oracle datetime functions; 1.7.2. Datetime Functions (DB2); 1.7.3. Datetime Functions (SQL Server); 1.7.4. Datetime Functions (MySQL); 1.7.5. Datetime Functions (PostgreSQL); 1.7.5.2. Rounding and truncating in PostgreSQL; 1.7.5.3. Other useful PostgreSQL datetime functions; 1.7.6. Numeric and Math Functions (All Platforms); 1.7.7. Trigonometric Functions (All Platforms)

1.7.8. String Functions1.7.8.2. Replacing text in a string; 1.7.8.3. Extracting a substring; 1.7.8.4. Finding the length of a string; 1.7.8.5. Concatenating strings; 1.7.8.6. Trimming unwanted characters; 1.7.8.7. Changing the case of a string; 1.7.9. GREATEST and LEAST (Oracle, PostgreSQL); 1.8. Grouping and Summarizing; 1.8.2. GROUP BY; 1.8.3. Useful GROUP BY Techniques; 1.8.3.2. Grouping before the join; 1.8.4. HAVING; 1.8.5. GROUP BY Extensions (Oracle, DB2); 1.8.5.2. CUBE (Oracle, DB2); 1.8.5.3. GROUPING SETS (Oracle); 1.8.5.4. Related functions (Oracle, DB2)

1.8.6. GROUP BY Extensions (SQL Server)1.8.6.2. CUBE (SQL Server); 1.8.6.3. GROUPING (SQL Server); 1.9. Hierarchical Queries; 1.9.2. CONNECT BY (Oracle); 1.9.2.2. Creative CONNECT BY (Oracle); 1.9.2.3. WHERE clauses with CONNECT BY (Oracle); 1.9.2.4. Joins with CONNECT BY (Oracle); 1.9.2.5. Sorting CONNECT BY results (Oracle); 1.9.2.6. Loops in hierarchical data (Oracle); 1.9.2.7. CONNECT BY functions and operators (Oracle); 1.10. Indexes, Creating; 1.11. Indexes, Removing; 1.12. Inserting Data; 1.12.2. Multi-Row Inserts (DB2, MySQL); 1.12.3. Insert Targets; 1.12.4. Subquery Inserts

1.12.5. Returning Inserted Values (Oracle, DB2)

Notes:

Includes index.

Previous ed.: published as SQL pocket reference. 2004.

Description based on print version record.

Related Work:

Gennick, Jonathan. SQL pocket reference.

ISBN:

9781306815284

1306815282

9780596529048

059652904X

9780596554538

0596554532

OCLC:

609841155