Books & Videos

Table of Contents

  1. Chapter 1 SQL Pocket Guide

    1. Introduction

    2. Analytic Functions

    3. CASE Expressions: Simple

    4. CASE Expressions: Searched

    5. CAST Function

    6. CONNECT BY Queries

    7. Data Type Conversion

    8. Data Types: Binary Integer

    9. Data Types: Character String

    10. Data Types: Datetime

    11. Data Types: Decimal

    12. Datetime Conversions: DB2

    13. Datetime Conversions: MySQL

    14. Datetime Conversions: Oracle

    15. Datetime Conversions: PostgreSQL

    16. Datetime Conversions: SQL Server

    17. Datetime Functions: DB2

    18. Datetime Functions: MySQL

    19. Datetime Functions: Oracle

    20. Datetime Functions: PostgreSQL

    21. Datetime Functions: SQL Server

    22. Deleting Data

    23. EXTRACT Function

    24. GREATEST

    25. Grouping and Summarizing

    26. Hierarchical Queries

    27. Indexes, Creating

    28. Indexes, Removing

    29. Inserting Data

    30. Joining Tables

    31. LEAST

    32. Literals

    33. Merging Data

    34. Nulls

    35. Numeric Conversions: DB2

    36. Numeric Conversions: MySQL

    37. Numeric Conversions: Oracle

    38. Numeric Conversions: PostgreSQL

    39. Numeric Conversions: SQL Server

    40. Numeric/Math Functions

    41. OLAP Functions

    42. Pivoting and Unpivoting

    43. Predicates

    44. Recursive Queries

    45. Regular Expressions

    46. Selecting Data

    47. String Functions

    48. Subqueries

    49. Tables, Creating

    50. Tables, Dropping

    51. Tables, Modifying

    52. Transaction Management

    53. Union Queries

    54. Updating Data

    55. Window Functions