4.6
stars
333 ratings

Rav Ahuja +3 more instructors

27,304 already enrolled

Offered By

IBM Skills Network

About this Course

137,828 recent views

Are you ready to dive into the world of data engineering? You’ll need a solid understanding of how data is stored, processed, and accessed. You’ll need to identify the different types of database that are appropriate for the kind of data you are working with and what processing the data requires.
In this course, you will learn the essential concepts behind relational databases and Relational Database Management Systems (RDBMS). You’ll study relational data models and discover how they are created and what benefits they bring, and how you can apply them to your own data. You’ll be introduced to several industry standard relational databases, including IBM DB2, MySQL, and PostgreSQL.

This course incorporates hands-on, practical exercises to help you demonstrate your learning. You will work with real databases and explore real-world datasets. You will create database instances and populate them with tables. 

No prior knowledge of databases or programming is required.

Anyone can audit this course at no-charge. If you choose to take this course and earn the Coursera course certificate, you can also earn an IBM digital badge upon successful completion of the course.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Beginner Level

Computer and IT literacy. Curiosity about how data is managed.

Approx. 18 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

What you will 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.
Implement different relational model constraints.

Skills you will gain

Database (DB) Design
Database Architecture
Postgresql
MySQL
Relational Database Management System (RDBMS)

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Beginner Level

Computer and IT literacy. Curiosity about how data is managed.

Approx. 18 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructors

Instructor rating

4.59/5 (81 Ratings)

Offered by

IBM Skills Network

IBM is the global leader in business transformation through an open hybrid cloud platform and AI, serving clients in more than 170 countries around the world. Today 47 of the Fortune 50 Companies rely on the IBM Cloud to run their business, and IBM Watson enterprise AI is hard at work in more than 30,000 engagements. IBM is also one of the world’s most vital corporate research organizations, with 28 consecutive years of patent leadership. Above all, guided by principles for trust and transparency and support for a more inclusive society, IBM is committed to being a responsible technology innovator and a force for good in the world.

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

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Content Rating90%(2,329 ratings)

Week1

Week 1

4 hours to complete

Relational Database Concepts

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.

4 hours to complete

13 videos (Total 72 min), 3 readings, 5 quizzes

13 videos

Review of Data Fundamentals 5mInformation and Data Models5mERDs & Types of Relationship4mMapping Entities to Tables2mData Types6mRelational Model Concepts2mDatabase Architecture6mDistributed Architecture and Clustered Databases4mDatabase Usage Patterns6mIntroduction to Relational Database Offerings7mDb210mMySQL5mPostgreSQL4m

3 readings

Course Introduction10mSummary & Highlights 5mSummary & Highlights10m

4 practice exercises

Practice Quiz: Fundamental Relational Database Concepts10mGraded Quiz: Fundamental Relational Database Concepts15mPractice Quiz: Introducing Relational Database Products10mGraded Quiz: Introducing Relational Database Products15m

Week2

Week 2

5 hours to complete

Using Relational Databases

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.

5 hours to complete

11 videos (Total 55 min), 2 readings, 6 quizzes

11 videos

Types of SQL statements (DDL vs. DML)2mCreating Tables4mCREATE TABLE Statement4mALTER, DROP, and Truncate tables4mData Movement Utilities7mLoading Data4mDatabase Objects & Hierarchy (Including Schemas)8mPrimary Keys and Foreign Keys3mOverview of Indexes3mNormalization7mRelational Model Constraints - Advanced5m

2 readings

Summary & Highlights10mSummary & Highlights 5m

4 practice exercises

Practice Quiz: Creating Tables and Loading Data10mGraded Quiz: Creating Tables and Loading Data15mPractice Quiz: Designing Keys, Indexes, and Constraints10mGraded Quiz: Designing Keys, Indexes, and Constraints15m

Week3

Week 3

4 hours to complete

MySQL and PostgreSQL

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.

4 hours to complete

7 videos (Total 31 min), 2 readings, 10 quizzes

7 videos

Getting Started with MySQL4mCreating Databases and Tables in MySQL3mLoading Data in MySQL5mUsing Keys and Constraints in MySQL4mGetting Started with PostgreSQL5mCreating Databases and Loading Data in PostgreSQL5mViews3m

2 readings

Summary & Highlights10mSummary & Highlights10m

4 practice exercises

Practice Quiz: MySQL10mGraded Quiz: MySQL15mPractice Quiz: PostgreSQL10mGraded Quiz: PostgreSQL15m

Week4

Week 4

6 hours to complete

Course Assignment

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.

6 hours to complete

1 video (Total 8 min), 2 readings, 6 quizzes

Reviews

4.6

62 reviews

5 stars
74.18%
4 stars
19.88%
3 stars
2.96%
2 stars
1.48%
1 star
1.48%

TOP REVIEWS FROM INTRODUCTION TO RELATIONAL DATABASES (RDBMS)

by AJan 27, 2023

Very beneficial course with real practical. I can't really thank the instructors team enough. I so much appreciate the opportunity given to me

by MCMar 16, 2022

The use of IBM services limited opportunities to study. Generally methods and common practices werre explained in great detail.

by EPMar 16, 2023

Awesome course, as always from IBM. Topnotch Labs using their Cloud IDE (Theia) and Docker.

by JASep 22, 2022

Very good however some parts need updating where the various portals have cahnged.

View all reviews

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Certificate?
When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

Introduction to Relational Databases (RDBMS)

About this Course

What you will learn

Skills you will gain

Instructors

Rav Ahuja

Sandip Saha Joy

Lin Joyner

Rose Malcolm

Offered by

IBM Skills Network

Syllabus - What you will learn from this course

Relational Database Concepts

Using Relational Databases

MySQL and PostgreSQL

Course Assignment

Reviews

TOP REVIEWS FROM INTRODUCTION TO RELATIONAL DATABASES (RDBMS)

Frequently Asked Questions

Learn Something New

Popular Data Science Courses

Popular Computer Science & IT Courses

Popular Business Courses

Coursera

Community

More

Introduction to Relational Databases (RDBMS)

About this Course

What you will learn

Skills you will gain

Instructors

Rav Ahuja

Sandip Saha Joy

Lin Joyner

Rose Malcolm

Offered by

IBM Skills Network

Syllabus - What you will learn from this course

Relational Database Concepts

Using Relational Databases

MySQL and PostgreSQL

Course Assignment

Reviews

TOP REVIEWS FROM INTRODUCTION TO RELATIONAL DATABASES (RDBMS)

Frequently Asked Questions

Coursera Footer

Learn Something New

Popular Data Science Courses

Popular Computer Science & IT Courses

Popular Business Courses

Coursera

Community

More