SQL
📄 80 Articles10 Must have SQL questions
What are the different Analytic functions available in SQL Server? 2. What are the different Ranking Window functions in SQL […]
Complete path to master SQL before interview
We have interviewed a lot of candidates and found out that SQL is still something which is very less explored […]
10 Questions, 10 Minutes – SQL/R/Python – 3/100
1.What will the following code output? >>> word=’abcdefghij’ >>> word[:3]+word[3:] The output is ‘abcdefghij’. The first slice gives us ‘abc’, […]
Cross Join Unnest and Lateral View Explode
Cross Join Unnest and Lateral View ExplodeThis is the growing age of data and it’s a challenge to store the […]
CROSS JOIN UNNEST in Presto
CROSS JOIN UNNEST in Presto What is Presto and what is the meaning of un-nesting an array?As the data grows, […]
Unnest and Sequence in Presto SQL
Unnest Sequence in Presto SQL helps you to create a sequence of numbers, dates, etc. as a table and then […]
Adobe Analytics Interview Questions – SQL
Adobe Analytics Interview Questions What was the project for? A. The project was to do sentiment analysis on the survey […]
Basic SQL Questions Asked in Analytics Interviews
Topic – Basic SQL Questions Asked in Analytics InterviewsCheck out all the Blogs to Master 200+ Advanced SQL Interview Questions […]
Day 3 | SQL Query Optimization and Data Modeling Interview Questions
SQL Series – This series aim to make sure you are able to learn and understand at least 100 of […]
Machine Learning using SQL – Day 6/100
The below article is the intellectual property of Ashish Kohli. This is one such article which actually powers the ability […]