SQL for Ecology: Glossary

A relational database is made up of tables which are related to each other by shared keys. Different database management systems (DBMS) use slightly different vocabulary, but they are all based on the same ideas. It is useful to apply conventions when writing SQL queries to aid readability. Use logical connectors such as AND or OR to create more complex queries. Calculations using mathematical symbols can also be performed on SQL queries.

SQL for Ecology: Glossary https://tess.elixir-europe.org/materials/sql-for-ecology-glossary A relational database is made up of tables which are related to each other by shared keys. Different database management systems (DBMS) use slightly different vocabulary, but they are all based on the same ideas. It is useful to apply conventions when writing SQL queries to aid readability. Use logical connectors such as AND or OR to create more complex queries. Calculations using mathematical symbols can also be performed on SQL queries.