Home » Archives for Odysseas Mourtzoukos

Author Archives: Odysseas Mourtzoukos

Mourtzoukos Odysseas is studying to become a software engineer, at Harokopio University of Athens. Along with his studies, he is getting involved with different projects on gaming development and web applications. He is looking forward to sharing his knowledge and experience with the world.

SQL Server Tutorial for Beginners

This is a tutorial about SQL Server for beginners. You can also check this tutorial in the following video: SQL Server Tutorial for Beginners – video 1. What is SQL Server SQL Server is a relational database management system (RDBMS) developed by Microsoft. The primary function of the SQL Server is to store and retrieve data used by other applications ...

Read More »

How to use XPath in Python

1. Introduction In this example, we will learn about the XPath and how we can use it in Python to traverse different XML or HTML Files. 2. What is XPath? XPath stands for XML Path Language. It is a major element in the XSLT standard. XPath can be used to navigate through elements and attributes in an XML document. XPath ...

Read More »

SQL vs NoSQL Databases

In this article, we will explain the differences between SQL vs NoSQL Databases. 1. Introduction We will check the relational (SQL) and non-relational (NoSQL) data structures. While both are viable options, there are key differences between the two that users must keep in mind when making a decision. 2. Differences between SQL and NoSQL 2.1 Database Architecture At the most ...

Read More »

SQL Server 2019: Overview and Installation

1. Introduction In this tutorial, we will see some new and key features of SQL Server 2019 and we will write a small example to help you get started. 2. What’s new in SQL Server 2019 2.1 Intelligent Query Processing Enhancements This is a set of enhancements that improves Query Optimizer. Query Optimizer is a component inside SQL Server that ...

Read More »

Java 8 vs Java 12

In this article, we will see a comparison of the Java 8 vs Java 12. 1. What is Java? Java is a programming language first released by Sun Microsystems in 1995. There are lots of applications and websites that will not work unless you have Java installed, and more are created every day. Java is fast, secure, and reliable. From ...

Read More »

Python Join List Example

In this article, we will explain how to use the function Join List in Python through examples. 1. Introduction Python join() function means concatenating an iterable of strings with a specified delimiter to form a string. Sometimes it’s useful when you have to convert an iterable to a string. 2. How to Use join list in Python The syntax of ...

Read More »

List in Python

In this article, we will explain List in Python through examples. 1. Introduction Lists are used to store multiple items in a single variable. List items are indexed, the first item has index [0], the second item has index [1], etc. Also, a list is ordered, which means that the items have a defined order, and changeable, meaning that we ...

Read More »

Java Programming Basics

1. Introduction Java is a high-level, general-purpose, object-oriented, and secure programming language developed by James Gosling at Sun Microsystems, Inc. in 1991. It is formally known as OAK. In 1995, Sun Microsystem changed the name to Java. In 2009, Sun Microsystem takeover by Oracle Corporation. In this tutorial, we are going to learn the basics of Java Programming. We will ...

Read More »

Java Write String to a File

1. Intruduction In this tutorial, we will see different ways that Java offers to write a String into a file. We’ll make use of BufferedWriter, PrintWriter, FileOutputStream, DataOutputStream, FileChannel, and Temporary File, and the advantages that each one gives us. 2. BufferedWriter Example In this example, we will use the BufferedWriter class. The BufferedWriter class can be used to write a String ...

Read More »

SQL Between, MySQL Between Dates, Not Between

In this example, we will see how to use the BETWEEN operator included in the SQL. 1. Introduction The BETWEEN is a logical operator, often used in the WHERE clause of the SELECT, UPDATE, and DELETE statements, and gives us the ability to specify whether a value is in a given range or not. Syntax SELECT column_name(s) FROM table_name WHERE column_name ...

Read More »