Home » Archives for Mary Zheng

Author Archives: Mary Zheng

Avatar photo
Mary has graduated from Mechanical Engineering department at ShangHai JiaoTong University. She also holds a Master degree in Computer Science from Webster University. During her studies she has been involved with a large number of projects ranging from programming and software engineering. She works as a senior Software Engineer in the telecommunications sector where she acts as a leader and works with others to design, implement, and monitor the software solution.

SQL EXISTS Operator

Bipartite Graph

1. Introduction The SQL EXISTS operator is a logical operator that is used to check whether a subquery returns any row. It returns TRUE if the subquery returns one or more rows, else it returns FALSE. SQL EXISTS operator syntax: WHERE EXISTS ( subquery ) In this example, I will demonstrate the following use cases: In a SELECT statement.In a ...

Read More »

SQL HAVING Clause

Bipartite Graph

1. Introduction A SQL HAVING clause is a part of a SQL SELECT statement that filters out the rows that don’t match the aggregating conditions. Here is the syntax for the HAVING clause in a SELECT statement: HAVING Syntax SELECT select_list [ INTO new_table ] [ FROM table_source ] [ GROUP BY group_by_expression ] [ HAVING search_condition ] [ ORDER ...

Read More »

SQL Server PIVOT Operator Explained

Bipartite Graph

1. Introduction SQL Server has supported the PIVOT operator since version 2005. It is used to generate a multidimensional report by transferring data from the row level to the column level. PIVOT Syntax SELECT <non-pivoted column>, [first pivoted column] AS <column name>, [second pivoted column] AS <column name>, ... [last pivoted column] AS <column name> FROM (<SELECT query that produces ...

Read More »

SQL Server FORMAT() Function

Bipartite Graph

1. Introduction SQL Server provides a format function that returns a formatted value based on the specified format. It is very useful as different countries have different formats for the number, date, and currency. Here is the syntax for the Format function: FORMAT Syntax FORMAT( value, format [, culture ] ) It returns a formatted string and has three arguments: ...

Read More »

SQL Transaction Example

Bipartite Graph

1. Introduction An SQL transaction is a logical unit of one or more SQL statements. A transaction has ACID properties: Atomicity: all or none of changes are performed. For example, when transferring money from one account to another. The two update SQL statements must be performed as a unit. Use both commit and rollback commands.Consistency: data is in a consistent ...

Read More »

SQL Server REPLACE() Function

Bipartite Graph

1. Introduction SQL defines the REPLACE function which takes three required arguments and returns a new string in which all occurrences of the substring are replaced by a new substring. REPLACE(input_string_arg, searching_substring_arg, replacing_substring_arg) input_string_arg – required, the searching source data.searching_substring_arg – required, the substring to be replaced.replacing_substring_arg – required, the replacement substring to be used to replace the searching_substring_arg. Note: ...

Read More »

SQL Add Column Example

Bipartite Graph

In this article, we will explain how to add a column in SQL. 1. Introduction An application’s requirements change over time. Sometimes it needs to increase the size of a column to handle larger data, sometimes it needs a new column to handle additional information. SQL ALTER TABLE statement is used to add, delete, and modify a column, and generally, ...

Read More »

SQL IF Statement Example

Bipartite Graph

1. Introduction Structured Query Language (SQL) supports the IF statement like any other programming language. The IF statement tests a boolean expression. If the expression is true, then the block of statements associated with the IF statement is executed. It can also be used with an ELSE statement; In this example, I will demonstrate how to: Use the IF function ...

Read More »

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 single package that contains the definition of Kubernetes resources and is used to deploy the containerized application with a single helm install or helm upgrade command. In this article, I will explain the basic information that you need to know ...

Read More »

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 has more than 1800 plugins. Jenkins Pipeline is a suite of plugins to support continuous delivery pipelines into Jenkins. In this example, I will demonstrate the following: Install Jenkins and Pipeline pluginConfigure the maven toolBuild simple pipeline jobs to demonstrate with ...

Read More »