In this tutorial, we will step through installing PostgreSQL, connecting to the database, loading some data, and running a variety of SQL queries.

In Microsoft SQL Server, for example, a primary key usually equates to a clustered index. In SQLite, a primary key is usually just a unique index and is distinct from the special rowid column name.