English

Posts with #learningSQL

#learningSQL

Public posts on X that use #learningSQL.

Related hashtags

  1. 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
  4. 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
  5. 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
  6. 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:
    Download
    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
  7. 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.
    Download
    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
  8. 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
  11. 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
    Download
    432151.7K
  13. Sunny Sahsi@SahsiSunny
    Just started my SQL journey with #SQLBolt! Lesson 1 is all about SELECT queries. SQL is like a language for databases, and SELECT is how we ask for data. Let's dive in!
    2191.6K
  14. Sunny Sahsi@SahsiSunny
    @SahsiSunny
    5. Find all information about each film: This provides detailed info on all movies in the database.
    Download
    10094
  15. Sunny Sahsi@SahsiSunny
    @SahsiSunny
    SQL makes it easy to retrieve specific data from a database. Can't wait to learn more! Next up, we'll explore queries with constraints. #LearningSQL Thanks @twts_tejas for suggesting me to learn SQL from SQLBolt. I am enjoying it. Link -
    1131.2K
  16. 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
  17. 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
  20. 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.
    Download
    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
  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.
    Download
    20426
  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
  28. 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
    Download
    11283
  29. 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.
    Download
    317147
  30. 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
    Download
    10314
  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
  33. Show more posts