# Author: Vijay Sinha

- 08 October
### How to Compare Dates in SQL

Agenda This article will look at yet another interesting topic in SQL commonly asked in interviews – How to Compare Dates or Date type date in SQL. We will look at different approaches with examples for a clear description. At first, let’s have a quick look at the Date data type in SQL. Introduction to […]

- 29 July
### nvarchar vs varchar in SQL Server

This article will look at the difference between the data types NVARCHAR and VARCHAR in SQL Server. These data types are commonly used for storing textual data or strings for various design purposes. We will look at the description of each along with the best-case scenario to use each data type with practical examples. We […]

- 30 June
### Difference between WHERE and HAVING clause in SQL

In this article, we will look at the difference between the WHERE and HAVING Clause in SQL. This is an important question asked in Interviews so we will look at each Keyword in detail with sample queries and compare their differences. At first, let us look at the description of the WHERE and HAVING Clause. […]

- 18 June
### Maximum Number of Vowels in a Substring of Given Length

In this article, we will look at an interesting problem related to the Strings and [Sliding-Window Algorithm](https://java2blog.com/sliding-window-maximum-java/ “Sliding-Window Algorithm”). The problem is : "Given a String we have to Find the Maximum Number of Vowel Letters present in any Substring of the String, with the length of each Substring equal to K." Let us understand […]

- 04 June
### Search for a range Leetcode – Find first and last position of element in sorted array

In this article, we will look into an interesting problem asked in Coding Interviews related to Searching Algorithms. The problem is: Given a Sorted Array, we need to find the first and last position of an element in Sorted array. This problem is also known as Search for a range on Leetcode. We will look […]

- 20 May
### Rotate Matrix by 90 degrees in java

In this article, we will look into another interesting problem related to 2D Arrays. Given a Matrix of N X N Dimension we have to Rotate matrix by 90 degrees. We will perform Rotation both Clockwise i.e. Right Rotation and Anti-Clockwise i.e. Left Rotation respectively. We will discuss each operation in detail along with a […]

- 30 April
### Top 20 Java Projects for Beginners

This tutorial provides the top 20 java projects for beginners for practice. These projects will help you to learn java quickly and efficiently.