コース
SQLで学ぶリレーショナルデータベース入門
基礎スキルレベル
更新日 2026/01
SQLProgramming4時間13 ビデオ45 演習3,600 XP190K+達成証明書
数千の企業の学習者に愛されています
Training a Team?
Try for Businessコース説明
前提条件
Intermediate SQL1
Your first database
In this chapter, you'll create your very first database with a set of simple SQL commands. Next, you'll migrate data from existing flat tables into that database. You'll also learn how meta-information about a database can be queried.
2
Enforce data consistency with attribute constraints
After building a simple database, it's now time to make use of the features. You'll specify data types in columns, enforce column uniqueness, and disallow NULL values in this chapter.
3
Uniquely identify records with key constraints
Now let’s get into the best practices of database engineering. It's time to add primary and foreign keys to the tables. These are two of the most important concepts in databases, and are the building blocks you’ll use to establish relationships between tables.
4
Glue together tables with foreign keys
In the final chapter, you'll leverage foreign keys to connect tables and establish relationships that will greatly benefit your data quality. And you'll run ad hoc analyses on your new database.
SQLで学ぶリレーショナルデータベース入門
コース完了 19百万人を超える学習者と一緒にSQLで学ぶリレーショナルデータベース入門を今日から始めましょう！
DataCamp for Mobileでデータスキルを磨きましょう
モバイル コースと毎日の 5 分間のコーディング チャレンジで、外出先でも進歩できます。