Master PostgreSQL, the powerful and open-source relational database management system trusted by developers worldwide! Our tutorials dive deep into everything you need to know about PostgreSQL, from installation and setup to advanced query optimization and database performance tuning. Learn how to efficiently manage large datasets, leverage ACID compliance for reliable transactions, and implement complex SQL queries with ease.
Introduction In this tutorial, we want to delete specific rows from a table by using a SQL Statement. In order to do this, we use the DELETE Statement. We have already created the table student with the following data: Example 1 We want to delete all rows where the name...
Introduction In this tutorial, we want to update the data in a table by using a SQL Statement. In order to do this, we use the UPDATE Statement. We have already created the table student with the following data: Example 1 We want to update the student with the name...
Introduction In this tutorial, we want to delete all rows from a table by using a SQL Statement. The table itself should remain. In order to do this, we use the TRUNCATE Statement. We have already created the table student with the following data: SQL Statement Now, let's...
Introduction In this tutorial, we want to insert new rows into a table by using a SQL Statement. In order to do this, we use the INSERT Statement. We have already created the table student. As you can see, the table is empty. SQL Statement Now, let's insert...
Introduction In this tutorial, we want to modify an existing table by using a SQL Statement. In order to do this, we use the ALTER TABLE Statement. We have already created a table called student. The table has the following columns: Example 1 - ADD COLUMN We want to add...
Introduction In this tutorial, we want to create a table by using a SQL Statement. In order to do this, we use the CREATE TABLE Statement. We have already created a server called DLNerdsServer and a database called dlnerdsacademy. Now, we want to create a table called student. SQL Statement...
Introduction In this tutorial, we want to delete an existing database by using a SQL Statement. In order to do this, we use the DROP DATABASE Statement. We have already created a server called DLNerdsServer and a database called dlnerdsacademy. Now, we want to delete the database dlnerdsacademy. SQL Statement...
Introduction In this tutorial, we want to create a database by using a SQL Statement. In order to do this, we use the CREATE DATABASE Statement. We have already created a server called DLNerdsServer. The database should be called dlnerdsacademy. SQL Statement We navigate to the default database of the...
Introduction In this turorial, you will learn how to create a database with the pgAdmin interface. Create Database We have already created a server called DLNerdsServer. In order to create a database, we right-click on the databases node and select Create>Database. Set properties Now, we can set certain...