Books & Videos

Table of Contents

  1. Chapter 1 SQL Pocket Guide

    1. Introduction

    2. Analytic Functions

    3. CASE Expressions

    4. Datatypes

    5. Dataype Conversion

    6. Deleting Data

    7. Functions

    8. Grouping and Summarizing

    9. Hierarchical Queries

    10. Indexes, Creating

    11. Indexes, Removing

    12. Inserting Data

    13. Joining Tables

    14. Literals

    15. Merging Data (Oracle, DB2)

    16. Nulls

    17. OLAP Functions

    18. Predicates

    19. Recursive Queries

    20. Regular Expressions

    21. Selecting Data

    22. Subqueries

    23. Tables, Creating

    24. Tables, Modifying

    25. Tables, Removing

    26. Transaction Management

    27. Union Queries

    28. Updating Data

    29. Window Functions