Real questions from top companies in SQL · medium
Analyze the output of various joins (LEFT, RIGHT, INNER, CROSS, FULL OUTER) on the given tables.
Calculate the cumulative transaction amount for each month using a transaction table.
Can you describe a project where you handled large volumes of data?
Can you modify a partitioned table into a non-partitioned one and vice-versa? How?
Check for duplicates in a table.
Coalesce function in SQL - explain
Compare Airflow's @daily vs once trigger scheduling.
Compare OLTP and OLAP systems in the context of financial transactions.
Compare PostgreSQL vs Snowflake. How do they handle duplicate record errors?
Compare the star schema and snowflake schema. Which one would you use for reporting at Swiggy, and why?
Connecting BigQuery with Linux
Count records for INNER JOIN and LEFT JOIN
Create data models for storing users, artists, and related data for music platform
Create partitioned table
Delete vs. Truncate in Snowflake?
Demonstrate how to use a LEFT JOIN to combine data from two tables and handle null values.
Describe a scenario where you disagreed with a product or business team. What did you do?
Describe a scenario where you would use a CROSS JOIN vs. an INNER JOIN.
Describe how Dataproc integrates with BigQuery for processing large datasets.
Describe how partitioning helps improve query performance in a large dataset.
Type or paste your answer to any of these questions and our AI Coach scores it, highlights gaps, and rewrites it at FAANG quality. Free to try.