Data:
Fact,raw or isolated facts from which the required information is processed.
Data Warehouse:
Collection of data organised to support management.
Information:
Processed,Organised and Summarized data defined collection of related data which communicate meaningful and useful message.
Database System:
Data Base system is collection of inter related data and set of program that allow uses to access an modify these data.
Data Mining:
Data Mining is used to "extracting the knowledge" from the database.
Distributed Database:
Distributed database system consists of multiple and independent databases that operate on two or more computers that are connected and share data over a network.
Database Manager:
Data Base Manager is a program module which provides the interface between the low-level data stored in the database .
Database Administrator:
The person who has central control over the system is called as database Administrator.
Keys:
Keys allows us to indentify a set of attribute and thus distinguishes entities from each other.
Structured Query Language:
SQL is non-procedural language.It is used to communicate with relational database management systems.
SQL Commands:
DDL-Data Definition Language is used to creating the table,add the new fields,modify the data type or increasing the value size ,create new table from existing table and delete the table.
create table ,
alter table......add,
alter table ...modify,
create table ...as select,
drop table,
Truncate,
Rename.
DML -Data Manipulation Language is used to insert new rows,update the existing rows and remove unwanted rows.
Insert,
Delete
Update.
DQL- Data Query Language is used to retrieve data from the database.
Select- select the database
DCL-Data Control Language gives and removes rights to database objects.
Grant
Revoke
These are basic commands set used in database management.

shindhu super yaar.
ReplyDelete