Three Amazing SQL Functions in PostgreSQL and Amazon Redshift

In this video we will discuss 3 Awesome SQL functions which are present in PostgreSQL and its derivatives like redshift and snowflake. Do hit like button if you think these functions are sexy.

Zero to hero(Advance) SQL Aggregation:

Most Asked Join Based Interview Question:

Solving 4 Trick SQL problems:

Data Analyst Spotify Case Study:

Top 10 SQL interview Questions:

Interview Question based on FULL OUTER JOIN:

Playlist to master SQL :

Rank, Dense_Rank and Row_Number:

#sql #dataengineer #function

[sharu]

Thanks Ankit! This is indeed interesting 😊

[shubhashish]

I was aware of split_part function only. Just got to know about the others. ilike is going to very useful for me. I am learning and working on Redshift in my project. Thanks a lot Ankit. Doing a great job.

[saurabhpandey]

Hey Ankit, Can you please make a video on the order of execution of SQL Clauses. That would be really helpful.

[gijane]

Damn. Postgre and Redshift are baap of sql server and others. Looks like what python did to other programming languages by easing all the commands. Redshift is doing similar to that

[chandraprakash]

Hi Ankit that was very helpful.
I am working on a project in Redshift but i am facing bit challenge in pattern match code like
'^([a-z]+[-.s\\']?)*+$' ...is used in HIVE how can I convert it into Redshift pattern ?

[vandana]

Hi Ankit i recently joined xxx company as data engineer as fresher, in that company they are not providing me the training but they gave me 2 months time to learn required skills for data engineer. Could you help me with this, can you please share a video regarding what are the skills required for data engineer, it will be very helpful for me if you do a video for this

[PradyutJoshi]

Can we use order by in listagg function?

[maxnijhof]

Use Command + D to duplicate line to avoid copy pasting

[gitagyan]

Toh kahna kiya chahate ho oracle and MSSQL chorke ye Redshift and Postgre SQL learn karein due to writing the functions😂

[palashgupta]

I have a input parameter in store procedure
I have to query that it's a comma seperated string, but I don't know the part-index how to proceed further without having an index @ankitbansal