Daily Coding Challenges & Projects

Frontend Mini Project Challenge

Theme : Vue.js Components

Challenge :

Build a Vue.js component for a Todo List with the following features:

• Add a task
• Mark task as complete
• Delete task
• Use v-model, v-for, and v-on

Backend Challenge

Focus : Python, PHP

Python Challenge :

Write a Python script that:

• Reads a CSV file of employees (id, name, salary, department).
• Groups employees by department.
• Prints the average salary per department.

PHP Challenge :

Create a PHP script that:

• Accepts form input (name, email).
• Validates the email format.
• Stores data in a MySQL database table users(name, email).

Database Query Challenge

Problems on SQL - HR Database :

1. Write a query to find the employees who earn more than their department’s average salary.
2. Write a query to list departments with no employees.

Data Structures & Algorithms Challenge

• Easy:
• Problem : Implement a function to reverse a queue using a stack.
• Hint :Queue/Stack
• Medium:
• Problem : Given meeting start and end times, find the maximum number of meetings that can be scheduled in a single room.
• Hint :Greedy + Sorting
• Hard:
• Problem : Given a matrix of integers, find the maximum path sum from top to bottom (moving only down, down-left, or down-right).
• Hint :DP + Matrix Traversal

Bug of the Day

Focus : Python, PHP

Buggy Code ( Python ) :

nums = [1, 2, 3, 4]
for i in range(0, len(nums)):
    if nums[i] % 2 == 0:
        nums.remove(nums[i])
print(nums)

Challenge: Identify and fix the bug(s).

📋 Daily Micro-Project

Focus : Database

Task :

Optimize a SQL query:

 SELECT * FROM employees WHERE salary > 50000 ORDER BY department_id;

• Add indexing strategy to make the query efficient.

Trivia: 5 Fun Facts

1. The first Python version was released in 1991.
2. The first PHP version was created in 1994 by Rasmus Lerdorf.
3. Vue.js was created by Evan You, a former Google engineer.
4. The SQL language was developed at IBM in the 1970s.
5. The term "bug" in computing was popularized by Grace Hopper.

Tool & Resource of the Day

Tool : MySQL Workbench

• Visual database design tool.
• Great for ER diagrams and query optimization.

Resource Roundup :

• MySQL Workbench Docs
• Free SQL Course

Interview Question of the Day

Daily Interview Questions

Frontend :
1. What are Vue.js lifecycle hooks?
2. Explain the difference between v-if and v-show.
3. How does Vue handle reactivity?
4. What is the role of props in Vue components?

Backend :
1. What is the difference between Python’s list and tuple?
2. Explain Python’s GIL (Global Interpreter Lock).
3. What are PHP sessions and cookies?
4. How does PHP handle memory management?

Database :
1. What is a foreign key in SQL?
2. Explain the difference between UNION and UNION ALL.
3. What are triggers in databases?

Others :
1. What is a deadlock in operating systems?
2. Explain the difference between monolithic and microservices architecture.

Daily Quiz Challenge

Frontend :

1. Which directive in Vue.js binds data to an element?
• v-model
• v-bind
• v-for
• v-if
2. Which Vue directive is used for conditional rendering?
• v-show
• v-if
• v-for
• v-bind
3. In CSS, which property is used for grid layout?
• display: flex
• display: block
• display: grid
• display: inline-grid

Backend :

1. Which Python keyword is used for exception handling?
• try/except
• catch
• handle
• error
2. In PHP, which function starts a session?
• start_session()
• begin_session()
• session_start()
• init_session()
3. Which Python data type is immutable?
• List
• Dictionary
• Set
• Tuple

Database :

1. Which SQL statement is used to change a table structure?
• ALTER TABLE
• MODIFY TABLE
• UPDATE TABLE
• CHANGE TABLE

Other :

2. Who is the creator of Python?
• Guido van Rossum
• James Gosling
• Linus Torvalds
• Bjarne Stroustrup

Mixed Quiz :

3. Which of the following is true?
• PHP is compiled before execution.
• Python has no garbage collection.
• Vue.js uses a Virtual DOM like React.
• SQL is object-oriented.

Weekly Cross-Domain Activities ( September 12 to September 18, 2025 )

API of the Day:

Integrate the NASA Astronomy Picture of the Day API and display today’s image.

Linux / DevOps Tip : Use df -h to check disk usage and du -sh for folder sizes.

Real-World Project of the Week ( September 12 to September 18, 2025 )

Project of the Week:

Build a habit tracker app ( Frontend: React/Vue + Backend: Node.js/Scala + DB: PostgreSQL).

Collaborative Project :

Join the open-source project FreeCodeCamp

Case Study :

Study how Netflix handles recommendations using collaborative filtering.