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

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

email addresses as usernames
email-based username
email-based usernames
emulating OFFSET instruction
enforcing
ENGINE=InnoDB
epoch time
Erdos numbers
errors caused by unrecognized date formats
escaping
escaping in C#
escaping in Java
escaping in Perl
escaping in PHP
escaping special characters      2nd
escaping special characters in strings
examples in different languages
Excel
excess repetition produced by one-to-many JOIN
exclusive matches
executing functions
executing functions in the database
executing in the database
executing Java
exp and imp utilities
exploiting SQL injection vulnerability
exploiting vulnerability
exporting and importing table definitions
exporting table definitions
Express edition (SQL Server)
Express edition, download site
EXTRACT and TO_DATE functions
extract function      2nd 3rd
extracting data from XHTML document
extracting subset
extracting subset of results
extracting subset of the results
FALSE and TRUE values, Access
family tree hierarchy
field size limits (HTML)
FIFO queuing in database
file and database storage, mixing
Files
filling in
filling in missing values in pivot table
Filtering
filtering on indexed columns
find command
finding all the files for an operation
finding and stopping long-running queries
finding current price
finding floating calendar date
finding floating calendar dates
finding maximum of three fields
finding middle row or rows
finding price on specified date
finding top n in each group
finding transposition errors
finding transposition errors in PostgreSQL
Firefox
fiscal year to date
fiscal year to date, reporting
floating calendar dates, finding
Floor function      2nd
FOR EACH ROW construct
for spaces in table and column names
for transactions
for updates
foreign key reference
foreign keys
Form Wizard (Access)
FROM clause
FROM clause, using other SELECT statements
FTP, anonymous sites
full outer joins      2nd
full text searching
full text searching with Tsearch2 module
FULLTEXT
FULLTEXT pattern match
FULLTEXT pattern match (MySQL)
FULLTEXT, MySQL
Functions
gaps in sequence
generating a calendar
generating alphabet with integers table
generating data for consecutive dates
generating data for each alphabet letter
generating rows without tables
generating sequence of dates
generating sequence using integers table
generating sequence with integers table
generating sequential or missing data
generating SVG images from SQL
generating the alphabet
generating unique sequential numbers
generating without tables
GETDATE( ) function (SQL Server)
getting in Oracle
getting metadata
getting strings
getting with SQL injection
Globally Unique Identifier (GUID)
GO instructions (SQL Server)      2nd
GPS locations, calculating distance between
GRAND TOTAL included in
GRANT and REVOKE commands
graphical reports from data imported directly from databases
graphing
GREATEST and LEAST functions
GREATEST function      2nd
gross.xsl (example)
GROUP BY solution
GROUP BY statement, choosing any three of five
grouping report data by
GROUPING SETS clause
GROUPING SETS clause (Oracle)
GUID (Globally Unique IDentifier)
gzip compression
handling in Unicode output
hardcoding postage cost rules
hash directory structure
Hashing
hashing algorithms
hashing passwords
Hidden variables
hidden variables and cookies
hidden, SQL injection attacks and
history tables
HTML fields, size limits on
HTML pop-up from a table
hung transactions
identifiers, unique
identifying uniquely
identifying uniquly
identifying updates uniquely
IDENTITY column (SQL Server)
IFNULL function
IFNULL function (MySQL)
IIS (Internet Information Services)
IIS web log format, controlling      2nd
Image
IMAGE datatype (SQL Server)      2nd
image filenames
image files
Images
imp utility
implemented incorrectly
implicit commits
implicit locks within transactions
importing directly from databases for graphical reports

importing external data
importing file of SQL commands into Access
importing SQL file
importing table definitions
improving with indexes
IN BOOLEAN MODE text-searching
IN BOOLEAN MODE text-searching (MySQL)
in JOIN conditions
in Perl
in PHP
in the programming language
in VALUES list
including rows left out of query output
inconsistent records, cleaning
Indexes
infrequently changing values, tracking
injecting to gather passwords
inner joins
InnoDB
InnoDB, specifying
Input document
INSERT ... SELECT
INSERT ... SELECT statement
INSERT ... VALUES statement
INSERT ALL statement
INSERT ALL statement (Oracle)
INSERT statement
INSERT TRIGGER
INSERTED table (SQL Server)
instance name (SQL Server)
Integers
integers table
Internet Movie Database (IMDb)
Internet, sharing data across
INTERVAL notation (Oracle)
into Access
into DB2
into MySQL, using command-line utility
into Oracle, using sqlplus
into PostgreSQL
into SQL Server
investigating user actions
invoices, reconciling with remittances
ISNULL function
ISNULL function (MySQL)
ISO standard date format
isolated transactions, ensuring in database updates
isolated, ensuring in database updates
isolation level
isolation level, transactions
iSQL*Plus (Oracle)
issuing queries without using table
issuing without using table
Java
Java Virtual Machine
javac (Java compiler)
JavaScript
JavaScript validation
JDBC driver for SQL databases
JOIN chain
JOIN chain example
JOIN keyword
JOIN on comma-delimited list
JOIN solution
JOIN star
JOIN syntax
Joins
joins and
JOINs on comma-delimited lists
keeping a running total
Kevin Bacon game
keys using, table comparisons and
keywords
killing the process
labels, adding to SVG pie chart
large data tables
Large Object Blocks      [See LOBs]
last Thursday of the month
last Thursday of the month, finding
last Thursday, finding
latitude, longitude, and altitude values (GPS)
LEAST function      2nd 3rd
left join      [See LEFT OUTER JOINs]
left outer joins      2nd
letters of the alphabet
LEVEL pseudovariable (Oracle)
libraries, database
LIKE operator
LIMIT instruction      2nd
LIMIT instruction (MySQL)      2nd
limiting number of rows returned
limiting queries
line continuation character (\\)
line continuation character)
Linux
linuxzoo web site
list of, obtaining with metadata query
listing all prices for specified date
listing for SQL Server with sqlcmd
listing in MySQL with command-line utility
LOBs (Large Object Blocks)
Locking
locking and
locking implicitly within
LOG function (SQL Server)
logarithms, adding for list of numbers
logging
long-running queries, finding and stopping
long-running, finding and stopping
LPAD function
Macintosh
Magnitude
making use of indexes
math
Maximum
maximum of three fields, calculating
MD5 algorithm
MD5 function
MD5 hash, generating with DBMS_CRYPTO library (Oracle 10g)
MD5 hashing
median, calculating
memory, buffered data from queries returning many rows
metadata, obtaining
Microsoft Access      [See Access]
Microsoft Search Engine
Microsoft SQL Server 2005
MID function (Access)
middle element(s), finding
minimizing bandwidth in one-to-many JOINs
minimizing clock and time zone discrepancies
Minimum
minimum of two values, calculating
mixing file and database storage
MOD function
MOD function (Oracle)      2nd
mod operator
Modular arithmetic
modulus operator
modulus operator (%)
MONTH and YEAR functions
Month function
MONTH, YEAR, and EXTRACT functions
monthly totals
monthly totals, reporting
months
moving databases between
msxsl.exe
multiplication across a result set
multiplying across a result set
multiuser considerations

1 2 3 4

О проекте