Cheat sheet: Databases
The 18 terms of this lesson, part by part, with the French word a team in France would use.
1. What a database is for
- Databasebase de données
- an organised store of data on a server, such as every message left in a guestbook.
- Recordenregistrement
- one item of data in a database, such as one customer or one order.
- Indexindex
- a sorted list that a database keeps on the side, like the index of a book, to find records without reading them all.
- Backupsauvegarde
- a copy of a site's data kept in a safe place, to recover it after a loss or an error.
2. Two ways to keep the same order
- Table databasebase de données relationnelle
- a database that keeps data in tables with fixed columns, linked to each other, such as PostgreSQL or MySQL.
- Document databasebase de données orientée documents
- a database that keeps each record as one document, whose fields can vary, such as MongoDB or Firestore.
- PostgreSQLPostgreSQL
- a free, open-source table database, the one developers use most, according to Stack Overflow's survey.
- MongoDBMongoDB
- the most common document database, first released in 2009.
3. A question in SQL, and two documents
- SQLSQL
- the language used to ask a table database for data, such as every product under €20.
- SQL queryrequête SQL
- a question sent to a database in SQL, such as "every product under €20, cheapest first".
- Fieldchamp
- one named piece of information in a record or a document, such as a price or a name.
4. What each kind is good at
- Transactiontransaction
- several changes to a database saved together or not at all, such as money leaving one account and arriving in another.
- Table databasebase de données relationnelle
- a database that keeps data in tables with fixed columns, linked to each other, such as PostgreSQL or MySQL.
- Document databasebase de données orientée documents
- a database that keeps each record as one document, whose fields can vary, such as MongoDB or Firestore.
5. What to ask
- Data exportexport des données
- a copy of your data that a service lets you download, so you can move it to another tool.
- CSVCSV
- a plain-text file of rows and columns, separated by commas, that spreadsheets and databases can read.
- GDPRRGPD
- the European law on personal data, which applies as soon as a site collects a name or an email.
- Backupsauvegarde
- a copy of a site's data kept in a safe place, to recover it after a loss or an error.
Web Technologies · Back ends · wt.thomasjuldo.com/course/back-ends/databases