Главная    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?

Язык: en

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

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

ed2k: ed2k stats

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

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

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

Операции: Положить на полку | Скопировать ссылку для форума | Скопировать ID
Предметный указатель
" (double-quote character)
% (percentage) wildcard operator      
'' (consecutive single quotes)      
* (multiplication operator)      2nd 3rd
+ (addition operator)      2nd 3rd
- (subtraction operator)      2nd 3rd
/ (division opeator)      2nd 3rd
/* */ (bracketed comments)      
; (semicolon)      
< (less-than) join      
< ALL(subquery)      
<= (less-than or equal to) join      
<> (not-equal) joins      
> (greater-than) join      
> ALL(subquery)      
>= (greater-than or equal to) join      
about      2nd
about this book      2nd 3rd
ACCESS      [See Microsoft Access]
ACID acronym      
ACID acronym for      
adding by column position      [See filtering rows joins sorting
adding in INNER JOIN clause      
adding row by column position      
adding rows by position of      [See constraints]
adding rows from another      [See joins views]
adding rows with      2nd 3rd 4th 5th 6th 7th 8th
adding to complex expressions      
adding, subtracting, multiplying, or dividing      2nd [See also comparison operators]
addition (+) operator      2nd 3rd
additional grouping column in      
additional grouping column with      [See inner joins]
Aggregate functions      [See IBM DB2]
aggregate functions and      [See subqueries]
aggregate functions and GROUP BY clause with      
aggregate functions not in      
aggregate functions with      [See inner joins]
aliases for      [See joins views]
ALL keyword      
ALL keyword with      
ALTER TABLE      [See subqueries]
ALTER TABLE statements      
altering      [See joins views]
altering tables      
AND operator in      2nd
AND operators and performance      [See subqueries]
ANSI-89 query mode (Access)
ANSI-92 query mode
ANSI-92 query mode (Access)
ANSI-92 query mode with
ANY keyword      
ANY keyword with      
application sequence for      2nd
application sequence for WHERE, HAVING and      2nd
approximate numeric types      
approximate numeric types for      
Arithmetic mean      
arithmetic operators      
AS clause      
as column expressions      2nd 3rd 4th 5th 6th [See also correlated subqueries simple
ASCII encoding      
assigning ranks      2nd
atomic values      
authors by sales      
authors by state      
authors listed by city of      2nd 3rd 4th 5th 6th 7th
authors table      
authors table in      
autocommit mode      
averaging distinct values      2nd 3rd
AVG()      2nd
AVG() aggregate function      2nd
backslash (\)      
backup/restore mechanisms      
Balanced tree      
Base      [See joins views]
base tables      
based on relational model      
batch mode      
bestsellers by author      2nd
BETWEEN condition      2nd 3rd
binary table operations      
BLOB data type      
BLOB data types      
BLOB types      [See IBM DB2]
books database incompatible for Access      2nd
books listed by type and sales      
books sample database      2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th
books_standard.sql      2nd 3rd
books_standard.sql script      2nd 3rd
BOOLEAN data type      
boolean data types      
Boyce-Codd normal form      
bracketed comments (/* */)      
by column      
by comparison      2nd 3rd
by DBMS platform      
by list      2nd
by matching pattern      2nd
by multiple columns      
by range      
by relative column positions      2nd
by using list      2nd
calculating authors' royalties      2nd
calculating differences between      
calculating differences between successive      [See filtering rows joins sorting
calculating for set of distinct values      2nd 3rd
calculating running statistics      2nd 3rd
calculating sums      [See IBM DB2]
calculating total      
calculating totals using INNER JOIN and      
calculating totals with      2nd
calculating trimmed mean      
calendar      [See joins views]
calendar tables      
candidate keys      
CASE expressions      2nd 3rd 4th
case sensitivity      
case-sensitive string comparisons      2nd 3rd
CAST() function      2nd 3rd 4th
caution using      
cautions using aggregate functions in subquery      
changing case of      2nd
changing for books      
changing publisher for      
changing sign of number      [See also comparison operators]
changing string case      2nd [See also comparison operators]
character string types      2nd
character strings      
characteristics of      
CHARACTER_LENGTH function      2nd
Check      2nd 3rd 4th
CHECK constraints      2nd 3rd 4th
CHECK constraints and      [See IBM DB2]
checking for nulls      [See IBM DB2]
checking for with COALESCE()      2nd
checking nulls      
choosing data types      
clustering indexes      
co-authors      2nd 3rd 4th
co-authors also sole      
COALESCE() function      2nd
Collating sequence      
column aliases      
column aliases in      
column aliases with      2nd
column constraints      
columns in      
combining and negating conditions      2nd 3rd 4th 5th 6th 7th 8th [See also conditions]
combining inner and left outer join      [See IBM DB2]
combining inner join with      
combining inner join with COUNT() and      
combining rows with UNION      2nd 3rd 4th 5th 6th
combining with left outer join      [See inner joins]
combining with UNION      [See filtering rows joins sorting
combining with UNION operations      [See subqueries]
Command Center (IBM DB2)      2nd
command line for      
command line for SQL      
commands showing execution of      [See also correlated subqueries simple
COMMIT      [See subqueries]
COMMIT statements      
committing transactions      2nd
common author and publisher      
common cities for author and      
common cities for publisher and      2nd
common errors in      
common state for publisher and      
common syntax errors in      
comparing all values      2nd 3rd [See also correlated subqueries simple
comparing author and co-author royalty shares      [See subqueries]
comparing author and co-author shares      
comparing authors in city without publisher      
comparing by city without publishers      
comparing equivalent      [See subqueries]
comparing equivalent queries      [See IBM DB2]
comparing expressions      2nd [See also comparison operators]
comparing results with inner joins      2nd 3rd 4th 5th
comparing results with outer joins      [See natural joins]
comparing subquery values      2nd 3rd 4th 5th 6th 7th 8th 9th
comparing subquery values with      2nd 3rd
comparing values      2nd 3rd 4th 5th 6th [See also correlated subqueries simple
comparing values in joins and      
comparing values in WHERE clauses and      [See also INNER JOIN clause JOIN OUTER
comparing values with      
comparing values with self-joins      [See also INNER JOIN clause JOIN OUTER
comparing VARCHAR strings      2nd
comparing with NULLIF() function      2nd
Comparison operators      
comparison operators in      
comparison operators in full outer join      
comparison operators with      
compatible data types for joined      [See constraints]
complex unique constraints      2nd
Composite      2nd
composite foreign keys      2nd
composite indexes      2nd
composite primary keys      
compound conditions      
compound conditions and      
concatenating      2nd 3rd
concatenating in Oracle      
concatenating strings      2nd 3rd [See also comparison operators]
Concatenation operator      [See IBM DB2]
concurrency control      
concurrency control and transparency      [See books sample database]
concurrency transparency      
conditional values      2nd 3rd 4th 5th
connecting PostgreSQL to server      
connecting to server from remote network      
consecutive integers      
Constant expressions      2nd
converting data types      2nd 3rd 4th [See also comparison operators]
converting nonstrings to      
converting strings to upper- or lowercase      
correlated subqueries      
correlated vs      [See correlated subqueries subqueries]
COUNT() aggregate function      2nd
COUNT(*) aggregate function      
COUNT(*) clause in      [See also correlated subqueries simple
COUNT(expr) aggregate function, in GROUP BY query      
Counting      [See filtering rows joins sorting
counting authors, publishers, and titles by state      
counting by state      
counting distinct non-null      [See filtering rows joins sorting
counting items by      
counting rows including      
covered in this book      
CREATE INDEX      [See subqueries]
CREATE INDEX statements      
CREATE TABLE      [See subqueries]
CREATE TABLE AS      [See subqueries]
CREATE TABLE AS statements      2nd 3rd 4th 5th
CREATE TABLE statements      
CREATE TABLES AS statements      [See IBM DB2]
CREATE TEMPORARY TABLE      [See subqueries]
CREATE TEMPORARY TABLE statements      2nd 3rd 4th
CREATE VIEW      [See subqueries]
CREATE VIEW statement      2nd 3rd 4th 5th 6th
creating aliases for      [See constraints]
creating books database      2nd 3rd 4th
creating books sample database      
creating column aliases      [See IBM DB2]
creating derived columns      2nd [See also comparison operators]
creating indexes      2nd 3rd
creating inner join listing with      
creating INNER JOIN with      
creating joins with      2nd 3rd
creating natural joins with      
creating new table from existing      [See joins views]
creating sample database      
creating sample database for      2nd
Creating tables      2nd
creating telephone      
creating telephone list with COALESCE() function      [See also INNER JOIN clause JOIN OUTER
creating three-table join      
creating views      [See IBM DB2]
creating with AS clause      2nd
creating with CREATE TABLE      [See joins views]
creating with JOIN or WHERE      2nd 3rd [See also INNER JOIN clause JOIN OUTER
cross      2nd [See also INNER JOIN clause JOIN OUTER
CROSS JOIN clause      2nd
cross joins      
CSV files      
current date and time      2nd [See also comparison operators]
CURRENT_DATE functions      2nd
CURRENT_TIME functions      2nd
CURRENT_USER function      
CURSOR declarations      
data recovery and      
data recovery and transaction logs      [See books sample database]
data type conversion and handling of      
Data types      2nd
data types in      [See constraints]
data types within      2nd
database design      
1 2 3 4 5
       © Электронная библиотека попечительского совета мехмата МГУ, 2004-2017
Электронная библиотека мехмата МГУ | Valid HTML 4.01! | Valid CSS! О проекте