The main objective of a database management system is to store, retrieve, and process data. In order to do this in a safe and efficient manner, several major components work together to achieve this aim. They are: Databases Security Data Dictionary Storage Engine Query Processor
Continue readingA SQL database is used to store and retrieve data. The database is housed in a database server and largely controlled by a database management system. All SQL databases, whether they MS SQL Server, MySQL, Oracle, or Progress have several components in common. They are: Tables Indexes Views Stored Procedures Triggers It is these various […]
Continue reading