New Training: Describe Relational Data Workloads
| new skills - Team Nuggets

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.

Download

Download

Ultimate Systems Administration Cert Guide

A 158-page guide to every Microsoft, VMware, Citrix, AWS, Google, and Linux certification, and how they fit into your career.

I have read and understood the privacy policy, and am able to consent to it.

LEARNING ON MOBILE

Learn anytime anywhere with our mobile apps.

I have read and understood the privacy policy and am able to consent to it.

© 2021 CBT Nuggets. All rights reserved. Terms | Privacy Policy | Accessibility | Sitemap | 1550 Valley River Drive, Eugene, OR 97401 | 541-284-5522
CBT Nuggets