Professional Course

Relational Database Basics

edX, Online
4 weeks
99 USD
Next course start
Start anytime See details
Self-paced Online
4 weeks
99 USD
Next course start
Start anytime See details
Self-paced Online
Visit this course's homepage on the provider's site to learn more or book!

Course description

Relational Database Basics

This course is an introduction to the world of relational databases. You will explore the fundamental concepts of relational databases and Relational Database Management Systems (RDBMS), learn about relational database design, and understand how to transform source data into tables with clearly defined relationships. From there, you will learn how to apply relational database design principles to your own data, and create databases, tables, and load data yourself. You’ll get an introduction to Structured Query Language (SQL) and use it to add the keys and constraints necessary in a relational database.

This course includes hands-on, practical exercises to help you demonstrate your learning. You will work with several industry standard relational databases, including IBM Db2, MySQL, and PostgreSQL. Based on what you’ve learned through the course, you’ll complete a final project in which you’ll design, create, and populate a database instance containing multiple tables.

No prior knowledge of databases or programming is required.

Upcoming start dates

1 start date available

Start anytime

  • Self-paced Online
  • Online
  • English

Who should attend?



Training content

Module 1 – Relational Database Concepts

  • Review of data fundamentals
  • Information and Data Models
  • Types of Relationships
  • Mapping Entities to Tables
  • Data Types
  • Relational Model ConceptsRelational Database Architectures and Usage Scenarios
  • Introduction to Relational Database Products
  • Db2
  • MySQL
  • PostgreSQL

Module 2 – Using Relational Databases

  • Creating Tables
  • Loading Data
  • Exporting Data
  • Primary Keys and Foreign Keys
  • Overview of Indexes
  • Normalization
  • Relational Model Constraints

Module 3 – MySQL and PostgreSQL

  • Getting started with MySQL - architecture, design focus
  • Creating Databases and Tables in MySQL
  • Loading Data in MySQL
  • Using Keys and Constraints in MySQL
  • Getting started with PostgreSQL
  • Creating Databases and loading data into PostgreSQL
  • Views

Module 4 – Database Design Project

  • Approach to Database Design
  • Final Project

Course delivery details

This course is offered through IBM, a partner institute of EdX.

2–3 hours per week


  • Verified Track -$99
  • Audit Track - Free

Certification / Credits

What you'll learn

The objective of this course is to provide you with a solid understanding of relational databases and Relational Database Management Systems (RDBMS).

After completing this course, you will be able to:

  • Describe a relational database and explain relational database concepts.
  • Design the schema of a relational database.
  • Create database objects such as tables, keys, constraints, and views.
  • Load tables with data from .CSV files.
  • Demonstrate working knowledge of MySQL, PostgreSQL and IBM Db2.

Contact this provider

Contact course provider

Fill out your details to find out more about Relational Database Basics.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
141 Portland Street
02139 Cambridge Massachusetts


edX For Business helps leading companies upskill their labor forces by making the world’s greatest educational resources available to learners across a wide variety of in-demand fields. edX For Business delivers high-quality corporate eLearning to train and engage your employees...

Read more and show all training delivered by this supplier