IBM - Introduction to Relational Databases
- Offered byCoursera
Introduction to Relational Databases at Coursera Overview
Duration | 13 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
Introduction to Relational Databases at Coursera Highlights
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Course 4 of 5 in the Data Engineering Foundations Specialization
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Beginner Level Computer and IT literacy. Curiosity about how data is managed.
- Approx. 13 hours to complete
- English Subtitles: English
Introduction to Relational Databases at Coursera Course details
- 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.
Introduction to Relational Databases at Coursera Curriculum
Relational Database Concepts
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
Course Introduction
Summary & Highlights
Summary & Highlights
Practice Quiz: Fundamental Relational Database Concepts
Graded Quiz: Fundamental Relational Database Concepts
Practice Quiz: Introducing Relational Database Products
Graded Quiz: Introducing Relational Database Products
Using Relational Databases
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
Summary & Highlights
Summary & Highlights
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
MySQL and PostgreSQL
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
Summary & Highlights
Summary & Highlights
Practice Quiz: MySQL
Graded Quiz: MySQL
Practice Quiz: PostgreSQL
Graded Quiz: PostgreSQL
Course Assignment
Approach to Database Design (Including ERD)
Congratulations & Next Steps
Course Team & Acknowledgements
Final Quiz
Introduction to Relational Databases at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?