Scribd
Upload
4 views3 pages

Python SQL 15 Day Plan

This document outlines a 15-day preparation plan for Python and SQL interviews. Each day includes specific coding challenges, SQL queries, and theoretical concepts to study. The plan covers a range of topics from data structures to advanced SQL functions and programming principles.

Uploaded by

Shiva Nayaka
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views3 pages

Python SQL 15 Day Plan

This document outlines a 15-day preparation plan for Python and SQL interviews. Each day includes specific coding challenges, SQL queries, and theoretical concepts to study. The plan covers a range of topics from data structures to advanced SQL functions and programming principles.

Uploaded by

Shiva Nayaka
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

15-Day Python + SQL Interview Prep Plan

Day 1:

Python: Second largest number in list

SQL: Second highest salary

Theory: List vs Tuple vs Set vs Dictionary

Day 2:

Python: Frequency of elements

SQL: Duplicate records

Theory: Time Complexity

Day 3:

Python: Anagrams

SQL: Salary > average

Theory: Mutable vs Immutable

Day 4:

Python: Max sum subarray (k)

SQL: Top 3 salaries

Theory: Generators

Day 5:

Python: Palindrome

SQL: WHERE vs HAVING

Theory: List comprehension

Day 6:

Python: First non-repeating char

SQL: Count per department

Theory: Decorators

Day 7:

Python: Merge sorted lists


SQL: Nth highest salary

Theory: Deep vs Shallow copy

Day 8:

Python: Group anagrams

SQL: Running total

Theory: Iterators vs Iterables

Day 9:

Python: Move zeros

SQL: Salary > manager

Theory: Exception handling

Day 10:

Python: Find duplicates (no extra space)

SQL: Top 2 per department

Theory: Normalization

Day 11:

Python: File word count

SQL: Delete duplicates

Theory: Indexing

Day 12:

Python: Bank Account class

SQL: INNER vs LEFT JOIN

Theory: OOP pillars

Day 13:

Python: LRU Cache

SQL: ROW_NUMBER remove duplicates

Theory: Window functions

Day 14:

Python: Multithreading example


SQL: Missing IDs

Theory: Threading vs Multiprocessing, GIL

Day 15:

Python: Multiprocessing squares

SQL: Daily active users

Theory: CPU vs IO bound

You might also like