Deutsch

Beiträge mit #learningSQL

#learningSQL

Öffentliche Beiträge auf X, die #learningSQL verwenden.

Verwandte Hashtags

  3. 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:
    Herunterladen
    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
  4. 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.
    Herunterladen
    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
  5. 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
  10. 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
  12. 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
  13. 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
  14. 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:
    Herunterladen
    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
  15. 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
    Herunterladen
    1029
  17. 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.
    Herunterladen
    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
  18. 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.
    Herunterladen
    20426
  21. 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.
    Herunterladen
    416346
  22. 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
  24. 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.
    Herunterladen
    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
  25. 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
    Herunterladen
    112142
  26. 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
  29. Priyanshu@prynsustwt
    Day 5 of #LearningSQL in 5 days (Yesterday missed post) - Lots of practice - Learnt Joins (Inner, left, right, cross joins) in. SQL and practice - Learnt about Case Statement and practice With that SQL has finished ✨ What are you all learning guys? #LearnInPublic #sql
    004151
  33. 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
    Herunterladen
    10314
  35. Mehr Beiträge anzeigen