sql databases
Programs that hold records of information
Think "Spreadsheets"
Databases are concerned with:
1) Storage of data
2) Retrieval of data
3) Deletion of data
SQL
Structured Query Language
a programming standard for databases.
Create a user
CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass';
Users access databases; often represent real people or roles (large companies), many times a db has a single user (smaller companies).
Create a database
CREATE DATABASE my_blog;
Databases often represent applications. If your site is one application, it is often the name of the site.
Insert data
INSERT INTO <table> (<list of fields>) VALUES (<list of values>);
Retrieve data
SELECT <fields> FROM <table> [WHERE ...conditions];
Retrieving, like all database operations, is about efficiency.