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 go...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, Califiornia :
O'Reilly
2006.
|
| Edición: | 2nd ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627029806719 |
Tabla de Contenidos:
- 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)
