Mysql Basics for beginners

Mysql DBA for beginners step by step process

DATA BASE : Collection of data and made up of tables, Tables store similar information.
Databases are organized by fields, records, and files. A filed is a single piece of information, A record is one complete set of fields, and a file is a collection of records. For example, you tube is analogous to a file it contains a list of records, each of which consists of three fields: users, videos and comments.

DATA: Data is a related facts which has future reference value (or) collection of raw facts.

TABLES:  Table is collection of rows and columns,

Row is horizontal record set.
column is a vertical arrangement or order of data set.
A database can have many tables as required depends on size of database.
tablemysql

Rows: Collection of information

Columns: columns are like categories, collection of similar information

Database Types:
1.DBMS(data base Management system)

2.RDBMS(Relational Database Management System)

It means Structured Query Language it was developed by IBM

SQL Commands:
DDL,DML,TCL,DCL

1.DDL: Data Definition language
Create : create is used to create the object
Alter: Alter is used to the Alter object
Drop: Drop is used to the drop object
Truncate: is used to delete the data from existing objects

2.DML: Data Manipulation Language
Select: is used to retrieve the data from object.
Insert: is used to insert in the object
Update: used to modify the existing object data.
Delete : used to delete the data

3.TCL: Transaction Control Language
Commit: used to make the changes permanent
Rollback: used to undo changes

4.DCL: Data Control Language
Grant: used to give the permissions to developers
Revoke: with draw users access privileges given by using the grant command
This entry was posted in Mysql and tagged Data, Database, Mysql, Mysql DBA, SQL. Bookmark the permalink.