Create Oracle Database Table and Specify Some Constraints
The following are the main constraints which can be defined when you are creating a TABLE. I will be using…
Websites to Learn and Practice SQL for Free
You can practise SQL live online for Free. Here are a list of some websites in no particular order. Oracle…
How To Track The Effectiveness of Email Campaign – Some Points to Consider
Sometimes, you would want to track the effectiveness of your email marketing campaign. How do you start ? What do…
Quick Example and Walk-Through JSON with Python
This is a quick to create a dictionary object , write it to a JSON file and then read back…
Using Subqueries To Join 2 More Tables Which Do Not Have Unique Primary and Foreign Keys
Using Subqueries to join 2 more tables which do not have distinct values in a column We want to find…
Rank a Place Visited By a Customer- Microsoft SQL Server – T-Transact
This is a short guide to getting ranking or rating from Microsoft Sql Server customers. Ranking is taken by checking…
Automatically Open Excel and Send Report Using Batch and VBA
We can use Visual Basic codes to automate some reports in Excel. Below are some simple codes to do…
Splitting Values in one Column to Multiple Columns using CASE Expression Statement SQL Server
Sometimes, you would want to split values in a column into separate rows in SQL server. This is a simple…
Decision Tree Price Optimisation – Regression Tree
Price Optimisation can be achieved in several ways. I did a simple analysis of how you can use Decision Tree…