Mohd AtifData Engineering: Advanced SQL ConceptsIn this article, we will dive into some advanced and complex SQL concepts using PostgreSQL 15 as a database but can be applied to any…May 4May 4
Mohd AtifSQL Analytical Window Functions from Simple to AdvancedSQL windows functions are very handy tool in various scenarios such as Top N, Running average/sum and Gaps and Island problems…Feb 17Feb 17
Mohd AtifTop N rows of each group using Pandas and DuckDBIn this article we will look into the different methods to get Top N rows of each group. We all must have faced a scenario of getting top N…Apr 6, 2023Apr 6, 2023
Mohd AtifMost Important Resources to start with Python and Data AnalysisI have started my journey to learn Python, Data Analysis using Pandas and other Python libraries in 2022. In recent times many of my…Mar 23, 20232Mar 23, 20232