Home » Core Java » sql

sql

SQL Constraints Example

Welcome readers, in this tutorial, we will understand the different SQL Constraints that maintain the data integrity inside a database table. 1. Introduction SQL Constraints are the restrictions that help maintain the data integrity inside a database table. Constraints can be divided into column level (i.e. limiting only column data) or table level (i.e. limiting whole data in a database ...

Read More »

SQL Clone Database Example

Welcome readers, in this tutorial, we feature a comprehensive article in SQL clone database. Specifically we will understand how to clone an existing database and its content. 1. Introduction In SQL, Database Cloning represents a feature of ensuring backup of all or specific databases. The feature is implemented for purposes, Data restore that was mistakenly modified or deleted For application ...

Read More »

SQL Primary Key Example

Welcome readers, in this tutorial, we will understand the SQL Primary Key column that uniquely identifies a tuple in the database table. 1. Introduction SQL Primary Key is a column or multiple columns that uniquely identify a tuple in the database table. It contains unique values but cannot have null or duplicate It consists of multiple columns known as a ...

Read More »

SQL Data Types Tutorial

1. Introduction SQL is the language used to communicate with Relational Databases such as MySQL, Oracle, MS SQL Server, PostgreSQL, etc. In this post, we will examine the various SQL Data Types and provide examples for MySQL, which is the most widely used open-source database. This post requires some knowledge in SQL and a tutorial for a complete understanding of ...

Read More »

MySQL Python Example

1. MySQL Python – Introduction In this post, we feature a comprehensive Tutorial on integrating MySQL in a simple Python application based on Flask and execute basic CRUD operations with the same. MySQL is one of the most used SQL databases in many of the world-enterprise applications due to its ability to manage transactions and the ACID-behaviour which is built into its ...

Read More »

MySQL NodeJS Example

1. Introduction In this post, we feature a comprehensive Tutorial on integrating MySQL in a simple NodeJS application and execute basic CRUD operations with the same. MySQL is one of the most used SQL databases in many of the world-enterprise applications due to its ability to manage transactions and the ACID-behaviour which is built into its core. One of the reasons MySQL ...

Read More »

MySQL Triggers Tutorial

1. Introduction In this post, we feature a comprehensive Tutorial on MySQL Triggers and how do they work. MySQL is one of the most used SQL databases in many of the world-enterprise applications due to its ability to manage transactions and the ACID-behaviour which is built into its core. One of the reasons MySQL is so popular is due to the easiness ...

Read More »

MySQL Most Popular Functions Tutorial

1. Introduction In this post, we feature a comprehensive Tutorial on MySQL Most Popular Functions. MySQL is one of the most used SQL databases in many of the world-enterprise applications due to its ability to manage transactions and the ACID-behaviour which is built into its core. One of the reasons MySQL is so popular is due to the easiness it provides ...

Read More »

MySQL Full-text Search Tutorial

1. Introduction MySQL is one of the most used SQL databases in many of the world-enterprise applications due to its ability to manage transactions and the ACID-behaviour which is built into its core. One of the reasons MySQL is so popular is due to the easiness it provides for its usage and its related commands. In the open source web application ...

Read More »

MySQL Replication Tutorial

1. Introduction MySQL is one of the most used SQL databases in many of the world-enterprise applications due to its ability to manage transactions and the ACID-behaviour which is built into its core. One of the reasons MySQL is so popular is due to the easiness it provides for its usage and its related commands. In the open source web application ...

Read More »