D | 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]

data
    accessing
        from another user 's table
        SELECT statement
    case sensitivity 2nd 3rd
    data types
        BOOLEAN values 2nd
        date and time
        decimal values
        domains 2nd
        fixed length
        floating-point decimals
        integers
        literal string 2nd
        NULL values
        numeric
        user defined type
        varying-length 2nd
    deleting from tables 2nd 3rd 4th
    grouping
         GROUP BY clause 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th
        HAVING clause 2nd 3rd
    inserting into tables 2nd 3rd 4th
        from another table 2nd 3rd 4th 5th 6th
        limited columns 2nd 3rd 4th 5th
        NULL values 2nd 3rd 4th
    integrity constraints
        Check (CHK) constraints 2nd 3rd
        disableing
        dropping 2nd
        foreign key constraints 2nd
        NOT NULL constraints
        primary key constraints 2nd 3rd 4th
        unique column constraints 2nd
    populating tables
    selecting
        from another user's table
    selecting from multiple tables
    sorting
        GROUP BY clause 2nd 3rd 4th 5th 6th 7th
        ORDER BY clause
    summarized data
        views, creating
    updating in tables
        multiple columns 2nd 3rd
        single column values 2nd 3rd 4th
    views
        maintaining
data administration commands
    START AUDIT
    STOP AUDIT
data and time storage
    DATETIME elements 2nd
Data Control Language. [See DCL]
Data Definition Language (DDL))
Data Definition Language. [See DDL]
data integrity
    integrity constraints
Data Manipulation Language. [See DML]2nd [See DML]
Data Query Language. [See DQL]2nd [See DQL]
data redundancy
data type definition
data types
    ANSI SQL
    BOOLEAN values 2nd
    character strings
    data
    date and time
    date and time values
    decimal values
    domains 2nd
    fixed length
    floating-point decimals
    integers
    literal string 2nd
    NULL values
    numeric
    numeric strings
    user-defined type
    using single quotation marks with
    varying-length 2nd
database
    security
        user access 2nd 3rd 4th 5th
database administration
database administrator
database administrator (DBA)
database administrator. [See DBA]
database applications
     components
database management system. [See DBMS]
database objects 2nd
database performance
    transactional control commands
database tuning vs. SQL tuning 2nd
database users 2nd
    access, removing 2nd
    creating 2nd
        altering attributes 2nd
        in Microsoft SQL Server 2nd
        in Oracle 2nd
        in Sybase 2nd
    management staff
    schema owners
    sessions 2nd
    tools
    types
database vendors
databases 2nd
     cursors 2nd
        closing 2nd
        fetching data
        opening
    denormalizing 2nd
    indexes 2nd
        composite 2nd
        determining when to consider/avoid 2nd 3rd 4th
        dropping 2nd
        implicit
        single-column 2nd 3rd
        table access 2nd
        unique 2nd
    Microsoft SQL Server
        user accounts, creating 2nd
    modern databases
    normalizing
        benifits 2nd
        drawbacks
        logical database design 2nd
        naming conventions
        normal forms 2nd 3rd 4th 5th 6th 7th 8th
    Oracle
        altering user attributes 2nd
        user accounts, creating 2nd
    performance tuning
        performance tools
    relational databases 2nd 3rd
    remote databases
        accessing 2nd 3rd
         Open Database Connectivity
        vendor connectivity products
    schemas
        creating 2nd
        removing 2nd
    security
        comparing to user management 2nd
        privileges 2nd 3rd
    stored procedures 2nd 3rd
        advantages
        creating
        executing 2nd
        triggers 2nd
    Sybase
        user accounts, creating 2nd
    system catalog 2nd
        contents 2nd 3rd
        creating
        database design information
        Microsoft Access
        Microsoft SQL Server
        MySQL
        Oracle
        performance statistics
        queries 2nd 3rd
        security information
        Sybase
        updating
        user data
    system date
        retrieving 2nd
    tables
        multiple keys 2nd
        primary keys
        z [See also tables]
    tables. [See tables]
    transactional control command
    transactional control commands 2nd
        COMMIT 2nd 3rd 4th 5th
        RELEASE SAVEPOINT
        ROLLBACK 2nd 3rd 4th 5th 6th 7th 8th 9th
        SAVEPOINT 2nd 3rd 4th 5th 6th
        SET TRANSACTION
    views
        storing
    views, [See views]2nd [See views]
    web-based systems)
