How to work with dates and times in SQL
Introduction When working with relational databases and Structured Query Language (SQL), you may…
How to use Joins in SQL
Introduction Many database designs organize information into tables based on relationships between specific data points.
How to insert data into SQL
Introduction Structured Query Language, more commonly known as SQL, offers great flexibility…
Understanding the limitations of SQL
Introduction When designing a database, there may be times when you want to impose restrictions on the data…
How to set up a remote database to optimize site performance with MySQL on Ubuntu 18.04
Introduction As your app or website grows, it may reach a point where…
How to repair corrupted tables in MySQL
Introduction Sometimes, MySQL tables may become corrupted, meaning that an error has occurred and…
How to allow remote access to MySQL
Introduction Many websites and applications with their own web server and database…
Create and connect to a MySQL database with Amazon RDS
Introduction In this tutorial, we will learn how to create an environment to run a MySQL database (we will use this environment as an example…
Deploy and configure Amazon Lightsail MySQL database
Introduction In this tutorial, you will deploy a database in Amazon Lightsail that can…
How to import and export databases in MySQL or MariaDB
Introduction: Importing and exporting databases is a common task in software development. You can use dump data…