Advanced SQL in MySQL 8.0: window functions, pivot tables, regex, stored procedures, employee management project, ML data prep
-
Updated
May 29, 2026 - SQL
Advanced SQL in MySQL 8.0: window functions, pivot tables, regex, stored procedures, employee management project, ML data prep
This advanced version of the initial Stock-Portfolio-Robo-Advisor project utilizes advanced SQL, Python, and Airflow for data storage and analysis. The data warehouse contains millions of rows and fetches results for each company and historical prices from an API, enabling comprehensive analysis using different complex algorithmic techniques.
Add a description, image, and links to the advanced-sql topic page so that developers can more easily learn about it.
To associate your repository with the advanced-sql topic, visit your repo's landing page and select "manage topics."