Learn MY SQL
Go from Beginner to PRO and achieve your Data Analyst goals faster with our self-paced Excel course. Learn from industry experts with 15+ years of experience.
MySQL Topics:
SELECT
WHERE
AND, OR, NOT
ORDER BY
INSERT INTO
NULL Values
UPDATE
DELETE
LIMIT
MIN, MAX
COUNT, AVG, SUM
LIKE
Wildcards
IN
BETWEEN
Aliases
INNER JOIN
LEFT JOIN
RIGHT JOIN
CROSS JOIN
Self Join
Comments
CREATE DATABASE
DROP DATABASE
CREATE TABLE
DROP TABLE
ALTER TABLE
Constraints
NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
Advanced SQL Topics:
COMMIT
ROLLBACK
SAVEPOINT
Data Positioning
Stored Procedures
IN Parameter
OUT Parameter
INOUT Parameter
RANK()
DENSE_RANK()
LEAD()
LAG()
INTERSECT
CROSS JOIN