Database management system is a system in which we can store the data. So, concepts of DBMS (Short form of database management system) is to explain the system in which we can create, store, modify and delete the data. It also helps us to get our useful information out of this large store.
We can create any data in database management system. We can modify and delete anytime. DBMS secures our data. It provides the information to the user who will have the permission. Today, accounting is also done in DBMS.
Famous DBMS are : -
1. Ms. Access
2. SQL Server
3. Oracle
Uses of DBMS in Our Daily Life :-
1. When we deposit or withdraw money from bank ATM, bank adds or modifies our bank balance in their DBMS.
2. When we buy anything from online and place order. It is recorded in website's owner' database.
3. When we pay our lighting bill through our online bank account, we are just interacting with bank's DBMS.
4. When we keep accounting records in Tally.ERP 9, actually, we are recording our accounting data in its DBMS
DBMS Language
You know, I am teaching to you in English language. Because, I know little English, so it is very easy to convey my teaching lecture to you. My every taught lecture is also written on my website which is operated through html language. It means, I know two language for reaching to you. One is English language and Second is hyper text markup language. I have written text through typing. So, for fast typing, I also know typing language. Like this, for creating any database in DBMS, we also need to learn DBMS Language. Only after this, we can create DBMS and other can use it who do not know.
Following are the main language, you should learn :
1. Data Definition Language (DDL)
2. Storage Definition Language (SDL)
3. View Definition Language (VDL)
4. Data Manipulation Language (DML)
5. Data Programming Language (DPL)
Data programming language has following sub-parts.
a) C
b) C++
c) Java
d) C#
e) Visual Basic
f) Cobol
g) Pascal
6. SQL Relational language
Related : Benefits of ERP
We can create any data in database management system. We can modify and delete anytime. DBMS secures our data. It provides the information to the user who will have the permission. Today, accounting is also done in DBMS.
Famous DBMS are : -
1. Ms. Access
2. SQL Server
3. Oracle
Uses of DBMS in Our Daily Life :-
1. When we deposit or withdraw money from bank ATM, bank adds or modifies our bank balance in their DBMS.
2. When we buy anything from online and place order. It is recorded in website's owner' database.
3. When we pay our lighting bill through our online bank account, we are just interacting with bank's DBMS.
4. When we keep accounting records in Tally.ERP 9, actually, we are recording our accounting data in its DBMS
DBMS Language
You know, I am teaching to you in English language. Because, I know little English, so it is very easy to convey my teaching lecture to you. My every taught lecture is also written on my website which is operated through html language. It means, I know two language for reaching to you. One is English language and Second is hyper text markup language. I have written text through typing. So, for fast typing, I also know typing language. Like this, for creating any database in DBMS, we also need to learn DBMS Language. Only after this, we can create DBMS and other can use it who do not know.
Following are the main language, you should learn :
1. Data Definition Language (DDL)
2. Storage Definition Language (SDL)
3. View Definition Language (VDL)
4. Data Manipulation Language (DML)
5. Data Programming Language (DPL)
Data programming language has following sub-parts.
a) C
b) C++
c) Java
d) C#
e) Visual Basic
f) Cobol
g) Pascal
6. SQL Relational language
Related : Benefits of ERP
nice :)
ReplyDelete