datatypes
    character string datatypes 2nd 3rd 4th
    conversion functions
    DATE 2nd
    numeric 2nd 3rd
    TIME 2nd
    TIMESTAMP 2nd
date and time data types
date and time storage
    datatypes 2nd
date conversions 2nd
    CAST operator 2nd
    converting character strings to dates 2nd 3rd 4th 5th
    date pictures 2nd 3rd
DATE datatype 2nd
date functions
    adding time to dates 2nd 3rd 4th 5th
    adding times to dates 2nd 3rd 4th 5th
    comparing dates and time periods
    time zones
date pictures
    Oracle
    Sybase 2nd
DATEADD function
    SQL server
DATEDIFF function
    SQL server
DATENAME function
    SQL server
DATEPART function
    SQL server
DATETIME data type
    elements
DATETIME data types
DATETIME elements 2nd
DATETIME value 2nd 3rd
DATETIME values 2nd
DBA (database administrator
DBA (database administrator)
DBA group (privileges)
dBase
    cursors
        closing
        fetching data
        opening
DBMS (database management system)
DCL (Data Control Language)
    commands
DCL commands
    ALTER PASSWORD
    CREATE SYNONYM
    GRANT
    REVOKE
DDL (Data Definiation Language)
    commands
DDL (Data Definition Language))
DDL commands
    ALTER INDEX
    ALTER TABLE
    CREATE INDEX
    CREATE TABLE
    CREATE VIEW
    DROP INDEX
    DROP TABLE
    DROP VIEW
deallocate statement
decimal values data types
DECODE function 2nd
default attributes
    for columns
default storage values
defining
    primary keys 2nd
DELETE
    DML command
DELETE command 2nd
    DML
DELETE statement 2nd 3rd 4th 5th
    subqueries 2nd
deleting
    table data 2nd 3rd 4th
denomalizing
    databases 2nd
DESC options
    ORDER BY clause
descending order
    ORDER BY clause 2nd
direct invocation
direct SQL
    comparing to embedded SQL
disabling
    integrity constraints
disabling indexes
    batch loads 2nd
DISCONNECT command
DISTINCT command
    AVG function
    COUNT function 2nd
    MAX function
    MIN function 2nd
    SUM function
DISTINCT option
    parentheses
    SELECT statement 2nd
division operator
    arithmetic operators
DML (Data Manipulation Language)
    commands
DML commands
    DELETE 2nd
    INSERT
    SELECT
    transactional control commands
    UPDATE 2nd
domains 2nd
    constraints
        adding
    creating
    referencing
DOUBLE PRECISION data type
DQL (Data Query Language)
    commands
    SELECT statement
DQL commands
    SELECT
drawbacks
    normalizing databases
driver managers
DROP command
DROP INDEX
    DDL command
DROP INDEX statement
DROP ROLE statement 2nd
DROP SCHEMA statement 2nd
DROP statement
    tables
        dropping 2nd
DROP TABLE
    DDL command
DROP TABLE statement
DROP TRIGGER statement
DROP VIEW
    DDL command
DROP VIEW command 2nd
    CASCADE option 2nd
    RESTRICT option
DROP VIEW statement
dropping
    integrity constraints 2nd
    schemas
    synonyms
    tables 2nd
        warnings
    triggers
    views 2nd
dropping indexes 2nd
dynamic SQL 2nd


Team-Fly

Top

About Safari Terms of Service Privacy Policy Contact Us Help Submit a Problem
Copyright