How 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 Parameters in Stored Procedures?
October 15, 2022
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.
Advanced SQLPL/SQLSQL TutorialsTransact-SQLHow 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-SQLWhy is my SQL query taking so long?
October 4, 2022
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.
Advanced SQLMiscellaneousPL/SQLTransact-SQL