SQL Interview Scenarios for ETL & BI Developers Part 1

SQL Interview Scenarios for ETL & BI Developers Part 1, available at $34.99, has an average rating of 4.6, with 24 lectures, based on 24 reviews, and has 195 subscribers.

You will learn about SQL Queries related to ETL & BI Interviews Part 1 This course is ideal for individuals who are ETL & BI Developers It is particularly useful for ETL & BI Developers.

Enroll now: SQL Interview Scenarios for ETL & BI Developers Part 1

Summary

Title: SQL Interview Scenarios for ETL & BI Developers Part 1

Price: $34.99

Average Rating: 4.6

Number of Lectures: 24

Number of Published Lectures: 24

Number of Curriculum Items: 24

Number of Published Curriculum Objects: 24

Original Price: ₹1,199

Quality Status: approved

Status: Live

What You Will Learn

SQL Queries related to ETL & BI Interviews Part 1

Who Should Attend

ETL & BI Developers

Target Audiences

ETL & BI Developers

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.

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.

Course Curriculum

Chapter 1: SQL Queries for ETL & BI Developers in Interview

Lecture 1: Columns to Rows

Lecture 2: Rows to Columns

Lecture 3: Multiply Column Values to Rows

Lecture 4: Concatenate Email with given group

Lecture 5: Read Column Value & repeat it on rows

Lecture 6: Convert Single Column to Multiple Columns

Lecture 7: Display each month start and end date up to last month of the year

Lecture 8: Eradicate duplicate values based on travel distance

Lecture 9: Display current quarter data from a given date

Lecture 10: Display previous quarter data from a given date

Lecture 11: Query to find Previous & Next Month Start and End Dates

Lecture 12: Repeat rows based on column count

Lecture 13: Merge Statement for Insert & Update

Lecture 14: Cumulative Sum of all rows

Lecture 15: Find employee count reporting to Manager

Lecture 16: Split word into rows containing single character

Lecture 17: Columns to Rows with characters

Lecture 18: Difference between Rank & Dense_Rank

Lecture 19: Find row count and display on each rows

Lecture 20: Display Start & End dates of Previous & Next Quarter

Lecture 21: Find Cricket Match Schedule

Lecture 22: Query to show all the alphabets in Small & Capital letters

Lecture 23: Find Read & Write Count & Display Values

Lecture 24: Display Filenames with converting columns to rows

Instructors

Saif Shaikh
Module Lead

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 1 votes
4 stars: 12 votes
5 stars: 10 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu