All Medium Articles

MySQL | LEAD() and LAG() Function

The LEAD() and LAG() function in MySQL are used to get preceding and succeeding value of any row within its partition. These functions are termed… Read More

DBMS-SQL

mysql

SQL-Functions

SQL

MySQL | PARTITION BY Clause

A PARTITION BY clause is used to partition rows of table into groups. It is useful when we have to perform a calculation on individual… Read More

DBMS-SQL

mysql

SQL-Clauses

DBMS

Minimum number of bracket reversals needed to make an expression balanced | Set – 2

Given an expression with only ‘}’ and ‘{‘. The expression may not be balanced. The task is to find minimum number of bracket reversals to… Read More

Parentheses-Problems

Data Structures

DSA

Strings

Number of ways to pair people

Given that there are p people in a party. Each person can either join dance as a single individual or as a pair with any… Read More

Algorithms

Combinatorial

DSA

Dynamic Programming

Find the shortest distance between any pair of two different good nodes

Given a weighted undirected connected graph with N nodes and M edges. Some of the nodes are marked as good. The task is to find… Read More

Competitive Programming

DSA

Graph

Heap

Mathematical

Minimum sum path between two leaves of a binary tree

Given a binary tree in which each node element contains a number. The task is to find the minimum possible sum from one leaf node… Read More

Binary Tree

Data Structures

DSA

Tree

gcc command in Linux with examples

GCC stands for GNU Compiler Collections which is used to compile mainly C and C++ language. It can also be used to compile Objective C… Read More

Picked

Linux-Unix

Sum of all odd factors of numbers in the range [l, r]

Given a range [l, r], the task is to find the sum of all the odd factors of the numbers from the given range.Examples: Input:… Read More

divisors

prefix-sum

sieve

Arrays

DSA

Mathematical

Print n numbers such that their sum is a perfect square

Given an integer n, the task is to print n numbers such that their sum is a perfect square.Examples: Input: n = 3 Output: 1 3… Read More

maths-perfect-square

number-theory

DSA

Mathematical

Check for an array element that is co-prime with all others

Given an array arr[] of positive integers where 2 ? arr[i] ? 106 for all possible values of i. The task is to check whether… Read More

prime-factor

sieve

Arrays

DSA

Mathematical

Introduction to Signals and Systems: Properties of systems

Signal is an electric or electromagnetic current carrying data, that can be transmitted or received. Mathematically represented as a function of an independent variable e.g.… Read More

Computer Subject

NumPy ndarray.__eq__() Method | Compare Array Values to Specific Value

The ndarray.__eq__() method of Numpy compares the values in ndarray to a specific value. It is useful to find which value in ndarray is equal… Read More

Python numpy-ndarray

Python-numpy

Python

Microsoft Interview Experience for Azure Team Hyderabad

Interview was for Azure team IDC Hyderabad. Total 9 candidates came. Round 1: 2->7->8->11 | 13->16->17->21 | 22->23->27->29 | 30->32 Sorted Linked List given like… Read More

Experienced

Experiences

Interview Experiences

atrm command in Linux with examples

atrm command is used to remove the specified jobs. To remove a job, its job number is passed in the command. A user can only… Read More

Picked

Linux-Unix

Maximum subarray sum by flipping signs of at most K array elements

Given an array arr[] of N integers and an integer K, The task is to find the maximum sub-array sum by flipping signs of at… Read More

subarray

subarray-sum

Arrays

Competitive Programming

DSA

Dynamic Programming

Chessboard Pawn-Pawn game

There is an 8*8 chessboard and two chess players having a single pawn each. A player has to move his pawn in each turn, either… Read More

chessboard-problems

Competitive Programming

DSA

Game Theory

Different Approaches to Concurrent Programming in Java

This article shows how to perform concurrent programming using Java threading framework. Let’s analyze concurrent programming first: Concurrent Programming: This means that tasks appear to… Read More

Java-Multithreading

Java

Java Programs

Regular expression to ∈-NFA

Prerequisite – Finite Automata Introduction, Designing Finite Automata from Regular Expression (Set 1) ∈-NFA is similar to the NFA but have minor difference by epsilon… Read More

GATE CS

Theory of Computation

jQuery ajaxError() Method

The ajaxError() method in jQuery is used to specify a function to be run when an AJAX request fails. Syntax: $(document).ajaxError( function(event, xhr, options, exc)… Read More

jQuery-AJAX

Picked

JQuery

Web Technologies

Draw a moving car using computer graphics programming in C

In computer graphics, use graphics.h which provide direct functions to draw different coordinate shapes (like circle, rectangle etc). By using these functions we can draw… Read More

computer-graphics

C Programs

Computer Subject