Luchiana Dumitrescu

Pinned

Published in
Code Like A Girl

Unsurpassed Filtering Clauses: WHERE and HAVING in SQL

SQL Simplified: Understanding WHERE and HAVING Clauses

Nov 21, 2024

Unsurpassed Filtering Clauses: WHERE and HAVING in SQL

Nov 21, 2024

Pinned

Published in
Code Like A Girl

FIRST_VALUE and LAST_VALUE in SQL: Capturing the Start and End Points of Your Data Journey

You can still enjoy the full article for free if you're not a Medium member. Click here to read it all😊

Aug 28, 2024

FIRST_VALUE and LAST_VALUE in SQL: Capturing the Start and End Points of Your Data Journey

Aug 28, 2024

Want to be the first to "taste" something fresh out of the oven?

Subscribe here to be the first to read my latest article as soon as it’s published. I truly hope you’ll enjoy reading it as much as I enjoyed writing it for you. Thank you for your valuable support! Big bear hug, Luchiana

By signing up, you will create a Medium account if you don’t already have one. Review our Privacy Policy for more information about our privacy practices.

Medium sent you an email at to complete your subscription.

Pinned

Published in
Code Like A Girl

SQL Essentials: RANK or DENSE_RANK? That’s the question

If you’re not a Medium member, you can still enjoy the full article for free. Click here to read it all 😊

Jul 10, 2024

SQL Essentials: RANK or DENSE_RANK? That’s the question

Jul 10, 2024

Pinned

Published in
Code Like A Girl

SQL Essentials: GROUP BY vs. PARTITION BY explained

If you’re not a Medium member, you can still enjoy the full article for free. Click here to read it all 😊

Jun 26, 2024

SQL Essentials: GROUP BY vs. PARTITION BY explained

Jun 26, 2024

Pinned

Published in
Code Like A Girl

SQL Window Functions: The Ultimate Tool for Data Enthusiasts

Vast amounts of data — this is what we’re dealing with nowadays. Along with this main challenge comes the complexity of various sources…

Jun 13, 2024

SQL Window Functions: The Ultimate Tool for Data Enthusiasts

Jun 13, 2024

Published in
Code Like A Girl

SQL Data Types and Memory: Because Size Sometimes Matters

You’re not a Medium member? Enjoy the full article for free HERE 👈😊

4d ago

SQL Data Types and Memory: Because Size Sometimes Matters

4d ago

Published in
Code Like A Girl

The Mystery Behind the Curtains: How SQL Processes Clauses in Your Queries

As a beginner, it’s essential to have a good understanding of all steps in your learning journey. Skipping the fundamentals can leave gaps…

Dec 5, 2024

The Mystery Behind the Curtains: How SQL Processes Clauses in Your Queries

Dec 5, 2024

Published in
Code Like A Girl

Avoid the Oops: DELETE and TRUNCATE Made Easy

Mastering Data Management Without Losing Your Mind

Oct 18, 2024

Avoid the Oops: DELETE and TRUNCATE Made Easy

Oct 18, 2024

Published in
Code Like A Girl

The Mystery of NULL Values: Why They Matter and How to Tackle Them

If you’re not a Medium member, you can still enjoy the full article for free. Click here to read it all😊

Sep 23, 2024

The Mystery of NULL Values: Why They Matter and How to Tackle Them

Sep 23, 2024

Published in
Code Like A Girl

LAG and LEAD in SQL: Mastering Time Travel for Better Data Insights

If you’re not a Medium member, you can still enjoy the full article for free. Click here to read it all😊

Aug 15, 2024

LAG and LEAD in SQL: Mastering Time Travel for Better Data Insights

Aug 15, 2024

Unsurpassed Filtering Clauses: WHERE and HAVING in SQL

SQL Simplified: Understanding WHERE and HAVING Clauses

FIRST_VALUE and LAST_VALUE in SQL: Capturing the Start and End Points of Your Data Journey

You can still enjoy the full article for free if you're not a Medium member. Click here to read it all😊

Want to be the first to "taste" something fresh out of the oven?

SQL Essentials: RANK or DENSE_RANK? That’s the question

If you’re not a Medium member, you can still enjoy the full article for free. Click here to read it all 😊

SQL Essentials: GROUP BY vs. PARTITION BY explained

If you’re not a Medium member, you can still enjoy the full article for free. Click here to read it all 😊

SQL Window Functions: The Ultimate Tool for Data Enthusiasts

Vast amounts of data — this is what we’re dealing with nowadays. Along with this main challenge comes the complexity of various sources…

SQL Data Types and Memory: Because Size Sometimes Matters

You’re not a Medium member? Enjoy the full article for free HERE 👈😊

The Mystery Behind the Curtains: How SQL Processes Clauses in Your Queries

As a beginner, it’s essential to have a good understanding of all steps in your learning journey. Skipping the fundamentals can leave gaps…

Avoid the Oops: DELETE and TRUNCATE Made Easy

Mastering Data Management Without Losing Your Mind

The Mystery of NULL Values: Why They Matter and How to Tackle Them

If you’re not a Medium member, you can still enjoy the full article for free. Click here to read it all😊

LAG and LEAD in SQL: Mastering Time Travel for Better Data Insights

If you’re not a Medium member, you can still enjoy the full article for free. Click here to read it all😊

Luchiana Dumitrescu

Python

Personal Stories

SQL Stuff