From the course: CMS Essential Training
Unlock this course with a free trial
Join today to access over 22,400 courses taught by industry experts.
What is MySQL?
Earlier when we discussed the LAMP stack, I mentioned MySQL as an important part of the open-source software stack used to power most open-source content management systems. At the time, I mentioned how MySQL helps us create and manage relational databases. Let's take a closer look at databases and their role in content management systems and then discuss why MySQL is such a popular means of managing those databases. A database is little more than a collection of data and can usually be represented as a table. Relational databases, like those created by MySQL, store data in multiple tables that have the ability to relate to each other in some way, usually by sharing data keys or properties. In the case of content management systems, using relational databases allows them to easily store and organize content in an efficient way while linking that content together. This makes it simple to find all the articles written by a particular author or all articles written about a specific…
Contents
-
-
-
-
-
What is an open source CMS?3m 4s
-
What is a LAMP stack?2m 53s
-
What are WebDAV and FTP?2m 39s
-
What is MySQL?2m 24s
-
WYSIWYG editors3m 56s
-
Understanding users, groups, and permissions4m 12s
-
What is metadata?5m 19s
-
Understanding taxonomy3m 35s
-
What is version control?4m 23s
-
What are themes and templates?3m 30s
-
What is SEO?4m 42s
-
What are web analytics?3m 21s
-
-
-