SQL for Social Science Data: Glossary

SQL (Structured Query Language) is used to extract data from the tables A schema for a table has to be created before data can be added The schema can be used to provide some data validation on input The DB Browser for SQLite application allows you to connect to an existing database or create a new database When connected to a database you can create new tables

SQL for Social Science Data: Glossary https://tess.elixir-europe.org/materials/sql-for-social-science-data-glossary SQL (Structured Query Language) is used to extract data from the tables A schema for a table has to be created before data can be added The schema can be used to provide some data validation on input The DB Browser for SQLite application allows you to connect to an existing database or create a new database When connected to a database you can create new tables