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....
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....
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....
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....
In this short Postgres tutorial you鈥檒l learn the differences between choosing a view or stored procedure to save a SELECT query in PostgreSQL. ...
Materialized views in PostgreSQL differ from the regular ones as they do physically store the data in the database. ...
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. ...
Learn how you can use stored procedures to give a name to any of your SELECT queries and make them reusable. ...