Creating a View in PostgreSQL
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.
CASE… WHEN… ELSE… END
Case… When.. Else… End maybe one of the most used SQL statements. Did you know you could use CASE with aggregate functions?
Top 10 SQL tips for beginners
As a beginner, maybe you are having some problems using SQL, tutorial to learn a bit more about this beautiful language called SQL.
How to install OracleDB on Docker
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.
How to use a QUALIFY clause in SQL?
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.
SQL vs NoSQL – What is the difference?
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?
How to Install SQL Server: Quick Guide
Want to Start learning SQL Server and don’t know where to start? Come and learn how to Install your first SQL Server here!