10 Simple Ideas to Prevent Information Loss
No matter which hard disk brand you have, it is simply a matter of your time before you’ll need data
Continue readingIT world
No matter which hard disk brand you have, it is simply a matter of your time before you’ll need data
Continue readingThere are three levels of data modeling. They are conceptual, logical, and physical. This section will explain the difference between
Continue readingTables are the basic structure where data is stored in the database. Given that in most cases, there is no
Continue readingViews can be considered as virtual tables. Generally speaking, a table has a set of definition that sets the structure
Continue readingIndexes help us retrieve data from tables quicker. Let’s use an example to illustrate this point: Say we are interested
Continue readingOnce a table is created in the database, there are many occasions where one may wish to change the structure
Continue readingA primary key is used to uniquely identify each row on a table. It can either be part of the
Continue readingA foreign key is a field (or fields) that points to the primary key of another table. The purpose of
Continue readingSometimes we may decide that we need to get rid of a table in the database for some reason. In
Continue readingSometimes we wish to get rid of all the data in a table. One way of doing this is with DROP
Continue reading