Türkçe

#learningSQL içeren gönderiler

#learningSQL

X'te #learningSQL kullanan herkese açık gönderiler.

İlgili etiketler

  2. Orkun Tahir Aran, PhD@orc_arn
    Chapter 8: Grouping and Aggregate functions of #LearningSQL @OReillyMedia This thread will be a brief summary and a short one. Let's dive in
    Orkun Tahir Aran, PhD @orc_arn
    Tomorrow I will start to read this gem, part by part every day, and share my notes here. Time to dive deep in #SQL
    117
  3. Orkun Tahir Aran, PhD@orc_arn
    Tomorrow I will start to read this gem, part by part every day, and share my notes here. Time to dive deep in #SQL
    İndir
    432151.7K
  7. 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
  8. 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
  9. 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:
    İndir
    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
  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:
    İndir
    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
    @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
    İndir
    1029
  13. Dave_D_Analyst@Dave_D_Analyst
    Now going further in my data journey—learning how BETWEEN and NOT BETWEEN work for filtering ranges in SQL. Data science and analytics folks, whether experienced or learning, let’s connect and grow together! #SQL #DataAnalytics #LearningSQL #DataScience
    İndir
    004114
  14. 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.
    İndir
    416346
  15. 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
  18. 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.
    İndir
    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
  19. 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
  21. 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
  23. Orkun Tahir Aran, PhD@orc_arn
    1⃣Hi everyone, let's start as promised yesterday. A quick note before starting, check @levikul09 for statistics and python related information. These tweets are my notes from @OReillyMedia #LearningSQL book chapter 1. All the credit goes to that book.
    1738
  24. 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
  25. 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
  26. 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.
    İndir
    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
  27. 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.
    İndir
    317147
  28. 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
    İndir
    10314
  31. 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
  32. 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
  33. 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
  34. Daha fazla gönderi göster