CRUD Operations in Depth in PostgreSQL

You have made it here so far. You are much familiar with databases and SQL. By now, you should be able to: Create new databases Create roles and users Know everything about SQL data types Create tables, set constraints and relationships among them You have come a long way indeed, but you still have more things to learn to use and harness the power of SQL fully....

September 17, 2021 路 10 min 路 Coderslang Master

Databases, Roles, and Tables in PostgreSQL

In the last tutorial, you installed PostgreSQL and prepared all the tools needed for SQL development. Also, you learned some fundamentals such as meta-commands, created your first database, your first table, and wrote your first SQL statements to perform CRUD operations....

September 16, 2021 路 13 min 路 Coderslang Master

Setting Up and Getting Started with PostgreSQL

Last time I鈥檝e introduced you to the fundamentals of relational databases and SQL . Now it鈥檚 time for you to set up the working environment you need to follow along with this series....

September 15, 2021 路 13 min 路 Coderslang Master

Introduction to relational databases and SQL

In our modern world, databases are ubiquitous. If you want to write any piece of software that creates and stores information for future use, using a database system is necessary. Also, if you get into any software development role, you are likely expected to be familiar with databases....

September 14, 2021 路 6 min 路 Coderslang Master

PostgreSQL, views vs stored procedures

In this short Postgres tutorial you鈥檒l learn the differences between choosing a view or stored procedure to save a SELECT query in PostgreSQL. ...

November 17, 2020 路 1 min 路 Coderslang Master

The difference between regular views and materialized views in PostgreSQL

Materialized views in PostgreSQL differ from the regular ones as they do physically store the data in the database. ...

November 16, 2020 路 1 min 路 Coderslang Master

How to create a VIEW in PostgreSQL

In PostgreSQL, view is a virtual table. It represents the result of a SELECT query and can be used to quickly get access to data without having to execute the full query. ...

November 13, 2020 路 2 min 路 Coderslang Master

How to save a SELECT query in PostgreSQL

Learn how you can use stored procedures to give a name to any of your SELECT queries and make them reusable. ...

November 8, 2020 路 4 min 路 Coderslang Master