Skip main navigation

New offer! Get 30% off your first 2 months of Unlimited Monthly. Start your subscription for just £35.99 £24.99. New subscribers only T&Cs apply

Find out more

Database Fundamentals: A Video Introduction

In this video, we explore the fundamentals of databases, including the different types of database models.
0.6
(gentle music)
5.4
Databases and database systems exist everywhere. Most of your day to day activities will involve or will invoke some interaction with the database. From recording deposits and withdrawals at the bank to recording inventory levels at a supermarket, lots of activities involve someone or some computer programme accessing a database. The word database is commonly used, but often refers to a collection of different components or systems sometimes interchangeably. At its core, a database is an organised collection of data. This data is stored in different structures or in different formats, depending on the type of database. Relational databases, one of the most common types of database stored data in a tabular format.
52.1
The tables are made up of columns and rows, similar to how data is arranged in a spreadsheet. Each row in these tables is marked with a unique identifier known as a primary key. These keys are used to relate the data in rows, across different tables in the database and access information in different ways without having to alter the underlying tables. As well as the tabular structure of relational databases, several other popular database models exist. This includes dimensional databases are a specialised adaptation of the relational model built around a central fact table and used to support data warehouses. Object-oriented databases, borrow concepts from object oriented programming, representing data with objects rather than rows in a table.
103.6
NOSQL databases provide a variety of non-relational models that can store semi structured or unstructured data, including key value pairs. Surrounding databases, we have database management systems. Database management systems are a collection of programmes that enable you to create and maintain a database. Database management systems provide several key functions, including the ability to define a database, including specifying data types and constraints of the data to be stored. Construct the database, manipulate the database, including finding or updating data, Share the database to enable multiple users or programmes to access the database simultaneously. The database management system enables applications to interact with the database, processing queries or transactions. A query is a request for information.
161.7
And the transaction describes when data is written or read into the database. You’ll often find query is loosely used to describe any interaction with a database, including performing transactions, but it’s important to be able to distinguish between these at times. (gentle music)

Here, we’ll focus on relational databases. As an analyst you’ll often work with these, especially when you have to analyse business data or transactions.

Read also: What is a database model [1]

Under ‘Types of database models’ the authors list several models, including those covered in the video. Why do you think so many types of database models have emerged over time?

Reference

What is a database model [Internet]. Lucidchart. Available from: https://www.lucidchart.com/pages/database-diagram/database-models#section_0

This article is from the free online

Excel for Data Analysis

Created by
FutureLearn - Learning For Life

Reach your personal and professional goals

Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.

Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.

Start Learning now