ETL Testing | Tricky SQL Queries | Interview SQL Queries

#etlqalabs #etl #sqlinterviewquestionsandanswers #linux

ETL Testing | Tricky SQL Queries | Interview SQL Queries

Playlists for your reference:
ETL Testing Tutorial for begginers and advanced level :

SQL Tutorial for begginers and advanced level :

Linux Tutorial for beginners and advanced level:

Data Warehousing Tutorial for beginners and advanced level:

Hey Guys,
If you’re enjoying this video and you’d like to support this channel, please do to consider subscribe this channel! It might seem small, but hitting that subscribe button helps alot and means more contents in future.

[shefaliwdw]

Lucky to find this channel, you explain concept very clearly and got very good understanding of concepts after watching your videos.

[VS-Studios_]

Thank you sir for your very detailed explanation, , keep up the same momentum
can you help me with below use case
How to extract part of string after specific character?
Example:
124.34
11.24
in the above numbers, i want query to extract after DECIMAL point

[ankitasrivastava]

I find this is also close to wt is told in the video for 2nd question:

select cust_id, cust_name, order_id, order_date, product_id, product_name from
(select c.cust_id, c.cust_name, c.order_id, c.order_date, c.product_id, p.product_name, dense_rank() over(partition by c.cust_id order by c.order_date desc) dr
from customer c inner join product p on c.product_id=p.product_id) where dr=1;

[polasapraveen]

Hi Sir, its a grate learning platform.. you are explaining in detail.

sir I have a interview question : 'ETLQALABS' this name need to spilt into individual letter and create separate column for each letter...
like: E | T | L |... Pls can you explain sir.

[SANJAYYADAV-hmbs]

Hello sir,
In the first SQL query, can you please explain when there are multiple months salary data.
The SQL that you solved will work only for one month salary.
What if want to sum salary by each month??

[Skv]

Your videos are very helpful. Also it will be more helpful if you add more probable question could be asked in interview on same table

[ankitasrivastava]

i too have one question..
if there is a table having temp data for multiple cities for e.g. 6 months(the data is present for each day in the table).. so there are three columns city_name, date, temp
now we want to fetch the Average_temp(month_wise) of the cities for the last three months.
please help me on this.

[ankitasrivastava]

is it mandatory to use 'dept' in the query for the monthly_sal question?

[ravishinde]

I want to become an ETL Developer. Please suggest an ETL Developer course for me.