How to Install and Configure Jupyter Notebook

Reading Time: 4 minutes

What is Jupyter Notebook?

Jupyter Notebook is an extremely powerful open-source, web-based tool that facilitates the creation of documentation. There are many different avenues to provide technical documentation or demonstrations, but Jupyter Notebook makes it possible to embed visualizations and execute live code. It is useful to be able to utilize documentation to describe development concepts or planning, but providing working examples within documentation can be a more effective way of conveying information. This tutorial will cover how to install Jupyter Notebook on an Ubuntu 18.04 LTS server and connect to it remotely via an SSH tunnel.

Continue reading “How to Install and Configure Jupyter Notebook”

Inserting Fields into Database Tables with PhpMyAdmin

Reading Time: 2 minutes

When working on a database, we sometimes find that additional data should be added for each record, but will not fit into any of the existing fields or structures. Adding a new column into an existing database can help with this problem, and it is very easy to accomplish with PhpMyAdmin.

This guide assumes that you have already logged in to PhpMyAdmin as the root user. Next, we will go over how to copy a table, and then review a few of the options PhpMyAdmin provides.

Continue reading “Inserting Fields into Database Tables with PhpMyAdmin”

Deleting Tables from a Database with PhpMyAdmin

Reading Time: 2 minutes

Managing databases and tables from within PhpMyAdmin is usually very straightforward. This guide will demonstrate how to remove columns and tables from a database using PhpMyAdmin.

We must first state that the potential for unintentional data removal can be elevated when working with any database. Before proceeding, it is highly recommended taking a backup before manipulating any data. Also, prior to amending data, we should confirm is not being used in a live environment.

Continue reading “Deleting Tables from a Database with PhpMyAdmin”

How to Install Python on Ubuntu 18.04

Reading Time: 3 minutes

Python is fast becoming one of the most popular programming languages worldwide. Its low entry barrier for new programmers and simple, elegant syntax makes it a fantastic language to start learning. Python is excellent for task automation, and thankfully most Linux distributions come with Python installed right out of the box. This is true of Ubuntu 18.04; however, the Python package distributed with Ubuntu 18.04 is version 3.6.8. This article will cover how to install a newer version of Python, specifically, the latest stable version 3.8.3.

Continue reading “How to Install Python on Ubuntu 18.04”

Modifying Fields in Database Tables with PhpMyAdmin

Reading Time: 2 minutes

The structure of a field inside a database table can be easily modified! There are a number of reasons why a column would need to be altered. For example, if the existing values needed to be modified to updated data, if a restructuring of tables were needed, or even to help with optimization. PhpMyAdmin makes modifying fields in database tables very straightforward to accomplish.

Continue reading “Modifying Fields in Database Tables with PhpMyAdmin”

Renaming Database Tables with PhpMyAdmin

Reading Time: 2 minutes

Renaming a table within a database is a task that may need to be done occasionally. You might just need to rename it for clarification purposes, to archive old data, to make a copy when a restore is being done, or any number of other reasons. PhpMyAdmin helps you rename a database quickly with just a few clicks.

Continue reading “Renaming Database Tables with PhpMyAdmin”

Exporting Databases and Tables with PhpMyAdmin

Reading Time: 3 minutes

Using PhpMyAdmin to export a database or table is a great way to make a backup you can save locally, or it can help you with transferring that information to another server quickly. A few simple steps can be a powerful tool to help you and your business. We will go over exporting all databases at once, a single database, and exporting a single table. This guide assumes that you have already logged in to PhpMyAdmin.

Continue reading “Exporting Databases and Tables with PhpMyAdmin”

Importing Databases and Tables with PhpMyAdmin

Reading Time: 4 minutes

Using PhpMyAdmin to import databases can help us in a few different situations, like when moving a database from one server to another, updating a table that is being developed elsewhere, or even restoring content from a backup. PhpMyAdmin helps make all those processes easy to accomplish through our browser.

This guide assumes that you have already logged in to PhpMyAdmin. We will go over what happens if we try to import into an existing database, importing a single table, and also partially restoring from a full database backup.

Continue reading “Importing Databases and Tables with PhpMyAdmin”

Searching Through a Database with PhpMyAdmin

Reading Time: 3 minutes

Using PhpMyAdmin to search for records and information in your database can quickly help you get the information you need without having to run advanced search queries. This tutorial assumes you have already logged in to PhpMyAdmin, and shows how to search by keyword and for a range of records.

Continue reading “Searching Through a Database with PhpMyAdmin”

Running SQL Queries on a Database with PhpMyAdmin

Reading Time: 2 minutes

In this tutorial, we will explore how to run SQL queries on a database within PhpMyAdmin. SQL stands for Structured Query Language. SQL statements or queries are used to perform database tasks such as searching, updating, or retrieving data from a database.

Continue reading “Running SQL Queries on a Database with PhpMyAdmin”