9121822375 sdetforum@gmail.com

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

All about DBMS:

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.

  • Creating Data
  • Accessing Data
  • Managing Data
  • Searching Data

Types of Database Management Systems:

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

  1. Hierarchical DBMS
  2. Relational DBMS (RDBMS)
  3. Network DBMS
  4. Object-oriented DBMS

All about MySQL:

  • 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++

Interesting facts about MySQL:

  1. In MySQL – “My” is the daughter’s name of co-founder Michael Widenius. SQL is the short form of “Structured Query Language”.
  2. MySQL’s initial release is 23 May 1995.
  3. Now Oracle is the owner of MySQL.
  4. 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.
  5. Maria – in “MariaDB” is the name of Michael Widenius’s daughter ?

Main Advantages of MySQL:

  • 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.

Big clients for MySQL:

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

  • Airbnb
  • Uber
  • Netflix
  • Dropbox
  • Pinterest
  • Amazon
  • Twitter
  • Slack

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

Introduction to Structured Query Language:

  • 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.

Introduction to MySQL Workbench:

  • 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.

MySQL Workbench Installation & Setup:

Step1: navigate to https://dev.mysql.com/downloads/mysql/

Click on “Go to Download Page”.

Step2: Download the below version

Note: Login is optional, you can proceed with the download

Step3: Rightclick on the downloaded file and proceed to install

Step2: Select “Full” and click on “Next”

Note: Wait until all products are going to be installed on your machine.

Step3: Click on next

Step5: Enter the root password and click on “Next”

Finally – Click on  “Finish”

You can check server connection status by providing MySQL root password

Step9: Search for “MySQL Workbench” in windows search and open the application

MySQL Workbench Homepage:

Click on the localhost connection and provide your MySQL root password.

Finally, you’ve landed on the ground to start MySQL practice.

Happy Learning:)