In this MariaDB tutorial, you will learn about MariaDB Vs SQLite. MariaDB Vs SQLite MariaDB is a fork of MySQL Database, which was created in 2009. In contrast, SQLite is a C library that runs a small, fast, standalone, highly reliable, full-featured SQLite database engine designed in 1995. Here are some of the differences between MariaDB … Read more >>
Do you want to drop the table in SQL Server? No worries. Follow this simple SQL Server tutorial to delete a table in SQL Server Management Studio. This tutorial will teach you how to check the table’s existence before dropping it. How to Drop Table if Exists in SQL Server Let us start with the … Read more >>
Azure SQL provides an option to encrypt your columns if you are storing sensitive data in the database, such as user passwords, credit card numbers, etc. You can use any encryption algorithm to encrypt the data, and only authentic users can decrypt it. How to encrypt a column in Azure SQL In this article, you … Read more >>
In this Oracle tutorial, we will learn about the NVARCHAR2 datatype in the Oracle database and demonstrate how to use it to create NVARCHAR2 columns for a table. NVARCHAR2 in Oracle NVARCHAR2 is a Unicode data type that can store Unicode characters. When the database was created, the national character set was specified as the NVARCHAR2 character set. Variable-length … Read more >>
In this MongoDB tutorial, we will learn how to auto increment id in MongoDB. How to create auto increment id in MongoDB We want the _id field to be in an auto-increment sequence starting from 1, 2, 3, up to n. So consider the following documents. Unlike a relational database, MongoDB doesn’t support auto-increment features. However, we … Read more >>
In this MariaDB tutorial, we will discuss the concept of MariaDB Sharding and look at several related examples. MariaDB Sharding Sharding is a MariaDB technique for dividing a single database server into many pieces. This post will teach you how to shard in the simplest of ways. Each schema is on its database server, and … Read more >>
You must know what is happening in the database if you are a Database Administrator. You need to be aware of the activities going on in the database. Therefore, email notifications can help a lot in monitoring database activities. You can define a notification email triggered when a specific action triggers in the database. How … Read more >>
We will learn how to use the Trigger For Delete SQL Server statement here. To help you understand the idea better, we will also discuss and learn various examples. Trigger for Delete SQL Server In this SQL Server section, we will learn and understand how to use the SQL Server FOR trigger, which is used with the DELETE statement of … Read more >>
In this MariaDB tutorial, we will learn about the basics of MariaDB JSON Functions, and different JSON Functions in MariaDB. MariaDB JSON Function Here, we will learn about the basics of the MariaDB JSON Function. In addition to MariaDB, MariaDB provides the user with one more important feature: MariaDB JSON. The MariaDB JSON function is a … Read more >>
In this MariaDB tutorial, we will look at the differences between MariaDB and Postgres and some examples. MariaDB vs Postgres Open-source RDBMS (Relational Database Management System) such as PostgreSQL or MariaDB are likely to be at the top of the list when a company is looking for a new RDBMS (Relational Database Management System). Each … Read more >>
Download A 40 pages PDF And Learn Now.