SQL tips that will make you productive from day1 at your job.

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 !