Home » Core Java » sql

sql

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 »

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 »

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 »

What is SQL and how does it work?

Hello. In this tutorial, we will learn and understand what SQL is and how does it work. 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 ...

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 »

How to Download and Install MySQL

In this article, we’re going to see how to download and install MySQL using the default installer. Also, we’ll set up the server using the auto start package and do some examples. 1. Download MySQL Installer As Linux/macOS-based system user, I commonly use a package manager like Home Brew and APT in the terminal to install software that I need. ...

Read More »