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

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

blank
blank
blank
Красота
blank
Cumming A., Russell G. — SQL Hacks
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.


Язык: en

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

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

ed2k: ed2k stats

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

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

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

Операции: Положить на полку | Скопировать ссылку для форума | Скопировать ID
blank
Предметный указатель
" (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
blank
Реклама
blank
blank
HR
@Mail.ru
       © Электронная библиотека попечительского совета мехмата МГУ, 2004-2020
Электронная библиотека мехмата МГУ | Valid HTML 4.01! | Valid CSS! О проекте