SQL Join Clause Learn how to use a SQL join clause to combine the contents of two or more tables in your select statements. We cover the most common joins - inner and left outer joins.
SQL Group By Clause Learn how to use a SQL group by clause to group the results of your select statements. You also learn how to use aggregate functions such as sum, count or average.
SQL Limit Clause Learn how to use a SQL limit clause to only return a certain number of rows from your select statements. Limit is used in PostgreSQL, but we discuss other databases as well.
SQL Order By Clause Learn how to use the SQL order by clause to sort the results of your SQL statements. We cover different sorting options including how to handle nulls.
SQL Where Clause Learn how to use the SQL where clause to filter the results of your SQL statements. We cover many of the operators with in depth examples.
Introduction to SQL Learn the basics of SQL (Structured Query Language) - the language of relational databases. Also, get an introduction to some basic select statements.
Ansible Bootstrap Playbook Learn how to write your first playbook with Ansible. This tutorial shows you how to bootstrap your server for future Ansible runs as well as adding some security.
Logrotate Learn how to manage your server's and application's log files with logrotate. We include a sample configuration you can use for your own application's logs.
Ansible Introduction Get an introduction to the server configuration, orchestration and deployment tool Ansible. Learn about Playbooks, Plays, Tasks, Modules, Handlers, Variables, Templates, Facts and Roles.
Secure Your Cookies How secure are the cookies you use for your web application? Learn how to better secure the cookies of your application. A specific example is shown using Ruby on Rails.
Basic PostgreSQL Backup and Restore Learn how to simply backup and restore a PostgreSQL database using SQL dumps. Learn different techniques and get shell scripts you can use to backup your database on a regular basis.
Set up HTTPS on Nginx Learn how to set up HTTPS on Ningx. This tutorial shows you how to generate a certificate request, prepare it for your server and configure Nginx to use it.
Ruby on Rails 4.1 Ubuntu 14.04 Server Deployment Learn how to deploy your Ruby on Rails 4.1 application to a Ubuntu 14.04 server. I show you how to deploy your application to the server we configured earlier using Capistrano 3.
Ruby on Rails 4.1 Ubuntu 14.04 Server Configuration Learn how to properly configure a Ubuntu 14.04 server to deploy a Ruby on Rails 4 application. I show you how to install and configure ruby using rbenv, a postgresql database, a nginx web server and a unicorn ruby application server.
Securely Setup Ubuntu 14.04 Server Learn how to securely setup a Ubuntu 14.04 server for application deployment. I cover patching the system, using public key authentication, using an account other than root, disabling root access and setting up a firewall
Ruby on Rails Development with Git and Github Learn how to setup your Ruby on Rails development environment to use git and github. This serves as a prerequisite to our server deployment series. We cover setting up your SSH keys, configuring your github account, and creating your git repository.
Setup a Rails 4.1 Development Environment on Ubuntu 14.04 Learn how to setup a Ruby on Rails development environment using Ubuntu 14.04. I walk you through the process and explain the steps along the way. I use Rails 4.1, rbenv, and postgres.
