PAYAL CHAUHAN“Revamping Data Architecture at The Economist Group: Setting ourselves up for success”OverviewJul 25Jul 25
PAYAL CHAUHANDecoding Data ModelingA Comprehensive Guide to Understanding the Fundamentals of Data ModelingApr 17, 2023Apr 17, 2023
PAYAL CHAUHANDo you know you can divide a pair of SQL queries?I recently had to divide 2 SQL queries and wondered how to go about doing that. I made the decision to write this brief article as an…Jan 27, 2023Jan 27, 2023
PAYAL CHAUHANValidating SQL Data Counts Is No Longer A PainIn this post, a great SQL tip is covered that will help you avoid manually counting rows using select count(1) from table and save a tonne…Oct 4, 2022Oct 4, 2022
PAYAL CHAUHANUber Data Engineer Tricky SQL Interview Question: IQ or SQ?Based on basic SQL aggregation concepts of GroupBy , Distinct , Sum, CountSep 16, 20222Sep 16, 20222
PAYAL CHAUHANJourney of Extrovert to IntrovertWhat makes a person to become so much introvert , once in life who used to be friendly,social and demonstrative.Jul 23, 2020Jul 23, 2020
PAYAL CHAUHANDelete Duplicate Records from database table on the basis of timestampHave you ever found yourself stuck in SQL when you are running a select query using WHERE clause on timestamp column , but it is returning…Jul 22, 2020Jul 22, 2020
PAYAL CHAUHANAccelerate your career by doing these Free Courses from upGrad to learn in this pandemicThese days most of us are doing work from home, some of us have lost our jobs and some are trying to enhance their skills while learning…Jun 25, 2020Jun 25, 2020
PAYAL CHAUHANA to Z about greenplum — starting from ArchitectureGreenplum — an open source MPP database. You must be wondering what is MPP. Yes you can google it which says , Massively Parallel…May 27, 2020May 27, 2020
PAYAL CHAUHANDivide By Zero Error in DatabaseSo you are computing some calculation in database such as average of the column value or calculating percentage. We mostly face this error…May 18, 2020May 18, 2020