Serious SQL with Danny – Day 10

365 Days of SQL: Day 169

I have been quite busy for the past two days. My little sister left for Australia today Her visa was approved on such a short notice that the entire family were on their edge. Anyway, she’s managed to fly and is going to be embarking on her new journey. Hoping for all the best for her new life and endeavors.

Today, I caught up again where I left. I basically covered some of the joins like UNION, UNION ALL and INTERSECT. Another notable thing that I learned today is that UNION is similar to GROUP BY in the SELECT statement and something to choose and think over while writing queries. I also went through some of the questions that were asked in Reddit about SQL. This I believe is inline with my wish to read other people’s way of thinking about SQL queries.

Karma

,

2 responses to “Serious SQL with Danny – Day 10”

  1. Kiran Avatar
    Kiran

    Hi can you post link to the questions/codes you practice? Im looking to practice my SQL as well. DO not know where to start.

    Like

    Reply
    1. Karma Avatar
      Karma

      Hey Kiran, Thanks for your comment. I would advise you to go through the resources below and choose any links that suit your needs and preference. I only went through a few based on my needs. Good luck! Let me know if you have more questions.

      1. Zachary Thomas’ SQL Questions https://quip.com/2gwZArKuWk7W
      2. Select * SQL: https://selectstarsql.com/
      3. Leetcode: https://leetcode.com/problemset/database/
      4. LinkedIn Learning: https://www.linkedin.com/learning/topics/sql
      5. Window Functions: https://www.windowfunctions.com
      6. HackerRank: https://www.hackerrank.com/domains/sql
      7. W3 Schools: https://www.w3schools.com/sql/
      8. CodeAcademy: https://www.codecademy.com/learn/learn-sql
      9. SQLZoo: https://sqlzoo.net/
      10. PostgreSQL: https://pgexercises.com/index.html
      11. Mode: https://mode.com/sql-tutorial/introduction-to-sql/
      12. Udemy free SQL courses: https://www.udemy.com/topic/sql/free/
      13. SQL Bolt: https://sqlbolt.com/
      14. SQLpad: https://sqlpad.io/questions
      15. AdvancedSQL: https://advancedsqlpuzzles.com/
      16. Download db: https://sqlitestudio.pl
      17. PG Exercises: https://pgexercises.com/

      Like

      Reply

Leave a reply to Karma Cancel reply