/sql-study

This repository is a place to record and document SQL related experiences, learnings, and discoveries.

MIT LicenseMIT

SQL - Study

SQL (Structured Query Language) is a programming language used to manage and manipulate relational databases. It is widely employed for performing queries, insertions, updates, and deletions of data in a database, as well as for defining and modifying the structure of tables and relationships within the database.

How to Install?

For Linux Users!

I consider MySQL to be the best for learning, so I will proceed with it for this study.

  1. Update Packages
sudo apt update && sudo apt upgrade -y
  1. Install MySQL Server
sudo apt install mysql-server
  1. Check MySQL Status
sudo systemctl status mysql

  1. Start, Stop, and Restart MySQL (Optional)

    • To start MySQL
    sudo systemctl start mysql
    • To stop MySQL
    sudo systemctl stop mysql
    • To restart MySQL
    sudo systemctl restart mysql

  2. Access MySQL

sudo mysql -u root -p

Main Functionalities:

  • DDL: Data Definition Language;

  • DML: Data Manipulation Language;

  • DQL: Data Query Language;

  • DCL: Data Control Language;

  • DTL: Data Transaction Language.

Other Docs

A Little Knowledge (maybe not)

10 Steps to Conceptual Data Modeling