Code Weekend

Code WeekendCode WeekendCode Weekend

Code Weekend

Code WeekendCode WeekendCode Weekend
  • Home
  • SQL
  • PYTHON
  • PYSPARK
  • FAQ
  • More
    • Home
    • SQL
    • PYTHON
    • PYSPARK
    • FAQ
  • Home
  • SQL
  • PYTHON
  • PYSPARK
  • FAQ

Comprehensive SQL Interview Preparation: Daily Challenges

A structured 14-day program designed to systematically prepare candidates for SQL technical interviews. Each day focuses on a core SQL concept through 15 progressive problems, using realistic datasets aligned with modern data platforms (Databricks/Redshift). 

Instructions (docx)Download
Day 1 - Query fundamentals (SELECT, WHERE, ORDER BY, LIMIT) (txt)Download
Day 2 - Arithmetic , Comparison and Logical operators (txt)Download
Day 3 - GROUP BY and Aggregate Functions (txt)Download
Day 4 - Table Joins (INNER, LEFT, Multi-table) (txt)Download
Day 5 - Advanced Joins (RIGHT, FULL OUTER, Self Joins) (txt)Download
Day 6 - CTEs and Subqueries (txt)Download
Day 7 - Window Functions and Ranking (txt)Download
Day 8 - Time-Series Window Functions (txt)Download
Day 9 - Date/Time Functions and Calendar Logic (txt)Download
Day 10 - Conditional Logic with CASE Statements (txt)Download
Day 11 - Data Manipulation Language (DML) Operations (txt)Download
Day 12 - Delta Lake Operations (Databricks Specific) (txt)Download
Day 13 - Redshift Performance Optimization (txt)Download
Day 14 - Advanced Grouping and Pivoting Operations (txt)Download

Daily Challenge Answers

For optimal results: Solve all problems independently first. Solution keys are meant for validation, not substitution of the learning process. 

Day 1 - Answers (txt)Download
Day 2 - Answers (txt)Download
Day 3 - Answers (txt)Download
Day 4 - Answers (txt)Download
Day 5 - Answers (txt)Download
Day 6 - Answers (txt)Download
Day 7 - Answers (txt)Download
Day 8 - Answers (txt)Download
Day 9 - Answers (txt)Download
Day 10 - Answers (txt)Download
Day 11 - Answers (txt)Download
Day 12 - Answers (txt)Download
Day 13 - Answers (txt)Download
Day 14 - Answers (txt)Download
  • Home
  • SQL
  • PYTHON
  • PYSPARK

Copyright © 2025 Code Weekend - All Rights Reserved.

Powered by

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.

DeclineAccept

Practice Daily – Free Coding Drills

Sharpen your SQL & Python skills with free daily challenges. Bite-sized problems, real-world datasets, and instant solutions to level up your coding game. 

Learn more