Buy Now AED 170.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Introduction to Relational Databases (RDBMS)
  • Level Foundation
  • المدة 19 ساعات hours
  • الطبع بواسطة IBM
  • Offered by

عن

Are you ready to dive into the world of data engineering? You'll need a solid understanding of how data is stored, processed, and accessed. You'll need to identify the different types of database that are appropriate for the kind of data you are working with and what processing the data requires. In this course, you will learn the essential concepts behind relational databases and Relational Database Management Systems (RDBMS). You'll study relational data models and discover how they are created and what benefits they bring, and how you can apply them to your own data. You'll be introduced to several industry standard relational databases, including IBM DB2, MySQL, and PostgreSQL. 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. 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.

الوحدات

Welcome to the Course

    • 1 Videos
    • 1 Readings
    • 1 Plugin
Show info about module content

1 Videos

  • Course Introduction

1 Readings

  • Course Overview

Fundamental Relational Database Concepts

    • 6 Videos
    • 1 Readings
    • 1 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz: Fundamental Relational Database Concepts
  • Graded Quiz: Fundamental Relational Database Concepts

6 Videos

  • Review of Data Fundamentals
  • Information and Data Models
  • ERDs and Types of Relationships
  • Mapping Entities to Tables
  • Data Types
  • Relational Model Concepts

1 Readings

  • Summary and Highlights

Introducing Relational Database Products

    • 7 Videos
    • 1 Readings
    • 2 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz: Introducing Relational Database Products
  • Graded Quiz: Introducing Relational Database Products

7 Videos

  • Database Architecture
  • Distributed Architecture and Clustered Databases
  • Database Usage Patterns
  • Introduction to Relational Database Offerings
  • Db2
  • MySQL
  • PostgreSQL

1 Readings

  • Summary and Highlights

Creating Tables and Loading Data

    • 6 Videos
    • 1 Readings
    • 1 ExternalTool
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz: Creating Tables and Loading Data
  • Graded Quiz: Creating Tables and Loading Data

1 External Tool

  • Hands-on Lab: Create Tables and Load Data in Datasette

6 Videos

  • Types of SQL Statements (DDL vs. DML)
  • Creating Tables
  • CREATE TABLE Statement
  • ALTER, DROP, and Truncate Tables
  • Data Movement Utilities
  • Loading Data

1 Readings

  • Summary and Highlights

Designing Keys, Indexes, and Constraints

    • 5 Videos
    • 1 Readings
    • 1 ExternalTool
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz: Designing Keys, Indexes, and Constraints
  • Graded Quiz: Designing Keys, Indexes, and Constraints

1 External Tool

  • Hands-on Lab: Normalization, Keys, and Constraints in Relational Database

5 Videos

  • Database Objects and Hierarchy (Including Schemas)
  • Primary Keys and Foreign Keys
  • Overview of Indexes
  • Normalization
  • Relational Model Constraints - Advanced

1 Readings

  • Summary and Highlights

(Optional) Db2 Labs

    • 1 ExternalTool
    • 4 Plugin
Show info about module content

1 External Tool

  • (Optional) Obtain IBM Cloud Feature Code and Activate Trial Account

MySQL

    • 4 Videos
    • 1 Readings
    • 3 ExternalTool
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz: MySQL
  • Graded Quiz: MySQL

3 External Tool

  • Hands-on Lab: Getting Started with MySQL Command Line
  • Hands-on Lab: Create Tables and Load Data in MySQL using phpMyAdmin
  • Hands-on Lab: Keys and Constraints in MySQL using phpMyAdmin

4 Videos

  • Getting Started with MySQL
  • Creating Databases and Tables in MySQL
  • Populating MySQL Databases and Tables
  • Using Keys and Constraints in MySQL

1 Readings

  • Summary and Highlights

PostgreSQL

    • 3 Videos
    • 1 Readings
    • 3 ExternalTool
    • 2 Assignment
Show info about module content

2 Assignment

  • Practice Quiz: PostgreSQL
  • Graded Quiz: PostgreSQL

3 External Tool

  • Hands-on Lab: Getting Started with PostgreSQL Command Line
  • Hands-on Lab: Create Tables and Load Data in PostgreSQL using pgAdmin
  • Hands-on Lab: Views in PostgreSQL

3 Videos

  • Getting Started with PostgreSQL
  • Creating Databases and Loading Data in PostgreSQL
  • Views

1 Readings

  • Summary and Highlights

Final Project

    • 1 Videos
    • 1 PeerReview
    • 2 ExternalTool
    • 2 Plugin
Show info about module content

2 External Tool

  • Hands-on Lab: Database Design Using ERDs
  • Final Project: Database Design and Implementation

1 Peer Review

  • Project Submission and Peer Review

1 Videos

  • Approach to Database Design (Including ERD)

Glossary and Final Assessment

    • 1 Plugin
    • 1 Assignment
Show info about module content

1 Assignment

  • Final Exam

Course Wrap-up

    • 2 Readings
Show info about module content

2 Readings

  • Congratulations and Next Steps
  • Thanks from the Course Team

Auto Summary

Embark on a journey into the realm of data engineering with the "Introduction to Relational Databases (RDBMS)" course, designed for beginners eager to master the fundamentals of relational databases. This course, nestled within the IT & Computer Science domain, is crafted by Coursera and steered by expert instructors. You will uncover the essentials of how data is stored, processed, and accessed within various relational database systems like IBM DB2, MySQL, and PostgreSQL. The course also introduces you to professional RDBMS tools such as phpMyAdmin and pgAdmin, alongside practical usage of command line and SQL statements for database management. Experience hands-on learning through practical exercises involving real databases and datasets. From creating database instances to populating them with tables and data, you will gain invaluable real-world skills. By the course's conclusion, you will complete a final assignment that showcases your ability to design databases, normalize tables, create and manage database elements, and effectively handle data. Designed for learners with no prior knowledge of databases or programming, this foundational course makes it accessible to everyone. Audit the course for free or opt for a subscription to earn a Coursera course certificate along with an IBM digital badge upon successful completion. With a duration of approximately 19 hours, this course offers flexible subscription options including Starter, Professional, and Paid plans, catering to a wide range of learning needs. Dive in and empower yourself with the skills to thrive in the data-driven world.

Rav Ahuja
Instructors

Rav Ahuja

Sandip Saha Joy
Instructors

Sandip Saha Joy