Home » Archives for Mary Zheng

Author Archives: Mary Zheng

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 Server REPLACE() Function

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

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

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 »

Java 17 New Features Tutorial

In this article, we will present the new features of Java 17. 1. Introduction JDK 17 is a long-term support (LTS) version and was released on September 14, 2021. It has the following new features: JEP 415: Context-Specific Deserialization FiltersJEP 414: Vector API (Second Incubator)JEP 412: Foreign Function & Memory API (Incubator)JEP 411: Deprecate the Security Manager for RemovalJEP 410: ...

Read More »

Date Format in SQL

In this article, we will explain the Date Format in SQL. 1. Introduction Structured Query Language (SQL) defines the date and time data types. In this example, I will use the MySQL database to demonstrate both date data types and corresponding utility functions. DATE – stores a calendar date in the YYYY-MM-DD format. The valid date ranges from ‘0000-01-01‘ to ...

Read More »

Introduction to SQL Basics

In this article, we will make an introduction to SQL Basics. 1. Introduction Structured Query Language (SQL) is a standardized database language that is used to create, maintain, and retrieve data from a relational database. SQL was initially developed at IBM San Jose Research Laboratory in early 1970. IBM released the first Relational Database Management System (RDBMS) – Multics_Relational_Data_Store in June ...

Read More »

SQL SELECT DISTINCT Statement

In this article, we will explain the SQL SELECT DISTINCT Statement. 1. Introduction The SQL DISTINCT keyword is used to eliminate the duplicate records and return only unique records. Here is the SELECT DISTINCT syntax: SELECT DISTINCT {column1}, {column2}, ... FROM {table_name} [WHERE {condition}] 2. Technologies Used The example code in this article was built and run using: MySQLDocker 3. ...

Read More »

MySQL UPDATE Statement

In this example, I will demonstrate how to use the UPDATE statement to modify values using MySQL. 1. Introduction MySQL is an open-source relational database management system. Here is the UPDATE statement syntax: UPDATE {table_name} SET {assignment_list} [WHERE where_condition] {table_name} – the table name.{assignment_list} – one or more assignments which update records.[WHERE where_condition] – optional condition. 2. Technologies Used The ...

Read More »