MySQL is a relational database management system (DBMS). In this overview, learn how MySQL stores data, and how that data can be recalled, combined, and transformed using SQL queries, a common database language.
- [Narrator] MySQL is one of the world's most popular relational database management systems. Though it's owned by Oracle Corporation, it's licensed under the GNU General Public License and is free to download and use. As a database management system, MySQL can be used to add, access, and process extremely large amounts of diverse data, from shopping transactions to population data to picture galleries and bulk text. MySQL is especially popular with web applications and underpins many popular web services, like WordPress, Joomla, Drupal, and phpBB.
MySQL is called relational because all the data it contains is logically divided into different databases and then further sub divided into different tables. Think of a database as a folder in a typical desktop environment, and then the tables as files within that folder. In fact, that's very similar to how MySQL stores its data on your computer. Because the data is all relational, you can either view the raw tables, or you can view just a subset of a table using queries to pair down the amount of data to just what you need. Queries are an essential feature of any DBMS, and they're incredibly powerful.
The right query can pull data from multiple tables, transform the data, and review relationships between data sets. Queries can even draw from the results of other queries, and with a few additional commands, you can turn the results of queries into a more prominent table. Queries are central to all of my solutions to the challenges in this course, and they're so central to the concept of relational databases that the SQL part of MySQL stands for structured query language, a standardized language used to interact with many types of DBMSs. The SQL code I use throughout this course can be used with only minor changes with many types of database software.
On a final note, the official way to pronounce MySQL is my ess que ell, though the official documentation notes that they don't mind if you pronounce it My sequel or in some other localized way.
- Strengths and weaknesses of MySQL
- Creating a database
- Joining data sets
- Integrating Python with MySQL
- Searching a database
- CRUD operations
- Performing calculations