Home » Archives for Simran Koul

Author Archives: Simran Koul

Simran has graduated as a Bachelor of Engineering in Computer Science from Chitkara University. She has undergone a 6-months long comprehensive industrial training at the reputed Centre for Development of Advanced Computing (C-DAC), where she worked on a project including the likes of Java, JSP, Servlets while the UI-UX through the pioneering HTML, CSS and JS. Her inquisitive nature and the seed of curiosity keeps her on the toes to find material to write about. Along with her interests in Software Development, she is an ardent reader and always ready-to-write writer.

SQL IN – SQL NOT IN

This article focuses on the functionality and usage of the SQL In and the SQL Not In operators. The first operator filters out rows from the multiple values mentioned in the Where clause. While SQL Not In operator excludes the rows with any of the values from the Where clause. 1. About SQL In and SQL Not In Operators Let ...

Read More »

SQL Like – SQL Not Like

In this article, we will be exploring the SQL Like and the SQL Not Like operators. These operators help in filtering specific patterns from the columns. 1. About SQL Like & SQL Not Like Let us start with understanding what both these operators are. 1.1 What is SQL Like operator? The SQL Like operator is used to filter the data ...

Read More »

SQL Truncate Table Example

In this article, we are going to explain the SQL Truncate Table through examples. While using tables in databases, you may need to delete the data of the entire table. In this article, we will study the SQL Truncate Table command, and use it with an example. We will also understand the difference between the SQL Drop Table command and ...

Read More »

SQL Drop Table Example

While using databases and tables, you may encounter a situation when you will have to drop the table – including the data, and the structure of the table. For this purpose, you will use the SQL Drop Table command. 1. Pre-requisities To implement the examples given in the article, you can use SQL in the following ways. Install MySQL in ...

Read More »

SQL Create Table Example

This article focuses on the functionality and usage of the SQL Create Table command. A Relational Database Management System stores data in form of relations. A relation comprises of tuples and attributes. In layman terms, relation means a table comprising of rows and columns. A tuple is a row, whereas an attribute is a column. 1. Pre-requisites You can implement ...

Read More »

SQL Server Convert function Example

This example will explain the SQL Server Convert function with its syntax and a proper example. SQL Server is relational database management (RDBMS). Microsoft has developed the SQL Server. Many of the Database Management Systems use SQL, and SQL Server is not different. 1. Pre-requisites To run this example, you should have SQL Server downloaded and installed on your local ...

Read More »

How to download Java 10 for Windows

Albeit you can use Java online, it is better to use it on a local machine. This tutorial is about downloading Java 10 on the Windows machine. 1. Downloading Java Google is your friend! Search for “download Java 10” on Google, and hit the button on the first link. Google Search for downloading Java 10 Or, you can also click ...

Read More »

What is Java used for

In this article, we are going to explain what is Java used for through examples and definitions. In the world where technology is evolving at an exponential, do you wonder why we are still using Java? This article will explore the nitty-gritty details about Java and Java programmers. 1. What is Java and what is used for Java is a ...

Read More »

SQL CASE Statement Example

This example will focus on the SQL Case Statement. In any programming language, you would know that the control statements are the most essential part of the programming language. Just like if-else in any of the programming languages, SQL also has the control statements. 1. About SQL CASE Statement There will be a list of conditions, which can either be ...

Read More »

SQL INSERT INTO SELECT Statement Example

In this article, we will explain SQL INSERT INTO SELECT Statement through examples. You might have used a ‘select’ statement, and the ‘insert into’ statement in SQL separately. The select statement is used to fetch data from the database whereas the ‘insert into’ statement inserts data into the table. In this particular example, we will learn the usage of the ...

Read More »