Home » Core Java

Core Java

SQL RIGHT JOIN Keyword

Hello. In this tutorial, we will learn the SQL RIGHT JOIN keyword. 1. Introduction SQL stands for Structured Query Language and is used to extract and organize data stored in relational databases like MySQL, PostgreSQL, Oracle, etc. A relational database consists of rows and columns that allow fetching specific information from databases that can be used later for analysis. In ...

Read More »

SQL LEFT JOIN Keyword

Hello. In this tutorial, we will learn the SQL LEFT JOIN keyword. 1. Introduction SQL stands for Structured Query Language and is used to extract and organize data stored in relational databases like MySQL, PostgreSQL, Oracle, etc. A relational database consists of rows and columns that allow fetching specific information from databases that can be used later for analysis. In ...

Read More »

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 Create a Table in MySQL

In this article, we explain how to create a table in MySQL. 1. Introduction MySQL database is used by developers as a database. Data can be read by different applications from the MySQL database. MySQL database is an open-source relational database. 2. MySQL Database – Table Creation Mysql database is used for data creation and storing the data. 2.1 Prerequisites ...

Read More »

Java 8 Stream API – limit() & skip() Example

Hello. In this tutorial, we will explore the Stream API: limit() and skip() methods introduced in Java 8. 1. Introduction Before diving deep into the practice stuff let us understand the methods we will be covering in this tutorial. The skip() method discards the first n elements of a stream. n cannot be a negative number and if it is ...

Read More »

Java 8 Stream API – distinct(), count() & sorted() Example

Hello. In this tutorial, we will explore the Stream API methods: sorted(), count(), and distinct() methods introduced in Java 8. 1. Introduction Before diving deep into the practice stuff let us understand the methods we will be covering in this tutorial. The distinct() method returns a stream of unique elements. It is a stateful intermediate operation and returns a new ...

Read More »

Download and Install SQL Server Management Studio

In this article, we’re going to the steps to download and install the Microsoft SQL Server Management Studio (SSMS). 1. SSMS System Requirements SQL Server Management Studio (SSMS) is a powerful application maintained and distributed by Microsoft that is used for configuring, managing, and administering all components within Microsoft SQL Server. The application was first launched with Microsoft SQL Server 2005 ...

Read More »

Java 8 Functional Interface – BiPredicate Example

Hello. In this tutorial, we will explain the BiPredicate functional interface in Java 8. 1. Introduction Java 8 BiPredicate functional interface represents a method that accepts two input arguments and returns a boolean output. Represented by the method syntax – boolean test(T t, U u). This interface also provides some default methods like – default BiPredicate or(BiPredicate other) – Composed ...

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 »

SQL vs NoSQL Databases

In this article, we will explain the differences between SQL vs NoSQL Databases. You can also check this tutorial in the following video: SQL vs NoSQL Databases – video 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 ...

Read More »