Database and SQL

Last updated: Feb. 21, 2024

Database is collections of organize data that store in computer. In this course, we learn relational database. MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres etc are relational databases. This tutorial is based on MySQL.

 

SQL stands for Structured Query Language. It is use for storing, retrieving, updating and deleting data in relational database. Using same SQL query we can perform operation all relational databases.

 

Requirements:

  1. Operating system(Windows, Linux or Mac)
  2. MySQL

 

In this course, I will use MySQL database. In windows 10, you can install MySQL workbench. Another option is XAMPP server. It's lite bit and easy to use. By searching google, you can easy download it and there is no complexity in installing process.

 

For linux simply install MySQL server

sudo apt install mysql-server

Related post