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

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

MySQL
MySQL connector
MySQL differences
MySQL ODBC connector
Mysqldump
mysql_ functions
Names
names (column and table), spaces in
namespace management
navigation features for web application
navigation features for web applications
nested, applying progressive tax
network connection concepts
NEWID( )      2nd
NewId( ) function
nonrepeatable reads
nonstandard, problems switching database platforms
nonstring data
nonstring data, checking format
normalizing the data
NOT IN subquery      2nd
NULL values
NULLIF function
Numbers
numbers 0-99
numbers sorted as
numbers table      [See integers table]
numerical keys, table comparisons and
obtaining
ODBC
ODBC driver
ODBC/JDBC bridge
OFFSET instruction
OID datatype
OID datatype (PostgreSQL)
old copy of data, returned for transaction
ON clause
on indexed columns
one-row tables
one-to-many JOIN producing excess repetition in result set
one-to-many relationship
one-to-many relationships, finding specific rows on many side
one-to-many, producing excess repetition in result set
one-to-one relationship
one-way hashes
online applications      [See web-based applications]
opening files in append mode
Operating systems
optimistic locking
optimizer behavior, changing with ALTER SESSION
optimizer hint returning subset of results
optimizer hints, returning subset of results
Oracle
Oracle recursive extensions
ordered
orders with postage rules
outer joins
output from msxsl.exe, cleaning up
OVER clause used with aggregate function
OVER clause used with SUM
overlapping ranges, identifying
overlapping, identifying
page rank calculations
parameterized report
Parameters
parameters, query
Parsing
partial index matching
Passwords
pattern-matching
Performance
performance and
Perl
PERMISSIONS
personalized
personalized parameters
personalized parameters, defining
pessimistic locking
pg_dump command
phantom reads
PHP
phpBB program, sharing namespaces
phpMyAdmin      2nd
phpPgAdmin
Pipes
piping output to
piping sequence of to SQL command-line utility
pivot table, filling in missing values with SQL
pivot tables, filling in missing values
placeholder examples
Placeholders
placeholders in C#
Plink (SSH client)
plpgsql language      2nd
pnm library
pop-up list from a table
Portability
portability, database applications
PostgreSQL
PostgreSQL, day-of-the-week
potential problems
precision, reducing for report data
preventing from running
preventing or minimizing consequences
preventing with placeholders
primary keys
prioritized
prioritized decision tables
problems switching datbase platforms
problems with
Processing
processing web server logs
processors, XSLT
profiles (Oracle)
Programming languages
progressive tax, applying
providing missing data with OUTER JOIN
providing missing report data
psql slash commands
Public role
PuTTY web site
Pythagorean Theorem      2nd
quadratic time, SQL calculations
QUARTER function
Quarterly Reports
quarterly reports, generating
Queries
queries returning large result set
queries returning many rows
Query Builder interface (Access)
query caching
query parameters
querying
questions and injection phrases
questions and their injection phrase
queuing in database
queuing in database, setting up
RAD (rapid application development) tools
radians, converting GPS coordinates to
Random
Random numbers
range of dates for period of days up to a year
ranges
RANK( ) function
rank, calculating
rank, page rank calculations
READ COMMITTED isolation level      2nd
READ UNCOMMITTED isolation level
reconciling invoices and remittances
recorded in plain text

recording price changes
recursive extensions
recursive extensions (Oracle)
redirection operator (<)
reducing precision in report data
reducing precision of
reducing precision of dates
reducing precision of numbers
Regular expressions
relationships between
relying on database clock
remittances, reconciling with invoices
REPEAT function
REPEAT function (MySQL)
repeatable
REPEATABLE READ isolation level
repeating same calculation, avoiding
Replace function
REPLACE function vs. || operator
replacing a table with
replacing GO instructions in SQL Server
replacing spaces in table and column names
replacing with a VIEW
REPLICATE function
REPLICATE function (SQL Server)
Report Wizard (Access)
reporting on any date criteria
reporting on current month
reports
representing seconds since epoch
restricting SQL account rights
result sets
result weighting
Results page
returning many rows
returning smallest value given
REVOKE command
RGB values
right outer joins
robot spiders, filtering from web server logs
rollback command
ROUND function
Rounding      2nd
Rounding errors
rounding numbers
ROWNUM pseudovariable      2nd 3rd 4th
ROWNUM pseudovariable (Oracle)      2nd 3rd 4th
Rows
rows and columns
Ruby
running from command line
running from Windows
running PHP
running SQL
running SQL from
running SQL from a web page
running the hack
running total, keeping
saving as named VIEW
Scalable Vector Graphics      [See SVG generating
schema, dropping
search results, alphabetic
searching for keywords without using
searching for specific rows on the many side
searching for, without using LIKE
second Tuesday of the month
second Tuesday of the month, finding
second Tuesday, finding
secure tunnel, creating on Windows
Security
SELECT * FROM t
SELECT statement
SELECT statement, dropping FROM clause
SELECT statement, using other SELECT statements
self-joins
separating statements
SEQUENCE (Oracle and PostgreSQL)
sequence of days up to a year
sequence table      [See integers table]
Sequential data
sequential data, generating
sequential numbers (unique), generating
sequential, generating
SERIALIZABLE isolation level      2nd 3rd
setting width for display with sqlplus
sharing data
shell accounts
shopping baskets, coping with unexpected redo
shopping-basket, coping with unexpected redo
show tables command (mysql)
simplifying complicated
simplifying queries that use self-joins on
simplying queries that use
sin function
single-row table (dual table)
single-row tables
Six Degrees of Kevin Bacon
six degrees of Kevin Bacon game
skipped in a count
slash commands (psql)
snapshot, table
solving a crossword puzzle
solving crossword puzzle using SQL
source command (mysql)
source data for Excel pivot tables
spaces in table and column names
specifying with command-line switch
specifying with command-line switches
spreadsheet applications      [See also Excel]
SQL
SQL calculations
SQL conventions
SQL conventions in this book
SQL conventions, variations in
SQL files imported into Oracle
SQL injection attack, preventing
SQL injection attacks
SQL injection attacks based on
SQL Server
SQL Server and Windows
SQL standard, dates
SQL statements
SQL*Plus (command-line interface)
SQL92 standard
SQL92 standard and
SQLCMD
sqlplus program
SSH tunnel, creating
SSH, creating secure tunnel on Windows
standard, listed
star (JOINs)      2nd
star JOIN example
star patttern JOINs
starting connection using Visual Basic
starting secure tunnel from Access
starting tunnel with Visual Basic
statement separators
static
static functions
steps in process
stopping the tunnel
storing data
storing images in database
storing images in files
storing in database
storing in files
storing user information
STR function (SQL Server)
strength of
String concatenation

1 2 3 4

О проекте