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 - MySQL Tutorial
From the course: Learning MySQL Development
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.