Skip to main content

Tutorials

Getting started with SQL​

Install MySQL​

Before starting with MySQL, you need to have it installed on your system. Follow the steps below to install MySQL on your operating system:

  • For Windows:

    1. Download the MySQL Installer from the MySQL official website ↗ .
    2. Run the installer and follow the on-screen instructions.
    3. After installation, configure MySQL by setting the root password and starting the MySQL service.

  • For macOS:

    1. You can install MySQL using Homebrew with the following command: 
      brew install mysql
    2. Once installed, start the MySQL service: 
      brew services start mysql
    3. Secure the installation by setting the root password: 
      mysql_secure_installation

  • For Linux (Ubuntu/Debian):

    1. Install MySQL using apt: 
      sudo apt update
      sudo apt install mysql-server
    2. After installation, start the MySQL service: 
      sudo service mysql start
    3. Secure the installation by running: 
      sudo mysql_secure_installation

Install PostgreSQL​

To start using PostgreSQL, you first need to install it on your system. Follow the installation steps below:

  • For Windows:

    1. Download the PostgreSQL installer from the PostgreSQL official website ↗ .
    2. Run the installer and follow the on-screen instructions.
    3. After installation, you can access PostgreSQL through the pgAdmin tool or the command line.

  • For macOS:

    1. Install PostgreSQL using Homebrew with the following command: 
      brew install postgresql
    2. Start the PostgreSQL service: 
      brew services start postgresql

  • For Linux (Ubuntu/Debian):

    1. Install PostgreSQL using apt: 
      sudo apt update
      sudo apt install postgresql postgresql-contrib
    2. Start the PostgreSQL service: 
      sudo service postgresql start

Learn SQL​

Comprehensive MySQL Tutorial ↗
This tutorial covers the basics of MySQL and helps you get started with database management. It includes the installation process, commands, queries, and more!

Core Topics​