Master SQL with SQL Server,MySql,PostGre,MariaDB and SQLite

How to create a Database in the 5 DBMS. How to use the IF NOT EXISTS option and add-on COLLATE, CHARACTER SET and COMMENT

How to use the key word USE, SHOW, ALTER and DROP on databases.

Data types: Numeric, Text, Date, Boolean

How to use CREATE TABLE and SHOW TABLE is each of the 5 DBMS. How to use add on LIKE to create a table.

Using LOAD DATA INFILE in MySQL

Use LOAD DATA INFILE in MariaDB

Using BULK INSERT in SQL Server

Using COPY in PostGre

Using .IMPORT in SQLite

Using INSERT INTO to insert data in a table

Using key word RENAME AND DROP

SELECT (col_name) and SELECT *

SELECT ... AS, SELECT DISTINCT and SELECT ... LIMIT or SELECT TOP

FUNCTIONS: ABS(),CEILING(),FLOOR(),PI(),POWER(),RAND/RANDOM(),ROUND(),SIGN(),SQRT(),TRUNCATE/TRUNC()

FUNCTIONS: CURRENT_DAY(),CURRENT_TIME(),DATE_ADD(),NOW(),DAY(),DATE_SUB(),DATE_DIFF(),DAYNAME(),DATE_FORMAT()

FUNCTIONS:MAKEDATE(),MAKETIME(),HOUR(),MINUTE(),MONTH(),TIME(),DAYOFWEEK(),TIMEDIFF()

FUNCTIONS: WEEK(),YEAR(),WEEKDAY(),WEEKOFYEAR(),UTC_DATE,UTC_TIME()

FUNCTIONS:IF(),IFNULL(),IN(),IS(),NULLIF(),NOT IN(),ISNULL()

FUNCTIONS:AVG(),SUM(),MIN(),MAX(),COUNT(),STDDEV(),VARIANCE()

Key word: UPDATE, BEGIN TRAN – COMMIT - ROLLBACK

Column NOT NULL, ZERO FILL, PRIMARY KEY

Column definition AUTO_INCREMENT, IDENTITY, SERIAL, CONSTRAINT

Foreign key, ON UPDATE, ON DELETE, CASCADE, SET NULL SET DEFAULT, RESTRICT

Constraint UNIQUE

Modify a table (Not Null, datatype and constraint)