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

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

blank
blank
blank
Красота
blank
Beaulieu A. — Learning SQL
Beaulieu A. — Learning SQL



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



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


Название: Learning SQL

Автор: Beaulieu A.

Аннотация:

SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. If you're working with a relational database — whether you're writing applications, performing administrative tasks, or generating reports — you need to know how to interact with your data. Even if you are using a tool that generates SQL for you, such as a reporting tool, there may still be cases where you need to bypass the automatic generation feature and write your own SQL statements.

To help you attain this fundamental SQL knowledge, look to Learning SQL, an introductory guide to SQL, designed primarily for developers just cutting their teeth on the language.

Learning SQL moves you quickly through the basics and then on to some of the more commonly used advanced features. Among the topics discussed:

The history of the computerized database

SQL Data Statements — those used to create, manipulate, and retrieve data stored in your database; example statements include select, update, insert, and delete

SQL Schema Statements — those used to create database objects, such as tables, indexes, and constraints

How data sets can interact with queries

The importance of subqueries

Data conversion and manipulation via SQL's built-in functions

How conditional logic can be used in Data Statements

Best of all, Learning SQL talks to you in a real-world manner, discussing various platform differences that you're likely to encounter and offering a series of chapter exercises that walk you through the learning process. Whenever possible, the book sticks to the features included in the ANSI SQL standards. This means you'll be able to apply what you learn to any of several different databases; the book covers MySQL, Microsoft SQL Server, and Oracle Database, but the features and syntax should apply just as well (perhaps with some tweaking) to IBM DB2, Sybase Adaptive Server, and PostgreSQL.

Put the power and flexibility of SQL to work. With Learning SQL you can master this important skill and know that the SQL statements you write are indeed correct.


Язык: en

Рубрика: Руководства по программному обеспечению/

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

ed2k: ed2k stats

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

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

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

