- 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
Beginner
Online
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. 3,177 |
certificate availability
certificate providing authority
What you will learn
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
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
Global Program Director
IBM
B.E /B.Tech, MBA
Mr Sandip Saha Joy
Data Scientist
IBM
Other Bachelors
Ms Lin Joyner
Senior Instructional Designer & Content Developer
IBM
Ms Rose Malcolm
Senior Instructional Designer & Content Developer
IBM
Articles
Popular Articles
Latest Articles
Similar Courses
NoSQL Database
Great Learning
Relational Database Administration
IBM via Coursera
Introduction to NoSQL Databases
IBM via Coursera
NoSQL Database Basics
IBM via Edx
Relational Database Basics
IBM via Edx
Introduction to Database Queries
NYU via Edx
Databases and Structured Query Language for Data S...
IBM via Coursera
Courses of your interest
Professional Certificate Course in Data Science
Newton School
JavaScript Foundations
PW Skills
Technical Analysis Series
PW Skills
C Programming Foundations
PW Skills
Python Foundations
PW Skills
Getting Started with Generative AI APIs
Codio via Coursera
Generating code with ChatGPT API
Codio via Coursera
Prompt Engineering for ChatGPT
Vanderbilt via Coursera
Data Structures and Algorithms in Java
Great Learning
More Courses by IBM
R Programming Basics for Data Science
IBM via Edx
Threat Intelligence Lifecycle Fundamentals
IBM via Edx
Introduction to Data Engineering
IBM via Coursera
Introduction to the Threat Intelligence Lifecycle
IBM via Coursera
Introduction to Web Development with HTML CSS Java...
IBM via Coursera
Introduction to Devops
IBM via Coursera
Data Scientist Career Guide and Interview Preparat...
IBM via Coursera
Data Analyst Career Guide and Interview Preparatio...
IBM via Coursera
Introduction to Software Programming and Databases
IBM via Coursera