Introduction to Relational Databases (RDBMS)
Ends soon! Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Introduction to Relational Databases (RDBMS)
This course is part of multiple programs.
Instructors: Rav Ahuja
100,119 already enrolled
Included with
792 reviews
Recommended experience
792 reviews
Recommended experience
What you'll 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.
Develop a working knowledge of popular DBMSes including MySQL, PostgreSQL, and IBM DB2
Skills you'll gain
Details to know
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
There are 4 modules in this course
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.
In this module, you will first learn about the fundamental aspects of data structures and file formats, along with the differences between relational and non-relational databases. You’ll explore various types of data models and discuss fundamental concepts in database management. Additionally, you’ll explore Entity-Relationship Diagrams (ERD) along with their components and relationships. You will also gain expertise in diverse database topics. Finally, you’ll gain a clear understanding of Db2 and PostgreSQL.
What's included
14 videos4 readings4 assignments3 plugins
14 videos•Total 86 minutes
- Course Introduction•4 minutes
- Review of Data Fundamentals •8 minutes
- Information and Data Models•6 minutes
- ERDs and Types of Relationships•5 minutes
- Mapping Entities to Tables•5 minutes
- Data Types•5 minutes
- Relational Model Concepts•6 minutes
- Database Architecture•6 minutes
- Distributed Architecture and Clustered Databases•5 minutes
- Database Usage Patterns•7 minutes
- Introduction to Relational Database Offerings•8 minutes
- Db2•10 minutes
- MySQL•7 minutes
- PostgreSQL•5 minutes
4 readings•Total 15 minutes
- Course Overview•3 minutes
- Summary and Highlights •1 minute
- Deep Dive into Advanced Relational Model Concepts•10 minutes
- Summary and Highlights•1 minute
4 assignments•Total 50 minutes
- Practice Quiz: Fundamental Relational Database Concepts•10 minutes
- Practice Quiz: Introducing Relational Database Products•10 minutes
- Graded Quiz: Fundamental Relational Database Concepts•15 minutes
- Graded Quiz: Introducing Relational Database Products•15 minutes
3 plugins•Total 26 minutes
- Helpful Tips For Course Completion•1 minute
- Hands-on Lab: Relational Model Concepts•10 minutes
- Reading: Advanced Relational Model Concepts•15 minutes
In this module, you’ll explore the types of SQL statements, like Data Definition Language (DDL) and Data Manipulation Language (DML). You’ll learn how to create, modify, and manage tables using DDL statements and understand data movement utilities for efficient data loading and management. Additionally, you’ll dive into key database objects such as schemas, primary keys, foreign keys, and indexes, gaining insights into their roles in data organization, integrity, and retrieval. You’ll also understand the importance of normalization for reducing redundancy and ensuring data consistency, while also understanding various constraints within the relational model to maintain data accuracy and reliability.
What's included
11 videos5 readings4 assignments3 app items2 plugins
11 videos•Total 52 minutes
- Types of SQL Statements (DDL vs. DML)•2 minutes
- Creating Tables•5 minutes
- CREATE TABLE Statement•3 minutes
- ALTER, DROP, and Truncate Tables•4 minutes
- Data Movement Utilities•6 minutes
- Loading Data•4 minutes
- Database Objects and Hierarchy (Including Schemas)•7 minutes
- Primary Keys and Foreign Keys•4 minutes
- Overview of Indexes•5 minutes
- Normalization•6 minutes
- Relational Model Constraints - Advanced•5 minutes
5 readings•Total 51 minutes
- Summary and Highlights•2 minutes
- Summary and Highlights •2 minutes
- Optional Lesson Overview•2 minutes
- Create Db2 Service Instance•15 minutes
- Create Tables and Load Data in Db2•30 minutes
4 assignments•Total 50 minutes
- Practice Quiz: Creating Tables and Loading Data•10 minutes
- Practice Quiz: Designing Keys, Indexes, and Constraints•10 minutes
- Graded Quiz: Creating Tables and Loading Data•15 minutes
- Graded Quiz: Designing Keys, Indexes, and Constraints•15 minutes
3 app items•Total 95 minutes
- Hands-on Lab: Create Tables and Load Data in Datasette•20 minutes
- Hands-on Lab: Normalization, Keys, and Constraints in Relational Database•60 minutes
- (Optional) Obtain IBM Cloud Feature Code and Activate Trial Account•15 minutes
2 plugins•Total 27 minutes
- Reading: Overview of Optional Lesson•2 minutes
- (Optional) Hands-on Lab: Normalization, Keys, and Constraints in Relational Databases (with Db2)•25 minutes
In this module, you will learn about the fundamental aspects of MySQL and PostgreSQL and identify Relational Database Management System (RDBMS) tools. You will explore the process of creating databases and tables and the definition of keys, constraints, and connections in MySQL. Additionally, you will discover important processes in PostgreSQL using command line, pgAdmin, and views. Moreover, you will gain essential skills such as database loading techniques and insights into securing sensitive data and streamlining data retrieval.
What's included
7 videos2 readings4 assignments6 app items
7 videos•Total 35 minutes
- Getting Started with MySQL•8 minutes
- Creating Databases and Tables in MySQL•3 minutes
- Populating MySQL Databases and Tables•5 minutes
- Using Keys and Constraints in MySQL•4 minutes
- Getting Started with PostgreSQL•7 minutes
- Creating Databases and Loading Data in PostgreSQL•5 minutes
- Views•3 minutes
2 readings•Total 3 minutes
- Summary and Highlights•2 minutes
- Summary and Highlights•1 minute
4 assignments•Total 50 minutes
- Practice Quiz: MySQL•10 minutes
- Practice Quiz: PostgreSQL•10 minutes
- Graded Quiz: MySQL•15 minutes
- Graded Quiz: PostgreSQL•15 minutes
6 app items•Total 115 minutes
- Hands-on Lab: Getting Started with MySQL Command Line•20 minutes
- Hands-on Lab: Create Tables and Load Data in MySQL using phpMyAdmin•20 minutes
- Hands-on Lab: Keys and Constraints in MySQL using phpMyAdmin•20 minutes
- Hands-on Lab: Getting Started with PostgreSQL Command Line•20 minutes
- Hands-on Lab: Create Tables and Load Data in PostgreSQL using pgAdmin•20 minutes
- Hands-on Lab: Views in PostgreSQL•15 minutes
In this module, you will navigate the database design process, refine your practical skills, and understand essential steps. You will discover the role of Entity Relationship Diagrams (ERDs) and get an opportunity to engage in a hands-on database design lab, where you will use your theoretical knowledge to create databases. As you progress, you will receive an optional final assignment and project submission stages. For those seeking an advanced challenge, a final project using PostgreSQL, MySQL and (optionally) Db2. A glossary is available for quick reference to key terms used throughout the module.
What's included
1 video5 readings2 assignments3 app items1 plugin
1 video•Total 7 minutes
- Approach to Database Design (Including ERD)•7 minutes
5 readings•Total 28 minutes
- Best Practices of RDBMS Design•20 minutes
- Project Overview•2 minutes
- Final Submission Guidelines and Deliverables•2 minutes
- Congratulations and Next Steps•2 minutes
- Thanks from the Course Team•2 minutes
2 assignments•Total 75 minutes
- AI Graded - Final Project Submission and Evaluation•30 minutes
- Final Exam•45 minutes
3 app items•Total 195 minutes
- Option 1: AI Graded - Final Project: Submission and Evaluation•60 minutes
- Hands-on Lab: Database Design Using ERDs•45 minutes
- Final Project: Database Design and Implementation•90 minutes
1 plugin•Total 25 minutes
- Course Glossary•25 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructors
Why people choose Coursera for their career
Learner reviews
- 5 stars
74.30%
- 4 stars
17.12%
- 3 stars
3.90%
- 2 stars
1.88%
- 1 star
2.77%
Showing 3 of 792
Reviewed on Oct 7, 2024
The course is well detailed and has a follow along approach. I love the lab activity also, it is easy to navigate.
Reviewed on Mar 17, 2024
Great course that sums up all that it teaches at the end, unfortunately I encountered an error loading PostgreSQL and MySQL at the end on the cloud IBM platform so I did it in VisCode
Reviewed on Dec 28, 2023
good kjhjkhjkhkhkjhjkhkjhjkhjkh jkhjkhkjhkhkjhjkhjkhjkhkjh jjkh jjkhj hjjh jhjh jhjh jjhj ljlkj iipi iouu ytftyt td ghb
Frequently asked questions
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. 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.
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.
More questions
Financial aid available,
¹ Some assignments in this course are AI-graded. For these assignments, your data will be used in accordance with Coursera's Privacy Notice.