top of page

SQL Installation

SQL is  an query language, it is not an database. So we need an database management system or more precisely I would say a RDBMS to store our data and learn SQL. For this purpose we are going to use MySQL.

What is MySQL?

MySQL is an relational database  management system is developed and managed by oracle.

Why MySQL?

  • MySQL is an relational database.

  • MySQL is efficient

  • MySQL is secure and reliable.

  • Scalability and Flexible for our needs

  • Supports large data Storage

  • perform faster operations

why Relational Database is preferred over Spreadsheets?

  • Spreadsheets can't store more than 1 million records but it is easily possible to store in relational database.

  • Databases are focused on storing numbers and data and they are not bothered with formatting and designing of a cells.

  • In Database we have to declare the type of data the column is going to store while creating an table  and it will throw an error if we try to store any other data this will help us to achieve data integrity.

  • We can keep tracks in relational database who make changes to the database and can manage access rights using DCL, this makes relational database more secure.

MySQL Installation

We need two things.

  1. SQL WorkBench

  2. SQL Server

​

Step 1 : Click Below and go to official website

​

Step 2 : Click on the download button

Step 3 : Scroll down and select the link below

2.2.png

As we discussed earlier, we need two things.

  1. MySQL Server

  2. MySQL Workbench from the applications

Once we move both the required application to right panel. click Next

  1. SQL WorkBench

  2. SQL Server

​

This is an optional step. if the installation process ask for the option, choose the second one which is an legacy authentication method

17.png
18.png
bottom of page