2-minutes SQL intensive course

Create a DB table
CREATE TABLE <TableName>
( ColumnName1 DataType
, ColumnName2 DataType
, ColumnName3 DataType
, …. ) 
Example: 
CREATE TABLE Products
( Company VARCHAR(100)
, Country VARCHAR(100)
, Category VARCHAR(255)
, YEAR INT )

Truncate a DB Table
The table will be empty
TRUNCATE TABLE <TableName>

Drop a DB table 
The table will be deleted from DB
DROP TABLE <TableName>

Select data from a DB table
SELECT <List of Columns>
FROM <TableName>
WHERE <Search Criteria>
Example: 
SELECT Company, Country, Category, Year
FROM Products
WHERE Year > 2013

Select distinct data from a DB table
Return a list of distinct values
SELECT DISTINCT <List of Columns>
FROM <TableName>
WHERE <Search Criteria>
Example:
SELECT DISTINCT Category
FROM Products;

Insert values in an existing table
INSERT INTO <TableName>  (<Field1>, <Field2>, etc. ) 
VALUES (<Value1>, Value2>, etc.)
Example: 
INSERT INTO Products (Company, Country, Category, Year) 
VALUES ('Sony', 'Japan', 'Playstation', 2014)

Insert values in a new table
SELECT * INTO <New Table Name> 
FROM <Existing Table Name>;
Example: 
SELECT * INTO ProductsBackup 
FROM Products;

Update records in a DB table
UPDATE <Table Name> 
SET <Column1> = <Value1>, <Column2> = <Value2>, … 
WHERE <Search Criteria>
Example: 
UPDATE Products 
SET Country = 'Japan' 
WHERE Company = 'Playstation'

Delete records from a DB table
DELETE FROM <Table Name>
WHERE <Search Criteria>
Example: 
DELETE FROM Products 
WHERE Year < 2000

Order the results of a query
SELECT <List of Table Columns>
FROM <Table Name>
WHERE <Search Criteria> 
ORDER BY < List of Table Columns> 
Example: 
SELECT Company, Category, Year 
FROM Products
WHERE Country = 'Japan' 
ORDER BY Company, Category

Select data from multiple tables
SELECT <List of Table Columns>
FROM <Table1> INNER JOIN <Table2> ON <Table1>.<Field1> = <Table2>.<Field2>
Example: 
SELECT Customers.Name, Orders.ProductId 
FROM Customers INNER JOIN Orders ON Customers.ID = Orders.CustomerID 

Aggregate functions
SELECT COUNT(*) FROM Products WHERE Category= 'Playstation';
SELECT COUNT(DISTINCT(Year)) FROM Products WHERE Category= 'Playstation';
SELECT MIN(Year) FROM Products;
SELECT MAX(Year) FROM Products;
SELECT AVG(SalesAmount) FROM Products;
SELECT SUM(SalesAmount) FROM Products;

Group data using aggregate functions
SELECT <List of Columns>
FROM <Table Name>
WHERE <Search Criteria> 
GROUP BY <List of Table Columns> 
Example: 
SELECT Company, COUNT(*) 
FROM Products
WHERE Year = 2014 
GROUP BY Company