Quick Facts

particular	details
Medium of instructions English	Mode of learning Self study	Mode of Delivery Video and Text Based

Course overview

The term relational database refers to a particular kind of database that stores and makes available connected data items. On the relational model, an easy-to-understand method of representing data in tables, relational databases are built. Introduction to Relational Databases (RDBMS) certification course is taught by Sandip Saha Joy - Data Scientist, Rav Ahuja - Global Program Director, Lin Joyner - Senior Instructional Designer & Content Developer, and is developed by IBM Skills Network and Rose Malcolm - Senior Instructional Designer & Content Developer, which is delivered by Coursera.

Introduction to Relational Databases (RDBMS) online course focus on assisting individuals in recognising the many database types that are suitable for the particular sorts of data they are working with and the processing requirements as well as providing individuals with a good understanding of how information is stored, analyzed, and retrieved. Introduction to Relational Databases (RDBMS) online classes incorporate 15 hours of hands-on practical learning materials to help individuals in learning the methodologies for building relational data models and the approaches to use them with their data.

Course and certificate fees

Depending upon the number of hours required to complete the learning, the participants may choose from any of the following Introduction to Relational Databases (RDBMS) certification fees mentioned in the table down below. All these structures include certificates after course completion.

Introduction to Relational Databases (RDBMS) Fee Structure

Head	Amount in INR
1 month	Rs. 4,117
3 month	Rs. 8,234
6 month	Rs. 12,352

certificate availability

Yes

certificate providing authority

Coursera +1 more

Who it is for

It engineer Software developer Software engineer Database architect Data engineer Data scientist Data analyst

What you will learn

Database management

After completing the Introduction to Relational Databases (RDBMS) online certification, individuals will acquire a detailed understanding of the functionalities involved with RDBMS as well as will acquire the knowledge of the strategies involved with database design, database architecture using MySQL and PostgreSQL. Individuals will explore the fundamentals of cloud databases, and relational databases as well as will learn about the methodologies involved with distributed architecture. Individuals will also learn about concepts associated with data models, relational models, entity relational diagrams, and indexes, as well as will acquire the knowledge of the techniques involved with data movement, data loading, and data normalization

The syllabus

Module 1: Relational Database Concepts

Videos

Review of Data Fundamentals
Information and Data Models
ERDs & Types of Relationship
Mapping Entities to Tables
Data Types
Relational Model Concepts
Database Architecture
Distributed Architecture and Clustered Databases
Database Usage Patterns
Introduction to Relational Database Offerings
Db2
MySQL
PostgreSQL

Readings

Course Introduction
Summary & Highlights
Summary & Highlights

Assignments

Practice Quiz: Fundamental Relational Database Concepts
Graded Quiz: Fundamental Relational Database Concepts
Practice Quiz: Introducing Relational Database Products
Graded Quiz: Introducing Relational Database Products

Plugins

Helpful Tips For Course Completion
Hands-on Lab: Relational Model Concepts
Reading: Deep Dive into Advanced Relational Model Concepts
Reading: Advanced Relational Model Concepts

Module 2: Using Relational Databases

Videos

Types of SQL statements (DDL vs. DML)
Creating Tables
CREATE TABLE Statement
ALTER, DROP, and Truncate tables
Data Movement Utilities
Loading Data
Database Objects & Hierarchy (Including Schemas)
Primary Keys and Foreign Keys
Overview of Indexes
Normalization
Relational Model Constraints - Advanced

Readings

Summary & Highlights
Summary & Highlights

Assignments

Practice Quiz: Creating Tables and Loading Data
Graded Quiz: Creating Tables and Loading Data
Practice Quiz: Designing Keys, Indexes, and Constraints
Graded Quiz: Designing Keys, Indexes, and Constraints

App Items

Hands-on Lab: Create Tables and Load Data in Datasette
Hands-on Lab: Normalization, Keys, and Constraints in Relational Database
(Optional) Obtain IBM Cloud Feature Code and Activate Trial Account

Plugins

Reading: Overview of Optional Lesson
(Optional) Hands-on Lab: Create Db2 service instance
(Optional)Hands-on Lab: Create Tables and Load Data in Db2
(Optional) Hands-on Lab: Normalization, Keys, and Constraints in Relational Databases (with Db2)