Recognition

Posts

178 Posts
  • Published Tutorial

    How To Install MySQL on Ubuntu 20.04

    MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It implements the relational model and uses SQL (Structured Query Langu...
    By Mark Drake, Hazel Virdó MySQL Databases Ubuntu 20.04 Ubuntu
  • Edited Tutorial in Series: How To Manage Data with MongoDB

    How To Design a Document Schema in MongoDB

    Document-oriented databases like MongoDB make it possible to break free from rigidity and limitations of the relational model. However, the flexibility and freedom from being able to store self-descriptive documents i...
    By Mateusz Papiernik MongoDB Conceptual Databases
  • Edited Tutorial in Series: How To Manage Data with MongoDB

    How To Use Transactions in MongoDB

    Though they were a staple feature of relational database management systems for many years, ACID transactions are a relatively new feature in MongoDB. This tutorial explains what transactions are and how you can initi...
    By Mateusz Papiernik MongoDB Databases NoSQL
  • Published Tutorial

    How To Use Cron to Automate Tasks on Ubuntu 18.04

    Cron is a time-based job scheduling daemon found in Unix-like operating systems, including Linux distributions. This guide provides an overview of how to schedule tasks using cron's special syntax on a machine running...
    By Mark Drake, Shaun Lewis Ubuntu 18.04 System Tools Automated Setups
  • Published Tutorial

    How To Install MySQL on Ubuntu 18.04

    MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It uses a relational database and SQL (Structured Query Language) to ma...
    By Mark Drake MySQL Databases Ubuntu Ubuntu 18.04
  • Published Tutorial

    How To Install and Secure phpMyAdmin on Ubuntu 18.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 18.04 server.
    By Brennen Bearnes, Mark Drake Applications PHP Apache Ubuntu 18.04 Ubuntu
  • Edited Tutorial in Series: How To Manage Data with MongoDB

    How To Use MongoDB Compass

    With MongoDB Compass, you can access most of the features the MongoDB database engine offers through an intuitive visual display. You can glance through the databases, collections, and individual documents, interactiv...
    By Mateusz Papiernik MongoDB Databases NoSQL Applications
  • Published Tutorial

    How To Install PostgreSQL on Ubuntu 20.04 [Quickstart]

    PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. This quickstart guide demonstrates how to install Postgres on an Ubuntu 20.04 server. I...
    By Mark Drake PostgreSQL Databases Ubuntu Ubuntu 20.04 Quickstart
  • Edited Tutorial in Series: How To Manage Data with MongoDB

    How To Use Aggregations in MongoDB

    MongoDB provides aggregation operations through aggregation pipelines — a sequential series of data processing operations through which the documents go to obtain the final result. In this tutorial, you'll learn by ex...
    By Mateusz Papiernik MongoDB Databases Data Analysis NoSQL
  • Published Tutorial

    How To Install Linux, Nginx, MySQL, PHP (LEMP stack) on Ubuntu 18.04

    This tutorial details the process for installing and configuring the components that constitute a LEMP stack on an Ubuntu 18.04 server, including Nginx, MySQL, and PHP. It also includes instructions for testing that t...
    By Justin Ellingwood, Mark Drake LEMP Databases Nginx MySQL PHP Ubuntu 18.04
  • Published Tutorial

    How To Enable SFTP Without Shell Access on Ubuntu 20.04

    In a standard configuration, the SSH server grants file transfer access and terminal shell access to all users with an account on the system. In this tutorial, we'll set up the SSH daemon to limit SFTP access to one d...
    By Mateusz Papiernik, Mark Drake, Jeanelle Horcasitas Miscellaneous Ubuntu Ubuntu 20.04
  • Published Tutorial

    How to Install and Configure VNC on Ubuntu 20.04

    Virtual Network Computing, or VNC, is a connection system that allows you to use your keyboard and mouse to interact with a graphical desktop environment on a remote server. In this guide, you'll set up a VNC server o...
    By finid, Mark Drake Miscellaneous Applications Ubuntu 20.04 Ubuntu
  • Published Tutorial

    How To Install and Secure Redis on Ubuntu 18.04

    Redis is an in-memory key-value store known for its flexibility, performance, and wide language support. This tutorial demonstrates how to install and configure Redis on an Ubuntu 18.04 server.
    By Justin Ellingwood, Mark Drake Redis NoSQL Ubuntu Ubuntu 18.04
  • Edited Tutorial in Series: How To Manage Data with MongoDB

    How To Use Indexes in MongoDB

    Indexes are one of the most essential tools the database administrator can use to consciously aid the database engine and improve its performance. In this tutorial, you'll learn what indexes are, how to create them an...
    By Mateusz Papiernik MongoDB Databases
  • Published Tutorial

    How To Set Up an OpenVPN Server on Ubuntu 18.04

    OpenVPN is a full-featured, open-source Secure Socket Layer (SSL) VPN solution that accommodates a wide range of configurations. In this tutorial, you will set up an OpenVPN server on an Ubuntu 18.04 server and then c...
    By Mark Drake VPN Security Ubuntu Ubuntu 18.04
  • Edited Tutorial in Series: How To Manage Data with MongoDB

    How To Create Queries in MongoDB

    MongoDB provides a robust query mechanism that makes it straightforward to define filtering criteria when retrieving documents. In this tutorial, you'll learn how to query MongoDB collections using a different range o...
    By Mateusz Papiernik MongoDB Databases
  • Edited Tutorial in Series: How To Code in JavaScript

    Understanding Variables, Scope, and Hoisting in JavaScript

    This tutorial covers what variables are, how to declare and name them, and also take a closer look at the difference between var, let, and const. It also goes over the effects of hoisting and the significance of globa...
    By Tania Rascia JavaScript Development
  • Edited Tutorial in Series: How To Manage Data with MongoDB

    How To Perform CRUD Operations in MongoDB

    Data management involves four fundamental types of database operations: operations that allow you to create, read, update, and delete data. Collectively, these operations are known as CRUD operations. This tutorial ou...
    By Mateusz Papiernik MongoDB Databases
  • Published Tutorial

    How To Install and Use PostgreSQL on Ubuntu 18.04

    This tutorial provides instructions on how to install the PostgreSQL database software on an Ubuntu 18.04 server. It also includes instructions for basic database management.
    By Justin Ellingwood, Mark Drake PostgreSQL Databases Ubuntu Ubuntu 18.04
  • Edited Tutorial in Series: How To Manage Data with MongoDB

    How To Use the MongoDB Shell

    The MongoDB shell is an interactive console you can use to connect to the database server and execute commands on it, allowing you to perform administrative tasks and read, write, or manipulate data directly. This tut...
    By Mateusz Papiernik MongoDB Databases