SQL – Alter Table

SQL – Alter Table is DDL (Data definition language) statement.The ALTER TABLE command is used to modify the definition (structure) of a table by modifying the definition of its columns.It is used to add, delete or modify columns in an existing table.

Continue reading

What is Data Modeling ?

Most of us are aware about Database and Database Management System. But do you know how the data is organized in a database. What is the relation between data in database ? For designing a database structure , which is easy to use and maintains the data security, we need…

Continue reading

What is SQL ?

Database is the most important part of decision system of any organization. Database stores the data of past and present and this data is used for better future. We have already discussed about database and database management system(DBMS). We are also aware about the types of databases. But you must…

Continue reading

What is Data Mart ?

Data Mart is very similar to a Data Warehouse but limited in scope and purpose and is usually associated to one single domain. Often people get confused between Data Warehouse and Data Marts. I have already written before about the Data Warehouse and need of Data Warehouse. If you have missed…

Continue reading

Types Of Databases

As we are in the age of computers, we deal with different kind of data in our day to day life. When we say about data, we are  talking about interactions with different kind of databases. I know that you would be very much familiar with the term ‘Database’ .…

Continue reading