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

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

" (quotes, double)
# (pound sign), indicating temporary table in SQL Server
% (percent sign)
& (ampersand)
' (apostrophe), escaping in SQL
' (quotes, single)
' OR ''=' and SQL injection attacks
(semicolon)
* (asterisk)
* (asterisk) wildcard      2nd
+ (string concatenation) operator      2nd 3rd
.mdb files
.NET Framework
404 errors
< (redirection) operator
? (question mark)
@ (at sign)
@ command
aborted transactions
abs( ) function
ACCESS
Access table definition
accessing SQL database
accessing with SQL injection
across the Internet
adding navigation features
adding/removing files
Administrator accounts
Adobe SVG plug-in
ADOdb
Advantages
advantages and limitations
aggregate subqueries, converting to JOINs
aggregate, converting to JOINs
aggregating
aggregating functions
AJAX applications, using SQL web-based interface
Aliases
alphabetical data in columns
ALTER command      2nd
ALTER SESSION (Oracle)
altering while preserving existing data
ancestral tree, implementing and querying
anonymous access
anonymous accounts
ANSI standard
ANSI syntax
Apache
Apache web server logs
append operator
append operator (&)
appending data to the end of files
application-level
application-level user accounts
applications
arc, calculating length of
arithmetic, dates
AS keyword
asking for strings
asking yes/no questions
assigning list of variables in single statement
asterisk (*) wildcard, using
attaching unique identifier to each transaction
audit trail, creating
Auditing
auditing features
Authentication
Auto-Numbering
autocommit (chained mode), turning off
autocommit, turning off
autocommit, turning off for transactions
automatic, issuing
avoiding constraints
avoiding division by zero
avoiding overreaction
badly formed web page
batch updates
Binary data
bind variable (placeholder)
bind variables
Binding variables
BLOBs (binary large objects)
BLOBs, creating and retrieving data from
branch transactions
breaking data down into ranges
building decision tables
C#
Caching
calculating a running total
calculating for three fields
calculating for two fields
calculating maximum of two fields
calculating minimum of two values
calculating rank
calculations (repeated), avoiding
calendar
calendar view of important dates
calendar, generating
camel case
canonical date format
capitalization
CASE
case sensitivity
Case statement
Case-sensitivity
CAST function
CAST keyword
casting dates to strings, MySQL and PostgreSQL
casting to strings
central server update
CGI parameters
chain (JOINs)
chain pattern JOINs
chained mode (autocommit in PostgreSQL)
changing existing files
changing to OUTER JOINs
character varying (PostgreSQL)
checking for broken links
checking if table exists before issuing DROP TABLE
choosing any three of five
choosing for number sequence
choosing primary key
choosing right style for relationships
cleaning up Unicode output
cleaning up Unicode output from msxsl.exe
click-through ratio (CTR)
clocks using epoch time
clocks, relying on database clock
COALESCE function
code examples in this book, using
collisions in password hashes
column
column aliases
column name (whn)
Columns
combinations, generating
combining
combining queries
combining tables with different data
combo box from a table
combo box from a table (Access)
comma-delimited lists
comma-delimited lists in a column
command line
command prompt editor (sqlcmd)
command-line switches
command-line utility
command-line utility (psql)
commit command
comparing

comparing tables
compressing to avoid LOBs
compression, using to avoid LOBs
compression/decompression script
CONCAT function (MySQL)      2nd 3rd
concatenate operator      [See + and || under
concatenating      2nd
concatenating strings      [See strings concatenating]
concatentating
concurrency issues
concurrency issues (transactions)
conditional INSERTs
CONNECT BY clause
connecting to from a program
connecting to from Access
connecting to SQL database from program
connecting to SQLEXPRESS instance from C# program
Connector/J driver (JDBC driver)
containing different data, combining
conventions for different databases
CONVERT function (SQL Server)
converting aggregate subqueries to
converting dates to
converting dates to in SQL Server
converting logfile lines into SQL INSERT statements
converting numbers to strings and concatenating with +
converting strings to
converting subqueries to
converting to dates
converting to integers
converting to JOINs
converting to strings
converting to VIEWs
converting web page to SQL statements
Cookies
coping with unexpected redo
copy of the data (outdated), returned for transaction
copying tables
copying web pages into a table
correlated
correlated derived table
correlated subquery
cos function
COUNT function
Counting
covering index
Create command
CREATE script for tables, keeping
CREATE script, storing for each table
CREATE script, storing for tables
Creating
creating audit trail
creating BLOBs and retrieving data from
creating database accounts for shell accounts
creating for complicated UPDATEs
creating list of
creating permanent audit trail
creating permanent log
creating secure tunnel
Creating tables
creating words table
cross joins      2nd
crossword puzzle, solving using SQL
csc.exe (C# compiler)
CTR (click-through ratio)
CURRENT DATE
current month
current month, reporting on
current timestamp
current username
current_date
CURRENT_TIMESTAMP      2nd 3rd
CURRENT_USER information
Cursor
custom ranges
custom ranges of any size
Data Definition Language (DDL)
data for consecutive dates, generating
database connections
database functions for
Database systems
databases
date literals
date literals in SQL Server
Date type
DATEADD function (SQL Server)      2nd 3rd 4th
DATEDIFF function (SQL Server)
DatePart function (Access)
DATEPART function (SQL Server)      2nd 3rd
Dates      2nd
dates (user supplied), converting to date literals
dates, parsing in Oracle
dateTime datatype      2nd
day-of-the week
day-of-the-week
day-of-the-week functions
DAYOFWEEK function
DAYOFWEEK function (MySQL)
DB2
db2batch utility
DBI interface
DBI interface (Perl)
DBMS_CRYPTO library (Oracle)
DB_File Perl module
DDL (Data Definition Language)
decision tables, building
Defining
defining to create indexed column
DELETE triggers
denormalization
denormalizing
denormalizing data
deploying
deploying applications
derived table
derived tables
deterministic hashes
diff command
diff command (Unix)
differences between tables, finding
differences in handling
directory structure
dirty reads
disadvantages
disaggregating a COUNT
disaggregating result
disk space, avoiding running out of
disk space, managing
displaying as columns
displaying as rows
displaying columns as
displaying ranges
displaying ranges by building a string
displaying rows as
displaying rows as columns
distance between GPS locations, calculation
Division
DNS cache
DNS cache (Webalizer)
DROP avoiding constraints
DROP TABLE command
dropping FROM clause
dropping FROM clause of SELECT statement
dropping from SELECT statement
duplicate batches
duplicate batches, handling
easypass generator tool
easypass tool
eliminating subqueries by using
email address as

1 2 3 4

О проекте