/sqlcourse

SQLCourse with PostgreSQL and Docker

Primary LanguageTSQL

SQLCourse with PostgreSQL and Docker

Content

SQLCourse

  • Selecting data
  • Creating tables
  • Inserting into a table
  • Updating records
  • Deleting records
  • Drop a table

SQLCourse2

  • SELECT Statement
  • Aggregate Functions
  • GROUP BY clause
  • HAVING clause
  • ORDER BY clause
  • Combining Conditions & Boolean Operators
  • IN and BETWEEN
  • Mathematical Functions
  • Table Joins, a must

Command(s)

Create the Docker container

docker container run --name sqlcourse -e POSTGRES_PASSWORD=sqlcourse -p 5432:5432 postgres:9.6.17-alpine

Start the Docker container

docker container start sqlcourse

Connect to the Docker container

docker exec -it sqlcourse bash

Connect to PostgresSQL

psql -h localhost -U postgres -d postgres

Run a SQL script

psql -h localhost -U postgres -d postgres -f sqlcourse2.sql

Reference(s)