MySQL ppt

Information about MySQL. How it was developed, advantages and disadvantages, etc.
By- Atharva Sawant

1. Industrial Training

2. TOPIC:MySQL

3. Contents
1.Introduction.
2.What is MySQL?
3.Development of MySQL.
4.How to install MySQL?
5.Features.
6.Data Types.
7.Basic Commands.
8.Advantages and Disadvantages Of MySQL.

4. Introduction
The original version of MySQLwas called SEQUEL. SQL is known as Structured Query Language. It enables to create and perform
certain operations on relational database, which are sets of related information stored in tables.
Database stores a collections of Tables and related Data.
RDBMSis used to store and manage huge volume of data. RDBMSis called as “ Relational Database Management System”.
MySQL is a fast and easy to use.
Data is stored into different tables and relations are established using primary keys or other keys known as foreign keys.
All Relational Database Management Systems (RDBMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server
use SQL as their standard database language.
Database and database management system have become essential for managing for business, governments, banks, universities and
every other kind of human endeavors.

5. What is MySQL?
MySQL is most popular open source SQL database management system.
It is developed, distributed and supported by Oracle co-operation.
MySQL is widely accepted.
MySQL Supports including Windows, the major operating systems Linux, UNIX, Mac.
It is used to create the backbone of many of the popular web site, social networking sites like: Uber, Netflix, Pinterest,
Amazon, Twitter, Udemy, Linked in, Tesla, cisco, Facebook, You Tube , and many more companies.
MySQL supports Windows, Linux, macOS, Solaris and FreeBSD.

6. Developmentof mysql
Created by Swedish Company, MySQL AB, founded by Michael Widenius, David Axmark & Allan Larsson during 1994.
The first versions of MySQL in windows was internally released on 23
rd
May 1995.
The windows version was released on 8
th
January 1998.
Latest version of MySQL is 8.0 the date of the latest version is 20 July 2021.
Michael Widenius David Axmark Allan Larsson

7. Features
It is non-procedural, English like language.
SQL is a high level language.
It is very flexible language.
SQL allows users to define the data in database and manipulate that data.
SQL can be run on any system.
SQL allows users to access data in relational database management systems.
MySQL is a freely available Database System.
MySQL stores data in table, tables further store Data in Rows and Columns.
MySQL takes less memory space.(800MB for Manager Minimum Disk Space and 500MB for Agent Minimum Disk Space).
MySQL is scalable and capable of handling more than 50 million rows.
MySQL has a unique storage engine architecture which makes it faster, cheaper and more reliable.

8. Data Types
Each column in a database table is required to have a name and a data type.
In MySQL there are many data types:
CHARACTER
VARCHAR (n) or CHARACTER VARYING
BINARY.
BOOLEAN.
VR (n) or BINARY VARYING (n).
INTEGER.
SMALLINT.
INTEGER.
BIGINT.

9. DECIMAL .
NUMERIC.
FLOAT(p).
REAL.
FLOAT.
DOUBLE PRECISION.
DATE.
TIME.
TIMESTAMP.
INTERVAL.
ARRAY.
MULTISET.
XML.

10. Basic Command
CREATE TABLE Command: The CREATE TABLE statement is used to create a new table in a
database.
ALTER TABLE Command: ALTER TABLE statement is to add, delete, or modify columns in an
existing table.
DROP TABLE Command: The DROP TABLE statement is used to drop an existing table in a
database.
TRUNCATE TABLE Command: The TRUNCATE TABLE statement is used to delete the data inside a
table, but not the table itself.
RENAME TABLE Command: The RENAME TABLE statement is used to change the name of the
table.
DESC TABLE Command: DESC TABLE statement is used to describe a table.

11. Advantages and Disadvantages of MySQL
Advantages of MySQL:
a)By using the MySQL queries we can quickly retrieve an ample amount of information from the database as the time
factor of execution queries is very less.
b)It is very easy to manage a database system as it doesn't require a huge amount of code to carry out the operations on the
database.
c)Data security is an important advantage of MySQL.
d)It upgrades fast and easy while enhancing the end-user experience.
Disadvantages of MySQL:
a)MySQL is not very efficient in handling very large database.
b)MySQL doesn't have as good a developing and debugging tool as compared to paid database.
c)MySQL version less than 5.0 do not support COMMIT, store procedure and ROLE.
d)MySQL does not supports SQL check constraints.

12. THE END