Операции: Положить на полку | Скопировать ссылку для форума | Скопировать ID
blank
Предметный указатель
' (single quotes)      
( ) (parentheses), condition evaluation      
+ (concatenation) operator      
ACCESS      
access, databases      
access, transactions      
administration, databases      
advanced SQL      
Aggregate functions      
aggregate functions, count( )      
aggregate functions, count(*)      
aggregation, selective      
Aliases
aliases, columns, inserting
aliases, tables, defining
all operator      
ANSI (American National Standards Institute)      
ANSI, join syntax      
any operator      
applying      
applying, indexes      
applying, mysql command-line tool      
applying, not operator
applying, regular expressions
applying, rules      
applying, sets      
applying, sets, operators      
applying, string data      
applying, subqueries      2nd
applying, subqueries, as tables      
applying, temporal data      
applying, wildcards      
Archive storage engine      
Arguments      
arguments, greater than zero
arguments, single-argument numeric functions      
arguments, truncate( ) function      
arithmetic operators
ascending sort orders
atomic clocks
attaching check constraints
auto-increment feature, starting      
autocommit mode
B-tree indexes      
bank schema      
BDB storage engine
BETWEEN operator      
bitmap indexes      
Branch nodes      
bridges      
Building      
building, conditions      
building, multicolumn indexes      
building, schema statements
building, strings character by character
built-in functions      
built-in functions, numeric      
built-in functions, select statements
built-in functions, strings
Cartesian products
Cartesian products, cross joins      
Cascading
cascading, constraints      
cascading, updates      
case expression      
cast( ) function      2nd
ceil( ) function      
CHAR data type      
char( ) function      
Characters      
characters, data types      
characters, data types, applying strings      
characters, data types, CHAR      
characters, data types, CLOB      
characters, data types, Text      
characters, data types, Varchar
characters, special, formatting      
characters, wildcards      
CHECK constraints      2nd
checking for existence      
classes, statements
clauses      
clauses, into outfile      
clauses, LIMIT      
clauses, ORDER BY
clauses, queries      
clauses, queries, from
clauses, queries, group by      
clauses, queries, having
clauses, queries, issuing without
clauses, queries, order by      
clauses, queries, where
clauses, select (aggregate functions)
clauses, where (group filter conditions)
CLOB data type
clocks, configuring time zones
Codd, Dr. E. F.      2nd
collation      
Columns      2nd
columns, aliases, inserting      
columns, characters, defining      
columns, check constraints
columns, constraints      
columns, datetime, populating
columns, indexes, inserting
columns, multicolumn
columns, multicolumn, grouping      
columns, multicolumn, indexes      
columns, multicolumn, subqueries      
columns, natural joins      
columns, null      
columns, populating
columns, signed data      
columns, single-column      
columns, single-column, grouping      
columns, single-column, subqueries      
columns, temporal data types
columns, values, troubleshooting
combining      
combining, insert/update statements      
combining, limit clauses/order by clauses
combining, multiple tables
command-line tools, mysql      2nd
Commands      
commands, commit      2nd
commands, replace, replacing      
commands, rollback      2nd
commands, show index
commit command      2nd
components      
components, date formats      
components, dates      2nd
compound keys
compound queries
compound queries, set operation rules
concat( ) function      2nd
concatenation operator (+)
conditional logic      
conditional logic, case expression
conditional updates
conditions
conditions, building      
conditions, equality      
conditions, evaluating
conditions, filters
conditions, group filter      
conditions, joins, comparing to filter conditions
conditions, subqueries in filter
conditions, types of
Configuration Wizard, starting      
Configuring
configuring, default character sets
configuring, MySQL databases      
Constraints
constraints, cascading      
constraints, check      
constraints, creating
constraints, foreign keys      
constraints, generating      
constraints, indexes      
constraints, primary keys      
containing query references
containing statements
controlling number precision      
Conversions
conversions, functions
conversions, invalid dates      
conversions, string-to-date      
conversions, values
convert_tz( ) function
Coordinated Universal Time (UTC)      
correlated subqueries      2nd
count( ) function
count(*) function      
counting distinct values      
CREATE TABLE statements
cross joins
data dictionaries      
data sources, subqueries as      
data statements
Data types
data types, characters      
data types, characters, applying strings
data types, characters, CHAR
data types, characters, CLOB
data types, characters, Text
data types, characters, Varchar
data types, numeric data
data types, termporal data      
data-feed generation      
databases      
databases, Access
databases, administration      
databases, constraints      
databases, design      
databases, ER diagrams      
databases, indexes
databases, languages
databases, managing      
databases, multiuser      
databases, MySQL      2nd
databases, natural joins
databases, nonrelational systems      
databases, programming      
databases, relational models      
databases, terminology      
databases, transactions      
databases, tuning      
DateDiff( ) function      
Dates
dates, components      2nd
dates, formatting      
dates, generating      
dates, invalid conversions      
dates, returning      
dates, string-to-date conversions      
datetime columns, populating
date_add( ) function      2nd
Daylight Savings Time
deadlocks
decimal points (numeric data types)      
default character sets, defining
Defining
defining, character columns
defining, null      
defining, query joins      
defining, table aliases
deleting
deleting, duplicates
deleting, indexes      
deleting, multitables      
deleting, ordered      
deleting, table data
descending sort orders      
Design      
design, databases
design, tables      
diagrams (ER)      
Dictionaries      
distinct keyword      
distinct values, counting
division by zero errors
duplicates
duplicates, rows, deleting      
duplicates, union operators      
embedded quotes
ending transactions      
English character sets      
Entities      
entity-relationship (ER) diagrams
equality conditions
equi-joins      
ER (entity-relationship) diagrams      
Errors      
errors, cascading constraints      
errors, division by zero      
escaping strings      
evaluating conditions
except operations
EXCEPT operator
executing      
executing, conditional logic      
executing, conditional logic, case expression
executing, queries
executing, transactions      
exercises, solutions to
existence, checking for
EXISTS operator      
explicit groups      
Expressions
expressions, aggregate functions
expressions, case
expressions, conditions, building
expressions, grouping      
expressions, regular, applying
expressions, searching
expressions, select statements
expressions, sorting
expressions, subqueries as generators
extensions, select statements
extract( ) function
fabrication, tables      2nd
Filtering
filtering, conditions
filtering, conditions, building
filtering, conditions, comparing to join conditions
filtering, conditions, evaluating
filtering, conditions, subqueries      
filtering, conditions, types of      
filtering, groups      2nd
filtering, null
floating-point number precision      
floating-point types
floor( ) function
foreign keys      2nd
foreign keys, constraints      2nd
foreign keys, ER diagrams
foreign keys, nonexistent
foreign keys, self-referencing
Formatting
1 2 3 4
blank
Реклама
blank
blank
HR
@Mail.ru
       © Электронная библиотека попечительского совета мехмата МГУ, 2004-2025
Электронная библиотека мехмата МГУ | Valid HTML 4.01! | Valid CSS! О проекте