PAYAL CHAUHAN – Medium

PAYAL CHAUHAN

PAYAL CHAUHAN

“Revamping Data Architecture at The Economist Group: Setting ourselves up for success”

Overview

1d ago

Data Demo High Level Design Architecture Diagram

1d ago

PAYAL CHAUHAN

Decoding Data Modeling

A Comprehensive Guide to Understanding the Fundamentals of Data Modeling

Apr 17, 2023

Decoding Data Modeling

Apr 17, 2023

PAYAL CHAUHAN

Do 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, 2023

Do you know you can divide a pair of SQL queries?

Jan 27, 2023

PAYAL CHAUHAN

Validating SQL Data Counts Is No Longer A Pain

In 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, 2022

Validating SQL Data Counts Is No Longer A Pain

Oct 4, 2022

PAYAL CHAUHAN

Uber Data Engineer Tricky SQL Interview Question: IQ or SQ?

Based on basic SQL aggregation concepts of GroupBy , Distinct , Sum, Count

Sep 16, 2022

Uber Data Engineer Tricky SQL Interview Question: IQ or SQ?

Sep 16, 2022

PAYAL CHAUHAN

Journey of Extrovert to Introvert

What makes a person to become so much introvert , once in life who used to be friendly,social and demonstrative.

Jul 23, 2020

Journey of Extrovert to Introvert

Jul 23, 2020

PAYAL CHAUHAN

Delete Duplicate Records from database table on the basis of timestamp

Have 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, 2020

Delete Duplicate Records from database table on the basis of timestamp

Jul 22, 2020

PAYAL CHAUHAN

Accelerate your career by doing these Free Courses from upGrad to learn in this pandemic

These 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, 2020

Accelerate your career by doing these Free Courses from upGrad to learn in this pandemic

Jun 25, 2020

PAYAL CHAUHAN

A to Z about greenplum — starting from Architecture

Greenplum — an open source MPP database. You must be wondering what is MPP. Yes you can google it which says , Massively Parallel…

May 27, 2020

A to Z about greenplum — starting from Architecture

May 27, 2020

PAYAL CHAUHAN

Divide By Zero Error in Database

So you are computing some calculation in database such as average of the column value or calculating percentage. We mostly face this error…

May 18, 2020

Divide By Zero Error in Database

May 18, 2020

PAYAL CHAUHAN

PAYAL CHAUHAN

Data Enthusiast | SQL | Business Intelligence |worked on various Databases | Big Data Apache Learner | ML admirer

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams