# Relational Database Fundamentals

Canonical URL: <https://training-nyc.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 Pivot, 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

## FAQ

### Is this course open to beginners?

Yes, this course is open to beginners. Students must be comfortable using a computer. No other prior knowledge is required.

### Do you offer payment plans or student financing for this course?

This course does not qualify for payment plans or student financing. See our Payment Plan FAQ to find related programs that qualify.

### Can I take this course online (remote learning)?

No upcoming live online dates are currently available. Please contact us about future availability.

### What happens if I need to miss a session?

You have some options: You can watch a recording of the session. We will provide any course materials. Contact us to confirm whether remote attendance is available for your session. You can use your free retake to make up any missed class time.

### What’s included with my tuition?

A hands-on learning experience working on projects and exercises, which is proven to boost comprehension, retention, and engagement Expert instructors who are industry professionals and experienced educators that are driven to help you succeed Access to industry-standard software during your training Top-notch curricula that have been tried and tested over many cohorts and are consistently improved for an optimal learning experience A 1-year free retake policy which allows students to retake any part of the course or program for free to refresh the materials and gain additional practice 30-day access to class recordings to review material at your own pace A certificate of completion to verify your accomplishment

### Are there any additional fees or expenses?

There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us.

### Do you offer any discounts for this course?

We don’t currently offer discounts as we do our best to affordably price our courses.

## Pricing

**Tuition:** $425