Hello everyone!! today i am going to start a Mysql Beginners tutorial. In this tutorial, I will cover topics such as What is a database, What is Database table , What is SQL and Why do we use SQL?
1. What is a database and Database Management Systems?
Database is collection of organized information or data that can easily be accessed managed and updated whenever is needed.
Database Management System (DBMS) is a system software There are many kinds of database management systems out there. Here are some example of popular Database Manage systems :
a. SQL
b. Sybase
c. Oracle
d. Microsoft Access
e. DB2
Database Management systems can be classified according to its structure. such as
a. Relational database :-In Relational Database Management systems(RDBMSs) database data are defined in such ways that it can be reorganized and accessed in a number of different ways. This kind of Database Management systems stores data in tables which has relationships to other tables.
b. Object oriented programming database :- In this database management system, the data is defined as object classes and sub classes.
c. Distributed database :- In this database management system, distributed database can be dispersed or replicated among different point in a network.
2. What is Database table ?
RDBMS(Relational Database systems) contains single or more objects called tables. Here are some more information on Database tables including Picture :
a. All of the Data information for database are saved in the Database tables.
b. Each Database tables are uniquely identified by their names.
c. Database tables contains Columns and Rows. Database rows are also known “Tuple”
In the picture you will see a table named Employee Table where ID, FirstName, LastName and Phone as Columns . Also 1,2,3 and 4 as Rows .
3. What is SQL and why do we use SQL ?
SQL is language. “SQL” Stands for Structured Query Language. Its a standard language for accessing and manipulating Databases. RDMSs use SQL as their language. RDMSs like MySQL, oracle have minor variations from SQL , but it’s all still SQL. We are going to USE MySQL RDMS for tutorials. We can use SQL language to :
a. Retrieve records from Database.
b. Insert, update and Delete records from database.
c. Create new Tables in Database.
d. Create New Database.
e. Create views in Database.
f. Set permissions on tables, procedures and views.
g. Execute queries against a database.
For today i am finishing MySQL Tutorial Part 1. If this tutorial helped you a little, Please Share and link this tutorial with your friends and rest of the world. Thanks