November 26, 2016
No Comments
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
November 26, 2016
No Comments
Data Warehousing
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
November 23, 2016
No Comments
November 20, 2016
No Comments
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
November 16, 2016
No Comments
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
November 13, 2016
No Comments
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
November 12, 2016
No Comments
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
November 9, 2016
No Comments
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
November 6, 2016
No Comments
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
November 3, 2016
No Comments
DataPandas LTS
An experienced DevOps and Cloud Training Company to meet your DevOps and Cloud needs