Kickstart 2020 with new opportunities! - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
1. Relational databases

Instruction

Welcome to our SQL Basics in PostgreSQL course. In this course, you will get to know how to talk to databases.

What is a database exactly? To put it simply, it's a computer program which stores various data. There are quite a few database vendors, e.g., Oracle, MySQL, SQL Server, and many others but we'll focus on the PostgreSQL database. Chances are some of these names already sound familiar to you – after all, databases can be found literally everywhere!

There are various types of databases. In this course, we're going to focus on relational databases – they're a very frequent choice in the contemporary IT world.

The chief advantages of PostgreSQL are:

  • It's open-source & free.
  • It had a lot of features before any other database, and it still can offer a lot more.
  • It has a plethora of extensions (such as PostGIS).

In the Code Editor you can see a query that does one thing: retrieves students' names and their graduation years but only for those who graduated in 2015. The result table is sorted by the birth year in descending order – it shows the youngest students first.

Don't worry if you don't understand the command yet; you'll learn how to write such commands yourself in this course.

Let's find out about how relational databases are organized.

Exercise

Click Next exercise to continue.