Fehily C. — SQL (Visual QuickStart Guide) :: Электронная библиотека попечительского совета мехмата МГУ

Главная Ex Libris Книги Журналы Статьи Серии Каталог Wanted Загрузка ХудЛит Справка Поиск по индексам Поиск Форум

Авторизация

Поиск по указателям

Красота

Fehily C. — SQL (Visual QuickStart Guide)

Fehily C. — SQL (Visual QuickStart Guide)

Обсудите книгу на научном форуме

Нашли опечатку?
Выделите ее мышкой и нажмите Ctrl+Enter

Название: SQL (Visual QuickStart Guide)

Автор: Fehily C.

Аннотация:

Database management. It may sound daunting, but it doesn't have to be, even if you've never programmed before. SQL: Visual QuickStart Guide isn't an exhaustive guide to SQL written for aspiring programming experts. It's simply an invaluable resource for those who want a fast, easy way to harness information living in complex databases.

Because author Chris Fehily assumes no prior programming experience on your part (just a familiarity with your OS's file system), he spends the first few chapters laying out the basics, including clear explanations of the relational database model and SQL syntax. Then he jumps into step-by-step tasks designed to get you comfortable using SQL right away. You'll learn how to use SQL's most popular statements and commands to maintain, retrieve, and analyze database information, and to create and edit database objects. Each visually oriented task features the actual code and plenty of screenshots to keep you on track. Fehily takes a software-independent approach to teaching SQL, but includes tips for specific database software. You may not be a programming expert, but with SQL: VQS, who will be able to tell?

Язык:

Рубрика: Технология/

Статус предметного указателя: Готов указатель с номерами страниц

ed2k: ed2k stats

Год издания: 2002

Количество страниц: 442

Добавлена в каталог: 22.06.2007

Операции: Положить на полку | Скопировать ссылку для форума | Скопировать ID

Предметный указатель

searched CASE expressions      2nd
searching for multiple-column
searching for multiple-column duplicates      [See constraints]
second      2nd
Second normal form      2nd
security, views and
Select      [See subqueries]
SELECT * clause      2nd
SELECT * clause in
SELECT clause
SELECT clause vs      [See subqueries]
SELECT DISTINCT clause
SELECT statement
SELECT statement vs
SELECT statements
SELECT statements in      2nd
selecting every nth      [See filtering rows joins sorting
selecting every nth row      [See IBM DB2]
self-join support in      [See IBM DB2]
self-joins      2nd 3rd 4th 5th 6th 7th
self-joins and      [See FOREIGN KEY constraints]
self-joins and table
self-joins for      [See joins views]
self-referencing tables
semicolon (; )
SEQUENCE      [See joins views]
sequence for specifying outer joins      [See joins views]
sequence generators      [See IBM DB2]
sequence tables      2nd 3rd
sequence tables and
Sequences
sequences, runs, and regions
Sessions
set functions      [See DB2;aggregate functions]
set membership of subqueries      2nd 3rd 4th 5th 6th 7th
set membership tests      2nd 3rd 4th 5th 6th 7th [See also correlated subqueries simple
Set operations      2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd
Set theory      [See set operations]
Sets
setting constraints for      [See constraints]
Show Table dialog box (Access)
SIMPLE      2nd
simple and correlated      2nd 3rd 4th 5th [See also correlated subqueries simple
simple and correlated subqueries
simple case expressions      2nd
simple foreign keys      2nd
simple indexes      2nd 3rd
simple primary keys
simple statement      2nd
simple subqueries
simple unique constraints
simple vs      [See subqueries]
single quotes (')
sole
SOME keyword
sort order and
sort order for      [See IBM DB2]
Sorting      [See filtering rows joins sorting
sorting and
sorting and listing authors and publishers by
sorting authors by same state
sorting bestsellers by author      2nd
sorting by
sorting by sales
sorting by state
sorting nulls
sorting rows      [See constraints]
sorting speed
sorting speed and
Soundex functions
Soundex functions and
source and target
spaces in character strings      2nd 3rd
specified value comparisons      2nd 3rd [See also correlated subqueries simple
Specifying      [See outer joins]
specifying column's nullability      2nd
specifying escaped/unescaped characters
specifying tables for      2nd
speed of
speeding up queries having AND operators
spreadsheets and      [See joins views]
spreadsheets, tables and
SQL
SQL based on
SQL levels of conformance
SQL operators expressing types of
SQL Server 2005
SQL Server steps for creating      2nd 3rd 4th
SQL statements
SQL tuning      [See IBM DB2]
SQL View (Access)      [See subqueries]
SQL*Plus example of      [See subqueries]
sqlcmd command-prompt utility
sqlplus command-line options
sqlplus command-line utility
sqlplus command-line utility in
standard aggregate functions
standard keywords      [See IBM DB2]
Standards
standards for      2nd
START TRANSACTION      [See subqueries]
START TRANSACTION statement
starting
starting command-line processor in Windows
state and royalty subqueries by co-author
States
Statistics
statistics in      2nd
statistics in SQL      [See IBM DB2]
Storing
streamlining expressions when filtering rows
streamlining when filtering rows
string comparisons and
strings      [See character strings]
strings to upper- or lowercase
subqueries      [See IBM DB2]
subqueries embedded in      [See subqueries]
subqueries embedded in statements
subqueries listing books by type      2nd
subqueries vs      2nd 3rd 4th 5th 6th [See also INNER JOIN clause JOIN OUTER
subqueries with      2nd
subquery
subquery characteristics      [See subqueries]
subquery comparisons returning      2nd
subquery SELECT clause with
subquery support in
subquery vs. join syntax and
substring functions      [See IBM DB2]
SUBSTRING() function
substrings
subtraction (-) operator      2nd 3rd
sum()
summing distinct values
Sums
Sybase Adaptive Server      [See IBM DB2]
Sybase Adaptive Server compatibility with
Syntax      2nd 3rd 4th
syntax for
syntax for subqueries with
syntax of
syntax of simple      [See subqueries]
system catalog
system tables
table
table aliases
table aliases and      [See subqueries]
table aliases for      [See IBM DB2]
table aliases with      2nd
table aliases with AS      2nd [See also INNER JOIN clause JOIN OUTER
table constraints

table relationships between foreign and      [See PRIMARY KEY constraints]
table relationships between primary and      [See FOREIGN KEY constraints]
table scans
Tables
tables in      2nd 3rd 4th 5th 6th
tables, columns, and rows      2nd 3rd
telephone lists      [See joins views]
Temporary      [See joins views]
temporary tables      [See IBM DB2]
Terminology
Testing
testing existence of      [See filtering rows joins sorting
testing existence of rows      2nd 3rd 4th 5th 6th 7th
testing for existence by book type
testing for existence of type
testing for in outer joins
testing for null with WHERE conditions
testing for nulls      [See subqueries]
testing for with IS NULL      2nd 3rd
testing levels of conformance
testing membership in      [See set operations]
theta joins
third
Third normal form
three-table join for author      2nd
three-table join for royalties      2nd
three-table joins      [See inner joins]
three-value logic (3VL) systems
Time
tips for      2nd
titles table
titles_authors table
Tokens      [See date literals;datetime data types]
total calculations by author      2nd
total paid to publishers
total royalties for      2nd 3rd 4th
total royalties paid to
total royalty calculations by author
transaction logs
transaction-related      [See subqueries]
Transactions      2nd 3rd 4th 5th 6th
transferring from one table to another      [See filtering rows joins sorting
Transitive
transitive dependencies      [See joins views]
trim() function      2nd 3rd 4th 5th
Trimmed mean
trimming characters      [See IBM DB2]
trimming characters from
trimming characters from string
trimming from strings
trimming functions for
TRUNCATE      [See subqueries]
TRUNCATE statements
TRUNCATE vs
truncating result of integer division
truncating results of division
Truth      [See joins views]
Truth tables
Truth values
tuning      [See subqueries]
tuning SQL statements
turning on ANSI-92 query mode (Access)
two grouping columns in
two grouping columns to calculate      2nd
two grouping columns to calculate total royalties
two join conditions      [See inner joins]
two join conditions in
two-table join on columns      [See inner joins]
two-value logic (2VL) systems
type and price comparisons      2nd 3rd
types of      2nd
types of joins      [See joins views]
types of normal forms
types of relationships      2nd 3rd
unary table operations
underlying tables
underscore (_) wildcard operator      [See views]
Understanding      2nd
Unicode
UNION ALL operations      2nd 3rd
UNION clause      [See views]
UNION JOIN clause
UNION operations
UNION operations for      [See IBM DB2]
UNION operations with
UNION queries
UNION queries and
UNION vs      2nd
unique      2nd 3rd 4th 5th
UNIQUE constraints      2nd 3rd 4th 5th
unique identifiers
unique indexes
UNIX
unordered
unpublished      2nd
unpublished authors      2nd
unsupported for some DBMS      [See outer joins]
UPDATE      [See subqueries]
UPDATE statements
UPDATE statements and
UPDATE statements in      [See IBM DB2]
updateable
updateable views
updateable views and      [See subqueries]
updateable views with      [See also INNER JOIN clause JOIN OUTER
updating information for      2nd
updating rows      2nd 3rd 4th 5th
updating rows in
updating rows with      2nd 3rd 4th 5th
updating with UPDATE      [See filtering rows joins sorting
UPPER() and LOWER() with null arguments      2nd
upper() function      2nd 3rd
use in syntax
user information, current
user tables
user-defined types
User-Defined Types (UDTs)
user-defined types in      [See IBM DB2]
uses for      2nd
using      2nd [See also INNER JOIN clause JOIN OUTER
using aggregate functions in
using AND, OR, and NOT      2nd
using AND, OR, and NOT together
using as constraint
USING clause for      [See also INNER JOIN clause JOIN OUTER
USING clause to create      [See also inner joins]
using Command Center      2nd
using command-line processor
using in ORDER BY clause
using in strings
using INNER JOIN with      [See joins views]
using JOIN syntax for
using left outer join with WHERE syntax
using SQL Query Analyzer
using SQL*Plus      2nd 3rd
using subqueries with      2nd
using syntax for outer joins
using UPPER() and LOWER() functions in      2nd
using with AND and NOT
using with AND and OR
using with inner join
using with OR and NOT
values within a range with BETWEEN      2nd 3rd
VARCHAR strings      2nd
variations for AS clause      2nd
verbs
verbs in
Versions
viewing
viewing query execution plans      [See subqueries]

1 2 3 4 5

Реклама

© Электронная библиотека попечительского совета мехмата МГУ, 2004-2024

Электронная библиотека мехмата МГУ

Valid HTML 4.01!

|

Valid CSS!

О проекте