SQL Interview Scenarios for ETL & BI Developers Part 1

SQL Interview Scenarios for ETL & BI Developers

4.65 (20 reviews)
Udemy
platform
English
language
Databases
category
Saif Shaikh
instructor
SQL Interview Scenarios for ETL & BI Developers Part 1
186
students
2.5 hours
content
Dec 2020
last update
$34.99
regular price

What you will learn

SQL Queries related to ETL & BI Interviews Part 1

Why take this course?

With this course you will get an exposure to answer interviewers on SQL queries.

I have tried to collate scenarios which i faced in interviews & trying to post on this platform so that it will be helpful for others if they face similar queries while attending their interview in ETL or BI domain.


Understanding of any SQL based DB is required. Try implementing with hands-on, prepare script for source & target tables with DML for source. Write the queries and test results. Understand how these queries are written. Wishing you a great success in SQL.


With this course you will get an exposure to answer interviewers on SQL queries.

I have tried to collate scenarios which i faced in interviews & trying to post on this platform so that it will be helpful for others if they face similar queries while attending their interview in ETL or BI domain.


Understanding of any SQL based DB is required. Try implementing with hands-on, prepare script for source & target tables with DML for source. Write the queries and test results. Understand how these queries are written. Wishing you a great success in SQL.


Have a great learning and if you have any new scenario share those in Q&A.

Will work on it and upload the solution on existing course.

Content

SQL Queries for ETL & BI Developers in Interview

Columns to Rows
Rows to Columns
Multiply Column Values to Rows
Concatenate Email with given group
Read Column Value & repeat it on rows
Convert Single Column to Multiple Columns
Display each month start and end date up to last month of the year
Eradicate duplicate values based on travel distance
Display current quarter data from a given date
Display previous quarter data from a given date
Query to find Previous & Next Month Start and End Dates
Repeat rows based on column count
Merge Statement for Insert & Update
Cumulative Sum of all rows
Find employee count reporting to Manager
Split word into rows containing single character
Columns to Rows with characters
Difference between Rank & Dense_Rank
Find row count and display on each rows
Display Start & End dates of Previous & Next Quarter
Find Cricket Match Schedule
Query to show all the alphabets in Small & Capital letters
Find Read & Write Count & Display Values
Display Filenames with converting columns to rows
Concatenate column values based on group

Screenshots

SQL Interview Scenarios for ETL & BI Developers Part 1 - Screenshot_01SQL Interview Scenarios for ETL & BI Developers Part 1 - Screenshot_02SQL Interview Scenarios for ETL & BI Developers Part 1 - Screenshot_03SQL Interview Scenarios for ETL & BI Developers Part 1 - Screenshot_04

Charts

Price

SQL Interview Scenarios for ETL & BI Developers Part 1 - Price chart

Rating

SQL Interview Scenarios for ETL & BI Developers Part 1 - Ratings chart

Enrollment distribution

SQL Interview Scenarios for ETL & BI Developers Part 1 - Distribution chart

Related Topics

Oracle SQL
3703806
udemy ID
12/14/2020
course created date
12/18/2020
course indexed date
Bot
course submited by