Types of databases
Firstly, let’s examine the concept of the word ‘database’ so that we can understand the various references to it.
When people refer to a 'database' they mean one of three things:
- A LOGICAL COLLECTION of tables (and other objects) that store data.
This is the definition of what a database really is. An example of this is LandRegistry.
- A SOFTWARE application that manages databases, stores data, and handles queries, called DBMS which stands for Database Management System.
Some examples of DBMS are Oracle, MySQL, MS SQL Server.
- A HARDWARE that has DBMS installed, called a database server.
An example of this is your computer.
Next, let’s look at what are the main types of databases that are in use.
This first course gives an overview of the five main database types and the components and concepts related to Entity Relationship Diagrams.
A world-leading tech and digital skills organization, we help many of the world’s leading companies to build their tech and digital capabilities via our range of world-class training courses, reskilling bootcamps, work-based learning programs, and apprenticeships. We also create bespoke solutions, blending elements to meet specific client needs.