Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Data and SQL Query Concepts

MediumSQL & Data Manipulation00:00
I
Practice interviewer
Your interviewer
In session
I
Interviewer

Welcome to your interview.

The question is on your right: Data and SQL Query Concepts. Take a moment with it first.

Talk your thinking through with me if you like - when you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes). Discussion and graded submissions share your five interviewer interactions, so spend them well.

You need to log in / sign up to chat or submit.

Problem

Explain the difference between UNION and UNION ALL, DELETE and TRUNCATE, and EXISTS and IN. Also, name types of joins and an ETL tool.