New Banner :) TEST UPDATE Learn more

Offered By: IBMSkillsNetwork

Relational Database Management Systems [RDBMS]

This course teaches you the fundamental concepts of relational databases and Relational Database Management Systems (RDBMS), including MySQL and PostgreSQL. In this course you will design relational databases, create tables, and load data.

Continue reading
Premium

Course

Database

At a Glance

This course teaches you the fundamental concepts of relational databases and Relational Database Management Systems (RDBMS), including MySQL and PostgreSQL. In this course you will design relational databases, create tables, and load data.

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.

Estimated Effort

15 Hours

Level

Intermediate

Skills You Will Learn

Database Design, MySQL, PostgreSQL, RDBMS, Relational Databases, SQL

Language

English

Course Code

DB0101EN

Tell Your Friends!

Saved this page to your clipboard!

This is part of the following learning path

Stay Ahead in AI – Subscribe to Our Newsletter

Get latest insights, courses, and trends in AI and cognitive computing by joining our newsletter. Be the first to know about new learning opportunities, expert articles, and exclusive content.

Have questions or need support? Chat with me 😊