How to Use Materialized Views in PostgreSQL
: About Views and Materialized Views For a complex SQL query, it is impractical to rewrite the entir
PostgreSQLMaterialized ViewsDatabase Management
SQL
December 1, 2022
By Arun Nanda
Articles in category: SQL
How to Restore a Single Database from a Full MySQL Database Dump
MySQL Dump is a backup utility used to recover your databases and tables in case your database serve
Database DumpDatabase RestorationMySQL
SQL
October 31, 2022
By Nathan Olupot
How to Use the JSON Data Type with PostgreSQL on Ubuntu 20.04
JavaScript Object Notation (JSON) is a modern data exchange format often used in API-based services.
PostgreSQLJSONUbuntu
SQL
September 16, 2022
By Francis Ndungu
How to Repair a Corrupted MySQL Table
MySQL is a Relational Database Management System (RDBMS). An RDBMS is a database management system (
InnoDBDatabase RepairMySQL
SQL
September 16, 2022
By Josh Amata
How to Work With PostgreSQL Joins
A PostgreSQL JOIN models logical relationships when retrieving data from multiple normalized databas
PostgreSQLSQL JoinsDatabase Management
SQL
June 9, 2022
By Francis Ndungu
How to Use Views and Stored Procedures in MySQL
SQL views and stored procedures allow storing SQL statements as an object in the database. You can r
Stored ProceduresSQL ViewsMySQL
SQL
June 9, 2022
By Anonymous User
How to Perform Full-Text Search on a PostgreSQL Database
A PostgreSQL full-text search allows you to find records that match certain keywords with a high deg
PostgreSQLDatabase ManagementFull-Text Search
SQL
April 14, 2022
By Francis Ndungu
Using Primary Keys, Indices, and Composite Keys in MySQL
In MySQL, a primary key is a field that uniquely identifies each record in a table. For instance, st
Primary KeysComposite KeysMySQL
SQL
February 28, 2022
By Francis Ndungu