SQL Advanced:
SQL TOP: TOP is used to specify the number of rows to display in the result.
SQL LIKE: LIKE is used in the where clause to search for a pattern.
SQL Wildcards: Wildcards are special characters that are used to perform special searches.
SQL IN: IN to select multiple values in a WHERE clause.
SQL BETWEEN: BETWEEN is used in the WHERE clause to select values from a range of data.
SQL ALIAS: ALIAS is used to rename a table or column.
SQL JOINS: JOIN can query data from 2 or more tables.
SQL INNER JOIN: INNER JOIN is used to combine each row in a table with each row in another table.
SQL LEFT JOIN: LEFT JOIN is used to combine the values of the first table with the values of the second table.
SQL RIGHT JOIN: RIGHT JOIN is used to combine the values of the first table with the values of the second table.
SQL FULL JOIN: FULL JOIN is used to combine the values of the first table with the values of the second table.
SQL UNION: UNION is used to accumulate the results of two SELECT statements.
SQL UNION ALL: SQL UNION ALL is used to accumulate the results of two SELECT statements, even rows will be repeated.
SQL SELECT INTO: SELECT INTO is used to copy data from one table to another table.
SQL CREATE database CREATE DATABASE is used to create databases.
SQL RESTRICTIONS: Restrictions are used to limit the data type of a column.
SQL NOT NULL: NOT NULL is used to specify that a column does not accept NULL.
SQL UNIQUE: UNIQUE is used to uniquely identify each row in a table
UNIQUE SQL ALTER TABLE: ALTER TABLE to add UNIQUE UNIQUE to a column of a table, after being created.
SQL PRIMARY KEY: PRIMARY KEY is used to uniquely identify each row in a table.
SQL FOREIGN KEY: FOREIGN KEY is used to identify a column that is primary key in another table.