Introduction to Relational Databases (RDBMS)

BY
IBM via Coursera

Develop a fundamental knowledge of the concepts and techniques underlying relational database management systems.

Lavel

Beginner

Mode

Online

Duration

4 Weeks

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

The highlights

  • Shareable certificate of completion
  • Self-paced course
  • 16 hours of effort
  • 100% online content
  • Flexible deadlines

Program offerings

  • English video lectures with subtitles
  • 100% online content
  • Learning resources
  • Practice exercise
  • Practice quizzes
  • Graded assignments
  • Accessible on mobile devices

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

Description

Amount in INR

1 Month, 20+ hours per week

Rs. 4,091

certificate availability

Yes

certificate providing authority

Coursera +1 more

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

Week 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
Practice Exercises
  • Practice Quiz: Fundamental Relational Database Concepts
  • Graded Quiz: Fundamental Relational Database Concepts
  • Practice Quiz: Introducing Relational Database Products
  • Graded Quiz: Introducing Relational Database Products

Week 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
Practice Exercises
  • 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

Week 3: MySQL and PostgreSQL

Videos
  • Getting Started with MySQL
  • Creating Databases and Tables in MySQL
  • Loading Data in MySQL
  • Using Keys and Constraints in MySQL
  • Getting Started with PostgreSQL
  • Creating Databases and Loading Data in PostgreSQL
  • Views
Readings
  • Summary & Highlights
  • Summary & Highlights
Practice Exercises
  • Practice Quiz: MySQL
  • Graded Quiz: MySQL
  • Practice Quiz: PostgreSQL
  • Graded Quiz: PostgreSQL

Week 4: Course Assignment

Video
  • Approach to Database Design (Including ERD)
Readings
  • Congratulations & Next Steps
  • Course Team & Acknowledgements
Practice Exercise
  • Final Quiz

Instructors

Mr Rav Ahuja

Mr Rav Ahuja
Global Program Director
IBM

B.E /B.Tech, MBA

Mr Sandip Saha Joy
Data Scientist
IBM

Other Bachelors

Articles

Popular Articles

Latest Articles

Similar Courses

NoSQL Database

Great Learning

Online
Beginner
Free

Introduction to NoSQL Databases

IBM via Coursera

5 Weeks Online
Beginner

NoSQL Database Basics

IBM via Edx

5 Weeks Online
Beginner
Free

Relational Database Basics

IBM via Edx

4 Weeks Online
Beginner
Free

Introduction to Database Queries

NYU via Edx

5 Weeks Online
Beginner
Free

Master Data Management for Beginners

TCS iON

1 Week Online
Beginner
Free
Everything about Databases using SQL and MongoDB

Everything about Databases using SQL and MongoDB

Skill Lync

12 Weeks Online
Beginner

Databases and Structured Query Language for Data S...

IBM via Coursera

6 Weeks Online
Beginner
₹ 4,115

Using Databases with Python

UM–Ann Arbor via Coursera

Online
Beginner
Learn SQL

Learn SQL

Udacity

4 Months Online
Beginner

Courses of your Interest

Professional Certificate Course in Data Science

Professional Certificate Course in Data Science

Newton School

8 Months Online
Beginner

JavaScript Foundations

PW Skills

Online
Beginner
Free

Technical Analysis Series

PW Skills

3 Months Online
Beginner
Free

C Programming Foundations

PW Skills

Online
Beginner
Free

Cracking the Coding Interview in Java Foundation

PW Skills

5 Months Online
Beginner
Free

Python Foundations

PW Skills

Online
Beginner
Free
Getting Started with Generative AI APIs

Getting Started with Generative AI APIs

Codio via Coursera

3 Weeks Online
Beginner
Generating code with ChatGPT API

Generating code with ChatGPT API

Codio via Coursera

3 Weeks Online
Beginner
Prompt Engineering for ChatGPT

Prompt Engineering for ChatGPT

Vanderbilt via Coursera

Online
Beginner

Data Structures and Algorithms in Java

Great Learning

Online
Beginner
Free

More Courses by IBM

Artificial Intelligence Chatbots Without Programmi...

IBM via Edx

2 Weeks Online
Beginner
Free

R Programming Basics for Data Science

IBM via Edx

5 Weeks Online
Beginner
Free

Threat Intelligence Lifecycle Fundamentals

IBM via Edx

4 Weeks Online
Beginner
Free

Introduction to Data Engineering

IBM via Coursera

4 Weeks Online
Beginner

Introduction to the Threat Intelligence Lifecycle

IBM via Coursera

3 Weeks Online
Beginner
Free

Introduction to Web Development with HTML CSS Java...

IBM via Coursera

5 Weeks Online
Beginner

Introduction to Devops

IBM via Coursera

6 Weeks Online
Beginner

Data Scientist Career Guide and Interview Preparat...

IBM via Coursera

9 Hours Online
Beginner

Data Analyst Career Guide and Interview Preparatio...

IBM via Coursera

4 Weeks Online
Beginner

Introduction to Software Programming and Databases

IBM via Coursera

5 Weeks Online
Beginner

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books