2022
Window Functions in SQL - Practical use through Data Analysis
Learn about Window Functions in SQL 2022 through practical examples.
ReadDesign • 26-Apr-2022
2021
Database Documentation
Generate Database Schema Documentation with Vector Image
ReadDesign • 10-Nov-2021
How to Automate Database Tasks Using DbSchema
Learn how to automate database tasks, like schema deployment on multiple databases or generate HTML5 documentation
ReadDesign • 10-Mar-2021
SQL Interview and Exam Questions
SQL Interview and University Exam Questions With Solutions
ReadDesign • 17-Feb-2021
2020
How to Connect to MongoDB Atlas and Design Using Diagrams
Learn how to connect to MongoDB Atlas and visualize the database as diagrams
ReadDesign • 15-Dec-2020
Top 5 Database Design Tools in 2021
In this article, we are going to compare 5 of the best database design tools in 2021.
ReadDesign • 17-Jul-2020
MongoDB Visual Design
In this article, we are going to explore how you can create Virtual Foreign keys for MongoDB with DbSchema.
ReadDesign • 16-Jul-2020
How to Document PostgreSQL Databases
Learn how to document your PostgreSQL database with psql or with DbSchemas intuitive interface
ReadDesign • 14-Jul-2020
Virtual Foreign Keys for MongoDB
In this article, we are going to explore how you can create Virtual Foreign keys for MongoDB with DbSchema.
ReadDesign • 23-Jun-2020
MySQL - How to rename a Database
Learn how you can easily rename a MySQL database using mysqldump
ReadDesign • 10-May-2020
MySQL - How to import a CSV file
Learn how to easily import a csv file to your MySQL database with a simple query.
ReadDesign • 05-May-2020
3 ways to List All Schemas from PostgreSQL
This article contains 3 methods in which you can list all schemas in PostgreSQL
ReadDesign • 27-Apr-2020
MySQL - How to DROP Foreign Key CONSTRAINTS
Learn how you can remove all foreign key constraints from a MySQL table using SQL language.
ReadDesign • 26-Apr-2020
MySQL - What is the Default Username and Password?
In this article, you are going to find the default username and password for mysql and how to reset the password.
ReadDesign • 21-Apr-2020
PostgreSQL - Show Tables [How to]
Learn how to list all tables available in PostgreSQL
ReadDesign • 14-Apr-2020
10+ Essential PostgreSQL Commands
In this article, we are going to list 20 essential PostgreSQL commands to help you manage your databases easily.
ReadDesign • 14-Apr-2020
SQL Server - How to return Date Only from GETDATE
In this article, you will learn two ways that will help you return only the date from GETDATE.
ReadDesign • 13-Apr-2020
Navicat vs DbForge, DbSchema
This article compares the features, price, strengths & weaknesses of 3 database modeling tools: Navicat, DbForge and DbSchema
ReadDesign • 10-Apr-2020
DbVisualizer vs DbSchema
In this article, we compare the main features of DbSchema & DbVisualizer.
ReadDesign • 09-Apr-2020
How to enable remote connections in SQL Server
Step-by-step guide on how to enable remote connections in SQL Server and set the Port
ReadDesign • 07-Apr-2020
Create New User in MySQL & Grant Access - Complete Guide
The easiest way to create a new user in your MySQL database and grant privileges
ReadDesign • 03-Apr-2020
Diagram Design Tips - The Secrets of Indexes & Foreign Keys
In this article, I will present how to use Indexes & Foreign Keys to improve the performance of your database.
ReadDesign • 31-Mar-2020
How to Run MySql in a Docker Container - Step by Step
Learn the easiest way to download & run MySql in Docker Container
ReadDesign • 31-Mar-2020
Relational Data Editor
Learn how to explore databases visually with Relational Data Editor.
ReadDesign • 30-Mar-2020
SQL Views Explained
SQL Views are virtual tables with data derived from one or more base tables. They are not physically stored in the database.
ReadDesign • 29-Feb-2020
2019
Specific Database Issues & Tool Comparisons
This article contains a list of posts that solves specific problems for database design & management
ReadDesign • 01-Dec-2019
PostgreSQL - Generate Random Data
In this article, you will learn how to generate meaningful data for PostgreSQL databases in less than 5 minutes.
ReadDesign • 16-Apr-2019
SQL Interview Questions
SQL Interview Questions for Developers and Database Administrators
ReadDesign • 15-Apr-2019
PostgreSQL - How to Describe Table
In this article, you are going to learn how to perform the equivalent of DESCRIBE TABLE in a PostgreSQL database.
ReadDesign • 15-Apr-2019
How to Drop All Tables from PostgreSQL
In this article, you will learn 3 easy ways to drop all tables from a PostgreSQL database.
ReadDesign • 14-Apr-2019
PostgreSQL - Create a Database Copy
In this article, we are going to learn how to copy a database in PostgreSQL.
ReadDesign • 13-Apr-2019
SQL Server - Insert multiple rows in a query
In this article, we are going to see how to insert multiple rows in a single SQL query.
ReadDesign • 12-Apr-2019
SQL Server - Use MERGE to update tables
Learn how you can update data to a table based on values matched from another table
ReadDesign • 11-Apr-2019