Data modelling - Technology
MySQL
A widely used database for storing and managing structured information
What's it for?
Stores structured application data in a widely used free database.
For example…
An online shop stores customer accounts, orders and payments in MySQL so the information can be linked and retrieved when needed
An ecommerce site queries MySQL to retrieve a customer's order history and update stock after checkout
Often confused with…
- SQL (Structured Query Language)A language used to ask for, organise and change information in many databases
- SQL Server (Microsoft SQL Server)Microsoft software for storing and managing structured business information
- NoSQLA broad group of databases that use structures other than traditional linked tables