Справочник по SQL

http://darkraha.com/rus/sql/index.php

http://www.w3schools.com/sql/default.asp

SQL Задачи и решения Учебник. Сергей Моисеенко.

Интерактивный учебник по SQL

Введение................................................................................................................................................................. 33

DDL (Data Definition Language).......................................................................................................................... 3

DML (Data Manipulation Language)..................................................................................................................... 3

прочие команды................................................................................................................................................... 4

Структура базы данных........................................................................................................................................... 4

ключи, ограничения............................................................................................................................................. 4

индексы................................................................................................................................................................. 5

представления....................................................................................................................................................... 5

процедуры и функции......................................................................................................................................... 5

триггеры................................................................................................................................................................ 5

схема...................................................................................................................................................................... 5

пользователи и сессии......................................................................................................................................... 6

Инструментарий....................................................................................................................................................... 6

скачать СУБД........................................................................................................................................................ 6

инсталляция.......................................................................................................................................................... 6

выполнение запросов.......................................................................................................................................... 6

использование примеров..................................................................................................................................... 7

Комментарий............................................................................................................................................................ 7

Идентификаторы...................................................................................................................................................... 7

Обзор типов данных................................................................................................................................................ 8

Интервал времени.................................................................................................................................................... 8

Oracle..................................................................................................................................................................... 9

PostgreSQL............................................................................................................................................................ 9

MySQL................................................................................................................................................................. 10

Литералы................................................................................................................................................................. 10

Выражения и операции......................................................................................................................................... 11

cтроковые операции.......................................................................................................................................... 11

алгебраические операции.................................................................................................................................. 11

операции отношения......................................................................................................................................... 12

логические операции и предикаты.................................................................................................................. 12

условные выражения......................................................................................................................................... 12

прочие операции................................................................................................................................................ 13

Обзор функций....................................................................................................................................................... 13

математические функции.................................................................................................................................. 13

строковые функции........................................................................................................................................... 14

работа с датами................................................................................................................................................... 14

Преобразование типов........................................................................................................................................... 15

функции Oracle................................................................................................................................................... 16

функции PostgreSQL.......................................................................................................................................... 17

функции MySQL................................................................................................................................................ 17

Создание таблицы.................................................................................................................................................. 18

значения полей по умолчанию......................................................................................................................... 18

ключи и ограничения........................................................................................................................................ 18

настройка внешнего ключа............................................................................................................................... 19

создание по выборке.......................................................................................................................................... 19

дополнительные параметры таблицы.............................................................................................................. 19

Изменение, удаление таблицы............................................................................................................................. 20

переименование таблицы или ее столбца....................................................................................................... 20

добавление/удаление столбца........................................................................................................................... 20

первичный ключ................................................................................................................................................ 20

уникальный ключ............................................................................................................................................... 20

внешний ключ.................................................................................................................................................... 21

безошибочное удаление таблиц........................................................................................................................ 21

Добавление записей............................................................................................................................................... 21

значения по умолчанию.................................................................................................................................... 22

подзапросы.......................................................................................................................................................... 22

вставка по условию............................................................................................................................................ 22

Обновление записей.............................................................................................................................................. 22

обновление подзапросом................................................................................................................................... 23

обновление по данным другой таблицы......................................................................................................... 23

Удаление записей................................................................................................................................................... 24

Выборка записей.................................................................................................................................................... 24

выборка констант............................................................................................................................................... 25

выборка по столбцам таблиц............................................................................................................................ 25

синонимы (алиасы)............................................................................................................................................ 25

уникальные записи............................................................................................................................................ 26

выборка по условию.......................................................................................................................................... 26

выборка по группам........................................................................................................................................... 27

Соединения............................................................................................................................................................. 27

Агрегатные функции, группировка данных....................................................................................................... 29

Операции над выборками..................................................................................................................................... 30

Добавление итогов................................................................................................................................................. 31

Нумерация записей................................................................................................................................................ 32

Oracle................................................................................................................................................................... 32

MySQL................................................................................................................................................................. 32

PostgreSQL.......................................................................................................................................................... 33

Обеспечение уникальности первичного ключа................................................................................................. 33

столбцы с автоинкрементом............................................................................................................................. 34

Индексы.................................................................................................................................................................. 34

Представления........................................................................................................................................................ 35

Динамический SQL (DSQL)................................................................................................................................. 36

Процедурные операторы....................................................................................................................................... 36

блоковая структура кода.................................................................................................................................... 36

присвоение.......................................................................................................................................................... 37

условный оператор............................................................................................................................................ 37

оператор выбора................................................................................................................................................. 37

метки.................................................................................................................................................................... 38

безусловный цикл.............................................................................................................................................. 38

цикл с предусловием......................................................................................................................................... 38

цикл по счетчику................................................................................................................................................ 38

цикл по элементам............................................................................................................................................. 39

операторы выхода/продолжения итерации..................................................................................................... 39

Выборка в переменные.......................................................................................................................................... 40

Хранимые процедуры............................................................................................................................................ 40

Oracle................................................................................................................................................................... 40

PostgreSQL.......................................................................................................................................................... 41

MySQL................................................................................................................................................................. 41

вызов процедур.................................................................................................................................................. 42

Исключения............................................................................................................................................................ 42

Oracle................................................................................................................................................................... 42

PostgreSQL.......................................................................................................................................................... 42

MySQL................................................................................................................................................................. 43

Курсоры................................................................................................................................................................... 43

Oracle................................................................................................................................................................... 44

PostgreSQL.......................................................................................................................................................... 44

MySQL................................................................................................................................................................. 45

Триггеры................................................................................................................................................................. 45

Oracle................................................................................................................................................................... 46

PostgreSQL.......................................................................................................................................................... 46

MySQL................................................................................................................................................................. 47

Числа прописью..................................................................................................................................................... 47

Транзакции, конкурирующие запросы................................................................................................................ 50

Схема....................................................................................................................................................................... 51

PostgreSQL.......................................................................................................................................................... 52

Oracle................................................................................................................................................................... 52

MySQL................................................................................................................................................................. 52

Управление аккаунтами........................................................................................................................................ 53

пользователи....................................................................................................................................................... 53

права доступа...................................................................................................................................................... 53

права доступа MySQL....................................................................................................................................... 54

права доступа PostgreSQL................................................................................................................................. 55

права доступа Oracle.......................................................................................................................................... 55

удаление прав доступа....................................................................................................................................... 56

роли...................................................................................................................................................................... 56

роли PostgreSQL................................................................................................................................................. 56

роли Oracle.......................................................................................................................................................... 57

роли MySQL....................................................................................................................................................... 57

Файловый вывод/ввод........................................................................................................................................... 57

Oracle................................................................................................................................................................... 57

MySQL................................................................................................................................................................. 58

PostgreSQL.......................................................................................................................................................... 58

Информация о базе данных................................................................................................................................... 59