MySQL provides the facility to execute events at a specific time. Click here to learn how you can enable, create MySQL events, and execute MySQL event scheduler.
Read More About MySql Event Scheduler

Flyway is an open-source database migration tool. Anyone with a basic knowledge of SQL can use Flyway for database migrations. Read further to know more.
Read More About Database Migration Using Flyway

Now, ready to upgrade database Liferay 6.2 to 7.1, Liferay 7.1/DXP gives upgrade tool to upgrade everything. It’s the best, most comprehensive thanks to upgrade tool provided by Liferay. Please follow below steps to upgrade database(Steps are given for both Ubuntu/Window). Steps Create a new database for Liferay 7.1/DXP in MySQL server e.g. create database ...
Read More About Liferay Database migration from 6.2 to 7.1/DXP

Information is a very confidential thing in today's era to protect that from unauthorize and unauthenticated access to secure that data we should encrypt and decrypt that data. Here are the steps to encrypt and decrypt your data in the database at a column level.
Read More About Column level Encryption and Decryption in MSSQL

Want to perform an action in the database before/after INSERT, UPDATE, and DELETE statement? Here are the steps to create a table trigger in the database.
Read More About Table Trigger In MySQL

As we all know, Replica is nothing but just a copy of something and the process to create a replica of something is called Replication. Now let’s define the term Database Replication. Database Replication Database Replication is a technique to transfer the exact replica of each database instances from a database to other databases located in the same or different server to provide ...
Read More About Database Replication