К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Introduction to Relational Databases (RDBMS) · LearnSpace
Назад в каталог
courseraIT и технологии

Introduction to Relational Databases (RDBMS)

Курс от IBM
Начальный≈ 16.4 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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.

Навыки, которые вы освоите

Relational DatabasesPostgreSQLMySQLDatabase DesignSQLData IntegrityDatabase Architecture and AdministrationDatabase SystemsCommand-Line InterfaceDatabase DevelopmentData ModelingIBM DB2Database ManagementDatabasesDatabase SoftwareData Import/ExportDatabase AdministrationDatabase Management Systems

Программа курса

4 модулей · 81 учебных материалов

01Relational Database Concepts25 материалов

Welcome to the Course

Course IntroductionВидеоCourse OverviewЧтениеHelpful Tips For Course CompletionPLUGIN

Fundamental Relational Database Concepts

Review of Data Fundamentals Видео

Учитесь у экспертов

Rav Ahuja

CCO & Global Program Director

Sandip Saha Joy

Former Data Scientist

Introduction to Relational Databases (RDBMS)
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 16.4 ч

4 модулей

Язык: Английский

Субтитры: Арабский, Французский, Бенгальский, Узбекский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Вьетнамский, Нидерландский, Корейский, Немецкий, Пушту, Урду, Русский, Тайский, Индонезийский, Шведский, Турецкий, Азербайджанский, Испанский, Дари, Хинди, Японский, Казахский, Венгерский, Польский

Часть программы вашего университета
Information and Data ModelsВидео
ERDs and Types of RelationshipsВидео
Mapping Entities to TablesВидео
Data TypesВидео
Relational Model ConceptsВидео
Hands-on Lab: Relational Model ConceptsPLUGIN
Summary and Highlights Чтение
Practice Quiz: Fundamental Relational Database ConceptsЗадание
Graded Quiz: Fundamental Relational Database ConceptsЗадание

Introducing Relational Database Products

Database ArchitectureВидеоDistributed Architecture and Clustered DatabasesВидеоDatabase Usage PatternsВидеоIntroduction to Relational Database OfferingsВидеоDb2ВидеоMySQLВидеоPostgreSQLВидеоDeep Dive into Advanced Relational Model ConceptsЧтениеReading: Advanced Relational Model ConceptsPLUGINSummary and HighlightsЧтениеPractice Quiz: Introducing Relational Database ProductsЗаданиеGraded Quiz: Introducing Relational Database ProductsЗадание
02Using Relational Databases25 материалов

Creating Tables and Loading Data

Types of SQL Statements (DDL vs. DML)ВидеоCreating TablesВидеоCREATE TABLE StatementВидеоALTER, DROP, and Truncate TablesВидеоData Movement UtilitiesВидеоLoading DataВидеоHands-on Lab: Create Tables and Load Data in DatasetteВнешний инструментSummary and HighlightsЧтениеPractice Quiz: Creating Tables and Loading DataЗаданиеGraded Quiz: Creating Tables and Loading DataЗадание

Designing Keys, Indexes, and Constraints

Database Objects and Hierarchy (Including Schemas)ВидеоPrimary Keys and Foreign KeysВидеоOverview of IndexesВидеоNormalizationВидеоRelational Model Constraints - AdvancedВидеоHands-on Lab: Normalization, Keys, and Constraints in Relational DatabaseВнешний инструмент

(Optional) Db2 Labs

Reading: Overview of Optional LessonPLUGINOptional Lesson OverviewЧтение(Optional) Obtain IBM Cloud Feature Code and Activate Trial AccountВнешний инструментCreate Db2 Service InstanceЧтениеCreate Tables and Load Data in Db2Чтение(Optional) Hands-on Lab: Normalization, Keys, and Constraints in Relational Databases (with Db2)PLUGIN
03MySQL and PostgreSQL19 материалов

MySQL

Getting Started with MySQLВидеоCreating Databases and Tables in MySQLВидеоPopulating MySQL Databases and TablesВидеоHands-on Lab: Getting Started with MySQL Command LineВнешний инструментHands-on Lab: Create Tables and Load Data in MySQL using phpMyAdminВнешний инструментUsing Keys and Constraints in MySQLВидеоHands-on Lab: Keys and Constraints in MySQL using phpMyAdminВнешний инструментSummary and HighlightsЧтениеPractice Quiz: MySQLЗаданиеGraded Quiz: MySQLЗадание

PostgreSQL

Getting Started with PostgreSQLВидеоCreating Databases and Loading Data in PostgreSQLВидеоHands-on Lab: Getting Started with PostgreSQL Command LineВнешний инструментHands-on Lab: Create Tables and Load Data in PostgreSQL using pgAdminВнешний инструментViewsВидеоHands-on Lab: Views in PostgreSQLВнешний инструмент
04Final Project and Assessment12 материалов

Final Project

Approach to Database Design (Including ERD)ВидеоBest Practices of RDBMS DesignЧтениеHands-on Lab: Database Design Using ERDsВнешний инструментProject OverviewЧтениеFinal Submission Guidelines and DeliverablesЧтениеFinal Project: Database Design and ImplementationВнешний инструментOption 1: AI Graded - Final Project: Submission and EvaluationВнешний инструментAI Graded - Final Project Submission and EvaluationЗадание

Glossary and Final Assessment

Course GlossaryPLUGINFinal ExamЗадание

Course Wrap-up

Congratulations and Next StepsЧтениеThanks from the Course TeamЧтение
Summary and Highlights Чтение
Practice Quiz: Designing Keys, Indexes, and ConstraintsЗадание
Graded Quiz: Designing Keys, Indexes, and ConstraintsЗадание
Summary and HighlightsЧтение
Practice Quiz: PostgreSQLЗадание
Graded Quiz: PostgreSQLЗадание