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 Parameters in Stored Procedures?
The Stored Procedures are an elegant way to store your code inside a SQL database. You can save your code and reuse it whenever you want to.
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.
Why is my SQL query taking so long?
This is one of the questions we almost always ask ourselves.
In this article, we are going to learn a bit about how to make an efficient query.