If you’re learning SQL server then you’ll often stumble onto term called “normalization”. So in this article we’ll discuss what normalization is and what are the different types of normalization. [Read more…]
If you’re using SQLite for your small apps then using GUI interface for database creation can be handy. There is no official GUI tool for manipulating SQLite database. There are some 3rd party gui tools for sqlite. Few tools are either discontinued or are still packaged with old version of sqlite. [Read more…]
Whenever database is modified then triggers are fired based on the event set. Two logical tables are created when triggers are fired.