List: SQL | Curated by Tripathi Aditya Prakash | Medium

Tripathi Aditya Prakash

Feb 17, 2025

15 stories

SQL

In

CodeX

by

Eurico Paes

Understanding the Difference Between WHERE and HAVING in SQL

When working with SQL queries, understanding how to filter data effectively is crucial. Two common filtering clauses, WHERE and HAVING…

Feb 10

Feb 10

In

DataDrivenInvestor

by

Marvin Rubia

Beginner’s Guide in Querying SQL Databases as a Data Analyst

Here are 5 ways to query databases relevant to our data projects.

Jan 17

Beginner’s Guide in Querying SQL Databases as a Data Analyst

Jan 17

Ritu Santra

EXISTS & NOT EXISTS in SQL

Understanding EXISTS & NOT EXISTS with example

Aug 8, 2024

EXISTS & NOT EXISTS in SQL

Aug 8, 2024

This story is no longer available

Prajwala B R

Data Cleaning using SQL

Data cleaning is very crucial step in data analysis process, which involves identifying errors, inconsistencies, inaccuracies in your…

Aug 19, 2024

Data Cleaning using SQL

Aug 19, 2024

In

TDS Archive

by

Jiayan Yin

The Most Useful Advanced SQL Techniques to Succeed in the Tech Industry

Syntax, use cases and expert tips for mastering advanced SQL

Jul 31, 2024

The Most Useful Advanced SQL Techniques to Succeed in the Tech Industry

Jul 31, 2024

Asim Manna

Another Beautiful SQL Question from my Business Analyst Interview

Recently, I was interviewed by Rapido for a business analyst position. In the interview, the interviewer asked me this SQL question.

Mar 13, 2024

Another Beautiful SQL Question from my Business Analyst Interview

Mar 13, 2024

In

TDS Archive

by

Egor Howell

SQL Knowledge You Need For Data Science

Topics, resources and advice for becoming proficient in SQL.

Jun 8, 2024

SQL Knowledge You Need For Data Science

Jun 8, 2024

Luna (Van) Doan

This is Exactly How I Use SQL at Work as a Data Scientist

And why you should learn SQL to level up your data career.

Apr 30, 2024

This is Exactly How I Use SQL at Work as a Data Scientist

Apr 30, 2024

This story is no longer available

In

ILLUMINATION

by

Richard Warepam

Clean Your Data Using SQL Efficiently in 8 Simple Steps

I know you spend 60–80% of your time cleaning data.

Mar 10, 2024

Clean Your Data Using SQL Efficiently in 8 Simple Steps

Mar 10, 2024

In

ILLUMINATION

by

Richard Warepam

How to use SQL in Data Preparation

The Ultimate Guide to the Most Effective Techniques and Strategies

Jan 25, 2024

How to use SQL in Data Preparation

Jan 25, 2024

In

Learning Data

by

Carlos da Costa

Data Cleaning with SQL

No Medium subscription? Read here — Free Access

Jan 3, 2024

Data Cleaning with SQL

Jan 3, 2024

In

Stackademic

by

SQL Fundamentals

Data Cleaning and Preprocessing with SQL

A Comprehensive Guide to Data Refinement

Jan 5, 2024

Data Cleaning and Preprocessing with SQL

Jan 5, 2024

In

Towards Dev

by

Avi Chawla

Pandas Isn’t Enough. Learn These 25 Pandas to SQL Translations to Become a Bilingual Data Scientist

25 common SQL Queries and their corresponding methods in Pandas.

Jan 1, 2024

Pandas Isn’t Enough. Learn These 25 Pandas to SQL Translations to Become a Bilingual Data Scientist

Jan 1, 2024

Tripathi Aditya Prakash
240 Followers
Data Analyst, Founder @shivai , Lifestyle | Tech | Mindset
Following
Inspired Writer
The Partnered Pen
Linda Caroll
Olivia Tanuwidjaja
Ron Markley
See all (102)

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