Cumming A., Russell G. — SQL Hacks :: Электронная библиотека попечительского совета мехмата МГУ

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

Авторизация

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

Cumming A., Russell G. — SQL Hacks

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

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

Название: SQL Hacks

Авторы: Cumming A., Russell G.

Аннотация:

SQL is the cornerstone of database programming and this book provides 100 hacks that push the limits of traditional SQL, from fun stuff like solving crosswords with SQL to hardcore data wrangling. Written by the author of "A Gentle Introduction to SQL" (sqlzoo.net), it covers the most popular databases: Access, SQL Server, Oracle, MySQL, and PostgreSQL.

Язык:

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

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

ed2k: ed2k stats

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

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

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

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

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

strings
strings command (Unix)
stylesheet (gross.xsl)
stylesheets, XSLT
subqueries
SUBSTITUTE function, escaping single quotes
SUBSTR function
SUBSTR function (Oracle)      2nd
substring function
SUBSTRING_INDEX function
subtotals and values, getting in one query
subtracting to get days between
Sum function
support for SQL92 standard
suppressing >1 prompt
surrogate keys
survey results
SVG (scalable vector graphics), generating from SQL
SVG pie chart created directly from SQL
switches
switches, command line
SYS_GUID( ) function
SYS_GUID( ) function (Oracle)
table comparison and
table comparison script
Tables
tag clouds, calculating
tallying survey results into a chart
tax (progressive), applying
temp space, running out of
Temporary
temporary space
temporary table
temporary table, creating
temporary tables
temporary variables
testing against two-column subquery
testing if table exists before executing
testing INSERT transaction
testing the connection
testing two values from a subquery
testKey function
text, searching for keywords without LIKE
Tidy program
ties
ties (in top n queries)
Time      [See also dates]
time zone, getting in Oracle
TIMESTAMP datatype      2nd
Timestamps
too many files
TOP function (SQL Server)
top keyword
top n query
top n rows in each group
TOP n \
TO_CHAR function (Oracle)      2nd 3rd 4th
TO_DATE function (Oracle)
TO_DAYS function (MySQL)
transaction isolation
transaction isolation level
transaction isolation level, querying
Transactions
transposition errors, finding
transposition errors, finding in numbers
traversing a simple tree
tree visualization
tree, implementing and querying
trends, uncovering in data
Triggers
TRUE and FALSE values
TRUE and FALSE values, Access
Tsearch2 module (PostgreSQL)
tunneling into from Access
tunneling into MySQL
tunneling into MySQL from Access
tunneling into other databases
turning derived table into
types of
uncovering trends in data
ungrouping data with repeated columns
Unicode
union-compatible result sets
unions      2nd
unique identifier
unique identifiers
unique sequential number generation
unique sequential numbers, generating
Universally Unique Identifier (UUID)
UNIX
UPDATE statement
UPDATE statements
UPDATE triggers
updates
updating in MySQL
used in INSERT statement
user accounts
user creation form
user interface controls
user permissions, setting on columns and rows

user permissions, setting on rows
user, setting on rows and columns
user-supplied date values converted to date literals
userid
Usernames
users and administrators, creating
using a large buffer
using as server-side script for AJAX applications
using big buffer for queries returning many rows
using BLOBs
using for complicated UPDATEs
using in CROSS JOIN
using instead of string concatenations
using optimistic locking
using OVER clause with
using pessimistic locking
using SELECT instead of VALUES construct
using self-join
using series of round trips
using to preprocess SQL
using variable binding
using with CASE
using with complicated UPDATEs
using with LEFT OUTER JOIN
using with SUM
UUID
UUID (Universally Unique Identifier)
UUID function
Validation
values (infrequently changing), keeping track of
values and subtotal, getting
values and subtotals, getting in one query
VALUES list (INSERT ... VALUES)
VARBINARY datatype
VARBINARY datatype (SQL Server)
VARCHAR datatype
varchar size
variable binding
Variables
vendor-specific XML features
version number
version number of database system
Versions
versions, SQL conventions and
viewing hidden variables and cookies
views
Visual Basic
Web Data Administrator (SQL Server)
web interface to SQL
web log format, controlling      2nd
web page converted to
web pages (badly formed), cleaning up with Tidy
web server log files
web site for this book
Web-based applications
web-based interfaace
web-based interface
web-based interfaces
web-based SQL interface
web-based SQL interfaces
Webalizer
Webalizer DNS cache, accessing
Webalizer tool, using
WebSQL Console (SQL Server)
WHERE clause
whn (columns with a DATE type)
widespread support among database systems
Wikipedia
Wildcard
wildcard character
Wildcards
Windows
with a condition
WITH ROLLUP clause
wizards (Access)
words table, creating
working without
Xalan
Xalan utility
XHTML, translating into SQL
XML features
XML, vendor-specific features
xmllint
XPath expressions
XSLT
XSLT processing
XSLT processor and stylesheet
XSLT stylesheet (gross.xsl)
XSLT transformation
XSLT transformation of web page to SQL
XSLT transformation of web page to SQL, Mac OS X
xsltproc utility
Year function      2nd
year-to-date totals
year-to-date totals, reporting
\      2nd 3rd
\Q \Q(back quotes) for spaces in table and column names
\\ (backslash)
_ (underscore)
|| (string concatenation) operator      2nd 3rd 4th

1 2 3 4

О проекте