Coding truck

14 Posts

Sql select with multiple criteria 16 September, 2019

Previously we talked about the sql where clause and using it to filter selected data. In this post we will talk about how to specify…

Sorting results with the order by sql clause 11 September, 2019

In the past few posts we have learned about database tables, selecting data and the basic sql clauses. In this post we are going to learn…

Select, from, and where sql clauses 09 September, 2019

One thing that helps beginners to learn sql fast is to understand the structure of a statement. A sql select statement is made up of clauses…

Selecting data and the truth about clauses 04 September, 2019

Previously, we looked at tables and how they are made. Today, we will take a closer look at the select statement and how to query a table…

What is a code fiddle? 02 September, 2019

So you have some code that you want to try and and see if it works. Maybe you have a coding idea that you want to share with others? Maybe…

Tables are how databases store data 28 August, 2019

Tables are the secret sauce of relational databases, the databases that use sql. They are the basic building block of what is to come…

How to make a local git server with a Raspberry Pi 25 August, 2019

Ever had a git repository that you wanted to copy to a remote server? Github is a great choice. It has a great interface and it's free for…

Harden your Raspberry Pi Linux Server 23 August, 2019

A few days ago we looked at basic headless Raspberry Pi setup. A headless setup will allow the pi to exist in your house with only a single…

Make a Raspberry Pi Linux Server 19 August, 2019

A Raspberry Pi is a great little single board computer.  It is a little workhorse of a machine that fits in the palm of your hand. There are…

Querying xml columns with sql server 14 August, 2019

Today I learned about querying xml with sql using t-sql. This is the first time that I had run into this use case and found it interesting…

How to Eat an Elephant 12 August, 2019

There is an old joke that asks, "How do you eat an elephant?"  Learning to work with databases can sometimes feel like trying to eat an…

Yet Another 10x Developer Post 12 August, 2019

Forgive me if I am a little late to the party.  I am getting caught up on my podcasts.  A few times in the past week, I have heard a series…

What is a Database and Why Should You Care? 08 July, 2019

If you have never worked with a database before, you may be asking yourself, "What is all this database talk about?" It's a good question…

The Coding Truck Arrives! 05 July, 2019

Hello and welcome to the Coding Truck! My name is Jamal Hansen, I am a developer and data analyst who wants to share what I've learned and…