Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

IBM

Introduction to Relational Databases (RDBMS)

IBM via Coursera

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
Are you ready to dive into the world of data engineering? In this beginner level course, you will gain a solid understanding of how data is stored, processed, and accessed in relational databases (RDBMSes). You will work with different types of databases that are appropriate for various data processing requirements.

You will begin this course by being introduced to relational database concepts, as well as several industry standard relational databases, including IBM DB2, MySQL, and PostgreSQL. Next, you’ll utilize RDBMS tools used by professionals such as phpMyAdmin and pgAdmin for creating and maintaining relational databases. You will also use the command line and SQL statements to create and manage tables.

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 and data.

At the end of this course, you will complete a final assignment where you will apply your accumulated knowledge from this course and demonstrate that you have the skills to: design a database for a specific analytics requirement, normalize tables, create tables and views in the database, load and access data.

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.

Syllabus

  • 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.
  • 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.
  • 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.
  • 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.

Taught by

Rav Ahuja and Sandip Saha Joy

Reviews

4.6 rating at Coursera based on 494 ratings

Start your review of Introduction to Relational Databases (RDBMS)

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.