-
sql
SQL EXISTS Operator
1. Introduction The SQL EXISTS operator is a logical operator that is used to check whether a subquery returns any…
Read More » -
sql
SQL HAVING Clause
1. Introduction A SQL HAVING clause is a part of a SQL SELECT statement that filters out the rows that…
Read More » -
sql
SQL Server PIVOT Operator Explained
1. Introduction SQL Server has supported the PIVOT operator since version 2005. It is used to generate a multidimensional report…
Read More » -
sql
SQL Server FORMAT() Function
1. Introduction SQL Server provides a format function that returns a formatted value based on the specified format. It is…
Read More » -
sql
SQL Transaction Example
1. Introduction An SQL transaction is a logical unit of one or more SQL statements. A transaction has ACID properties:…
Read More » -
sql
SQL Server REPLACE() Function
1. Introduction SQL defines the REPLACE function which takes three required arguments and returns a new string in which all…
Read More » -
sql
SQL Add Column Example
In this article, we will explain how to add a column in SQL. 1. Introduction An application’s requirements change over…
Read More » -
sql
SQL IF Statement Example
1. Introduction Structured Query Language (SQL) supports the IF statement like any other programming language. The IF statement tests a…
Read More » -
Kubernetes
Introduction to Kubernetes Helm Charts
In this article, we explain the basics about Kubernetes Helm Charts. 1. Kubernetes Helm Charts Kubernetes Helm Chart is a…
Read More » -
DevOps
Getting Started with Jenkins Pipeline
1. Introduction Jenkins is an open-source automation server that enables developers to build, test, and deploy their software reliably. It…
Read More »