This course provides an introduction to the PostgreSQL relational database, one of the world's most powerful and popular databases. In this one-day course, you will gain both theoretical knowledge and hands-on experience in installing, configuring and using PostgreSQL for data management and analysis. We use the Microsoft Windows operating system for this course.

1. Introduction to PostgreSQL
Introduction to PostgreSQL and its benefits
Install and set up your environment
2. SQL Basics
Basic SQL terms and concepts
Working with databases, tables and records
Basic SQL commands (SELECT, INSERT, UPDATE, DELETE)
3. Data types and operations
Overview of PostgreSQL data types
Working with strings, numbers and dates
Using functions and operators