Learn PostgreSQL with a comprehensive learning path designed for beginners. These PostgreSQL courses provide a structured roadmap to master the powerful, open-source relational database system. Progress through topics like fundamental SQL, database design, and administration. Gain practical, real-world experience through hands-on, non-video tutorials and interactive exercises in a dedicated SQL playground focused on database management and querying.
Learn to create a new PostgreSQL database from scratch.
Understand how to connect to a PostgreSQL database.
Set up a new user account in PostgreSQL for database access.
Give a PostgreSQL user permission to read data from a table.
Allow a PostgreSQL user to modify data in a table.
Remove a specific privilege from a PostgreSQL user account.
Build a simple table in PostgreSQL to store data.
Add an integer column to a PostgreSQL table for whole numbers.
Add a text column to a PostgreSQL table for string data.
Add a date column to a PostgreSQL table for storing dates.
Define a primary key in a PostgreSQL table for unique row identification.
Add a single row of data to a PostgreSQL table.
Add several rows of data to a PostgreSQL table at once.
Retrieve all rows from a PostgreSQL table.
Fetch rows from a PostgreSQL table using a WHERE condition.
Order PostgreSQL query results based on a column.
Modify data in a single row of a PostgreSQL table.
Remove a single row from a PostgreSQL table.
Expand a PostgreSQL table by adding a new column.
Build a simple index in PostgreSQL to speed up data retrieval.
Delete an existing index from a PostgreSQL table.
Create a basic view in PostgreSQL based on a query.
Remove an existing view from a PostgreSQL database.
Write a simple function in PostgreSQL for reusable logic.
Execute a stored PostgreSQL function to process data.
View the current status of a PostgreSQL database.
Retrieve the version of the PostgreSQL server.
Delete an entire PostgreSQL database and its contents.