Home » Archives for Mary Zheng » Page 2

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.

Java 17 New Features Tutorial

Bipartite Graph

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

Bipartite Graph

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

Bipartite Graph

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

Bipartite Graph

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

Bipartite Graph

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 »

SQL UNION Operator

Bipartite Graph

In this article, we will explain the SQL UNION Operator through examples. You can also check this tutorial in the following video: SQL Union Operator Tutorial – video 1. Introduction SQL UNION operator combines results from two select statements into a single result which includes all unique rows. UNION ALL includes duplicated rows in the combined result. The syntax is ...

Read More »

Microservices Architecture Tutorial

1. Introduction Microservices architecture builds an application with many loosely coupled and independently deployable artifacts. In this example, I will demonstrate a simplified microservices architecture with two services. Figure 1 Simplified MSA The course service runs at port 9001.The student service runs at port 9002.The student service depends on the course service.The Eureka Server runs at port 8761. 2. Technologies ...

Read More »

How to Download and Install Java 16

Bipartite Graph

In this article, we will explain how to Download and Install Java 16. 1. Introduction Oracle released JDK 16 on March 16, 2021. Let’s see how to download and install Java 16 (Oracle JDK 16). 2. Download Oracle JDK 16 In this step, I will download the installer from the Oracle website. First, open a web browser and navigate to ...

Read More »

SOA vs Microservices: What’s the Difference?

In this article, we will see a comparison between SOA vs Microservices and their basic differences. 1. Introduction A service is a single software unit that performs business tasks. Service-oriented architecture (SOA) is a software architecture where distinct components of an application provide services to other components via a communications protocol over the network. SOA composes a complex application by ...

Read More »

Microservices Tutorial for Beginners

This is a tutorial for beginners about Microservices. 1. Introduction Dr. Peter Rogers spoke about “micro web services” at a cloud computing conference in 2005. A workshop of software architects held near Venice in May 2011 used the term “microservice” to describe a common architectural style. IBM defines microservices as an architectural approach to deploying a single application with many ...

Read More »