Computer BooksSQL

SQL Dialects Reference

By Admin

SQL Dialects Reference

Publisher: Wikibooks 2010

Description:
This wikibook is a compact comparative reference for several SQL language dialects. It lists particular common tasks and problems resolved in terms of several popular SQL server implementations. When possible, it tries to emphasize an universal solution. When it’s not possible, it tries to list best practices.

Home page url

Download or read it online here: 
Read online
(online html)

Contents

  1. Introduction
  2. Data structure definition
    1. Data types
      1. Numeric types
      2. Character types
      3. Date and time types
      4. Binary types
      5. Large object types
      6. Misc types
    2. Delimited identifiers
    3. Auto-increment column
  3. Functions and expressions
    1. Math functions
      1. Trigonometric functions
      2. Numeric functions
      3. Aggregate functions
    2. Date and time functions
    3. String functions
    4. Misc expressions
  4. Select queries
    1. Subqueries
    2. Select without tables
    3. Limiting results of select query
    4. Hierarchical Queries
  5. Write queries
    1. Replace query
    2. Insert results from select query into existing table
    3. Save results from select query as new table
    4. Update returning
  6. Transactions
  7. Procedural language
    1. Stored procedures
    2. User-defined functions (UDFs)
  8. SQL XML
  9. Administration
  10. References
You might also like
MISC. Books Urdu

Modern Tends in the Persian Language

Computer Books

Top 10 Free Books And Resources For Learning TensorFlow

Miscellaneous

Natural Language Processing Succinctly

Audio Book – Green Grey Homestead

Audio Book – A Full Moon in March

Perl 6 at a Glance