installing a local instance of a database server (SQL)
Microsoft SQL Server
FOR MAC
[OR YOU COULD INSTALL WINDOWS ON YOUR MAC]
downloading windows operating system software
windows on mac installation guide
FOR WINDOWS
Download
SQL Server Management Studio (SSMS)
SSMS 18.6 is the latest general availability (GA) version of SSMS. If you have a previous GA version of SSMS 18 installed, installing SSMS 18.6 upgrades it to 18.6.
SQL Server Express Installation Guide
other database options
MySQL [link for both windows and mac]
Postgresql [link for both windows and mac]
https://www.enterprisedb.com/postgresql-tutorial-resources-training?cid=47 [for Postgresql training, resources]
GUI/IDE/BUILDER tools/ resources
SQL Workbench (link to community downloads)
https://www.comparitech.com/net-admin/best-sql-query-builders/