First, you will learn how to query data from a single table using basic data selection techniques such as selecting columns, sorting result set, and filtering rows. The world is full of data. Every app that you use is full of data. On Khan Academy, we store data about users and badges and progress. On Bank of America, they store data about how much money you have.
And when I first started programming, I learned Ruby on Rails. We will also explore the. So Rails was my hammer. Over time, I started acquiring more tools for my tool belt. But for some reason, when it came to interacting with a database, I kept using the hammer.
To get started writing SQL, we need to first set up a server and a database. A table in a relational database is much like a table on paper: It consists of rows and columns. It has more than years of active development phase and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. You may well have heard the name and wondered what it is, how it works and whether you should learn it. This is both a brief tutorial and a quick reference for the absolute least you need to know about psql.
I assume you’re familiar with the command line and have a rough idea about what database administration tasks, but aren’t familiar with how to use psql to do the basics.
