|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/introduction-to-relational-databases
课程评论：没有评论
课程名称：关系数据库入门（RDBMS） 简介：您是否准备好深入数据工程的世界？您需要深入了解数据是如何存储、处理和访问的，以及如何识别适合您工作中的不同类型的数据库及数据处理需求。在本课程中，您将学习关系数据库和关系数据库管理系统（RDBMS）的基本概念。您将研究关系数据模型，了解它们如何创建及其带来的好处，并学习如何将其应用到自己的数据中。课程还将介绍多个行业标准的关系数据库，包括 IBM DB2、MySQL 和 PostgreSQL。 课程内容中包含实践性操作，帮助您验证学习成果。您将使用 real databases（真实数据库）并探索实际数据集，创建数据库实例并填充数据表。 本课程不需要任何数据库或编程的前期知识。 任何人都可以免费旁听本课程。如果您选择参加并获得 Coursera 课程证书，成功完成课程后还可以获得 IBM 数字徽章。 课程大纲： 1. **关系数据库概念**：该模块中，您将学习数据结构和文件格式的基本方面，了解关系数据库与非关系数据库之间的区别，探索各种类型的数据模型，讨论数据库管理的基本概念，深入了解实体-关系图（ERD）及其组成部分和关系，最终掌握 Db2 和 PostgreSQL 的相关知识。 2. **使用关系数据库**：在此模块中，您将探讨 SQL 语句的类型，例如数据定义语言（DDL）和数据操作语言（DML）。您将学习如何使用 DDL 语句创建、修改和管理数据表，理解数据移动工具以实现高效的数据加载和管理。此外，您还将研究关键数据库对象，如模式、主键、外键和索引，了解它们在数据组织、完整性和检索中的作用，以及归一化在减少冗余和确保数据一致性中的重要性。 3. **MySQL 和 PostgreSQL**：在该模块中，您将了解 MySQL 和 PostgreSQL 的基本方面，并识别关系数据库管理系统（RDBMS）工具。您将探索创建数据库和表的过程，学习 MySQL 中键、约束和连接的定义。此外，您将通过命令行、pgAdmin 和视图发现 PostgreSQL 中的重要操作，掌握数据库加载技术、保护敏感数据及简化数据检索的技能。 4. **最终项目和评估**：在这个模块中，您将导航数据库设计过程，提升实践技能，理解必要步骤。将发现实体关系图（ERD）的作用，并有机会参与实践数据库设计实验室，在这里您可以运用理论知识创建数据库。同时，您将获得可选的最终作业和项目提交阶段，对于寻求更高挑战的人，还可以完成一个使用 Db2 的最终项目。模块中提供的术语表供快速参考。 加入课程，开始您的数据库学习之旅吧！
Name:Relational Database Concepts
Description: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.
Name:Using Relational Databases
Description: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.
Name:MySQL and PostgreSQL
Description: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.
Name:Final Project and Assessment
Description: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 Db2 is available. A glossary is available for quick reference to key terms used throughout the module.
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.
