From the course: Complete Guide to T-SQL for Data Analysts by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,200 courses taught by industry experts.

Describe features of structured data

Describe features of structured data - SQL Tutorial

From the course: Complete Guide to T-SQL for Data Analysts by Microsoft Press

Start my 1-month free trial Buy for my team

Describe features of structured data

“

- [Chris] In this sub-lesson, we are going to describe features of structured data. So some features of structured data are a schema, which is a definition of how data is organized in a system. Structured data is data that adheres to a fixed schema, most commonly represented as one or more tables with tables having one or more columns, and tables contain rows of data. Examples of structured data are relational databases and files such as CSVs and tab-delimited files. Some features of structured data are the following. We generally end up with an entity, or a table here, in this case called Person. So this entity or table is collecting information about people in our database. We can see that there are four columns of information in this table. The Person ID itself, the Name, Email, and Address, and this is just a subset of information that you would possibly want to collect on a person in your database. The columns…

Contents