-
We have created different tables and build the data model,
-
Generate SQL create table statements, insert data, show examples of updating data.
-
Also performed analytic examples using where condition, orderby, group by, having clause,
-
And practiced different aggregation functions.
-
We have also covered subquery, window function, CTE, case statement, date casting, and working with dates.
