课程

数据库设计

基础技能水平

更新时间 2026年3月

学习使用 SQL 设计数据库，以更高效地处理、存储和组织数据。

免费开始课程

SQLData Engineering

4小时

13 视频

52 道练习

4,150 XP

120K+

成就证明

深受数千家公司学习者的喜爱

需要团队培训？

企业版试用

课程描述

良好的数据库设计对于高性能应用至关重要。就像在建房前一定要有蓝图一样，您也需要事先考虑数据将如何存储。花时间进行数据库设计能在后续节省时间并避免挫折，而良好的设计还能确保信息访问与检索更为便捷。在选择设计时，需要综合考虑多方面因素。在本课程中，您将学习如何高效地处理、存储和组织数据。您会看到如何通过规范化来构建数据结构，并使用视图呈现数据。最后，您还将学习如何管理数据库；整个过程将基于多种数据集展开，从图书销售、汽车租赁到音乐评论。视频包含实时字幕，您可以点击视频左下角的 "Show transcript" 进行查看。课程术语表位于右侧的资源区域。如需获取 CPE 学分，您需要完成课程并在合格测评中取得 70% 的成绩。您可点击右侧的 CPE 学分提示跳转到测评。

先决条件

Introduction to Relational Databases in SQL

1

Processing, Storing, and Organizing Data

Start your journey into database design by learning about the two approaches to data processing, OLTP and OLAP. In this first chapter, you'll also get familiar with the different forms data can be stored in and learn the basics of data modeling.

OLTP and OLAP

OLAP vs. OLTP

Which is better?

Storing data

Name that data type!

Ordering ETL Tasks

Recommend a storage solution

Database design

Classifying data models

Deciding fact and dimension tables

Querying the dimensional model

2

Database Schemas and Normalization

In this chapter, you will take your data modeling skills to the next level. You'll learn to implement star and snowflake schemas, recognize the importance of normalization and see how to normalize databases to different extents.

Star and snowflake schema

Running from star to snowflake

Adding foreign keys

Extending the book dimension

Normalized and denormalized databases

Querying the star schema

Querying the snowflake schema

Updating countries

Extending the snowflake schema

Normal forms

Converting to 1NF

Converting to 2NF

Converting to 3NF

3

Database Views

Get ready to work with views! In this chapter, you will learn how to create and query views. On top of that, you'll master more advanced capabilities to manage them and end by identifying the difference between materialized and non-materialized views.

Database views

Tables vs. views

Viewing views

Creating and querying a view

Managing views

Creating a view from other views

Granting and revoking access

Updatable views

Redefining a view

Materialized views

Materialized versus non-materialized

Creating and refreshing a materialized view

Managing materialized views

4

Database Management

This final chapter ends with some database management-related topics. You will learn how to grant database access based on user roles, how to partition tables into smaller pieces, what to keep in mind when integrating data, and which DBMS fits your business needs best.

Database roles and access control

Create a role

GRANT privileges and ALTER attributes

Add a user role to a group role

Table partitioning

Reasons to partition

Partitioning and normalization

Creating vertical partitions

Creating horizontal partitions

Data integration

Data integration do's and dont's

Analyzing a data integration plan

Picking a Database Management System (DBMS)

SQL versus NoSQL

Choosing the right DBMS

数据库设计

课程完成

获得成就证明

将此证书添加到您的 LinkedIn 档案、简历或履历中
在社交媒体和绩效评估中分享立即注册

加入超过19百万学习者，今天就开始数据库设计！

通过 DataCamp for Mobile 提升您的数据技能

随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。