How to Delete a Row in SQL
In this post, you’ll learn how to delete a row in SQL and how to delete all rows in a table.
How to Count Distinct Values in SQL
In this article, you’ll learn how to count the number of unique values in a column.
How to Install Postgres on Mac Using Homebrew
Installing PostgreSQL on a Mac can be done using the Terminal and using something called “homebrew”. In this article, you’ll see step-by-step instructions on how to install PostgreSQL using Homebrew.
Solution for Homebrew PostgreSQL Service Not Starting
If you’re on a Mac and trying to run Postgres using Homebrew, you might have problems starting the service. In this post, I’ll explain the issue and the solution.
How to Install MySQL on Windows
In this post, you’ll learn how to install a MySQL database on Windows and connect to it using MySQL Workbench. Let’s get started.
How to Set Up the Oracle Cloud Free Tier
Do you want to create an Oracle database to use for free? Oracle offers a cloud-based Oracle Cloud Free Tier database which you can sign up for and access using a tool like SQL Developer on your own computer, all for free. Learn how in this article.
How to Install Postgres on Windows
In this guide, you’ll learn how to download PostgreSQL for Windows, install it, and use pgAdmin to connect to the database.
How to Install SQL Server Express (& SSMS)
In this post, you’ll see the step-by-step process to download and install SQL Server Express, install SQL Server Management Studio, and connect to the database. Let’s get started.
How to Install MySQL on Mac using a DMG File
In this article, you’ll learn how to install MySQL on a Mac using an installation package, otherwise known as a DMG file.
How to Install MySQL on Mac using Homebrew
Installing MySQL on a Mac can be done using the Terminal and using something called “homebrew”. In this article, you’ll see step-by-step instructions on how to install MySQL using Homebrew.