# Relational Database Fundamentals

Canonical URL: <https://www.careercenters.com/courses/relational-database-fundamentals>

## Overview

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. In this course, you will examine the basic database concepts and learn the differences in how data is stored and manipulated in common tools such as MS Excel versus true relational database tools such as MS SQL Server or MS Access.

This course is designed for students who not only need to learn the basics of the SQL language but to also understand how true databases function and understand the benefits of using these specialized tools. It is also recommended for students who need to learn MS Excel Power Pivots which is also based on relational concepts. It also provides the fundamental knowledge and techniques needed to advance to more complex data analysis scenarios.

## What you'll learn

- Identify the Components of a Relational Database
- Organize Data in Tables
- Understand Relationships
- Link Multiple Tables to Extract Data
- Query a Database
- Understand a Basic SQL Statement

## Curriculum

### Lesson 1: Relational Databases Comparison

#### Topic A: Flat File Database

#### Topic B: Relational Database

### Lesson 2: Planning a Layout

#### Topic A: Data Normalization

#### Topic B: Building Tables

#### Topic C: Creating Fields

### Lesson 3: Identifying Relationships

#### Topic A: Keys and Indexes

#### Topic B: Referential Integrity

### Lesson 4: Retrieving Data

#### Topic A: Basic Queries

#### Topic B: Introduction to SQL

## Pricing

**Tuition:** $425