How to Create Database Tables with SQL

We have already learned what SQL is and how we can use basic select statements to get information out of our database. We can use that information we’ve selected to draw insights from potentially complicated databases. In this article, we’re going to learn how to create database tables with SQL. Remember that tables are basically Read More >

How to Write Select Statements

The Select statement is a very simple but important part of SQL. At this point, if you read the What is SQL? article, I presume you have a bunch of test data to work with. The important thing about data is not always the data itself but what insights you can draw from the data. Read More >

What is SQL?

In this series, we are going to going through some of the basics of using SQL. No prior experience with SQL is required. This will not be an extensive course. The history of SQL is outside of the scope of this series. However, we will touch briefly upon how SQL is used and for what Read More >

Org2Blog – Post to WordPress from Emacs

Org2Blog provides a way of synchronizing your Org mode document with a WordPress post or page. Org2Blog Requirements Installation Set Up Your Website Media Management More Resources On Managing WordPress Here are the top benefits of using Org2Blog: Post and update WordPress content from within Emacs Manage content locally Speed up your workflow Optimize content Read More >

How to Edit Your Jekyll Theme

We have already seen in our Jekyll series, how you can change your default theme using RubyGems. However, instead of changing your whole theme, you can also edit the theme you have and creat new layouts based on your own design. In this article, we’re going to show you how to edit your Jekyll theme. Read More >

How to Change Your Jekyll Theme with RubyGems

Continuing in our Jekyll series, we have already learned how to create a Jekyll site. And you will have noticed that the Jekyll site comes with a default theme. In this article, we’re going to show you how to change your Jekyll theme from the default to a theme of your choosing. In order for Read More >

How to Point a Subdomain to GitHub Pages

You may recall, in a previous article, we explained how you can <a href=”/support/website/git/how-to-use-a-custom-domain-with-github-pages/”>point a domain to GitHub</a> to host a static site. In this article, we’re going to show you how you can do the same thing but for a subdomain. </p> <p> There are many reasons why you might want to use a Read More >

How to Publish Your Jekyll Site with SCP

In this article, we’ll show you how you can automate your publishing process with secure copy (SCP). In the <a href=”/support/website/jekyll/how-to-customize-your-jekyll-site/”>customizing Jekyll</a> article we learned about how you can change the base directory of your site. This means you will be building your site into a specific directory, which is going to be important later. Read More >

How to Publish a Jekyll Site with Git

In this article, we’re going to show one way (among many) to automate the publishing process for a Jekyll site. This is an advanced article and requires referencing of other information. Where appropriate, links to supporting material have been provided. </p> <p> Before proceeding with this article, it is highly recommended that you familiarize yourself Read More >

How to Publish Your Jekyll Site

In this article, we’ll show you how to publish your Jekyll site. There are many different ways to do this. The process can even be automated (and we’ll show how to do that later). Automating the publishing process is a popular option because otherwise you will be manually uploading files to your site every time Read More >

How to Customize Your Jekyll Site

Your site is unique. So you will need a place where you can edit the Jekyll example content. (You’ll remember we created a Jekyll site in the previous article.) Jekyll puts these options into a configuration file called _config.yml. Using this “config” file, this article will show you how to customize your Jekyll site. Where Read More >

How to Create a Jekyll Site

In this tutorial: How to Create a Jekyll Site How to Add Posts to Your Jekyll Blog How to Add Pages to the Jekyll Site Reviewing our Jekyll series, we have already learned what Jekyll is and why you might want to use it for your site. We’ve also learned how to install Jekyll. Make Read More >

How to Install Redis on Your VPS/Dedicated Server

You may have already heard about Redis databases. Likewise, you may have noticed that many websites use Redis as an object cache to serve pages faster. In this article, we’ll show you how to install Redis on your VPS or Dedicated server. How To Install Redis Add EPEL repository, if needed: yum -y install epel-release Read More >

How to Use a Custom Domain with GitHub Pages

In our previous GitHub Pages article, we showed you how you can create a static site and host it in your GitHub repository. This is a simple option for creating a site—with considerable limitations. Your GitHub Pages site will have its own URL based on your username and the name of the repository. However, you Read More >

How to Host a Static Site with GitHub Pages

In this article we’ll show you how you can easily host a basic website on your GitHub account using GitHub Pages. This can be valuable if you require an offsite resource to redirect visitors to in case of emergency hosting situations. For example, if you are undergoing maintenance or switching servers, you will be able Read More >

Installing the Agile CRM Plugin

CRM stands for Customer Relationship Management. And it’s something you may want to learn about now that you have an e-commerce business. There are many different CRM platforms available. Be sure to check out our WooCommerce Education Channel for full guides on using WooCommerce to create an online business. CRM applications on the market today Read More >

How to Get Support from WordPress.org

Throughout our WordPress Education Channel, you have likely found references to plugins and themes. And you must already know that using plugins will get you more value out of your WordPress site. But sometimes plugins break, and themes don’t always work as you might have expected. In this article, we’ll show you exactly how you Read More >

How to Add SSH Keys to Your GitHub Account

In this tutorial: Why use an SSH key? How to Create an SSH Key Adding an SSH Key to Your GitHub Account GitHub offers a convenient SSH key feature for accessing your repositories on the command line. Instead of using usernames and passwords every time you push to or pull from your repository, you can Read More >

Using Your GitHub Account

In this article, we’re going to cover some of the basic functions and settings you have in your GitHub account. Using your GitHub account properly may mean different things for different users. In this article we’re going to cover the following: Log into your account Access your settings Delete your account After reading this article Read More >