Contents:

* Legend, definitions, and notes
* Features
o Views
o Join types/features
* The SELECT statement
o Ordering result sets
o Limiting result sets (RANK() / ROW_NUMBER() / LIMIT / TOP / FETCH FIRST)
+ Simple limit
+ Top-n (quota-queries)
+ Limit—with offset, including a note about the importance of sorting on unique values
* The INSERT statement
o Inserting several rows at a time
* Data types
o BOOLEAN
o CHAR
o Date and time types
+ TIMESTAMP
* Functions and operators
o CHARACTER_LENGTH
o SUBSTRING
o REPLACE
o TRIM
o LOCALTIMESTAMP
o Concatenation
* Constraint handling
o The UNIQUE constraint
* Mixture of type and operations
o Automatic key generation (IDENTITY/SERIAL/AUTO_INCREMENT)
* Bulk operations
o TRUNCATE TABLE
* Command line operations / metadata
o Starting the command line interface
o Getting a list of databases
o Getting a list of schemas
o Getting a list of tables
o Getting a table description
o Manually telling the DBMS to collect statistics
o Getting a query explanation
o Turning on query timing
* Other topics
o Dummy-table use
o Obtaining DBMS version
o Standard TCP/IP port

To Download this E-Book Click Here.