Scribd
Upload
5 views

MySQL Sept 2

Mysql notes chapter 5

Uploaded by

mohitnajkani786
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views

MySQL Sept 2

Mysql notes chapter 5

Uploaded by

mohitnajkani786
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 8

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 ramsharma@gmail.com
Abhijeet Singh 8967452310 singhabhi@gmail.com
Parul Bhatia 7685943021 parulb@gmail.com
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

You might also like