Scribd
Upload
8 views2 pages

Python SQL 30 Day Interview Plan

This document outlines a 30-day study plan to prepare for Python and SQL interviews, dividing the time between the two subjects. It includes daily topics and exercises, progressing from foundational concepts to advanced interview preparation. The plan emphasizes practical coding questions, mock interviews, and revision to build confidence and clarity in both languages.

Uploaded by

n80343974
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
8 views2 pages

Python SQL 30 Day Interview Plan

This document outlines a 30-day study plan to prepare for Python and SQL interviews, dividing the time between the two subjects. It includes daily topics and exercises, progressing from foundational concepts to advanced interview preparation. The plan emphasizes practical coding questions, mock interviews, and revision to build confidence and clarity in both languages.

Uploaded by

n80343974
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

30-Day Python + SQL Interview-Focused Study Plan

Goal: Become interview-ready in Python and SQL with limited time.

Daily Time Split


Python: 1.5–2 hours per day

SQL: 1–1.5 hours per day

Days 1–7: Foundation


Python

1 Day 1: Python intro, syntax, variables, data types, input(), print()


2 Day 2: Operators, if / elif / else
3 Day 3: for loop, while loop, break, continue
4 Day 4: Strings (methods, slicing)
5 Day 5: Lists, Tuples, Sets
6 Day 6: Dictionaries, nested structures
7 Day 7: Revision and small programs

SQL

1 Day 1: What is SQL, SELECT, FROM


2 Day 2: WHERE, AND, OR, NOT
3 Day 3: DISTINCT, ORDER BY, LIMIT
4 Day 4: COUNT, SUM, AVG, MIN, MAX
5 Day 5: GROUP BY
6 Day 6: HAVING
7 Day 7: Revision and practice queries

Days 8–15: Core Interview Topics


Python

1 Day 8: Functions, parameters, return


2 Day 9: Default arguments, keyword arguments, scope
3 Day 10: OOP – class, object, __init__
4 Day 11: Inheritance, Polymorphism
5 Day 12: Encapsulation, Abstraction (theory)
6 Day 13: File handling (read, write, append)
7 Day 14: Exception handling (try, except, finally)
8 Day 15: Full Python revision and coding practice

SQL
1 Day 8: INNER JOIN
2 Day 9: LEFT JOIN, RIGHT JOIN
3 Day 10: FULL JOIN, SELF JOIN
4 Day 11: Subqueries
5 Day 12: IN, BETWEEN, LIKE
6 Day 13: CASE statement
7 Day 14: PRIMARY KEY, FOREIGN KEY
8 Day 15: SQL revision and practice

Days 16–22: Advantage Zone


Python

1 Day 16: List comprehensions


2 Day 17: Dictionary and set comprehensions
3 Day 18: Lambda, map(), filter(), reduce()
4 Day 19: Iterators and generators
5 Day 20: Decorators (basic understanding)
6 Day 21: Built-in functions and time complexity basics
7 Day 22: Python interview question practice

SQL

1 Day 16: Indexes


2 Day 17: Views
3 Day 18: Stored procedures (basic)
4 Day 19: Normalization
5 Day 20: ACID properties
6 Day 21: SQL interview questions
7 Day 22: Mock query practice

Days 23–30: Interview Preparation Only


1 Daily Python coding questions and logic building
2 OOP explanations and common interview questions
3 SQL joins and subquery combination problems
4 Mock interviews and revision
5 Focus on clarity and confidence

You might also like