MySQL
What is Data?
Data in simple words is different pieces of information or collection of facts related
to any entity
What is Database?
A database is the collection of data organised in a way that data can be easily
accessed, managed and updated.
First Name Last Name Phone Email
Ram Sharma 9994562341
[email protected] Abhijeet Singh 8967452310
[email protected] Parul Bhatia 7685943021
[email protected] What is DBMS?
Database Management System (DBMS) is a software that allows creation, definition
and manipulation of databases, allowing users to store, process and analysis data
easily.
DBMS allows us to perform various operations like creating databases, storing data in
it, updating data, creating tables in the database and a lot more
client DBMS Database
Computer
Database is of two types:
1. Relational: data is stored in form of tables and to manage such databases we
use RDBMS(Relational Database Management System)
Emp Dept Salgrad
Deptno e
Empno
Deptnme Losal
Name
location Hisal
Deptno
Grade
a. RDBMS uses SQL(structured query language)
Eg. MySQL, Oracle, MS SQL Server, PostgreSQL
SQL Structured Query Language
A standardized programming language which is used for accessing and
manipulate relational databases.
With SQL, you can modify databases add, update or delete rows of data,
retrieve information
2. NoSQL: these databases are document based
Eg. MongoDB, Redis, Cassandra
MySQL is the most popular open-source Relational Database Management System. It
is one of the best RDBMS being used for developing various web-based software
applications. It is developed by MySQL AB, which is a Swedish company
Advantages of MySQL:
1. Cross platform
2. Used with multiple languages (PHP, NodeJS, Python, C#)
3. It is open source
4. It is an RDBMS
5. MySQL is fast, reliable, scalable and easy to use
MySQL is used by various websites likes facebook, twitter, google, youtube, flickr,
wikipedia
Major operations performed by MySQL:
CRUD: C: create R: read U: update D: delete
Installation of XAMPP
Once installation is finished, Go to Start Button -> XAMPP folder ->XAMPP Control Panel
Click on Start button to start the services of Apache and MySQL
Open browser and type localhost
Click on phpMyAdmin
