Things To Remember:

1. date-format: YYYY-MM-DD
   • To separate date from DateTime column use DATE(column_name)
2. CURRENT_TIMESTAMP gives current time, which can be used to insert.

SQL Fundamentals

GROUP BY statements

JOINS Statements

ADVANCED SQL Commands

CREATE databases and Tables

Window Function LAG()

Conditional Expressions and Procedures Introduction