Nederlands

Berichten met #LearningSQL

#LearningSQL

Openbare berichten op X die #LearningSQL gebruiken.

Gerelateerde hashtags

  1. Moyiné@Moyineee
    Data Analysis Learning - Part 2 Learning SQL GM guys 👋 Hope you’re good. Today was a very lazy day, but I’m still here 🫠. I learned about JOINS in SQL. There are four types of joins. I’ll explain the ones I learned using Table A and Table B. From my understanding:
    Downloaden
    Moyiné @Moyineee
    Data Analysis Learning - Part 2 Learning SQL GM guys 👋 Hope you’re good. Today, I learned about NULL values in SQL and solved some practice questions.
    315105
  2. Moyiné@Moyineee
    Data Analysis Learning - Part 2 Learning SQL GM guys 👋 Hope you’re good. Today, I learned about NULL values in SQL and solved some practice questions.
    Downloaden
    Moyiné @Moyineee
    Data Analysis Learning - Part 2 Learning SQL GM guys 👋 Hope you’re good. Today, I practiced aggregate functions using practice questions from the SQL video I’m learning from. The first question gave me some trouble, but I solved it after taking a long break.
    31898
  3. Moyiné@Moyineee
    @Moyineee
    3️⃣ INNER JOIN Returns only values that exist in both Table A and Table B. If a value isn’t present in both tables, it won’t be returned. There’s one more join that I didn’t learn today. I’ll continue from this in tomorrow’s lesson.
    10314
  5. Moyiné@Moyineee
    Data Analysis Learning - Part 2 Learning SQL GM guys 👋 Hope you’re good. Today was busy, but I can’t miss a day (working day 😅) if I can. Today, I learned about FULL OUTER JOIN and solved a few practice questions. Explaining it using Table A and Table B:
    Downloaden
    Moyiné @Moyineee
    Data Analysis Learning - Part 2 Learning SQL GM guys 👋 Hope you’re good. Today was a very lazy day, but I’m still here 🫠. I learned about JOINS in SQL. There are four types of joins. I’ll explain the ones I learned using Table A and Table B. From my understanding:
    21474
  6. Moyiné@Moyineee
    @Moyineee
    FULL OUTER JOIN This join returns all the values you want from both Table A and Table B, even when there’s no matching or related value between the tables. That’s what I learned today. Still learning 🌱 Still growing
    Downloaden
    1029
  9. Moyiné@Moyineee
    Data Analysis Learning - Part 2 Learning SQL GM guys 👋 Hope you’re good. Today, I practiced aggregate functions using practice questions from the SQL video I’m learning from. The first question gave me some trouble, but I solved it after taking a long break.
    Downloaden
    Moyiné @Moyineee
    Data Analysis Learning - Part 2 Learning SQL GM guys 👋 Hope you’re good. Today, I learned about Aggregate Functions in SQL: SUM, COUNT, AVG, MAX, MIN.
    125106
  10. Moyiné@Moyineee
    @Moyineee
    From my understanding, NULL values represent empty cells or fields. Fields that contain nothing at all, not even spaces (like ' '). In general, 0 is greater than NULL, but in some arithmetic operations, NULL can be treated as zero depending on how the operation is handled.
    Downloaden
    20426
  12. Moyiné@Moyineee
    Data Analysis Learning - Part 2 Learning SQL GM guys 👋 Hope you’re good. Today, I learned about Aggregate Functions in SQL: SUM, COUNT, AVG, MAX, MIN.
    Downloaden
    Moyiné @Moyineee
    Data Analysis Learning - Part 2 🧵 Learning SQL Today, I learned about arithmetic operations in SQL. Using SQLite and actual, I practiced: • (+) addition • (-) subtraction • (*) multiplication • (/) division • (%) modulus
    317147
  13. Moyiné@Moyineee
    @Moyineee
    ...everything in the SELECT statement at the same time, so the alias isn’t available yet for another operation like an aggregate function That’s what I learned today Screenshots of my queries are in this thread Still learning 🌱 Still growing 🚀 One step at a time
    Downloaden
    10314
  15. Moyiné@Moyineee
    Data Analysis Learning - Part 2 🧵 Learning SQL Today, I learned about arithmetic operations in SQL. Using SQLite and actual, I practiced: • (+) addition • (-) subtraction • (*) multiplication • (/) division • (%) modulus
    Downloaden
    112142
  16. Moyiné@Moyineee
    @Moyineee
    Other key concepts: • GROUP BY - Groups rows that share the same property so aggregate functions can be applied. • HAVING - Filters groups based on aggregate function results. It’s similar to WHERE, but WHERE filters rows, while HAVING filters groups.
    10216
  18. Moyiné@Moyineee
    Data Analyst Learning - Part 2 Learning SQL GM guys, Hope you’re doing great. Here’s a quick update on what’s been happening with me after learning MS Excel.
    Downloaden
    416346
  19. Moyiné@Moyineee
    @Moyineee
    After Excel, I took a short break, started and completed posting my Data Analyst 2026 Roadmap thread series, and then moved on to SQL. I started learning SQL on January 14th, but paused briefly to finish the DA roadmap thread series. I picked SQL back up on the 21st.
    10230
  21. Shrinath Joshi@ImShriJoshi
    💡 SQL learning: Solving a “Repeated Payments” problem. The goal: find payments made at the same merchant, with the same card & amount, within 10 minutes. The key was comparing each transaction with the previous matching transaction. That’s where LAG() comes in. 👇
    1006
  22. Shrinath Joshi@ImShriJoshi
    @ImShriJoshi
    The mental model: GROUP → SORT → LAG → TIME DIFF → FILTER → COUNT LAG() = find the previous row. Key takeaway: whenever a SQL problem says “compare the current row with the previous row”, think LAG(). Small concepts → big improvements. 🚀 #SQL #LearningSQL #100DaysOfCode
    1026
  23. The Data Boy@Fortune_star01
    Just updated my MySQL playlist on YouTube. This new episode covers ORDER BY, sorting, LIMIT, and using DISTINCT to clean results. Simple concepts, but essential for real data analysis. Watch the update on my channel The Data Boy: #SQL #MySQL #learningsql
    00393
  29. Priyanshu@prynsustwt
    Day4 of #learningSQL in 5 days (Yesterday missed post) - practice more questions - learnt about (row_number, rank, dense_rank) window functions - did easy, medium level leetcode question around that topic - started learning JOINS in sql That's it ✨ See you later 👋
    006161
  30. jason✓@jxnlco
    when you do a join vs a left join... #learningsql
    001
  31. Sir Deffi⚡@DeffiFavour
    Day 8 of #learningSQL 😊 Topic(s) covered 1. WINDOWS RANKING FUNCTION The Ranking functions are used to assign ranks or values to rows of data. The window ranking function must make use of the ORDER BY clause
    Sir Deffi⚡ @DeffiFavour
    Day 7 of #learningSQL 😊 Topic(s) covered 1. WINDOWS function 2. ⁠ Calculating Running and Rolling Totals 1. WINDOWS FUNCTION Also referred to as analytical functions. WINDOWS Function performs calculations (e.g aggregation) on a specific subset of data and return a value(s)
    81290
  32. Sir Deffi⚡@DeffiFavour
    Day 7 of #learningSQL 😊 Topic(s) covered 1. WINDOWS function 2. ⁠ Calculating Running and Rolling Totals 1. WINDOWS FUNCTION Also referred to as analytical functions. WINDOWS Function performs calculations (e.g aggregation) on a specific subset of data and return a value(s)
    80195
  33. Esther 💙@Etty_official
    I move again today ; Day 6 of #100DaysOfSQL Today I learned the difference between WHERE and HAVING in SQL: - WHERE filters rows before grouping - HAVING filters groups after GROUP BY` #SQL #LearningSQL
    Downloaden
    106100
  34. Esther 💙@Etty_official
    @Etty_official
    I move again today ; Day 6 of #100DaysOfSQL Today I learned the difference between WHERE and HAVING in SQL: - WHERE filters rows before grouping - HAVING filters groups after GROUP BY #SQL #LearningSQL
    Downloaden
    215102
  35. data girl@datagirlmaya
    🚀 My SQL Journey: From Curiosity to Mastery! 💡 If you told me a while back that learning SQL would be fun, I might have raised an eyebrow. But here I am, genuinely enjoying every step of the process! #SQL #DataAnalytics #LearningSQL #TechJourney
    Downloaden
    11283
  37. Meer berichten tonen