Topics to be covered:
- Basics of SQL
- String Operations
- Joining Tables
- Grouping & Computing Aggregates
- Case Clause
- Subqueries
- Analytics: Window Functions
Northwind sample dataset will be used for all operation in this tutorial. Northwind is a fictitious company that imports and exports food globally. Here is the schema:
