MySQL TutorialLesson 1Free preview

MySQL HOME

This lesson is part of MySQL · All levels

Summary

MySQL is one of the most popular open source relational database management systems (RDBMS) in the world, and is the backbone of many popular web applications. To communicate with MySQL, we write SQL commands that are sent from a client (e.g. phpMyAdmin, MySQL Workbench, or terminal) to a MySQL server. This lesson is the gateway: understanding what MySQL is, how client-server works, and the basic structure of a database.

Key points

MySQL is an open source RDBMS that uses SQL to manage data.
MySQL works with a client-server architecture: multiple clients can connect to one MySQL server
Data is stored in a database, and each database contains one or more tables.
MySQL is known to be fast, stable, and a popular part of the LAMP/LEMP stack

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.