Self join Example

Display the hierarchy of all employees with rank

Create employee table

create table emp(
        id int,
                    fname varchar(16),
                    lname varchar(16),
                    e_level int
);

Insert data

joins.xlsx

Create folder if not exist

Sub create_folder_()

'
folder_path = "C:\Users\aashish mittal\Downloads\learnskill"

If Dir(folder_path, vbDirectory) <> "" Then
MsgBox "exist"
Else
MsgBox "not exist"
MkDir folder_path
End If

End Sub

Create file if not exist

Sub check_file_exist()

filePath = "C:\Users\aashish

Read More

Vibe Coding: Good or Bad for Beginners?

Vibe coding is an AI-assisted software development technique, popularized by Andrej Karpathy in early 2025, where developers use natural language prompts to guide large language models (LLMs) in generating, refining, and debugging code, shifting the developer's role from writing code to high-level task management

Read More

The No‑Drama Guide to Deploying FastAPI Project

(Step‑by‑Step)

Project -Store Management

  • User Interface (React)
  • Backend Database (PostgreSQL)
  • Web Framework (FastAPI)

Project view

    Introduction

    Data science is one of the fastest-growing careers, but a common question for beginners is Which programming language should I learn for data science? With Python, R, SQL, Julia, and others in the mix, the answer depends on

    Read More

How Hackers Exploit Call Forwarding Attacks on Mobile Phones (And How to Stay Safe)

In today’s digital era, our smartphones are not just communication tools-they’re gateways to our personal and financial lives. Hackers know this, which is why they’ve devised a clever trick called a Call Forwarding Attack.

Read More

understanding sort() vs sorted() in python

Featuresort()sorted()
Works onLists onlyAny iterable (lists, tuples, dictionaries, strings, etc.)
ReturnsNoneNew sorted list
Modifies original?Yes (in-place)No
Usagelist.sort()sorted(iterable)

sort() example

numbers = [4, 1, 3, 2]
numbers.sort()
print(numbers)  # Output: [1, 2, 3, 4]

sorted()

Read More

Call Now