Do you want to know how to develop your skillset to become a sysadmin Rockstar?

Subscribe to our newsletter to start Rocking right now!

To get you started we give you our best selling eBooks for FREE!

 

1. Introduction to NGINX

2. Apache HTTP Server Cookbook

3. VirtualBox Essentials

4. Nagios Monitoring Cookbook

5. Linux BASH Programming Cookbook

 

 

 

 

FREE SysAdmin books with the SCG Newsletter

scg-logo

Here at System Code Geeks we know how much you love books about system administration; we are geeks ourselves. After all, a geek that respects himself should always have his face in a book, he has to keep up with the latest technologies and developments. For this reason, we have decided to distribute 4 of our books for free. You ...

Read More »

Linux Find Large Files Example

bash-logo

Having our disk tidy and free of garbage occupies space is something we all want to do, but many times we don’t pay attention at large files that are taking up a considerable amount of space that could be useful for something else. In this example, we will see how to look for large files, just to be aware of ...

Read More »

PostgreSQL: Database Creation and Data Population

postgresql-logo

In the first tutorial of this series (PostgreSQL: Introduction and installation tutorial) we explained how to download a sample database and import it into our PostgreSQL server. This approach, although appropriate at the time, did not show how to create a database of our own from scratch – which is an essential skill that every database administrator (DBA) or developer ...

Read More »

PostgreSQL indexes example

postgresql-logo

In our previous article we discussed how to free up disk space by vacuuming tables with frequent updates and deletes. Under the hood, this procedure also helps to improve the performance of other CRUD operations performed on those tables. In this tutorial we will explain how to optimize SELECT queries with WHERE clauses using indexes in PostgreSQL tables. 1. Introducing ...

Read More »

PostgreSQL VACUUM Command Example

postgresql-logo

In the previous tutorials of this series (“PostgreSQL: Introduction and installation” and “PostgreSQL commands and datatypes”) we explained how to load a sample database (World_db) into our PostgreSQL server and how to get help with both SQL and psql commands. In real-world scenarios, you will need to perform CRUD (Create, Read, Update, and Delete) operations on database tables all the ...

Read More »

Linux Screen Command Tutorial

bash-logo

Screen is a window manager that allows to have several virtual terminals, several sessions and programs in text mode executing simultaneously in the same console. In this tutorial we will see how to use it. For this tutorial, Linux Mint 18 has been used. 1. Installation If you don’t have installed Screen, you can install it easily with apt-get: sudo ...

Read More »

System Code Geeks are giving away a FREE Sublime Text Editor License

scg-logo

Struggling with your heavy-weight editor? Then we have something especially for you! We are running a contest giving away a FREE license for the kick-ass Sublime Text Editor. Sublime Text is a sophisticated text editor for code, markup and prose. You’ll love the slick user interface, extraordinary features and amazing performance! Sublime Text is available for OS X, Windows and ...

Read More »

PostgreSQL commands and datatypes

postgresql-logo

In our previous post (PostgreSQL: Introduction and installation) we explained how to install and use a desktop and a web-based client to query a sample database we created and populated. We also introduced two basic commands to connect to a database (\c followed by the database name) and to quit (\q) the PostgreSQL prompt. PostgreSQL commands In this tutorial we ...

Read More »

Linux Create User Example

bash-logo

This example will show you how to create users in Linux, looking at the two different available commands: the default utility, useradd; and a script that acts as more friendly front-end for the default utility, which is named adduser. For this example, Linux Mint 17.03 has been used. 1. How users are organized The existing users of the system are ...

Read More »

PostgreSQL: Introduction and installation tutorial

postgresql-logo

With all the Relational Database Management Systems (RDBMs) out there, it may be somewhat difficult to identify the best solution for your needs and to take an informed decision as to which one to choose. Thus, in this series we will provide an introduction to PostgreSQL and share some of the reasons why you may want to consider this solution ...

Read More »

Linux Add User to Group Example

bash-logo

In this tutorial we will see how to add users to groups in Linux, looking at the different possibilities (existing or non-existing users), and taking into account also the different types of groups users can belong to (primary and secondary groups). For this example, Linux Mint 17.03 has been used. 1. How groups are organized Linux defines the groups in ...

Read More »

Want to take your sysadmin skills to the next level?

Grab our programming books for FREE!

Here are some of the eBooks you will get:

  • Linux BASH Programming Cookbook
  • NAGIOS Monitoring Cookbook
  • Introduction to NGINX
  • Apache HTTP Server Cookbook
  • VirtualBox Essentials