Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)

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]

identifiers

    integers

        ORDER BY clause  2nd  3rd 

implementations   2nd 

    ANSI SQL compliance  2nd 

    differences  2nd  3rd 

    extensions  2nd 

        PL/SQL  2nd 

        Transact-SQL 

    vendor-specific 

implicit indexes 

implimentation restrictions

     columns (tables)

        modifying 

implimentations

    extensions

        Transact-SQL 

IN operator

    logical operators  2nd 

indexes  2nd 

    composite indexes 

        comparing to single-column 

    determining when to consider/avoid  2nd  3rd  4th 

    disabling during batch modes  2nd 

    dropping  2nd 

    implicit indexes 

    single-column indexes  2nd 

        comparing to composite 

    table access  2nd 

    unique indexes  2nd 

Informix

    SQL implimentations syntax 

INNER JOIN.  [See INNER JOIN]2nd  [See INNER JOIN]

INSERT command

    DML 

INSERT statement  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th 

    subqueries  2nd 

INSERT statements

    examples 

INSERTSELECT statement 

inserting

    data

        tables  2nd  3rd  4th 

installing

    MySQL

        on Windows  2nd 

    MySQL on Linux  2nd 

INSTR function  2nd 

integers 

    identifiers

        ORDER BY clause  2nd  3rd 

integers data types 

integrity constraints 

    Check (CHK) constraints  2nd  3rd 

    disabling 

    dropping  2nd 

    foreign key  2nd 

    NOT NULL constraints 

    primary key constraints  2nd  3rd  4th 

    unique column  2nd 

interactive invocation 

interactive SQL statements 

    parameters  2nd 

International Standards Organizations.  [See ISO]

Internet

    SQL usage  2nd 

interrelated parts

    SQL-99

        SQL/Call-Level Interface 

        SQL/Foundation 

        SQL/Framework 

        SQL/Host Language Bindings 

        SQL/Persistant Stored Modules 

INTERSECT operator  2nd  3rd 

intranet

    SQL usage 

invoking sessions) 

ISO (International Standards Organizations)

    SQL-99 


Team-Fly    
Top
 

Категории