Skill Keyword - SQL , PostgreSQL, Python, Data science, Excel, Tableau.
Description:
• Using third party database to retrieve data and prepare for analysis using PostgreSQL
• Generally know how to make efficient queries when dealing with several tables and know what's involved in optimizing queries
Details:
o Multiple joins (joining several tables)
o Subqueries and CTE Tables
o Window Functions (RANK, ROW_NUMBER, etc.)
o Regular Expressions
o Grouping and aggregation
o Set functions: UNION ALL, etc.
o JSON(b) functions