u/OliveIndividual7351

I’m Learning SQL and Wrote a Simple Beginner Guide About SQL Transformations

I’m currently learning SQL and recently wrote a simple beginner-friendly article about SQL transformations.

When working with data, transformations become really important because you often need to:

  • change data formats
  • calculate values
  • clean data
  • combine text
  • or prepare data for analysis

Sometimes a number is stored as text and needs to be converted.
Sometimes data contains unwanted values or formatting that needs to be cleaned up.

So I wrote an article explaining:

  • how SQL transformations work
  • simple practical examples
  • and common beginner use cases

I also added a small SQL Formula Sheet at the end 😊

As someone still learning SQL myself, I tried to explain things in a very simple and practical way instead of making it overly technical.

https://medium.com/@meryem_cebeci/learning-sql-step-by-step-transformations-explained-b2b37a0f9fbb

reddit.com
u/OliveIndividual7351 — 3 days ago

I’m Learning SQL and Wrote a Simple Beginner Guide About Filtering / WHERE Clauses

If you are currently learning SQL, maybe this will help you 😊

I recently wrote a beginner-friendly article about SQL filtering / WHERE clauses.

When I started learning SQL, I mixed a lot of things up, forgot NULL values, missed brackets, and sometimes got completely wrong results without understanding why.

So I wrote an article explaining:

  • how filtering actually works
  • common beginner mistakes
  • simple real-world examples

I also added a small SQL Formula Sheet with filtering functions at the end.

As someone still learning SQL myself, I tried to explain things in a very simple and practical way instead of making it overly technical.

https://medium.com/@meryem_cebeci/learning-sql-step-by-step-filtering-explained-363a0a638bd0

u/OliveIndividual7351 — 10 days ago