PostgreSQL Basics Cheat Sheet
1. Connecting to PostgreSQL Start PostgreSQL Service sudo systemctl start postgresql Access PostgreSQL Shell psql -U postgres -U – Specifies the user (default is postgres) Exit psql: \q Connect to…
1. Connecting to PostgreSQL Start PostgreSQL Service sudo systemctl start postgresql Access PostgreSQL Shell psql -U postgres -U – Specifies the user (default is postgres) Exit psql: \q Connect to…
1. Connecting to MongoDB Start MongoDB mongod Connect to MongoDB Shell mongosh Connect to a Specific Database mongosh <database_name> Show Current Database db 2. Database Management List All Databases show…
1. SQL Syntax Overview SQL (Structured Query Language) is used to manage and manipulate databases. 2. Database and Table Management 1. Create a Database CREATE DATABASE my_database; 2. Delete a…