Skip to main content

Database Services

Unit: 7 Lesson: 2

IM NOT A BIG FAN OF SQL (30 on 30)

We love databases. It allows us to interact with and manage large groups of data easily. There are two types of databases: relational and NoSQL.

Relational Databases

Relational databases store information in tables with rows and columns, referred to as records and fields. Relationships between fields in different tables are managed using specialized key fields that uniquely identify each record. All (..?) relational databases are managed using SQL. SQL uses commands like SELECT and UPDATE for retrieving and editing data in databases.

Management Systems

SQL is the backend for many relational database management systems (RDBMS). These systems often come packaged with other management tools and a GUI to use and operate the database. Remote access protocols allow clients to connect to the database server over network, and allows replication traffic to move between synced database servers.

  • Oracle's SQL SQL*Net uses 1521/tcp

  • Microsoft SQL Server uses 1433/tcp

  • MySQL (and MariaDB) uses 3306/tcp

  • PostgreSQL uses 5432/tcp

  • [i] Most of these ports are insecure by default. However, all of them can be configured to use TLS encryption with the installation of a certificate without changing the port used.

NoSQL Databases

Literally any other database that doesn't use a record-field structure, like key-value pairs or wide columns. These databases don't usually come with a GUI, but are accessed using an API over HTTPS. Popular NoSQL database platforms include:

  • MongoDB
  • Amazon DynamoDB
  • CouchDB

#Netplus

Back to top