/tag/database

  • Introduction to Databases

    There are two main families of databases: Relational and NoSQL. Relational databases store information in an orderly, column, row, and table schema. They “relate” the tables together to present different views of the data. NoSQL databases are much less structured. This means they can store different data alongside each other – which makes things both easier to store but harder to query across. Relational Databases (RDBMS) Most users have at least heard of relational databases like: MySQL / MariaDB PostgreSQL Microsoft SQL Server Oracle Relational databases operate on the concepts of tables, relations, indexes, SQL, CRUD operations, and joins.