课程: Intermediate SQL for Data Scientists

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Data definition commands

Data definition commands - SQL教程

课程: Intermediate SQL for Data Scientists

开始一个月试用 购买团队方案

Data definition commands

“

- [Instructor] Now we're going to look at data definition commands, the second type of SQL command. Data definition commands allow us to manipulate data structures within a relational database. Now there are many different types of data structures that we have built into relational databases. We're going to focus on four tables, indexes, views, and schemas. Now, tables are probably the most familiar data structure to those of us who've worked with SQL databases. Here's an example of a data manipulation command for creating a table, and we'll walk through each of the main components. But as you can see, it allows us to create a particular table that has certain columns and certain data types. So the first part of a create table statement is the set of key terms or keywords create table. Now we follow that by the name of the table. In this case, we're creating a table called staff. Now, after the create table clause, we have a list, and those are a list of columns. Now each column is…

内容