Recognition

Posts

148 Posts
  • Published Tutorial

    What is the Relational Model?

    The relational model is an abstract model used to organize data within a database. In order to control access to a database, write data, run queries, or perform any other tasks related to database management, a databa...
    By Mark Drake Databases Glossary SQL
  • Published Tutorial

    What is a Packet?

    Packets are the basic units of data transmitted through a TCP/IP network. Originally conceived as a way to transmit data without a pre-established connection, packets make dynamic data transference possible. Packet da...
    By Mark Drake Cloud Computing Networking Glossary
  • Published Tutorial

    What is a VPN?

    A VPN, short for virtual private network, is a means of establishing secure connections between remote computers. A VPN presents its connection as if it were a local private network, allowing for secure communications...
    By Mark Drake VPN Security Glossary
  • Published Tutorial

    What is Redis?

    Redis is an open-source key-value data store known for its flexibility, performance, and wide language support. An in-memory database, Redis is also known for its speed and has found wide use as a cache and message br...
    By Mark Drake Redis Databases Glossary
  • Published Tutorial

    What is MongoDB?

    MongoDB, also known as Mongo, is an open-source document database used in many modern web applications. It is classified as a NoSQL database because it does not rely on a traditional table-based relational database st...
    By Mark Drake Glossary MongoDB NoSQL Databases
  • Published Tutorial

    How To Use the BETWEEN and IN Operators in SQL

    In certain Structured Query Language (SQL) statements, WHERE clauses can be used to limit what rows the given operation will affect. SQL allows users to retrieve granular result sets by providing a variety of differen...
    By Mark Drake SQL Databases
  • Published Tutorial

    How To Use Comparison and IS NULL Operators in SQL

    In certain Structured Query Language (SQL) statements, WHERE clauses can be used to limit what rows the given operation will affect. SQL allows users to retrieve granular result sets by providing a variety of differen...
    By Mark Drake SQL Databases
  • Published Tutorial

    How To Use WHERE Clauses in SQL

    In Structured Query Language (SQL) statements, WHERE clauses limit what rows the given operation will affect. This guide will go over the general syntax used in WHERE clauses. It will also outline how to combine multi...
    By Mark Drake SQL Databases
  • Published Tutorial

    How To SELECT Rows FROM Tables in SQL

    One of the most fundamental parts of working with databases is the practice of retrieving information about the data held within them. In relational database management systems, any operation used to retrieve informat...
    By Mark Drake SQL Databases
  • Published Tutorial

    What is SQL?

    Structured Query Language — commonly known as SQL — is a language used to define, control, manipulate, and query data held in a relational database.
    By Mark Drake SQL Glossary
  • Published Tutorial

    What is NoSQL?

    NoSQL is a term generally used to describe any database management system that uses a data model other than the relational model.
    By Mark Drake NoSQL Glossary
  • Published Tutorial

    What is PostgreSQL?

    PostgreSQL, commonly referred to as "Postgres," is an open-source relational database management system. As with other relational databases, PostgreSQL stores data in tables made up of rows and columns and users can d...
    By Mark Drake PostgreSQL Glossary
  • Published Tutorial

    What is MySQL?

    MySQL is an open-source relational database management system. As with other relational databases, MySQL stores data in tables made up of rows and columns and users can define, manipulate, control, and query data usin...
    By Mark Drake MySQL Glossary
  • Published Tutorial

    How To Migrate a MySQL Database to PostgreSQL Using pgLoader

    The prospect of migrating a database can be intimidating, especially when migrating from one database management system to another. This tutorial provides instructions on how to install pgLoader, an open-source databa...
    By Mark Drake Databases PostgreSQL Open Source MySQL Ubuntu 18.04
  • Published Tutorial

    What is Platform as a Service (PaaS)?

    Platform as a Service (PaaS) is a category of cloud computing in which the underlying infrastructure (such as the operating system and other software) is installed, configured, and maintained by the provider, allowing...
    By Kathleen Juell, Mark Drake, Erin Glass Cloud Computing DigitalOcean App Platform Glossary
  • Published Tutorial

    How To Install MongoDB on Ubuntu 18.04

    MongoDB is an open-source document database used commonly in modern web applications. It is classified as a NoSQL database because it does not rely on a traditional table-based relational database structure. Instead,...
    By Mark Drake MongoDB NoSQL Databases Ubuntu Ubuntu 18.04
  • Published Tutorial

    How To Install and Secure phpMyAdmin on Ubuntu 20.04

    phpMyAdmin is an application that allows users to interact with MySQL databases through a web interface. This tutorial covers the process of installing and securing phpMyAdmin on an Ubuntu 20.04 server.
    By Mark Drake Apache Applications PHP Ubuntu Ubuntu 20.04
  • Published Tutorial

    How To Secure Apache with Let's Encrypt on Debian 10

    Let's Encrypt is a Certificate Authority (CA) that provides an easy way to obtain and install free TLS/SSL certificates, thereby enabling encrypted HTTPS on web servers. In this tutorial, you will use Certbot to obtai...
    By Kathleen Juell, Mark Drake, Erika Heidi Let's Encrypt Apache Security Debian 10
  • Published Tutorial in Series: How To Use SQL

    How To Use Joins in SQL

    Many database designs separate information into different tables based on how certain data points relate to one another. Even in cases like this, it's likely that there will be times when someone will want to retrieve...
    By Mark Drake Databases SQL
  • Published Tutorial in Series: How To Use SQL

    How To Update Data in SQL

    When working with a database, there may be times when you need to change data that's already been inserted into it; you may need to correct a misspelled entry, or perhaps you have information to add to an incomplete r...
    By Mark Drake SQL Databases