This course introduces you 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.

You will then apply relational database design principles to your own data, creating databases and tables, and loading data yourself. You'll also 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 MySQL and PostgreSQL. Based on what you've learned throughout the course, you'll complete a final project in which you'll design, create, and populate a database instance containing multiple tables.

What you will learn:

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.

Course Syllabus

Module 1 – Relational Database Concepts

Review of data fundamentals
Information and Data Models
Types of Relationships
Mapping Entities to Tables
Data Types
Relational Model Concepts
Relational 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

General Information

This course is self-paced.
This platform works best with current versions of Chrome, Edge, Firefox, Internet Explorer, or Safari.

Recommended Skills Prior to Taking this Course

Basic computer skills.
Data Literacy.

Relational Database Management Systems [RDBMS]

Language

Topic

Skills You Will Learn

Offered By

Estimated Effort

Platform

Last Update