From the course: Learning MySQL Development

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Common database terms

Common database terms

- [Instructor] Like any computer system, DBMSs have a detailed technical vocabulary. This vocabulary makes it possible to discuss database-specific questions in detail, but it can be impenetrable to newcomers. In this video, I'll touch on terms and ideas that you'll see in action throughout the rest of this course. A database is a set of ordered, related data stored on a computer. This is true of any type of database, but this course focuses specifically on relational databases, a type of database model that focuses on organizing data into rows and columns within tables. A table is a collection of closely related data. In theory, all data in a database could be stored in a single giant table. However, organizing data into many tables is more efficient from both a human's and a computer's perspective. It makes the data much more readable, and it also takes much, much less processing power to interact with numerous…

Contents