Scribd
Upload
339 views3 pages

JMAN Coding Preparation Python SQL

The document outlines a coding preparation guide for JMAN interviews focusing on Python and SQL. It includes practice questions categorized by topics such as strings, arrays, hash maps, sorting, and searching for Python, as well as SQL concepts like joins, aggregates, subqueries, and filtering. It also recommends using platforms like LeetCode, HackerRank, and SQLZoo for additional practice.

Uploaded by

kondetivineetha
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
339 views3 pages

JMAN Coding Preparation Python SQL

The document outlines a coding preparation guide for JMAN interviews focusing on Python and SQL. It includes practice questions categorized by topics such as strings, arrays, hash maps, sorting, and searching for Python, as well as SQL concepts like joins, aggregates, subqueries, and filtering. It also recommends using platforms like LeetCode, HackerRank, and SQLZoo for additional practice.

Uploaded by

kondetivineetha
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
You are on page 1/ 3

JMAN Interview Coding Preparation (Python + SQL)

Python DSA Practice Questions (Topic-Wise)

1. Strings

- Check if a string is a Pangram.

- Count frequency of characters in a string.

- Group anagrams together.

- Replace vowels in a string.

- Reverse a string without using built-in functions.

- Split words by even/odd length and print them.

2. Arrays / Lists

- Remove duplicate elements from a list.

- Remove elements that appear more than once.

- Merge intervals (like meeting room problems).

3. Hash Maps

- Group words by anagram (use dictionary as hash map).

- Frequency map of characters.

4. Sorting and Searching

- Custom sort strings.

- Sort based on length or frequency.

5. Patterns
JMAN Interview Coding Preparation (Python + SQL)

- Print pyramid, diamond, or hourglass using nested loops.

Practice each with Python using lists, dicts, sets, and string operations.

SQL Questions to Practice

1. Joins

- INNER JOIN to find matching data in two tables.

- LEFT JOIN to find unmatched records.

- Practice writing queries with multiple JOINs.

2. Aggregates & Group By

- Count, MAX, MIN, AVG, SUM by group.

- Total salary by department.

3. Subqueries

- Get 2nd or 3rd highest salary.

- Find employees earning above average salary.

4. Filtering & Sorting

- WHERE conditions with IN, BETWEEN, LIKE.

- ORDER BY salary DESC.

5. Common Questions
JMAN Interview Coding Preparation (Python + SQL)

- Top N per group (e.g. highest scorer per class).

- Find duplicates in a table.

- Fetch nth row using LIMIT/OFFSET.

Use practice platforms like LeetCode, HackerRank, SQLZoo.

You might also like