Creating Database Tables with SQL

4.6
290 个评分
提供方
Coursera Project Network
6,774 人已注册
在此指导项目中,您将:

Create a relational table with SQL code.

Alter the structure of an existing table with SQL code.

Identify the attributes of a relational table.

Clock50 minutes
Intermediate中级
Cloud无需下载
Video分屏视频
Comment Dots英语(English)
Laptop仅限桌面

In this course you will experience the process of defining, creating, and managing relational database tables using the SQL language. Tables are used as the containers for the data in a database. As such, the structure, or makeup, of each table in a relational database is critical, since it must be designed and created specifically to meet the needs of the data it will contain. The table’s structure indicates which pieces of data are stored in a table, as well as the type and size of each piece of data. Throughout the course, you’ll be exposed to guidelines and rules that database designers use to make sure that the tables will keep the data as safe and accurate as possible. You’ll learn to use SQL code to incorporate the constraints that help the database management enforce those rules. As you work through and complete hands-on tasks, you’ll become familiar with SQLiteStudio, the database management system used in the course. Tables that are well-designed and created correctly improve data integrity--and make data retrieval easier! Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

您要培养的技能

  • Database (DBMS)
  • Sql Commands
  • Relational Database
  • SQLiteStudio
  • SQL

分步进行学习

在与您的工作区一起在分屏中播放的视频中,您的授课教师将指导您完成每个步骤:

  1. The CREATE TABLE Command

  2. Rules for Relational Tables

  3. Adding Constraints

  4. The ALTER Command

  5. Build a Database with a Script

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

授课教师

审阅

来自CREATING DATABASE TABLES WITH SQL的热门评论

查看所有评论

常见问题

常见问题

还有其他问题吗?请访问 学生帮助中心