Financial Dashboard With Oracle Visualization Desktop
Oracle Analytics Cloud (OAC) is a single cloud-based platform for data preparation, in-depth...
How to Create a Table with Multiple Foreign Keys and Not Get Confused
Understanding Table Relations SQL server adds foreign keys to implement relations between tables in a relational database. A table can have...
How to Create Data Flow in Oracle Analytics
The traditional approach to the transformation process (Extract, Load, Transform) requires that technical users get involved directly. They...
Advanced Analytics with Oracle Data Analytics – Handling with Express Builder Functionality
This article completes the series of posts dedicated to Advanced Analytics with Oracle Data...
SQL Server Replication Monitor: Scripts for Checking Replication Status
Replication is one of the oldest technologies on MS SQL Server, loved by every database administrator. It is a great and reliable...
How to Check Status Of SQL Agent Jobs using PowerShell Tool
From a certain point in my career, I started to play around with PowerShell. But I never imagined that it would become such an essential...
How to Get Backup Status in SQL Server using Stored Procedure
Any SQL Server DBA (of course, this applies to all platforms) will agree that database backups are...
How to Delete Entire MySQL Database
In some cases, we need to drop the entire database from the MySQL community server. This is simple but irreversible. Thus, the DROP...
Easy Answers to 5 Vital Questions about Composite Index in SQL
Imagine you need to query a table with a WHERE clause on columns a, b, and c. Sometimes, you filter the results with columns a and b only....
The Cartesian Product in SQL
Cartesian product in SQL is a term from the set theory of mathematics. However, we can also find...