Français

Posts avec #LearningSQL

#LearningSQL

Les posts publics sur X qui utilisent #LearningSQL.

Hashtags associés

  1. 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
  2. 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
  4. 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.
    Télécharger
    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
  5. 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.
    Télécharger
    317147
  6. 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
    Télécharger
    10314
  10. 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:
    Télécharger
    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
  11. 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.
    Télécharger
    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
  12. 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
  15. 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.
    Télécharger
    20426
  18. 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
    Télécharger
    215102
  20. Priyanshu@prynsustwt
    Day2 of #learningSQL in 5 days - Learnt about constraint in SQL (Primary key, Unique key, Foreign key, Not null, Check and Default). - Deep dive into Group by, Order by, Having clauses and practise questions. - Learnt about how to DELETE OR UPDATE data and practice. #Database
    002115
  21. 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:
    Télécharger
    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
  22. 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
    Télécharger
    1029
  24. 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
  25. 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.
    Télécharger
    416346
  26. 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
  28. 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
  29. 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
  32. Priyanshu@prynsustwt
    Day 3 of #learningSQL in 5 Days - Not done much but - learnt window and ranking functions in SQL - solved questions for practice - little sketching That's it ✨ See you later 👋 #LearnInPublic #SQL
    002109
  35. Afficher plus de posts