DEV Community

Cover image for SQL tips that will make you productive from day1 at your job.
Aditya Sharan
Aditya Sharan

Posted on

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 !

Top comments (0)