IBM
Introduction to Relational Databases (RDBMS)
IBM

Introduction to Relational Databases (RDBMS)

This course is part of multiple programs.

Taught in English

Some content may not be translated

Rav Ahuja
Sandip Saha Joy

Instructors: Rav Ahuja

51,321 already enrolled

Included with Coursera Plus

Course

Gain insight into a topic and learn the fundamentals

4.6

(507 reviews)

|

90%

Beginner level

Recommended experience

18 hours (approximately)
Flexible schedule
Learn at your own pace

What you'll learn

  • Describe data, databases, relational databases, and cloud databases.

  • Describe information and data models, relational databases, and relational model concepts (including schemas and tables). 

  • Explain an Entity Relationship Diagram and design a relational database for a specific use case.

  • Develop a working knowledge of popular DBMSes including MySQL, PostgreSQL, and IBM DB2

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

14 quizzes

Course

Gain insight into a topic and learn the fundamentals

4.6

(507 reviews)

|

90%

Beginner level

Recommended experience

18 hours (approximately)
Flexible schedule
Learn at your own pace

See how employees at top companies are mastering in-demand skills

Placeholder

Build your subject-matter expertise

This course is available as part of
When you enroll in this course, you'll also be asked to select a specific program.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 4 modules in this course

A relational database organizes data into tables that can be linked—or related—based on data common to each. By storing your business data in a relational database, you can retrieve and analyze the data to make important business decisions. There are many companies that offer relational database systems and, regardless of which one you use, they all share a common set of characteristics that you must be familiar with before you can move on to more advanced operations with databases. In this module, you will learn some basic relational database concepts and how to diagram and describe the relationships between tables in a database. You will also learn the different deployment topologies and architectures that are commonly used, who the typical users of databases are, and some of the features and benefits of some common relational database management systems including Db2, MySQL, and PostgreSQL.

What's included

13 videos3 readings4 quizzes1 app item2 plugins

In this module, you will learn how to use a RDBMS GUI or web interface and SQL statements to create and manage the tables in a relational database and populate them with data. You will also learn how to employ some database design techniques that help improve the integrity of your data and the performance of your queries, including the use of Primary and Foreign keys to define relationships, indexes, normalization, and relational model constraints.

What's included

11 videos2 readings4 quizzes2 app items2 plugins

MySQL and PostreSQL are two common RDBMS tools for creating and managing relational databases. Both are free and open-source, have download/install and cloud versions, and offer both command-line and desktop and/or web interface options. In this module, you will learn the basics of creating databases and tables, defining keys and constraints in tables, and loading a database with data using MySQL and PostgreSQL. You will also learn how to define views in PostgreSQL to limit access to sensitive data and simplify data retrieval.

What's included

7 videos2 readings4 quizzes6 app items

This module contains the final project for this course. You will consolidate the skills that you learned throughout this course by applying them to a specific scenario. To complete the project successfully, you must demonstrate that you have the skills to design a database from a new set of data, including creating an ERD to identify entities, attributes, and relationships. You will normalize tables, create your database, and load some data. You will also demonstrate some database management tasks by working with views.

What's included

1 video2 readings2 quizzes1 peer review3 app items1 plugin

Instructors

Instructor ratings
4.6 (117 ratings)
Rav Ahuja
IBM
53 Courses2,330,473 learners

Offered by

IBM

Recommended if you're interested in Data Management

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

Showing 3 of 507

4.6

507 reviews

  • 5 stars

    74.36%

  • 4 stars

    18.59%

  • 3 stars

    3.71%

  • 2 stars

    1.76%

  • 1 star

    1.56%

DR
5

Reviewed on Aug 29, 2023

EP
5

Reviewed on Mar 16, 2023

WT
5

Reviewed on Jun 19, 2023

New to Data Management? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions