Enforce Referential Integrity in MySQL With Foreign Keys
In MySQL, referential integrity is a concept that maintains the relationship of data across multiple
Referential IntegrityForeign KeysMySQL
SQL
February 10, 2021
By Francis Ndungu
Articles in category: Database
Page MySQL Data with a Limit Clause
Pagination is the process of sub-dividing a large recordset into multiple manageable pages. In MySQL
Database ManagementSQL QueriesMySQL
SQL
February 2, 2021
By Francis Ndungu
Use MySQL Aggregate Functions in Multiple Tables with Subqueries
MySQL aggregate functions are in-built self-contained modules that perform calculations on multiple
Aggregate FunctionsSubqueriesMySQL
SQL
February 2, 2021
By Francis Ndungu
Retrieve MySQL Running Totals With Subqueries, Windowed Functions and User-Defined Variables
In MySQL, a running total is a derived column that computes one or more columns values while contin
Windowed FunctionsSubqueriesMySQL
SQL
December 23, 2020
By Francis Ndungu
How to Create a Physical Backup and Restore a MySQL Database
In MySQL, you can backup your data either by using a logical or a physical backup. The former makes
Database BackupMySQLDatabase Restore
SQL
July 17, 2020
By Francis Ndungu
Securing MongoDB
MongoDB is not secure by default. If you are installing MongoDB and launching it without configuring
SecurityMongoDBNetwork Interfaces
NoSQL
January 8, 2020
By Anonymous User
How to Install Apache Cassandra 3.11.x on CentOS 7
OpenJDKApache CassandraPython
NoSQL
June 15, 2018
By Feng Li
How to Install and Configure OrientDB Community Edition on CentOS 7
OpenJDKCentOSOrientDB
NoSQL
October 31, 2017
By Feng Li