185 Madison Ave. at 34th St., Suite 1104, New York, NY 10016 • 212-684-5151
Relational Database Fundamentals
Relational Database Fundamentals

Price: $425.00

Course Code: RD | Hours: 8

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.

Upon successful completion of this course, students will be able to:

  • 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

Prerequisites:

Students should have a basic understanding of Windows, including how to use files and folders. A mid-level knowledge of MS Excel would also be helpful.

Related Classes:

See Also:

Prerequisites:

Students should have a basic understanding of Windows, including how to use files and folders. A mid-level knowledge of MS Excel would also be helpful.

Related Classes:

See Also:

Relational Database Fundamentals Outline:

Lesson 1: Why 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