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

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

blank
blank
blank
Красота
blank
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
blank
Предметный указатель
Learning      
learning database design      
learning design of      [See books sample database]
left outer joins      
less-than (<) join      [See outer joins]
less-than or equal to (<=) join      [See outer joins]
levels of conformance      
lexicographical ordering      
LIKE condition      
LIKE in      
limiting number of rows returned      
limiting number returned      [See filtering rows joins sorting
limiting rows returned      [See IBM DB2]
Linux      
list filtering      [See subqueries]
list of all authors and      
listed by publisher's city      2nd 3rd 4th 5th 6th 7th
listing all publishers and      
listing and printing      2nd
listing and printing royalties with      2nd
listing and printing royalties with WHERE condition      2nd
listing authors by publisher's      2nd 3rd 4th 5th 6th 7th
listing books by type and sales      
listing by publisher      
listing by sales value      
listing by type and sales conditions      
listing for author and publisher      
listing for character codes      
listing items with WHERE condition      [See outer joins]
listing objects with inner and outer queries      [See inner joins]
listing of      
listing of books_standard.sql script      2nd 3rd
listing only different pairs      
listing only different pairs of authors      
listing only nonduplicates      2nd
listing published authors by      
listing states of authors and      2nd
listing states of publisher and      2nd
listing tables      [See IBM DB2]
listing values using two      [See also correlated subqueries simple
literal values      
local temporary tables      2nd
locating substrings with POSITION()      2nd 3rd [See also comparison operators]
Locking      
locking data      
lossless decomposition      
lower() function      2nd 3rd
making case-insensitive comparisons      
Mantissa      
many-to-many      
Many-to-many relationships      
matching patterns      [See IBM DB2]
matching patterns with      [See subqueries]
matching with LIKE      2nd 3rd 4th
max()      
MAX() aggregate function      
MAX() clause      
Median      
Microsoft Access      [See IBM DB2]
Microsoft SQL Server      [See IBM DB2]
Microsoft Windows with IBM DB2      2nd
min()      
MIN() aggregate function      
MODE      
modulo expressions      
monadic arithmetic operators      
moving      
moving averages      
multiple columns      
multiple subqueries      
multiple table joins with      2nd 3rd 4th
multiplication (*) operator      2nd 3rd
MySQL      [See IBM DB2]
mysql command-line options      
mysql command-line utility      
mysql command-line utility in      
MySQL steps for creating      
naming      
naming constraints      
Natural      2nd 3rd 4th 5th [See also INNER JOIN clause JOIN OUTER
natural inner joins      [See natural joins]
NATURAL JOIN clause      2nd 3rd 4th
natural join support      [See IBM DB2]
natural joins      2nd 3rd 4th [See also inner joins]
natural joins and naming of      [See constraints]
natural joins in      2nd
negating conditions      [See combining and negating conditions]
nested queries      
nesting aggregate functions      [See subqueries]
nesting subqueries in      
nesting transactions      [See subqueries]
non-reserved keywords      [See subqueries]
nonclustering indexes      [See subqueries]
nonstrings      [See subqueries]
nonstrings to strings      
nonupdateable views      [See subqueries]
Normal forms      
Normalization      2nd 3rd 4th 5th 6th
NOT EXISTS subqueries and      
NOT EXISTS tests      
NOT NULL      2nd 3rd 4th
NOT NULL constraints      2nd 3rd 4th
NOT operator      
NOT operator in      2nd
not-equal (<>) joins
not-equal joins and      
nullability of      [See constraints]
nullability with PRIMARY KEY columns      [See IBM DB2]
nullable columns and      
NULLIF() expression      [See CASE expressions]
NULLIF() function      2nd
NULLs      
nulls in      [See IBM DB2]
Numbers      
object references      [See IBM DB2]
ON DELETE clause      2nd
ON UPDATE clause      2nd
one-to-many      
One-to-many relationships      
one-to-many relationships and      [See FOREIGN KEY constraints]
one-to-many relationships in      [See joins views]
One-to-one      
One-to-one relationships      
one-to-one relationships in      [See joins views]
opening in Access      
opening sample database      
Operator overloading      
operators and functions      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 44th [See also comparison operators]
OR operator      
OR operator in      2nd
Oracle      [See IBM DB2]
Oracle steps for creating      2nd 3rd
ORDER BY clause      
ORDER BY vs      
order of evaluation      
order of evaluation of      
Order statistics      
orphan      [See filtering rows joins sorting
orphan rows      
osql command-line options      2nd
osql command-line utility      2nd
osql command-line utility in      
other normal forms      
OUTER JOIN clause      
OUTER JOIN syntax      [See IBM DB2]
outer joins      2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th
outer joins with      2nd
outer queries      
Overlay function      
overriding evaluation order with      
Parent-child relationships      
parentheses ()      
partial and fully functional      2nd
partial and fully functional dependencies      [See joins views]
partial functional dependency      
path and pathnames      
pathnames      [See IBM DB2]
Patterns      
percentage (%) wildcard operator      
Performance      
picking random      [See filtering rows joins sorting
picking random rows      2nd
pipe operator (||)      2nd 3rd
pivot tables      
placing around alias      
placing double quotes around      
Platforms      
populating      [See joins views]
populating tables      
Position functions      [See IBM DB2]
position of substrings in      [See character strings]
position() function      2nd 3rd
PostgreSQL      [See IBM DB2]
PostgreSQL steps for creating      
precedence in      [See IBM DB2]
precedence of      
precedence of operators      
precision and scale examples for      
preventing duplicate values with UNIQUE      2nd 3rd 4th
price subqueries and      
Primary key      2nd 3rd 4th 5th
PRIMARY KEY constraints      2nd 3rd 4th 5th
primary keys      2nd
Programming languages      
promotion of      
promotion of data types      
psql command-line options      
psql command-line utility      
psql command-line utility with      [See subqueries]
Publishers      
publishers and authors by state      
publishers table      
qualified column names      2nd 3rd
qualified columns names      [See subqueries]
qualified names      [See constraints]
qualifying column names      2nd [See also INNER JOIN clause JOIN OUTER
qualifying column names in      [See also correlated subqueries simple
qualifying names in subqueries      [See constraints]
Queries      
queries for bestsellers      2nd
queries in      [See IBM DB2]
queries joining three tables      [See inner joins]
query execution plans      
query execution sequence for      [See also INNER JOIN clause JOIN OUTER
quota      [See subqueries]
quota queries      [See subqueries]
Randomization      2nd
randomization features      [See IBM DB2]
RANGE      
range filtering      [See subqueries]
ranking values      
ranking values in      [See subqueries]
ranking values in queries      [See IBM DB2]
re-creating and repopulating tables      2nd
re-expressing      
re-expressing conditions      2nd
referenced table      
referencing table      
referential integrity with foreign keys      
Regions      
Regular expressions      
Relational model      
relationships      2nd 3rd
remote networks      
removing spaces from string      2nd 3rd
removing spaces with TRIM()      2nd 3rd
removing tables from      [See books sample database]
removing with UNION expressions      
renaming      [See joins views]
renaming tables      [See IBM DB2]
replicating      2nd [See also inner joins]
replicating natural joins      
replicating with MAX() clause      
repopulating tables      2nd
requirements for derived columns      [See IBM DB2]
reserved and non-reserved      2nd 3rd 4th 5th 6th
reserved and non-reserved keywords      2nd 3rd 4th 5th 6th
reserved keywords      
restricting columns appearing in ORDER BY clause      [See IBM DB2]
restrictions      
restrictions on columns in      
restrictions on in ORDER BY clause      [See constraints]
results compared with inner      [See also INNER JOIN clause JOIN OUTER
retrieving columns      [See subqueries]
retrieving columns from      [See joins views]
retrieving columns from tables      2nd 3rd
retrieving columns with      2nd 3rd
retrieving data through      2nd 3rd
retrieving data through views      [See IBM DB2]
retrieving data with two existence tests      
retrieving rows with      2nd
retrieving through views      2nd 3rd
retrieving titles published by      2nd
retrieving titles published by state      2nd
retrieving with existence tests      
retrieving with null or non-null values      [See filtering rows joins sorting
retrieving with SELECT and FROM clauses      [See constraints]
returning if expressions equivalent      
returning single values with      
rewriting as joins      [See also correlated subqueries simple
rewriting subqueries as      [See also INNER JOIN clause JOIN OUTER
rewriting subqueries as joins      [See subqueries]
right outer join using WHERE syntax      
right outer joins      [See outer joins]
rollback      [See subqueries]
ROLLBACK statements      2nd 3rd
rolling back transactions      
row existence tests with      2nd 3rd 4th 5th 6th 7th [See also correlated subqueries simple
row existence with subqueries      2nd 3rd 4th 5th 6th 7th
Rows      2nd 3rd 4th
rows added from one table to another      2nd 3rd
rows in      
royalties      
royalties table      
royalty calculations with      [See inner joins]
running from Command Center      [See subqueries]
running from remote network      
running in Access      [See subqueries]
running multiple Access      [See subqueries]
running multiple queries in      
running MySQL from      
running on DBMS      2nd
running Oracle SQL      
running Oracle SQL scripts      
running SQL programs      [See IBM DB2]
running SQL statement in      2nd
running statistics      2nd 3rd
running statistics for      
runs      
sample database      
savepoints      [See books sample database]
savepoints for      
scalar subqueries      [See books sample database]
scalar vs. aggregate functions      [See also comparison operators]
scalar vs. aggregate functions for      [See filtering rows joins sorting
schemas      [See books sample database]
Scientific notation      [See books sample database]
script mode      
Scripts      
searched      2nd
1 2 3 4 5
blank
Реклама
blank
blank
HR
@Mail.ru
       © Электронная библиотека попечительского совета мехмата МГУ, 2004-2024
Электронная библиотека мехмата МГУ | Valid HTML 4.01! | Valid CSS! О проекте