Repository for The Complete SQL Bootcamp Go From Zero To Hero

Preparing the environment

• PostgreSQL Installation

  • Add the PostgreSQL repository to the sources.list file:

    sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

  • Download the PostgreSQL signing key and add it to the system:

    wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

  • Update the list of available packages:

    sudo apt-get update

  • Install the desired version of PostgreSQL:

    sudo apt-get -y install postgresql

• pgAdmin4 installation

  • Install curl:

    sudo apt install curl

  • Install the public key to the repository:

    curl -fsS https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /usr/share/keyrings/packages-pgadmin-org.gpg

  • Create the repository configuration file:

    sudo sh -c 'echo "deb [signed-by=/usr/share/keyrings/packages-pgadmin-org.gpg] https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

  • Install for Desktop and Web modes:

    sudo apt install pgadmin4

  • After installing PostgreSQL and pgAdmin4, simply perform the initial user and connection configurations as desired.

Challenges

• Challenges Section 2 - SQL Statement Fundamentals
• Challenges Section 3 - GROUP BY Statements
• Assessment Test 1 Section 4
• Challenges Section 5 - JOINS
• Challenges Section 6 - Advanced SQL Commands
• Assessment Test 2 Section 7
• Assessment Test 3 Section 9
• Challenges Section 10 - Conditional Expressions and Procedures

📌 General Content