The Series of MySQL -1- Basic of MySQL - EP 01_01
HI Hi, Greetings! 
Happy December 
Hi Everyone,
Today, I would like to share with you an article about the first episode of Series of MySQL (Basic of MySQL), and the content is given below.
a. Basic of MySQL
b. Introduction of Database
c. Introduction of MySQL
d. History of MySQL
a. Basic of MySQL:
MySQL tutorial covers both fundamental and advanced MySQL principles. The series of MySQL is suitable for both beginners and experts.
MySQL is a relational database management system based on the Structured Query Language (SQL), the most widely used language for accessing and managing database records. Under the GNU license, MySQL is open-source and free software. Oracle Corporation backs it up.
The series of MySQL covers all aspects of the MySQL database, including how to manage the database and manipulate data using SQL queries. Insert records, update records, delete records, select records, create tables, drop tables, and so on are examples of these queries.
b. Introduction of Database:
Before mastering MySQL, it's critical to comprehend the database. A database is a program that organizes and saves a collection of records. It is very simple for the user to access and manage. It allows us to rapidly access essential information by organizing data into tables, rows, columns, and indexes. Each database has its own API for conducting database tasks like generating, managing, accessing, and finding the information it holds. Many databases are available today, including MySQL, Sybase, Oracle, MongoDB, PostgreSQL, SQL Server, and others. In this section, we'll mostly focus on MySQL.
c. Introduction of MySQL:
MySQL is the most widely used database management system software for managing relational databases today. It is an open-source database that is supported by the Oracle Corporation. In comparison to Microsoft SQL Server and Oracle Database, it is a quick, scalable, and simple to use database management system. It's frequently combined with PHP scripts to build powerful and dynamic server-side or web-based enterprise applications.
MySQL AB, a Swedish business, created, marketed, and supported it, and it was written in the C and C++ programming languages. MySQL is used by many small and large businesses. MySQL uses the C, C++, and Java programming languages to support a variety of operating systems, including Windows, Linux, macOS, and others.
MySQL is a Relational Database Management System (RDBMS) that offers a variety of features, including:
· It allows us to use tables, rows, columns, and indexes to perform database operations.
· Tables (collection of rows and columns), also known as relations, are used to construct database relationships.
· It ensures that the Referential Integrity between rows or columns of different tables is maintained.
· It allows us to automatically update the table indexes.
· It employs a number of SQL queries and integrates useful data from many columns for end-users.
d. History of MySQL:
The MySQL project began in 1979 when MySQL's creator Michael Widenius created an in-house database tool called UNIREG for database management. Following then, UNIREG was rewritten in a variety of languages and expanded to handle large databases. Michael Widenius contacted David Hughes, the inventor of mSQL, after some time to ask if Hughes was interested in linking mSQL to UNIREG's B+ ISAM handler to offer to an index to mSQL. MySQL came into being in this manner.
Source:
· https://www.w3schools.com/mySQl/default.asp
· https://www.mysqltutorial.org/mysql-basics/
You are welcome to like and leave feedback in the comment area.
Link:
Main:
EP 01_02:
The Series of MySQL -1- Basic of MySQL - EP 01_02
EP 01_03:
EP 01_04:
EP 01_05:
The Series of MySQL -1- Basic of MySQL - EP 01_05
M M Zaheer Hussain
Stay Safe!
