What Will You Learn?

• SELECT
• WHERE
• AND, OR, NOT
• ORDER BY
• INSERT INTO
• NULL Values
• UPDATE
• DELETE
• LIMIT
• MIN and MAX
• COUNT, AVG, SUM
• LIKE
• Wildcards
• IN
• BETWEEN
• Aliases
• Joins
• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• CROSS JOIN
• Self Join
• UNION
• GROUP BY
• HAVING
• EXISTS
• ANY, ALL
• INSERT SELECT
• CASE
• Null Functions
• Comments
• Operators
• Database
• Create DB
• Drop DB
• Create Table
• Drop Table
• Alter Table
• Constraints
• Not Null
• Unique
• Primary Key
• Foreign Key
• Check
• Default
• Create Index
• Auto Increment
• Dates
• Views