Data and Datbase Management System:
Protecting the data generated from various business operations and taking decisions basing on analysed data plays a pivotal role in success of a company.
Decision making during meetings with various functional departments of an organization, data or information is significant in the sense that something is decided on real time analyzed data. For example sales data according to various geographical area of marketing products.
In which area the sales people has to concentrate more to popularize and take special steps to push the company products.
Then customer feedback. How far customers are satisfied with your product, how marketing personnel are giving importance to customer service.
IT'S ALL DATA CONTRIBUTE A LOT FOR FINALIZING OR TAKING RIGHT DECISION AT RIGHT TIME.
DataBase Management System (DBMS) tools, app like MySql, Oracle, Ms Sql Server (from Microsoft), Postgres database mostly used in storing, retrieving, editing, deleting the un-required data.
SQL - Structured Query Language
Create database...
Create table...
Select * from table (for selecting all stored data in a database table)
Select * from table name where customer_name = "John"
(For filtered database)
Update table...
Drop Database...
DML - Data Manipulation Language
DDL - Data Definition Language etc.,
Constraint like PRIMARY KEY, FOREIGN KEY, NOT NULL, UNIQUE ETC.,
Thanks
Comments
Post a Comment