Relational databases use Structured Query Language (SQL) to manage and manipulate data. Tables can be linked using foreign keys, creating relationships between different types of data. For example, a table containing patient information can be linked to another table containing treatment details, allowing researchers to easily query and analyze relationships between treatment types and patient outcomes.