Главная    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
Предметный указатель
Database Language SQL      [See SQL]
Database Management Systems      [See DB2;DBMS-specific SQL features]
databases      
date literals      
date literals when filtering rows by list      [See IBM DB2]
datetime      2nd 3rd 4th 5th 6th 7th 8th
datetime data types      2nd 3rd
datetime fields      2nd
DB2      
db2 command-line options      
db2 command-line utility      [See IBM DB2]
db2 command-line utility in      
DB2 steps for creating      2nd
DBMS requirements for derived columns using      2nd
DBMS setup      [See IBM DB2]
DBMS support for      
DBMS-specific SQL features,      [See IBM DB2]
De Morgan's laws      
Debugging      
debugging WHERE clauses      [See IBM DB2]
decompressing      
DEFAULT clauses and      [See IBM DB2]
Default keyword      2nd 3rd 4th
default values for      [See constraints]
defined      2nd
Defining      2nd
defining sequence generators      2nd 3rd 4th 5th 6th
defining values with constraints      [See joins views]
DELETE      [See subqueries]
DELETE statements      
deleting all entries in table for      
deleting rows      2nd 3rd
deleting rows with      2nd
deleting selected entries      
denormalization      2nd
denormalizing      [See books sample database]
Dependencies      
dependency-preserving decomposition      
derived      [See constraints]
derived columns      
derived tables      
designing      [See books sample database]
detecting version running      
determinants for second normal form      [See views]
determining co-authorship by      
determining duplicates with      
determining if co-author      
determining subquery has one row      
determining with EXISTS tests      
directories      [See views]
directory path      
displaying Access      
displaying DB2      
displaying definitions      [See joins views]
displaying MySQL      
displaying Oracle      
displaying PostgreSQL      
displaying SQL Server      
displaying table definitions      [See IBM DB2]
DISTINCT      2nd 3rd 4th
DISTINCT aggregate function      2nd 3rd 4th
DISTINCT vs      
Distributive laws      
division (/) operator      2nd 3rd
domains      
Double Negation      
double-quote character (")
drawing comparisons from comparable      [See constraints]
drawing comparisons from comparable columns      
DROP INDEX      [See subqueries]
DROP INDEX statements      [See IBM DB2]
DROP TABLE      [See subqueries]
DROP TABLE statements      2nd
DROP VIEW      [See subqueries]
DROP VIEW statements      
dropping      2nd
dropping tables in      [See IBM DB2]
dropping views      [See joins views]
DUAL tables with constant expressions      
duplicate      [See filtering rows joins sorting
duplicate entries in      [See books sample database]
duplicate rows      2nd 3rd 4th 5th
durability      
dyadic arithmetic operators, defined      
effect of inner and outer joins on      [See filtering rows joins sorting
effect of null with OR operator      2nd
effect of on rows      [See natural joins]
effect of with OR operator      
eliminating duplicate rows      2nd
eliminating in calculations      2nd 3rd 4th
eliminating redundancies in self-joins      [See filtering rows joins sorting
eliminating redundant rows in results      
Embedded SQL      
empty string as null      2nd
empty strings      
empty tables      
ending transactions with      2nd
Entities      
entity types      
equivalencies for      
Equivalent      
equivalent conditions      
equivalent expressions      
equivalent expressions for      
errors in syntax      
ESCAPE keyword      
escaped and unescaped      
evaluating      
evaluating book types with      [See also correlated subqueries simple
evaluating comparison within type      
evaluating conditional values      [See IBM DB2]
evaluating multiple      [See also correlated subqueries simple
exact numeric types      2nd
exact numeric types by platform      [See IBM DB2]
exact numeric types for      2nd
example of      2nd
examples of      
EXCEPT clauses and      
except operations      
EXCEPT operations in      [See IBM DB2]
EXCEPT vs      
Exclusive-OR      
exclusive-or (xor) logical operator      
executing      2nd
executing transactions      [See IBM DB2]
execution sequence for      
execution sequence for joins      [See subqueries]
EXISTS tests      
EXISTS tests for subqueries      [See IBM DB2]
exiting      
EXPONENT      
expressing as subquery      [See natural joins]
Expressions      
expressions results for      
EXTRACT() function      2nd
extracting      2nd 3rd
extracting substrings      2nd 3rd
extracting substrings with      2nd 3rd
extraction function by platform      [See IBM DB2]
fifth normal form      
FileMaker Pro      [See IBM DB2]
filling in gaps for sequential integers      
Filtering      
filtering groups with      2nd 3rd
filtering rows      
filtering rows by      2nd 3rd
filtering rows by list and      
filtering rows by using list      
filtering rows with      2nd 3rd 4th
filtering rows with WHERE      
filtering values in range      [See IBM DB2]
filtering with HAVING clause      2nd 3rd
finding and listing      2nd
finding common      [See filtering rows joins sorting
finding common rows with      2nd
finding common rows with INTERSECT      2nd
finding DBMS-specific information on      [See also comparison operators]
finding different      [See filtering rows joins sorting
finding different rows with EXCEPT      2nd
finding information for operators and functions      [See IBM DB2]
finding length of      2nd
finding pairs by state      
finding pairs of authors in same state      
finding series of values      
finding series of values in      
finding sole authors with      
finding string length      [See IBM DB2]
finding string lengths      2nd [See also comparison operators]
finding substrings      2nd 3rd
finding with POSITION()      2nd 3rd
first      
First normal form      
for Linux, Unix, and Windows      
forbidding nulls      [See joins views]
forcing mathematical      
forcing mathematical closure      [See IBM DB2]
forcing unique values in      [See constraints]
Foreign key      2nd 3rd 4th 5th 6th 7th
FOREIGN KEY constraints      2nd 3rd 4th 5th 6th 7th
foreign keys      2nd
foreign keys and      2nd
formatting retrieved      
formatting retrieved data      [See FOREIGN KEY constraints]
four-table joins      
four-table joins with      [See inner joins]
fourth and fifth      
fourth normal form      [See FOREIGN KEY constraints]
FROM clause      
FROM keyword in DELETE statements      [See IBM DB2]
full outer join including all rows      
full outer join unsupported      
full outer joins      
full outer joins for      
fully functionally dependent      [See outer joins]
function of      
Function overloading      [See outer joins]
Functions      [See DB2;aggregate functions operators
further reading      
generating sequences      2nd 3rd 4th 5th 6th
getting current date and time      2nd
global temporary tables      2nd
greater-than (>) join
GROUP BY      [See subqueries]
GROUP BY clause      [See IBM DB2]
GROUP BY clause with      [See inner joins]
GROUPING      [See filtering rows joins sorting
grouping column      2nd 3rd
grouping columns      [See constraints]
grouping items by compared values in category      [See subqueries]
grouping rows      2nd 3rd 4th 5th 6th 7th
grouping rows with      2nd 3rd 4th 5th 6th 7th
groups      
groups with HAVING clause      2nd 3rd
handling data type conversions      [See IBM DB2]
handling duplicates      2nd 3rd
HAVING clause      
HAVING clause with      [See inner joins]
help      
holding in temporary tables      [See also correlated subqueries simple
holding subqueries in      
Hosts      
IBM DB2      [See IBM DB2]
Identifiers      2nd
identifiers in      2nd
identifying current user      [See IBM DB2]
illustrated      
imitating GROUP BY clause with      [See subqueries]
implicit and explicit conversions      
importing CSV files as      [See joins views]
importing CSV files as table      
improper WHERE syntax with      
IN
IN condition      2nd 3rd 4th
in GROUP BY query      
in keyword      2nd 3rd 4th 5th 6th 7th
IN operators      
in SQL Server      [See subqueries]
in subqueries      
including all publishers      
including in DELETE statements      
including ORDER BY with      
including with GROUP BY clauses      
Indexes      2nd 3rd 4th 5th 6th 7th 8th
indexes and      2nd
indexes for      [See joins views]
inner and outer      [See subqueries]
inner and outer queries for listing objects      [See also correlated subqueries simple
INNER JOIN clause      
inner join listing with      
inner joins      
inner joins and      2nd [See also inner joins]
inner joins in      2nd 3rd 4th 5th 6th
inner joins with      2nd
inner joins with three or more      [See joins views]
inner joins with three or more tables      
inner queries      [See natural joins]
Insert      [See subqueries]
INSERT statements      [See IBM DB2]
inserting DEFAULT values      2nd 3rd 4th
inserting row by column name      2nd
inserting rows by name of      [See constraints]
inserting rows into table      2nd 3rd
inserting rows with      
inserting with INSERT      [See filtering rows joins sorting
Instances      
Integers      
interactive and script modes      
interactive mode      
INTERSECT operations      
INTERSECT support by      [See IBM DB2]
INTERSECT vs      2nd
interval types      2nd
interval types and      
interval types and conformance      [See IBM DB2]
Intervals      
IS NOT NULL condition      2nd 3rd
IS NULL condition      2nd 3rd
isolating single field of      2nd
Isolation      
Join      
Join clause      
JOIN syntax for outer joins      
joined columns and compatible      2nd
joining      [See joins views]
joining three tables with INNER JOIN      
joining three tables with INNER JOIN clause      [See subqueries]
joining two tables on      [See constraints]
joining two tables on columns      
joining values in two      [See constraints]
joining values in two columns      [See inner joins]
Joins      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 45th 46th 47th 48th 49th 50th 51st 52nd 53rd 54th 55th 56th 57th 58th 59th 60th 61st
joins and      
joins vs      2nd 3rd 4th 5th 6th [See also correlated subqueries simple
joins vs. subqueries with      [See constraints]
joins with      [See constraints]
joins with JOIN vs      2nd 3rd
joins with WHERE or JOIN clauses      
joins with WHERE vs      2nd 3rd
junction tables      [See also INNER JOIN clause JOIN OUTER
keywords      
1 2 3 4 5
blank
Реклама
blank
blank
HR
@Mail.ru
       © Электронная библиотека попечительского совета мехмата МГУ, 2004-2024
Электронная библиотека мехмата МГУ | Valid HTML 4.01! | Valid CSS! О проекте