Português

Publicações com #LearningSQL

#LearningSQL

Publicações públicas do X que usam #LearningSQL.

Hashtags relacionados

  1. 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:
    Baixar
    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
  2. 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:
    Baixar
    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
  3. 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
    Baixar
    1029
  5. 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.
    Baixar
    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
  6. 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
  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.
    Baixar
    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
    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.
    Baixar
    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
  11. 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
    Baixar
    10314
  13. 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
    Baixar
    112142
  14. 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
  16. 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
  18. 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
    Baixar
    004114
  21. 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.
    Baixar
    20426
  23. 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.
    Baixar
    416346
  24. 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
  30. 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
    Baixar
    11283
  31. 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
  32. 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
  35. Mostrar mais publicações