New Training: Describe Relational Data Workloads
In this 6-video skill, CBT Nuggets trainer Ben Finkel covers the structures and objects that are commonly found in relational data storage models. Watch this new Azure training.
Learn Azure with one of these courses:
This training includes:
- 6 videos
- 45 minutes of training
You’ll learn these topics in this skill:
- Recognizing the Right Workloads for Relational DBs
- Understanding Tables and Fields
- Understanding Queries and Views
- Indexing Tables
- Using DDL and DML
- Querying Azure’s Relational DBs
What Makes Up a Relational Database?
A relational database is a type of database that organizes data based on unique attributes. For example, a relational database may represent a data entry by employee ID, name, age, and date of birth. These unique characteristics are how relational databases organize the database structure such that data entries share a common relationship.
A relational database is made up of 3 basic elements: fields (columns), records (rows), and table. A record is a row of entries that reads from left to right and will be populated with data for employee ID, name, age, and date of birth.
A field is a column that stores a relational data entry. An example of a field could be employee ID. As you can imagine, the ID field column will be populated solely with ID values reading top to bottom.
Lastly, the table itself encompasses the entire relational database. So when you hear table, just think of the entire database of entries.