Database Backup and Restore Explained Simply (SQL Server, MySQL and PostgreSQL)
How database backups work: full, differential and log backups, point-in-time restore, the 3-2-1 rule, and commands for SQL Server, MySQL and PostgreSQL.
PostgreSQL
SQL Triggers Explained Simply (With a Price History Example)
Learn what SQL triggers are, how to write them in SQL Server, MySQL and PostgreSQL, and when they help or hurt, with a price history example.
SQL Data Types Explained Simply: Choosing the Right Type for Each Column
A practical guide to SQL data types: numbers, text, dates and more, with differences between SQL Server, MySQL and PostgreSQL.
SQL Stored Procedures Explained Simply (SQL Server, MySQL and PostgreSQL)
Learn what stored procedures are, how to create and run them in SQL Server, MySQL and PostgreSQL, and when they are worth using.
How to Choose the Right Database Server for Your Project
You’ve learned about MySQL, PostgreSQL, and SQL Server. Now comes the real question: which one should you actually use? This
MySQL vs PostgreSQL — Which Should You Use?
MySQL and PostgreSQL are the two most popular open-source relational databases in the world. Both store data in tables. Both
PostgreSQL Explained for Beginners — What Makes It Different?
If MySQL is the most popular database on the web, PostgreSQL is the one developers love most. Year after year,