TrainingByPackt / SQL-for-Data-Analytics Star 268 Code Issues Pull requests Perform fast and efficient data analysis with the power of SQL sqlalchemy sql copy datetime geospatial data-analytics join window-function group-by having index-scan sequential-scan hash-scan killing-queries aggregate-functions Updated Apr 1, 2023 Jupyter Notebook
PacktWorkshops / The-Applied-SQL-Data-Analytics-Workshop Star 65 Code Issues Pull requests A Quick, Interactive Approach to Learning Analytics with SQL data sqlalchemy sql database copy analysis excel python3 data-analytics joins performant exporting importing window-function group-by having sequential-scan hash-scan killing-queries aggregate-functions Updated Jan 15, 2021 Jupyter Notebook
eugene-khyst / postgresql-performance-essentials Star 55 Code Issues Pull requests PostgreSQL performance essentials in 1 hour postgres sql postgresql query-optimization database-perfomance btree-indexes slow-queries table-partitioning query-plan nested-loops hash-join sql-join index-scan sequential-scan merge-join gin-indexes hash-indexes partial-indexes bitmap-scans multicolumn-indexes Updated Jul 10, 2022