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 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
  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.
    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
  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. 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
  6. 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
  7. 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
  8. 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
  11. 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
  12. 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
  13. 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. 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
  17. 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
  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
  22. Shelley Tang@shelleyyolivia
    Too bad we can't just type \ to escape from a group text or unproductive meeting #learningSQL
    003199
  23. 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
  24. 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
  26. 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
  28. 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
  29. 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
  33. 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
  34. 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
  35. 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
  36. Mostrar mais publicações