Creating a View in PostgreSQL
January 20, 2023
A View is a way of protecting your SQL tables and formatting your table’s raw data into useful information that can be queried by your organization individuals.
Advanced SQLPostgreSQLSQL TutorialsCASE… WHEN… ELSE… END
November 12, 2022
Case… When.. Else… End maybe one of the most used SQL statements. Did you know you could use CASE with aggregate functions?
Advanced SQLSQL TutorialsTop 10 SQL tips for beginners
November 12, 2022
As a beginner, maybe you are having some problems using SQL, tutorial to learn a bit more about this beautiful language called SQL.
SQL TutorialsSQL tutorials for beginnersHow to install OracleDB on Docker
October 17, 2022
I come up with this problem yesterday, Oracle is potentiating their cloud solutions so they are not making it that easy to install their star product on a testing environment.
PL/SQLSQL tutorials for beginnersHow to use a QUALIFY clause in SQL?
October 7, 2022
Qualify may be one of the most underestimate commands in SQL, as a Data Analyst, I use it a lot and I really hope after this tutorial you use it too.
Advanced SQLPL/SQLSQL TutorialsTransact-SQLSQL vs NoSQL – What is the difference?
October 5, 2022
SQL and NoSQL have been in the market for a while now, but what are the real differences between each other? Why should we use one or the other?
Advanced SQLMiscellaneousNoSQLNoSQL TutorialsSQL IntegrationsHow to Install SQL Server: Quick Guide
October 1, 2022
Want to Start learning SQL Server and don’t know where to start? Come and learn how to Install your first SQL Server here!
SQL Installation manualSQL tutorials for beginners