Beginner guide to MySQL and Workbench installation in Windows

Welcome to Keren Automation, In this tutorial, we will learn about MySQL, Installation & Setup.
Let’s continue…

A database is a virtual container, which stores the data for further processing.

If you want to process the data, you need to have a management system, nothing but a Database Management System.

DBMS is an application software, which manages several databases for processing data. We can do below operations by using DBMS software.

Database Management System can be categorized into 4 types, those are:

MySQL is DBMS software, which belongs to the RDMS category.
MySQL is opensource and offers premium support from Oracle Corporation.
MySQL was developed by Michael Widenius and David Axmark in 1994.
Opensource developers love MySQL, because of its license, fastness, and reliability.
MySQL is written in C, C++

In MySQL – “My” is the daughter’s name of co-founder Michael Widenius. SQL is the short form of “Structured Query Language”.
MySQL’s initial release is 23 May 1995.
Now Oracle is the owner of MySQL.
MySQL co-founder Michael Widenius forked MySQL and established “MariaDB”, which is also an RDMS software. The reason is, he felt some insecurity about “Opensource MySQL” after Oracle acquisition.
Maria – in “MariaDB” is the name of Michael Widenius’s daughter ?

MySQL is Opensource – Free to use.
MySQL has a large community
MySQL handles large databases
MySQL provides transactional and non-transactional storage engines.
MySQL supports an in-memory heap table.
MySQL Server works in client/server or embedded systems.
MySQL is fully multithreaded by using kernel threads. It can handle multiple CPUs if they are available.

Some of the major companies, who are having MySQL in their tech stack is listed below:

Check some more companies here: https://stackshare.io/mysql

SQL (pronounced “ess-que-el”) stands for Structured Query Language.
According to ANSI(American National Standard Institute), SQL is the standard language for RDMS systems.
By using SQL, once you can perform Delete, Update, Access, Manage operations on Database.
The different subsets in SQL are followed:
- Data Definition Language (DDL): useful to perform CREATE, ALTER and DELETE objects.
- Data Manipulation Language (DML): useful to perform insert, update, delete and retrieve data from the database.
- Data Control Language (DCL): useful to execute GRANT or REVOKE permissions on DB.
- Transaction Control Language(TCL): Allows us to perform Commit, Rollback, Savepoint, Set Transaction on DB.

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs.
MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more.
MySQL Workbench is available on Windows, Linux and Mac OS X.