Loading lesson path
Concept visual
Start at both ends
Formula
AND / ORSELECT column_name(s)FROM table_name
AND|OR condition
ALTER TABLE table_name
ADD column_name datatype or
ALTER TABLE table_nameDROP COLUMN column_name AS (alias)
SELECT column_name AS column_aliasFROM table_name or
SELECT column_nameFROM table_name AS table_alias
SELECT column_name(s)FROM table_name WHERE column_name
CREATE DATABASE database_name
CREATE TABLE table_name ( column_name1 data_type, column_name2 data_type, column_name3 data_type,... )
CREATE INDEX index_name ON table_name (column_name) or CREATE UNIQUE INDEX index_name ON table_name (column_name)
CREATE VIEW view_name AS
SELECT column_name(s)FROM table_name
DELETE FROM table_name
WHERE some_column=some_value or
DELETE FROM table_name
(Deletes the entire table!!)
DELETE * FROM table_name
(Deletes the entire table!!)
DROP DATABASE database_name
DROP INDEX table_name.index_name (SQL Server) DROP INDEX index_name ON table_name (MS Access)
Formula
DROP INDEX index_name (DB2/Oracle)ALTER TABLE table_name
DROP INDEX index_name (MySQL)DROP TABLE table_name
IF EXISTS (SELECT * FROM table_name WHERE id = ?)--do what needs to be done if exists
--do what needs to be done if not
SELECT column_name, aggregate_function(column_name)FROM table_name WHERE column_name operator value GROUP BY column_name
SELECT column_name, aggregate_function(column_name)FROM table_name WHERE column_name operator value GROUP BY column_name HAVING aggregate_function(column_name) operator value IN
SELECT column_name(s)FROM table_name WHERE column_name IN (value1,value2,..)