Справочник по языку SQL

Содержание

• Начало работы
  • Основы архитектуры
  • Создание базы данных
  • Доступ к базе данных
• Язык SQL
  • Введение
  • Концепции
  • Создание новой таблицы
  • Заполнение таблицы строками
  • Запрос к таблице
  • Объединения между таблицами
  • Агрегатные функции
  • Обновление строк таблицы
  • Удаление строк таблицы
• Команды SQL
  • ABORT
  • ALTER AGGREGATE
  • ALTER COLLATION
  • ALTER CONVERSION
  • ALTER DATABASE
  • ALTER DEFAULT PRIVILEGES
  • ALTER DOMAIN
  • ALTER EVENT TRIGGER
  • ALTER EXTENSION
  • ALTER FOREIGN DATA WRAPPER
  • ALTER FOREIGN TABLE
  • ALTER FUNCTION
  • ALTER GROUP
  • ALTER INDEX
  • ALTER LANGUAGE
  • ALTER LARGE OBJECT
  • ALTER MATERIALIZED VIEW
  • ALTER OPERATOR
  • ALTER OPERATOR CLASS
  • ALTER OPERATOR FAMILY
  • ALTER POLICY
  • ALTER PROCEDURE
  • ALTER PUBLICATION
  • ALTER ROLE
  • ALTER ROUTINE
  • ALTER RULE
  • ALTER SCHEMA
  • ALTER SEQUENCE
  • ALTER SERVER
  • ALTER STATISTICS
  • ALTER SUBSCRIPTION
  • ALTER SYSTEM
  • ALTER TABLE
  • ALTER TABLESPACE
  • ALTER TEXT SEARCH CONFIGURATION
  • ALTER TEXT SEARCH DICTIONARY
  • ALTER TEXT SEARCH PARSER
  • ALTER TEXT SEARCH TEMPLATE
  • ALTER TRIGGER
  • ALTER TYPE
  • ALTER USER
  • ALTER USER MAPPING
  • ALTER VIEW
  • ANALYZE
  • BEGIN
  • CALL
  • CHECKPOINT
  • CLOSE
  • CLUSTER
  • COMMENT
  • COMMIT
  • COMMIT PREPARED
  • COPY
  • CREATE ACCESS METHOD
  • CREATE AGGREGATE
  • CREATE CAST
  • CREATE COLLATION
  • CREATE CONVERSION
  • CREATE DATABASE
  • CREATE DOMAIN
  • CREATE EVENT TRIGGER
  • CREATE EXTENSION
  • CREATE FOREIGN DATA WRAPPER
  • CREATE FOREIGN TABLE
  • CREATE FUNCTION
  • CREATE GROUP
  • CREATE INDEX
  • CREATE LANGUAGE
  • CREATE MATERIALIZED VIEW
  • CREATE OPERATOR
  • CREATE OPERATOR CLASS
  • CREATE OPERATOR FAMILY
  • CREATE POLICY
  • CREATE PROCEDURE
  • CREATE PUBLICATION
  • CREATE ROLE
  • CREATE RULE
  • CREATE SCHEMA
  • CREATE SEQUENCE
  • CREATE SERVER
  • CREATE STATISTICS
  • CREATE SUBSCRIPTION
  • CREATE TABLE
  • CREATE TABLE AS
  • CREATE TABLESPACE
  • CREATE TEXT SEARCH CONFIGURATION
  • CREATE TEXT SEARCH DICTIONARY
  • CREATE TEXT SEARCH PARSER
  • CREATE TEXT SEARCH TEMPLATE
  • CREATE TRANSFORM
  • CREATE TRIGGER
  • CREATE TYPE
  • CREATE USER
  • CREATE USER MAPPING
  • CREATE VIEW
  • DEALLOCATE
  • DECLARE
  • DELETE
  • DISCARD
  • DO
  • DROP ACCESS METHOD
  • DROP AGGREGATE
  • DROP CAST
  • DROP COLLATION
  • DROP CONVERSION
  • DROP DATABASE
  • DROP DOMAIN
  • DROP EVENT TRIGGER
  • DROP EXTENSION
  • DROP FOREIGN DATA WRAPPER
  • DROP FOREIGN TABLE
  • DROP FUNCTION
  • DROP GROUP
  • DROP INDEX
  • DROP LANGUAGE
  • DROP MATERIALIZED VIEW
  • DROP OPERATOR
  • DROP OPERATOR CLASS
  • DROP OPERATOR FAMILY
  • DROP OWNED
  • DROP POLICY
  • DROP PROCEDURE
  • DROP PUBLICATION
  • DROP ROLE
  • DROP ROUTINE
  • DROP RULE
  • DROP SCHEMA
  • DROP SEQUENCE
  • DROP SERVER
  • DROP STATISTICS
  • DROP SUBSCRIPTION
  • DROP TABLE
  • DROP TABLESPACE
  • DROP TEXT SEARCH CONFIGURATION
  • DROP TEXT SEARCH DICTIONARY
  • DROP TEXT SEARCH PARSER
  • DROP TEXT SEARCH TEMPLATE
  • DROP TRANSFORM
  • DROP TRIGGER
  • DROP TYPE
  • DROP USER
  • DROP USER MAPPING
  • DROP VIEW
  • END
  • EXECUTE
  • EXPLAIN
  • FETCH
  • GRANT
  • IMPORT FOREIGN SCHEMA
  • INSERT
  • LISTEN
  • LOAD
  • LOCK
  • MERGE
  • MOVE
  • NOTIFY
  • PREPARE
  • PREPARE TRANSACTION
  • REASSIGN OWNED
  • REFRESH MATERIALIZED VIEW
  • REINDEX
  • RELEASE SAVEPOINT
  • RESET
  • REVOKE
  • ROLLBACK
  • ROLLBACK PREPARED
  • ROLLBACK TO SAVEPOINT
  • SAVEPOINT
  • SECURITY LABEL
  • SELECT
  • SELECT INTO
  • SET
  • SET CONSTRAINTS
  • SET ROLE
  • SET SESSION AUTHORIZATION
  • SET TRANSACTION
  • SHOW
  • START TRANSACTION
  • TRUNCATE
  • UNLISTEN
  • UPDATE
  • VACUUM
  • VALUES
• Ключевые слова SQL
• Соответствие стандарту SQL
  • Поддерживаемые возможности
  • Неподдерживаемые возможности
  • Ограничения XML и совместимость с SQL/XML