F

Team-Fly

---

  

	Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
	Table of Contents

---

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]

FETCH statement 
fetching data ( cursors ) 
field definition 
fields
    tables  2nd  3rd 
        naming 
firewalls 
first normal form 
fixed-length data types 
FLOAT data type 
floating point decimals 
foreign key constraint
    integrity constraints  2nd 
foreign key constraints 
foreign keys 
formatting
    SQL statements 
        for readability  2nd  3rd  4th 
        join conditions, ordering  2nd 
        most restrictive condition  2nd  3rd 
        table arrangement in FROM clause 
FROM clause 
    SELECT statement  2nd  3rd  4th  5th 
    table arrangement 
front-end applications  2nd  3rd 
front-end tools 
front-end Web tools 
full table scans   2nd 
    avoiding  2nd 
functions 
    ADD MONTHS
        Oracle  2nd 
    aggregate  2nd 
        AVG  2nd 
        MAX  2nd 
        MIN  2nd 
    aggregate functions 
        AVG  2nd  3rd  4th  5th 
        COUNT  2nd  3rd  4th  5th  6th  7th  8th 
        MAX  2nd 
        MIN  2nd  3rd 
        SUM  2nd  3rd 
    character 
        substring 
    character functions 
        ASCII 
        combining  2nd  3rd 
        concatention  2nd 
        DECODE  2nd 
        INSTR  2nd 
        LENGTH 
        LOWER 
        LPAD  2nd 
        LTRIM  2nd 
        NVL  2nd 
        POSITION  2nd 
        REPLACE 
        RPAD  2nd 
        RTRIM  2nd 
        SUBSTR  2nd 
        TRANSLATE  2nd  3rd 
        UPPER 
    conversion 
    COUNT
        queries  2nd  3rd  4th 
    date functions 
        comparing dates and time periods 
        time zones 
    DATEADD
        SQL server 
    DATEDIFF
        SQL server 
    DATENAME
        SQL server 
    DATEPART
        SQL server 
    GETDATE()
        SQL server 
        Sybase 
     group functions 
    mathmatical functions  2nd 
    MONTHS BETWEEN
        Oracle server 
     NEXT DAY
        Oracle server 
    stored procedures  2nd  3rd 
        advantages 
        creating 
        executing  2nd 
        triggers  2nd 
    TO CHAR
        Oracle 
    TRANSACT-SQL conversion function 

---

Team-Fly

Top