Thanks to your knowledge of SQL, you will be able to unload the necessary data from databases without the help of developers. You will also be able to perform quick primary data analysis
right at the stage of SQL query writing without using additional tools (Excel, Python, etc.).
Unit Content:
What is SQL and databases.
Writing the first query using PostgreSQL
The main types of queries.
How to filter and sort data.
How to build a summary table. Aggregating functions.
How (and why) to write nested queries. CTE concept.
How to perform complex calculations. Window functions.
How to speed things up with indexes.
How to work with huge tables. Partitioning.