Hey, folks! Some time back, I was scrolling through LinkedIn and found some essential SQL topics to revisit before an Interview.
Have a look π§΅π
Have a look π§΅π
1. WHERE, AND, OR, NOT, IN
2. ORDER BY, ASC, DESC
3. IS NULL
4. LIMIT
5. MIN, MAX, COUNT, AVG, SUM
6. LIKE, WILDCARDS
7. IN BETWEEN
8. INNER JOIN
9. LEFT JOIN
2. ORDER BY, ASC, DESC
3. IS NULL
4. LIMIT
5. MIN, MAX, COUNT, AVG, SUM
6. LIKE, WILDCARDS
7. IN BETWEEN
8. INNER JOIN
9. LEFT JOIN
10. UNION ALL
11. GROUP BY
12. HAVING
13. LEFT, RIGHT, MID, CONCAT
14. PARTITION BY, OVER
15. LEAD, LAG
16. Subqueries
17. RANK, DENSE_RANK, PERCENT_RANK
18. ROW_NUMBER, CUME_DIST
19. FIRST_VALUE, LAST_VALUE
20. AS
11. GROUP BY
12. HAVING
13. LEFT, RIGHT, MID, CONCAT
14. PARTITION BY, OVER
15. LEAD, LAG
16. Subqueries
17. RANK, DENSE_RANK, PERCENT_RANK
18. ROW_NUMBER, CUME_DIST
19. FIRST_VALUE, LAST_VALUE
20. AS
Most of these topics you would find in the threads I posted before. More of these would be posted soon!
Also, for some of you who would want to practice SQL questions, check out Hackerrank Platform.
Link: https://www.hackerrank .com/domains/sql
Also, for some of you who would want to practice SQL questions, check out Hackerrank Platform.
Link: https://www.hackerrank .com/domains/sql
For learning the concepts, I would suggest you go through the YouTube tutorial -> https://bit .ly/3pQYxO0
Simply getting to know the concepts won't take you anywhere. Try implementing those topics through regular practice problems.
Happy Learning! :)
Simply getting to know the concepts won't take you anywhere. Try implementing those topics through regular practice problems.
Happy Learning! :)
β’ β’ β’
Missing some Tweet in this thread? You can try to
force a refresh
γ
