Автор и выходные данные не указаны. — W3 School (Www.w3schools.com). — 105 p.
SQL is a standard language for storing, manipulating and retrieving data in databases.
Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.
Contents:
Introduction to SQL
SQL Syntax
SQL SELECT Statement
SQL INSERT INTO Statement
SQL UPDATE Statement
SQL DELETE Statement
SQL AND & OR Operators
SQL Injection
SQL SELECT TOP Clause
SQL LIKE Operator
SQL Wildcards
SQL IN Operator
SQL BETWEEN Operator
SQL Aliases
SQL Joins
SQL INNER JOIN Keyword
SQL LEFT JOIN Keyword
SQL FULL OUTER JOIN Keyword
SQL UNION Operator
SQL CREATE DATABASE Statement
SQL CREATE TABLE Statement
SQL Constraints
SQL NOT NULL Constraint
SQL UNIQUE Constraint
SQL PRIMARY KEY Constraint
SQL FOREIGN KEY Constraint
SQL CHECK Constraint
SQL DEFAULT Constraint
SQL CREATE INDEX Statement
SQL DROP INDEX, DROP TABLE, and DROP DATABASE
SQL ALTER TABLE Statement
SQL AUTO INCREMENT Field
SQL Views
SQL Date Functions
SQL Functions
SQL AVG() Function
SQL COUNT() Function
SQL MAX() Function
SQL SUM() Function
SQL GROUP BY Statement
SQL HAVING Clause
SQL UCASE() Function
SQL LCASE() Function
SQL MID() Function
SQL LEN() Function
SQL ROUND() Function
SQL NOW() Function
SQL FORMAT() Function