Data ScienceLesson 4Free preview
DS Database Table
This lesson is part of Data Science · All levels
Summary
A database is a collection of related tables, while a single table holds specific data in the form of rows (records) and fields (fields). The primary key serves as a unique identifier for each row to prevent duplicate data. SQL language queries such as SELECT are used to take data as needed for analysis.
Key points
- The row is one whole record; the field is one attribute.
- The primary key guarantees the uniqueness of each line.
- Database is a collection of related tables.
- SQL query to take, filter, and change data.
- The relationship between tables avoids duplication of data.
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.