Hands On Training

Relational Database Basics

IBM

via

edX

Course Features

Duration

4 weeks

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Beginner

Effort

3 hours per week

Teaching Type

Self Paced

Course Description

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.

Course Overview

International Faculty

Post Course Interactions

Instructor-Moderated Discussions

Skills You Will Gain

What You Will Learn

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.

Course Content

Expand all sections

Module 1: Relational Database Concepts

Module 2: Using Relational Databases

Module 3: MySQL and PostgreSQL

Module 4: Database Design Project

Course Instructors

Rav Ahuja

AI and Data Science Program Director

Rav Ahuja is a Global Program Director at IBM. He leads growth strategy, curriculum creation, and partner programs for the IBM Skills Network. Rav co-founded Cognitive Class, an IBM led initiative to...

Lin Joyner

Senior Instructional Designer & Content Developer at Skill-Up Technologies

Lin Joyner works for Skill-Up Technologies as a Senior Instructional Designer and Content Developer. Based in the UK, she has a background in databases and software development. Lin has been involved...

Rose Malcolm

Senior Instructional Designer & Content Developer at Skill-Up Technologies

Rose Malcolm is an unparalleled Instructional Designer, Content Developer, and Instructor with 20 yrs. experience in physical and virtual classrooms. During her time with Skill-Up, she has been writi...