In this post,I'm going to write the SQL skills which i feel usually required in the day to day responsiblities of a developer.
Topic1: Window Functions
Topic2: CTE and WTH
Topic3: Query Optimization
Topic4: Organized, Clean Syntax
Topic5: User Defined Functions
But for the interview prep specifically you may not need the above 5 but you should have these ready:
1.) COALESCE and CASE WHEN
2.) Subqueries
3.)COUNT DISTINCT
4.)Self Joins
5.)Different join types
Here is a Bonus tip for you:
There are lot of keywords in SQL but do you know they follow up an order of precendence.
From >Join> Where > Group By> Having> Select> Order By> Limit
Happy SQL Learning !
Top comments (0)