Đạt Trần
Introduction to Python Welcome to Day 1 of our Python curriculum! In this lesson, we’ll introduce you to the Python programming language and get you started with writing your first program. Installing Python Before we can start programming in Python, we need to install it on our computer. You can download the latest version of … Read more
Overview Using aliases saves you time and helps you avoid typos. On my daily work as a developer, I have to issue git commands many times. Thanks to aliases, I can avoid many mistakes when typing commands. On Linux/Mac, it is super easy to create aliases with your bashrc/zhsrc file. However, you need extra work … Read more
Overview Subquery is a powerful SQL tool. It enables users to do things that are not possible using common statements. Here are some common use cases of subqueries: In this post, I will show you how to use subqueries to get the data you need from your tables. Let’s get started. A Simple (and useless) … Read more
Overview As a web developer, you need to interact with APIs/URLs all day. There are many ways you can interact with such resources and get the job done. However, knowing how to CURL can boots your productivity to another level. In this post, I’m going to show you the most useful CURL commands you can … Read more
Overview Now you have your data populated (if you haven’t, please go back to the previous post) to complete the setup. In this post, I’m going to show you various way to query your data using the SELECT command. When using in combination with other clauses (such as WHERE, LIMIT), you can get exactly what … Read more
Introduction PostgreSQL provides a variety of built-in aggregation functions that allow you to calculate values such as count, sum, average, minimum, and maximum values for a set of rows. In this post, I’m going to walk you through the basic to advance aggregation functions. Let’s get started Basic Aggregation Functions You can use aggregation functions … Read more