Database Terminology

Lesson Transcript
Instructor: Katie Musselwhite

Microsoft certified professional with a bachelor's degree in information technology management

Databases are structures of organized data. Learn a variety of key terms that relate to data basics, database management, and relationships between different types of tables. Updated: 12/28/2021

Database Background

Have you ever walked the streets in a foreign country? If you have, you probably felt quite out of place. Conversations were going on around you, people smiled and laughed...but you didn't understand the language. Diving into the world of databases can feel the same way! In order to effectively manage and navigate databases, it's essential to know the terminology. Let's walk the streets of databases and see if we can make the ''language'' feel a little less foreign.

An error occurred trying to load this video.

Try refreshing the page, or contact customer support.

Coming up next: Database Query: Definition & Tools

You're on a roll. Keep up the good work!

Take Quiz Watch Next Lesson
Your next lesson will play in 10 seconds
  • 0:04 Database Background
  • 0:30 Data Basics
  • 1:57 Database Management
  • 3:19 Relationships Betwen Tables
  • 5:07 Lesson Summary
Save Save Save

Want to watch this again later?

Log in or sign up to add this lesson to a Custom Course.

Log in or Sign up

Speed Speed

Data Basics

Understanding databases has to start at the surface. A database is simply a structured collection of data. The data is typically ordered into tables similar to a table you may see in Microsoft Excel - only much larger! Each table has columns and rows and a piece of data housed in a specific column. A row is referred to as a record. Each piece of data has a data type, such as an integer, date, or time, that helps the computer ''expect'' and define what type of data is allowed in that column. The data doesn't just sit there in cyberspace somewhere, though; the tables and data housed in a database can have a number of different uses and relationships.

A table has what's called a primary key that helps relate it to other tables. A primary key is usually a critical and identifying piece of data. For instance, in a table of customer names, addresses, and phone numbers, the column containing the name would most likely be the primary key because it holds the most significance.

A foreign key works in conjunction with a primary key. A foreign key tells two tables that they are housing similar columns. In our customer example, we might have another table that holds customer names also but additionally, stores their order number and invoice number. A foreign key on the customer name column would help tie this table to our first table, assuming this is a pool of the same customers. Data within a database can have several different types of relationships, which we will explore further.

Database Management

If you're with me so far, we're doing great! We've navigated the first street in our database journey, but now, it's time to look at how a database is accessed and managed. A database is accessed through a DBMS or database management system. This is a specialized software that handles the storage, updating, and retrieval of data that is housed within a database. A DBMS allows you to query a database, which is the process that involves writing a snippet of simple code that displays or alters data in a database, matching the requirements given by the user. This is a quick way of accessing only the data you need without having to look through tables that potentially contain millions of entities.

SQL, or structured query language, is the programming language that's standard for querying a database. An SQL query might contain such words as ''update'', ''insert'', or ''delete'', which are considered to be DML or database manipulation language because queries containing these words are making changes to the database, not simply accessing information. Terms such as ''create'', ''alter'', and ''drop'' are considered DDL, or database definition language, because they can either create, modify, or remove entire tables within a database. A query containing the word ''select'' that simply displays data to the user is commonly referred to as a select statement.

Relationships Between Tables

Tables within a database can have three different types of relationships: one-to-one, one-to-many, and many-to-many. Understanding each of these relationships can really help a database to feel less foreign because it maps tables to one another and shows how the data is all interconnected.

To unlock this lesson you must be a Member.
Create your account

Register to view this lesson

Are you a student or a teacher?

Unlock Your Education

See for yourself why 30 million people use

Become a member and start learning now.
Become a Member  Back
What teachers are saying about
Try it now
Create an account to start this course today
Used by over 30 million students worldwide
Create an account