sql Archives

SQL Select Tutorial

April 17, 2023February 22, 2023 by Đạt Trần

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

Setup PostgreSQL And pgAdmin

February 22, 2023 by Đạt Trần

Overview In this post, I will walk you through the setup of your environment and data so you can start quickly. As in the series introduction, I said that we will use PostgreSQL. The quickest way to set up a PostgreSQL database instance is by using docker-compose. Setting up PostgreSQL using docker-compose You can use … Read more